| |
|
QuickLabs.com 14515 North East 67th Court Redmond,
WA 98052 |
|
|
|
| Table of Contents |
April 2004 |
| |
|
QuickBooks
News QuickBooks
Features QuickBooks Common
Questions QuickBooks
Tips QuickBooks Product
Updates Articles
Prior Issues |
| |
| QuickBooks News |
| |
QuickBooks Online Edition
Enhancements QuickBooks: Premier
2004 Wins PC Magazine Editors' Choice Award QuickBooks Merchant Account Service
Improvements |
|
|
QuickBooks
Online Edition Enhancements On March 13,
2004 Intuit, the makers of QuickBooks, enhanced its QuickBooks
Online Edition with the following new features and price and
billing changes:
- Customized Home Page & Overview
- More Ways To Learn
- Estimates
- Plus Package Price & Billing Changes
For a detailed explanation of these new features and price
and billing changes, see QuickBooks Product Updates.
QuickBooks: Premier 2004 Wins PC
Magazine Editors' Choice Award In its March
issue, PC Magazine awarded QuickBooks: Premier 2004 its
Editors’ Choice award.
In her March 16, 2004 article, Editor Kathy Yakal states,
“As the old saying goes, nobody ever got fired for buying IBM.
The same holds true for QuickBooks: It isn't the cheapest
program here, but you can't go wrong buying it for your small
business. Intuit has earned this distinction, providing a
robust, easy-to-use line of applications for a variety of
company sizes and needs.”
To read Kathy Yakal’s article, click here.
QuickBooks
Merchant Account Service
Improvements Intuit is making some
important improvements April 5, 2004 to the Automatic Credit
Card Billing (ACCB) feature of their QuickBooks Merchant
Account Service. ACCB allows merchants to automatically bill
their customer credit cards on a recurring basis.
These ACCB service improvements allow QuickBooks Merchant
Account Service customers using QuickBooks 2002, 2003, or 2004
software to have more of the service features they have asked
for, including:
More billing interval options - in addition to the current
monthly, quarterly, and annual billing options, merchants will
be able to automatically bill semi-monthly, semi-annually, and
bi-weekly. New activity reporting features that allow
merchants to easily generate billing activity reports. New
search capabilities that help merchants search quickly through
their automatically billed transactions. Simplified payment
recording - when an invoice is present in QuickBooks, a
corresponding payment will automatically be received against
it (Auto-apply invoices feature must be enabled in
QuickBooks).
If you are a QuickBooks Merchant Account Service merchant
currently using the ACCB feature, you must take certain steps
to avoid duplicate billing entries.
For additional information about these improvements, click
here. |
| |
| QuickBooks Features |
| |
| New QuickBooks
2004 Features |
|
|
New QuickBooks 2004
Features
E-Mail QuickBooks Forms And Reports And Save As
PDFs E-mail more forms and reports right from
QuickBooks. In addition to invoices, statements, and
estimates, you can now e-mail purchase orders, sales orders,
sales receipts, credit memos, and reports - all right from
QuickBooks. You can save forms and reports as a PDF format, so
they'll look professional when your customers, vendors, or
accountant views or prints them.
Quickly Import Data From Microsoft
Excel Import Microsoft Excel data into QuickBooks,
including customer lists, vendor lists, item lists, and other
important information. Just assign each column in your Excel
spreadsheet to a corresponding QuickBooks "field," such as
inventory item, phone number, or price. You can also save
import settings to use again.
Export Reports To Microsoft Excel More
Efficiently Easily export QuickBooks reports to
any Microsoft Excel worksheet. Just indicate a specific
worksheet, and QuickBooks will export your report to that
sheet, replacing any existing data with your updated report
data.
Customize Prices With Up To 100 Price
Levels Customize prices for different groups of
customers, such as corporate, loyal, or high-volume, with more
price levels (up to 100). Plus, you can attach percentage
discounts or mark-ups in pricing to each customer group, so
you can automatically reduce or raise prices.
Easily Reconcile And "Undo" A
Reconcile Now you can easily reconcile your
accounts, plus you can undo a previous reconcile in one click.
Easily customize the layout of the reconcile screen, and an
improved reconcile discrepancy report shows you changes and
deletions made to previously reconciled transactions.
Manage Your Addresses More
Easily Quickly and easily copy and paste entire
addresses, rather than having to cut, copy, and paste just one
line at a time. Export address lists more easily to Microsoft
Excel, since each line of the address exports to a different
column.
Manage Your Loans Right In QuickBooks With Loan
Manager Keep all your loan information in one
place and manage your loans in QuickBooks. Enter loan payments
right from Loan Manager. No need to figure out principal and
interest - QuickBooks can calculate amortization and the
breakdown of principal and interest for you.
Track Vehicle Mileage And Expenses With The Vehicle
Mileage Tracker Now you can track vehicle mileage
and expenses including date, amount, and type of expense for
tax purposes. You can easily create reports and invoice
customers for billable mileage.
Predict Your Cash Balance With The Cash Flow
Projector Put an end to surprise cash flow
crunches. QuickBooks helps you predict your cash flow for the
next six weeks, using your QuickBooks data and your answers to
simple questions. Easily view your projected "available to
spend" weekly cash balance in a printable report.
Set "Per Item" Price Levels To Match The Right
Price To The Right Customer More flexible price
levels enable you to set the exact prices you want to charge
each customer for each item you sell. Setting price levels per
item helps you save time, reduce errors, and increase profits
by recognizing loyal customers with specialized service.
Manage Your Addresses More
Easily Quickly and easily copy and paste entire
addresses, rather than having to cut, copy, and paste just one
line at a time. Export address lists more easily to Microsoft®
Excel, since each line of the address exports to a different
column.
Easier Time Tracking Get an alert when
creating an invoice if you have any outstanding time or
expenses to help avoid under-billing. Plus, you can easily
bring over both item descriptions and notes to invoices, so
customers can clearly see what you are billing them for.
Calculate, Allocate, And Track Loans In One Place
With Loan Manager Track all your clients' loans in
one place. You'll use fewer spreadsheets with the new Loan
Manager. Create and manage loan amortization schedules. You
can compute "what if" scenarios to help clients make better
financial decisions about which loans and lines of credit are
right for them. Allocate the loan payment between principal
and interest, and track the allocation over the life of the
loan.
Fixed Asset Tracker Helps you keep
track of fixed assets, i.e., equipment and furniture. Track
important details like asset name, serial number, acquisition
date and disposal date.
Manage Fixed Assets From Acquisition To Disposition
With Integrated Fixed Asset Manager (QuickBooks: Premier
Accountant Edition Only) Manage fixed assets with
fewer spreadsheets - right from QuickBooks. With the new
full-featured Fixed Asset Manager, you can easily enter fixed
assets, calculate depreciation, and print reports. Enter asset
purchases, or easily import your Fixed Asset List. You can
compute depreciation for up to six asset bases including
federal, state, book, and AMT. Compute Section 179 expense and
luxury auto calculations. Project depreciation for the life of
the asset. Automatically create journal entries for
depreciation, as well as gains and losses from asset sales.
Print 20 different reports, including asset schedules by
General Ledger Account, location, and category. You can also
print tax worksheets for Forms 4562 and 4797.
|
| |
| QuickBooks Common
Questions |
| |
|
How Do I Add a Fixed Asset
Item? What Do I Need
Before Adding A Loan To The Loan Manager? How Do I Track Mileage For A
Vehicle? How Do I
Charge My Customers For Mileage?
|
|
|
How Do I Add a Fixed Asset
Item? When you purchase fixed assets that
you need for your business, it's important to keep good
records so you can track their cost, the cost of repairs and
upgrades, and how much they depreciate from year to year.
These amounts affect the worth of your business and the size
of your tax bill.
Fixed asset items provide a way to keep important
information about your assets in one convenient place.
You can create an item to track a fixed asset at several
points during the asset's life cycle, but we recommend that
you create the item when you buy the asset.
You can create a fixed asset item from the following
locations:
- From the Fixed Asset Item list
- From a transaction
From the Fixed Asset Item list The
simplest way to create a fixed asset item is while you are
entering the transaction used to purchase it, but sometimes
you may want to create a fixed asset item directly from the
Fixed Asset Item list. For example:
- You intend to purchase or have already purchased several
items that you want to track as fixed assets, such as a
suite of office machines
- You pay for a fixed asset with cash.
- You transfer a personal asset to your business.
- You pay for a business asset with personal funds.
To create a new fixed asset item
- From the Lists menu, choose Fixed Asset Item List.
- Click Item, and then choose New to display the New Item
window. Fixed Asset is preselected as the item type.
- In the Asset Name/Number field enter an identifying name
or number for your fixed asset.
What you enter here appears on fixed asset item reports.
Enter a name or number that will help you distinguish this
item from all others on the list.
- Select an asset account from the Asset Account drop-down
list or create a new one.
- Enter purchase information:
- Purchase Description: Enter a brief description of the
purchase of your fixed asset.
- New/Used: Select whether your asset is new or used.
- Date: Enter the date you purchased your fixed asset,
or select one from the popup calendar. Defaults to today's
date.
- Cost: Enter the cost of your fixed asset.
- What do I say here about total cost vs down-payment?
- Vendor/Payee: Enter the name of the vendor from whom
you purchased the asset.
Note: The Vendor/Payee name is not saved to your Vendor
list when you save this fixed asset item to your Fixed
Asset Item list. You must choose Vendor List from the
Lists menu and add the vendor there if
desired.
- (Optional) Enter asset information:
- Asset Description: Enter a brief description of your
fixed asset.
- Location: Enter a location; for example, if your asset
is real estate, enter an address. If your business has
more than one location, enter where your asset has been
placed into service.
- PO Number: Enter the number of the purchase order you
used to purchase your asset, if applicable.
- Serial Number: Enter the serial number or VIN of your
asset.
- Warranty Expires: If applicable, enter the date the
warranty for your asset expires.
- Notes: Enter any notes concerning your asset that you
want to track.
- Leave the sales information blank, and click OK.
Note: When recording any transactions involving your
fixed asset, be sure to choose the appropriate fixed asset
item from the Items tab or Item column. This enables you to
track depreciation and other costs.
From a transaction You can record
information about your asset as you pay for it from any one of
the following transactions:
To create a fixed asset item from a
transaction
- If available, select the Items tab.
- Select in the Item column and select Fixed
Asset as the item type.
- In the Asset Name/Number field enter an identifying name
or number for your fixed asset.
What you enter here
appears on fixed asset item reports. Enter a name or number
that will help you distinguish this item from all others on
the list.
- Select an asset account from the Asset Account drop-down
list or create a new one.
- Enter purchase information:
- Purchase Description: Enter a brief description of the
purchase of your fixed asset.
- New/Used: Select whether your asset is new or used.
- Date: Enter the date you purchased your fixed asset,
or select one from the popup calendar. Defaults to today's
date.
- Cost: Enter the cost of your fixed asset.
- What do I say here about total cost vs down-payment?
- Vendor/Payee: Enter a brief description of your fixed
asset.
- The Vendor/Payee name is not saved to your Vendor list
when you save this transaction. You must choose Vendor
List from the Lists menu and add the vendor there if
desired.
- (Optional) Enter asset information
- Asset Description: Enter a brief description of your
fixed asset.
- Location: Enter a location; for example, if your asset
is real estate, enter an address. If your business has
more than one location, enter where your asset has been
placed into service.
- PO Number: Enter the number of the purchase order you
used to purchase your asset, if applicable.
- Serial Number: Enter the serial number of your asset.
- Warranty Expires: Enter the date the warranty for your
asset expires.
- Notes: Enter any notes concerning your asset that you
want to track.
- Leave the sales information blank, and click OK.
What Do I Need Before Adding A
Loan To The Loan Manager? Before adding
loans to the Loan Manager, you'll need to gather your loan
information.
For a new loan:
- Set up a liability account for the loan in QuickBooks.
When you add the account and lender details, include any
information you want the Loan Manager to use for tracking,
such as the account number and lender contact information.
This information can be found on your loan documents. Be
sure that you enter the correct opening balance for the
account. Otherwise, you will not be able to set up payments
from the loan manager.
- Set up an expense account for tracking the loan
interest.
- If you need to make escrow payments to the loan, set up
an escrow account for them.
- Make sure all transactions for the loan liability and
interest accounts are up to date.
For an existing loan:
- Make sure all transactions for the loan liability and
interest accounts are up to date.
- Check to see that you have entered the loan details you
want the Loan Manager to use for tracking, such as the
account number and lender contact information. This
information can be found on your loan documents.
When you're ready to add a loan to the Loan Manager, have
your loan documents in hand. You'll need them for the
origination date, payment amount, term, escrow amount (if
any), interest rate, and other information.
Adding a loan to the Loan Manager
- From the Banking menu, choose Loan Manager.
- In the Loan Manager window, click Add a Loan.
- In the Add a Loan window, complete each section as
follows:
- Enter account information for this loan.
- Enter payment information for this loan.
- Enter interest information for this loan.
- Click Finish.
How Do I Track Mileage For A
Vehicle? QuickBooks can track mileage for
your business vehicles. You can use the mileage information
for tax deductions for your vehicles, and to bill customers
for mileage expenses. You cannot use vehicle mileage tracking
to reimburse your employees for mileage.
To track vehicle mileage
- Enter the current mileage rates for vehicle mileage.
- Add a vehicle to the Vehicle List.
- Enter mileage for a vehicle.
- Run vehicle mileage reports.
Enter the current mileage rates for vehicle
mileage Keep your mileage rates up-to-date so you
can always take advantage of the latest IRS deduction rates
for your business vehicles. QuickBooks calculates the
appropriate mileage expense based on the dates and rates you
enter in the Mileage Rates window. Check regularly with the
IRS for the latest rates and enter each date and rate change
as it becomes effective.
- From the Company menu, choose Enter Vehicle Mileage.
- On the toolbar in the Enter Vehicle Mileage window,
click Mileage Rates.
- In the Mileage Rates window, select a date from the
calendar for the Effective Date, then press Tab.
- Enter the IRS rate for that date, then click Close.
Add a vehicle to the Vehicle List To
track mileage for a vehicle, you must add it to the Vehicle
list. If you already have the Enter Vehicle Mileage window
open, you can QuickAdd a vehicle by clicking "Add New" on the
Vehicle dropdown list.
To add a vehicle to the Vehicle list
- From the Company menu, choose Enter Vehicle Mileage.
- In the Enter Vehicle Mileage window, click Vehicle List
(on the toolbar).
- From the Vehicle menu, choose New.
- In the New Vehicle window, enter a name for the vehicle
and an optional description.The vehicle name might be the
model and year of the car, the license number, or a specific
number that you've given to a vehicle.
- Click OK.
Enter mileage for a vehicle
- From the Company menu, choose Enter Vehicle Mileage.
- In the Enter Vehicle Mileage window, choose the vehicle
(or add a new vehicle) for which you want to enter a mileage
record.
- Enter the start and end dates for the trip.
- Enter the mileage from the odometer start and end
readings. QuickBooks will calculate the total mileage for
you, based on these numbers.
- (Optional) If you plan to bill a customer, select the
"Billable" checkbox.
- If you selected to bill a customer for the mileage,
choose the appropriate items from the Customer:Job, Item,
and Class (if class tracking is turned on and it is
applicable to this record) drop-down lists.
- Save your mileage record.
Run vehicle mileage reports There are
four reports you can use to review your vehicle and mileage
records:
- Mileage by Vehicle Summary
- Mileage by Vehicle Detail
- Mileage by Job Summary
- Mileage by Job Detail
How Do I Charge My Customers
For Mileage?
- Enter the vehicle mileage, being sure to mark it
Billable and assign it to a customer:job.
- Open the sales form where you want to enter the cost,
and click Time/Costs on the toolbar.
- In the Choose Billable Time and Costs window, select the
Mileage tab.
- Select the "Use" column to the left of the mileage item.
- (Optional) Click Options to determine how you want the
mileage expenses to appear on the invoice.
You can
combine several mileage items, include descriptions, etc.
These options allow you to view the detail in QuickBooks,
even if you print the sales form showing only single line
items.
- Combining mileage from several trips
- Charging a customer more than the amount of the
mileage expense
- (Optional) If you want the mileage expenses you select
to appear as a single line item when you print the invoice
or sales receipt, select the "Print selected time and costs
as one invoice item" checkbox. If you select this checkbox,
it overrides the options for transferring billable mileage
settings.
Note: Do this only if you are certain you want
the printed invoice to show only the total of the costs (and
not a line-by-line listing of each cost). Once you record
the invoice or sales receipt, it is difficult to print the
costs separately. To go back, you will need to delete the
original expense transaction and then select the invoice
column (to the right of the Customer:Job column) on the
Expenses or Items tab. When you print the invoice or
sales receipt, it shows one amount (the sum of all the
expenses). The Description column lists the amount as "Total
reimbursable expenses." If you want, you can change this
description by editing the onscreen version of the invoice
or the sales receipt.
- Click OK.
|
| |
| QuickBooks Tips |
| |
|
Allocating Job Costs Estimating Construction Contracts Progress Billing for Lump-sum
Contracts Billing Cost-plus
and Time and Material Contracts Change Orders Retainages (Retention) Over/Under Billings Unbilled Time that Will Not Be
Invoiced
|
|
|
Allocating Job
Costs QuickBooks allows users to assign job
costs to a project and indicate whether the expenses are
billable to the customer/owner. To do that, enter the
customer/owner or a project to be charged in the
"Customer:Job" column as you record the bill, check, or credit
card. An icon will appear next to the "Customer:Job" column
indicating the expense is billable to the customer/owner. If
the expense is not billable, click the icon to change it to an
"X" indicating the expense is not billable. For example,
cost-plus and time and material contracts are billable, but
lump-sum contracts should be marked as not billable. If job
costs should be tracked as an asset (e.g., a homebuilder with
a spec home), record those costs to an asset account such as
"Spec Home."
Estimating Most
construction contractors compete for projects through bidding.
Even smaller contractors often provide customers with an
estimate of the project. Accurately estimating a project is
critical to the contractor's business. When preparing a bid or
an estimate, contractors must make sure that all costs are
included in their estimates. Direct costs, such as materials,
labor, and subcontract costs, can, in most cases, be
accurately estimated and included. Other costs such as
overhead and interest are less obvious but still must be
considered. To create an estimate in QuickBooks, select
"Create Estimates" from the "Customers" menu and fill in the
information requested by the form.
Note: Group items may be set up in QuickBooks to summarize
a group of items or services identified as one unit for the
estimate. To set up a group item, select "Item List" from the
"Lists" menu. Select "New" from the "Item" menu button and
choose "Group" from the "Type" drop-down list. Then, enter the
name of the item group and select the items to be included in
the group.
Construction
Contracts The type of construction contract
determines the method for billing the customer/owner in
QuickBooks. Contractors use the following types of
contracts:
- Lump-sum/Fixed Price. These contracts generally provide
that the contractor guarantees to complete the project for
an agreed-upon price. Owners often prefer a lump-sum
contract because they feel it limits their exposure to cost
overruns, though the contract price may be increased by
change orders for various reasons.
- Cost-plus. These contracts provide for reimbursement of
allowable or defined costs incurred plus a fee that
represents profit. The fee may be a fixed amount, a
percentage of reimbursable costs, or an amount based on
performance criteria.
- Time and Materials. These are contracts that generally
provide for payments to the contractor on the basis of
direct labor hours at fixed hourly rates (that cover the
cost of direct labor, indirect expenses, and profit) and the
cost of materials. Total contract price is determined
similarly to the manner used for cost-plus contracts, and
modifications to the total contract price should be made
whenever changing circumstances can be reasonably predicted
and measured.
Progress Billing for Lump-sum
Contracts Most construction projects take
several months or even longer to complete, and interim
billings are prepared as the work progresses. Progress
billings can sometimes identify budget overruns and other
problems early enough to allow the contractor to remedy the
problem and avoid large write-offs. If the "Jobs &
Estimates" company preferences were set up, QuickBooks Pro,
Premier, Premier-Accountant, or Premier-Contractor may be used
to process invoices from estimates as the project progresses.
The user has the choice of invoicing either for a fixed
percentage of the estimate or for different percentages of
each line item on the estimate. The preferential method of the
percentage to bill is the percentage-of-completion method.
Previous amounts billed on the estimate also can be shown on
the invoice. To prepare a progress billing using QuickBooks
Pro, Premier, Premier-Accountant, or Premier-Contractor, first
create an estimate. Then, create an invoice for that project
by selecting "Customers," "Create Invoices" from the menu bar.
(When an invoice is created for an owner or a project for
which an estimate has been created, a window will appear with
estimates available to create an invoice. Select the estimate
to create the invoice and enter the percentage of the estimate
to be billed.) Job costs will be allocated to the project and
marked as not billable.
Note: In versions prior to QuickBooks Pro, Premier, and
Premier-Accountant 2002, when an invoice is created for a
customer/owner or job for which an estimate has been created,
a prompt will appear asking whether you want to create the
invoice based on the estimate. Answer yes, and enter the
percentage of the estimate to be billed.
Billing Cost-plus and Time and
Material Contracts Cost-plus and time and
material contracts are billed based on reimbursable time and
expenses on the invoice or the billing statement, select
"Time/Costs" on the toolbar that appears at the top of the
window when preparing the invoice or billing statement. Select
the items to bill in each tab (i.e., items, expenses, and
time) of the "Choose Billable Time and Costs" window and
select "OK." Expenses may be marked up with an amount or a
percentage in this window.
If the contractor requires a review process prior to
billing customers/owners or inputs partial invoices to bill
later, the user can create pending invoices. Pending invoices
will not post to the register until marked final, but they can
be printed for review. To create a pending invoice, create an
invoice and choose "Mark Invoice As Pending" from the "Edit"
menu. Once the invoice is approved, display the invoice and
choose "Mark Invoice As Final" from the "Edit" menu.
Change
Orders Change orders modify provisions of
the original contract but do not add new provisions. Some
change orders generate no additional revenues or expenses, but
more often they do. To record an approved change order under
the percentage-of-completion method in QuickBooks, first set
up a subjob identified as a change order. To do that, select
the job from the "Customer:Job List," select "Add Job" from
the "Customer:Job" menu button, and enter the job name and any
other job details. Next, edit the original estimate to include
the change order to bill the owner on one invoice or record a
separate estimate for the subjob to bill the owner separately
for the change order. Total estimated contract revenues and
total estimated contract costs should include the change order
for the percentage-of-completion calculation.
Retainages
(Retention) Retainages (also called
retention) are amounts withheld from progress billings until
final and satisfactory project completion. The owner typically
withholds or retains a percentage of the progress payments due
the contractor until project completion. The contractor, in
turn, retains a portion of the payments due subcontractors.
The purpose of retainage is to provide the owner security for
costs incurred to repair defective work, to settle claims from
parties not paid by the contractor, and to ensure that work is
completed in accordance with the contract. Retainage due from
the owner is recorded as a contract receivable and retainage
payable to the subcontractor is recorded as a liability. To
account for retainage receivable and retainage payable due
within one operating cycle in QuickBooks, the user must:
- Add an "Other Current Asset" type account called
"Retainage Receivable" to the chart of accounts list and add
a subaccount for each customer/owner. "Retainage Receivable"
generally is reported as a part of "Contract Receivables" on
the financial statements; therefore, the practitioner may
wish to reclassify the amount when reporting. (Items cannot
be associated with accounts receivable type accounts in
QuickBooks, as discussed in step c.)
- Add an "Other Current Liability" type account called
"Retainage Payable" to the chart of accounts list and add a
subaccount for each vendor/subcontractor. "Retainage
Payable" generally is reported as a part of "Accounts
Payable" on the financial statements; therefore, the
practitioner may wish to reclassify the amount when
reporting. (Items cannot be associated with accounts payable
type accounts in QuickBooks, as discussed in step c.)
- Add "Other Charge" items for the various retainage
receivable percentages. Enter the percent as a negative and
link the items to the asset account created in step a. Add
an "Other Charge" item for retainage payable, leave the
amount blank, and link the item to the liability account
created in step a. (QuickBooks will not allow an item with a
percentage to be entered on an accounts payable bill.)
- After creating the invoice for an owner, add a subtotal
item on the line after the last item being billed and then
enter the retainage receivable item created in step c.
- After creating the accounts payable bill for a
subcontractor, add a subtotal item on the line after the
last item being billed and then enter the retainage payable
item created in step c. and the amount withheld.
- When billing an owner or paying a subcontractor for the
final retainage amounts, record the invoice or bill with the
appropriate item created in step c. and enter the amount. A
separate item may be set up for final retainage receivable,
if desired, or the description can be typed over on the
invoice/bill.
Over/Under
Billings Over/under billings are unique to
the construction industry. The accounts are aggregates for
each of the two categories, and the accounts should not be
offset or presented as a net amount. Underbillings are
reported as a current asset to reflect revenues recognized in
excess of amounts billed, and overbillings are reported as a
current liability to reflect billings in excess of revenues
recognized. QuickBooks will not automatically add the
over/under billing accounts to the chart of accounts list, nor
will it automatically calculate the amounts. Construction
contractors who want to track over/under billings in
QuickBooks may calculate the amounts and record them as a
journal entry at the end of each period. If the calculation is
extensive, QuickBooks may not be appropriate. The accounts to
set up in QuickBooks are as follows:
- Costs (and estimated earnings) in excess of billings on
uncompleted contracts (underbillings)- other current asset
account.
- Billings in excess of costs (and estimated earnings) on
uncompleted contracts (overbillings)-other current liability
account.
Unbilled Time that Will Not Be
Invoiced Many construction contractors keep
track of time by customer/owner, but do not bill the
customer/owner based on that time. For example, the contractor
may decide to bill the customer/owner based on a method other
than a time-based fee (e.g., lump-sum/fixed price). As a
result, the contractor bills the customer/owner, but the time
remains "unbilled" on the time reports.
To change the "unbilled" time status to "billed" on the
time reports, the user should:
- Create an Invoice for the Time. Select "Customer,"
"Create Invoices" from the menu bar to enter the invoice.
Select the Customer:Job to which the time was charged. Enter
an invoice number. The user may want to use a different
invoice numbering system to keep the invoices separate from
the invoices that will be sent to customers. To invoice for
the time, select "Time/Costs" on the toolbar that appears at
the top of the window.
- Issue a Credit Memo for the Invoice Created in Step a.
Select "Customers," "Create Credit Memo/Refunds" from the
menu bar to enter the credit memo. Select the Customer:Job
for which the original invoice was created. Enter a credit
number. The user may want to use a different credit memo
numbering system to keep the credit memos separate from the
credit memos that will be sent to customers. Enter the time
information. The credit memo should look exactly like the
original invoice.
- Receive Payments from Customer and Apply the Credit.
Select "Customers," "Receive Payments" from the menu bar to
apply the credit memo created in step b. to the invoice
created in step a.
- File the Original Invoice and the Credit Memo Together
in the Customer's File.
To obtain the billing status of time, generate the "Time by
Job Detail" report by selecting "Reports," "Jobs & Time"
from the menu. |
| |
| QuickBooks Product
Updates |
| |
| QuickBooks Online
Edition Enhancements |
|
QuickBooks Online Edition
Enhancements The following are Online
Edition enhancements that took effect on March 13, 2004:
Customized Home Page &
Overviews The Home page now has flexible sections
that you can move, add, collapse, or remove. A new "Money
In/Out" flow diagram helps guide you to the tasks you want to
perform. It even changes to match your preferences. For
example, if you don't turn on the "Estimates" preference, the
Estimates icon is not included on the "Money In/Out" diagram.
All overviews are now dynamic in this way.
More Ways To Learn New Online Edition
users will benefit from a new onscreen tutorial with seven
interactive lessons. Also included is a two-page "Getting
Started Guide". Both of these learning tools are accessible by
clicking "Start Here!" from the Home page, or by looking up
"welcome" in the Help Index.
Estimates You can now easily prepare
quotes or bids for your customers. Once work has been
performed, it's simple for you to move the estimated charges
onto an invoice for billing. Estimates share the same
professional look of other customer sales forms in the Online
Edition. To start using estimates, simply turn on the
"Estimates" preference.
Plus Package Price & Billing
Changes There are changes to the price and billing
configuration of the QuickBooks Online Edition Plus Package.
Now there are two Plus Packages in the Online Edition, the
"Sales" package and the "Business Management" package.
The Sales Plus Package costs $9.95 per month and contains
the following features:
- Charges
- Custom Invoice Styles
- Expense Tracking by Customer
- Time Tracking
The Business Management Plus Package costs $7.95 per month
and includes the following:
The Time Tracking feature works for an unlimited number of
“time tracking-only” users.
You can receive both Plus Packages for a reduced total of
$15.00 per month - a 16% savings, equivalent to the existing
Plus Package price. Online Edition users who have subscribed
to the existing Plus Package can move to one of the new,
lower-cost Plus Packages.
To learn more about QuickBooks Online Edition, click here.
|
| |
| Articles |
| |
| QuickBooks Setup for
Construction Companies |
|
|
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. |
| | |
|
|
|