Security

Is your exported expense file complete? Quick checks in Excel

Check an exported expense file is complete in Excel or Sheets: row count, date range, monthly totals against statements and missing categories, with an example.

Editorial illustration for Is your exported expense file complete? Quick checks in Excel

To check an exported expense file, count the rows, confirm the first and last dates, add up each month and compare with your bank statements, and scan for blank categories. Four checks, about fifteen minutes, and you will know whether the file is the whole record or a partial copy.

The formulas below work in Excel and Google Sheets. Assume dates are in column A, amounts in column C and categories in column D, with data in rows 2 to 5000.

How do I check the row count?

  • Count rows with data: =COUNTA($A$2:$A$5000)
  • Count rows with an amount: =COUNT($C$2:$C$5000)
  • If the two numbers differ, some rows have a date but no numeric amount; text amounts such as '1,200 Dr' will not be counted by COUNT.

Compare the result with the number of transactions the app reports for the same period.

How do I check the date range?

  • Earliest date: =MIN($A$2:$A$5000)
  • Latest date: =MAX($A$2:$A$5000)

Format both cells as dates. If the latest date is weeks before you exported, the file may have been cut off. If dates show as text and MIN returns 0, the file's dates were not recognised as dates; re-import or convert them first.

How do I compare totals with statements?

Put the first day of a month in E1, for example 01-04-2026, and the first day of the next month in E2. Then total the month's outgoings, assuming spends are positive numbers: =SUMIFS($C$2:$C$5000, $A$2:$A$5000, ">="&$E$1, $A$2:$A$5000, "<"&$E$2). Compare the result with the debits total on that month's statement.

What does a truncated export look like?

Worked example with hypothetical numbers. Say the app showed 600 transactions for the year, and your file has exactly 500 rows. The latest date is 14 September while you exported in November. Monthly totals for April to August match your statements, but September is ₹9,200 short against the statement's debits of ₹41,700, and October and November are empty.

CheckExpectedFoundMeaning
Row count600500100 rows missing
Latest dateEarly November14 SeptemberExport stopped mid-September
September debits₹41,700₹32,500₹9,200 gap
Oct and Nov rowsPresentNoneLater months absent

Here 41,700 minus 32,500 is 9,200, and the pattern points to a row limit or a date filter. The fix is to export again in smaller date ranges, or to find the setting that was limiting the file.

How do I find missing categories or receipts?

  • Blank categories: =COUNTBLANK($D$2:$D$5000) counts empty cells in the range, so make sure the range matches your last data row.
  • Uncategorised label: =COUNTIF($D$2:$D$5000, "Uncategorised") if your tool uses that word.
  • Receipts: if the export has a receipt column, filter for blanks on entries above an amount you care about, for example ₹5,000.

One more check catches duplicates: sort by date and amount and look for rows that repeat exactly. A few repeats can be real, such as two identical tea stall payments on one day, but a block of identical rows usually means a double import. Compare the count of repeats with your statement before deleting anything.

When should I ask the app for help?

  1. The row count differs from the app by more than a handful.
  2. Totals differ from statements and you have ruled out transfers and refunds.
  3. Whole accounts or months are absent.
  4. Columns you rely on, such as account or currency, are missing.

SpendixAI gives CSV downloads from reports and an Export centre with a standard all-transactions file, so you can run these checks on a fresh file before any big change. Possible duplicate imports are flagged in the app, so a row count above your statement count is worth checking against that flag. If the file feeds your accounts or a return, ask your CA which checks they expect.

SPENDIXAI JOURNAL

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

Explore your reports