AR Cash Receipt Upload  Help

AR Cash Receipt Upload creates and maintains Oracle Receivables cash receipts directly from Excel. It supports all three receipt operations in a single template: Standard receipts (a customer payment, optionally applied to open invoices on the same rows), Miscellaneous receipts (non-customer income posted against a Receivables Activity, with no customer), and reversing an existing receipt. It also handles on-account and unapplied receipts, remittance and customer bank-account selection, Notes Receivable / Bills of Exchange details, and your configured Receipt Information (descriptive flexfield) – so a full batch can be entered, applied or reversed in a single pass.

When to use it

• Standard receipt – enter a batch of customer payments and apply each to one or more open invoices.
• Apply a single receipt across several invoices, place it On Account, or leave it Unapplied.
• Add applications to a receipt that already exists, without re-creating it.
• Miscellaneous receipt – record non-customer income (bank interest, sundry refunds, etc.) against a Receivables Activity.
• Reverse an existing receipt.
• Capture Notes Receivable / Bills of Exchange, or the customer bank details used by automatic receipt methods such as Direct Debit and EFT.

Before you start

• Blitz Report is installed and you are signed in to a Receivables responsibility with cash-receipt entry access.
• The Receipt Methods you will use are defined, with their remittance bank accounts assigned.
• For miscellaneous receipts, the relevant Receivables Activity is configured – it supplies the GL accounting automatically.
• The GL Date you intend to use falls in an open Receivables period.

Step 1 – Open the upload and choose a mode

Run AR Cash Receipt Upload from the Blitz Report menu and choose an Upload Mode:

• Create – opens an empty template for entering brand-new receipts.
• Create, Update – downloads existing receipts together with their applications, so you can review them or add further applications.

Step 2 – Set the parameters and download the template

The parameters limit what is downloaded (in Create, Update mode):

Click Download to open the populated Excel template.

Step 3 – Enter the receipt header

On each new row, choose the Receipt Type (Standard or Miscellaneous – Standard is the default) and enter the receipt itself: Receipt Number, Receipt Method, Receipt Amount, Receipt Date, Currency and the Customer (name, number or site). For a foreign-currency receipt you can also supply the exchange rate type, date and rate.

Step 4 – Apply the receipt to invoices

• Leave Invoice Number blank – the receipt is created as Unapplied.
• Enter an Invoice Number (with Amount Applied, and optionally Discount / Application Reference) – the receipt is applied to that invoice.
• Set Apply on Account = Yes – the amount is applied On Account, with no specific invoice.

To apply one receipt to several invoices, enter multiple rows with the same Receipt Number: the receipt is created only on the first row, and each later row adds one application to it. On those later rows the header columns (Receipt Method, Amount, Date, Currency) can be left blank.

Step 5 – Receipt types and other operations

• Standard receipt (default) – a customer cash receipt, optionally applied to invoices as in Step 4.
• Miscellaneous receipt – set Receipt Type to Miscellaneous to record non-customer income. A Receivables Activity is required (it supplies the accounting); the customer and application columns must be left blank.
• Reverse a receipt – download the receipt (Create, Update), set Reverse = Yes and supply the Reversal Date, Reversal Category and reason. The receipt must already exist.
• Remittance Bank Account – defaults to the primary account of the Receipt Method. Pick a different account to override; the Override flag is then set to Yes automatically.
• Receipt Information (flexfield) – choose an Attribute Category to expose its segments in the Attribute columns; the headers rename to your configured segment labels. Flexfield values are written when the receipt is created.
• Customer Bank Account – the customer’s own funding account, used by automatic receipt methods (Direct Debit, EFT). Leave blank for ordinary cash receipts.
• Notes Receivable / Bills of Exchange – Issuer Name, Issue Date and Issuer Bank Branch. Populate only for notes / bills.

Step 6 – Save and upload

Save the workbook and use Blitz Report’s Upload button. Each row is validated and processed; the results are written back to the same workbook.

What’s produced

• Cash receipts in Receivables – Standard (Unapplied, Applied or On Account) or Miscellaneous, according to the rows entered.
• One receipt application per applied row; miscellaneous receipts with their activity accounting; reversed receipts marked as reversed.
• A result workbook with a Status and Message on every row, so you can see at a glance which rows succeeded and why any failed.

Common questions

How do I apply one receipt to several invoices?
Enter one row per invoice, all using the same Receipt Number. The receipt is created once; each row adds an application.

Can I add applications to a receipt that already exists?
Yes. Enter the existing Receipt Number and the application columns only – Receipt Method, Amount, Date and Currency can be left blank.

What’s the difference between a Standard and a Miscellaneous receipt?
Standard is a customer payment applied to invoices. Miscellaneous records non-customer income (e.g. bank interest) against a Receivables Activity, with no customer and no invoice application.

How do I reverse a receipt?
Download it in Create, Update mode, set Reverse = Yes and supply the Reversal Date and Reversal Category. The receipt must already exist – you cannot reverse and create in the same row.

Can I change the Receipt Information (flexfield) on an existing receipt?
No – flexfield values are written when the receipt is created. Maintain header flexfields in the form, or reverse and re-create the receipt.

Troubleshooting