QuickBooks Accountant 2015 – Page 5

How to track Job Time Costs for LLC members/owners that are not Employees? They are not on the payroll so they cannot enter time worked to jobs. But it is important to see how profitable the jobs are.

The idea here is to create a Zero-Journal bill to allocate time and effort to jobs without impacting on P&L report.

QuickBooks Setup (one-time)

In your QuickBooks chart of accounts create the following new accounts:

GO to Lists menu > Chart of Accounts > Account > select New

Zero Journal (under Accounts Payable – this is to differentiate this from operational Accounts Payable). Refer to Image # 1 for setup screen.
Direct Labor – Owner’s Allocation (under COGS). Refer to Image # 2 for setup screen.

Image # 1

Image # 2

Service Item Setup

GO to Lists menu > Item List > Item > New > select Service

Type = Service
Item Name/Number = Labor – Owner’s
Check the box > This service is used in assemblies or is performed by a subcontractor or partner
Description = Leave it blank (if you put anything here, it will show up in job cost reports as lengthy unnecessary title/description)
Sales = Labor (anything you like to see in your invoice as description)
Cost = Hourly Rate (say $40 per hour for this example)
Expense Account = Direct Labor – Owner’s Alloc (under COGS)
Sales Price = Marked Up Hourly Billing Rate (say $80 for hour for this example)
Tax Code = Non-Taxable Labor
Income Account = Job Labor (title for income account)
Refer to Image # 3 for setup screen.

Image # 3

Enter Zero-Journal Bill for Owner’s Time Allocation

GO to Vendors menu and Select “Enter Bills”

Have a Weekly (or Bi-Weekly) Timesheet ready
Select Zero-Journal (NOT regular A/P)
Vendors = Owner’s Name (setup as Other Name)
Reference No. = Ending period of timesheet covered
Select Items tab
- Select Labor = Owner’s from Item List (Service Type)
- Description = Timesheet work period
- Qty = Hours worked
- Cost and Amount should automatically calculate (hourly rate was already setup as $40 per hour in this example)
- Customer: Job = select Customer’s Name from Customer/Job
- Billable = check billable box if it’s actually billable to commercial customer (optional)
- Refer to Image # 4 for entry screen

Image # 4

Select Expenses Tab
- Account = Direct Labor – Owner’s Alloc (COGS account type)
- Amount = Enter negative amount (in this example -600.00)
- Memo = Labor allocation – Owner’s Time
- Refer to Image # 5 for entry screen
- Notice Expenses Tab & Items Tab
  - Should see negative amount (-$600.00 in this example) for Expense Tab
  - Should see positive amount ($600.00 in this example) for Items Tab
  - The net impact is zero journal entry with no impact to Profit & Loss account.
  - Refer to Image # 6 for entry screen

Image # 5

Image # 6

Now, let’s look at the various reports what will they turn out.

Job Profitability Detail Report & Item Actual Cost Detail Report for this Job
- GO to Reports menu > Job, Time & Mileage > select Job Profitability Detail > select Customer
- Refer to Image # 7 for report screen
- Will reflect Owner’s cost of labor allocation for this job
- Double click actual cost dollar amount, it will take you to Item Actual Cost Detail Report. It will give detailed costs all the bill items entered for this job. Refer to Image # 8 for report screen

Image # 7

Image # 8

The big test is to see how it will come out in the Profit and Loss Report. See Image # 9 below. It shows no impact to P&L, and it zeroes out. It worked!

Image # 9

Please note that you should always run this past your CPA or Tax advisor to confirm it meets your needs, as we are not financial experts.

QuickBooks Pro Premier Desktop versions tags.

