Statement Roll Forward Details
Statement Date - The statement date entered should be the date of the bank statement that is being used to reconcile the checkbook. The transactions that fall outside that date will still be shown in the list, but the ability to mark them as cleared will be disabled (the checkbox will not be present for those items).
Last Statement Balance - The last statement balance pulls from the statement balance used in the prior reconciliation. This value will be zero if no reconciliation has been performed on the account.
Checks - The number of items and total for the CLEARED checks.
Deposits - The number of items and total for the CLEARED deposits.
Interest Income - The number of items and total for the CLEARED interest income.
Bank Charges - The number of items and total for the CLEARED bank charges.
Other - The number of items and total for the other CLEARED items.
Current Statement Balance - The amount entered by the user as the ending balance of the current bank statement being used to reconcile.
Unreconciled Difference - The difference between the Cleared Items and the Current Statement Balance. The equation used to calculate this value is: (Last Statement Balance - Checks + Deposits + Interest Income - Bank Charges +/- Other Items) - Current Statement Balance. This total must be equal to zero before the statement may be reconciled.
Bank reconciliation details
G/L Balance Date - The date that the user selects to balance the bank reconciliation to the balance as shown in the cash account in the general ledger. This date may be any day on or after the Statement Date.
Balance per Bank Statement - The value pulls the amount from the Current Statement Balance on the Statement Rollforward Details section of the reconciliation.
Outstanding Checks - The number of items and total for the IN TRANSIT checks.
Deposits In Transit - The number of items and total for the IN TRANSIT deposits.
Other Items in Transit - The number of items and total for the other IN TRANSIT items.
G/L Balance Per Analysis - The difference between the Balance Per Bank Statement and the In Transit items. The equation used to calculate this value is: Balance per Bank Statement + Outstanding Checks - Deposits In Transit +/- Other Items.
Unreconciled Difference - The difference between the G/L Balance as of Balance Date and the G/L Balance per Analysis. The equation used to calculate this value is:
G/L Balance as of Balance Date - G/L Balance per Analysis.
If the bank account after reconciliation is in balance with the amount that the general ledger shows to be in the cash account, then this value will be zero. If this value is not zero, then the accounts are out of balance and the user should investigate. Unposted journal batches, unrecorded transactions or improperly recorded transactions may be the culprit.
G/L Balance as of Balance Date - The amount here is the amount that is in the general ledger cash account for the cash account assigned to this bank as of the G/L Balance date selected.
<![CDATA[ ]]>
Related topics
