Importing Bank Transactions in CSV Format

Before importing your bank transactions, you need to download the CSV file from your online banking account.  Please contact your financial institution if you need assistance finding out how to do this.

You can locate the file in your downloads folder. You can then move it to your desktop or any other preferred location.

In AgExpert Accounting, select Banking, Bank accounts, identify your bank account, and Upload Statement at the end of the row.

Click Import.

Select the bank account you will be importing transactions for and click Browse to upload your csv file. 

Some files have the amount of the transaction as a single column, and others have deposits in one column and withdrawals in another.  You will want to tell the tool if you need one or two columns for the transaction amount.

Another screen will open that will allow you to work with the CSV file you have selected. 

If your file contains 1 column for the transaction amounts, under the Transaction amounts are drop-down, select One column.

Box 1 allows you to assign setup options for the CSV file itself.

The toggle for the header row should be on if each column in the preview box has a name (such as Transaction Date).  If there are no names, and each row is just a transaction, you will want to turn this toggle off.

If there is a header row, and it is not at the top, you can enter the row number the header is on using “Header row is online”.

Finally, if you only want to import a block of transactions, you can tell the tool which range of transactions to import.  This is useful if the file contains some transactions from the prior or the next month that you either have already dealt with or want to deal with later.

Box 2 will allow you to map your columns to an area of the transaction screen in Accounting.  Every financial institution uses a different format, so there is some flexibility to make sure your file imports correctly.  Using the preview in box 3, make sure to map the transaction date and format, description, and transaction amount columns. 

You will want to refer to the Preview in box 3.  As you change options, the preview will adjust, and you will want to make sure everything looks the way you expect before saving.

Make sure the preview in box 3 looks correct before continuing.

Click Review once you are ready to continue.

The next screen will display your transactions using the format provided.  It will also show if any transactions were excluded.  You can go back and fix things if needed by clicking Change import options on the top left.

At the bottom right, give a name to this template so that you can use it in the future without having to set things up from scratch.  Click Import when done.

The larger screen will disappear, and you will be given a basic import screen where you can select to import each individual transaction.  Import these transactions as normal, coding them to the correct accounts as normal.

If your file contains 2 columns for the transaction amount, you will be able to map your withdrawal amount and your deposit amount.

Note: In your csv file, make sure you don’t have any  $ signs and all numbers must be positive, even your money out (withdrawals).

Choose your import options and click Review.

At the bottom right corner, you can give a name to this template so that you can use it in the future without having to set things up from scratch.  Click Import when done editing the options and review your transactions.

Click the plus sign beside each amount, one at a time, to edit the transaction.

Choose the Supplier (or Customer for deposits), select your account. Once all errors have cleared, click Save and Next to move to the next transaction on the list, or Save and Close, if you want to select any other transactions.

When all the transactions have been recorded, you can click Done to complete the import.

Last updated on January 4, 2026 by FCC AgExpert