Vendor - Trial Balance (report)
The Vendor - Trial Balance report shows the beginning balance and net change for the mandatory date range you select in the date filter.
If you use accounting periods, the report shows the fiscal year amounts for beginning balance, net change, and ending balance.
The report is segmented for vendors in each vendor posting group. The grouping makes it easier to reconcile the ending balance against the general ledger payables accounts.
Use cases
Analyze the closing balance of vendors at the end of the period and reconcile the vendor subledger against the payables accounts in the general ledger.
Procurement managers use the report to:
- Analyze vendor balances. The report displays the net changes for vendors for the period specified in the date filter and the net change year-to-date for the corresponding fiscal year. Use this information to analyze vendor balances and ensure that the company isn't overpaying or underpaying vendors.
Vendor managers use the report to:
- Review vendor posting group balances. The report has groups for vendor posting groups, making it easy to review vendor posting group balances. Use this information to ensure that vendors are appropriately categorized and managed.
Accounts payables specialists use the report to:
- Reconcile vendor subledgers. The report is segmented for vendors in each vendor posting group, making it easy to reconcile the ending balance against the general ledger payables accounts. Use this information to ensure accurate and timely financial reporting.
Controllers use the report to:
- Monitor vendor performance. The report provides information on net changes for vendors for the period specified in the date filter. It also shows the net change year-to-date for the corresponding fiscal year. Use this information to monitor vendor performance and identify potential issues that might affect the procurement processes.
Try the report
Try the report here: Vendor - Trial Balance
Tip
If you press CTRL and choose the report link, the report opens in a new browser tab. This allows you to stay on this page while you explore the report in the other browser tab.
See also
Purchase reports
Ad hoc analysis of purchasing data
Purchasing analytics overview