This tutorial shows how to import CSV/Excel file into AccountEdge Pro 2015. We will use CSV2OFX utility.
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 to OFX file, using utility, called CSV2OFX from ProperSoft.
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 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 is negative Amounts. So they should be reversed before converting to OFX file.
On the right side, you can select Target. It has different software. For AccountEdge we just select Regular OFX file. You can select Account Type, Account #, Currency, even enter Balance on the OFX file. Usually, list things 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 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 Account, like expense or income account in your accounting, like how you defined this specific expense or specific income. It seems 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 company, 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.