job cost detail report

gallupadmin · ‎February 19, 2019

I am using Quickbooks Premier Contractor Edition 2019. We print Job Cost Detail reports, weekly. One of our vendors requires payment by check. We receive approximately 70-100 invoices a month from this particular company & at the end of the month we get a statement. We use this statement to confirm all entered invoices and make a payment via the statement. They used to accept cc payments. That was easy, every invoice that came in would be entered under CC charge and show up immediately on the Job Cost report and at the end of the month when we receive the statement, we would compare all entered invoices with the statement and pay. Now they want us to pay by check. I can't write 70-100 checks a month to one company. I can't enter them as CC charges (this method is the only way they will show up on my job cost report). I tried entering them as a BILL and they are not showing up on my JOB COST report. Long story short, how can I enter each invoice, without writing a check each time, so the invoices reflect on the reports I use daily and still make ONE single, lump sum payment at the end of the month?

HoneyLynn_G · ‎February 19, 2019

Hello there, @gallupadmin.

Thank you for visiting us today and providing details. I can help you reflect the invoices on the Job Cost Detail report.

Click Edit.
Choose Preferences.
Select Time & Expenses.
Choose the Company Preferences tab.
For invoicing options, make sure to put a check mark on Track reimbursed expense as income.

That should allow you to enter the invoice and its payment and reflect the transaction on the Job Cost report, gallupadmin.

Let me know if there's anything else you need. You can leave a comment or mention my name. I'd be right back to help you more!

View solution in original post

HoneyLynn_G · ‎February 19, 2019

Hello there, @gallupadmin.

Thank you for visiting us today and providing details. I can help you reflect the invoices on the Job Cost Detail report.

Click Edit.
Choose Preferences.
Select Time & Expenses.
Choose the Company Preferences tab.
For invoicing options, make sure to put a check mark on Track reimbursed expense as income.

That should allow you to enter the invoice and its payment and reflect the transaction on the Job Cost report, gallupadmin.

Let me know if there's anything else you need. You can leave a comment or mention my name. I'd be right back to help you more!

topknotchbookkeeping · ‎May 06, 2019

I have the exact same issue. We just pay our invoices by check, and sometimes multiple invoices are paid on one check, but it will not show up on the weekly Job Cost Detail I run for my bosses. They like to see the previous weeks costs, including Labor (paychecks), credit cards and invoices paid (via check). But when I go to customize report-> filters and then select "transaction type" and select the above ones I just mentioned, bill payments still wont show up. How can I get these invoices that were paid to reflect on this report?

If it is your above explanation, can you explain how selecting the reimbursable button in preferences this will make the bill payments show up? I clicked that button and am still getting the same results. Nothing is reimbursable here, so I'm not sure I'm understanding how this solves the problem. Is there anything else that needs to be done when the invoices are entered and the bills are being paid to make it show up on the report?

Angelyn_T · ‎May 06, 2019

Hi there, @topknotchbookkeeping.

I'm here to help check why your invoices are not showing on your weekly job cost detail report.

Transactions showing up on the report depends on the item type used when creating invoices. Service and non-inventory items won't show costs when running reports. It's possible that some of the items on your invoices are service and non-inventory items. For now, you have to open those invoices that aren't reflecting on the report and check the items and the item types associated with it.

If the items used are inventory items and it's still not showing on the report, then you need to run your report using the Cash basis of accounting method.

To learn more about running and customizing reports in QuickBooks Desktop (QBDT), you may check this article: Understand reports.

Please feel free to add a comment below if you have any other questions about invoices and reports, I'll be right here to help you. Have a good day!

Topics

Training

Community

Resources

job cost detail report