An Aging report is a powerful financial tool that provides businesses with a snapshot of their accounts receivable or payable.

This report helps organizations monitor their cash flow, evaluate their financial health, and track outstanding payments. The Aging report shows how long invoices or bills have been outstanding, allowing businesses to prioritize their collection efforts or payment schedules. This report is particularly useful for companies that have payment terms, enabling them to identify overdue accounts and take appropriate action.

In this knowledge base article, we will discuss the features and benefits of the Aging report and how it can help businesses manage their finances more effectively.

Before You Start

• Aging Report requires Manager, Admin, or Owner permission level

How to Use the Aging Report

To access the Aging Report, follow these steps:

1. From your ServiceCore Dashboard, click "Reports"
2. Click on the "View Report" button for the Aging Report
3. Use the "As Of" filter to specify a date. Learn more About Date Filters here.
4. Use the "Customer Search" filter to look up specific customers.
5. Use the "Customer Name" filter to further specify customers.

   • Contains: This filter retrieves customer names that contain a specific sequence of characters. For example, if you search for "John" using the "Contains" filter, it will return names like "John Smith" or "Jonathan Johnson."

   • Does not contain: This filter excludes customer names that contain a specific sequence of characters. For instance, if you search for "Doe" using the "Does not contain" filter, it will exclude names like "John Doe" or "Jane Doe."

   • Starts with: This filter retrieves customer names that begin with a specific sequence of characters. For example, if you search for "Joh" using the "Starts with" filter, it will return names like "John Smith" or "John Doe."

   • Does not start with: This filter excludes customer names that start with a specific sequence of characters. For instance, if you search for "Joh" using the "Does not start with" filter, it will exclude names like "John Smith" or "John Doe."

   • Ends with: This filter retrieves customer names that end with a specific sequence of characters. For example, if you search for "son" using the "Ends with" filter, it will return names like "Jackson" or "Anderson."

   • Does not end with: This filter excludes customer names that end with a specific sequence of characters. For instance, if you search for "son" using the "Does not end with" filter, it will exclude names like "Jackson" or "Anderson."

   • Like: This filter allows you to search for customer names using wildcard characters. For example, if you search for "Jhn" using the "Like" filter, it will return names like "John Smith" or "Jonathan Johnson," where the asterisk () represents any number of characters.

   • Not like: This filter excludes customer names that match a specific pattern using wildcard characters. For instance, if you search for "J*hn" using the "Not like" filter, it will exclude names like "John Smith" or "Jonathan Johnson."

     
6. Use the "Aging Bucket" filter to specify which aging periods you'd like to see.
7. Use the "Total Aging Amount" to filter out the aging report by specific minimum and maximum transaction amounts.
8. Use the "Type" filter to specify which kinds of transactions you'd like to see.
9. Use the "Customer Is Active?" filter to specify active and inactive customers.
10. Use the "Division" filter to narrow down the results by division.

Sending or Printing Statements via the Aging Report

The Aging Report includes a convenient Statements feature that allows you to easily print or email statements to all your customers. The statements will be sent or printed to customers listed in the "Balances by Customer" section of the report. Before sending them out, remember to set your filters accordingly so that you target the correct customers.

To email statements for your customers:

1. Utilize the different filters at your disposal to refine your customer selection, focusing solely on those you wish to email a statement to.
2. Hover your mouse cursor over the "Send Statements" section.
3. Click on the "Click to Send Statements" link.
4. This will open up a new tab with a landing page asking you to "Review Your Statements Summary"
5. Once you've reviewed the statements summary, click "Send Now."

To print statements for your customers:

1. Utilize the different filters at your disposal to refine your customer selection, focusing solely on those you wish to print a statement for.
2. Hover your mouse cursor over the "Print Statements" section.
3. Click on the "Click to Print Statements" link.
4. This will open up a new tab with a landing page asking you to "Review Your Statements Summary"
5. Once you've reviewed the statements summary, click "Send Now."
6. Check your email for an email from no-reply@servicecore.com with the subject: "Batch Statements."
7. Download and print the attached PDF document.

How to Export the Aging Report

If you'd like to export the report into a CSV or Excel file, follow these steps:

1. Make sure you've set up any filters to narrow results down to just the data you would like to see.
2. Scroll down to the "Balances by Customer" portion of the report.
3. Hover over any area in the Details portion of the report to bring up the (additional menu name thing here)
4. Click on the 3 Vertical Dots
5. Hover over the "Download >" option.
6. Select your preferred file type.
7. A download will appear with your selected file.