Cash Forecast Outstanding Checks Tab

Created by Jess Miller, Modified on Fri, 23 Feb, 2024 at 8:29 AM by Jess Miller

Cash Forecast Outstanding Checks Tab

Creation Date: January 31, 2024

Created By: Finance Silvertrek

View most recent version

1. Go into Vista and verify you are in the correct company.

Go into Vista and verify you are in the correct company.

2. Go into the Cash Management Module>Programs> CM Clear Entries

Go into the Cash Management Module>Programs> CM Clear Entries

3. Press F4 to select or type in the CM Account you need to export

Press F4 to select or type in the CM Account you need to export

4. Select Refresh to use current month for cash forecast

Select Refresh to use current month for cash forecast

5. Right click in the grid to open the drop down

Right click in the grid to open the drop down

6. Select Export Grid

Select Export Grid

7. Select the dropdown tab under Action: Export to Microsoft Excel

Select the dropdown tab under Action: Export to Microsoft Excel

8. Select the ".." icon to save the file

Select the ".." icon to save the file

9. In dropbox go into the Customer Folder>Management>YYYY>MM>Week

Sometimes your Cash Forecast is saved in a different folder

In dropbox go into the Customer Folder>Management>YYYY>MM>Week

10. Save the file as M.DD Outstanding Checks

Save the file as M.DD Outstanding Checks

11. Select Save

Select Save

12. Once you have your folder named and saved in the relevant location, press OK

Once you have your folder named and saved in the relevant location, press OK

13. Go into the Outstanding Checks file you saved and open up the file so we can add it to your Cash Forecast

Go into the Outstanding Checks file you saved and open up the file so we can add it to your Cash Forecast

14. Having your Cash Forecast Open, take the tab in your Outstanding Checks file and drag it into your Cash Forecast

Having your Cash Forecast Open, take the tab in your Outstanding Checks file and drag it into your Cash Forecast

15. Remove the previous Outstanding Checks tab in your Cash Forecast

Remove the previous Outstanding Checks tab in your Cash Forecast

16. Right click on the new tab and select "Rename", rename the tab to Outstanding Checks and press enter

Right click on the new tab and select "Rename", rename the tab to Outstanding Checks and press enter

17. Go Below and enter: CHK

Go Below and enter: CHK

18. Click into the column with your totals

Click into the column with your totals

19. Highlight all Amounts that are labeled CHK

Highlight all Amounts that are labeled CHK

20. Press AutoSum to calculate the totals

Press AutoSum to calculate the totals

21. Underneath CHK and enter DEP

Underneath CHK and enter DEP

22. Highlight all Amounts that are labeled DEP

Highlight all Amounts that are labeled DEP

23. Press AutoSum to calculate their totals

Press AutoSum to calculate their totals

24. Save your work in your Cash Forecast

Save your work in your Cash Forecast