 |
 |
Bank Statements - Details Page
When you click on the View Record Details icon
for a specific record on the Bank Statements Search/Criteria Grid page, the Bank Statements Detail page opens for that record.
The following list defines every field displayed on the Bank Statements Details page:
- In the Main Context section, the Company, Bank Account Code and Statement Date display as reference information for the detail record you are viewing.
- In the Bank Reconciliation section:
- Bank Opening Balance - displays the Opening Balance from the bank statement. This field is manually entered when the statement is created and you can edit this field as required.
- Bank Closing Balance - displays the Closing Balance from the bank statement. This field is manually entered when the statement is created and you can edit this field as required.
- Deposits in Transit - calculated as all AR31 Cash Receipts that have not been assigned a statement date in the GL Transactions view and have a posting date that is less than or equal to the current statement date.
- Outstanding Checks - calculated as all checks (computer posted or manual) from AP43/AP51 that have not been assigned a statement date in the GL Transactions view and have a posting date that is less than or equal to the current statement date.
- Note: Checks that have been cancelled via AP81 do not display in the GL Transactions view.
- Outstanding Postings - calculated as the postings from AP31 and all journal entries from GL31 and GL80 in the GL Transactions view that have not been assigned a statement date and have a posting date that is less than or equal to the current statement date.
- Bank Errors - displays the Bank Errors that are not yet recorded on the bank statement. This field is manually entered when the statement is created and you can edit this field as required. You can enter a negative value in this field if the bank error removes money from your GL.
- Reconciled Bank Balance - calculated as the (Bank Closing Balance) + (Deposits in Transit) - (Outstanding Checks) +/- (Bank Errors).
- Bank Opening Balance - displays the Opening Balance from the bank statement. This field is manually entered when the statement is created and you can edit this field as required.
- In the GL Reconciliation section:
- GL Closing Balance - calculated as the balance in the GL Transactions view as of the current statement date.
- Bank Statement Unrecorded Credit Amount - displays the credit 'items' from the current Bank Statement that are not yet in the GL. For example, the bank charges, monthly fees or other credits that are not recorded by the depositor. This field is manually entered when the statement is created and you can edit this field as required.
- As part of standard accounting procedures, these unrecorded credits will be added to the GL by GL30/GL31 transactions. Once the current statement date is assigned to these transactions in the GL Transactions view, you must update this field to zero. Failure to do so will result in a duplication of these transactions in the bank reconciliation for the current statement date. For more information, see the Bank Reconciliation Overview topic.
- Bank Statement Unrecorded Debit Amount - displays the debit 'items' from the current Bank Statement that are not yet in the GL. For example, interest or additions/debits by the bank that are not recorded by the depositor. This field is manually entered when the statement is created and you can edit this field as required.
- As part of standard accounting procedures, these unrecorded debits will be added to the GL by GL30/GL31 transactions. Once the current statement date is assigned to these transactions in the GL Transactions view, you must update this field to zero. Failure to do so will result in a duplication of these transactions in the bank reconciliation for the current statement date. For more information, see the Bank Reconciliation Overview topic.
- Depositor Errors - displays the Depositor Errors from the bank statement. This field is manually entered when the statement is created and you can edit this field as required. You can enter a negative value in this field as required.
- As part of standard accounting procedures, the depositor errors will be added to the GL by GL30/GL31 transactions. Once the current statement date is assigned to these transactions in the GL Transactions view, you must update this field to zero. Failure to do so will result in a duplication of these transactions in the bank reconciliation for the current statement date. For more information, see the Bank Reconciliation Overview topic.
- Reconciled GL Balance - is calculated as the (GL Closing Balance) - (Bank Statement Unrecorded Credit Amount) + (Bank Statement Unrecorded Debit Amount) +/- (Depositor Errors).
- GL Closing Balance - calculated as the balance in the GL Transactions view as of the current statement date.
- In the Reconciled Variance section:
- Reconciled Variance - is calculated as the difference between "Reconciled Bank Balance" and the "Reconciled GL Balance". The variance will always be a positive number.
- Total Stmt Trans. - displays the number of transactions entered for the current statement. You can edit this field as required.
- Total Rec. Trans. - displays a count of all transactions in the GL Transactions view that have been assigned to the current statement date.
- Comment - displays the comment entered for the Bank Statement. This field is manually entered when the statement is created and you can edit this field as required. You can enter a maximum of 8,000 characters in this field.
- Reconciled Variance - is calculated as the difference between "Reconciled Bank Balance" and the "Reconciled GL Balance". The variance will always be a positive number.
The Related section at the bottom of the page contains links to related resources for the current record. The following link is available: GL Transactions.
For information on the functionality of each button on the Bank Statements Details page, click here.
