Cash Needs Analysis Dashboard

This dashboard is based on data from a scheduled extract that occurs daily.

Purpose

The Cash Needs dashboard reflects unpaid AP Bills for the entire company.

Details

The Bills Due this Month information reflects the current calendar month. The Discounts Available next 30 Days is based on the first discount paid by date. The AP Bills Due Next Month reflects the next calendar month.

The Cash Needs Analysis is broken down into Past, Current, and Future Due categories. Past Due reflects anything older than today, Current is due today, and Future Due reflects all AP Bills with a Due Date beyond today.

The As of Due Date filter is based on the AP Bill Due Date and does not take Discount dates into consideration.

The Location Filter reflects the Vendor location rather than the location the bill was entered.

The AP Bills by GL Account information reflects the GL account used on the AP Bill.

The Profit Center Breakdown is based on the Profit Center associated with the GL account used on the AP Bill.

The Discount Schedule lists available discounts per AP Bill and can be filtered by bill overall Due Date, Vendor, Location, and AP Bill Invoice Number.

To view the discount schedule per AP Bill, choose the Bill Net Due column and the discount schedule will display on the right.