Seeing which invoices a receipt was applied to
When testing accounts receivable cash transactions, a payment that has been allocated across several invoices can be difficult to match. Validis shows you the allocation directly, so you can see exactly which invoices a receipt was applied to and how much went to each.
Finding the allocation
Step 1
Open the Receivables Ledger Control report
Select Receivables Ledger in the menu on the left, under Detailed Reports, then select the Receivables Ledger Control tab.
Step 2
Choose the period you want to look at
Select a single accounting period to look at that month on its own, or a figure in the Total row at the bottom to look at everything the report covers. The steps below follow a single period.
Step 3
Filter to cash transactions
The Transaction Data Viewer opens on Show All. Select Cash at the top of the report to narrow the list to receipts only. The figure on each filter tells you the total for that transaction type before you select it.
Step 4
Select the payment
Use the search box above the report to find a specific payment or invoice, or sort a column using the arrows beside its heading. Select the payment you want to examine.
Step 5
Read the allocation
The Allocations view opens, listing the payment followed by every invoice it was allocated to. Where a single receipt was split across several invoices, each one appears on its own row.
| Column | What it shows |
|---|---|
| Type | Whether the row is the payment or an invoice it was applied to. |
| Reference | The sales receipt or the invoice number. |
| Date | The date of the payment or the invoice. |
| Amount | The full value of that transaction. |
| Allocation Date | The date the payment was applied to that invoice. |
| Allocation Amount | How much of the payment went to that invoice. |
| Balance | What remains unallocated. |