Statement converter
PDF bank statement to QuickBooks (QBO)
QBO here is an OFX file with the header QuickBooks looks for. It is a way to get a month of PDF activity into a register. It is not a bank feed, and QuickBooks will still ask you which account to use.
What is in the file
Checking and savings statements use a bank statement message, account type CHECKING, and the last four digits as the account id when we found them. We do not invent a routing number. The bank id is a placeholder, and you match the import to the real account in QuickBooks.
Card statements use a credit card message. A charge, which increases the balance you owe in our preview, is a negative amount in the QBO file. A payment is positive. That is the OFX convention, and it is the opposite of the signed amount column in the spreadsheet. The spreadsheet is the one that has to add up to the statement balance. The QBO file is the one QuickBooks can import.
What it will not do
It will not categorize expenses, match transfers, or replace a review. Names are shortened to the 32 characters OFX allows, and the full description is in the memo. Dates that are not a real calendar day are left out of the QBO file rather than posted as nonsense. Fix those rows and export again.
If the reconciliation badge is red, fix the table first. Importing an unbalanced month just moves the problem into QuickBooks.
Questions
Does this connect to my bank?
No. You upload a PDF you already downloaded. Nothing is linked to the bank, and we do not store the file.
Northline is not affiliated with the bank named on this page. This is not tax or financial advice. Compare the export to the original statement. Read the disclaimer.