a/r, a/r aging summary, account, account management, account register, accountant, accounting advice, accounting banking & taxes, accounts payable, accounts payable/receivable, accounts payable/receivable, accounts payable/receivable, accounts receivable, adjustment checks, administrator, advanced inventory, affordable care act, aging, agreement, alignment, amount, android, app, app center, apps, archive, ask the expert event, attachments, au accb&t, au cst&gp, au invtmgt, au my intu, au p&emp, au rsp, au ven&po, australia, authorization, automatic credit card billing, backorder, balance, balance detail report, balance sheet, balance sheet report, bank, bank account, bank feed, bank of america, bank reconciliation, bank transactions, bank transfer, banking, banking & bookkeeping, banking / bookkeeping / multi-currency, banking rules, batch, batch actions, been, beginning balance, billing, bills, blank, blank page, blank screen, blocked, bonus check, bookkeeping, browse:accountant copy, browse:payroll, browse:qbo:money in, browse:reports, browse:sales, browser, budget vs. actuals, builders & contractors, business checking, but quickbooks won’t install on windows server 2011, ca accb&t, ca cst&gp, ca invtmgt, ca myintu, ca p&emp, ca rsp, ca ven&po, california, canada, cannot, capital investment, cash basis, cash register plus, categorized, cfr1w, characters, charge, chart of accounts, chase bank, check, check printing, checking, checks, citibank, class, classes, classifieds, classifieds, client data review, client list, closed, closing date, code, collections, community, community experts, compa, company, company address, company file, company info, company list, company overview, company settings, company snapshot, connect, contractor, contribution limits, convert now, cost of goods sold, cpp, crashes, create, created, creating & customizing forms, credentials, credit card, credit card / check processing / billing solutions, credit card processing, credits, custom, custom field, custom form styles, customer, customer balance summary, customer center, customer list, customer manager, customer manager & client manager desktop, customer type, customers, customers & customer center, customers & getting paid, customers&gettingpaid, customize, cut off, cutoff, data, data loss, data rebuild, database server manager, date, dc, debit card, debits, define accounting, delete, deleted, deposit, deposited, deposits, description, desktop, desktop data, dialog, did, different, direct deposit, disco, discounts, discrepancy, display, displaying, displays, distribution, document, document management system, doubled, downgrade, download, downloaded, downloaded transactions, drop down, dt accb&t, dt accounting banking, dt cst&gp, dt invtmgt, dt my intu, dt p&emp, dt sec, dt t&inst, dt ven&po, due, duplicate, duplicate deposits, duplicates, e-file, e-invoice, e-invoicing, easyacct, easystep interview, echeck, edit, edit employees, editing, efile, ei, einvoice, el capitan, email, emails, employee, employees, employees – hiring/firing/managing/making payroll, emv, ending balance, endofyear, enterprise, epay, equity account, error, error 102, error 106, error 108, error 163, error code, error message, escrow account, español, essentials, estimate, estimates, excel, exception description, expense, expense account, expense transactions, expiration date, export, export payroll, export preferences, exporting, federal, federal withholding, fica, file, filing, filtering, finance charge, financial exchange, financial statement designer, find, finish later, first time use, fixed asset, fixed asset manager, following error has occurred, form, , form customization, formatted, forms, formulas, france, français, freezes, french, from, from account, from quickbooks development team, full service payroll, functionality, functions, fund accounting, funds, ga, garnishment, general discussion, general discussion, general enterprise solutions discussion, general journal, general ledger, georgia, get, getting started, gopayment, gross sales, gross sales amount, grow your business, gst, help with intuit products, highlight, hiring & managing people, home currency, home page, homepage, homestead, hours, hst, http status 500, hud-1, import, import transactions, import/export, importing, importing & exporting data, in accb&t, in cst&gp, in invtmgt, in myintu, in p&emp, in ven&po, income account, increase, information, install, integration, interface, internal error, international, intuit data protect, intuit full service payroll, intuit online payroll, intuit payment network, intuit payroll, intuit products, intuit statement writer, intuit subscription, intuit sync manager, intuit websites, intuit workplace app center, inventory, inventory management, invitations, invite, invoice, invoices, iop, iopfspo, ios, ipad, iphone, irs, is, it, item list, item number, item receipt, items, journal entries, journal entries & accounting tasks, journal entry, ky, lacerte, law, layaway, layout designer, liability, limited, lines, link, list, lists, load, loading, loan manager, log in, log in error, logged out, logging, login, login portal, logo, mac, mac app, making a copy of your company file, manage users, manage-customers, managing business finances, managing your business, manual payroll, marketing/public relations, massachusetts, match, memo, memo field, memorized, memorized transaction, message, message to customer, mfa, mi, michigan, mileage, misaligned, missing, mobile, mobile app, moveonline, mrchsvcs, multi user, multi-page, multi-user & networking, multicurrency, multicurrency, my custom reports, my intuit pr, my intuit products & users, my time, name, navigate, negative, networking, new intuit business tools & resources, new invoice, new sales form customization, new2qb, newforms, newfoundland, no, non-profit, not, not loading, null primary key, on file, online, online banking, online invoice, onlinebanking, open, opening balance, option, option to pay, order, os, os x, other, other industries, other names, overdue, overtime, owner draw, packing slip, page, paid, paper check, partially, password, pay, paybills, paycheck, paychecks, payment, payment failed, payment history, payment method, payments, payments&merchantservices, paypal, payroll, payroll & employees, payroll, payroll, payroll liabilities, payroll setup, payroll tax, payroll tax center, payroll taxes, payroll update, paystub, pdf, physical inventory, plus, pop up, popup, português, pos, preview payroll, previous, price level, prince edward island, print, print preview, printing, printing in quickbooks, proadvisor, proadvisors general discussion, process, processed, product installation & file maintenance, product installation & upgrades, product or service you couldn’t live without, product suggestions, product suggestions, products, profit and loss, proforma, progress invoicing, property, proseries, ptin, purchase, purchase order, purchase orders, qb2011update, qb2012update, qbmac, qbo, qboa, quantity on hand, quick links, quickb, quickbooks, quickbooks alerts, quickbooks and payroll, quickbooks attached documents, quickbooks australia, quickbooks canada, quickbooks data services, quickbooks desktop, quickbooks documents, quickbooks educational resources, quickbooks file / edit & view menu tasks, quickbooks for mac, quickbooks full service payroll, quickbooks installation / update / con, quickbooks installation / update / conversion, quickbooks mac faq, quickbooks mobile, quickbooks networking & user setup, quickbooks online, quickbooks online accountant, quickbooks online alerts, quickbooks online faq, quickbooks online for ipad, quickbooks online payroll, quickbooks online suggestions for improvement, quickbooks payments, quickbooks payments alerts, quickbooks payroll, quickbooks performance issues & program errors, quickbooks proadvisor program, quickbooks self employed, quickbooks self-employed faq, quickbooks service/support policies & procedures, quickbooks simple start edition, quickbooks uk, quickbooks ups / fedex shipping manager, quickbooks windows faq, real estate, recalculate, receipt printer, reconcile, reconcile reports, reconcile tool, reconciled, reconciliation, reconciling, recurring, recurring invoices, recurring transaction, recurring transactions, refund, register, regular hours, regulatory/legal/government, reimbursable expense, #VALUE!, remains, reminders, report, reporting, reports, reports & report center, requesting, reset, reset password, retailers, retained earnings, retainer, reverted, rl-1, routing number, row accb&t, row cst&gp, row invtmgt, row myintu, row p&emp, row ven&po, rules, run, run payroll, runtime error, s, s corporation, safari 10, sales form customization, sales forms, sales order, sales page, sales receipt, sales receipts, sales tax, sales tax, sales tax center, sales transactions page, salesforce for quickbooks, save, save invoice, scheduled, screen, scroll bar, section 179, security, security update, security update email, send, send invoice, send transactions, sending, service, service column, service industries, service item, services, settings, setup, setup problems, sheet, shows, sign in, signup, silicon valley bank, simple start, small business news, smd, sms, sorry, south africa, spain, split transaction, spoof email, sptr apps, sqaure, square, square error message, square integration, stack, starting a business, starting a business, starting and managing your practice, starting my business, state forms, statement charges, statements, status, storefront, subscription, summary, summary report, supplier list, suppliers, supported-browsers, svb, switching, sync manager, sync with paypal, sync with sqaure, system, t, t4, tab, tax, tax center, tax code, tax payment, tax payments, tax rate, tax table, taxable sales amount, taxes, technology, testcomm201409, testing, texas, text message, the, time, time clock, time sheets, timesheet, to, trace, tracking, training and resources, transaction, transaction detail by account, transactions, transfer, transferring, trial, trial balance, troubleshooting, tx, uk, uk accb&t, uk cst&gp, uk invtmgt, uk myintu, uk p&emp, uk rsp, uk ven&po, unable, unchecked, undefined, undeposited funds, undeposited funds account, unexpected, unexpected error, unexpected problem, union bank, unit of measure, united kingdom, unrecoverable error, update, update2newqb, upgrade, user, users, vat, vend, vendor, vendor center, vendors, vendors & paying others, vendors & vendor center, verify, view, viewing, viewmypaycheck, voucher, w-2 alignment, we encountered an error, webconnect, webex, website, wells fargo, when, white, white pages, window envelopes, withholding, work order, workers compensation, working with vendors, working with vendors or suppliers, yahoo, ye 1099, ye 940-941, ye clb, ye rec, your account, zero, zero balance