Write-off Unapplied Receipt Balances Report

Use the Write-off Unapplied Receipt Balances Report to review a run of the Create Automatic Receipt Write-offs process. You can also generate the report without creating actual write-off entries to review the results of a proposed process run.

Both the manual and automatic write-off processes initiate the Create Automatic Receipt Write-offs program to process the writing off of unapplied receipt amounts. The program validates both the data that you enter and your write-off approval limit, selects the records to write off, then creates the accounting entries and updates the receipt balances.

If the value that you enter in the Unapplied Amount or Unapplied Amount Percentage parameter exceeds your write-off approval limit, then the program run ends with no data found.

The report provides separate receipt and write-off totals for each customer and customer account, and final totals for the program run.

Use the Write-off Unapplied Receipt Balances Report as part of your customer account review process.

Selected Report Parameters

Receipt Currency

The currency of the receipts that you want to write off. Only receipts with the currency you enter are eligible for write-off.

Unapplied Amount

The maximum amount that you can write off. The program selects receipts with unapplied amounts less than or equal to this value that meet the other selection criteria.

Unapplied Amount Percentage

The percentage of unapplied amount against the original receipt amount that you can write off. For example, if you want to write off receipts with an unapplied balance of 5% or less of the original receipt amount, then enter 5.

Receipt Method

Enter a receipt method to limit the selection of receipts to this receipt method only.

Receipt Number

The number of a specific unapplied receipt that you want to write off. If you specified a receipt method, a customer name, or a customer account number, then you can only select a receipt number belonging to this customer or receipt method.

Create Write-offs

  • Generate Report Only: Generate a report without performing the write-off to review the receipts to be processed using your selection criteria.

  • Create Write-off: Submit the Create Automatic Receipt Write-offs program to write off receipts according to your selection criteria, and generate the Write-off Unapplied Receipt Balances Report.

Write-off Receivables Activity

The receivables activity that determines the general ledger account to use to credit the write-offs.

This parameter is required if you set the Create Write-offs parameter to Create Write-off.

Application Date

The application date of the write-off to apply to all of the selected receipts.

Accounting Date

The accounting date of the write-off to apply to all of the selected receipts. The date is validated during the program run as being in an Open or Future Open period.