How to use Bank2CSV
This tutorial shows how to use the Bank2CSV utility and convert PDF, QFX, QBO, OFX, QIF, MT940 to CSV.
Use the ProperConvert app to convert your transaction files to required by your accounting software file format.
Step by step instructions
Click the ''Download'' button.
And then select Windows or macOS version to download.
Once downloaded and installed, start Bank2CSV. Read the welcome message that provides the main points about the conversion process.
Select a file with transactions that you would like to convert. It could be a PDF bank or credit card statement, QIF, or QMTF file exported from Quicken or other accounting software, OFX, QFX, QBO, QIF, STA, or MT940 file downloaded from online banking.
Review transactions before converting, make sure dates are correct, expenses are negative and payments to the account are positive.
Select the CSV target depending on which accounting software you need to import the converted file. We will select Regular CSV, Quickbooks Online, and Xero as three examples. Depending on the selected target different columns are exported.
Set the “Open after save” checkbox if you would like the software installed on your computer to open the created CSV file. If you have Excel installed, it would be Excel to open the CSV file.
Click the ''Convert'' button.
And confirm the filename and the file location.
For CSV Target "Regular CSV" the converter exports all columns you see.
For CSV Target "Quickbooks online" the converter exports Date, Description, Amount.
For CSV Xero, the converter exports more columns: Date, Amount, Payee, Description, Reference, Check Number.
Related articles
- Convert CSV General Journal Entries to QBJ and import into Quickbooks Desktop
- Convert OFX files to QIF and import into Quicken
- Convert QBO files to CSV (QBO2CSV)
- Convert QIF files to CSV/Excel (QIF2CSV)
- Convert PDF to CSV/Excel (how to use PDF2CSV)
- How to use the Transactions app
- Convert OFX files to CSV or EXCEL format and Import into Excel, QUICKBOOKS Online, Xero, YNAB