Citi statement to Excel. Charges, payments and the balance that follows them, re-added.
Card statements have their own arithmetic: a previous balance, new charges, payments and credits, and a new balance — and the summary block at the top has to agree with the register below it. When it does not, the useful output is the exact amount by which it does not, not a tidier-looking sheet.
Drop a Citi statement here
Or click to pick the file. It opens in the same page you would have used anyway — the balance chain starts re-adding on the next screen.
Three files free, 60 pages in total, no card needed. Paid plans are priced by the page — one page of the original is one page, up to 500 pages in a single file.
A credit line is not a bank ledger
On a card statement a charge increases what you owe, so the sign convention is the opposite of a current account. A converter that assumes deposits and withdrawals will invert every row and still produce a column of plausible numbers. Here the account type is decided from the statement, stated on screen, and used consistently — and the previous/new balance pair is the check that proves it.
What gets checked before you download
Every line below is arithmetic on the paper you sent — not a supplier's claim about how good its reading is. Where the arithmetic fails, you get the row and the exact difference, and the statement is not called balanced.
Previous balance + charges − payments = new balance
The summary block is checked as its own arithmetic. A failure is reported with the exact difference and is not rounded to the cent.
Which way the sign runs
A card ledger and a deposit ledger move in opposite directions. The convention used is stated, so a reviewer can confirm it rather than infer it.
Every row reconciled forward
Each printed running balance is compared with the previous one adjusted by that row.
Interest and fee blocks kept separate
They are claims about the period, not transactions. They are checked against the register rather than added into it.
Where a Citi statement goes wrong quietly
None of these announce themselves. Each one produces a file that looks correct.
Credits printed as negatives on a card statement
A payment reduces the balance but can print as a negative charge or a separate credit column. Either way it is read from the statement's own structure, not guessed from the description.
Foreign currency transactions
The original amount and the posted amount can both be printed. Both are preserved; neither overwrites the other.
Promotional rate sections
A trailing 'interest charge calculation' table repeats amounts already in the register. Read as rows, it doubles them; it is recognised as a summary and kept out.
What we will not claim
We do not maintain a Citi layout. When the reader cannot place a line, the line is flagged and left visible — the gap is yours to look at, not ours to fill.
The same goes for the arithmetic: a clean run means the checks we ran found nothing to flag. It does not mean the document is correct — it means nothing in it failed the checks listed above.
How it runs
Upload the statement
A native PDF, a scan, or a phone photo of the Citi statement. No bank connection, no credentials, nothing to authorise.
The ledger is rebuilt and walked
Rows are put back in the order the statement prints them, page furniture is removed, and the balance chain is re-added line by line.
Check the flags, then export
Anything that did not add up is listed first, with its page and exact difference. Then take the Excel file, the other export shapes, and the review sheet.
What lands on your disk
- The .XLSX register — one row per transaction, no merged cells, amounts as numbers
- A Review sheet: who confirmed or corrected which cell, and what it said before
- Plain CSV, Xero-shaped CSV, and QuickBooks .QBO with unique transaction IDs
- A check report stating the rows printed, the rows exported, and every difference found
- Every cell still clickable back to the page and region it was read from
- Files are read, then destroyed — a second upload is a second read
Questions
Does this work for a credit card statement, not a bank account?+
Yes. The account type is detected and the sign convention follows it. Where the statement makes that ambiguous, it is flagged rather than assumed.
What is the Review sheet in the workbook?+
A list of every cell a person confirmed or corrected, with the printed value and the value as it now stands. Everything else is marked as machine-read and untouched, so nobody can mistake an unexamined figure for a checked one.
Can I get a CSV or a QuickBooks file as well?+
All four exports come from one upload: .XLSX, plain CSV, a Xero-shaped CSV, and .QBO for QuickBooks.
What does it cost?+
Three files are free, 60 pages in total, with no card and no account needed to try. Paid plans are sold by the page — $19 a month buys 1,000 pages — and a page is one page of the original document.