Getting started

Spending tracker with CSV import: prepare the file so it loads cleanly

Prepare a CSV for a spending tracker: the columns it needs, how to merge debit and credit, fix dates and amounts, and test with a few rows first.

Editorial illustration for Spending tracker with CSV import: prepare the file so it loads cleanly

A CSV import works when the file is tidy: one header row, one transaction per line, a date column in a single format, and an amount column that holds plain numbers. Most failed imports trace back to one of these. Prepare the file in a spreadsheet, test with five rows, and only then load the lot.

Which columns does a tracker usually need?

ColumnWhat to putWatch out for
DateOne format throughout, such as DD/MM/YYYYDates stored as text
DescriptionPayee or narrationCommas inside text
AmountA plain number, signed or with a type columnCurrency signs and thousand separators
TypeDebit or credit, if amount is unsignedMixed spellings
AccountName of the account, or pick it in the trackerSeveral accounts in one file

Check what your tracker lists as required; some can pick a column mapping at import, which saves editing.

How do I merge debit and credit columns?

Many statements show Debit in one column and Credit in another. Trackers often want a single signed amount. If Debit is column C and Credit is column D, enter this in E2 and copy down: =N(D2)-N(C2). N() turns a blank or text cell into zero, so the sum never errors. Credits come out positive and debits negative. Say a row has Debit 1,200 and no credit: E2 = 0 − 1,200 = −1,200. A row with Credit 5,000 gives +5,000.

How do I fix amounts that arrive as text?

A figure like 12,450.00 stored as text will not add. Left-aligned numbers are a clue. In a helper column use =VALUE(SUBSTITUTE(C2,",","")) to remove commas and convert. Copy the helper column, paste as values only over the original, then delete the helper. If the statement uses Cr and Dr after amounts, split that text into the Type column first.

Why are my dates wrong after import?

The usual culprit is day and month swapped: 03/11/2026 means 3 November in India but 11 March in US-style settings. Look at a date with a day above 12, such as 25/11/2026. If it appears as text or an error, the tracker has read the format differently from the file. Fix the sheet's date format, or choose the right date format on the import screen if one is offered.

How do I check the totals after importing?

  1. Total debits and credits in the sheet before import.
  2. Total them again in the tracker for the same period.
  3. Compare both to the opening and closing balance on your statement. Say the opening was ₹10,000, debits ₹7,300 and credits ₹4,500: closing should be 10,000 − 7,300 + 4,500 = ₹7,200.

What does SpendixAI accept?

SpendixAI accepts bank and card statements as PDF, CSV or Excel. Choose the account before importing, review the rows, then save. It flags possible duplicate imports and keeps an import history with a status. Do not expect every layout to parse perfectly; the review step is there for that reason.

Keeping a clean master copy

Keep one cleaned master file per account and add new months below the old ones, rather than starting from scratch each time. Import only the new rows into the tracker. A master copy also gives you a record that does not depend on any one app, which is useful if you ever switch tools.

Before you close the file

  • Save the cleaned file under a new name and keep the original.
  • Do not import the same period twice.
  • Record the totals you checked.
SPENDIXAI JOURNAL

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

Explore your reports