How to Generate Supplier Aging & Supplier Ledger Reports

Supplier Aging

Monitor all your unpaid bills especially bills that are due by generating a 12 Months Supplier Aging Report. This report calculates aged days based on the terms you agreed upon with your supplier and selected under the Supplier’s Maintenance and Transaction forms.

Let’s try to Preview the 12 Months Supplier Aging Report. Go back to the Supplier Reports Menu, expand Supplier Aging, and click on the 12 Months Supplier Aging to generate.

Select the Report’s Date and set other preferred filters to generate your report. If you want to cover everything, you can leave the filters blank. 

You may exclude suppliers by their status by check mark the Exclude Active, Inactive or Suspended. Do not checkmark anything if you prefer to include all suppliers. Use ‘Sort By’ to determine how the data sequence is arranged.

Once filtered, click “Preview” and a new browser Tab will open to show the generated 12 Months Supplier Aging report.

Supplier Ledger

As a counterpart of your Accounts Receivable or your Customer Ledgers discussed in the previous chapter, the Supplier Ledger Report, or the report consisting of all transactions relating to every Supplier, may also be generated in QNE.

Under the same Supplier Reports Menu, expand Other Reports and select Supplier Ledger.

Set your Report Filters as required, such as the Date Range of your report, Supplier Accounts range to capture, and many others. You may also opt to keep it all blank to include all data. Enable the ‘Include PD Cheque’ option to include all Payments made as Post Dated Cheque. 

Once filtered, click “Preview” and another Tab will open to show the generated Supplier Ledger report.