The Bank Reconciliation module allows you to reconcile your bank accounts to ensure that all transactions are entered. You may reconcile all your bank accounts. You can reconcile your bank account as often as needed.
This module can be added to the menu by selecting Type = Fixed and then selecting Bank Reconciliation in the Module column.
Navigation: Main Menu > Accounting > Bank Reconciliation.
Table of Contents
Navigation: Main Menu > Setup > Settings > Users (tab)
Accounting > Banking (Import and Reconciliation) - Access Allowed: Tick the checkbox to allow access.
The List View displays a summary of Bank Reconciliations.
View: Generates a List View according to the selected Data Filters.
New: Creates a new Bank Reconciliation.
Menu:
Reset Data Filter: Resets all the selected filters.
Layout & Grids:
Save
Save (All Users)
Restore Default (All Users)
Set: Sets a specific time frame such as Today, This Month, This Year, Fin Year etc.
Dates: Filters the data according to the selected Start and End Dates.
← →: Adjusts the Date forwards or backwards based on the selected time frame.
Bank: Dropdown list from which a Bank Account can be selected.
Status: Dropdown list to filter transactions that have a Pending or Complete Status.
Some of the fields are hidden by default. They can be added in using the Field Chooser (*).
ID: An ID is automatically assigned to each bank reconciliation in sequential order.
Status: The Status of a Bank Reconciliation.
Date: The Date selected for a Bank Reconciliation.
Account: The Bank Account that was reconciled / is being reconciled.
Statement: The Bank Statement's balance that was typed in.
Dr Uncleared: The value of Debited transactions that were not cleared.
Cr Uncleared: The value of Credited transactions that were not cleared.
Adjusted: The Total of items marked as reconciled.
Ledger: The balance of the bank account in the Ledger.
Variance: The difference between the Adjusted and Ledger columns.
Note: Any Notes typed in during the Bank Reconciliation.
...: Submenu to Edit or Delete a Bank Reconciliation.
The Edit View is used during the process of reconciling a bank account.
⬆ ⬇ : Use the arrows to scroll through transactions.
New: Creates a new Bank Reconciliation.
Delete: Deletes the Bank Reconciliation.
Save: Saves or Refreshes (recalculates) the information.
Done: Sets the Bank Reconciliation transaction to a Complete Status.
Menu:
Email Excel
Detailed Ledger: Emails the bank ledger account.
Bank Statement: Emails a list of cleared transactions.
Layout & Grids:
Save
Save (All Users)
Restore Default (All Users)
Add: Adds a Transaction (or multiple transactions) to the Bank Statement.
The Statement Date on the transaction will be set to the Bank Reconciliation date and the Status will be set to the default Reconcile Status of the Transaction Type.
Remove: Removes a Transaction (or multiple transactions) from the Bank Statement.
The Statement Date on the transaction will be cleared and the Status will be set to the first Accounting Status for the Transaction Type.
Header
Status: The Status of the bank reconciliation.
Account: The Bank Account being reconciled.
Date: The Reconciliation Date (should be the last date on the bank statement).
The date must be later than the previous reconciliation date.
Duplicate dates are not allowed.
Balance as per bank statement: A field for the user to type in the balance on the bank statement as per the date selected.
Debit transactions not cleared: A running total of all uncleared debit transactions.
Credit transactions not cleared: A running total of all uncleared credit transactions.
Adjusted Bank Balance: The sum of all cleared transactions.
Ledger Balance: The Ledger Balance of the selected bank account.
Variance: The difference between the Adjusted Bank and Ledger Balances.
Detailed Ledger
Displays a list of transactions linked to the Bank Account where the Statement Date is blank and the Period Date is less than or equal to the Statement Date.
Field Chooser (*): Allows users to add or remove columns.
ID: The overall ID of the original item in a transaction.
TransID: The Transaction Type specific ID of the original transaction.
Status: The Status of the original transaction.
Type: A code indicating the original Transaction Type used to record the transaction.
No.: The Number of the transaction in the Ledger.
Where transactions are split across multiple accounts, this number can be used to reconcile those transactions: Users can select all the transactions with the same number. The total at the bottom of the debit or credit column will update and this total will match a single entry on the bank statement.
Period: The Period that was selected when the transaction was recorded.
Reference: The Reference that was typed in when the transaction was recorded.
Description: The Description that was typed in when the transaction was recorded.
Dr Account: The Account that was Debited.
Cr Account: The Account that was Credited.
Debit: The amount that was Debited to the bank account.
Credit: The amount that was Credited to the bank account.
Balance: A running total of the detailed ledger.
Bank Statement
The opening balance is the closing balance on the previous bank reconciliation.
Field Chooser (*): Allows users to add or remove columns.
ID: The ID of the order in the Bank Statement section.
TransID : The Transaction Type specific ID of the original transaction.
Status: The Status of the original transaction.
Trans: A code indicating the original Transaction Type used to record the transaction.
No: The ID of the transaction in the Ledger.
Period: The Period that was selected when the transaction was recorded.
Company: The name of the Supplier or Customer linked to the transaction.
Reference: The Reference that was typed in when the transaction was recorded.
Description: The Description that was typed in when the transaction was recorded.
Debit: The transaction amount that was Debited to the bank account.
Credit: The transaction amount that was Credited to the bank account.
Balance: Running total of the adjusted bank account balance.
A script can be used to set the Statement Date on existing transactions to the Period date - this will effectively remove transactions from the Pending list.
See Shared Drives/Downloads/BOS Enterprise 22/Scripts/BOS Ent 22 - Set Opening Bank Reconciliation.