Reviewing Cash Receipts

Use the Automatic Cash Receipts Review Queue to view information on cash receipts by branch or territory. You can edit and view the cash receipts directly from the queue or delete any of the log entries related to a line item.

Note: This queue contains any automatically created cash receipts and the information in this queue is based on the data supplied by Batch Cash Receipts. For more information, see Reviewing Batch Cash Receipts.

To view the Cash Receipts Review queue:

From the A/R > Utilities menu, select Cash Receipts Review Queue to display the Automatic Cash Receipts Review Queue window.
In the Branch/Territory field, enter the branch or territory for which you want to view cash receipts.

To limit the queue, use any of the following options for the header fields:

To limit the queue to...	Use the following header field...
a specific customer	Customer
items in the queue after a specific date	Put on queue after
items in the queue before a specific date	Put on queue before
items with a specific batch number	Batch Name Note: To add a prefix to your batch names that further identify what the system receives through the lockbox, use the Auto Cash Receipts Multi Lockboxcontrol maintenance record. However, you cannot use that prefix to search by, the Batch Name field requires an exact match.
include only a particular check number	Check Number
items without an ID	Only items not created
only items from a specific cash general ledger account	Cash G/L Account

Click Update.

The system populates the window with the following information for each cash receipt as listed during cash receipt entry or batch cash receipt processing. Double-click any line item to view the cash receipt.

Column	Description
Check Number	The check number.
Cash Receipt	The system-assigned identification number.
Batch Name	The batch number or name, if any. Note: To add a prefix to your batch names that further identify what the system receives through the lockbox, use the Auto Cash Receipts Multi Lockboxcontrol maintenance record. However, you cannot use that prefix to search by, the Batch Name field requires an exact match.
Customer	The name of the customer associated with a cash receipt.
Payment Date	The date the payment was applied to a cash receipt.
Check Amount	The amount of the check. Note: If the customer sends more cash than what the invoice is for, the system displays the entire amount and indicates there is a credit when you drill into that invoice.
Discount Amount	The amount, if any, applied to a cash receipt. Note: When using Net comparison matching rules, the system applies discounts per invoice, not as a lump sum.
Reconciled	The amount of the reconciled amount of the check.
Difference	The amount of the difference, if any, between the cash receipt and the reconciled amount.
Assigned User	Enter the user to whom the cash receipt resolution is assigned. The system locks that cash receipt for that user and does not allow editing of the receipt by another user. The system prompts you if you reassign a receipt.

Save your changes and exit the window.

More Options for the Automatic Cash Receipts Review Queue

The following options are available on the Automatic Cash Receipts Review Queue window:

To...	Use this option...
print out or send a printable version of the Automatic Cash Receipts Queue to your Hold file, including any errors	Print > Review Queue
print or send a printable version of the Automatic Cash Receipts Posting Exceptions to your Hold file, which contains any errors encountered while posting the transactions. Common errors might be duplicate records or duplicate customer ABA numbers.	Print > Posting Exceptions
print out or send to your Hold file the Automatic Cash Receipts Daily Balancing Report, which contains the transactions, by branch, that were posted.	Print > Daily Balancing
display the Cash Receipts window in view-only mode. For more information, see Cash Receipts Overview.	View > View Cash Receipt
display the Cash Receipts window in edit mode. For more information, see Cash Receipts Overview.	View > Edit Cash Receipt
display the Auto Cash Receipts Posting Exceptions Report, which contains any errors encountered while posting the cash receipts. This option is only active when an error report exists for the current line item.	View > Error Report
Displays the A/R Inquiry window where you can view information about your A/R accounts. For more information, see A/R Inquiry Overview.	View > A/R Inquiry
clear all matching receipts	Options > Clear All Matches
requeue one line item for repayment under certain situations, for example, if there is an error on the line item.. Any cash receipts that were posted without any errors cannot be requeued.	Options > Requeue

Viewing Tax Breakdowns

You can also review the tax information for a payment from the Cash Receipts window. Here, you can call a window that queries Avalara to show you the taxes applied to each invoice.

To view the Total Tax Breakdown:

From the A/R menu, select Cash Receipts.
In the Customer field, enter the customer you want to review.
Select the Order Number of the order you for which want to review the receipts.
The window lists all the invoices associated with this order. Select the one you want to see tax information on, and open the Total Tax Breakdown window. You can do this in one of three ways:

Ctrl + E
RMB > Total Tax Breakdown
Invoice > Total Tax Breakdown

Note: This window is informational only. You cannot edit any of the information displayed here.