Applied Receipts Register

Use the Applied Receipts Register to review all receipt applications that affect your customer balances.

The report includes both customer receipts and discount information. You can use this report to review receipt applications for a specific customer, receipt batch, or applied transaction number. You can’t use this report to review miscellaneous receipts.

Review how customer receipts were applied to transactions. Optionally analyze receipts requiring manual application (Application Exception Reason) to improve automated receipt applications. Use for reconciling to the general ledger when a standalone report is needed.

Selected Report Parameters

You can select receipt applications by customer and receipt batch. Specify a receipt application accounting date range to review specific information for the period. The report displays all receipt applications within the date range regardless of check date.

Application Accounting Date

The application accounting date range.

Receipt Batch Number

Select receipts by batch to review specific batches, such as lockbox batches.

Application Exception Reason

The application exception reasons indicate why a receipt application wasn’t made automatically. If you select this parameter, the report provides a subtotal by application exception reason.

Applied Transaction Number

The transaction number that allows selection of all receipts applied to a transaction.

Report Output

The report provides customer receipt application information by business unit and application accounting date for the specified period:

  • The report displays receipt-to-receipt applications as one receipt with a positive application and the other receipt with a negative application.

  • The report displays debit memo reversal receipts as applied receipts, because the transaction is closed by the debit memo reversal receipt and a new debit memo is created for the amount of the receipt. All other receipt reversals appear on the Unapplied Receipts Register.

This table describes important columns in the output of the Applied Receipts Register.

Column Heading

Description

Application Accounting Date

The accounting date of the receipt application or application reversal.

Entered Applied Amount

The receipt amount applied in the entered currency.

Earned Discount

The earned discount amount in the ledger currency.

Unearned Discount

The unearned discount amount in the ledger currency.

Accounted Applied Amount

The total amount applied in the ledger currency.

Application Exception Reason

The reason that the receipt couldn’t be applied automatically.

This table describes important rows in the output of the Applied Receipts Register.

Row Heading

Description

[Application Exception Reason] Total

The subtotal accounted applied amount by each application exception reason.

[Business Unit] Total

The subtotal accounted applied amount by business unit.

Grand Total

The total of all accounted applied amounts for the report.