AR Reports

Overview

  • AR Reports
    All AR sales and transaction reporting can be found under the reports menu.  

    Reports:
    - AR Report: Provides a high-level summary of all outstanding receivables, including total balances, customer aging brackets, and open credit amounts.
     
    - AR Aging: Breaks down overdue balances by age buckets (e.g., 30/60/90+ days), allowing for effective collection prioritization and financial risk tracking.

    Sales:
    - Daily Sales Report: Offers a snapshot of all invoiced sales within a single business day — ideal for daily performance tracking.
     
    - Weekly Sales Report: Aggregates sales data over a 7-day span to highlight mid-range trends and sales velocity.
     
    - Monthly Sales Report: Presents high-level sales activity across a full calendar month, including totals by customer, product, or sales rep.
     
    - Sales Detail Report: Delivers line-item level reporting on all invoiced sales transactions, allowing for granular review and product-level performance.

    Registers:
    - Invoice: Lists all invoices generated within a selected date range, including invoice numbers, amounts, and customer info.

    - Credit: Tracks credit memos issued to customers, including the original invoice reference, reason codes, and amounts.

    - Overpayment: Identifies instances where payments exceed invoiced totals, helping manage credit balances and potential refunds.

    Transactions:
    - AR Cash Receipts: Logs all incoming customer payments, whether via check, ACH, or credit card, including applied and unapplied balances.
     
    - AR Credits: Lists customer credits issued, with associated reasons and links to original transactions.
     
    - AR Adjustments: Displays manual AR adjustments such as write-offs, account corrections, and payment reapplications.
     
    - AR Misc. Cash: Captures non-invoice-related cash entries, such as deposits or one-off customer payments, for complete AR visibility.

    How to Use These AR Reports for Smarter Financial Management
    Each report listed above is designed to serve a specific purpose in the Accounts Receivable lifecycle, enabling teams to track revenue, monitor customer payment activity, and maintain financial control. Understanding how to use these tools effectively is key to maximizing the value of your ERP system.

    • Improve Cash Flow & Collections
    Use the AR Report and AR Aging to identify overdue accounts and prioritize follow-up. These reports help finance teams take proactive steps to reduce outstanding balances and improve liquidity.
     
    • Drive Sales Visibility & Performance
    Daily, Weekly, and Monthly Sales Reports allow sales and finance managers to monitor invoicing trends, track rep performance, and spot revenue fluctuations. This insight supports both short-term adjustments and long-term sales strategy.
     
    • Audit-Ready Documentation
    The Invoice, Credit, and Overpayment Registers ensure your records are always audit-ready. Having clear, well-organized documentation streamlines both internal reviews and external audits.
     
    • Enhance Customer Account Management
    Reports like AR Cash Receipts, AR Credits, and AR Adjustments provide a comprehensive view of each customer’s financial activity. These are essential tools for resolving disputes, issuing refunds, or reviewing payment history before future transactions.
     
    • Track Non-Standard Cash Entries
    The AR Misc. Cash report helps account for cash transactions not tied to invoices, ensuring that no customer payment goes untracked.

    Together, these AR reports offer real-time insights, actionable data, and full visibility into customer financial activity—all critical for managing receivables efficiently and making confident business decisions. We are continually developing new reports and enhancing existing ones to ensure users have access to the most relevant and powerful financial tools within the Inspired Technology Systems ERP.

AR

  • AR
    1. Go to the Reports Menu and click on the AR Sub-Menu



    2. You are now viewing the Accounts Receivables for all customers

  • AR Aging
    1. Go to the Reports Menu and click on the AR Aging Sub-Menu 



    2. You are now viewing the open accounts receivables for all customers



    Note: Only customers with an open AR Balance will appear on this report

