Click into File name: Highlight to rename your document
20
Your file will be titled by the Forecast Date & Title of the Report
21
Click Save
22
You can close out of Vista and start editing the AP Due Tab
23
Go into Customer>Management>Cash Forecast>Year>Month>Week
24
Select your saved AP Due Report
25
Double click to open
26
Enable Editing in your Excel File
27
Delete Columns K through O - right click and delete
28
Go through and remove any duplicate sections or anything from The Fringe Benefit Group - right click and delete
29
Click on any Vendors with the Unapproved Invoices and Highlight them
30
Save your work
31
Keep your AP Due Report Tab Open
32
Locate your Cash Forecast Template or Cash Forecast and double click to open
We date it YYYYMM Cash Forecast
33
Grab the tab of your AP Due Report and Drag into your Cash Forecast Excel
34
Delete the generic AP Due Tab on your template or Cash Forecast and title your new tab AP Due.
35
Save your Cash Forecast so it has your new changes and close out of the AP Due Report.
36
Final Step Create the Formula for AP Due invoice total
Column L is usually Orange and Column M is Green
37
Minimize column K and paste the sample formula from the Cash Forecast Template
38
Highlight both boxes and drag all the way down to the last invoice
39
Click on the green box at the bottom where your total is, select auto sum, hit enter.
40
Hit the save button to save your work on your Cash Forecast Ap Due Tab
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