|
Back
QuickBooks Setup for Construction Companies
QuickBooks is designed to be used by businesses and entities
of all types. Accounting needs can vary from user to user, however, depending
on the industry in which the entities operate. For example, companies
that sell services may need to track time spent by employees and bill
clients for that time. Nonprofit organizations may want to track employee
and volunteer time, and contributions by donor. In many cases, customizing
QuickBooks to work efficiently for a particular entity involves no more
than creating a customized chart of accounts. In other cases, certain
preferences must be enabled to make desired QuickBooks features available
to users.
This article provides guidance on company setup for construction contractors.
Construction contractors generally bid for contracts and successfully
manage awarded contracts by having timely and accurate financial information
about all contracts in progress at a given time. QuickBooks Pro or higher
is best suited to those tasks since it has an estimating feature and allows
users to bill customers/owners and pay employees based on accumulated
time and expenses. Additionally, reports can be generated on billable
and unbilled time. (Estimating and time tracking features are available
in the Pro, Premier, Premier-Accountant, and Premier-Contractor versions
of QuickBooks.)
Company Setup
The "EasyStep Interview" will guide users through the process
of creating a company in QuickBooks and offer setup hints for the type
of business selected. In addition, to tailor QuickBooks to specifically
handle a construction contractor, consider enabling the following preferences:
- Classes. Construction contractors frequently wish to view reports
of income and expenses by construction division, type of construction,
project manager, size of contract, or other meaningful grouping. Classes
should be used for only one purpose. To accomplish that, be sure to
enable the QuickBooks preference during the "EasyStep Interview"
by answering "Yes" to the question "Do you want to
use classes?" Classes can also be enabled by selecting "Edit,"
"Preferences" from the menu, then choosing the "Accounting"
icon from the list of icons that appears on the left side of the "Preferences"
window, and checking "Use class tracking" in the "Company
Preferences" tab.
- Inventory. Construction contractors may need to track inventory if
they keep a stock of products like doors, sinks, and cabinets. To turn
on inventory preferences, answer "Yes" during the "EasyStep
Interview" to the question "Does your company maintain inventory?"
Inventory also can be enabled by choosing the "Purchases &
Vendors" icon from the list of icons that appears on the left
side of the "Preferences" window and checking the "Inventory
and purchase orders are active" checkbox in the "Company
Preferences" tab. Other products may be set up as noninventory
parts.
- Sales Tax. Construction contractors may need to collect sales tax
if products are sold. Sales tax preferences are enabled in QuickBooks
during the "EasyStep Interview" by answering "Yes"
to the question "Do you collect sales tax from your customers?"
Users then must choose whether they collect a single tax rate paid to
a single tax agency or whether they collect multiple tax rates or pay
multiple tax agencies. Sales tax preferences can also be enabled by
choosing the "Sales Tax" icon from the list of icons that
appears on the left side of the "Preferences" window. On
the "Company Preferences" tab, answer "Yes"
to the question "Do You Charge Sales Tax?" Even if the sales
tax feature is turned on in the "EasyStep Interview," additional
information should still be entered in the "Preferences"
window (for example, when sales tax is paid, when sales tax is owed,
most common sales tax, and whether to mark taxable amounts with "T"
when printing).
- Tax: 1099. Construction contractors must send Form 1099-MISC to unincorporated
subcontractors for amounts above the IRS threshold. To enable Form 1099
tracking, select "Preferences" from the "Edit"
menu. Then select "Tax: 1099" from the "Preferences"
scroll box and answer "Yes" to the question, "Do you
file 1099-MISC forms?" on the "Company Preferences"
tab.
- Time Tracking (QuickBooks Pro, Premier, Premier-Accountant, and Premier-Contractor).
Construction contractors may need to track time by employee or subcontractor
for specific jobs. To use time tracking, enable the QuickBooks preference
during the "EasyStep Interview" by answering "Yes"
to the question "Would you like to track the time that you or
your employees spend on each job or project?" Time tracking also
can be enabled by choosing the "Time Tracking" icon from
the list of icons that appears on the left side of the "Preferences"
window and, on the "Company Preferences" tab, answering
"Yes" to the question "Do You Track Time?" The
user also should enter the first day of the work week in this screen.
- Jobs and Estimates (QuickBooks Pro, Premier, Premier-Accountant,
and Premier-Contractor). Construction contractors may wish to use estimates
and progress bill their customers/owners. If the contractor will use
estimates and progress billings in QuickBooks Pro, enable the preferences
during the "EasyStep Interview" by answering "Yes"
to the questions "Do you prepare written or verbal estimates for
your customers?" and "Do you ever issue more than one invoice
for one estimate?" Estimates and progress billings also can be
enabled by choosing the "Jobs & Estimates" icon from
the list of icons that appears on the left side of the "Preferences"
window and, on the "Company Preferences" tab, answering
"Yes" to the questions "Do You Create Estimates?"
and "Do You Do Progress Invoicing?" If the contractor bills
from an estimate in stages rather than the full estimate, mark "Yes"
to the question "Do You Do Progress Invoicing?"
- Use Audit Trail. When a user activates this option, QuickBooks keeps
a record of all changes made to transactions, an important internal
control to help detect fraud.
- Require Accounts. This option prevents a transaction from being recorded
without assigning it to an account. If the user does not select this
preference, unassigned transactions will post to the "Uncategorized
Expenses" or "Uncategorized Income" accounts.
- Cash Versus Accrual. Reports and graphs can display on an accrual
or cash basis. The construction contractor should select the appropriate
one.
- Setting a "Closing Date." QuickBooks does not require
users to close their books at the end of a fiscal year. Consequently,
users can continue posting transactions to a fiscal year even after
all adjustments for the year have been recorded and financial statements
have been prepared. If a closing date is set, users cannot post or adjust
transactions occurring before the closing date without providing a password.
Customer Setup
Each of the contractor's customers/owners should be entered in the
"Customer:Job List" so that information about contracts can
be tracked. To set up customers/owners, select "Customer:Job List"
from the "Lists" menu. Select "New" from the "Customer:Job"
menu button and enter the customer/owner data. Notes can be kept on each
customer/owner and are entered on the "Edit Customer" window.
(Click the button on the right side labeled "Notes." If a
note is added for a customer/owner, the "Customer:Job List"
will display an icon indicating notes are available.) Custom fields may
be added in the "Additional Information" tab to track birthday,
spouse, administrative assistant, fiscal year end, or any other meaningful
data. Keep in mind, however, that an individual list is limited to seven
custom fields with a maximum of 15 custom fields for all lists. The same
field (e.g., birthday) that applies to customers/owners, vendors, and
employees counts as one field.
Job Setup
QuickBooks supports up to five levels of jobs or projects for each customer/owner
on the "Customer:Job List." Jobs may be added to customers/owners
by displaying the "Customer:Job List," selecting the customer/owner,
and choosing "Add Job" from the "Customer:Job"
menu item. Each contract should be set up as a job rather than as another
customer/owner to prevent inputting customer/owner information twice.
Regardless, each contract should be set up as a separate job. For example,
if a contractor has one contract to remodel a kitchen and make bathroom
repairs, the contract could be set up as a job with subjobs for the remodel
and repair. If two separate contracts exist for the remodel and the repair,
each project should be set up as a separate job. (Users can drag jobs
and subjobs between sublevels and customers/owners if they are incorrectly
set up.) Custom fields may be used by job to track contract number, contract
amount, or any other meaningful data. Furthermore, notes may be kept on
each job and are entered from the "Edit Job" window. (Click
the button on the right side labeled "Notes." If a note has
been added, the "Customer:Job List" will display an icon indicating
notes are available.)
Setting up Customers/Owners by Type
Construction contractors may find it useful to track and report customers/owners
by type. Some useful customer types for a contractor might be type of
customer/owner (e.g., commercial, industrial, or residential) or customer
referrals (e.g., customer name, yellow pages, or other referral). Customer
types should be used for only one purpose and may have up to five levels
of subtypes. Subtypes further define customers/owners. For example, a
residential customer/owner could be further divided by single home and
apartment building. Reports, labels, and summary statements may print
by customer type.
To group customers/owners by type, first create the customer type by selecting
"Lists/Customer & Vendor Profile Lists/Customer Type List"
from the menu bar, clicking the "Customer Type" menu button
on the screen that appears, and selecting "New." Once customer
types have been created, assign customers/owners to the types by double-clicking
each customer/owner name on the "Customer:Job List," selecting
the "Additional Info" tab, and choosing the appropriate type
from the drop-down list under "Type."
Note: Customer types can be added "on the fly" as customer/owner
information is entered. Simply choose "" from
the drop-down list of customer types on the "Additional Info"
tab.
Grouping Projects by Type (QuickBooks Pro, Premier, Premier-Accountant,
and Premier-Contractor)
Construction contractors may find it useful to view reports by job type.
For example, construction contractors may want to view P&L for remodeling,
repairs, or other types of projects. Up to five levels of subtypes may
be used to further detail job types. For example, kitchen and bathroom
could further define remodeling projects, or if decks were a job type,
wood and stone could further define decks as subtypes. A contractor may
use job types to track types of contracts (e.g., fixed price, cost-plus,
or time and materials).
To group projects by type, first create the job types by selecting "Lists/Customer
& Vendor Profile Lists/Job Type List" from the menu bar, clicking
the "Job Type" menu button on the screen that appears, and
selecting "New." Once job types have been created, assign
projects to the types by double-clicking each project on the "Customer:Job
List," selecting the "Job Info" tab, and choosing the
appropriate type from the drop-down list under "Job Type."
Note: Job types can be added "on the fly" as project information
is being entered. Simply choose "" from the
drop-down list of job types on the "Job Info" tab.
Tracking Owners by Project Manager
Construction contractors may find it useful to track customers/owners
by a project manager. (Users should note that the customer representative
field cannot track individual jobs.) To do that as an alternative to using
classes:
- Set up Each Project Manager for Which Customers/Owners Will Be Tracked
as a Customer Representative. Customer representatives are entered by
selecting "Lists/Customer & Vendor Profile Lists/Sales Rep
List" from the menu bar, clicking the "Sales Rep"
button on the screen that appears, and selecting "New."
Note that new customer representatives may be selected from the employee,
vendor, or other names lists.
- Assign a Representative to Each Customer/Owner. Customer representatives
are assigned to customers/owners by selecting each customer/owner on
the "Customer:Job List," selecting the "Additional
Info" tab, and choosing the appropriate representative from the
drop-down list under "Rep."
Note: Project managers can be added "on the fly" as customer/owner
information is entered. Simply choose "" from
the drop-down list under "Rep" on the "Additional Info"
tab.
|