Match Open Receivables/Payables to Bank Settlements
In the Cash Matching workspace's Manual Matching tab, you can manually match an open receivable/payable with a bank settlement for the same cash account and security. During manual cash matching, the system does not use any tolerances you defined for use in automated cash matching. You can fully or partially settle bank settlements and open receivables/payables.
To match open receivable/payables with bank settlements:
In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching.
You see the Cash Matching workspace. The Manual Matching tab is active by default.In the Manual Matching tab, search for and select the open receivables/payables and bank settlements that you want to match.
On the Cash Matching tab, in the Actions group, click Match.
You see the Match Records dialog box. In the upper pane, you see the selected open receivables/payables along with a total and a Remaining Receivable/Payable amount. The Remaining Receivable/Payable amount identifies the amount that remains open after you submit the match. In the lower pane, you see the selected bank settlements along with a total and Balance amount. This Balance amount shows the remaining amount that is left to allocate for the bank settlement after you submit the match. The Pro Rate button is selected by default and is not available.If you have an exact match, click the Match button in the Match Records dialog box to submit the match. Otherwise, continue to the next step.
The system submits the settlements to the accounting engine for processing. You no longer see the fully settled bank settlements and open receivable/payables in the Cash Matching workspace.If you want to fully settle the selected bank settlements and open receivables/payables for a non exact match, select the Write to Breakage check box, and then click the Match button in the Match Records dialog box to submit the match. Otherwise, continue to the next step for a partial settlement.
The Write to Breakage option allows you to fully settle the open receivables/payables by writing off the difference between the bank settlement and open receivables/payables and tracking that amount in the account determined by the entity's cash breakage election. The system submits the settlements to the accounting engine for processing. You no longer see the fully settled bank settlements and open receivable/payables in the Cash Matching workspace.If you want to partially settle the selected bank settlements and open receivables/payables for the system calculated pro rated amounts, ensure the Write to Breakage check box is cleared, and then click the Match button in the Match Records dialog box to submit the match. Otherwise, if you want to change the pro rated amounts, continue to the next step.
The system submits the settlements to the accounting engine for processing. You see the partially settled bank settlements and/or partially settled open receivable/payables in the Cash Matching workspace. The Net Amount Local value identifies the unmatched amount that is available for further matching.If you want to change the system calculated pro rated amounts for the open receivables/payables, click the Open Local Amt field for an open receivable/payable and enter the amount that you want to settle for that open receivable/payable.
In the Match Records dialog box, the system recalculates the Units value that you are settling for the selected open receivable/payable, and updates the totals and Remaining Receivable/Payable values. After you change an Open Local Amt value, the Pro Rate button becomes available. You can continue updating the pro rated amounts and/or can click the Pro Rate button to have the system recalculate the pro rated amounts.Click the Match button in the Match Records dialog box to submit the partial match for the adjusted amounts.
The system submits the settlements to the accounting engine for processing. You see the partially settled bank settlements and/or partially settled open receivable/payables in the Cash Matching workspace. Their Net Amount Local value identifies the unmatched amount that is available for further matching.
Â