Free template

Purchase ledger and aged creditors spreadsheet template

A working Excel purchase ledger: every supplier invoice, what you have paid against it and what you still owe. A second sheet turns it into an aged creditors report, showing for each supplier how much is not yet due and how much is 1 to 30, 31 to 60, 61 to 90 and over 90 days late on a date you choose. Free, no sign-up and no email address.

Download the template (.xlsx)

What is in it

SheetOne row perWhat it does for you
InvoicesSupplier invoiceInvoice date, supplier, invoice number, net, VAT, due date, the amount paid so far and the date of the last payment. The total and the amount still owed are worked out on every row, so a part payment leaves the rest showing.
Aged creditorsSupplierWhat you owe each supplier, split by how late it is on the date at the top, with a total for the whole ledger and a line that catches money owed to any supplier you have not listed.

What a purchase ledger is for

It answers three questions that a folder of invoices cannot: how much do we owe in total, who do we owe it to, and what is overdue. Each supplier invoice is one row. When you pay some or all of it, you type the amount paid so far on the same row, and the amount still owed falls to match.

The aged creditors sheet is the same information arranged for a decision. Type each supplier's name once, exactly as it appears on the Invoices sheet, and set the date. Reading across a row tells you how old that supplier's debt is; reading down the last columns tells you who to pay first.

How the ageing is worked out

Ageing runs from the due date, not the invoice date. An invoice due on or after the date at the top is not yet due. One that fell due the day before is one day late and sits in the first column of late debt. An invoice with no due date cannot be late, so it is counted as not yet due; add a due date if the supplier's terms give one.

The report shows what is owed now, aged as at the date you enter. It is not a record of what was owed on a past date, because a payment you have since typed in reduces the amount wherever you set the date.

Keeping it right

Supplier names must match letter for letter between the two sheets, or that supplier's invoices will not reach its row. The last line of the report exists to catch this: if it shows anything other than zero, some supplier on the Invoices sheet is missing from the list or spelled differently. A credit note goes in as a row with negative net and VAT.

Filling it in without typing

Every row here starts as a supplier invoice: a PDF, a scan or a photo. Invoices to Spreadsheets reads a folder of those into one checked table with the date, supplier, invoice number, net, VAT and total, which you can export to Excel and paste into the Invoices sheet. Try one invoice free, without an account.

Is the purchase ledger template free?

Yes. Download it, use it, change it. No account, no email address, no card.

What is an aged creditors report?

A list of what you owe each supplier, split into columns by how overdue it is: not yet due, 1 to 30 days late, 31 to 60, 61 to 90 and over 90. It shows at a glance which bills are oldest.

How do I record a part payment?

Type the total paid so far in the Paid so far column and the date of the latest payment beside it. The Still owed column shows the remainder, and the aged creditors sheet uses that figure.

What is the difference between this and the invoice tracker?

The invoice tracker gives each invoice a status of paid, due or overdue and is the simpler of the two. The purchase ledger handles part payments and adds the aged creditors report by supplier.

Does it work in Google Sheets or Numbers?

Yes. It is a standard .xlsx file using SUM and SUMIFS. Set your locale to United Kingdom before importing so dates are read day first.

Start my free trial

7 days · 50 documents · No card needed

All free tools and templates · Invoice tracker template · Bookkeeping cash book template