How to Resolve GL Account Discrepancies in Job Costing reports

Problem

Your job costing shows a significant discrepancy between the billed amount and the revenue caused by GL accounts not being set correctly in the pricebook.

Solution

Income items are pricebook items linked to income GL accounts, which determine completed revenue. If an item isn't mapped to an income GL account, it still counts toward total sales on a sold estimate but not as completed revenue on the job invoice. To keep your revenue reporting accurate, make sure all relevant pricebook items are mapped to income GL accounts in QuickBooks or Intacct.

1. Go to the navigation bar and click Reports.

2. Open the Invoice Item Detail with Pricebook Information report.

3. Choose a date range for the report so that the invoice with the discrepancy appears in the list.

4. Filter the report to see the invoice. If it's an invoice for a completed job, use the Completion Date filter. Otherwise, use the Invoice Date filter.

5. Check the GL accounts associated with the invoice.

6. Ensure that the account is set to an income account rather than an expense account.

7. Adjust the pricebook item so that it has the correct income account.

8. Run the report again to ensure the issue has been resolved.

If you follow these steps, you should be able to resolve the discrepancy in your job costing report. If you have any further questions or concerns, please contact Technical Support for further assistance.