• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Industries   Builders & Contractors  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
96
cc7RlMuPir4yUOacwZ5xHE
Subscribe RSS
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
Contributor
02/08/12 12:21pm PST
Viewed by asker 02/13/12 4:33pm PST

Owners, Subs, time tracking, items & billing rates

US QuickBooks Premier : 2012: Contractor

I have a architectural design client.  She needs to track all of the drafting time for each job for billing and job costing, time tracking purposes. 

She (as an owner) bills out her time at rate $A

She bills her draftsmen(independent contractors) at rate $B.  (The 2 current draftsmen are paid different hourly rates but billed out at the same rate.)

I can set up a different billing rate for each draftsman in the vendor center and use the same "Drafting" item with a sales price of rate $B. 

Do I need a separate Drafting item for my owner since she bills out at a different rate?  And do I check the box "This service is used in assemblies..." for her?

Or should I set up 2 subitems under "drafting", one for the independent contractors and one for the owner with the appropriate sales rate of each and then could pull total drafting times by job name?   

I want this as simple as possible and have gotten a little befuddled as I've been chewing on this for so long.

Solved!
Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
8 Replies
Lance Wilkins
Lance Wilkins
Questions asked: 3
Questions answered: 690
Points earned: 1487
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
Lance Wilkins
Lance Wilkins
Questions asked: 3
Questions answered: 690
Points earned: 1487
Allstar
02/09/12 7:50am PST

The Billing Rate feature is designed to allow you to charge different rates for employees or vendors for the same item.  You could use the same item but, with a different billing rate, as long as the owner is in QuickBooks as a vendor or employee.  Just enter her time on the weekly timesheet as well as the draftsmen.  Mark it billable.  Create a billing rate for Owner - Drafting at $XX in addition to the one you have for Drafting - Subs at $XX. 

And, you shouldn't need different billing rates for the two draftsmen if they are being billed out with the same rate.  The billing rate is for the rate being charged on invoices, it won't affect the cost of individual vendors.

Hope that helps.

 

Lance Wilkins
http://www.qbassist.com

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
Contributor
02/12/12 3:11pm PST

Thank you for responding.

This is where I'm getting confused:  Is billing rate for Accounts Payable or Accounts Receivable? 

I thought I could use the billing rate to pay the draftmen from time entered from their invoices to us (A/P) then use the item "sales price"  to invoice our client (A/R). 

Have I gotten things mixed up?  

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/12/12 3:23pm PST

"You could use the same item but, with a different billing rate, as long as the owner is in QuickBooks as a vendor or employee. "

That is not necessary and leads to errors. If the owner is not really an employee, then the Timesheet and Owner utiliize the Other Names list.

I would suggest not using the Billing Rate Level for your client file. Billing Rate Levels adjust Base Price of items per the name on the timesheet. Price Levels adjust Base Price of items per customer name.

You should set up the drafting item, or Items, to meet what you need to see on reports and use in estimates. You want at least two.

Since the owner bills out at a different rate, if the owner is not on payroll ( a Sole Proprietorship), you won't get good job costing unless you pay the owner using Items, such as, items that are tracked as Draw instead of Expense.

Create a Service item for Owner time, "this is used in" should be checkmarked to provide an Expense side and an Income side for accounting data flow. Set the Expense side to owner draw. Pay the owner using Job Tracking and the Items tab.

For the subs, using a timesheet allows you to pay from the timesheet, but the two-sided item "Cost" data is what is used for AP; not Billing Rate Level. This can be overridden, if they don't Cost the same rate, of course. QB tells you to "leave cost as $0 if cost varies" in fact.

For using this method, the timesheet data is marked Not Billable. When you pay the subs, such as Write Check, QB asks if you want to pay from the timesheet. This is the transaction where the Items are marked Billable.

Now you have Billable entries for invoices and the Cost data.

Costs do not come from timesheets. They come from purchases and payments.

I used QB for an architectural firm for ten years. It works well but takes some set up.

 

 

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
Contributor
02/12/12 4:10pm PST

