quickbooks sale
QuickBooks POS 10.0
with custom hardware bundle

as low as $1099
quickbooks on sale
Huge Savings

Visit our webstore
Request our price list

Authorized Intuit Reseller & Partner

Our products are factory direct and guaranteed authentic.

Meet our Intuit team

How to Get Journal Entry Information to Show Up on Job Costing Reports in QuickBooks for Contractors

I'm having problems getting all my expenses to show on my job costing reports.  One item to note is that I set up the initial project by making a journal entry to get the beginning balances in QuickBooks.  If it is necessary to do so, how do I account for the opening balances (my fear is balances will be double counted if I have already made the opening balance JE and then I create a purchase transaction with all the amounts so that they show up as actual in the ‘Estimate to Actual report’)? Lastly, the Estimate report shows all balances I entered as estimates as Revenue, under the title Service.  Is this possible to change?
In order for the job costing reports to display properly, you need to use the Items tab insted of the Expenses tab on your purchase transactions (bills, checks, credit card charges).  This is because most of the job costing reports are based on your items, not your chart of accounts. 

Since journal entries don’t have an item field, you’ll have to trick QuickBooks into doing what you want with a $0 transaction.  Since these are purchase transactions, I’d use a $0 check.  Start by creating a bank account called Clearing Account in Lists > Chart of Accounts so that you don’t clutter up your regular checking account with a bunch of $0 checks.  Then go to Banking > Write Checks, select your clearing account for your bank account, enter in your items on the Items tab with a positive amount and enter the expenses you've already entered with your journal entries on the Expenses tab with a negative amount.  Always put a Customer:job on the Items tab, put it on the Expenses tab only if was also included on your journal entries  Once you’re done, check both your Profit & Loss by Job (which is based on your chart of accounts) as well as one of your job costing reports to make sure everything looks correct.

As for the estimates, the Amount column is your estimate expenses and the Total column is your estimated revenue.  If you have a line that’s only for expenses clear out the Total column.  If you have a line that’s only for revenue clear out the Amount column.  If you have a line for both, put your expense estimate in the Amount column and your revenue estimate in the Total column.  You can use the Markup column to help you determine the revenue (you can use either a $ or % for markup).


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.


QuickBooks price list | Buy QuickBookse | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>