Go into Vista and verify you are in the correct company.
2
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
4
Select Refresh to use current month for cash forecast
5
Right click in the grid to open the drop down
6
Select Export Grid
7
Select the dropdown tab under Action: Export to Microsoft Excel
8
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
10
Save the file as M.DD Outstanding Checks
11
Select Save
12
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
14
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
16
Right click on the new tab and select "Rename", rename the tab to Outstanding Checks and press enter
17
Go Below and enter: CHK
18
Click into the column with your totals
19
Highlight all Amounts that are labeled CHK
20
Press AutoSum to calculate the totals
21
Underneath CHK and enter DEP
22
Highlight all Amounts that are labeled DEP
23
Press AutoSum to calculate their totals
24
Save your work in your Cash Forecast
Well done!
Create how-to guides like this in a snap. Get Tango now.
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key