Ok, that makes it clear for the subs and that is helpful.  Then it is unnecessary to use the billing rate and price levels in these situations.   

I understand using a separate item for the owner so I can use the owner's draw as the expense account but the owner has never gotten paid off of her time card, they take draws as needed.  But if she doesn't get paid off of the time card, we're not tracking 'job costs' properly, right?  And if Idon't pay her then I can't invoice her time out unless I mark them billable on her time card and figure her time out separately to add to the job costs of the project? 

And, we must make certain we pay the subs prior to invoicing clients or their time won't show up billable, right?

 

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/12/12 4:15pm PST
The solution

Let's break these apart:

"But if she doesn't get paid off of the time card, we're not tracking 'job costs' properly, right?" 

There is no cost for the owner, in reality. This method would allow you to "job allocate" draws.

"And if Idon't pay her then I can't invoice her time out unless I mark them billable on her time card and figure her time out separately to add to the job costs of the project? "

The timesheet provides the data to invoice; the tasks are marked Billable in this case. You see this when using Add Time & Costs; the Time tab.

"And, we must make certain we pay the subs prior to invoicing clients or their time won't show up billable, right?"

No. You can create Bill for the vendor name, to be paid later. It isn't the payment but the creation of a Cost (purchase) transaction that is the key, here.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
10
 Report Abuse
 
 
 
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
Contributor
02/12/12 4:43pm PST

Thank you for taking the time to clarify all the ins and outs of this for me.  This certainly answered my original question and fortunately, I hadn't set anything up yet so I don't have to 'un-do' anything. I will set it up as you suggested

But it raises an entirely separate question about job allocating owner's draws.  I'm not able to visualize how to do this.  

If I enter the owner's time and they're going to take a draw, I mark it unbillable, write a check to the owner off her time...but what if she's getting more? 

and Should I be encouraging the owners to keep time cards to allocate their time to jobs? 

Sorry for all the questions but you're a wealth of information and I've been struggling on my own for awhile. 

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
02/12/12 5:09pm PST

No problem.

"If I enter the owner's time"

meaning, we are tracking Tasks...

"and they're going to take a draw,"

meaning, they take funds...

"I mark it unbillable,"

Well, the timesheet is marked billable, unless you intend to use a payment (purchase) transaction of some sort and bill from it. You don't need to have Billable entries to have job cost data. You need to have Billable entries for something that is to be charged back. You need to Job Track any data that you expect to see on job reports. These serve different purposes...

"write a check to the owner off her time...but what if she's getting more? "

You use the Items tab and job track the amounts that apply to jobs, such as, "I want to job cost myself at $20 per hour." On the Expenses tab, add the rest as Owner Draw. Check = total of Items tab and Expenses tab. This is Splits and job allocation.

"and Should I be encouraging the owners to keep time cards to allocate their time to jobs?"

Always. Even if you don't bring $ into the job costing picture, the ability to avoid tracking your time means, you have no idea if you really are wasting your time or underbidding a project. Or both. This is a business management tool and not a bookkeeping or financial tool.

QB is far more than accounting.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
jabbott
jabbott
Questions asked: 10
Questions answered: 19
Points earned: 19
Contributor
02/12/12 5:28pm PST
Latest post

I've printed out your response and will work through it in my sample company to make sure I understand it inside out. I need to get these clients up and going and you've certainly helped me NOT make mistakes that could've been awkward down the line.

I like the idea of times cards particularly when they want to see if the design or construction part of their business is more profitable.  Let's see if I can get them to do it!

Thank you again. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • 2012: contractor
  • us quickbooks premier
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
EdNY
5 mins ago
EdNY
replied to
Intermediate Assets
BJLL
8 mins ago
BJLL
posted
How to zero out unpaid vend...
JERRYERIC
14 mins ago
JERRYERIC
posted
how many registered users a...
BRConsulting
15 mins ago
BRConsulting
replied to
Importing IIF into Quickboo...
BRConsulting
16 mins ago
BRConsulting
replied to
Importing Invoice data from...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business