The Total Matches. Why Are Some Orders Still Missing?
A matching grand total can coexist with missing or repeated records. Add population, identity and exception checks to your monthly reconciliation note.

The summary total agrees with the source export. That is reassuring, but a colleague cannot find an order they expected to see. Is the report right, or did two different problems happen to offset each other?
A matching total is one useful check. It is not a complete account of which records entered the report and how they were represented.
Reconcile the population as well as the amount
Consider a fictional retailer. One order is omitted while another is repeated. If their amounts happen to match, the overall total can agree even though the detail is wrong.
This example does not mean every matching total hides an error. It shows why the check should fit the question. If you need to know which orders belong to the month, inspect record coverage and identity as well as the combined amount.
Write down what one row means. A source with order lines cannot be compared with an order summary by row count alone without accounting for the different level of detail.
Choose a small set of complementary checks
A practical monthly note can record the incoming file coverage, relevant counts, a defined total and the list of unmatched or excluded records. Select checks that address the likely preparation risks in your actual report.
For the retailer, the coordinator might compare unique order identifiers, review any unexpected repeats and explain cancelled or excluded transactions. The important part is the meaning of the check, not collecting a long list of reassuring numbers.
Keep the source file and the reporting period visible. A clean reconciliation against the wrong export still leaves the business question unanswered.
Explain differences instead of hiding them
When a record is excluded by a valid rule, retain a short explanation. When the reason is unknown, leave it unresolved and assign the review to someone who can answer it.
Do not make the total agree by adjusting a summary cell without documenting the underlying decision. That may conceal a preparation problem which returns next month.
A clearly labelled provisional report can support a discussion while a small exception is investigated. The reader needs to know what remains open and whether it affects the decision they are making.
Test an offsetting pair
In a safe fictional copy, remove one small record and repeat another of the same amount. Notice which checks detect the change and which remain unchanged.
Then restore the correct population and record how you confirmed it. This exercise helps colleagues understand why the reconciliation note includes more than a grand total.
The aim is a report whose contents can be traced and explained. Agreement at the bottom of the sheet is valuable evidence, but it should sit beside a reasonable account of what is inside the number.
Keep the reporting method connected
Explore the Make the Imported Detail Worth Summarising guide and the related practical questions below.
- The Rows Multiplied After the Join. Did the Business Really Grow?
- Where Did the Zeros Go? When an Identifier Starts Looking Like a Number
If you want a written practice route, review the Excel Monthly Reports with Matze course overview. It requires compatible Excel Desktop for Windows with Power Query; you build the report yourself.
Check the course contents and current price. Affiliate link: Superstore may earn a commission if you buy. Check current contents, requirements and terms before purchasing.




Discussion 0
What did this article make you think about?