Buy Now

Accounts Payable

Excel Template

Organize your invoices and payment dates with our Accounts Payable Excel Template. Improve your accounting workflow with smart ledgers, pre-formulated cells and dynamic reports. 
 
Buy Now

What's Inside the Accounts Payable Template?

Details | 5 SheetsĀ 

Supported VersionsĀ | Excel Office 365 (Mac)

Category | Accounting, Small Business

TagsĀ |Ā Accounting, Ledger, Invoices

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now
World-Class Excel University

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog
How-To Videos

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Accounts Payable Excel Template

 

Excel is one of the top programs to know if you work in accounting.

Log invoices, the amount and balance into your spreadsheet

Accounts Payable is an account within the general ledger that represents a debt to a creditor or supplier. Rather than use any of the 68 accounting softwares that charge you on a monthly basis, Excel is a more than capable tool for automating your accounting workflow and accounts payable.

If you like our Accounts Payable Excel Template, you’ll also want to check out our Accounts ReceivableInvoicingPayroll and Loan Amortization Schedule. All of these templates at your fingertips will empower you to understand interest payments, invoicing and the general ledger of your company.

Start off in the Lists sheet and edit, add or delete items from the Expense Categories table. Sample data includes Administrative, Cost of Goods, Operating Expenses and Miscellaneous.

Navigate to the Enter Invoices sheet and input your data in fields such as Invoice Data, Invoice #, Vendor/Supplier, Expense Category, Notes/Description, Due Date and Amount Due.

In the Record Payments Made sheet, input data into the fields with white columns such as Invoice Number (select the invoice of record in the dropdown menu), Amount Paid and the Payment Date.

 

Record payments made in this sheet
Scheduled payments will automatically populate in this sheet

Once you’ve filled in those sheets, the Scheduled Payments and At a Glance sheets will auto populate like magic (and by magic we mean formulas). The Scheduled Payments sheet will list all your invoices from earliest to latest due date, although you can easily organize by any of the variables available. Once they’ve been marked as paid they’ll be crossed off automatically.

Grey cells in our templates typically indicate those fields will pre-populate based on data from other sheets so no need to edit the other four columns which will automatically calculate.

 

 

Move to the At a Glance sheet and you’ll see your payments organized by when the payment is due. They’re color-coordinated so the most urgent, like Overdue, stand out. Other columns will also include payments Due Today, Due in 1-7 Days, Due in 7-14 Days, and Coming Up Later This Month.

With our Accounts Payable and Accounts Receivable Excel Templates, you’ll have no problem organizing your accounting processes.

 

The At a Glance sheet of our Accounts Payable Excel Template displays what invoices are overdue, due in seven days, as well as other payment timelines.

More Accounting Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW