Bank Transactions

Overview

The Bank Transactions page enables you to record bank transactions and import bank them from your online banking accounts so you can track the flow money into and out of your business.

Actions

The Transactions List follows the standard List Page Actions paradigm.

The list has several additional actions:

IconActionDescription
Expand line item.Will expand reconciled line items to display the reconciliation data.
Unreconcile.Will un-reconcile any selected bank transactions.
InformationFor imported transactions, will display all available data.

Column Definitions

ColumnDefinition
DateThe date the bank transaction occurred.
DescriptionThe description field from the bank statement. Because different banks record transactions in different ways, this may be a combination of fields from the bank statement.
ReferenceThe reference field from the bank statement.
Other PartyThe Other Party the money came from or went to.
CreditThe money value for credit (positive) transactions.
DebitThe money value for debit (negative) transactions.
BalanceThe balance of the bank account after the transaction is applied.
ReconciledDisplays whether the transaction has been reconciled or not.

Filters

The bank transactions list can be filtered to just show transactions that are of interest. The filters are combined, so that for a transaction to be displayed, it must satisfy the criteria of all the filters that have been applied, plus any list filters that are in effect.

Date filter

The date filter will specify a range of dates within which the transactions must fall. Multiple pre-defined ranges are available to select, or a custom range can be specified with an exact start and end date.

Date filter

If Seasons have been defined, the current season will be available as an option.

Type filter

The type filter can be used to restrict the transactions to those of a certain type or status.

Type filter

Filter valueMeaning
AllNo filter is applied.
UnreconciledOnly transactions with a reconciled flag set to false will be displayed
CreditOnly transactions with a positive value (money in) will be displayed
DebitOnly transactions with a negative value (money out) will be displayed

Tag filter

The tag filter will restrict the display to transactions that have been reconciled and have been tagged with one of the selected tags.

Tag filter

Multiple tags can be selected. A transaction only needs to be tagged with one of the selected tags to be included for display.

Import bank Statement

Although bank transactions can be added manually, it is much quicker and easier to import them directly. Go to your Bank’s online banking portal and download the transactions for the current month. iAgri bank statement import supports the Quicken (.qif) format and the Comma Separated File (.csv) format for many banks.

Now in iAgri, Click on the Bank Account Name to open the bank account. The system will display the Transaction page for the Bank Account. There are of course, no transactions to display yet.

Click the button at the top right of the page to begin the import process. The system will display the statement import dialog:
Import dialog

From the Bank dropdown, select the format of the statement you have just downloaded. Use the “Browse…” button to browse to your computer’s Downloads folder and select the file you have just downloaded from your bank. Click the “Import” button to import the transactions.

The system will import the transactions from the statement file and display them in the transactions list.

Reconcile transactions

Click the button to open the reconciliation page