Details of customer payments are imported into the system via a text or .csv file to be reconciled with system transactions. Once the details have been imported, you can reconcile them manually or automatically. You can also unreconcile them if the payments are unprocessed and create transactions if they are missing.
See also:
This form is displayed when you select Nominal Ledger > Bank & Currency Options > Import and Reconcile Statement.
| Menu | Icon | Description |
|---|---|---|
| File > Load Transactions |  |
Displays all unreconciled nominal ledger transactions for a specified account number in the Autoline grid. |
| File > Import |  |
Imports all transactions from the file sent from the bank and displays them in the Import grid. |
| File > Process |  |
Processes all reconciled transactions if both the Autoline and Import totals are equal. Note: If all the imported data has been reconciled, the system is automatically reset. If there are still imported transactions to be reconciled, the grid displays the unreconciled transactions. |
| File > Restart |  |
Clears all filter and grid information and displays a blank screen. |
| File > Exit |  |
Exits the form and returns to the Bank & Currency Options menu. |
| Tools > Autoreconcile |  |
Automatically reconcile payment and system transactions where a match is found. |
| Help > Help |  |
Displays this help file in your default browser. |
| Help > Legend | — | An explanation of the colour coding of the statuses of transactions displayed in the grid. They are:
|
Autoline Group:
Bank Account: The nominal ledger bank account that contains the unreconciled transactions.
Cut-off Date: The end date for unreconciled transactions. All unreconciled transactions created after this date will not be displayed.
Show Reconciled: If activated, all transactions are displayed, including reconciled ones. If de-activated, only transactions that are at unreconciled statuses are displayed.
Autoline Grid:
Date: Date the transaction was created.
Reference: The transaction reference, usually input by the transaction creator.
Amount: The value of the transaction.
Status: The status of the transaction. For example, reconciled, unreconciled.
Import Group:
Bank Code: The code input by the user that added the bank details via the Add/Modify Bank Details form.
Filename: The filename of the text or .csv file the bank sent. This file can be searched for.
Show Reconciled: If activated, all transactions are displayed, including reconciled ones. If de-activated, only transactions that are at unreconciled statuses are displayed.
Import Grid:
Date: The date that the bank transaction was created.
Reference: The bank transaction reference, usually input by the transaction creator.
Amount: The value of the bank transaction.
Status: The status of the bank transaction. For example, reconciled, unreconciled.<
Details of customer payments are imported into the system via a text or .csv file to be reconciled with system transactions. Once the details have been imported, you can reconcile them manually or automatically".
To import transactions:
Select Nominal Ledger and the company from the main menu.
The Nominal Ledger menu is displayed.
Select Bank & Currency Options.
The NL Bank and Currency Menuis displayed.
Select Import and Reconcile Statement.
The Import and Reconcile Statement form is displayed.
Input a nominal ledger bank account in the Bank account field.
The Load button is activated.
Note: You can input the bank account number by hand or click the Ellipsis button (![[...]](Ellipsis.gif){kind=small}
) to search for the account number.
Click Load.
All unreconciled nominal ledger transactions for the specified account number are displayed in the grid.
Note: If you input a cut-off date, only the transactions up to that date will be displayed. If you activate the Show Reconciled field, all transactions, including the reconciled ones will be displayed.
Input the Bank Code and Filename of the file to be imported.
the Importbutton is activated.
Note: You can input the bank code and filename by hand or click the Ellipsis button () to search for the account number.
Click Load.
All unreconciled transactions for the specified bank code are displayed in the grid.
Note: If you input a cut-off date, only the transactions up to that date will be displayed. If you activate the Show Reconciled field, all transactions, including the reconciled ones will be displayed.
Imported payments are automatically reconciled with existing system transactions where a match is found according to the following criteria:
To reconcile transactions automatically:
Import the transactions for reconciling.
The Autoline and Import grids display the unreconciled transactions.
Click Auto reconcile.
The system will find any possible matching transactions in the Autoline and Import grids and reconcile them.
Note: If two rows match and are reconciled, their status is set to A and they will be colour coded green.
The Autoline and Import totals will be incremented by the value of the reconciled transactions and deducted from the unreconciled totals.
When the Reconciled totals balance, the Process button is activated.
Click Process.
The details of the reconciled transactions are written back to the database.
Payments that are not processed, but have been reconciled with a system transaction can be unreconciled.
To unreconcile transactions:
Import the transactions for reconciling.
The Autoline and Import grids display the unreconciled transactions.
Do one of the following:
The transaction status is reset to blank (or C (White) if a posting was created)
If the reconciled transaction is set to A (Automatically reconciled), right click on it and click Yes when the Are you sure you want to undo the automatic reconciliation? message box is displayed.
The transaction status is reset to blank (or C (White) if a posting was created)
When the transactions are unreconciled, the Import transactions are also unreconciled.
Click Process.
The details of the reconciled transactions are written back to the database.