Cash Forecast Outstanding Checks Tab

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

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

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

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

  3. 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. 4. Select Refresh to use current month for cash forecast

    Select Refresh to use current month for cash forecast

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

    Right click in the grid to open the drop down

  6. 6. Select Export Grid

    Select Export Grid

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

    Select the dropdown tab under Action: Export to Microsoft Excel

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

    Select the ".." icon to save the file

  9. 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. 10. Save the file as M.DD Outstanding Checks

    Save the file as M.DD Outstanding Checks

  11. 11. Select Save

    Select Save

  12. 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. 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. 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. 15. Remove the previous Outstanding Checks tab in your Cash Forecast

    Remove the previous Outstanding Checks tab in your Cash Forecast

  16. 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. 17. Go Below and enter: CHK

    Go Below and enter: CHK

  18. 18. Click into the column with your totals

    Click into the column with your totals

  19. 19. Highlight all Amounts that are labeled CHK

    Highlight all Amounts that are labeled CHK

  20. 20. Press AutoSum to calculate the totals

    Press AutoSum to calculate the totals

  21. 21. Underneath CHK and enter DEP

    Underneath CHK and enter DEP

  22. 22. Highlight all Amounts that are labeled DEP

    Highlight all Amounts that are labeled DEP

  23. 23. Press AutoSum to calculate their totals

    Press AutoSum to calculate their totals

  24. 24. Save your work in your Cash Forecast

    Save your work in your Cash Forecast