Product guides

Why a report total and a list total can differ

Two screens, two totals, no obvious reason. Learn the usual causes of the gap, from excluded items to filters and time zones of thought.

Editorial illustration for Why a report total and a list total can differ

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.

CauseHow to confirm
Excluded itemsFilter or review the rules that exclude them
Different periodsCompare the date ranges shown
Active filtersClear all and recheck
TypesFilter by expense, income or refund
CurrencyCompare 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports