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