A good invoice summary isn’t a copy of the invoice list. It’s the page you look at when you want an answer in ten seconds instead of ten minutes. In my sample reconciliation workbook, the Summary tab is built around four questions.
1. How much did we bill?
One number: the total invoiced for the period. In the sample, that’s $11,065.
2. How much actually came in?
Payments received, calculated from the Payments tab instead of typed in by hand. In the sample: $8,900.
3. What’s still out there?
The outstanding balance, plus a count by status: paid, partial, unpaid, and overpaid. Counts make problems visible. “3 unpaid” is easier to act on than scanning a column of dates.
4. What needs a human to look at it?
This is the one most trackers skip. The sample flags invoices that need attention and payments that don’t match any invoice. An unmatched payment is money you received but can’t tie to a bill — easy to miss, and annoying to untangle months later.
A few habits that make this easier
- Keep raw data (invoices, payments) on their own tabs, and never type on the summary tab.
- Use the same invoice number format everywhere, so matching works.
- Keep an “overpaid” status even if it’s usually zero. That’s how you notice when it isn’t.
If your summary can answer those four questions without scrolling, it’s doing its job.