Vendor Trial Balance Report overview

Vendor > Reports > AP Reports > APRT

Function acronym: APRT

Use this report to determine the vendor balances for each vendor as of the current date or any date you enter.

This balance is compared to the General Ledger AP Control account balance for each vendor, and is also printed.

Note:  All open journals must be closed before running this report. If a journal is open, the journal number, operator, function name, date and time will print at the top of the report. You should find the journal, close it, and then rerun the report.

The return merchandise, discounts taken, discounts lost, invoice, and payment transactions will also print for each vendor. These are updated directly from Accounts Payable.

Note:  Use caution when you enter range parameters. Limiting information that should be included on the report may cause the AP balance to differ from the GL balance. This message is displayed at the end of the report if the ranges you chose affected the AP balance: Warning: Range Option(s) Were Selected. Printed AP Balances Will Not Equal Printed GL Balances.

Foreign Currency

If a vendor deals in foreign currency, the amount is converted to the domestic equivalent for the balance display. Additional fields on the report display the currency and foreign balance. A warning note appears on the report to alert you to the foreign currency.

Sections

The Vendor Trial Balance Report prints in three sections. The first section prints all vendor/General Ledger account combinations in vendor name or vendor number order. If a vendor is associated with more than one General Ledger account, the report will include a vendor total after that vendor's record. This section is usually used to isolate problems. It is not appropriate for balancing information, as more than one vendor often updates the same General Ledger account. No totals are provided.

The second section of the report is the main balancing section. It displays each GL account code, the vendor records that feed into that account, and the total balances from both General Ledger and Accounts Payable, in GL account order. Every account that is not in balance will include an "Off By" message. Totals for AP balance, GL balance and "Off By" are provided.

The last section is used only when you specify (T)otals for the Detail option. Totals displays each GL account accessed along with the GL balance, AP balance and the Off By amount. This information is carried down to provide a grand total figure.