Vendor - Detail Trial Balance (report)

The Vendor - Detail Trial Balance report shows vendor balances at the end of a period. The report groups the following information by vendor:

  • Opening balance
  • Transactions within a given period
  • Closing balance

If you specify a date range in the date filter, the report displays the following information for each vendor:

  • Beginning balance
  • Each transaction within the period, and its remaining amount and due date
  • Ending balance

You can run the report either in your local currency or in the vendor's currency. You can also exclude vendors that didn't have transactions in the period.

Use cases

Analyze and reconcile vendor balances at the end of a period.

Procurement specialists use the report to:

  • Analyze vendor balances and transactions for a specific period.
  • Identify vendors with outstanding balances and negotiate payment terms with them.
  • Reconcile vendor accounts and ensure that all transactions are accurate.
  • Review the transactions that explain changes in vendor balances.

Accounts payable specialists use the report to:

  • Reconcile vendor accounts and ensure that all invoices are paid in a timely manner.
  • Identify overdue invoices and take appropriate action to resolve the issue.
  • Monitor cash flow and vendor payments.

Controllers use the report to:

  • Monitor cash flow and vendor payments.
  • Identify vendors with high outstanding balances and take steps to reduce the amounts owed.
  • Forecast cash flow and plan for vendor payments.
  • Analyze vendor balances and transactions to identify opportunities to save cost.

Purchasing agents use the report to review outstanding amounts and due dates when discussing payment terms with vendors.

Try the report

Try the report here: Vendor - Detail Trial Balance

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview

Find free e-learning modules for Business Central here