Overview
Excerpt | ||
---|---|---|
A bank reconciliation is a process that explains the difference between the bank balance shown in an organisation's bank statement (as supplied by the bank) and the corresponding amount shown in the organisation'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. Please ensure that the last bank reconciliation for a financial year is the last day of June - the system will not allow you to extract into the next month. 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 bank reconciliation must represent the closing bank reconciliation from your old system and must balance back to your general ledger bank account. For the first bank reconciliation, 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 bank reconciliation. Bank reconciliations are set to compress depending upon what rules have been set up against each tender (usually set up by Readysell at commencement of business). As well as making it easier to navigate the bank reconciliation, these compressed figures are used to guide the automatic matching and automatic generation features based on the tender and bank reconciliation rules. All transactions on a bank statement that relate to a card should be entered onto the card not through the bank reconcilation as a manual entry. |
Note |
---|
There is a system reference under the name of cashbook code = BANK-RECONCILIATION-AUTO-MATCH-DAYS with a value. This has a default of 9 days. The field 'Matched Reference' on a bank reconcilation line is filled in at the time you import the bank statement line using the comments in the 'text' field from the bank statement line once a auto match is found based upon, date, value etc. |
Getting Started
Child pages (Children Display) | ||
---|---|---|
|
...
Image | Field | Description |
---|---|---|
Extract Bankings | Extract bankings readysell banking transactions into this bank reconciliation | |
Import Transactions | Import bank transactions from the Exported Bank Statemnet Statement into Readysell for automatic matching and automatic transaction generation | |
Generate Corrections | Generate corrections for a banking that will create either a bank payment / bank deposit based on the value in the correction column. This action button should only be used for minimal variances usually where cash varies between what is banked and what is recorded in Readysell. If a transaction value for a source transaction has been entered incorrectly, ensure that you fix the source transaction on the card. | |
New Banking | Create a new banking in this reconciliation being either a bank deposit/bank payment or bank transfer |
Fields
Field | Description |
---|---|
Date | Date created for the Bank Reconciliation |
Number | Bank Reconciliation transaction number |
Status | Status of the Bankrec |
Account Site | BAnk Bank Account General Ledger Account |
Statement Open Date | The statement opening balance date for the Bank Reconciliation, This value is Populated from the closing balance of the last bank statement. |
Statement Open Balance | The statement opening balance for the Bank Reconciliation. This value is Populated from the closing balance of the last bank reconcilation reconciliation for that bank account. Equals Statement Closing balance from the previous bank reconciliation for that bank account |
Unpresented Balance | Expected GL Closing Balance - Computed Closing Balance. The sum of the items not yet marked |
Statement Close Date | The Statement Closing Date. This is a manual entry from the Bank Statement. The date you are last reconciling to. |
Statement Close Balance | This is the statement closing balance for the Bank Reconciliation and is entered from the Bank Statement. This is not calculated. |
Value Marked | Sum The sum of the transaction value of marked Lines, this field shows the value marked for the Bank Reconciliation |
Comp GL Close Balance | Statement Opening Balance + Total Value (all readysell transactions within the bank rec), also known as the 'Expected expected General Ledger closing balance' |
Comp Close Balance | Statement Opening Balance + Value Marked, this is the computed closing balance |
Actual GL Close Balance | 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 also known as the "Statement Variance" |
...
Field | Description |
---|---|
Date | The date and time of the banking (source record date) |
Tender | The tender that was used for that source of banking |
Site | The site of the banking |
Workstation | The workstation for that source banking |
Transaction Number | The source transaction number |
Card | The card that relates to this banking |
Description | The description of the source transaction |
Payment Reference | This is the payment reference entered onto into the Customer Payment or Supplier Payment at the time of entry |
Transaction Value | This is the transaction value for this line or the Sum of all transactions for the tender |
Corrected Date | Manual entry of the date |
Corrected Value | Mnaual Manual entry of what the value should be. |
Marked | Check this box to mark the line |
Matched Reference | This is the matched reference value from the Imported Bank Statement |
Value Excluding Fee | This line shows the value excluding fee for this line |
Buttons | |
Show in report- Shows banking records in a report | |
Show the oriignal original transaction that generated this banking | |
References | |
Date | The date and time of the banking record |
Card | The Cardid of the source transaction |
Transaction Number | This is a unique transaction number for the source banking record |
Payment Reference | This is the payment reference for the source banking record |
Description | This field contains a short description of the source banking record at the time of entry |
Presented date | The date and time that the payment was presented |
Value | This field shows the value of the banking record within a bank reconcilationreconciliation |
Value Excluding Fee | This field shows the value of the banking record, excluding fees |
...