Cash Forecast AR Aged Analysis Report

Created by Jess Miller, Modified on Mon, 11 Mar, 2024 at 11:13 AM by Jess Miller

Cash Forecast AR Aged Analysis

Creation Date: February 19, 2024

Created By: Finance Silvertrek

View most recent version 



1. Verify you are in the correct company in Vista Go into Accounts Receivable

Verify you are in the correct company in Vista Go into Accounts Receivable

2. Accounts Receivable> Reports

Accounts Receivable> Reports

3. Accounts Receivable>Reports> Double Click AR Aged Analysis by Customer/Contract

Accounts Receivable>Reports> Double Click AR Aged Analysis by Customer/Contract

4. Select your aging date

In most cases you will want all AR up to your cash forecast, this helps you stay on top of any AR payments that still need to be collected and gives you a review of what money could be coming in to better plan your week.

Select your aging date

5. Select Preview to Begin exporting your document

Select Preview to Begin exporting your document

6. Select the icon to begin your export

Select the icon to begin your export

7. File Format: PDF

There are many ways to export, export to your needs in this case we will use a PDF to save it for later use in reviewing.

File Format: PDF

8. Save your document

Save your document

9. Go into Dropbox and click into the correct customer folder

Go into Dropbox and click into the correct customer folder

10. Go into Customer Folder> Management Folder> Cash Forecast> Current YYYY> Current MM Saved AR Aging and add the week of the cash forecast

Go into Customer Folder> Management Folder> Cash Forecast> Current YYYY> Current MM 
Saved AR Aging and add the week of the cash forecast

11. Go into your Main Tab of the cash forecast and add your AR Aged Analysis total to the relevant file. *Reference your Cash Forecast Template*

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article