BankPDFtoXLS
Start your free trial
Menu

BankPDFtoXLS for bookkeepers and accountants

The short answer: Convert each client's statement PDFs, then download Excel or the import file for their books. We check every running balance and mark each row in the Ledger column, so you start with the rows that do not add up instead of retyping them all.

  • We check every running balance, so a missing or misread row shows.
  • We read the statements of most banks, scans included.
  • If you take a plan, you can cancel it any time.
Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

What a client's pile of PDFs becomes

  • Rows, not pages. Every transaction is a row with its date, description and amount, ready to post or to sort.
  • A check on every balance. The Ledger column tells you if each balance follows from the row before, so a missing or misread row shows.
  • A file for their books. On the free trial and the Standard and Plus plans, most whole statements come with a file that Xero, QuickBooks Online and FreeAgent import. Lite gives Excel and CSV.

How to post a client's statements

  1. Ask your client for each statement as the PDF their bank gives them. Scans and phone photos saved as PDF work too.
  2. Drop the first one in the box at the top of this page, and we show you its first page converted.
  3. Sign up to download it. You do not need a card: your free trial converts 15 pages, so you can check the columns before you take a plan.
  4. Once you have a plan, drop the rest into your account. Each one converts in the background.
  5. Download Excel, or, on Standard or Plus, the Xero, QuickBooks or FreeAgent file. Check any row the Ledger column marks break against the PDF first.
  6. Import the file into your client's bank account in their software, or post the rows from Excel.
Date Description Paid out Paid in Balance Ledger
02/04 BGC CUSTOMER LTD 2,400.00 5,112.40 ok
03/04 DD OFFICE RENT 850.00 4,262.40 ok
03/04 CARD SUPPLIES 46.20 4,216.20 filled
05/04 FPO CONTRACTOR 600.00 3,661.20 break

Sample figures, not a real statement.

Here the last balance is 45.00 more than 4,216.20 less 600.00. A row between them is missing or misread, so look at that part of the PDF.

Questions

How many pages will a client's year use?

Each page of PDF uses one page of credit. Lite gives you 500 pages a month for $29 USD, Standard 1,250 for $59 USD, and Plus 5,000 for $99 USD. Standard and Plus add the Xero, QuickBooks and FreeAgent files. Lite gives Excel and CSV. An annual plan gives you the year's pages at once. You can cancel any time.

Which banks can you read?

We read statements from the columns on the page, not from a template for each bank. That works for most banks whose statements print the transactions as a table with a running balance.

My client's PDF has a password.

Drop it in as it is. We ask for the password, use it once to open the PDF, and do not store it.

Does anyone else see my client's statements?

No person reads statements you upload. We encrypt the PDF. Once the statement is in your account, we delete the PDF as soon as it is converted. We keep the spreadsheet for a while, then delete it too. If you drop a statement in and do not sign in, we delete it. Our privacy policy says what we keep, and for how long.

Other use cases

Start with this month's statement

We read every row, check every balance, and give you a file for your spreadsheet or your books.

Start your free trial