Sales

  • Key Information

    Sales Details Listing:

    Displays all sales across all customers by invoice line.  

    Sales Daily Listing:

    Displays all sales across all customers for a particular day by invoice date, per service, per item.  

    Sales Weekly Listing:

    Displays all sales across all customers for a particular week by invoice year/week, per service, per item.  

    Note: Each week begins on a Saturday and ends of the following Friday.  

    Sales Monthly Listing:

    Shows all sales across all customers for a particular cycle by cycle, per service, per item. 

    Top Sales Report:

    Shows all subtotaled sales across all customers with the option to order by high to low values.

    Sales Reports Features:

    Excel Downloads: Download an excel sheet of any sales report table 



    Subtotals: Generate subtotals by customer, customer class, item, item class, service, salesman and address ID



    All * Customers Grouping: Generate totals across all customers



    Prior Year Comparisons: Compare the prior year's monthly values 

  • Sales Details

    To View the Sales Details Report: 

    1. Go to the Reports Menu and click on the Sales Details Sub-Menu



    2. You are now viewing all of the sales details (one record per order detail line) across all customers.  




    To Limit by Cycle:

    1. Enter a cycle in YYMM format and click the Search Button 

    Example: Cycle 4 of 2021 -> YYMM = 2104 




    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 




    To Generate Subtotals:


    Example 1: Subtotal by Service

    1. Select the appropriate option from the Subtotal By Drop Down 



    2. Enter either a Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note:     For the service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table 




    Example 2: Subtotal by Address ID

    1. Enter a Customer name (Required) 



    2. Select the appropriate option from the Subtotal By Drop Down 



    3. Enter either a Cycle or a From/To Date (Required)



    4. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note:     For the address id subtotal selection, entries will be shown by address id in descending date order with a subtotal at the end of each address id's transactions



    5. Click on Download Table to download an Excel Spreadsheet of the current table 

  • Sales Daily

    To View the Sales Daily Report: 

    1. Go to the Reports Menu and click on the Sales Daily Sub-Menu

     
    2. You are now viewing all of the sales daily details (one record per date, per service) across all customers. 




    To Limit by Cycle:

    1. Enter both a From and To Cycle in YYMM format and click the Search Button 
     
    Example: Cycle 1 of 2021 -> YYMM = 2101 
     




    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 




    To Generate Subtotals:     

    Example 1: Subtotal by Customer

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter either a From/To Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom

    Note: For the customer subtotal selection, entries will be shown by customer # (not name), in descending date order with a subtotal at the end of each customer's transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table




    Example 2: Subtotal by Customer Class

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter either a From/To Cycle or a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the customer class subtotal selection, entries will be shown by customer class name in descending date order with a subtotal at the end of each customer class' transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Sales Weekly

    To View the Sales Weekly Report: 

    1. Go to the Reports Menu and click on the Sales Weekly Sub-Menu
     


    2. You are now viewing all of the sales weekly details (one record per week, per service, per item) across all customers. 



    To Limit by Date: 

    1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 

    Note:     From Date must be a Saturday
    To Date must be a Friday
     



    To Subtotal by Item: 

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the item subtotal selection, entries will be shown by item number in descending date order with a subtotal at the end of each item's transactions



    4. Click on Download Table to download an Excel Spreadsheet of the current table  



    To Subtotal by Item Class: 

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Date (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the item class subtotal selection, entries will be shown by item class in descending date order with a subtotal at the end of each item class' transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Sales Monthly

    To View the Sales Monthly Report: 

    1. Go to the Reports Menu and click on the Sales Monthly Sub-Menu
     


    2. You are now viewing all of the sales monthly details (one record per month, per service, per item) across all customers. 



    To Limit By Cycle: 

    1. Enter either a From Cycle, To Cycle or both a From and To Cycle and click the Search Button 
     
    Note: Cycle 1 of 2021 -> YYMM = 2101
     
     



    To Subotal by Salesman:     

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Cycle (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the salesman subtotal selection, entries will be shown by salesman in descending date order with a subtotal at the end of each salesman's transactions 




    4. Click on Download Table to download an Excel Spreadsheet of the current table   



    To Subtotal by Service:

    1. Select the appropriate option from the Subtotal By Drop Down



    2. Enter a From/To Cycle (Required)



    3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom
     
    Note: For the service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions 



    4. Click on Download Table to download an Excel Spreadsheet of the current table
     
  • Top Sales

    Use our Cloud ERP WMS software's Top Sales Report to easily view the customers bringing in the most sales.   


    1. Go to the Reports Menu and click on the Top Sales Sub-Menu



    2. You are now viewing the sales made for the current month, ordered by customer, starting with those top sale customers






    Limit By Cycle 



    Limit By Customer, Item and/or Service



    Sort By Total Price, Total Quantity or Total Weight



    Download Excel Sheets 



    Compare Sales With The Previous Year



    Subtotal By Customer, Customer Class, Item Class, Item, Salesman and Service  




Registers

  • Key Information

    A/R Invoice Register Listing:

    Displays all basic positive invoices generated and their current payment status.

    Screen Overview:Type: Invoice 
    Against: Does not apply for basic invoices 
    Status: Open or Closed/Paid 
    Lines: The total number of service/item order detail lines 
    Total: The original total $dollar amount of the invoice 
    Paid: the total $dollar amount of what has been paid through cash receipts (*this includes applied credits)
    Adjustments: the total $dollar amount of negative adjustments made against an invoice 
    Credits:  the total $dollar amount of all against invoice credits applied to a particular invoice 
    Applied Credits: Does not apply for basic invoices 
    Open: the total $dollar amount of what is currently not paid for a particular invoice

    A/R Credit Register:
    Every AR against invoice credit and AR on account credit created generates a separate credit type invoice.  The A/R Credit Register displays all of these credit type invoices and their current payment status.

    Screen Overview:
    Against: For against invoice credits only, if the against invoice credit has been posted, the original invoice the credit was applied against is listed here
    Status: Open or Closed/Paid 
    Lines: The total number of service/item order detail lines 
    Total: The original total $dollar amount of the credit invoice 
    Paid: Does not apply for credit type invoices 
    Adjustments: the total $dollar amount of negative adjustments made against an invoice 
    Credits: Does not apply for credit type invoices  
    Applied Credits: the total $dollar amount of what has been applied of the credit invoice (against invoice credits are fully applied automatically once the credit posts, applied credits are applied only after applying through a cash receipt) 
    Open: the total $dollar amount of what is currently not applied for a particular credit invoice 

    A/R Overpayment Register:

    Displays credit invoices generated from overpayments and their current payment status.

    Screen Overview:
    Against: Does not apply for overpayment credits 
    Lines: The total number of service/item order detail lines 
    Total: The original total $dollar amount of the invoice 
    Paid: The total $dollar amount of what has been paid through cash receipts (this includes applied credits/applied overpayments)
    Adjustments: The total $dollar amount of negative adjustments made against an invoice 
    Credits: Does not apply for overpayments 
    Applied Credits: The total $dollar amount of what has been applied of a credit invoice (against invoice credits are applied automatically once the credit posts, applied credits resulting from overpayments are applied only after applying through a cash receipt) 
    Open: The total $dollar amount of what is currently not paid for a particular invoice or not applied for a particular credit invoice (credit invoices created for every on account and against invoice credit posted)

    A/R invoices/Credits/Over Payments:

    Displays all types of invoices generated and their current payment status.

    Screen Overview:
    Against: Against invoices credits generate a subsequent credit invoice that indicate which original invoice the credit was applied against 
    Lines: The total number of service/item order detail lines 
    Total: The original total $dollar amount of the invoice 
    Paid: The total $dollar amount of what has been paid through cash receipts (this includes applied credits)
    Adjustments: The total $dollar amount of negative adjustments made against an invoice 
    Credits: The total $dollar amount of all against invoice credits applied to a particular invoice 
    Applied Credits: The total $dollar amount of what has been applied of a credit invoice (against invoice credits are applied automatically once the credit posts, applied credits are applied only after applying through a cash receipt) 
    Open: The total $dollar amount of what is currently not paid for a particular invoice or not applied for a particular credit invoice (credit invoices created for every on account and against invoice credit posted)

    Register Features:

    Open Versus Closed/Paid:



    Excel Downloads:



    Note:     $0 invoices are left out by default 

  • AR Invoice Register

    To View the Invoice Register:


    1. Go to the Reports Menu and click on the AR Invoice Register Sub-Menu 



    2. You are now viewing all invoices across all customers



    To View Just Open or Closed/Paid Invoices:


    1. Select the Open or Closed/Paid Option from the Show Dropdown 



    To View Totals: 


    1. Select either a Customer, or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • AR Credit Register

    To View the Credit Register:

     
    1. Go to the Reports Menu and click on the AR Credit Register Sub-Menu 



    2. You are now viewing all posted credit invoices (both on account and against invoice credits) across all customers


    To View Just Open or Closed/Paid Credits:

     
    1. Select the Open or Closed/Paid Option from the Show Dropdown 



    To View Only On Account or Against Invoice Credits: 


    1. Select either Against Invoice or On Account from the Credit Type Dropdown 


    To View Totals: 

     
    1. Select either a Customer, and/or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • AR Overpayment Register

    To View the Overpayment Register:

    1. Go to the Reports Menu and click on the AR Overpayment Register Sub-Menu 
     
     
    2. You are now viewing all posted overpayment invoices across all customers
     
     

    To View Just Open or Closed/Paid Overpayments:

    1. Select the Open or Closed/Paid Option from the Show Dropdown 
     


    To View Totals:

    1. Select either a Customer, and/or enter a Date or Cycle (Required) 
     
     
    2. Click on the Show All Button  

     
    3. Click on Download Table to download an excel file

  • AR Invoices/Credits/Over-payments Register

    To View the AR Invoices/Credits/Over-payments Register:

     
    1. Go to the Reports Menu and click on the AR Invoices/Credits/Overpayments Register Sub-Menu 



    2. You are now viewing all invoices for all invoice types across all customers



    To View just Open or Closed/Paid Invoices/Credits/Over-payments:

     
    1. Select the Open or Closed/Paid Option from the Show Dropdown 


    To View Totals: 

     
    1. Select either a Customer, or enter a Date or Cycle (Required) 



    2. Click on the Show All Button 



    3. Click on Download Table to download an excel file

  • Tax Register
    The Tax Register showcases one row per order line, along with its tax rate and tax total.

    Note: Only credits made directly against invoices will be showcased on the Tax Register.  On Account Credits do not apply to the Tax Register. 


    1. Go to the Reports Menu and click on the Accounts Receivable Sub-Menu, then click on the Tax Register 






    Search by Customer



    Search by Period or Date



    View Invoices and/or Credits

     

    View Totals



Transactions

  • Key Information

    AR Invoice Adjustments:

    Report includes all posted invoice adjustments made to decrease the total of an invoice.   
     
    Example:
    Writeoff 

    AR Miscellaneous Cash:

    Report includes all posted miscellaneous cash entries that have been received. 
     
    Examples:Investment
    Miscellaneous Deposit

    AR Cash Receipts:

    Report includes all payments received, any applied on account credits and payment reversals (bounced checks) that have been posted. 

    Examples:
    Checks
    Cash
    Credit Cards
    ACH/Transfer/Wire
    Payment Reversals
    Payments Applying On Account Credits

    AR Credits:

    Report includes all posted AR Credits.

    Examples:
    Against Invoice 
    On Account
  • AR Invoice Adjustments

    To View AR Invoice Adjustments:

    1. Go to the Reports Menu and click on the AR Invoice Adjustments Sub-Menu



    2. You are now viewing all Posted AR Invoice Adjustments 



    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 

    Accepted Formats: MM/DD/YY or MMDDYY

    Examples:     12/07/20
    120720



    To Search by Cycle:

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 

    Accepted Format: YYMM

    Example:     2101



    To Search by Notes:

    1. Enter the Note and any other relevant inputs 
    Note: Only either  note1, note2 or amount can be searched over at once   



    To Search by Amount: 

    1. Enter the amount of the AR Invoice Adjustment(s) and any other relevant inputs 
    Note: Only either  note1, note2 or amount can be searched over at once 

  • AR Miscellaneous Cash

    To View AR Miscellaneous Cash Entries:

    1. Go to the Reports Menu and click on the AR Miscellaneous Cash Sub-Menu



    2. You are now viewing all Posted AR Miscellaneous Cash Entries  


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720

     

    To Search by Cycle: 

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example:
    2101


    To Search by Notes:

    1. Enter the note in either the Notes 1 or Notes 2 input field 
     
    Note:Only either  note 1, note 2 or amount can be searched over at once
    Notes entered into the Notes 1 field can only be searched within the Notes 1 field, not Notes 2, and vice versa  


    To Search by Amount: 

    1. Enter the amount of the AR Misc. Cash entry and any other relevant inputs 

    Note: 
     Only either  note 1, note 2 or amount can be searched over at once    



     
  • AR Cash Receipts

    To View AR Cash Receipts:

    1. Go to the Reports Menu and click on the AR Cash Receipts Sub-Menu



    2. You are now viewing all Posted AR Cash Receipts 


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720


    To Search by Cycle:

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example: 
    2101


    To Search by Check #:

    1. Enter the check # and any other relevant inputs 
     
    Note:
    Only either check #, amount or reference # can be searched over at once 


    To Search by Amount:     

    1. Enter the amount of the AR Cash Receipt(s) and any other relevant inputs 
     
    Note: 
     Only either check #, amount or reference # can be searched over at once 


    To Search by Reference Number: 

    Reference #: Reference numbers are required for Credit Card and ACH/Transfer/Wire Payments.  Once a Credit Card or ACH/Transfer/Wire Payment has been completed from an outside source, the reference number generated from that transaction must be included as part of the corresponding AR Cash Receipt. 
     
    1. Enter the reference # and any other relevant inputs 
     
    Note: 
     Only either check #, amount or reference # can be searched over at once

  • AR Credits

    To View AR Credits: 

    1. Go to the Reports Menu and click on the AR Credits Sub-Menu



    2. You are now viewing all Posted AR Credits (Against Invoice Credits and On Account Credits)


    To Search by Date: 

    1. Enter either a From, To or both a From and To Date and click on the Search Button 
     
    Accepted Formats: MM/DD/YY or MMDDYY
     
    Examples: 12/07/20
    120720


    To Search by Cycle: 

    1. Enter the Cycle Date and Cycle Year and click on the Search Button 
     
    Accepted Format: YYMM
     
    Example: 
    2101


    To Search for Credits Applied Against an Invoice: 

    1. Enter the invoice number the credit has been applied to and click on the Search Button 
     

AR Reconciliation