AC-AR-RT10 AR Aging Summary by Customers

Applies to

• Product version: Velixo NX, Velixo Classic
• ERP: Acumatica, MYOB Advanced, Cegid XRP Flex, Hotel Investor Apps, Haufe x360
• Functional area: All
• Plan: All
• Template type: Production Report template

TABLE OF CONTENTS

• Applies to
• Description
• Coverage
• Typical audience
• Features
• Preview
• Download this template
• Documentation
  • Filter
  • AR Transactions Detailed Report
  • AR Aging Summary Report
• User Guide
  • Using the report
  • Using the Control report
• Version History

Description

The AC-AR-RT10 AR Aging summary by Customers report provides an overview of the outstanding balances owed to a company, categorized by the length of time the invoices have been outstanding. This report also helps businesses monitor the health of their accounts receivable by identifying overdue payments, tracking the aging of outstanding invoices, and highlighting potential cash flow issues.

Coverage

This workbook includes the following sample reports:

Typical audience

The typical users of this type of report are Finance professionals: Accountants, CFOs, Controllers 

Features

The following features are used by this report. To use this report, please ensure that your Velixo license includes all of them, (or contact Support or Sales):

• Financial functions
• List functions
• Generic Inquiry functions

Preview

Download this template

Important: To use the sample reports, you will need to download the below Velixo-AR-Aging Generic Inquiry required by this Template and uploading that inquiry into the appropriate tenant of your ERP.

Download Report

Download Generic Inquiry Velixo-AR-Aging

Documentation

The AC-AR-RT10 AR Aging Summary by Customer report provides a concise breakdown of outstanding balances by customer accounts and aging periods. Its user-friendly interface ensures effortless execution, requiring minimal effort for comprehensive insights into accounts receivable status.

Filter

Located in the upper left of the AR Transactions sheet, the filters include:

• Branch: lists all branches present in Acumatica. For ease of use, Velixo shows you the Branch ID that you may be familiar with along with the Branch name.
• Customer: giving users options to filter the data to a specific customer only. 
• Project ID: giving users options to filter the data to a specific project only.
• As of: a Financial Period field in MM-YYYY format. The report will extract all open AR transactions as of the period specified on this field. If left blank, this is defaulted to current period.
• Aging by: will be the basis of the aging days calculations. Users can select from Document date or Due date.

These filters are seamlessly linked to the data on the Options tab:

AR Transactions Detailed Report

The report is created to gather all important basic information for an aging report. It is neatly organized in a table and includes these key details:

• Transaction type
• Customer
• Project
• Branch
• Reference or Document number
• Dates
• Amount

Additional details were added as well to aid users with the analysis:

• Due in days
• Aging bucket
• % of aging per customer
• % of aging per bucket

AR Aging Summary Report

The summarized report is derived from the AR Transaction detailed report and is presented in Pivot table format. It is categorized by aging bucket and displays various types of calculations. Users have the flexibility to customize the table accordingly based on their needs.

For user convenience in isolating negative amounts within the Pivot table, Velixo has added the Negative AR Pivot slicer. This feature allows users to seamlessly filter the table to exclusively display negative amounts, which may be categorized as Prepayments, Payments, or Credit Memos in Acumatica.

Charts are added as well to aid users in visualization of the data.

User Guide

Using the report

• Set the Connection Name on the Options sheet: crucial for all processes, set the Connection Name on the Options sheet by updating cell A2. Ensure it matches the name used during Velixo application login.

• Update the Options Sheet: as the foundation for all filters on the AR Transactions tab, keep the Options sheet up to date. It should always automatically capture the latest dimension and structures from your Sage Intacct instance
• Velixo have set multiple aging bucket by default in columns K and L. However, user can always customize it to fit their requirements.

On the AR Transactions sheet, choose the desired filter:

• Branch
• Customer
• Project
• As of in MM-YYYY format (this will default to current period if left blank)
• Aging by

• Automatic report update: selecting any filter will automatically update the AR Transaction table

• Once everything is set on the filter and the AR transactions tab has been fully refreshed, go to the AR Aging Summary tab to refresh the Pivot table. Refreshing the Pivot table will automatically refresh the charts.

• Validation and analysis: ensure accuracy by verifying balances in the Control sheet.

Specify the default Accounts Receivable (AR) GL code and Ledger (ACTUAL is set as default) on your Acumatica instance to ensure accurate data retrieval for the GL balance. Branch and Year will be based on the filters set on the AR Transactions tab.

Using the Control report

Committed to upholding data integrity across the report and Acumatica, the Control sheet serves as a supplementary component to the primary AR aging report sheets. Its purpose is to validate the AR data extracted by Velixo by period and cross-referencing it with the extracted balances at AR GL code level.

The Control sheet is divided into three sections:

• By Period balance check: Extracting GL balances by period of the specified year. This is automatically updated based on the date set on the As of field on the AR Transaction sheet filter.
• Aging Balance: the total balance per period extracted on the AR Transactions sheet. The unrealized gain/loss is added as well for more accurate reconciliation.
• Differences: Highlights reconciliatory differences between the AR GL code and the aging report by period.

Version History