Reconciliation Statement

Form ID: (CA627000)

This report displays information about reconciled and unreconciled disbursements and receipts for the specified cash account and the reconciliation statement that has been entered on the Reconciliation Statements (CA302000) form. The report also shows the beginning balance of the bank statement and the cash account balance as of the statement date.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

See The Generated Report for information about the generated report.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Cash Account: The cash account for which the report will display information. You must select a cash account.
  • Ref. Number: The reference number of the reconciliation statement for which you want to review transactions.
  • Show Reconciled Transactions: A check box that you select to review a list of reconciled transactions. By default, the check box is cleared.

The Generated Report

This section describes some key elements of the generated report to help you use this report successfully. The header of the report shows the following rows.

Row Value Comments
Last Reconciliation Date The last reconciliation date from the selected reconciliation statement.
Statement Beginning Balance The beginning balance of the statement.
Reconciled Disbursements (N items) The total amount of the reconciled disbursements as of the reconciliation date that is specified on the Reconciliation Statements (CA302000) form. This row of the report lists all Disbursement cash transactions included in the reconciliation statement. N represents the number of items that are reconciled disbursements.
Reconciled Receipts (N items) The total amount of the reconciled receipts as of the reconciliation date that is specified on the Reconciliation Statements form. This row of the report lists all Receipt cash transactions included in the reconciliation statement. N represents the number of items that are reconciled receipts.
Statement Ending Balance The ending balance of the reconciliation statement.
Unreconciled Disbursements The total amount of the unreconciled disbursements as of the reconciliation date that is specified on the Reconciliation Statements form. This row of the report lists all Disbursement cash transactions that meet the following criteria:
  • The cash account of the transaction is the same as the cash account specified in the reconciliation statement on the Reconciliation Statements form.
  • The Payment Date of the transaction is earlier than or the same as the statement date.
  • On the Reconciliation Statements form, the Reconciliation Date box is empty, or its date is later than the statement date.
Unreconciled Receipts The total amount of unreconciled receipts as of the reconciliation date that is specified on the Reconciliation Statements form. This row of the report lists all Receipt cash transactions that meet the following criteria:
  • The cash account of the transaction is the same as the cash account specified in the reconciliation statement on the Reconciliation Statements form.
  • The Payment Date of the transaction is earlier than or the same as the statement date.
  • On the Reconciliation Statements form, the Reconciliation Date box is empty, or its date is later than the statement date.
Cash Account Balance The balance of the selected cash account as of the bank statement date.
Difference The difference amount, which is calculated based on other values of the report according to the following formula: Difference = Cash Account Balance – Statement Ending Balance – Unreconciled Disbursements + Unreconciled Receipts. This difference can usually be explained by documents that are dated later than the statement date and were reconciled in this statement or previous statements because they are included in the Statement Ending Balance amount shown on this report but not in the Cash Account Balance amount.
Reconciled Documents Dated After <Statement Date> The total amount (receipts – disbursements) of the documents that have a Tran. Date later than the reconciliation date on the Reconciliation Statements form and that were included in this reconciliation statement and previous reconciliation statements for the same cash account. This row of the report is displayed if this amount is not 0.