Reconcile to the paper
Convert the statement. Check that opening + credits − debits equals the printed closing balance. Then import the .qbo or Xero CSV and reconcile to that same number. One figure, printed by the bank, closes the loop.
Preview is free. The first download is free after sign-in. After that, Solo is $29/month, cancel anytime.
up to 20 files · 20 MB each · PDF only · bank or credit-card statements
Every statement prints an opening balance and a closing balance. Opening + credits − debits has to equal the closing, to the penny. If the grid you are about to import satisfies that equation, every line is there and every amount is right. If it does not, something is missing or wrong, and you know before it reaches the books.
The example above and the sample on this page are a synthetic statement made for the demo, run through the real engine.
A grid with one line missing looks complete. A merged page footer looks like a transaction. A debit read as a credit looks like a deposit. None of that shows up until the reconcile screen disagrees with the bank, weeks later. The printed closing balance catches all three, on the day, in one number. Why a statement must tie before you import it →
4. Reconcile to the same number. In QuickBooks or Xero, the ending balance you type into the reconcile screen is the printed closing balance you already saw tie. The difference should be zero on the first pass.
QuickBooks Desktop: File → Utilities → Import → Web Connect Files. Pick the account whose type matches the export. Then Banking → Reconcile, with the printed closing balance as the ending balance. The Desktop page → · How the .qbo is built →
QuickBooks Online in the US can read a clean PDF on its own. It shows you the resulting balance after the import is linked to an account, not before. When the month has to be proven first, or the stack is long, or the file is a card, a combined PDF or a scan, convert here, then upload the .qbo through Transactions → Bank transactions → Upload from file, one month at a time. The Online page →
Accounting → Bank accounts → Manage account → Import a statement. Use the Xero bank-import CSV in Xero's own columns, or the OFX. Then reconcile to the printed closing balance. The Xero page →
The proof shows the first broken row. Often it is a missing page or a scan that needs the OCR pass. Fix a cell and the proof reruns. If it still does not tie, there is no download and no charge. Email the bank name and the layout is added within 24 hours on business days. Banks and cards that have tied →
Nothing is stored on our side. The PDF is parsed in memory and discarded when the response is sent. Security notes →
A statement that does not tie is not billed. Any first charge is refundable within 14 days. Billing and refunds →
Swipe sideways to see every column.
This grid exists only in this tab. Click a cell to edit date, description or amount; ± flips debit/credit. The proof re-runs on every edit. Convert another statement