A report says one number. The transaction list, filtered to what looks like the same slice, says another. The discrepancy feels alarming, as if one screen is wrong. Usually neither is. They are answering slightly different questions, and finding the difference is a small piece of detective work with a short list of suspects.
Suspect one: excluded transactions
Some transactions are kept out of reports on purpose, such as transfers between your own accounts or credit card bill payments. They appear in the transaction list because they are real movements of money, but they do not count in report totals. If the list is higher than the report, exclusion is the first thing to check.
A filter in the transaction list can isolate them, or you can look at the rules that set the exclusion flag. The difference between the two totals should equal the sum of the excluded items.
Suspect two: different periods
The report and the list each have a period selected. They may not be the same. This month in one place and a custom range in the other will naturally produce different figures. Compare the dates shown on each screen before comparing numbers.
Suspect three: leftover filters
The list remembers filters. A forgotten account filter, an amount range or a category selection can silently narrow the list. Clear all filters and compare again. The same applies in reverse: a report built with filters may show less than the list suggests.
Suspect four: transaction types
Reports about spending usually count expenses only. The list may include income and refunds, which change the visible sum. Make sure you filter the list by type to match what the report measures. Refunds in particular reduce net spending, and some reports handle them differently from others.
Suspect five: currency
If you track more than one currency, the list may show amounts in each transaction's own currency, while a report converts everything to one. The totals will differ unless you account for conversion. Amount filters also use each transaction's own currency before conversion.
A method for finding the gap
- Match the period on both screens.
- Clear all filters on the list.
- Filter the list by type to match the report.
- Add up the excluded items and subtract them.
- Check for different currencies.
Work through the steps in order, comparing after each. By the time you reach the end, the gap is usually explained.
| Cause | How to confirm |
|---|---|
| Excluded items | Filter or review the rules that exclude them |
| Different periods | Compare the date ranges shown |
| Active filters | Clear all and recheck |
| Types | Filter by expense, income or refund |
| Currency | Compare converted and original amounts |
Document the reconciliation
Once you have found the reason for a gap, write it down in a line: for example, report is lower by the amount of the card bill payments, which are excluded. The next time someone asks, or you wonder yourself, the answer is on hand. Over time you build a small set of known differences, and mystery shrinks to near zero.
When the gap remains
If a real difference persists after these checks, note the figures, period and settings, and test a smaller slice, such as one category for one week. Narrowing until the numbers agree will expose the transaction responsible. It might be a duplicate, a misdated entry or an item with an unusual type.
Do not adjust anything until you know why the numbers differ. A difference you understand is harmless. A difference you cover up with a guess grows into a real error.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


