QuickBooks Premier Software. Buy now!
Categories
QuickBooks QuickBooks 2016 QuickBooks 2017 QuickBooks Canada QuickBooks Desktop QuickBooks Enterprise QuickBooks Premier

How to print the build assembly report in QuickBooks QBD

Here’s how you can find an assembly build transaction and then print (see sample screenshot below).

From the Home Page:

  1. Go to Edit, then select Find.
  2. Click the Advanced tab.
  3. In the Choose Filter section, select Transaction Type in the Filter list.
  4. Click the Transaction Type drop-down arrow and click Build Assembly.
  5. Click Find.
  6. Click Report.
  7. Click Print.

 

[wpedon id=”615″ align=”center”]


 

print-build-assembly1

print-build-assembly2

Categories
QuickBooks QuickBooks 2016 QuickBooks 2017 QuickBooks Accountant 2015 QuickBooks Canada QuickBooks Desktop QuickBooks Enterprise 2015 QuickBooks Mac 2015 QuickBooks Premier 2015 QuickBooks Pro 2015 QuickBooks Pro 2017

How to track Job Time Costs for Owners and LLC members that are not Employees

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 # 1Zero Journal A/P

Image # 2Direct Labor - Onwer's Allocation

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 # 3Service Item

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 # 4zero journal enter item tab

  • 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 # 5zero journal enter expense tab

Image # 6zero journal entry

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 # 77 job profitability report

Image # 8item actual detail cost

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 # 9profit and loss

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.

 

 

 

Categories
QuickBooks Canada QuickBooks Desktop

QuickBooks Canada Desktop Security Information

All users who have the “Credit Card Protection” feature on, or whose QuickBooks Desktop file contains sensitive data such as credit card data or PII will be asked to set up a password to verify that the person attempting to access the account is authorized to view such data.

QuickBooks Desktop detects the presence of the following data to ensure strong controls:

  • Employee and Employer Social Insurance Number
  • Employer Bank Details (Routing Number, Account Number)
  • CRA Business Number

Find out more about our security update here.


 

[wpedon id=”615″ align=”left”]


 

Learn How To Use QuickBooks For FREE. Our 10 Quickbooks Tutorials.

10 Quickbooks Tutorials
QuickBooks Pro Premier Tutorial Part 1: How to Create Your Company File
QuickBooks Pro Premier Tutorial Part 2: Chart of Accounts COA
QuickBooks Pro Premier Tutorial Part 3: Item List
QuickBooks Pro Premier Tutorial Part 4: Invoice and Accounts Receivable
QuickBooks Pro Premier Tutorial Part 5: Create Invoices / Receive Payments / Record Deposits
QuickBooks Pro Premier Tutorial Part 6: Create Sales Receipts Uneposited Funds Record Deposits
QuickBooks Pro Premier Tutorial Part 7: Write Checks Bank Debit Card ATM Fee Wire
QuickBooks Pro Premier Tutorial Part 8: Enter Vendor Bills | Accounts Payable | A/P Aging Report | Pay Vendor Bills
QuickBooks Pro Premier Tutorial Part 9: Manage Sales Tax | Setup Preferences | Code List | Liability | Use Tax | Pay Sales Tax
QuickBooks Desktop Part 10: Inventory - All you need to know about QuickBooks Inventory
QuickBooks Pro Premier: How to pay a vendor bill using bank loan (line of credit) account

Categories
QBO vs QBDT QuickBooks QuickBooks 2015 QuickBooks 2016 QuickBooks 2017 QuickBooks Accountant QuickBooks Accountant 2015 QuickBooks Accountant 2016 QuickBooks Accountant 2017 QuickBooks Canada QuickBooks Desktop QuickBooks Enterprise QuickBooks Enterprise 2015 QuickBooks Mac 2015 QuickBooks Online QuickBooks Payroll QuickBooks Premier QuickBooks Premier 2015 QuickBooks Premier 2016 QuickBooks Pro QuickBooks Pro 2015 QuickBooks Pro 2016 QuickBooks Pro 2017

QuickBooks Desktop Home Page Screen

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