AP Cash Requirements

Before creating the AP Cash Requirements Report, make sure that Unapproved Invoices have been posted. Directions here: Helpdesk : silvertreksystems 

1. Accounts Payable > Reports

2. AP Cash Requirements by Job Report

3. Company 1 - Set the due date to Friday of the following week 

4. Fill out the rest of the report settings as shown below:

5. Click Export

6. Export Type: Excel Format > Click Open in Application

7. Go through the excel and delete lines like the examples below (These repeats represent page breaks as they would appear in a PDF version of the report, which explains their current display)

Example 1:

Example 2:

8. Delete any vendors (and their invoices) that have to do with payroll - these include:

    34 - State of California Employment Development Department

    33 -  EFTPS

    1018 - IRA Account - Pete Buss

    781 - Newport Group Inc. 

    869 - Navia Benefit Solutions

    31 - Northern California Laborers

    23 - Operating Engineers

9. Copy formulas from the template that is attached (this should be cels P,Q,R,S)

10. Paste cells onto current weeks excel spreadsheet

11. Scroll down to where the formula ends and copy and paste the formula until you reach the bottom of the report.

12. Scroll to the top and put an "x" in the first open invoice box to test the formula.

13. Scroll to the bottom of the report and ensure that the formula is working the whole way throughout.

If the formula stops at any point as shown below - follow these steps

13A. Copy the two lines of formula above where the formula stops working. 

13B. Paste in the box shown below

14. Delete the "x" from the first open invoice.

15. Go through Check Run Notes on the AP Trello Board and put "x" next to all invoices that need paid (move Trello cards to done as they are marked off on the Cash Requirements Report)