How to import a CSV file into AccountEdge Pro 2015

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.

How to import a CSV file into AccountEdge Pro 2015 Step 1: accountedge

Start CSV2OFX and select sample.csv file. In your case, you're gonna be selecting a file with your transactions.

How to import a CSV file into AccountEdge Pro 2015 Step 2: sample csv

There are several tins 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.

How to import a CSV file into AccountEdge Pro 2015 Step 3: review csv2ofx

You can use '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.

How to import a CSV file into AccountEdge Pro 2015 Step 4: change button

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 tins are not so important, but you can set them.

How to import a CSV file into AccountEdge Pro 2015 Step 5: target

Click the 'Convert' button and save OFX file.

How to import a CSV file into AccountEdge Pro 2015 Step 6: convert

Go back to AccountEdge, look for 'Bank Register' and click on it.

How to import a CSV file into AccountEdge Pro 2015 Step 7: bank register

Then click 'Bank Statement'.

How to import a CSV file into AccountEdge Pro 2015 Step 8: bank statement

Look for 'Import Statement'.

How to import a CSV file into AccountEdge Pro 2015 Step 9: 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'.

How to import a CSV file into AccountEdge Pro 2015 Step 10: transactions imported

Now you can see, that negative amounts imported as Withdrawals and positive amounts 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.

How to import a CSV file into AccountEdge Pro 2015 Step 11: amount imported

Related artciles