BankStatementHub

Check the books against the bank.

Drop in bank statements and a QuickBooks or Xero ledger export. See what's missing from the books, what never cleared, what was entered with the wrong amount or twice, and the month it all started.

1. Bank statements

PDF, CSV, OFX or Excel. Several at once.

2. The books

Ledger or account report from QuickBooks, Xero or any software, as Excel or CSV.

The books file is read in your browser and never uploaded. Statement PDFs are read on our secure server and deleted within 24 hours.

How to use it

  1. Add the bank statements for the period: PDFs, or the bank's CSV or OFX download.
  2. Export the bank account's activity from the books for the same dates. In QuickBooks: Reports → Transaction Detail by Account, filtered to the bank account → Export to Excel. In Xero: Accounting → Reports → Account Transactions → Export → Excel.
  3. Press Check the books, and work through the lists. Download the Excel file to send the client the questions.

Why it helps on cleanups

When the reconciliation is months behind, the bank feed was disconnected, or transactions were keyed in by hand, finding the difference means ticking every statement line against the ledger. This does the ticking: it pairs what matches and leaves you the few lines that need a decision, with the month the books and the bank first went apart.

Questions

Which ledger reports work?
From QuickBooks Online or Desktop: Transaction Detail by Account, General Ledger, or the bank account's register or QuickReport, exported to Excel or CSV. From Xero: Account Transactions for the bank account. From other software: any CSV or Excel file with a date column and either an amount column or debit and credit columns.
My report has every account in it. Is that a problem?
No. The check finds each account in the report and starts with the one that matches the bank best. You can switch to another account above the results.
How are transactions matched?
By amount first, then by date: the books often date a payment when it's made and the bank when it clears, so a few days apart is a match, and a check can clear weeks after it was written. A deposit of several receipts entered one by one is matched to their total. What's left is listed as missing from the books, not on the statement, a different amount, or entered twice.
What does “Probably not cleared yet” mean?
Checks, and entries from the last days of the period, that aren't on the statement yet. They are usually outstanding items that clear on the next statement, so they're listed apart from the entries that look wrong.
Are my files uploaded?
The ledger file and bank CSV and OFX files are read in your browser and never uploaded. PDF statements are read on our secure server, the same way as on the converter, and deleted within 24 hours.

Need the statements in the books first? Convert a PDF statement to Excel, CSV, QuickBooks or Xero.