<< Click to Display Table of Contents >> Navigation:  »No topics above this level« Description and Usage

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

 

 

Detail Trial Balance

 

 

Listed below is an explanation of each column.

 

•Vendor Num (Vendor Number): Pulls from the Vendor Master.

 

•Vendor Name: Pulls from the Vendor Master, Page 1.

 

•Pay (Pay Code): Pulls from the Vendor Master, Page 2.

 

•BK (Vendor Class): Pulls from the Vendor Master, Page 3.

 

•% Dis (Discount Percentage): Pulls from the Vendor Master, Page 2.

 

•Tran Date (Transaction Date): The date that affects General Ledger and pulls from the invoice or check.

 

•Batch (Batch Number): Pulls from Invoice Entry and represents the edit list batch on which the entry was posted.

 

•Seq (Sequence Number): Pulls from Invoice Entry and represents the entry’s position within the batch, or the order in which the entries were keyed.

 

•Invoice-Num: Pulls from Invoice Entry.

 

•Invoice Date: Pulls from Invoice Entry.

 

•Due Date: Pulls from Invoice Entry.

 

•Invoice Amount: Pulls from Invoice Entry.

 

•Disc Pay (Discount Amount): Pulls from Invoice Entry and is the amount of the individual invoice discount.