In this article, we will cover how to run a report to check for late payments. We'll use a very specific date range example (61 to 90 days after a quarter) so that you learn how to handle those situations when they come up. Please note, in order to run this report your agency must have and be using the EZLynx Accounting product because the report we will be using is specific to the Accounting product.


TABLE OF CONTENTS


Did you know? - You can click on the images in our articles to make them bigger!

Navigate to Aged Receivables 


First, let's navigate to the base report. 


1. Hover over the Reports icon on the left navigation bar to open the Reports menu.

2. Choose Accounting under the Categories section. This will take you to the Accounting Category Reports page. 

3. Scroll down to the Receivables section and choose Aged Receivables. This will take you to the Aged Receivables report. 


Set Date Range Filter


Second, we'll set the date filter. We will be looking at a date range of 61 days to 90 days after a quarter. However, the overall steps are the same if you follow a different standard operating procedure.


1. Select "is any time" under the As of Date. This will open the filter.

2. Select "is any time" to open the date type dropdown. This will let you customize the date filter.

3. Choose "is in range". This will let you choose a beginning date and an end date for the date range filter.



4. Select the first date box to open the date field. 

5. Select the Calendar icon to open the Calendar date selector. 

6. Using either the scroll bar or the Month/Year selector find the 61st day after the end of a quarter. Again, we are using a specific example, but the steps here are the same regardless of the date you are choosing.



7. Repeat steps 4-6 for the second date field which should be 90 days after the end of a quarter. Again, we are using a specific example, but the steps here are the same regardless of the date you are choosing. 




8. Your date range filter should now encompass the AR amount 61-90 days after a quarter. Now that we've adjusted our filters we need to apply them to the report. To apply the changes, select the Update button. This will apply the filters and refresh the report.

Aggregating Numbers


If you are looking to aggregate the data, you will need to complete this step in Excel. To download the report to excel please follow the steps below.


1. Scroll down to the Aged Receivables table and click the Dashboard Actions icon which is three vertical dots on the Dashboard card. Not the three vertical dots on the top right of the page which is the Report Actions. 

2. Choose Download data. This will open the Download window.

3. Choose either Excel Spreadsheet or CSV under the Format dropdown. 

4. Select the Download button. This will download only the Aged Receivables Dashboard data file to your computer where you can work on it further in Excel. This is great if you need to aggregate the data. 


AR Over 90 Day Example


Another example of tracking late payments, would be to check for anything more than 90 days after a quarter. The steps for this example would be the same except you would change the date range to be the 90th day after a quarter for the first date filter, and the second date filter would be yesterday's date. 

We hope this article was helpful in learning how to run a report to find late payments. Please let us know if this article was helpful by answering the question below. Check out our related articles on the right-side of the page to learn more about EZLynx!