--- title: Using the AR Aging Report description:   Setting the date in the selection modal to the last day of the period will run the report as if it was that day and only include transactions dated on or before that date.  When you are satisfied wi --- [Skip to content](https://support.paragon-erp.com/using-the-ar-aging-report#main-content) English Show submenu for translations [![paragon logo-1.png\]](https://support.paragon-erp.com/hs-fs/hubfs/paragon%20logo-1.png?width=240&height=75&name=paragon%20logo-1.png)](https://support.paragon-erp.com/?hsLang=en) - [New Ticket](https://share-eu1.hsforms.com/1PiwaZCxTRpabuHVnQxGeXQc751y) - [Tickets](https://help.paragon-erp.com/tickets) - [Knowledge Base](https://support.paragon-erp.com/) - [Sign out](https://20488534.hs-sites.com/_hcms/mem/logout) Open main navigation Close main navigation - [New Ticket](https://share-eu1.hsforms.com/1PiwaZCxTRpabuHVnQxGeXQc751y) - [Tickets](https://help.paragon-erp.com/tickets) - [Knowledge Base](https://support.paragon-erp.com/) - [Sign out](https://20488534.hs-sites.com/_hcms/mem/logout) - English Show submenu for translations - [Go to website](https://www.paragon-erp.com/) [Go to website](https://www.paragon-erp.com/?hsLang=en) Welcome! Search our Knowledge Base. - There are no suggestions because the search field is empty. 1. [ParagonERP](https://support.paragon-erp.com/?hsLang=en) 2. [Reports](https://support.paragon-erp.com/reports?hsLang=en) May 28, 2025 # Using the AR Aging Report ### Introduction If you're using a system such as ParagonERP, you are no doubt selling products, services, or both and therefore would likely want to be paid for your hard work. Once you issue invoices to your clients, you need the ability to see, at a glance, who owes you what and when it is due. That's where the AR Aging Report will come in handy. This report can be run from the customer screen and will list which invoices are still outstanding for each client, if they have any credits they can apply to their account(s), and when this money is due to hit your bank.   #### **Print the AR aging report for one customer** Navigate to the customer module from anywhere in Paragon by clicking the **customer** button on the navigation bar on the right. Once you are in the customer module, open the detail view of any customer and click the **action list** button. You will see a print option for **aged AR**.    ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/edbsn72a8f657c8427e5900e3229259549c3589fe55ee23ef0006271af9bf28c2e87967d76772c0c7459552d28395f0f80fc9-1-1-3-1.png)   Click on **aged AR**. It will open a modal where you can select the **template** you want to use.   ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202024-08-07%20095239-png.png?width=523&height=429&name=Screenshot%202024-08-07%20095239-png.png)   The default layout is Customer AR Aging. This is the only layout available, unless you have a customized aging report available to you. Select the template. Your next option is **export report to**. Here you will have two options; PDF and Excel.    ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202024-08-07%20095920-png.png?width=513&height=416&name=Screenshot%202024-08-07%20095920-png.png)   The PDF option will produce the report in PDF format. The Excel option will produce an Excel file, as sampled below.   ![](https://support.paragon-erp.com/hs-fs/hubfs/Knowledge%20Base%20Import/edbsn580cd18a5f2940a0799a9c79c582e19ac7453c44600a4155c42e906201604bbdc15be942a5da22d111749118a3683b61-1-1-3-1.png?width=688&height=150&name=edbsn580cd18a5f2940a0799a9c79c582e19ac7453c44600a4155c42e906201604bbdc15be942a5da22d111749118a3683b61-1-1-3-1.png)   The last option on the **aged AR selection** screen is **run as of**. Enter the end date that you want to use for your report.   ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202024-08-07%20100816-png.png?width=516&height=423&name=Screenshot%202024-08-07%20100816-png.png)   Setting the date in the selection modal to the last day of the period will run the report as if it was that day and only include transactions dated on or before that date.      When you are satisfied with your selections, click **accept** to print the AR aging report for this customer.  #### Print the AR aging report for all customers or specific customers Navigate to the list view. ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-05-27%20104805-png.png?width=688&height=224&name=Screenshot%202025-05-27%20104805-png.png)   You are looking for the **bulk edit** function. In order to access this feature, you must select one or more customers from the list. ![](https://support.paragon-erp.com/hs-fs/hubfs/Bulk%20actions-jpg.jpeg?width=688&height=248&name=Bulk%20actions-jpg.jpeg)     Click the **bulk actions** button.  Bulk actions will open a mini modal that allows you to apply an action across your selected entries.  ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-05-27%20105508-png.png?width=375&height=204&name=Screenshot%202025-05-27%20105508-png.png) Click on **aged AR**. You will be asked to confirm that you want to proceed with your selections. ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-05-27%20105826-png.png?width=474&height=357&name=Screenshot%202025-05-27%20105826-png.png) Click the *yes* option and then the **accept** button to continue. It will open a modal where you can select the template you want to use.  ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-05-27%20110312-png.png?width=512&height=418&name=Screenshot%202025-05-27%20110312-png.png)  In most cases, you will only have one template to choose; *customer AR aging.* If you have created custom aging reports, you will see a list to choose from. After you have selected the template, the report will be generated and will include the information for all the customers that you selected.      ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/edbsn39c01096ac7427875dae296e5adfb22595b0c1da29dc7a9a98fba95d9670521126d3230ee7b5c94ea0c7ed26ec3f958f-1-1-3-1.png)   Using the bulk edit option, you still have the option to export directly to Excel.   ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-05-27%20110845-png.png?width=510&height=420&name=Screenshot%202025-05-27%20110845-png.png)   #### **Currency and customer totals** The AR Aging report displays information by currency and customer, listing each currency and then displaying each customer and their transactions within that currency. If there is no due date, the transaction date is used. 1. A total is calculated for each customer (calculation = invoices - payment - credit) 2. A total is calculated for each currency and shows the sum of all customer totals within that currency. The columns include: \- **due date**: the due date from the transaction (if applicable) \- **transaction**: type of transaction being displayed and the transaction number \- **total**: total dollar amount for that customer amount \- **current, 0-30 days, 31-60 days, 61-90 days, and +90 days**: these columns will be filled with the total dollar amount for each transaction based on their due dates (if applicable)   #### What's next? If you're looking to explore more reports in Paragon, or need help on how to use them, check out some of these articles: [Customer and vendor history reports](https://support.paragon-erp.com/customer-and-vendor-history-wigo-reports?hsLang=en) [Product profitability report](https://support.paragon-erp.com/product-profitability-report-wigo?hsLang=en) [Wigo reports](https://support.paragon-erp.com/wigo-business-intelligence-reporting?hsLang=en) [Using the AP aging report](https://support.paragon-erp.com/using-the-ap-aging-report?hsLang=en)       - [Paragon Basics](https://support.paragon-erp.com/paragon-basics?hsLang=en#main-content) - [Paragon Modules & Features](https://support.paragon-erp.com/paragon-basics?hsLang=en#paragon-modules-features) - [Basic use Paragon](https://support.paragon-erp.com/paragon-basics?hsLang=en#basic-use-paragon) - [Advanced use Paragon](https://support.paragon-erp.com/paragon-basics?hsLang=en#advanced-use-paragon) - [Paragon policies](https://support.paragon-erp.com/paragon-basics?hsLang=en#paragon-policies) - [Customer](https://support.paragon-erp.com/paragon-basics?hsLang=en#customer) - [Configuring Paragon](https://support.paragon-erp.com/configuring-paragon?hsLang=en#main-content) - [Basic Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#basic-settings) - [Advanced Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#advanced-settings) - [My Company Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#my-company-settings) - [User Management & Access](https://support.paragon-erp.com/configuring-paragon?hsLang=en#user-management-access) - [Import & Export](https://support.paragon-erp.com/configuring-paragon?hsLang=en#import-export) - [Attributes](https://support.paragon-erp.com/configuring-paragon?hsLang=en#attributes) - [PDF Templates](https://support.paragon-erp.com/configuring-paragon?hsLang=en#pdf-templates) - [Configuring - Aloha](https://support.paragon-erp.com/configuring-paragon?hsLang=en#configuring-aloha) - [Product](https://support.paragon-erp.com/configuring-paragon?hsLang=en#product) - [Associations](https://support.paragon-erp.com/configuring-paragon?hsLang=en#associations) - [Purchase](https://support.paragon-erp.com/purchase?hsLang=en#main-content) - [Vendor & Product](https://support.paragon-erp.com/purchase?hsLang=en#vendor-product) - [Purchase Order](https://support.paragon-erp.com/purchase?hsLang=en#purchase-order) - [In Transit & Receiving](https://support.paragon-erp.com/purchase?hsLang=en#in-transit-receiving) - [Vendor Invoicing](https://support.paragon-erp.com/purchase?hsLang=en#vendor-invoicing) - [Vendor](https://support.paragon-erp.com/purchase?hsLang=en#vendor) - [Manufacturing](https://support.paragon-erp.com/manufacturing?hsLang=en#main-content) - [Work Orders](https://support.paragon-erp.com/manufacturing?hsLang=en#work-orders) - [Bill of Materials](https://support.paragon-erp.com/manufacturing?hsLang=en#bill-of-materials) - [material](https://support.paragon-erp.com/manufacturing?hsLang=en#material) - [Inventory](https://support.paragon-erp.com/inventory?hsLang=en#main-content) - [Warehouse Management](https://support.paragon-erp.com/inventory?hsLang=en#warehouse-management) - [Inventory Adjustment](https://support.paragon-erp.com/inventory?hsLang=en#inventory-adjustment) - [Inventory Value](https://support.paragon-erp.com/inventory?hsLang=en#inventory-value) - [Inventory Transfer](https://support.paragon-erp.com/inventory?hsLang=en#inventory-transfer) - [Picking](https://support.paragon-erp.com/inventory?hsLang=en#picking) - [Packing](https://support.paragon-erp.com/inventory?hsLang=en#packing) - [Sales](https://support.paragon-erp.com/sales?hsLang=en#main-content) - [Sales Order](https://support.paragon-erp.com/sales?hsLang=en#sales-order) - [Reservations](https://support.paragon-erp.com/sales?hsLang=en#reservations) - [Returns](https://support.paragon-erp.com/sales?hsLang=en#returns) - [Invoicing](https://support.paragon-erp.com/sales?hsLang=en#invoicing) - [Finance](https://support.paragon-erp.com/finance?hsLang=en#main-content) - [Financial Settings](https://support.paragon-erp.com/finance?hsLang=en#financial-settings) - [GL Mapping](https://support.paragon-erp.com/finance?hsLang=en#gl-mapping) - [Journal Entries](https://support.paragon-erp.com/finance?hsLang=en#journal-entries) - [Reports](https://support.paragon-erp.com/reports?hsLang=en#main-content) - [Financial Reporting](https://support.paragon-erp.com/reports?hsLang=en#financial-reporting) - [WIGO](https://support.paragon-erp.com/reports?hsLang=en#wigo) - [Integrations](https://support.paragon-erp.com/integrations?hsLang=en#main-content) - [QuickBooks](https://support.paragon-erp.com/integrations?hsLang=en#quickbooks) - [Minox](https://support.paragon-erp.com/integrations?hsLang=en#minox) - [Shopify](https://support.paragon-erp.com/integrations?hsLang=en#shopify) - [2Ship](https://support.paragon-erp.com/integrations?hsLang=en#2ship) - [Mobile](https://support.paragon-erp.com/integrations?hsLang=en#mobile) - [Google](https://support.paragon-erp.com/integrations?hsLang=en#google) - [Release Notes & Rules](https://support.paragon-erp.com/release-notes-rules?hsLang=en#main-content) - [Rules](https://support.paragon-erp.com/release-notes-rules?hsLang=en#rules) - [Release Notes](https://support.paragon-erp.com/release-notes-rules?hsLang=en#release-notes) - [Transactions](https://support.paragon-erp.com/transactions?hsLang=en#main-content) - [Receive Payment](https://support.paragon-erp.com/transactions?hsLang=en#receive-payment) - [Transaction Basics](https://support.paragon-erp.com/transactions?hsLang=en#transaction-basics) - [Quote](https://support.paragon-erp.com/transactions?hsLang=en#quote) - [Sales Order](https://support.paragon-erp.com/transactions?hsLang=en#sales-order) - [Make Payment](https://support.paragon-erp.com/transactions?hsLang=en#make-payment) - [Credit](https://support.paragon-erp.com/transactions?hsLang=en#credit) - [Invoice](https://support.paragon-erp.com/transactions?hsLang=en#invoice) [![Logo for ParagonERP](https://support.paragon-erp.com/hs-fs/hubfs/paragon%20logo.png?width=401&height=126&name=paragon%20logo.png "Logo for ParagonERP")](https://www.paragon-erp.com?hsLang=en) We do our utmost to share all relevant information for our customers here. Still missing the answer to a question? Then please contact support. Copyright © 2026, ParagonERP