Manually reconciling using reconciliation statements

• Verify that the reconciliation statement number and line number exist in the Cash Management Statement Records file.

• Displays the date, amount, reconciled amount, description, transaction number, cash code and transaction code.

• Uses the cash code to retrieve transactions from the Cash Management Transaction file. These records are then displayed in the detail lines.

Use these guidelines to specify the field values:

Override Cash Code

Required if cash code is not available from the statement file. This field is used to filter the CBTRANS records to a specific bank account.

Bank Statement

The bank statement number assigned to the transaction. You must define the statement number on Bank Statement (CB06.1) and is used only for cash codes that require bank statements.

If the reconciliation amount is different than the issued amount, then click R in the detail line to access Reconciliation Amount (CB82.3). From Reconciliation Amount (CB82.3), specify the reconciliation amount and click OK to return to Statement Reconciliation (CB82.1).

The program performs these actions when applying a cash ledger record to the reconciliation statement line:

• If the reconciliation amount is less than the transaction issue amount and the amount is outside the tolerance set on Company-Cash Codes (CB00.3), then an adjustment record for the difference is created.

• If the difference is within tolerance, then the variance distribution is created.

• If the reconciliation statement amount is greater than the transaction issue amount, then Statement Reconciliation (CB82.1) reconciles the record for the full amount. It adds the amount to the reconciliation balance, leaving a balance left over to still be applied.

• If you are applying multiple transaction records to the statement line, then Statement Reconciliation (CB82.1) applies each line separately, adding up the reconciled amount until the remaining balance is zero. Any reconciliation differences are reflected on the last selected transaction record.

You can reopen transactions by using the O option in the FC field and performing a form change. Reopening a transaction means that the data from the reconciliation statement needs to be applied to another transaction record. It can then be edited or deleted using Reconciliation Statement Maintenance (CB81.1) or re-applied to other transaction records.