On the Unreconcile screen you can unreconcile data entered in the Transactions - Bank processing - Reconciliation screen.
From the Transactions Records menu choose Adjustments & reversals and select the Unreconcile tab.
From the Bank account drop-down list, select the bank account or fund you want to unreconcile. If you have the Reference or Date for this reconciliation, enter it in the relevant box.
The relevant transactions are listed. Under Transaction groups, select the line you want to unreconcile (if there are many entries, scroll through the list or use grouping or sorting as described below).
Under Group details, details of the selected entry are listed.- Check the information against your bank statement or transactions list.
To unreconcile a transaction, set the Reconciled toggle to No. Alternatively you can use the check box at the top of the column to toggle all items in the list. - Repeat steps 2-4 to unreconcile additional lines.
- When you have finished marking any grouped or single transactions that should be unreconciled, click Update.
- Check the information in the Unreconcile pop-up window. To confirm, click Update.
(If you want to return to the previous screen without updating, click Cancel.)
The screen is refreshed to remove the unreconciled items and update the Reconciled total value. A green message bar confirms that the unreconcile was successful.
At the bottom of the Transaction groups list, the Reconciled total value shows the total amount of the transactions that have been reconciled so far. After reconciliation this total should match the closing balance on the bank statement. You can also view the projected reconciliation total, by clicking the Reconciled total icon to display a pop-up window:
At the bottom of the Transaction groups list, the Reconciled total value shows the total amount of the transactions that have been reconciled so far. After reconciliation this total should match the closing balance on the bank statement. You can also view the projected reconciliation total, by clicking the Reconciled total
icon to display a pop-up window:
To Group the Transactions
If you have many transactions, it's a good idea to group them in a way that makes them easy to find and reconcile against your bank statement or transaction list. By default the transactions are ungrouped.
Click the Group by icon. A Group by settings pop-up is displayed, allowing you to choose groupings at up to 3 levels.
- From the First group by drop-down list, choose the primary way to group the transactions.
It is often convenient to first group by Reference. - If required, choose a secondary grouping from the then by drop-down list.
- If required, choose a third grouping from the finally by drop-down list.
- If you want to Allow mixed transaction types (i.e. Income and Expenditure grouped together), tick the box.
- By default gross amounts are displayed in the transaction list. If you want to show Nett values, tick the box.
- When you have finished, click Save.
- If you want to store these settings as the default for this bank account, click Yes; otherwise click No.
To Sort the Displayed Transactions
You may want to sort the transactions to make them easy to find and reconcile against your bank statement or transaction list. By default the transactions are listed by date.
Click the Sort icon. A Sort by pop-up is displayed.
- Select the required sorting option.
- Click Save.
Comments
Article is closed for comments.