This chapter contains the following topics:
You can use the Debit Credit Match program (P09131) to reconcile debits and credits within a particular account, such as a trade or suspense account. For example, if a trade account is out of balance, you would use this program to match debit transactions to credit transactions to locate the transaction that is causing the account to be out of balance.
The process to reconcile debit and credit transactions consists of these steps:
Before you complete the tasks in this section:
Run the Auto Reconcile Void Payment program.
Run the Auto Reconcile Void Receipt program.
Run the Refresh Reconciliation File program.
This section discusses how to:
Set processing options for the Debit Credit Match program
Reconcile debit and credit transactions manually.
|Form Name||Form ID||Navigation||Usage|
|Bank Account Reconciliation||W09131A||Manual Reconciliation (G09209), select Debit Credit Match form.||Manually reconcile and unreconcile debit and credit amounts.|
The processing options for the Debit Credit Match program appear on the Debit Credit Edits tab of the Manual Reconciliation program. Use these processing options to specify whether a debit and credit transaction must balance before you can continue the manual reconciliation process.
The processing options on this tab are used only by the Debit Credit Match program.
Specify an option that specifies the type of processing for an event. Values are:
Blank: Bank Account Reconciliation.
1: Matching Debit Credit Reconciliation.
Specify whether debits and credits are required to balance. Values are:
Blank: Not required to balance.
1: Required to balance
Specify the tolerance amount by which debit and credit transactions can be out of balance. This processing option is used only when you enter 1 in the Debit Credit Balance processing option.
If you enter 1 in the Debit Credit Balance processing option and you leave this processing option blank, debits and credits must balance exactly or the system generates an error.
If you enter 1 in the Debit Credit Balance processing option and you specify an amount for this processing option, the difference between the debit and credit transactions must be less than or equal to the tolerance amount. If the debit and credit transactions are out of balance by the tolerance amount, they are considered reconciled and the system does not generate an error message. For example, if you enter 5.00 in this processing option, debits and credits can be out of balance by 5.00. If debits and credits are greater than the tolerance amount, the system generates an error message.
Specify how the system should sort transactions. Values are:
Blank: Sort transactions by general ledger date.
1: Sort transactions by amount. The system sorts the transactions by amount, regardless of whether they are debits or credits. You can see an amount with the debit and credit together as opposed to searching for the offset of the amount by the general ledger date.
Access the Bank Account Reconciliation form.
To reconcile debit credit transactions manually, select the transaction and then select Reconcile Toggle from the Row menu.
The system updates the GLRCND field in the F0911R table and F0911 with an R (or the reconciliation code that you selected) only if these conditions are met:
You entered 1 for the Debit Credit Balance processing option in the Manual Reconciliation program and the debit and credit transactions net to zero or the difference between the two transactions is within the tolerance limit that you entered in the Tolerance Limit processing option.
You left the Debit Credit Balance processing option blank in the Manual Reconciliation program.
If these conditions are not met, the system displays an error message and does not update the transactions as reconciled. If the error message is displayed then the Total Debits and Total Credits fields are also displayed.