From a PDF bank statement to QuickBooks
When the bank feed does not go back far enough, or the client only has PDF statements, you can still get the transactions into QuickBooks without typing them.
1. Convert the statement
Drop the PDF in the converter, check that the balances add up and press Download QBO (QuickBooks). If you keep several accounts in QuickBooks, type the account number first: it is only written inside the file, so QuickBooks can tell your accounts apart.
2. Import it into QuickBooks Online
Go to Transactions > Bank transactions, open the Link account menu and choose Upload from file. Select the .qbo file and pick the account it belongs to.
3. Or into QuickBooks Desktop
Go to File > Utilities > Import > Web Connect Files, select the .qbo file and choose the account.
Good to know
- Each transaction carries a stable identifier, so importing two statements that overlap does not create duplicates.
- A QBO file has to name a bank that QuickBooks recognises. The file uses a generic one, so QuickBooks may show a different bank name during the import. It does not change your transactions.
- One file is one account. If a PDF contains several accounts, download Excel or CSV instead.
- The files are checked with an OFX validator. If QuickBooks rejects yours, please tell us with the “send diagnostic” link under the result.
Xero, Sage, FreeAgent and others
Use Download OFX: it is the same data in the standard format those programs import. CSV and Excel are always available too.
Checking the balances is free, so you can see the statement was read correctly before importing anything.
Convert a statement