You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 42
Next »
Overview
A Bank reconciliation is a process that explains the difference between the bank balance shown in an organization's bank statement, as supplied by the bank, and the corresponding amount shown in the organization's own accounting records at a particular point in time. If your account records does not agree with the bank statement you must determine where the discrepancy is and make the appropriate corrections. It is normal for a company's bank balance to differ from the balance as per bank statement due to timing differences. Such timing differences appear as reconciling items in the Bank Reconciliation. Bank reconciliations should be done by date Consecutively and Periodically. You cannot commence a new bank reconciliation until your current bank reconciliation is balanced and finalised for the Bank Account you are reconciling. The First Bankrec must represent the Closing Bank Reconciliation from your Old System and Must Balance back to your General Ledger Bank Account. For the first time bankrec, the site will need to provide readysell with the statement opening date and statement opening balance figure. Readysell will insert this for you as the starting bankrec.
Bank Reconciliations are set to compress depending upon what rules have been set up against each tender. Usually Set up by Readysell at commence of Business.
Getting Started
Reference
Refer to Common Buttons.
| Image | Field | Description |
|---|
 | Extract Bankings | Extract bankings into this bank reconciliation |
 | Import Transactions | Import bank transactions for automatic matching and automatic transaction generation |
 | Generate Corrections | Generate correction bank payments / bank deposits based on the values in the correction column |
 | New Banking | Create a new banking in this reconciliation |
Fields
| Field | Description |
|---|
| Date | |
| Number | |
| Status | |
| Account Site | |
| Statement Open Date | The statement opening balance date for the Bank Reconciliation |
| Statement Open Bal | The statement opening balance for the Bank Reconciliation |
| Unpresented Bal | Expected GL Closing Balance - Computed Closing Balance, the statement closing balance date for the Bank Reconciliation |
| Statement Close Date | |
| Statement Close Bal | This is the statement closing balance for the Bank Reconciliation |
| Value Marked | Sum of transaction value of marked Lines, this field shows the value marked for the Bank Reconciliation |
| Comp GL Close Bal | Statement Opening Balance + Total Value, the expected General Ledger closing balance |
| Comp Close Bal | Statement Opening Balance + Value Marked, this is the computed closing balance |
| Actual GL Close Bal | Bank Account GL Balance at Statement Closing Balance Date, this field shows the general ledger closing balance for this Bank Reconciliation |
| GL Variance | GL Closing Balance - Expected GL Closing Balance |
| Variance | Statement Closing Balance - Computed Closing Balance, also known as the "Statement Variance" |
Lines Tab
| Image | Field | Description |
|---|
 | Mark Selected | |
 | Unmark Selected | |
 | Mark All | |
 | Unmark All | |
Fields
| Field | Description |
|---|
| Date | The date and time of the bank reconciliation |
| Tender | |
| Site | |
| Workstation | |
| Transaction Number | Unique transaction number for this line |
| Card | |
| Description | The description of this line |
| Payment Reference | This is the payment reference for this line |
| Transaction Value | This is the transaction value for this line |
| Corrected Date | Corrected date is a date and time |
| Corrected Value | The corrected value |
| Marked | Check this box to mark the line |
| Matched Reference | This is the matched reference for this line |
| Value Excluding Fee | This line shows the value excluding fee for this line |
|
 | |
 | Show in report- Shows banking records in a report |
 | Show the transaction that generated this banking |
References |
| Date | The date and time of the banking record |
| Card | |
| Transaction Number | This is a unique transaction number for the banking record |
| Payment Reference | This is the payment reference for the banking record |
| Description | This field contains a short description of the banking record |
| Presented date | The date and time that the payment was presented |
| Value | This field shows the value of the banking record |
| Value Excluding Fee | This field shows the value of the banking record, excluding fees |