PDF Bank Statements to CSV and OFX
I need bank statement PDFs in a file format
If you need to get historical data into an electronic format and all you have are old bank statement PDFs our PDF conversion service can assist. Using a semi-automated process we tidy up the data, put transactions in the correct sequence, detect any potential gaps, test integrity, and send it back to you. Turnaround is typically less than 3 business days. We take historical bank statement PDFs and convert them into CSV and OFX files, clean and ready for you to use. For Pricing please see here.
How to convert your PDFs
- Zip your pdf files (keeping a separate PDF for each bank account - you can have multiple PDF's for the one bank account it will just mean multiple CSV and OFX files for that bank account).
- The initial page count and can take minutes or a bit longer depending on the number of pages. However, you will receive an email to pay for the job. Reply to the email if you do not wish to continue with the conversion having viewed the price to be charged.
- To continue, pay for the conversion.
- The conversion will take up to 3 business days, it can be longer for large jobs over 100 pages.
- Your CSV, OFX and completion report will be emailed to you upon completion.
What is converted in the CSV / OFX files?
You will receive three columns of data:
- Description - Descriptions that scroll over more than one line will be combined into one line.
If the bank statement pages submitted are missing data we will add a line to ensure the files balances against the bank statements.
What if I am missing bank statement pages?
As long as we have the opening and closing balance for that bank account we will add an entry to make sure the delivered files match the bank statements.
If you are missing the opening or closing balance we will be unable to perform our usual Quality Assurance checks though you will still receive files of what we have been able to convert.
Does it matter if it is a scanned copy of the bank statements?
Jet Convert service can process any bank statements, original or scanned, as long as the figures are human eye legible. Many bank statement readers can only process original bank statements.
How do I use the CSV / OFX files with my accounting software?
To import into Xero
- Download the attached file(s) to your computer. OFX is the preferred type by Xero.
- Go to your Xero Dashboard.
- For the bank account, click the drop-down arrow next to Manage Account.
- Select ‘Import a Statement’ and follow the instructions.
- Do this for each bank we have converted statements for.
To import into another accounting software type
- Check with your software provider as to the preferred file type for import.
- Download the attached file(s) to your computer.
- Refer to your accounting software instructions as to how to import bank statement data.
- Repeat for each bank we have converted statements for.
What are the advantages of using the Jet Convert bank statement conversion service?
Using a semi-automated process we tidy up the data, put transactions in the correct sequence, detect any potential gaps, test the integrity, and send it back to you. Even if descriptions wrap over two lines in the original bank statements, our service will ensure it remains in the one cell within your spreadsheet.
The Jet Optical Character Recognition (OCR) process provides automated testing along with a manual check of OCR failures. So what you get back balances perfectly against the bank statements supplied.
The bottom line is that we save you the hours and hours required to tidy up and correct spreadsheets generated using the DIY approach.
As long as the bank statements are English language-based, single currency and are human eye legible, then we can convert the statements into CSV / OFX for you.
Bank Account Mapping - Bank Account / Credit Card / Paypal / Asset / Liability Any account you want to reconcile in Xero, or receive bank feeds for need to be selected as a bank, credit card or PayPal. Each bank requires the accounts to be set up in ...
Bank Account Mapping
Bank Account Mapping is available with Insight and Accelerate Packages. Under the Standard Package we convert the chart of account based on the account type in the source file - for example: Bank Account, Credit Card, Paypal - Will be set up as such ...
Post Conversion Queries
Amending Conversion Balances Please see here for more information on how to Amend Conversion Balances Figures in Conversion Clearing Account Please see here for more information regarding conversion clearing accounts. Why do I have a Reconciliation ...
Bank Versus Asset/Liability Accounts
In Xero if you would like to be able to reconcile an account it needs to be a bank account, you don’t have to have linked bank feeds if not required. As such it is an operational decision whether it is a bank account or an asset/liability account. It ...
$0 balance invoices/Differences in the GST Reconciliation Report
Invoices that have positive and negative lines that result in the balance of the invoice being $0.00 are captured differently among accounting systems. These are sometimes used to Journal an amount from one account to another without creating a ...