To give an AI assistant a transactions file it can read properly, export a CSV with one header row, one transaction per row, dates in year-month-day form, amounts with a sign, and a category column. Remove merged cells, blank lines and totals rows from the middle. Mask anything personal before you upload it.
What does a clean layout look like?
An assistant reads a CSV as plain rows and columns. Anything that depends on how a sheet looks, such as colour, merged cells or a title banner above the table, becomes noise. Keep the file boring.
- Row 1 holds the column names, and nothing sits above it.
- Each row is one transaction. No subtotals, no blank separator rows.
- Dates use the form 2026-10-14, so there is no confusion between 03/04 meaning March or April.
- Amounts are plain numbers with no rupee sign or commas inside the number, so 12500.00 and not Rs 12,500.
- Money going out is negative and money coming in is positive, or use a separate type column. Pick one approach and keep it everywhere.
- One column for category, one for merchant, one for account.
An example of five rows
| date | merchant | amount | category | account |
|---|---|---|---|---|
| 2026-10-01 | Salary credit | 85000.00 | Income | Salary account |
| 2026-10-03 | Supermarket groceries | -2340.50 | Groceries | Credit card |
| 2026-10-05 | Metro recharge | -500.00 | Transport | Wallet |
| 2026-10-08 | Electricity bill | -1860.00 | Bills | Salary account |
| 2026-10-12 | Cafe lunch | -420.00 | Food and Dining | Credit card |
Adding the five amounts gives 85000.00 - 2340.50 - 500.00 - 1860.00 - 420.00 = 79,879.50, the net movement for these rows. A tidy file lets you check a total like this in seconds, and lets the assistant do it too.
How do you get the file out of your tracker?
- Filter to the period you want, for example one calendar month, so the file stays small.
- Choose a CSV download from the transactions or reports area. SpendixAI offers CSV downloads from its reports and an export centre with a standard all-transactions file.
- Open the file in Excel or Google Sheets and look at it before sharing. Check the header row, the date format and the sign of the amounts.
- Delete columns the assistant does not need, such as internal IDs or notes with personal remarks.
- Save as CSV again, choosing plain CSV rather than a spreadsheet format.
What should you mask before uploading?
The assistant needs patterns, not identities. Replace personal names in merchant fields, remove account numbers and any reference numbers, and delete the opening and closing balance lines if the file has them. If you plan to ask the assistant to check totals against a balance, tell it the balance in the question instead of leaving the line in the file.
How big should the file be?
Smaller is better. A month or a quarter of transactions is plenty for most questions, and files of a few hundred rows are easier for an assistant to read in full. A free plan on a chat assistant may also limit the size of an upload or the number of messages, so if the file is long, split it by month and ask the same question of each part. Then add the answers yourself, in a sheet, instead of asking the assistant to add forty numbers it has not seen in one place.
How do you check the file before you upload it?
- Count the rows in your sheet and compare with the number of transactions in your tracker for that period.
- Add the amount column and compare the result with the net movement shown in your reports.
- Sort by date and look at the first and last rows, to make sure the period is right.
- Scan the category column for blanks, because an empty cell tells the assistant nothing.
Common mistakes to avoid
- Mixed date formats in one column because rows came from two sources.
- Amounts stored as text, shown with a small green marker in a sheet, which sums can silently ignore.
- Debit and credit in two separate columns with the sign missing, which the assistant may add together.
- Uploading a whole year when your question is about one month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

