How do I calculate the vendor history report?
In order to calculate a Vendor History Report, it is important to have an understanding of the firm's payment transactions with a vendor. This report will list all historical information for the selected vendor or vendors in either a detail or summary view.
To calculate the Vendor History Report, the following formula can be used:
Vendor History Report = Detail or Summary View of Payment Transactions with Vendor
Using Sourcetable, the data from a firm's payment transactions with a vendor can be organized into a spreadsheet. This will help to provide a comprehensive view of the vendor's historical information. From there, the data can be filtered and summarized to provide an accurate Vendor History Report.
What information does the report display?
The report shows the account, 1099 type, amount, and comment for each payment. It also includes totals for the filtered data at the bottom of the report.