Accounts payable month-end close checklist for small firms
An accounts payable month-end close makes sure every bill that belongs to the month is recorded once, in the right period, and that your unpaid bills agree with the payables balance in the ledger. The core steps are cut-off, entering bills, accruing what is unbilled, reconciling payables, checking duplicates and aging, and locking the period.
General information for bookkeepers, not accounting, tax or legal advice. Rules and software screens differ by country and change over time.
Cut-off and accrual rules depend on your accounting basis and your jurisdiction, so confirm your own policy with your accountant.
The checklist
Run the steps in this order. Each one makes the next easier, and the bills step is the one most months depend on.
-
Set the cut-off
Fix the last day of the month and the date by which late invoices will still be accepted into it.
-
Collect every bill
Check the inbox, the mail, the shared drive and any photos taken on site for invoices dated in the month.
-
Enter the bills
Key or import them all, dated by invoice date, one entry per invoice. Check each total against the paper as you go.
-
Reconcile supplier statements
For your busiest suppliers, compare the statement with your open bills to find missing invoices, unapplied payments and credits.
-
Accrue what arrived but is not billed
Goods received or work done in the month with no invoice yet may need an accrual, depending on your basis of accounting.
-
Look for duplicates
Sort the month's bills by supplier and number. See duplicate invoice detection.
-
Reconcile payables to the ledger
The aging report total must equal the accounts payable balance. Investigate journals posted to payables, unapplied credits and payments dated in the wrong period.
-
Review aging and due dates
Look at overdue bills, discount deadlines and due dates that look wrong. See net 30 due date calculation.
-
Reconcile bank and card accounts
Paid bills should match cleared payments, with nothing paid twice.
-
Lock the period and file the evidence
Set the closing or lock date in your software, and keep the aging report, reconciliations and statements for the month.
Cut-off cheat sheet
| Situation | Usual treatment | Check |
|---|---|---|
| Invoice dated in the month, received after month-end | Record it in the month if that period is still open. | Date it by the invoice, not the day you key it. |
| Goods received or work done in the month, no invoice yet | Accrue the cost in the month. | Reverse the accrual when the invoice is entered. |
| Invoice dated after month-end for work done in the month | Often belongs in the month of the work, depending on policy. | Ask your accountant which rule applies. |
| Credit note dated after month-end | Record it in the period of the credit note unless you reopen the month. | Link it to the original bill. |
| Payment sent but not yet cleared | Record it on the payment date. The bank reconciliation shows it as outstanding. | Look for it on next month's statement. |
| Statement shows an invoice you do not hold | Ask the supplier for a copy, then enter it. | Search for duplicates first. |
When payables will not reconcile
Step 7 is where closes stall. Work through the gap in this order.
- Same date. Run the aging summary and the balance sheet as at the same date. Mismatched report dates are the commonest false alarm.
- Odd transaction types. List the transactions in the payables account and look for anything that is not a bill, a bill payment or a credit. A journal is the usual culprit.
- By supplier. Compare the two by supplier. A gap that sits with one supplier points to a wrongly dated payment or an unapplied credit.
Locking the period
As of general knowledge, QuickBooks Online has a closing date setting in its advanced account settings, and Xero has lock dates in its financial settings. Once a period is locked, later corrections go into the next period or need an unlock, so finish reconciling before you lock. Check who in your team can unlock, and keep a note of why.
What goes wrong
Cut-off drift
Bills keyed in the first week of the next month take the wrong date. Date by the invoice, and keep a list of bills entered late.
A lock that comes too early
Locking before late bills and corrections are in forces a reopen. Keep a short list of what is still expected, and lock when it is empty.
Duplicates inflate the month
The same invoice entered from an emailed copy and a mailed one. The aging report looks fine, and the cash goes out twice.
Liabilities nobody entered
Invoices still sitting in someone's inbox. Ask project leads for anything outstanding before you lock.
How BillToCSV helps
Step 3 is where BillToCSV fits. Drop the month's supplier bills, clear the amber rows, and download one QuickBooks or Xero file for all the bills you ticked. The review CSV lists every line with its check result, which you can file with the month's evidence. It does not reconcile payables, make accruals or close the period; those stay with you. Free: 1 file per day, up to 10 pages, no account. Files over 10 pages are converted up to page 10 on the free allowance; a page code converts the whole file, up to 150 pages. See pricing.
Questions people ask
How long should an accounts payable close take?
It depends on volume and discipline, so no honest figure applies to everyone. Small firms do best with a fixed calendar: a cut-off date, a day for entering bills and a day for reconciling.
What is an accrual in accounts payable?
A recorded cost for goods or services received in the period but not yet invoiced. It is usually reversed when the real invoice is entered. Whether you need accruals depends on your accounting basis.
Why does my aging report not match the payables balance?
Typically because of journals posted to payables, unapplied credits or payments, or a payment dated in another period. List the differences by supplier. In multi-currency books, revaluation can also cause it.
Should I lock the period every month?
Most bookkeepers do once the month is reconciled, so figures already reported do not change. Check how your software unlocks a period and who has that permission.
Do I need supplier statements for every supplier?
No. Reconcile statements for your largest and busiest suppliers, and for any supplier whose invoices you suspect are missing.
What evidence should I keep for the close?
The payables aging report as at month-end, the reconciliation to the ledger, supplier statement reconciliations, the accrual list, and a note of who closed the month and when. Retention rules differ by country.