Calculated Balance Report

The Calculated Balance Reconciliation Type is used to compare the General Ledger account balance to a specific detailed calculation that would be prepared by the accountant. There are several examples of this report type and you can get to them all from the Calculated Balance Reconciliation Type page.

Here is one of the sample reports for the Allowance for Doubtful Accounts account.

Major Report Elements

• The top of the report shows the account number, the account name and the date of the reconciliation.
• The Calculated Balance was input when preparing the reconciliation along with a description of the basis of the calculation.
• The reconciling item appears in the Reconciling Items section and shows the date the item occurred and the amount of the item.
• The General Ledger Balance was entered when preparing the reconciliation, and the Unidentified Difference is calculated by RecWizard. If all reconciling items had not been included, the Unidentified Difference would show the amount not yet identified and reconciled.
• The persons preparing, approving and reviewing the reconciliation, and the dates of their actions, are shown next.
• The Comment area shows some additional information that the person reconciling the account thought was important to clarify this account balance. The Comment will only appear for the month the Comment was written. It will not repeat in any other month.
• As a reminder of what should be done, the Account Description and Company Policy and/or Procedure is shown every month.

While you may want to live in a totally "electronic environment", it is normally a good practice to print your reconciliation report and keep it in a file with any appropriate copies of supporting documentation.

Return to TOP