The Order Management Report helps you track how much of one document has been converted into another and how much value is billed, pending, or exceeded.

Let’s take an example -

Suppose you have created a Sales Order of ₹2,00,000 for a client. 

Instead of billing everything at once, you raise invoices gradually:

> ₹30,000 this week
> ₹60,000 next month
> Remaining in later batches

Over time, multiple invoices get linked to the same Sales Order.

Now you need answers to simple but important questions:

1) How much of the Sales Order has already been invoiced?
2) Which invoices were raised against it?
3) How much is still pending to bill?
4) Did we accidentally overbill or underbill?

Without a report, you would need to open each invoice, calculate totals manually, or use spreadsheets.

The Order Management Report automatically calculates all of this for you and shows the complete utilisation status in one place.

How to generate the report

Firstly, go to Accounting Reports > Order Management Report:

You will see the following page:

To generate the report, simply choose -

• Source document (e.g., Sales Order)
• Converted document (e.g., Invoice)
• Date range

This defines what conversion you want to track - and over what period.

Just click on Apply Filters to generate the report:

How to Use the Report?

As you see, each row represents one source document (here for example, a Sales Order) and its utilisation:

How values are calculated

• Converted Amount = Total of all linked documents (e.g., all invoices created from the Sales Order)
• Utilisation %ge = (Total Converted Amount ÷ Source Document Amount) × 100
• Remaining = Source Document Amount − Total Converted

Viewing Converted Documents

To view all the documents converted from a source document, click on the "eye" icon:

slider will open:

Here, you can see:

• All documents converted from this source document
• Document Numbers
• Dates
• Individual amounts
• Payment status

This will help you verify exactly how the totals were calculated.

Downloading the report

You can export both **A) **the main report, and **B) **the converted document details of any specific source document.

Just look for the "Download CSV" option for sharing or further analysis.

Supported document flows

You can track utilisation between any linked documents, such as:

• Sales Order → Invoice

Track how much of each Sales Order has been invoiced and how much is still pending to be billed.

• Quotation → Invoice

Monitor which approved quotations have been converted into invoices and identify any missed or partial billing.

• Purchase Order → Purchase Invoice

Compare vendor bills against Purchase Orders to ensure you are billed correctly and avoid overcharges.

• Invoice → Delivery Challan

Verify that all invoiced items have been delivered and track pending or partial fulfilments.

That’s it!

If you have any questions, drop us an email at care@refrens.com OR reach out to us on the live chat support for quicker assistance!

Updated on: 13/02/2026