Cash Forecast AP Due Tab

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

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

  2. 2. Accounts Payable> Reports

    Accounts Payable> Reports

  3. 3. Accounts Payable> Reports> +AP Cash Requirements

    Accounts Payable> Reports> +AP Cash Requirements

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

    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.

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

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

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

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

  7. 7. Select Preview

    Select Preview

  8. 8. Select the export button

    Select the export button

  9. 9. File Format: Select Dropdown

    File Format: Select Dropdown

  10. 10. Select Microsoft Excel (97-2003)

    Select Microsoft Excel (97-2003)

  11. 11. Select Export

    Select Export

  12. 12. Click Save

    Click Save

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

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

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

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

  15. 15. Customer>Management>Cash Management

    Customer>Management>Cash Management

  16. 16. Customer>Management>Cash Management> Year

    Customer>Management>Cash Management> Year

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

    Customer>Management>Cash Management>Year> Month

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

    Customer>Management>Cash Management>Year>Month> Week

  19. 19. Click into File name: Highlight to rename your document

    Click into File name: Highlight to rename your document

  20. 20. Your file will be titled by the Forecast Date & Title of the Report

    Your file will be titled by the Forecast Date & Title of the Report

  21. 21. Click Save

    Click Save

  22. 22. You can close out of Vista and start editing the AP Due Tab

    You can close out of Vista and start editing the AP Due Tab

  23. 23. Go into Customer>Management>Cash Forecast>Year>Month>Week

    Go into Customer>Management>Cash Forecast>Year>Month>Week

  24. 24. Select your saved AP Due Report

    Select your saved AP Due Report

  25. 25. Double click to open

    Double click to open

  26. 26. Enable Editing in your Excel File

    Enable Editing in your Excel File

  27. 27. Delete Columns K through O - right click and delete

    Delete Columns K through O - right click and delete

  28. 28. Go through and remove any duplicate sections or anything from The Fringe Benefit Group - right click and delete

    Go through and remove any duplicate sections or anything from The Fringe Benefit Group - right click and delete

  29. 29. Click on any Vendors with the Unapproved Invoices and Highlight them

    Click on any Vendors with the Unapproved Invoices and Highlight them

  30. 30. Save your work

    Save your work

  31. 31. Keep your AP Due Report Tab Open

    Keep your AP Due Report Tab Open

  32. 32. Locate your Cash Forecast Template or Cash Forecast and double click to open

    We date it YYYYMM Cash Forecast

    Locate your Cash Forecast Template or Cash Forecast and double click to open

  33. 33. Grab the tab of your AP Due Report and Drag into your Cash Forecast Excel

    Grab the tab of your AP Due Report and Drag into your Cash Forecast Excel

  34. 34. Delete the generic AP Due Tab on your template or Cash Forecast and title your new tab AP Due.

    Delete the generic AP Due Tab on your template or Cash Forecast and title your new tab AP Due.

  35. 35. Save your Cash Forecast so it has your new changes and close out of the AP Due Report.

    Save your Cash Forecast so it has your new changes and close out of the AP Due Report.

  36. 36. Final Step Create the Formula for AP Due invoice total

    Column L is usually Orange and Column M is Green

    Final Step Create the Formula for AP Due invoice total

  37. 37. Minimize column K and paste the sample formula from the Cash Forecast Template

    Minimize column K and paste the sample formula from the Cash Forecast Template

  38. 38. Highlight both boxes and drag all the way down to the last invoice

    Highlight both boxes and drag all the way down to the last invoice

  39. 39. Click on the green box at the bottom where your total is, select auto sum, hit enter.

    Click on the green box at the bottom where your total is, select auto sum, hit enter.

  40. 40. Hit the save button to save your work on your Cash Forecast Ap Due Tab

    Hit the save button to save your work on your Cash Forecast Ap Due Tab