Payments Received Reports
The Payments Received reports contain a list of reports that provide detailed insights into customer payments, collections, refunds, and credit-related transactions. These reports help you track payment activity, analyse collection timelines, and monitor how payments impact invoices and outstanding balances across customers.
Note: Users in custom roles can perform actions and access modules only based on the permissions enabled for them.
You can access the following Payments Received reports in Zoho ERP:
- Payments Received
- Time to Get Paid
- Credit Note Details
- Refund History
Payments Received
The Payments Received report provides a consolidated view of all customer payments recorded during the selected period. It helps you track payment statuses, payment modes, and deposit accounts, making it easier to monitor payment collections. You can also filter records based on the transaction type, such as Invoice Payments, Retainer Payments, or All.
Scenario: A finance team wants to review all payments collected from customers over a financial year to verify payment statuses, identify unused amounts, and ensure payments are correctly linked to invoices and deposit accounts. By using the Payments Received report, they can quickly audit customer payments and track outstanding or unapplied amounts.
Here’s how you can view this report:
- Navigate to Reports on the left sidebar.
- Select Payments Received in the Report Category pane.
- Click Payments Received.
This report includes the following columns:
- Payment Number: The unique number assigned to each payment received.
- Date: The date on which the payment was recorded.
- Status: Indicates the current state of the payment, such as Draft, Paid, or Void.
- Reference Number: The transaction reference or payment gateway ID associated with the payment.
- Customer Name: The customer who made the payment.
- Payment Mode: The method used to receive the payment, such as Cash, Bank Transfer, Online Payments, Cheque, or others.
- Notes: Additional information or remarks recorded for the payment.
- Invoice #: The invoices to which the payment is applied.
- Deposit To: The account where the received amount is deposited, such as a bank or petty cash account.
- Amount (FCY): The total amount received from the customer in the foreign currency used for the transaction.
- Unused Amount (FCY): The portion of the payment that has not been applied to any invoice in the foreign currency used for the transaction.
- Amount (BCY): The total amount received from the customer converted to the base currency of your organization.
- Unused Amount (BCY): The portion of the payment that has not been applied to any invoice converted to the base currency of your organization.
Time to Get Paid
The Time to Get Paid report provides a summary of how quickly payments are collected from customers after invoices are issued. It helps you analyse due dates, identify delayed payments, and monitor overall payment collection efficiency. You can view the data as of a specific date to understand current payment trends.
Scenario: A finance team wants to track how promptly customers are paying their invoices. By using the Time to Get Paid report, they can identify customers who frequently delay payments, and improve cash flow management by following up.
Here’s how you can view this report:
- Navigate to Reports on the left sidebar.
- Select Payments Received in the Report Category pane.
- Click Time to Get Paid.
This report includes the following columns:
- Customer Name: The name of the customer.
- 0–15 Days: The percentage of payments received within 0–15 days of invoice issuance.
- 16–30 Days: The percentage of payments received within 16–30 days.
- 31–45 Days: The percentage of payments received within 31–45 days.
- Above 45 Days: The percentage of payments received after more than 45 days.
Credit Note Details
The Credit Note Details report provides a consolidated view of all credit notes issued to customers during the selected period. It helps you track the status of credit notes, credit amounts, and remaining balances, making it easier to monitor credit adjustments and customer accounts.
Scenario: A finance team wants to review all credit notes issued to customers over a financial year to ensure amounts are applied correctly and outstanding balances are visible. By using the Credit Note Details report, they can quickly audit customer credits and track remaining amounts for better payment management.
Here’s how you can view this report:
- Navigate to Reports on the left sidebar.
- Select Payments Received in the Report Category pane.
- Click Credit Note Details.
This report includes the following columns:
- Status: Indicates the current state of the credit note, such as Open or Closed.
- Credit Date: The date on which the credit note was issued.
- Credit Note#: The unique number assigned to the credit note.
- Customer Name: The customer for whom the credit note was issued.
- Credit Note Amount: The total value of the credit note.
- Balance Amount: The remaining amount of the credit note that has not yet been applied to invoices or refunded.
Refund History
The Refund History report provides a consolidated view of all refunds issued to customers during the selected period. It helps you track refund amounts, transaction details, and customer information, making it easier to monitor refunds processed and ensure accurate payment records.
Scenario: A finance team wants to review all refunds issued to customers over a financial year to verify amounts and track refunded transactions. By using the Refund History report, they can quickly check refund activity and maintain transparency in customer accounts.
Here’s how you can view this report:
- Navigate to Reports on the left sidebar.
- Select Payments Received in the Report Category pane.
- Click Refund History.
This report includes the following columns:
- Date: The date on which the refund was processed.
- Reference#: The reference associated with the refund transaction.
- Transaction #: The unique reference number for each refund transaction.
- Customer Name: The customer receiving the refund.
- Mode: The method used to process the refund, such as Cash, Bank Transfer, Online Payments, Cheque, or others.
- Notes: Additional information or remarks recorded for the refund.
- Amount (FCY): The total refund amount in the foreign currency used for the transaction.
- Amount (BCY): The total refund amount converted to the base currency of your organization.