Zoho inventory logo Help Docs
/

Receivables Reports

Receivables reports help you track outstanding customer balances, monitor invoice and sales order status, and analyse ageing across your receivables. Go to Reports from the left sidebar, then select Receivables from the Report Category list.

Invoice Details

The Invoice Details report shows all invoices for a selected period - including their status, due date, customer name, invoice amount, and balance due. Use it to track which invoices are outstanding, overdue, or paid.

Scenario: Bailey at Zylker Inc needs to send payment reminders before the end of the month. She generates the Invoice Details report filtered to the current month to see all open and overdue invoices, then follows up with customers who have outstanding balances.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Invoice Details.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • STATUS: Current status of the invoice (e.g., Draft, Sent, Overdue, Paid).
  • INVOICE DATE: Date on which the invoice was created.
  • DUE DATE: Date by which payment is due.
  • INVOICE#: Unique reference number of the invoice.
  • ORDER NUMBER: Sales order number associated with the invoice.
  • CUSTOMER NAME: Name of the customer billed.
  • TOTAL: Total invoice amount including taxes.
  • BALANCE: Outstanding balance remaining on the invoice.

Retainer Invoice Details

The Retainer Invoice Details report shows all retainer invoices raised during a selected period - including status, amount, and the amount applied against subsequent invoices. Use it to track advance payments collected from customers.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Retainer Invoice Details.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • STATUS: Current status of the retainer invoice (e.g., Unpaid, Partially Used, Closed).
  • RETAINER INVOICE DATE: Date on which the retainer invoice was raised.
  • RETAINER INVOICE#: Unique reference number of the retainer invoice.
  • CUSTOMER NAME: Name of the customer billed.
  • PROJECT/ESTIMATE: Project or estimate associated with the retainer, if applicable.
  • AMOUNT: Total amount of the retainer invoice.
  • UNUSED RETAINERS: Remaining retainer amount not yet applied against an invoice.

Sales Order Details

The Sales Order Details report shows all sales orders for a selected period - including their status, expected shipment date, customer name, and order amount. Use it to monitor open orders, track fulfilment timelines, and identify overdue shipments.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Sales Order Details.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • STATUS: Current status of the sales order (e.g., Open, Fulfilled, Cancelled).
  • DATE: Date on which the sales order was created.
  • EXPECTED SHIPMENT DATE: Date by which the order is expected to be shipped.
  • SALES ORDER#: Unique reference number of the sales order.
  • CUSTOMER NAME: Name of the customer who placed the order.
  • AMOUNT: Total value of the sales order.

Click any SALES ORDER# to open the order, or click a CUSTOMER NAME to open the customer record.

Delivery Challan Details

The Delivery Challan Details report lists all delivery challans issued during a selected period - including the challan number, associated customer, items delivered, and status. Use it to track goods sent out without a formal invoice, such as items sent for approval or on a returnable basis.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Delivery Challan Details.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • DELIVERY CHALLAN#: Unique reference number of the delivery challan.
  • DATE: Date on which the delivery challan was created.
  • STATUS: Current status of the delivery challan.
  • INVOICE STATUS: Status of the associated invoice, if any.
  • CUSTOMER NAME: Name of the customer receiving the goods.
  • AMOUNT: Total value of goods covered by the delivery challan.

Customer Balance Summary

The Customer Balance Summary report shows the outstanding balance owed by each customer - including their invoice balance, available credits, and net balance. Use it to identify your highest-balance customers and prioritise collection efforts.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Customer Balance Summary.

This report is generated automatically as of the current date and updates with every customer transaction.

This report includes the following columns:

  • CUSTOMER NAME: Name of the customer.
  • INVOICE BALANCE: Total outstanding balance across all open invoices for this customer.
  • AVAILABLE CREDITS: Total unapplied credit note balance available for this customer.
  • BALANCE: Net amount owed by the customer (Invoice Balance minus Available Credits).

Click any value under INVOICE BALANCE, AVAILABLE CREDITS, or BALANCE to drill down to a customer-level transaction history.

Receivable Summary

The Receivable Summary report provides an aggregated view of all invoices and credit notes, grouped by customer, due date, or custom fields. Use it for period-end receivables reconciliation and management reporting.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Receivable Summary.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • CUSTOMER NAME: Name of the customer.
  • DATE: Date of the invoice or credit note.
  • TRANSACTION#: Reference number of the transaction.
  • REFERENCE#: Additional reference number, if applicable.
  • STATUS: Current status of the transaction (e.g., Open, Overdue, Paid).
  • TRANSACTION TYPE: Type of transaction (e.g., Invoice, Credit Note).
  • TOTAL (BCY): Total transaction amount in your base currency.
  • TOTAL (FCY): Total transaction amount in the customer’s foreign currency.
  • BALANCE (BCY): Outstanding balance in your base currency.
  • BALANCE (FCY): Outstanding balance in the customer’s foreign currency.

Receivable Details

The Receivable Details report shows each invoice and credit note with their underlying line-item details - item name, quantity, and price. Use it to export a granular breakdown of outstanding receivables for audit or reconciliation.

To generate this report:

  • Go to Reports from the left sidebar.
  • Select Receivables from the Report Category list.
  • Click Receivable Details.
  • Set a Date Range and any additional filters, then click Run Report.

This report includes the following columns:

  • CUSTOMER NAME: Name of the customer.
  • DATE: Date of the invoice or credit note.
  • TRANSACTION#: Reference number of the transaction.
  • REFERENCE#: Additional reference number, if applicable.
  • STATUS: Current status of the transaction.
  • TRANSACTION TYPE: Type of transaction (e.g., Invoice, Credit Note).
  • ITEM NAME: Name of the line item within the transaction.
  • QUANTITY ORDERED: Quantity of the item on the invoice.
  • ITEM PRICE (BCY): Unit price of the item in your base currency.
  • TOTAL (BCY): Total amount for this line item in your base currency.

For payments collected against invoices, credit notes, and refunds, see Payments Received Reports.

IN THIS PAGE…