Practice CS: Billed Amount on the Work-in-Process Summary Does Not Equal the Invoices Amount on the Accounts Receivable Summary

Show expandable text

The Billed amount on the Work-in-Process (WIP) Summary report with the Invoices amount on the Accounts Receivable (A/R) Summary report may not be the same for some clients when the report is printed for the same date range.

The Billed amount on the WIP Summary report may not match the Invoices amount on the A/R Summary report because the Billed amount on the WIP Summary does not include discounts, progress bills or sales tax that are included in the Invoices amount on the A/R Summary.

In the example below, note that for client 11246 the Billed amount on the WIP Summary is $11,210.75 while the Invoices amount on the A/R Summary is $11,450.00 for a difference of $239.25. One of the invoices entered for client 11246 included a discount of $60.75. This amount is not shown on the WIP Summary because it does not affect WIP. The discount amount can be viewed on the Invoice Journal. Notice also, that the invoices for 11246 include a progress bill for $300.00. This is not included in the Billed amount because progress bills do not relieve WIP but it is shown on the WIP Summary report because it is subtracted from the WIP balance. If we add the $239.25 difference between the amounts on the two reports to the $60.75 discount, the total is the $300.00 progress bill which explains the difference between the two amounts.

Was this article helpful?

Thank you for the feedback!