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

The Summary Trial Balance Report provides a complete listing of all vendors by name or number and their respective totals. The report will show the beginning balance, number of invoices posted to the account, number of checks paid against the account, total discounts taken, the ending balance, discounts available on unpaid invoices and the ending balance less the discounts available for each vendor for the month end. This report is especially useful to management to determine the activity level with the various vendors.

 

The Report Writer application allows the user to filter, sort and manipulate this report so that they may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.

 

 

Summary Trial Balance - Report Writer

 

 

 

Listed below is an explanation of each column.

 

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

 

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

 

•Bank: Pulls the vendor's bank code from the Vendor Master, Page 3.

 

•% Dis: Pulls the vendor's discount percentage from the Vendor Master, Page 2.

 

•Begin Bal: Pulls the total amount of invoices from the prior month’s ending balance.

 

•# Inv: Pulls the total number of invoices with a transaction date that falls within the time period.

 

•Inv Amt: Pulls the total dollar amount of all invoices with a Transaction Date that falls within the time period.

 

•#Cks: Pulls the total number of checks that have been printed within the time period.

 

•Checks Written: Pulls the total dollar amount of checks that have been printed within the time period.

 

•Disc Taken: Pulls the amount of discounts that were taken within the time period

 

•End Bal: Pulls the ending balance plus the invoice amount minus the checks written less the discounts taken.

 

•Disc. to Take: Pulls the total amount of invoice discounts that have been entered but not paid.

 

•Bal Less Disc.: Pulls the ending balance less the discounts to take.