How to import a CSV file into AccountEdge Pro
This tutorial shows how to import CSV/Excel file into AccountEdge Pro 2015. We will use the CSV2OFX utility. IMPORTANT: CSV2OFX is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.
AccountEdge Pro 2015 imports OFX files, but doesn't import CSV/Excel file with transactions. To import a CSV file we're gonna first convert it to an OFX file, using the utility, called CSV2OFX from ProperSoft.
Start CSV2OFX and select a sample.csv file. In your case, you're gonna be selecting a file with your transactions.
There are several things to watch for first. Amount of your CSV file: expenses should be negative and payments to the account should be positive. If it's a Checking Account or Credit Card, for both cases Amount for expenses, withdrawals from the Account, like when you buy something with Credit Card - it's an expense - this Amount should be negative and payments to the Account - deposits - they should be positive.
You can use the 'Change +/-' button to reverse. You usually need to use this button in case your Credit Card CSV file has expenses as positive Amounts and payments to the Account are negative Amounts. So they should be reversed before converting to the OFX file.
On the right side, you can select Target. It has different software. For AccountEdge we just select the Regular OFX file. You can select Account Type, Account #, Currency, even enter Balance on the OFX file. Usually, list things that are not so important, but you can set them.
Click the 'Convert' button and save the OFX file.
Go back to AccountEdge, look for 'Bank Register', and click on it.
Then click 'Bank Statement'.
Look for 'Import Statement'.
Go to the location OFX file and click 'Open'. We see that four transactions in the bank statement file, four transactions imported, zero transactions skipped. Click 'OK'.
Now you can see, that negative amounts are imported as Withdrawals and positive amounts are imported as Deposits. Cheque # and Payee are imported. You have to set an Account, like expense or income account in your accounting, like how you defined this specific expense or specific income. It seems the OFX file itself is a bank statement download. Bank doesn't know about your accounting or how you categorize your expenses for one company. Home Depot expense could be a utility or could be office supplies for other companies, or building supplies, or things like that. So, basically, if you have CSV or Excel file and you need to import into AccountEdge, you can use the utility from ProperSoft CSV2OFX and the tool allows you to convert CSV or Excel files to OFX format and import them into AccountEdge.
