Cash Forecast AP Due Tab

Finance Silvertrek

Created Feb 01, 2024

Cash Forecast AP Due Tab

53
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

Accounts Payable> Reports

Accounts Payable> Reports
3

Accounts Payable> Reports> +AP Cash Requirements

Accounts Payable> Reports> +AP Cash Requirements
4

Due Date: Select the date range for next week's AP DueInclude 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

Pay Types: See Step 6 for pay types referenceCash Accounts: 1,2,3,4,5PR 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

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

Select Preview

Select Preview
8

Select the export button

Select the export button
9

File Format: Select Dropdown

File Format: Select Dropdown
10

Select Microsoft Excel (97-2003)

Select Microsoft Excel (97-2003)
11

Select Export

Select Export
12

Click Save

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)

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)

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

Customer>Management>Cash Management

Customer>Management>Cash Management
16

Customer>Management>Cash Management> Year

Customer>Management>Cash Management> Year
17

Customer>Management>Cash Management>Year> Month

Customer>Management>Cash Management>Year> Month
18

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

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

Click into File name: Highlight to rename your document

Click into File name: Highlight to rename your document
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

Click Save

Click Save
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

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

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

Select your saved AP Due Report

Select your saved AP Due Report
25

Double click to open

Double click to open
26

Enable Editing in your Excel File

Enable Editing in your Excel File
27

Delete Columns K through O - right click and delete

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

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

Click on any Vendors with the Unapproved Invoices and Highlight them
30

Save your work

Save your work
31

Keep your AP Due Report Tab Open

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

Locate your Cash Forecast Template or Cash Forecast and double click to open
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

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

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

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

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

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

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

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
Well done!
Create how-to guides like this in a snap. Get Tango now.