Receivables

The Receivables section contains a list of reports which show all the money that you are to receive from your customers from different sources.


Customer Balances 

This report is a summary of all the money that your customers owe you based on the invoices and the credits you record for them.

To view this report:

Customer Balances

Let us take a look at the different sections that this report contains:

Fields Description
Customer Name (FCY) Customer whose balance you want to view.
Invoice Balance (FCY) Total value of all the unpaid invoice(s) of the customer.
Available Credits (FCY) Total value of all the credit notes and excess payments that you’ve recorded for your customers.
Balance (FCY) Amount which the customer actually owes you (for foreign currencies).
Balance = Invoice Balance - Available Credits
Balance (BCY) Amount which the customer actually owes you (in the base currency).

To customize this report:

Customize Report

You can customize the report based on:

Fields Description
As on  Time period for which you want to generate the report.
Customer Name Generate the report exclusively for a customer.

You can also choose which fields you want to show in the report. Here’s how:

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.


Aging Summary 

This report contains all the money that your customers owe you based on the invoice due date or the invoice date. in different time intervals or on a certain date. By default, this report displays the balances for the following intervals:

For example, if you generate the report for today’s date, and have an invoice whose due date has passed a week ago, then it will be shown in the 1 - 15 days section.

To view this report:

Aging Summary

In this report, you can see the following details of your customers:

You can click on any of the customers to view their detailed drill-down summary.

To customize this report:

Customize Report

Fields Description
As of Select the time interval for which you want to generate the report or set a custom period of your own.
Aging By Generate the report based on the Invoice Due Date or the Invoice Date.
Aging Intervals Choose the length and the number of intervals.
Group By Group the report either by Salesperson or Currency.
Show By Generate the report based on the Outstanding Invoice Amount or the Invoice Count.
Credit Notes Choose to display the Credit Notes or the Manual Journals of the customers (if any).

You can also choose which fields you want to show in the report. Here’s how:

Customize Report

Schedule Report

You can schedule the report to be sent to your email address or other users in the organization. The report will be sent in different time intervals at a specific time. Here’s how you can set this up: Click the Schedule Report button in the top right side of the page. Enter the parameters for the report. Click Save.

Schedule Report

The report will be automatically sent to your email at the specified time and interval.


Aging Details 

This report contains the split up of transactions in the Aging Summary report. You can generate the report for different customers.

To view this report:

Aging Details

Let us take a look at the different sections that this report contains:

Fields Description
Date Date on which the transaction was created.
Transaction# Transaction ID.
Status Status of the transaction.
Customer Name Customer for whom the transaction was created.
Age Number of days passed the due date of the transaction.
Amount Total value of the transaction.
Balance Due Balance due for the transaction.

To customize this report:

Customize Report

You can customize the report based on:

Fields Description
As of Filter the report for a week, month, year, or set a period of your own.
Aging By Generate the report based on the Invoice Date or the Invoice Due Date.
Aging Intervals Select the number of intervals and the length of the intervals.
Customer Name Select the customer for whom you want to generate the report.
Group By Group the report either by the Customer, Salesperson or Currency.
Credit Notes Include the credit notes and/or manual journals in the report by marking the box next to them.

You can also choose which fields you want to show in the report. Here’s how:

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.

Schedule Report

You can schedule the report to be sent to your email address or other users in the organization. The report will be sent in different time intervals at a specific time. Here’s how you can set this up:

Click the Schedule Report button in the top right side of the page. Enter the parameters for the report. Click Save.

Schedule Report

The report will be automatically sent to your email at the specified time and interval.


Invoice Details 

This report contains the details of all the invoices that you have created for various customers in your organization along with the due dates and their pending balances.

To view this report:

Invoice Details

To customize this report:

Select the following fields:

Fields Description
Date Range Select the date range for which you want to generate the report.
Report By Generate the report either based on the Invoice Due Date or the Invoice Date.
Invoice Status Filter the report based on the status of the invoices.

Customize Report

You can also add additional filters. Click the + Advanced Filters at the bottom of the popup. Add more criteria by clicking + Add more in the next line.

Customize Report

You can also choose which fields you want to show in the report. Here’s how:

Click the Show / Hide Columns under General. Choose the fields under Customer which you want to display in your report. Click Run Report.

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.

Schedule Report

You can schedule the report to be sent to your email address or other users in the organization. The report will be sent in different time intervals at a specific time. Here’s how you can set this up:

Click the Schedule Report button in the top right side of the page. Enter the parameters for the report. Click Save.

Schedule Report

The report will be automatically sent to your email at the specified time and interval.


Retainer Invoice Details 

This report contains the retainer invoice you’ve created for your customers, any projects associated with retainers, and the total amount along with the unused retainers.

To view this report:

Retainer Invoice Details

Let us take a look at the different sections that this report contains:

To customize this report:

Select the following fields:

Fields Description
Date Range Select the date range for which you want to generate the report.
Retainer Invoices Status Filter the report based on the status of the retainer invoices.

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.

Schedule Report

You can schedule the report to be sent to your email address or other users in the organization. The report will be sent in different time intervals at a specific time. Here’s how you can set this up:

Schedule Report

The report will be automatically sent to your email at the specified time and interval.


Sales Order Details 

This report contains all the sales orders that you created for your customers and their amounts for a specific period.

To view this report:

Sales Order Details

To customize this report:

Fields Description
Date Range Select the date range for which you want to generate the report.
Status Filter the report based on the status of the sales orders.

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.


Estimate Details 

This report contains all the estimates that you created for your customer, any associated invoice and the estimate amount for a specific period of time.

To view this report:

Estimate Details

To customize this report:

Select the following fields:

Fields Description
Date Range Select the date range for which you want to generate the report.
Report By Generate the report either based on the Estimate Date or the Expiry Date.
Estimate Status Filter the report based on the status of the estimates.

Customize Report

You can download this report by clicking Export As in the top right corner of the page and selecting the file format in which you want to download.

You can also print the report by clicking the Print icon in the top right side of the page.

Schedule Report

You can schedule the report to be sent to your email address or other users in the organization. The report will be sent in different time intervals at a specific time. Here’s how you can set this up:

Schedule Report

The report will be automatically sent to your email at the specified time and interval.


Was this document helpful?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial
Zoho Books

VAT compliant accounting
software for small
businesses.

Maybe Later