ledgarooBank statement PDF to QuickBooks CSV
Drop the PDF as you downloaded it. We check every row against the figures your bank printed, then write the Date, Description and Amount CSV that QuickBooks Online’s bank upload asks for.
QuickBooks CSV comes with Premium. Excel and CSV are free for a whole statement at a time, with no account and no limit on how many. See what Premium costs.
Importing it into QuickBooks
Download the QuickBooks CSV
- In QuickBooks Online, go to All apps, then Accounting, then Bank transactions.
- Open the Link account menu, choose Upload from file and select the file.
- For the QuickBooks CSV, match its Date, Description and Amount columns to the ones QuickBooks names, and say the dates are dd/mm/yyyy.
The QBO carries the currency shown on its button, so check it is the account’s before you download. The CSV carries no currency and takes at most 1,000 transactions, so the QBO is the one to prefer.
What is in the QuickBooks CSV file
- Three columns: Date, Description, Amount.
- The three-column layout QuickBooks documents for a CSV upload, with a header row naming its fields, so matching the columns is three picks.
- Dates are written 23/01/2026.
- Day first, the format QuickBooks recommends. Choose dd/mm/yyyy when it asks how the dates are written.
- One signed amount a row, with no thousands separator.
- Money out is negative and money in is positive, written as -1850.00. A row of 0.00 is left blank, as QuickBooks asks.
- At most 1,000 transactions.
- QuickBooks takes no more in one CSV, so a longer statement shows why instead of a button. The QBO has no such limit.
Every format holds the same checked transactions. The other files we write are on the import page.
Questions
Is my statement uploaded anywhere?
No. The statement is read in your browser, on your computer. Nothing in it is sent to us or to anyone else.
Should I use the CSV or the QBO?
The QBO where you can. It records the currency and the date range, and QuickBooks reads it without asking which column is which. The CSV is for a QuickBooks set up to take one.
Why not the four-column layout, with Credit and Debit?
Because QuickBooks’ own example of it puts a payment under Credit and a deposit under Debit, so which way round it reads is not something we can promise. One signed amount column cannot be read the wrong way round.
Does it handle scanned statements?
Yes, as a PDF, JPG, PNG or WebP. The text is read off the picture by OCR in your browser, and the file never leaves your computer. The first scan takes longer while the reader loads. OCR can misread a figure, so a scan is checked like any other statement. If it prints no running balance, no totals and no closing balance, nothing can check the figures, so the download is held as it is for a failed check, and you look the figures over first. A date misread within the statement period passes every check, so a date OCR was unsure of is marked for you to compare with the scan. A PDF downloaded from online banking is more reliable than a scan. More about scanned statements.
Is it free, and do I need an account?
Excel and CSV are free for a whole statement at a time, with no limit on how many. Premium adds every other format, a CSV in a layout of your own, payee names with rules that set the payee and category, the working paper, part of a statement, several statements joined into one, and downloading every open statement at once. Neither needs an account: Premium is a licence key, which you paste into the page or activate from the email it comes in, and your browser keeps it. The pricing page lists each format and the price.