---
title: "Cash Receipt"
slug: "cash-receipt-report"
updated: 2026-03-03T03:54:09Z
published: 2026-03-03T03:54:09Z
canonical: "zenoplesupport.aqore.com/cash-receipt-report"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://zenoplesupport.aqore.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Cash Receipt

## **Summary**

**The Cash Receipt Report** provides finance and accounts teams with detailed visibility into customer payments, including payment amounts, methods, reasons, posting status, and Days Sales Outstanding (DSO).

Its standout capability is the **Date Type** parameter, which gives users flexible control over batch selection filtering by **Accounting Period Date**, **Post Date**, or **Payment Date** and the **Payment Reason breakdown**, which summarizes total cash collected by reason code within each company. This makes it possible to analyze collections from multiple financial perspectives in a single report run.

This report is essential for:

- **Accounts Receivable & Finance:** reconciling posted cash receipts against invoices and accounting periods.
- **Billing & Collections Teams:** analyzing payment behavior by method, reason code, and customer to improve collection strategies.
- **Management:** monitoring DSO trends at the company level and forecasting cash flow performance.

By using this report, staffing companies gain a complete, auditable view of all posted cash activity enabling faster period-end closing details, more accurate AR records, and stronger customer payment accountability.

## **Report Overview**

| **Attribute** | **Details** |
| --- | --- |
| **Purpose** | Provides detailed and summary views of cash receipts, including payment amounts, payment methods, payment reasons, DSO, and company/office totals. Links receipts to invoices and accounting periods for accurate reconciliation. |
| **Classification** | Business-Critical Report |
| **Who Should Use This Report** | Accounts Receivable, Finance and Accounting, Billing, Collections |
| **Business Problem Solved** | Improves visibility into posted cash receipts, supports cash reconciliation, enables DSO tracking, and helps identify payment trends across customers, offices, and companies. |
| **Run Frequency** | Daily or weekly; also on demand for audits or period-end reconciliation. |
| **Related Reports** | AR Aging, Invoice Register |

### **Business Value**

| **Category** | **Description** |
| --- | --- |
| **Cash Reconciliation** | Confirms that posted cash receipts align with invoices and accounting periods by linking each payment to its AR batch, Post Date, and Invoice record. |
| **DSO Analysis** | Measures payment timeliness by calculating days between Invoice Date and Date Received. Provides both individual and company-level average DSO to identify slow-paying customers. |
| **Payment Behavior Insights** | Analyzes payment methods (Check, ACH, Credit Card) and reason codes (Full Payment, Partial, Write-Off) across customers and offices to reveal collection patterns and trends. |
| **Operational Control** | Supports collection strategies and cash flow forecasting by providing a structured breakdown of receipts by company, office, customer, and reason code. |
| **Audit Support** | Provides a complete audit trail from batch ID through to individual invoice payments, with posting dates and references — enabling rapid reconciliation for period-end close. |

### **Known Issues or Limitations**

| **Issues** | **Description** |
| --- | --- |
| Posted batches only | Only AR batches with a valid payment batch post date are included in the report. Unposted or in-progress batches are excluded regardless of date range. |
| Payment Date filter applies a two-step exclusion | When Date Type = Payment Date, batches are first selected by whether any payment falls in the range, then individual rows outside the date range are deleted. This means a batch may be partially included. |
| DSO can be negative | If a payment is received before the invoice date (e.g., advance payment or data entry error), the DSO will be negative. This is mathematically correct but may indicate a data issue. |
| Access-scoped data | The organizations and offices returned are restricted to those the logged-in user has access to via Person Data Access. Users with limited access will see a subset of data. |

### **Troubleshooting Guide**

| **Issues** | **Problem Reason** | **Solution** |
| --- | --- | --- |
| Missing receipts when using Payment Date | Individual receipt rows whose Date Received falls outside the Start/End range are removed after batch selection. | Verify that the payment dates on the missing receipts fall within the selected Start and End Date. Use Post Date mode if you want all receipts in a posted batch regardless of individual payment dates. |
| Unexpected or very high DSO values | DSO is calculated from Invoice Date to Date Received. If either date is incorrect on the underlying record, the DSO figure will be skewed. | Cross-check Invoice Date and Date Received on the underlying invoice and AR batch records to ensure both are accurate before interpreting DSO. |
| Payment totals appear lower than expected | Reason Code or Payment Type filter is restricting the result set. | Set Reason Code and Payment Type to 'All' to remove those filters and compare the unfiltered totals against your expected values. |

### **FAQ**

