BankToRows

0 reviews

BankToRows gets bank and credit card transactions out of PDF statements and into QuickBooks, Xero, Quicken or a spreadsheet, checked first. Bookkeepers and accountants use it for catch-up bookkeeping, closed accounts, missing months and banks that only give PDFs. Every statement is checked against its own balances: the opening balance plus the transactions must equal the closing balance, and each printed running balance must follow from the one before, to the cent. A missed or misread line shows up as a difference with the rows highlighted, and any date, description or amount can be fixed before downloading. When a date could be read two ways or the currency isn’t clear, it asks instead of guessing. There are no per-bank templates: it reads the transaction table on any text-based statement. Downloads are Excel, CSV, the CSV layout QuickBooks Online uploads, QBO (Web Connect), IIF for QuickBooks Desktop, OFX, QFX and QIF, with stable transaction IDs so a re-import doesn’t duplicate. Bank downloads in CSV, QBO, QFX, OFX, QIF or IIF can be checked and converted too, and a reconciliation report (PDF) records the check for the client’s file. The statement is read in the browser and never uploaded. One statement at a time is free with no sign-up. Pro ($19 a month or $149 a year) adds batch conversion: a year of statements at once, checked for missing months, overlaps and rows printed twice, as one file with a full-year report. Scanned (image-only) statements aren’t supported.