Pricing
Download
Support
Customer
Getting Started Notes
IMPORTANT NOTES
Before importing into Quickbooks,
back up
your Quickbooks company file before importing
Before importing into your accounting softwre,
back up
your accounting software data file before importing
Before importing into Quicken,
back up
your Quicken or other accounting software data file before importing
When converting from CSV or Excel files.
Check dates - You can choose how dates are shown after parsing, you can adjust the input date format as the output date format if applicable
Expenses must be negative and payments to the account positive, use Change +/- once per file
Look for any reported issues on the Issues tab and fix them.
Transactions tab shows data after parsing. Click the Review Mapping button to reassign columns
Your CSV/Excel file must have the Category column with expense/income names as in QuickBooks
OFX/QBO/QFX files do not carry categories (expense/income account names), you can map the category as a memo
Use Account Name, Account Type columns in Review Mapping for multiple accounts on the same CSV/Excel file only
When converting from PDF files
Try the OCR option for better parsing
Check dates - You can choose how dates are shown after parsing, you can adjust the input date format as the output date format if applicable
Expenses must be negative and payments to the account positive, use Change +/- once per file
Double-click the individual amount to adjust the sign of the specific amount
When converting from QIF files
Check dates - You can choose how dates are shown after parsing, you can adjust the input date format as the output date format if applicable
When converting to CSV/Excel
Select CSV target to create CSV layout your accounting software expects
Choose the output date format that is needed
When converting to OFX/QFX/QBO
Account Type - Checking or Credit Card, make sure to select it before converting.
Account Id - Enter the actual account number, change for different accounts
When converting to QFX/QBO
INTU.BID - Click the Look Up button to locate your bank or use any "allowed" value, for example. 3000 (Wells Fargo).
Bank ID - Leave empty unless you know you need to set it
When you convert to QIF
Set the QIF Target - select the application you would like to import into, if not listed, select "MS Money or other"
For the QIF target, as "MS Money or other" set the required date format
Learn More
QBO -
What is QBO (web connect) file format
QFX -
What is QFX file/format and how to open it?
OFX -
What Is OFX File Format and How to Open it?
QIF -
What is QIF file/format and how to open it?
Quicken -
How To Import QIF or QFX into Quicken
QuickBooks -
How to import transactions into Quickbooks
Related articles
How to Convert CSV to QFX Quickly and Easily
Convert CSV/Excel to QIF and import into Quicken, Banktivity, MYOB #quicken
What are OFX, QFX, QBO (Web Connect) files?
How to Convert Bank Statement PDF to CSV
Convert PDF to OFX
Convert PDF statements to a QuickBooks-compatible format
Convert PDF to QFX and import into Quicken Classic