Navigation:  ACCOUNTS PAYABLE > Accounts Payable Reports >

5. Cash Requirements Report

Previous pageReturn to chapter overviewNext page

 

The Cash Requirements Report is the most useful Accounts Payable report since it’s the most flexible report, and details exactly your accounts payable liabilities.

 

To ensure accuracy and consistency of this report, you are advised to consistently enter all payables as soon as they are received. In addition you should process all payments using Make a Payment to One Vendor or Make Payments to Several Vendors, discussed in the next two sections.

 

 

▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄

█                Golden Opportunity ♦ Cash Requirement Report                  █

█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█

█  1) For Vendors:                      ___            ___                     █

█  2) Excluding Vendors:                                                       █

█  (none specified)                                                            █

█  3) For Dates Due Before:             12/31/99                               █

█  4) For Discount Dates Before:        12/31/99                               █

█  5) For Invoices Received Between:    12/31/99       12/31/99                █

█  6) For Unpaid Invoices, Paid or Both                Unpaid                  █

█  7) Include Memo Invoices                            Yes                     █

█  8) Include Non-Inventory Invoices                   Both                    █

█  9) Display Report                                                           █

█  A) Print Report                                                             █

█  0) Return to Main Menu                                                      █

▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ <Esc>=Quit ▀▀▀

 

 

 

The first two options allow you to select or exclude vendors. Only invoices for selected vendors will be included on the report.

 

Options 3 through 8 allow you to select which invoices that will appear on the report.

 

Option 9 or A will start the report.

 

To select invoices with options 3 through 5, use the <↑> and <↓> keys to highlight the option, press <Enter>, and type the information required by the selection.

 

To change the selection on options 6 - 8, highlight the option and press <Enter> until the desired selection appears.

 

You can select more than one option to print a very specific set of invoices on the report. For example, you can select a range of vendors with option 1, then invoices due before a certain date with option 3. The report will show invoices from the selected vendors and due before the date entered. Make your selections, then choose Display or Print to begin the report.

 

Don’t choose any of the selections unless you specifically want to restrict the report to those items. For example, if you want to see invoices for all vendors, you don’t even have to choose the For Vendors option.

 

For Vendors*} Use this option to restrict the selection to invoices from one vendor only, or a series of vendors. To choose invoices from just one vendor, enter the vendor code as both the starting and ending vendor code. If nothing is entered, ALL vendors will be reported.

 

Excluding Vendors*} You can enter a list of vendors here that you do not want to be included in the report. If you have already entered a list, you can clear all previous entries and start over by typing XXX.

For Dates Due Before *} Only show invoices due on or before the date entered here. This can let you choose only those payables that will be due soon.

 

For Discount Dates Before*} Only show invoices with discount dates on or before the date entered here. This can let you choose only those payables whose discounts will expire soon.

 

For Invoices Received Between*} Only show invoices received on or between the dates entered.

 

For Unpaid Invoices, Paid or Both*} To only show invoices with balances (either positive or negative), choose Unpaid. To show only fully paid invoices, choose Paid. To print both paid and unpaid invoices, choose Both.

 

Include Memo Invoices*} If you have entered any memo invoices (those with invoices numbers starting with the letters MEM) you may want to exclude them from the report since they may not be payable. Choose No to exclude them, or Yes to show them along with the rest of the invoices payable.

 

Include Non-Inventory Invoices*} Non-Inventory Invoices are those from vendors who do not supply you with merchandise. Vendors who supply you with merchandise should have an Expense Code between 500 and 599 in the vendor screen. If you choose Only then only those invoices from vendors with expense codes between 500 and 599 will report. If you choose No then only invoices from vendors with expense codes other than in the range 500–599 will report — these will generally be invoices for operating expenses. If you choose Both then invoices will show up regardless of the expense code in the vendor screen.

 

When you have made the necessary selections, use option 9 to display the report on-screen, or option A to print it on paper.

 

When the report has finished, the report menu will reappear. Return to step 1 to print another cash requirements report, or press <0> to return to the previous menu.