Our Accounts Payable Template is an Excel spreadsheet that is an effective way for the bookkeeper to track how much your business owes to vendors and suppliers and when those payments are due. All kinds of free accounting templates can be found online, such as those for the balance sheet, receivable template, billing statement template, expense report template, accounting journal template, and income statement. This feature can be found on accounting software as well.
As business purchases are made every day, trying to juggle paying bills with the business’s cash flows can be a challenge. Having an Accounts Payable spreadsheet will give you a snapshot of the number of invoices, who you owe, due dates, the invoice amount, and the ability to prioritize which bills should be paid.
Download The Accounts Payable Template
Click to download the spreadsheet and save it on your computer. The spreadsheet is unlocked so you can customize it to use the best practices to best meet small businesses’ needs.
Using The Spreadsheet
We prefilled some records to show how the spreadsheet works as an example for you to look at.
The first section allows you to enter company details such as the business name.
Next is a field that calculates the current date. This is used to determine the number of days payment is overdue.
The next columns include fields for bill details. When you receive an invoice from a supplier or vendor, enter the details in these cells. Be sure to not type in the light blue fields as those hold formulas to do various calculations. Cells are provided for the invoice date, invoice number, supplier name, payment terms, and the total amount owed.
The fields in the light blue section calculate the due date, balance due, and the number of days overdue if the bill is late. If the bill isn’t yet due, nothing will show in those cells.
Further to the right, there are cells to enter the payments that have been made. Ten cells are provided, but you could easily add more if needed.
At the bottom of the sheet, all the outstanding balances to vendors are calculated to give you a quick view of how much is due.
Before closing the spreadsheet, be sure to save the file to keep it up to date. We hope this Accounts Payable template helps better organize the bills your business has to pay.