1. [Home](https://www.g2.com/)
2. ...
3. [Data Extraction Tools](https://www.g2.com/categories/data-extraction-tools)
4. [BankToRows Discussions](https://www.g2.com/products/banktorows/discuss)

[
 ![BankToRows](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_d3fc4d7b1a741bf04811334bf579337c/banktorows.png "BankToRows")
](/products/banktorows/reviews)

# BankToRows Discussions

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.

## Be the first to start the conversation

Get answers from real professionals in the G2 community.