Import Statement#

Importing statements are supported for both liability and asset accounts.

Supported File Formats#

CSV#

Csv files are extremely common and readily available from most financial institutions. At this time, we look for the following columns:

• Date
• Description
• Amount - The Amount of the transaction.
  Note: A positive value will be interpreted as a Payment, and a negative amount will be interpreted as a Receipt.
• Reference - (optional) This is an extra “reference code” that is part of the transaction.

Review your source file to ensure you have the proper column names, or the import will fail.

At a later date, we are looking at building a column mapping tool.

Ofx/QBO#

Dependent on your financial institutuion, they may offer a statement download of either QuickBooks, QBO, Ofx, or similar. All of these options are based on the Ofx standard. When you are initiating the import, choose the file, and continue. No manual edits will be required in the document.

One word of caution on this. Ofx files support a Currency type, and if that does not match the default currency of your company, the import process will fail. A resolution to this is scheduled for a later release.

Mapping#

Once the source file has been parsed, you will be given a screen that has each transaction listed, along with a dropdown to select which Revenue/Expense account the item should be assigned to. Simply select the account. Once completed, click the Next button.

You will now be at the Confirmation screen. This gives you a chance to make sure you are happy with your assignments. If so, you will need to check-off the I am satisfied with these values checkbox, then click Confirm. If you wish to not import this statement, click the Cancel button.