AugTool Documentation
Import of Bank CSV and OFX
Once you have created your bank and linked it to your chart of accounts you can click on it and import your bank statement by clicking on the blue arrow Import icon.
The bank statement can be uploaded using either CSV or OFX. For CSV, you need to remove the header information from your CSV file leaving the column headers only. You also need to ensure that there are no empty line items at the bottom of the file. In the future, we will be enhancing this feature to gain access directly to your bank in real time. Our system only currently recognizes imports that have columns for date, description, debit and credit (or one column for debits and credits) and a balance column. If your bank does not give you the option to download in this format you will need to manipulate your csv file before you import it.
The file column names we expect is as follows:
"date" or "effective date" | "description" | "amount" | "debit" or "debit amount" | "credit" or "credit amount" | "balance"
We do not care in what order the columns are in but rather what column names there are. The system intelligently matches against : date, description, amount, debit, credit, balance. If the amount column imports, it assumes that the file format does not require debits and credits and works out the debits and credits according to the sign in the amount column (negative or positive). If that column does not exist, it assumes that the file format has a debit and credit column and imports those for the amount.
Some banks provide you with your csv in oldest first order of transactions and others in newest first order. Before clicking on submit, please indicate to the system what order your bank file is in. The system will try to detect the order but please ensure that the order is correct. This is important because it will ensure that the bank balance from your bank is picked up correctly by Augtool.
The description field can only be 200 characters long. Any description longer than 200 will be truncated.
When you upload a bank file the system checks three things on each line to eliminate duplicate uploads. Augtool checks the date, description and amount on each line. If it finds a duplicate one previously uploaded line that matches the one it is trying to upload for all three checks, it ignores that line. This means that you can download a bank statement for a month every day and upload that and the system will only accept the difference.
Date Format Selector on Bank Import
As statements are downloaded from the bank in different date formats the system has been enhanced to accommodate different date formats. This can be setup on the Import Tab. It can also be changed on the actual bank import which will override the Import tab.
The system was designed to import different date formats which you might still be able to do without changing anything however if you experience a date format error then this can be used by simply choosing the date format on Augtool that matches your bank statement, before importing.
