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 QuickBooks 2017 QuickBooks Desktop QuickBooks Pro 2017

Buy QuickBooks Pro 2017

QuickBooks Desktop Premier 2017 – BUY QUICKBOOKS PRO 2017

Overview:

Automated Reports – Custom schedule what reports to receive and when.
Smart search – A personalized autocomplete feature speeds up searches.
Report filters – Apply visible data filters to multiple reports on one screen.

pro2017

Buy QuickBooks Premier 2017

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

 

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


 

Buy QuickBooks Premier 2017
Buy QuickBooks Pro 2017

Categories
QuickBooks QuickBooks 2017 QuickBooks Desktop

QuickBooks Desktop 2017 – New Feature Demo Tour

QuickBooks Desktop 2017 – New Feature Demo Tour

QuickBooks Desktop 2017 New Features

#1 Save Time On Search
#2 Easily Schedule Reports
#3 Easier Amount Search
#4 Find Customer/Vendor Faster
#5 Report Filter Made Easy
#6 Insight Into Deleted Users
#7 Quickly Select Filters
#8 Keep Deposits In Order
#9 Take Credit Card Status

Estimated Retail Release Date: 3rd or 4th week of September 2016.

Here is a list of the past few release dates of QuickBooks. Most of the releases occurred in the third week of September.

Release dates of QuickBooks

QuickBooks VersionRelease Date
QuickBooks 2019September 17, 2018
QuickBooks 2018September 26, 2017
QuickBooks 2017September 27, 2016
QuickBooks 2016September 25, 2015
QuickBooks 2015September 22, 2014
QuickBooks 2014September 23, 2013
QuickBooks 2013September 10, 2012
QuickBooks 2012September 26, 2011

[wpedon id=615]


Categories
QuickBooks QuickBooks Desktop

How to enter credit card charges payments transactions in QuickBooks

This video shows you how to correctly enter your credit card transactions in Quickbooks desktop. Watching this video tutorial, you will learn all need to know about entering credit card expenses, correct enter payments, and also reconcile credit card account.

WATCH VIDEO

QuickBooks Pro Premier Desktop – how to enter credit card charges payments transactions


[wpedon id=615]


Categories
QuickBooks QuickBooks Desktop

How to create Sales Receipt Template to enter Daily Sales Summary

How to create sales receipt template to enter daily sales summary for e-commerce online, retailers, restaurants.

The video tutorials cover Items List, Chart of Accounts, Payment Method, Sales Discounts, Gift Card Certificates, Subtotal, Sales Tax. Memorized Sales Receipt Template and more.


[wpedon id=615]


Categories
QuickBooks QuickBooks 2016 QuickBooks Desktop

QuickBooks 2016 Desktop – Create a new company file express setup

QuickBooks 2016 Desktop – Create a new company file express setup