Skip to main content

Invoice Information

The Invoice Information data model provides a detailed view of invoice level financial data. It includes measures like amount paid, amount invoice, balance due, check amount, discount amount, retention amount, taxable and non taxable amounts, freight, tax, average days to pay, and average days overdue. Use it to review invoice details by vendor and location, track payment behavior, and monitor outstanding balances.

How to use this data model​

  • Review invoice details by vendor to see how much was invoiced, paid, and what balance remains.
  • Track payment timing using average days to pay and days overdue to understand how quickly vendors are being paid.
  • Compare invoice and check amounts by city to spot discrepancies or patterns across locations.
  • Monitor balance due distribution across vendors and cities to see where the largest outstanding amounts are.

Available views​

ViewTypeWhat it shows
Invoice AMT By VendorWorksheetBreaks down total invoice amounts by vendor with payment and balance details.