<< Click to Display Table of Contents >> Navigation:  Report Dashboard > Detail Trial Balance - Report Writer > Description and Usage

The Detail Trial Balance report provides a complete listing of all vendors by name and number and their respective detail. The report will show every transaction posted to vendors' accounts along with the beginning and ending balance for each vendor. It will show one line for each invoice and one line for each check. The last page will include a grand total for all vendor balances. The grand total should equal the Accounts Payable total for vendors in the General Ledger at month's end. The running of this report is considered mandatory because detail will eventually purge from vendors’ accounts. However, this report will provide both an audit trail and a hard copy of the detail.

 

 

AP Detail Trial Balance - Report Writer

 

 

 

Listed below is an explanation of each column:

 

Vendor Information

 

•Vendor Number: Pulls the vendor number from the Vendor Master.

 

•Vendor Name: Pulls the vendor name from Page 1 of the Vendor Master.

 

•Pay Code: Pulls the pay code from Page 2 of the Vendor Master.

 

•Bank (Vendor Class): Pulls the vendor class code from Page 3 of the Vendor Master.

 

•Discount Percentage: Pulls the discount percentage from Page 2 of the Vendor Master.

 

•Beginning Balance/Discount: Pulls the beginning balance of the vendor followed by the total dollar amount of any discounts entered for the vendor for the selected date range.

 

•Ending Balance/Discount: Pulls the ending balance of the vendor followed by the total dollar amount of any discounts entered for the vendor for the selected date range.

 

 

Vendor Detail

 

•Transaction Date: This is the date from the invoice or check that affects General Ledger.

 

•Batch-Sequence: The batch and sequence numbers pull from Invoice Entry. The Batch Number represents the edit list batch on which the entry was posted. The Sequence Number is the entry’s position within the batch, or the order in which the entries were keyed.

 

•Invoice Number: Pulls the invoice number entered from Invoice Entry. For any checks cut for a vendor, this column will also display the bank code, check number, and check reconciliation status.

 

•Invoice Date: Pulls the Invoice Date from Invoice Entry.

 

•Due Date: Pulls the Due Date of the invoice from Invoice Entry.

 

•Amount: Pulls the amount of the invoice or check.

 

•Discount: Pulls the individual invoice discount from Invoice Entry.

 

•Pay: Pulls the Pay Code loaded on the invoice from Invoice Entry.

 

NOTE: Multi-pay invoices will pull a separate line for each invoice along with the Due Date, Paid Amount, Paid Date, etc.