Budgeting

Category report shows zero for a month: why it happens

Category shows zero spending in a month? Check the usual causes, from renamed categories and date filters to missing statements and annual bills, step by step.

Editorial illustration for Category report shows zero for a month: why it happens

A category showing zero for a month almost never means you spent nothing. Most often the money is sitting in another category, the date filter is off, a statement for that month was never added, or the payment genuinely falls once a year. Work through the checks below in order, from the quickest to the slowest.

What is the fastest check?

Add up the category totals for the month and compare them with the total of all spending. If everything adds up to ₹37,000 but your total spending is ₹48,000, then ₹11,000 is sitting somewhere your report is not showing, such as uncategorised items or another account. That gap is the first clue. If it equals the amount you expected in the empty category, you have your answer.

The step-by-step check

  1. Look at the date filter. Confirm the exact start and end dates, and whether you are viewing a calendar month, last 30 days or a statement period.
  2. Check the account filter. A report limited to one bank account will miss spending on a card or wallet.
  3. Open the uncategorised or needs-review list for that month. Payments that could not be matched may be waiting there.
  4. Search for a few merchants you know belong to the empty category, for example your usual grocery store, and see which category they landed in.
  5. Compare the category name with last month. Renames and merges can leave an old name and a new name side by side.
  6. Check the import history to confirm a statement exists for every account that month, and that no import failed.
  7. Think about the calendar. Some categories legitimately have zero most months.

Why would a category be renamed or split?

Suppose you had a category called Groceries and later renamed it Food and household. May shows ₹11,000 under the old name and June shows ₹11,500 under the new one. Looking only at Groceries, June appears to be zero. The money did not vanish; the label changed. Check whether your tool keeps both names or merges them, and tidy up so one name remains.

Could a missing statement be the reason?

Yes, and it is common with cards. If your June card statement was never uploaded, then every purchase made on the card in June is absent, and categories you mostly pay by card look empty. SpendixAI keeps an import history with a status for each upload and sends an Import failed notification when something goes wrong, so check there for a failed or missing file before blaming the categories. If AI categorisation is switched off, unmatched items are held for review rather than guessed, so look at that list too.

When is zero correct?

  • Annual or half-yearly items such as insurance premiums, which appear in one month and nowhere else.
  • Seasonal categories like festival gifts, travel or school uniforms.
  • A category for something you stopped, such as a cancelled subscription.
  • Months when you paid for the item in a different month, for example a yearly pass bought earlier.

A worked example with numbers

Groceries was ₹11,000 in May and shows ₹0 in June. Total spending for June is ₹48,000, but the category totals add up to only ₹37,000, leaving a gap of ₹11,000. You open the uncategorised list and find ₹7,500 of grocery payments waiting there. The other ₹3,500 turns out to sit under the old category name from before the rename. 7,500 + 3,500 = ₹11,000, so the whole gap is explained and nothing was missing.

How to stop it happening again

  1. Import statements for all accounts and cards on a fixed day each month.
  2. Review uncategorised items soon after each import.
  3. Rename categories rarely, and when you do, check the previous months afterwards.
  4. Keep the date filter on calendar month while you investigate, then switch to others once the picture is clear.
SPENDIXAI JOURNAL

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

Explore your reports