Cash Forecast AP & PR Due Tab

Creation Date: January 31, 2024

Created By: Finance Silvertrek

View most recent version 

1. Verify you're in the correct company and then go into the Accounts Payable Module

2. Accounts Payable> Reports

3. Accounts Payable> Reports> +AP Cash Requirements

4. Due Date: Select the date range for next week's AP Due Include Unapproved Transactions?: Check the box with your mouse or press the space bar.

Your due date will be how far out you want to review invoices to pay.

5. Pay Types: See Step 6 for pay types reference Cash Accounts: 1,2,3,4,5
PR Due if ever needed: 6

6. By pressing F4 in Pay Types: You can review Pay Types 1-5 for all cash accounts

7. Select Preview

8. Select the export button

9. File Format: Select Dropdown

10. Select Microsoft Excel (97-2003)

11. Select Export

12. Click Save

13. Go into Dropbox and select the customer (if you're already in your Dropbox, just make sure you are in your admin folder)

14. Customer>Management (sometimes the location varies, yours may be different)

15. Customer>Management>Cash Management

16. Customer>Management>Cash Management> Year

17. Customer>Management>Cash Management>Year> Month

18. Customer>Management>Cash Management>Year>Month> Week

19. 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