17 Nov Purchases by Item versus Purchases by Vendor Discrepancy
Purchases by Item versus Purchases by Vendor Discrepancy
The purchase reports are another area where it helps to understand what is happening behind the scenes for reports. In this article, we will briefly look at the difference between the Purchases by Vendor Summary report and the Purchases by Item report. Think they are the same, think again.
QBRA-2004: Reports > Purchases > Purchases by Vendor Summary
For illustrative purposes, according to the Purchases by Vendor Summary report, the amount of purchases with the vendors in total for the period of December 1-15, 2007 is $25,558.02. This includes all amounts coded to an item on a bill, bill credit, check, item receipt, credit card charge, or credit card credit.
Now, from the same file, as of the same date range, the Purchase by Item Summary report shows purchases subtotaled by item is $28,327.17. Or a difference of $2,769.15.
QBRA-2004: Reports > Purchases > Purchases by Item Summary
Upon further investigation, the difference is discovered… paychecks that include a service item are on the Item summary report but not on the Vendor summary report.
QBRA-2004: Reports > Purchases > Purchases by Item Summary > Double click on the total > Modify Report > Filter Tab > choose the Transaction Type of paycheck > OK