Bookkeeping
Aged payables vs a supplier statement: why they never agree
Every month-end someone asks the same question: Xero's Aged Payables says we owe this supplier $4,210, and the statement they sent says $5,540. Which one is right? Almost always, both. They are answering two different questions, and the gap between them is the useful part.
Aged Payables answers "what do I owe, and when"
Aged Payables is a report generated entirely from your own books. It takes every unpaid bill belonging to that supplier, sorts them by due date into age buckets (current, 30, 60, 90+ days), and totals them. It is a view of your obligations as you have recorded them, organised by urgency, which is exactly what you need for cash flow planning and for deciding what to pay this week.
Three consequences follow from this that people often forget:
- It only contains bills you have entered. A bill sitting in a drawer awaiting coding does not exist as far as Aged Payables is concerned.
- It includes bills that are not yet due — genuinely owed, but no one expects payment today.
- It usually excludes any payments you have made that the supplier has not yet received, and excludes everything the supplier has recorded but not yet sent you.
A supplier statement answers "what does the supplier think has happened"
A supplier statement is the supplier's narrative of your shared history over a period: opening balance, every bill, credit note and payment they have recorded, running balance line by line, and a closing balance. It is chronological rather than urgency-sorted, and it reflects their records, their posting dates, and whatever they know about payments received.
It answers "do we agree about what happened?", which Aged Payables is structurally unable to ask. You can read more about the structure in how to create a supplier statement.
| Aged Payables | Supplier statement | |
|---|---|---|
| Who produces it | You, from your ledger | The supplier, from theirs |
| Ordering | By due date / age bucket | Chronological |
| Contains unentered bills | No | Yes |
| Contains payments in transit | No — already deducted | Depends on their receipts |
| Running balance | No | Yes |
| Best for | What to pay this week | Whether you agree |
The five reasons the totals differ
Almost every gap between the two numbers comes from one of these, and once you can name them the reconciliation becomes routine rather than alarming:
- Payments in transit. You sent it; they haven't banked or applied it. Your books are lower; theirs aren't. Usually resolves in a few days.
- Bills you have not entered. The invoice exists but never made it past someone's inbox. The statement is right and your books are incomplete.
- Credit notes you have not applied. They issued a credit; you haven't allocated it against a bill, so your total stays high.
- Partial payments and rounding. A payment applied to the wrong line, or a foreign-currency difference at settlement.
- Cut-off differences. Their statement covers to the 31st and includes something you booked on the 2nd of the following month. Neither side is wrong; the windows differ.
A working routine that takes about ten minutes
Do them together, in this order, rather than trying to make one number match the other in your head:
- Note the closing balance on their statement and the Aged Payables total from the same date.
- Match reference numbers rather than amounts — the gaps identify themselves, and the order in which you match matters more than most people expect.
- Deal with anything on their statement that isn't in your books first; that is where actual missing data lives.
- Chase anything in your books they haven't shown — usually the payments in transit. This is the list you email them.
- Explain the remaining difference in one line before you adjust anything: "they have not applied the $500 paid on the 10th".
If it is genuinely the fourth month in a row with unexplained differences, stop adjusting and pick up the phone. Repeated small differences usually mean someone is posting to the wrong account, and no amount of reconciliation will fix it.
The useful part is the gap
Once both views exist side by side, the difference stops being a discrepancy and becomes a short to-do list: one bill to chase, one payment to confirm, one credit to apply. Statemint builds that list from the two files in about a minute — everything stays in your browser, and the comparison with the cloud tools explains what you give up for that privacy.
Run your own files through it — the preview is the whole product, and nothing is uploaded.