ocrsnip
No uploads · runs in this tab
ocrsnip
No uploads · runs in this tab
Citi has more statement layouts than most banks: a checking statement, a savings statement and a card statement are three different documents, and a relationship statement can hold several accounts in one PDF. Here is what each means for the conversion.
The answer changes what you should expect from the sheet.
A transaction list with dates, descriptions and amounts, and usually a balance that lets the arithmetic be checked. This is the case where the reader can do its best work: each balance is recomputed from the one above it, and anything that does not follow is highlighted before you import it anywhere.
No running balance anywhere — only transactions and a summary of previous balance, payments, purchases and new balance. Rows still come out correctly; the verdict will say there is nothing to reconcile against, which is the truth about the document rather than a limitation we would rather hide.
A combined statement prints one account after another. The reader takes the pages in order, so the transactions of the second account follow the first in the same sheet — and the balance check will fail at the boundary, because the two accounts have nothing to do with each other. That failure is the signal: split the PDF per account first, and each part checks out on its own.
Short dates take their year from the statement period printed at the top. Convert the whole document rather than a few extracted pages, or a statement spanning the new year can land in the wrong one.
No column headings were found, so the columns were identified from the running balance alone. Check a few rows before you rely on it.
| Date | Description | Debit | Credit | Balance |
|---|
They are already read and checked in this tab. A pass unlocks every row of every file you convert over the next 7 days, in this browser.
The workbook carries a second sheet, Warnings: every row whose balance does not follow from the row above, with the balance your statement shows next to the one the arithmetic expects. It says so plainly when there is nothing to check.
A converter is the second-best answer when an export exists.
Citi online banking can export recent activity as a spreadsheet file or as a Quicken file. Where your period is still online, use it: nothing is interpreted, so nothing can be misread.
Older months, closed accounts, and any case where the document itself is what somebody asked for. A PDF is also the only thing that exists when a statement was emailed to you.
If one PDF holds several accounts, separating it per account before converting takes a minute in any PDF reader and makes every balance check meaningful again. It is the single most useful thing you can do to a Citi statement before dropping it here.
Statements change, and yours may not look like this. Drop it anyway: the reader works from the layout in front of it rather than from a template per bank, and the balance check reports what it actually found.
Something else? Write to support@ocrsnip.com.
Probably not. The transactions are read correctly; what fails is the arithmetic across the join, where one account's closing balance is followed by another account's opening one. Split the PDF per account and convert each part, and both should reconcile.
Yes. You get every transaction with its date, description and amount. There is no running balance on a card statement, so the page says there is nothing to check rather than inventing a confidence figure; compare the totals on screen with the summary box on the first page.
Yes. Full detail keeps the statement's own columns; the QuickBooks and Wave preset gives the three columns their import expects; Xero has its own. Every preset writes dates as yyyy-mm-dd, so no import wizard can read them backwards.
It is opened in this browser tab and never sent anywhere — there is no server here that receives files. The spreadsheet is built in the tab too, and closing it leaves nothing behind.