Skip to main content

Accounts Payable

The Accounts Payable dashboard tracks outstanding vendor balances, payment activity, and invoice details. It combines charts and a detailed worksheet to show who you owe, how much, and how payments are trending over time. Use this dashboard to monitor liabilities, review payment patterns, and keep track of vendor level costs like freight, tax, and discounts.

The pie and radar charts focus on your top vendors by balance due and amount paid, showing where the largest amounts are concentrated. The spline chart adds a time dimension, showing how invoice balances move month over month. The worksheet provides a full vendor by vendor breakdown including discounts, freight, tax, and remaining balance.

How to use this dashboard​

  • Monitor outstanding balances across vendors to stay on top of what's owed and what's been paid.
  • Identify top vendors by balance due to prioritize payments and manage cash flow.
  • Review payment activity by city to compare invoice amounts and check amounts across locations.
  • Track invoice level details by vendor including discounts taken, freight, tax, and remaining balance.

Visual components​

ViewTypeWhat it shows
Monthly Invoice Balance by Vendor CitySplineShows invoice amounts and balance due by month, with vendor and city context.
Top 5 Balance Due VendorPieShows the five vendors with the highest balance due as a proportion of total.
Top 10 Amounts & Check Amounts by CityStacked BarCompares invoice amount, balance due, and check amount by city for the top 10 cities.
Top 5 Vendors by Amount PaidRadarShows the five vendors with the highest paid amount for relative comparison.
Invoice Amount By VendorWorksheetLists vendor payment and balance details including invoice amount, paid amount, amount discount, freight, tax, and balance due.

Filters​

Use the filtering panel at the top of the dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.

  • Vendor