The Reconcile Cust. and Vend. Accs. report lists all general ledger (G/L) accounts defined for customer posting groups, vendor posting groups, and currencies.
Total net change is calculated for the general ledger and customer and vendor ledgers for a given period. Differences between the two are highlighted.
Customer and vendor ledger amounts are separated by posting group and type to make it easy to find errors and correct them.
Realized and unrealized foreign exchange gains and losses are totaled in the general ledger and compared to the gains and losses posted to the customer and vendor ledgers by currency. Use Date Filter to select the period.
Use cases
Understand the transactions for control G/L accounts, and highlight any discrepancies between G/L and customer/vendor ledgers.
Accounts payable professionals can use the report to:
- Reconcile vendor accounts and ensure that all vendor transactions are correct in the general ledger.
- Identify discrepancies or errors in vendor transactions and investigate.
- Investigate differences in payables, discounts, tolerances, and rounding accounts.
Accounts receivable professionals can use the report to:
- Reconcile customer accounts to ensure that all customer transactions are correct in the general ledger.
- Identify discrepancies or errors in customer transactions and investigate.
- Investigate differences in receivables, discounts, tolerances, and rounding accounts.
Financial accountants can use the report to:
- Verify the accuracy of the financial data by ensuring that the balances on customer and vendor ledgers reconcile to the general ledger balances.
- Identify discrepancies or errors in financial data and investigate.
- Use the data from the report to prepare financial statements, such as income statements, balance sheets, and cash flow statements.
Try the report
Try the report here: Reconcile Cust. and Vend. Accs
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.
Related information
Built-in key finance reports
Accounts payable analytics overview
Ad hoc analysis on finance data
Financial analytics overview