Free Excel Accounts Payable Template

Download our free Excel accounts payable template to record supplier invoices, track outstanding bills, and stay on top of your business’s payments.

Written by

Angela Boxwell, MAAT

Experience

30+ years’ experience

Last updated

19th October 2026

To streamline your accounts payable process, download our free, simple-to-use Accounts Payable template in Excel at the bottom of this page. If you don’t have Microsoft Excel, Google Sheets is a free alternative compatible with our template.

Do you struggle to know when to pay your supplier invoices? As a business, one of the last things you want is to upset suppliers by not paying invoices on time. It may cause problems when you seek credit in the future.

The easiest way to generate an accounts payable list is to use accounting software. Although most packages have a monthly cost, they will save you time.

Disclosure: This content may contain affiliate links, which means if you click on them, I may get a commission (without any extra cost to you).

Accounting Software Best Deals

Xero logo

XERO – 90% Discount for 6 Months – Cloud accounting, unlimited users, bank feeds, MTD compatible

QuickBooks logo

QuickBooks – 90% off for 7 Months – Sole traders, easy to use, MTD-compatible

tide logo

Tide – Free with Tide Bank Account – All your banking and accounts in one place, MTD compatible

Using our template, you can help ensure that bills are settled on time. If you have a dispute, you can add notes in the comments field. You can sort the data by supplier or date to make it easier to find the information you need.

Accounts Payable Template

What is the Accounts Payable Ledger?

The accounts payable ledger (AP) records the short-term debts your business owes to suppliers and service providers. It’s a key part of your day-to-day bookkeeping and essential for managing cash flow. Tracking what you owe—and paying it on time—helps you build trust with vendors and avoid unnecessary late fees.

Using an accounts payable template can simplify this process by giving you a structured way to record, track, and manage outstanding invoices. Whether you’re just getting started or want to streamline your bookkeeping, a reliable AP template helps ensure nothing falls through the cracks.

How to Use the Accounts Payable Template

  • Download the accounts payable spreadsheet using the link at the bottom of this page.
  • Save it either to the hard disk or cloud software.
  • Enable editing in Excel.
  • At the top, please enter your business name where it says’ Enter Company Name Here’.
  • You are now ready to start entering the details from the purchase invoices.
  • Enter the supplier name, date, invoice number and amount. If there is no invoice number, you can leave it blank.
  • Use the drop-down list to select the payment terms; the due date will be automatically entered based on this information.
  • The spreadsheet will automatically enter the figure into the correct column and indicate whether the invoice is current or overdue.
  • The comments section helps if you have a query about a purchase invoice, as you can add notes. You may be waiting for a credit note because the order was incomplete, or, for larger companies, the invoice may be sent to a manager for approval.

When all the data is entered, you may find it helpful to sort the data by the supplier, invoice date, or due date. It will help you see how much you owe to one supplier and the order in which invoices are due.

Sorting Accounts Payable Template Data

  • Highlight the rows that you want to sort
  • Using the Excel ribbon at the top, select Data > Sort > Use the drop-down list to choose which column you want to sort it by and the order to sort it.
  • Click OK

The data will be sorted in the format requested.

Accounts Payable Sorting Data

Purchase Invoices Sorted Data

Removing Paid Invoices

You will need to clear the contents of the row rather than delete it. This will ensure you keep the same number of rows in the spreadsheet.

  • Highlight the customer, invoice date, invoice number and amount.
  • Use the mouse to right-click
  • Select clear contents

You may then wish to sort the data to remove the cleared line.

Year-end Accounts Payable

Printing or saving a copy of the report at year-end, as part of your management reports, is helpful. To save a copy, select “Save As” and use a different name. You can then continue using the original spreadsheet to start the next financial year.

Alternatives to Accounts Payable Templates

QuickBooks Accounting software banner

While Excel templates can be a simple and accessible starting point for managing accounts payable, they have limitations as your business grows. Manual data entry and tracking increase the risk of errors and can become time-consuming. In contrast, accounting software offers a more efficient, accurate, and scalable solution. It automates many parts of the accounts payable process, including invoice matching, due date reminders, and payment tracking, helping you save time and reduce costly errors.

 

Advantages of Using Accounting Software for Accounts Payable Ledger

There are many advantages for a small business to use software for its accounts payable process, including:

  • Adding bills using an upload feature
  • Sharing information with the accountants and accounts payable department
  • Other reports available
  • Printing remittance advice and emailing it to the supplier
  • Some allow for payment processing within the software
  • Easier to keep track of when payments are due
Xero 90 Banner

Excel Bookkeeping Templates.

We have created other useful, free Excel templates to help with your bookkeeping. These include detailed templates for Accounts Receivable, designed to help you track outstanding sales invoices; a comprehensive Cash Book for recording all bank transactions; a Petty Cash template for managing small, everyday expenses; and a Budget template to assist in planning your finances over various periods.

Each template is designed with the user in mind, ensuring ease of use and efficient management of financial tasks.

Can I use this accounts payable template in Google Sheets?

Yes, you can upload the file to Google Drive and open it in Google Sheets to use it online.

Is this template suitable for VAT-registered businesses?

Yes, you can use the total of the invoice, which includes VAT

How do I record partial payments?

Reduce the total outstanding balance by the amount paid and leave the invoice marked as unpaid until it is fully settled.

Free Accounts Payable Excel Template Licence Agreement

By downloading the accounts payable template, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way.

ACCOUNTING SOFTWARE

Xero Accounting Software

Spend less time entering transactions into spreadsheets. Xero connects to your bank, helps you manage invoices and expenses, and supports Making Tax Digital.

From 70p per month for 6 months Paid plans then continue from £7/month. Prices exclude VAT.
  • Send invoices
  • Connect your bank
  • Capture receipts
  • MTD ready
View Xero Plans & Prices →

Other Useful Templates

Accounts Receivable – Track all your sales invoices
Cash Book – Record Income and Expenses
Sales Invoices

Disclaimer: This template is provided for general bookkeeping purposes and is not a substitute for professional tax advice. Check that it suits your circumstances and review current HMRC requirements before submitting information.

Angela Boxwell MAAT

Angela Boxwell – Senior Writer

Angela Boxwell, MAAT, is an accounting and finance expert with over 30 years of experience. She founded Business Accounting Basics, where she provides free advice and resources to small businesses.

Angela is certified in Xero, QuickBooks, and FreeAgent accounting software. To simplify bookkeeping, she created lots of easy-to-use Excel bookkeeping templates.