| **Questions** | **Answers** |
| --- | --- |
| What does the Date Type parameter control? | Date Type selects AR batches by Accounting Period Date, Post Date, or Payment Date. Payment Date also removes any payment rows outside the selected Start/End range. |
| How is DSO calculated? | DSO is the number of days between the Invoice Date and the payment’s Date Received, calculated per receipt row and averaged at the company level. Higher DSO means slower customer payment; 0 means same‑day payment. |
| Can I see totals by company and office? | Yes. The report produces summary totals at both Company level (Invoice Amt, Payment Amt, Customer Count, Invoice Count, Average DSO) and Office level (Invoice Amt, Payment Amt, Customer Count, Invoice Count). These totals appear as sub-total rows alongside the invoice-level detail rows. |
| What happens if I enter a specific Batch Id? | When a non-zero Batch Id is entered, the report bypasses the Date Type and date-range batch-selection logic entirely and returns all receipts from that specific AR batch only. This is useful for auditing or reprinting a single batch. |

### **Reference Video/Screenshot**

![](https://cdn.document360.io/f6cab4f2-9572-4cd7-96b4-39b941f22824/Images/Documentation/cash-reciepts-image-jkkmkdfs.png)

## **Report Details**

| **Category** | **Value** |
| --- | --- |
| **Parent Category** | Back Office |
| **Category** | Accounts Receivable |
| **Report Type** | Paginated Report |
| **Report Runs from Application** | RMS |
| **Report Category** | Shareable |
| **Report Level** | Account Receivable |

### **Report Parameters**

| **Report Parameter** | **Description** | **Parameter Options** | **Default** | **Required** |
| --- | --- | --- | --- | --- |
| AR Batch Id | Targets a single specific AR batch, bypassing all date-range and Date Type logic. | Free text to enter numeric Id | 0 | No |
| Date Type | Drop down having date types to determine the date range scope of AR Batches | Accounting Period Date / Post Date / Payment Date | Accounting Period Date | No |
| Start Date | Start of the date range applied to the selected Date Type. | Any valid date |  | Yes |
| End Date | End of the date range applied to the selected Date Type. | Any valid date |  | Yes |
| Company | Filters results to selected company | List of companies present that a user has access | All | No |
| Office | Filters the results based on the office of the company selected | List of office belonging to a company that a user has access | All | No |
| Customer | Filters receipt detail rows by the customer’s name. | Free text for Customer name. | % | No |
| Payment Type | Filters receipt detail rows to specific payment methods (e.g., Check, ACH, Credit Card, Wire). | One or more Payment Method List, or All | All | No |
| Reason Code | Filters receipt detail rows to specific payment reason codes (e.g., Full Payment, Partial, Write-Off). | List containing Reason Code for Payment | All | No |

### **Report Grouping**

- Company
  - 
    - Office

The Cash Receipt Report organizes data in a three-level hierarchy: Company → Office → Customer/Invoice detail rows.

### **Report Columns**

| **Report Column** | **Description** | **Definition/Logic** |
| --- | --- | --- |
| Company | Short alias (abbreviation) for the tenant organization. | The abbreviated name of the company responsible for issuing the invoice and managing the billing activities. |
| Office | Name of the office associated with the invoice. | The office location associated with the invoice. |
| Customer Name | Name of the customer who made the payment. | The name of the customer organization that submitted the payment. |
| Department | Department associated with the customer's organization. | The business department within the customer’s organization |
| Invoice Number | Unique identifier for the invoice the payment was applied against. | The unique number assigned to the invoice that the payment was applied to. |
| Invoice Date | Date the invoice was issued. | The date the invoice was officially issued to the customer. |
| Due Date | Date the invoice payment was due. | The date by which the customer was expected to make payment. |
| Invoice Amt | Total amount billed on the invoice. | Represents the full invoiced value before any payments are applied. Finance charges are not included in this value. |
| Date Received | Date the payment was received from the customer. | This is the date the cash receipt was entered, representing when funds were actually received. |
| Posted Date | Date the AR batch was posted to the ledger. | The date when the AR Batch was posted. |
| Payment Amt | Amount of this payment applied to the specific invoice. | Represents the portion of the Customer Organization Payment allocated to this invoice — not the total payment in the batch. |
| Payment Method | Method used to make the payment (e.g., Check, ACH, Wire). | The financial channel used for the transaction. |
| Reason Code | Reason code is associated with the invoice payment (e.g., Full Payment, Partial, Write-Off). | A category describing the nature of the payment, such as a full settlement, a partial payment, or a debt write-off. |
| Batch Id | Identifier for the AR batch in which this payment was recorded. | The identifier of the accounting batch that contains this payment. Used for audit tracking and reconciling posted financial entries. |
| Batch Type | Classification of the AR batch (e.g., Regular, Adjustment). | The type of accounting batch in which the payment was processed (e.g., regular payment, adjustment). |
| Reference | Free-text reference entered when the payment was recorded (e.g., check number, wire reference ID). | Any additional reference text provided at the time of payment entry—such as a check number. |

### **Additional Notes**

|  |
| --- |
|  |
|  |