Excel for accounts payable: the supplier invoice register
The accounts payable workbook on this page is the list you open before you decide which supplier invoice is still open. One row is one invoice you received. You type the invoice number, the vendor, the amount, the due date, and the status. Two more amounts sit on the same row: the purchase order amount and the goods receipt amount. The sheet compares those three amounts. It does not rank software. This file is not a customer invoice you issue, a cash payment calendar, or a collections chase. Issuing invoices belongs with the accountant. A payment schedule says when cash leaves. Collections follow money customers still owe you. An aging report buckets open items by how late they are. Here the question is only: does this supplier invoice match the order and the receipt, and is it still open. The guide below builds that register. Elyx writes the match flags in the workbook you already keep. You still type the invoice. The trial lasts 7 days, with no card.
- Build the supplier invoice register
- Customer invoicing, a different job
- Payment schedule, when cash leaves
- Treasurer payment schedule, also a different list
- Collections, accounts receivable
- Aging buckets, a different how-to
- AI tools for accounts payable in Excel
Frequently asked questions
What goes on an accounts payable invoice register?
One row per supplier invoice you received: number, vendor, amount, due date, status, and flags that compare the PO amount and the receipt amount with the invoice amount.
Is this the same as issuing customer invoices?
No. The accountant invoicing page is about invoices you send to customers. This register logs invoices vendors sent to you.
Is this an aging report or a tool ranking?
No. Aging buckets live on the accounts payable aging how-to. This page is the register and the three-way match. It does not list software.