| |
|
QuickLabs.com 14515 North East 67th Court Redmond,
WA 98052 |
|
|
|
| Table of Contents |
July 2003 |
| |
|
QuickBooks News
QuickBooks
Features
QuickBooks Common
Questions
QuickBooks Tips
QuickBooks Product
Updates
Articles
Prior Issues |
| |
| QuickBooks News |
| |
QuickBooks Basic/Pro/Premier
2003 Release 7 (R7) Intuit, the makers of
QuickBooks, creates a maintenance release when improvements
are made in the current version of QuickBooks, or when
problems with the software are discovered and fixed. Release 7
includes all changes that have been made to your QuickBooks
2003 software since it was first released. See Release 7
Summary in QuickBooks Updates.
Complete Payroll for
QuickBooks Online Edition Intuit's Complete
Payroll is the only full service payroll solution that
seamlessly updates data not only into QuickBooks, but now also
into QuickBooks Online Edition, providing small businesses
with a comprehensive anytime, anywhere accounting and
full-service payroll solution. The new offering maximizes
productivity and provides business insight through flexible
service and powerful reporting capabilities that can be
accessed on the road, at home or the office.
E-File & Pay for QuickBooks
Do-It-Yourself Payroll Fully integrated
with QuickBooks accounting software, QuickBooks Do-It-Yourself
Payroll gives business owners all of the tools and tax tables
they need to manage their payroll, plus timely updates to
ensure they stay compliant. Do-It-Yourself Payroll is now
available with E-File & Pay options for federal and
quarterly state payroll tax electronic filing and payment,
which provide significant productivity gains for payroll
users. The state forms and eFiling are licensed from Aatrix
Software Inc. With the click of a button, federal and
quarterly state forms are filed and tax liability paid,
allowing small businesses to save time by filing and paying
federal and state payroll taxes electronically. Intuit
guarantees that filings will be made on time, reducing the
possibility of costly fines. Due to the QuickBooks
integration, E-File & Pay eliminates the need to manually
re-enter data into payroll tax forms and reduces the risk of
errors.
Complete Payroll HR
Assistant Available beginning in July 2003,
Complete Payroll's HR Assistant helps business owners manage
employee information and stay in compliance with federal and
state employment laws and regulations. Integrated directly
with Complete Payroll's PC Entry software, HR Assistant
provides employers with guidance to perform key HR events and
processes, answers common employee administration questions,
and provides the forms and templates required for managing
employees. HR Assistant integrates with information already in
Complete Payroll - eliminating duplicate data entry and
helping to ensure greater accuracy, while expediting employee
administration and payroll. Regular updates are provided by
CCH, the nation's tax and business law leader since 1913, to
help ensure that employers stay compliant.
|
| |
| QuickBooks Features |
| |
Bank
Reconciliations The following paragraphs
provide guidance for using QuickBooks to reconcile bank
accounts accurately and efficiently. The discussion also
provides guidance on common reconciling differences and how to
detect those differences.
Reconciliation Procedures QuickBooks
allows users to reconcile bank statements by selecting
“Reconcile” from the “Banking” menu. Users should select the
bank account to be reconciled from the “Account” drop-down
list in the “Begin Reconciliation” window. Then, enter the
statement date, the ending balance from the current bank
statement, the service charges or interest earned from the
bank statement, and the applicable account to charge such
amounts. Click “Continue” and QuickBooks automatically
displays:
- Beginning Balance - This amount should equal the ending
balance from the prior month’s bank statement (which should
be the beginning balance on the current bank statement).
- Deposits and Other Credits - These amounts represent
uncleared deposits and other credits recorded in QuickBooks
through the current date.
- Checks and Payments - These amounts represent uncleared
checks and other payments recorded in QuickBooks through the
current date.
Note: The “Begin Reconciliation” window is not available in
versions prior to QuickBooks 2002. When users of earlier
versions select “Reconcile” from the “Banking” menu, the
“Reconcile” window is automatically displayed. Users should
enter the ending balance from the current bank statement,
service charges or interest earned from the bank statement,
and the applicable account to charge such amounts in this
window.
QuickBooks users should perform the following procedures in
the “Reconcile” window:
- Check all deposits and other credits, as well as all
checks and other payments that appear on the bank statement.
Do not check transactions that have occurred but that have
not been posted to the bank statement.
- Enter any transactions that appear on the bank statement
but that are not listed in the “Reconcile” window. Enter
such transactions by selecting “Use Register” from the
“Banking” menu and recording the applicable information in
the blank line at the end of the register. (Alternatively,
users can select “Chart of Accounts” from the “Lists” menu
and double-click on the applicable bank account to access
the account register.)
- Change any incorrect transaction by double-clicking on
the transaction and making any necessary corrections to the
source document.
- Click the “Reconcile Now” button after reconciling the
difference between the ending balance and the cleared
balance to zero.
- Print the “Reconciliation Report.”
QuickBooks allows users to have both the bank account
register and the “Reconcile” window open at the same time,
which users may find helpful while reconciling the bank
statement. Having both windows open allows users to locate
reconciling differences more easily. In addition, QuickBooks
automatically updates any affected information in the
“Reconcile” window when users correct transactions in the bank
account register. QuickBooks users can open the bank account
register by selecting “Chart of Accounts” from the “Lists”
menu and double-clicking the applicable bank account.
Reconciling Beginning Balance
Differences The beginning balance in the
“Reconcile” window may not match the bank statement beginning
balance the first time a bank account is reconciled in
QuickBooks. Users should enter beginning bank account balances
as of the last bank statement date on or before the QuickBooks
start date. However, users erroneously may enter the general
ledger balance as of the QuickBooks start date (or setup date)
as the bank account beginning balance. In that case, the
amount displayed as the “Beginning Balance” in the “Reconcile”
window will not agree to the beginning balance on the bank
statement the first time an account is reconciled. QuickBooks
users can correct the beginning balance by selecting “Chart of
Accounts” from the “Lists” menu and double-clicking on the
applicable bank account. Users then can locate the beginning
balance transaction in the account register and correct the
amount and transaction date. (QuickBooks automatically posts
the offsetting entry to “Opening Balance Equity.”) QuickBooks
then updates the beginning balance in the “Reconcile” window.
Users cannot edit the beginning balance amount directly in the
“Reconcile” window.
After a bank account is reconciled in QuickBooks for the
first time, the beginning balance in the “Reconcile” window
may not match the bank statement beginning balance if:
- The QuickBooks user erroneously cleared a transaction
for the current bank statement period in the bank account
register. In that case, QuickBooks automatically changes the
beginning balance in the “Reconcile” window, as if the
transaction had been cleared in a prior reconciliation. The
current “Reconcile” window does not list the cleared
transaction as a deposit or payment.
- The QuickBooks user “uncleared” a previously cleared
transaction for a prior bank statement period in the bank
account register. In that case, QuickBooks automatically
changes the beginning balance in the “Reconcile” window, as
if the transaction had not been cleared in a prior
reconciliation. The current “Reconcile” window lists the
uncleared transaction as a deposit or payment with a
checkmark beside it.
- The QuickBooks user changed, voided, or deleted a
previously cleared transaction after the prior
reconciliation.
If the beginning balance in the “Reconcile” window does not
match the bank statement beginning balance for a particular
month, QuickBooks users should perform the following
procedures:
- Calculate the difference between the bank statement
beginning balance and the beginning balance in the
“Reconcile” window.
- Look for the difference in the “Payment” and “Deposit”
columns of the bank account register.
- Look for checkmarks in the bank account register for
transactions dated in the current bank statement period.
(Checkmarks indicate that a transaction has been “cleared.”
Asterisks beside a transaction that has not been reconciled
indicate that the cleared status of the transaction is
pending because the bank reconciliation is not complete.)
- Look for asterisks in the bank account register for
transactions dated in a prior bank statement period.
(Asterisks beside a transaction that has been reconciled
previously indicate that a previously cleared transaction
has been “uncleared.”)
- Look for voided transactions in the bank account
register.
- Review the prior month’s bank reconciliation report for
the difference.
- Look for the difference in the “Audit Trail” report.
Also look for deleted or modified transactions in the
report.
- Review differences in the “Reconcile Discrepancy” report
(QuickBooks Premier and Premier-Accountant only).
- Look for entries that were changed after the last
reconciliation by reviewing the “Transaction Report by
Date.” (From the “Reports” menu, select “Custom Transaction
Detail Report.” Click the “Filters” tab, choose “Account,”
and select the account. Choose “Date,” and select the date
from the earliest transaction to the date of the last
reconciled bank statement. Choose “Entered/Modified” and
enter the date the last reconciliation was completed to
today’s date. Choose “Cleared,” and select “Yes.”)
QuickBooks users can change the status of an erroneously
“cleared” or “uncleared” transaction by selecting “Chart of
Accounts” from the “Lists” window and double-clicking on the
applicable bank account. Users then can click on the field
between the “Payment” and “Deposit” fields for the applicable
transaction and (a) remove a checkmark if the transaction has
been “cleared” erroneously, or (b) enter a checkmark if the
transaction has been “uncleared” erroneously. QuickBooks then
automatically changes the beginning balance when the
“Reconcile” window is reopened. QuickBooks users cannot edit
the beginning balance amount directly in the “Reconcile”
window.
Reconciling Ending Balance and Cleared Balance
Differences If the difference between the ending
balance and the cleared balance is not zero after following
the procedures above, QuickBooks users should:
- Verify that the amount in the “Beginning Balance” field
matches the beginning balance on the bank statement.
- Verify that the amount entered in the “Ending Balance”
field matches the ending balance on the bank statement.
- Verify that the number of transactions listed on the
bank statement equals the number of transactions checked in
the “Reconcile” window. Entries in the “Service Charge” or
“Interest Earned” fields should be counted as transactions.
(QuickBooks specifies the number of cleared transactions at
the lower left corner of the “Reconcile” window.) If the
transaction numbers are not equal:
- Verify that all transactions marked as cleared in the
“Reconcile” window are included in the bank statement.
- Verify that all transactions included in the bank
statement are marked as cleared (or entered as a service
charge or interest earned) in the “Reconcile” window.
- Verify that the amounts checked in the “Reconcile”
window match the amounts on the bank statement.
- Review the “Missing Checks” report to verify that all
checks have been entered. Generate the report by selecting
“Banking” and then “Missing Checks” from the “Reports” menu.
- Look for the difference between the ending balance and
the cleared balance in the “Payment” and “Deposit” columns
of the bank account register.
- Verify that a payment checked as cleared was not entered
as a deposit (or that a deposit checked as cleared was not
entered as a payment) by dividing the difference by two and
looking for that amount in the “Payment” and “Deposit”
columns of the bank account register.
- If the difference is evenly divisible by nine, search
for transposition errors by comparing cleared amounts in the
“Reconcile” window to amounts in the bank statement.
- Look for the difference in the “Audit Trail” report.
- Look for the difference in the “Reconcile Discrepancy”
report (QuickBooks Premier and Premier-Accountant only).
QuickBooks users can search the bank account register for
errors by selecting “Chart of Accounts” from the “Lists” menu
and double-clicking on the applicable bank account. Users then
can click the “Go to” button at the upper left corner of the
bank account register and enter the desired search criteria in
the “Go To” window.
The difference between the ending balance and the cleared
balance may not be zero the first time a bank account is
reconciled in QuickBooks. QuickBooks users should enter all
cash transactions occurring between the last bank statement
date on or before the QuickBooks start date and the QuickBooks
start date, as well as all cash transactions occurring between
the QuickBooks start date and the actual set-up date. To
verify that all such transactions have been entered,
QuickBooks users should compare the transactions listed in the
“Reconcile” window to those listed in the first bank statement
after the QuickBooks start date. Any “missing” transactions
should be entered. That is, cash transactions occurring
between the prior bank statement date and the QuickBooks start
date should be entered with an offsetting entry to “Opening
Balance Equity.” Cash transactions occurring between the
QuickBooks start date and the actual set-up date should be
entered with an offsetting entry to the applicable expense,
income, asset, or liability account.
Adjusting Unresolved
Differences QuickBooks allows users to adjust
unresolved differences by clicking the “Reconcile Now” button
and then clicking the “Enter Adjustments” button in the
“Reconcile Adjustment” window. However, QuickBooks offsets the
entry to the bank account against “Opening Balance Equity.”
Consequently, users should not adjust unresolved differences
via the “Reconcile Adjustment” window. Instead, users should
click “Cancel” in the “Reconcile Adjustment” window and
returning to the “Reconcile” window. Next, the users should
record a journal entry for immaterial unresolved differences.
The adjustment to the bank account can be offset against a
charge or credit to miscellaneous expense or income.
QuickBooks then lists the adjustment to the bank account in
the “Reconcile” window, and users can check the adjustment as
cleared. If QuickBooks users subsequently determine the cause
of the difference, a journal entry can be recorded to reverse
the charge or credit to miscellaneous expense or income and
post the difference to the correct account(s). This procedure
does not affect the balance in the bank account or subsequent
bank reconciliations.
Leaving the Reconciliation Process If
QuickBooks users do not have enough time to finish the bank
reconciliation, they can click the “Leave” button at any time
during the reconciliation. QuickBooks retains the information
related to cleared transactions in the “Reconcile” window so
that the reconciliation can be finished later. However, users
must re-enter the ending balance, service charges, and
interest earned each time the “Reconcile” window is
opened.
Printing the Reconciliation Detail
Report After the reconciliation is complete (i.e.,
the ending balance equals the cleared balance), QuickBooks
users should click the “Reconcile Now” button. QuickBooks then
displays the “Select Reconciliation Detail Report” window that
asks users which type of reconciliation report they would like
to print. Users can choose to print a summary report or a
detail report. Although QuickBooks does not require users to
print a reconciliation report, (users can click on “Cancel” to
leave the “Select Reconciliation Detail Report” window without
printing a report) users should print a detail report for each
reconciliation.
The information in the detail report provides documentation
of the reconciliation, as well as an audit trail. In addition,
if the opening balance in the subsequent month’s
reconciliation is incorrect, users can review the prior
month’s reconciliation report to help resolve the discrepancy.
The “Reconciliation Detail” report lists the detail for all
cleared transactions, as well as all uncleared transactions
dated on or before the bank statement closing date. In
addition, the report lists the detail for all new transactions
dated after the bank statement closing date. The
“Reconciliation Summary” report lists the totals (but not the
detail) for all cleared transactions, uncleared transactions
dated on or before the bank statement closing date, and new
transactions dated after the bank statement closing date.
Basically, the summary report is the first page of the detail
report.
Note: The “Select Reconciliation Detail Report” window was
not available prior to QuickBooks 2002. When users of earlier
versions of QuickBooks click the “Reconcile Now” button,
QuickBooks displays the “Reconciliation Complete” window that
asks users which type of reconciliation report they would like
to print. Users can choose to print no report, a summary
report, or a full report. Users of these versions should also
specify the bank statement closing date in the “Reconciliation
Complete” window before printing the “Reconciliation
Report.”
QuickBooks users can choose to display or print the
“Reconciliation Detail Report.” If they choose to display the
“Reconciliation Report,” they have the option to customize or
filter the report and, if they wish, export the report to
Excel. Exporting the report to Excel and saving it is
recommended if they want to print the report again at a later
time. Once the reconciliation is performed, QuickBooks stores
the most recent reconciliation report and overwrites the data
in the “Reconcile” window. Consequently, the next time the
“Reconcile” window is opened, data pertaining to the next
reconciliation appears. However, QuickBooks users can print
the most recent reconciliation by clicking the “Last Report”
button at the lower left corner of the “Reconcile” window.
QuickBooks adds the company name to the bank reconciliation
reports to help users that work with multiple companies.
Note: The company name is not printed on bank
reconciliation reports in QuickBooks Version 2000 and earlier.
QuickBooks Version 2001 and earlier do not have the option of
displaying the “Reconciliation Report.” Users should print the
“Reconciliation Report” to a file rather than a printer if
they want to print the report again at a later time.
QuickBooks Premier and Premier-Accountant provide a
“Reconcile Discrepancy” report that lists the cleared
transactions that have changed since the last reconciliation.
This report is helpful when the beginning balance in the
“Reconcile” window is different than the beginning balance on
the bank statement. QuickBooks users can generate the
“Reconcile Discrepancy” report by selecting “Banking” and then
“Reconcile Discrepancy” from the “Reports” menu.
“Catching up” on
Reconciliations QuickBooks users that have skipped
reconciling their bank statements for several months or that
have never reconciled their statements should “catch up” by
reconciling each statement separately, beginning with the
earliest month. However, if separate reconciliations are not
feasible, QuickBooks users can reconcile the most recent bank
statement and work backwards as follows:
- Manually reconcile the most recent bank statement
- Enter the ending balance from the manually reconciled
bank statement in the “Ending Balance” field in the “Begin
Reconciliation” window
- Click the “Mark All” button at the lower left corner of
the “Reconcile” window to clear all outstanding transactions
- Delete the checkmarks from the transactions listed as
outstanding in the manual reconciliation
- Click the “Reconcile Now” button if the difference
between the ending balance and the cleared balance is
immaterial. Record a journal entry record an adjustment for
the difference.
- Manually reconcile the preceding month if the difference
between the ending balance and the cleared balance is
significant, and repeat the preceding steps
Printing Sequential Check
Registers QuickBooks automatically sorts bank
account registers by date, type, and document number. However,
QuickBooks users may find it useful to print registers sorted
by document number to assist in the bank reconciliation
process. (QuickBooks does not allow users to sort the register
by type and then document number. For example, users cannot
sort the register first by type so that all deposits are
listed together and all checks are listed together.) Sorting
the register by document number lists all checks sequentially
in check number order. To sort the register in document number
order, QuickBooks users should:
- Select “Chart of Accounts” from the “Lists” menu
- Double-click on the applicable bank account
- Select “Number/Ref” from the “Sort by” drop-down list in
the lower left corner of the register window
QuickBooks users also may find it helpful to sort the bank
account register by cleared status. That sort lists
transactions that have been reconciled with a bank statement
(i.e., transactions with a checkmark) first. Transactions in
which the cleared status is pending because the bank
reconciliation is not complete (i.e., transactions marked with
an asterisk) are listed next. Uncleared transactions are
listed last. Sorting the register by cleared status may be
helpful when searching for transactions that have been cleared
or uncleared erroneously.
QuickBooks users also may generate the “Check Detail”
report by selecting “Banking” and “Check Detail” from the
“Reports” menu. The “Check Detail” report can be filtered by
check number so that it includes only check numbers in a
specified range.
Limitations on Using the Accountant’s Review
Copy QuickBooks users can generate an accountant’s
review copy that allows their QuickBooks Advisors to enter
adjustments to the client’s QuickBooks files while the client
continues to use QuickBooks for daily operations. However,
Advisors should be aware that they cannot use the accountant’s
review copy to reconcile their client’s bank accounts.
QuickBooks allows Advisors to open the “Begin Reconciliation”
window and enter the ending bank statement balance and the
service charges or interest earned using the accountant’s
review copy. However, QuickBooks does not allow Advisors
to:
- Check transactions as cleared or uncleared
- Edit transactions
Consequently, Advisors cannot reconcile their clients’ bank
statements using the accountant’s review copy in
QuickBooks.
Note: The “Begin Reconciliation” window is not available in
versions prior to QuickBooks 2002. In QuickBooks 2001 and
earlier versions, users will select “Reconcile” from the
“Banking” menu and the “Reconcile” window is automatically
displayed. QuickBooks then allows Advisors to enter the ending
bank statement balance; however, they are not able to enter
any service charges or interest earned from the bank
statement, check transactions as cleared or uncleared, or edit
transactions.
Reconciling the Bank Account Register to the
Balance Sheet The ending balance in the bank
account register (which is also the chart of accounts balance)
may not equal the balance in the general ledger since
QuickBooks allows transactions with future dates (such as
postdated checks) to be recorded. Transactions with future
dates are listed in the bank account register and included in
its balance. However, future transactions are not included in
the general ledger balance for the bank account as of a
specified date. QuickBooks users can reconcile the bank
account register to the general ledger by sorting the register
by date (the way QuickBooks automatically sorts the register)
and scrolling to the general ledger date. The balance as of
the last date on or before the general ledger date should
equal the general ledger balance.
Reconciling Credit Card
Transactions QuickBooks users can reconcile
credit card purchases to the monthly card statement by
selecting “Reconcile” from the “Banking” menu. Users should
select the credit card account to be reconciled from the
“Account” drop-down list in the “Begin Reconciliation” window.
Then, enter the statement date, the ending balance from the
current credit card statement, the finance charges or fees
from the credit card statement, and the applicable account to
charge such amounts. Click “Continue” and QuickBooks
automatically displays:
- Beginning Balance - This amount should equal the ending
balance from the prior month’s credit card statement (which
should be the beginning balance on the current credit card
statement).
- Payments and Credits - These amounts represent uncleared
credit card payments and credits recorded in QuickBooks
through the current date.
- Charges and Cash Advances - These amounts represent
uncleared credit card purchases and cash advances recorded
in QuickBooks through the current date.
Note: The “Begin Reconciliation” window is not available in
versions prior to QuickBooks 2002. When users of earlier
versions select “Reconcile” from the “Banking” menu, the
“Reconcile” window is automatically displayed. Users should
enter the ending balance from the current credit card
statement, finance charges or fees from the credit card
statement, and the applicable account to charge such
amounts.
QuickBooks users should perform the following procedures in
the “Reconcile Credit Card” window:
- Check all payments and charges that appear on the credit
card statement. Do not check transactions that have occurred
but that have not been posted to the credit card statement.
- Enter any transactions that appear on the credit card
statement but that are not listed in the “Reconcile Credit
Card” window. Enter such transactions by selecting “Use
Register” from the “Banking” menu and recording the
applicable information in the blank line at the end of the
register. (Alternatively, users can select “Chart of
Accounts” from the “Lists” menu and double-click on the
applicable credit card account to access the account
register.)
- Change any incorrect transaction by double-clicking on
the transaction and making any necessary corrections to the
source document.
- Click the “Reconcile Now” button after reconciling the
difference between the ending balance and the cleared
balance to zero.
Note: Version 99 users should click the “Done” button after
reconciling the difference to zero.
If the difference
between the ending balance and the cleared balance is not zero
after following the procedures above, QuickBooks users
should:
- Verify that the number of transactions listed on the
credit card statement equals the number of transactions
checked in the “Reconcile Credit Card” window. An entry in
the “Finance Charges” field should be counted as a
transaction. (QuickBooks specifies the number of cleared
transactions at the lower left corner of the “Reconcile
Credit Card” window.)
- Verify that the amounts checked in the “Reconcile Credit
Card” window match the amounts on the credit card statement.
- Verify that the amount entered in the “Ending Balance”
field matches the ending balance on the credit card
statement.
QuickBooks allows users to adjust unresolved differences by
clicking the “Reconcile Now” button and then clicking the
“Enter Adjustment” button in the “Reconcile Adjustment”
window. However, QuickBooks offsets the entry to the credit
card liability account against opening balance equity.
QuickBooks users should not adjust unresolved differences via
the “Reconcile Adjustment” window. If QuickBooks users do not
have enough time to finish reconciling the difference, they
can click the “Leave” button at any time during the
reconciliation. QuickBooks retains the information related to
cleared transactions in the “Reconcile Credit Card” window so
that the reconciliation can be finished later.
Note: Versions 2000 and 2001 allow users to adjust
unresolved differences by clicking the “OK” button.
Paying Credit Card Charges After
reconciling the credit card account and clicking on the
“Reconcile Now” button, QuickBooks displays the “Make Payment”
window after the reconciliation report is printed or
displayed. As illustrated by the following, this window
specifies the outstanding balance on the account and allows
users to pay all or part of the balance either by writing a
check for payment or entering a bill for payment later.
Note: Version 2001 or earlier will display the “Made
Payment” window.
If QuickBooks users enter a bill for payment later,
QuickBooks records a debit to the credit card liability
account and a credit to the accounts payable account for the
amount specified in the “Enter Bills” window. That amount also
is reflected as a payment the next time the “Reconcile Credit
Card” window is opened. If the user subsequently pays a
different amount than the amount entered in the “Enter Bills”
window, QuickBooks debits accounts payable for the actual
amount paid but does not change the balance in the credit card
liability account. Consequently, the accounts payable balance
and the credit card liability balance both are incorrect by
the difference between the amounts entered in the “Enter
Bills” and “Pay Bills” windows. In addition, QuickBooks lists
the amount in the “Enter Bills” window rather than the actual
payment amount the next time the “Reconcile Credit Card”
window is opened.
QuickBooks users that want to pay a bill for an amount
different from the amount entered in the “Enter Bills” window
should edit the amount in the “Enter Bills” window before
paying the bill. For example, a QuickBooks user may enter the
bill for the entire amount due but later decide to pay less
than the amount due. In that case, the amount in the “Enter
Bill” window should be changed to the actual amount to be paid
before paying the bill. That procedure corrects the accounts
payable and credit card liability balances. In addition, the
actual payment amount is listed the next time the credit card
account is reconciled.
Recording Credit Card Purchases
Monthly Some QuickBooks users do not record credit
card purchases as they occur. Instead, those users record
credit card charges monthly after receiving the credit card
statement. Users record such charges by selecting “Chart of
Accounts” from the “Lists” menu and double-clicking on the
applicable credit card account. QuickBooks then displays the
credit card account register, and users generally enter the
entire credit card statement balance as one transaction and
split the total amount among the applicable accounts to be
charged. Even though it may seem easier to record all credit
card charges in total at the end of the month after receiving
a statement, that method causes the following problems:
- Credit card liability accounts are understated during
the month.
- Expense accounts are understated during the month.
- Inventory balances may be understated if inventory items
are purchased with credit cards.
- QuickBooks cannot report purchases by vendor accurately
because the credit card charges are posted as one
transaction. (Information for 1099 vendors will not be
available.)
- QuickBooks users must remember to charge the credit card
liability account when entering the transaction in the
“Enter Bills” or “Write Checks” windows. Otherwise, expense
accounts may be double-charged and the credit card liability
account will not be cleared.
- Balances must be paid in full.
Some QuickBooks users treat credit card purchases like
purchases from any other vendor. Those users do not set up a
separate credit card account by which to record credit card
purchases. Instead, those users record credit card statement
charges directly in the “Enter Bills” window as they would for
any other vendor. QuickBooks automatically offsets such
charges against the accounts payable account.
The QuickBooks Platinum Business MasterCard allows
QuickBooks users to download their transactions from the
MasterCard directly into QuickBooks; credit card transactions
do not have to be manually entered. However, downloading these
transactions at the end of the month after receiving a
statement may cause many of the same problems stated
above.
|
| |
| QuickBooks Common
Questions |
| |
| Why Is The Beginning Balance
Incorrect In The Begin Reconciliation Window?
The beginning balance in the Begin Reconciliation window
may be incorrect if any of the following have occurred:
- A transaction was cleared directly in the account
register, causing the transaction to be excluded from the
beginning balance in the Begin Reconciliation window. To
include the transaction in the beginning balance, you must
clear it in the Reconcile [Account]
window.
Note: Unlike QuickBooks 2001 and
earlier versions, transactions cleared directly in the
register are no longer used to calculate the beginning
balance for reconciliation. If you are familiar with the way
QuickBooks formerly calculated beginning (opening) balances,
the amount may be different than expected.
- A previously cleared transaction was somehow modified
since the last reconciliation. This includes:
- Voiding or deleting a cleared transaction.
- Changing the amount of a cleared transaction.
- There may be data damage in the company data file.
If you are certain that the discrepancy is due only to
transactions cleared in the account register, choose one of
the following options:
- Complete the reconciliation with the beginning balance
discrepancy:
If you ignore the discrepancy in the Begin
Reconciliation window and click Continue to proceed to the
Reconcile [Account] window, any transactions cleared through
the register will appear and will already have checkmarks
next to them. Use your bank statement to select all other
cleared transactions for the period. Assuming there are no
other issues, the reconciliation should balance correctly.
- Complete the reconciliation of the transactions cleared
in the register before reconciling to the bank
statement:
Because the sum of transactions cleared in the
register is causing the variance between the QuickBooks and
the bank statement beginning balances, if you complete the
reconciliation of these items, you should then be able to
reconcile properly to the bank statement.
- Enter the beginning balance from the bank statement in
the Ending Balance field of the Begin Reconciliation
window, and then click Continue to proceed to the
Reconcile [Account] window.
- The transactions cleared in the register will already
have checkmarks next to them, and the Difference amount in
the lower right corner should be 0.00.
- Click Reconcile Now to finish reconciling these
transactions only, and then begin the reconciliation
process again. The QuickBooks beginning balance will now
match the bank statement beginning balance.
If you suspect that any transactions have been altered or
deleted, choose one of the following options:
- Run a reconciliation detail report:
With this report,
you may be able to find transactions that have been changed
or deleted since your last reconciliation.
- From the QuickBooks Reports menu, choose Banking, and
then choose Reconciliation Detail.
- Select the appropriate account, and then click
Display. Compare this report to reports printed for past
reconciliations to look for differences.
- Locate the discrepancy amount:
(This option will work
only if the discrepancy was caused by a single transaction.)
- From the QuickBooks Edit menu, choose Advanced Find.
- Select Amount in the Filter list, select the equals
(=) option, and then enter the discrepancy amount in the
field to the right.
- Click Find. If a transaction is found, determine
whether it is the transaction causing the discrepancy, and
correct it as needed.
Note: If the transaction was
previously reconciled but is now uncleared, correct the
status through the account register by clicking in the
checkmark column, and then clicking Record to save the
change. If the transaction has been marked cleared but has
not been reconciled, see the solutions above regarding how
to handle transactions cleared in a register.
- Run an account QuickReport:
Use this report to
determine if transactions have an incorrect cleared status.
- From the QuickBooks Lists menu, choose Chart of
Accounts.
- Select the account you want to reconcile.
- Click the Reports button at the bottom of the list,
and then choose QuickReport.
- Click Modify Report, and then click the Display tab.
- Select Clr in the Columns list.
- Click the Filters tab.
- In the Filter list, select Cleared.
- To the right of the Filter list, select either Yes (to
filter for cleared transactions) or No (to filter for
uncleared transactions), and then click OK to return to
the report.
- Look at recent transactions. If you see transactions
incorrectly cleared or uncleared, update them in the
account register by clicking in the checkmark column, and
then clicking Record to save the change. (See the
solutions above regarding how to handle transactions
cleared in a register.)
- Run an audit trail report:
This report can help
identify transactions that have been deleted, changed, or
added since the last reconciliation. A close examination of
this report can often help locate a problem, however, if the
audit trail feature has not been active, you will not be
able to see changes or deletions that occurred while the
audit trail was inactive.
- To activate the audit trail feature:
- From the QuickBooks Edit menu, choose Preferences.
- Click the Accounting icon on the left.
- Click the Company Preferences tab.
- Select the Use audit trail option, and then click
OK.
- To run the report, from the QuickBooks Reports menu,
choose Accountant & Taxes, and then choose Audit
Trail. You may need to adjust the report dates to see
modifications for the appropriate time period.
If the options listed above do not resolve
the issue and you suspect damage, use the QuickBooks Verify
Data and Rebuild Data utilities to detect and repair the
damage.
How Do I Handle A Bounced Check
From A Customer?
When a customer's check has "bounced" (returned to you for
insufficient funds), handle it in the following manner:
- First, create items for tracking bounced checks and
their associated charges if these items do not already exist
in your company data file (otherwise, skip to Step 2):
- From the QuickBooks Lists menu, choose Item List.
- Click the Item button and choose New.
- Select Other Charge from the Type drop-down list and
name this item Bad Check or similar.
- Leave 0.00 in the Amount or % field and select Non
from the Tax Code drop-down list.
- Select your bank account from the Account drop-down
list and then click Next.
- Repeat Steps 1.c and 1.d to create a second item named
Bad Check Charge or similar. This is for the service
charge you will assess customers for bounced checks when
you send them another invoice. (See Step 4.)
- Select an income account (such as Returned Check
Charges) from the Account drop-down list. If the account
does not exist, click the drop-down arrow and choose Add
New, and add the new income account.
- Click OK to save both items.
- Record your bank's charges for a bounced check:
- From the Banking menu, choose Use Register. If
prompted, select the appropriate bank account and click
OK.
- Create a new transaction, naming it NSF Fee or
similar.
- Enter the bank charge amount in the Payment field.
- In the Account field, enter the income account you
used in Step 1.g.
- Enter a memo if desired, and then click Record.
- Record a credit memo to reverse the original sale:
- From the Customers menu, choose Create Credit
Memo/Refunds.
- Enter all of the items from the original invoice or
sales receipt, including the sales representative and
sales tax if applicable.
- Enter the Bad Check line item from Step 1.c with a
negative amount. This amount should match the total of all
the items on the credit memo, creating a credit memo with
a zero total.
- Click Save & Close to record the credit memo.
- Choose Create Invoices from the Customers menu to send
the customer a new invoice, which should include all of the
items from the original invoice, plus a line item for Bad
Check Charge created in Step 1.f.
- If the original transaction was a statement charge,
print a new statement charge.
- If the original transaction was a sales receipt, you
still need to recreate an invoice to send to your
customer.
Tip: QuickBooks Pro and Premier versions have a "bounced
check" letter that you can send in addition to the new
invoice. This is one of the prewritten letters available
through the Write Letters feature in the QuickBooks Pro and
Premier versions. For more information, from the Help menu,
choose Help Index, and then type writing letters.
How Do I View My Bank
Reconciliation Reports?
To view your most recent bank reconciliation report:
- From the QuickBooks Reports menu, choose Banking, and
then choose Reconciliation Detail or Reconciliation Summary.
- Select the desired account from the drop-down list and
click Display.
To save a previous reconciliation report for later viewing,
memorize the report. |
| |
| QuickBooks Tips |
| |
| Cash Transactions
Entering Beginning Balances QuickBooks
users should enter balances for each bank account as of the
last bank statement date on or before the QuickBooks start
date. QuickBooks considers all checking, savings, and money
market accounts to be bank accounts. In addition, petty cash
accounts also should be set up as bank accounts. QuickBooks
users can set up bank accounts and enter their balances during
the “Opening Balances” portion of the “EasyStep Interview.”
QuickBooks users also can set up bank accounts by selecting
“Chart of Accounts” from the “Lists” menu. When setting up
bank accounts via the chart of accounts, users should select
“Bank” as the “Type” in the “New Account” window.
The opening balances for bank accounts should be set up as
of the last bank statement date on or before the QuickBooks
start date. Entering actual bank balances as of the statement
date rather than entering general ledger cash account balances
as of the QuickBooks start date allows QuickBooks users to
reconcile bank accounts more efficiently. Users also should
enter any cash receipts or disbursements occurring between the
last bank statement date and the QuickBooks start date, as
well as between the start date and the set-up date.
Using Subaccounts to Distinguish Check
Types Maintaining the proper check sequence in
QuickBooks can be difficult when both manual and computer
checks are drawn on the same bank account. To distinguish
manual checks from computer checks, consider creating a parent
cash account in QuickBooks with two subaccounts—one for manual
checks and another for computer checks. Beginning balances and
deposits could be recorded in the parent account, and the
parent account could be reconciled to the bank statement each
month. Checks could be written to the applicable subaccounts,
however (note that subaccounts will carry negative balances).
To avoid writing checks against the wrong subaccount, consider
using different colors for each subaccount by selecting “Chart
of Accounts” from the “Lists” menu, opening the applicable
checking account/subaccount register, and selecting “Change
Account Color” from the “Edit” menu.
Transferring Cash between
Accounts QuickBooks users may erroneously record
transfers of cash from one bank account to another as a
disbursement from one account and a deposit to the other
account. However, such transactions should be recorded as
transfers by selecting “Transfer Funds” from the “Banking”
menu. The “Transfer Funds between Accounts” window allows
users to select which bank accounts to transfer funds from and
to, as well as the amount to be transferred.
Voiding vs. Deleting Checks One of the
most common errors made by QuickBooks users is deleting a
check that should be voided. Users should not delete checks
that already have been printed. If a check that already has
been printed needs to be voided because it was issued in error
or with a mistake, QuickBooks users should:
- Select “Use Register” from the “Banking” menu.
(Alternatively, users can select “Chart of Accounts” from
the “Lists” menu and double-click on the applicable bank
account)
- Select the applicable bank account from the “Use
Register” window
- Select the check to be voided
- Select “Void Check” from the “Edit” menu
QuickBooks retains the check number and other information
about a voided check; however, no record of a deleted check is
maintained (unless the audit trail is turned on).
Consequently, deleting a check creates a gap in check numbers.
Even though QuickBooks allows users to delete checks that
already have been printed, such checks should be voided rather
than deleted. QuickBooks users may delete an incorrect check
only if the check has not yet been printed. QuickBooks does
not display voided or deleted checks when reconciling bank
accounts. Consequently, if a check listed as outstanding in a
prior month’s reconciliation is voided or deleted in a
subsequent month, QuickBooks does not list the check in the
reconciliation for the subsequent month.
QuickBooks users should not void a check that already has
been cleared during the bank reconciliation for a prior month.
If a QuickBooks user voids a check issued in a prior fiscal
period that already has been “closed,” QuickBooks changes the
cash and other affected general ledger account balances as of
the prior balance sheet date. Consequently, to restore
balances as of the prior balance sheet date, the practitioner
would need to record a journal entry as of the prior balance
sheet date to credit the cash account and debit the account to
which the check was charged originally. In addition, a journal
entry would need to be recorded in the fiscal period in which
the check actually was voided to debit cash and credit the
account to which the check was charged originally. If the
amount of the voided check is material, the user should
consider whether a prior-period adjustment should be
recorded.
Recording Bounced Checks When a
customer’s check is returned for insufficient funds, the
company must reduce its cash account in QuickBooks and record
a receivable from the customer for the amount of the bounced
check. Additionally, the company may be charged a fee by its
bank for processing the bad check, and charge its customer a
returned check fee. To record such transactions, do not delete
the invoice or deposit. Instead:
- Remove the bad check from the cash account, and
establish a receivable from the customer by creating an
entry in the bank register that lists NSF as the check
number, the customer’s name as the payee, and accounts
receivable as the account charged.
- Record bank charges by creating an entry in the check
register with NSF as the check number, the bank’s name as
the payee, and bank service charge as the account charged.
- Resubmit the original invoice to the customer with an
NSF letter and issue another invoice to the customer for any
fees the company charges for returned checks.
Correcting a Customer Deposit Customer
deposit errors in QuickBooks may be corrected in the screen on
which it was originally entered (i.e. “Received Payments,”
“Enter Cash Sales,” or “Create Invoices”), but there are
additional steps required for companies that use “other
undeposited funds” and have subsequently deposited those
amounts in the “Make Deposits” window.
To correct an error on a customer payment that has not been
deposited, follow these steps:
- Select the window of the original payment (“Receive
Payments,” “Enter Sales Receipts,” or “Create Invoices”)
from the “Customer” menu and locate the original
transaction.
- Edit the transaction and click on “Save and Close.” (If
the message “You need to delete this line item from the
deposit before you can edit its name or amount. Discard
changes and continue?” appears, proceed with the steps for
the “Make Deposits” window.
To correct an error on a customer payment previously
deposited in the “Make Deposits” window, follow these
steps:
- Select “Make Deposits” from the “Banking” menu and
locate the original transaction.
- Select the line containing the payment to be corrected
and select “Delete Line” from the “Edit” menu.
Alternatively, QuickBooks users can right-click and select
“Void Deposit” to void the entire deposit. (The transaction
still exists for companies that use “undeposited funds.”
QuickBooks changes only the status to undeposited so the
amount can be corrected and redeposited. Companies that post
directly into a bank account will actually delete the
transaction.)
- Click on “Save and Close.”
- Select the window of the original payment (“Receive
Payments,” “Enter Sales Receipts,” or “Create Invoices”)
from the “Customer” menu and locate the original
transaction.
- Edit the transaction and click on “Save and Close.”
- Select the payment for redeposit from the “Make
Deposits” window.
Petty Cash
Transactions
Setting up Petty Cash
Accounts QuickBooks users that maintain petty cash
should set up a petty cash account. A petty cash account can
be created when setting up bank accounts during the “Opening
Balances” portion of the “EasyStep Interview.” If the petty
cash account is new, the “Statement Ending Balance” field
should be left blank. Otherwise, the petty cash balance as of
the QuickBooks start date should be entered in the “Statement
Ending Balance” field. QuickBooks users also can create a
petty cash account by selecting “Chart of Accounts” from the
“Lists” menu. In that case, “Bank” should be selected as the
“Type” in the “New Account” window. The “Opening Balance”
field should be left blank if the petty cash account is new.
Otherwise, the petty cash balance as of the QuickBooks start
date should be entered in the “Opening Balance” field. Users
should enter any cash transactions occurring between the
QuickBooks start date and the set-up date. If the petty cash
account is new, its opening balance should be recorded via a
funds transfer, as discussed in the following paragraph.
Transferring Funds to Petty
Cash QuickBooks users should record a funds
transfer, when withdrawing funds from a bank account to set up
or replenish petty cash. The “Petty Cash” account should be
entered in the “Transfer Funds To” field. QuickBooks users
that replenish the petty cash account by writing a check
payable to “Cash” should set up “Cash” as an “Other Name” and
select “Petty Cash” as the account in the “Expenses” portion
of the check.
Recording Petty Cash
Disbursements QuickBooks users should record petty
cash disbursements by selecting “Chart of Accounts” from the
“Lists” menu and double-clicking on the “Petty Cash” account.
Users can enter each petty cash expense as an individual
payment in the petty cash account register or enter a single
transaction on a daily or weekly basis to record multiple
petty cash expenses. If a single transaction is entered for
multiple expenses, users should (a) enter the employee
receiving the petty cash in the “Payee” field, (b) enter the
total amount in the “Payment” field, and (c) click the
“Splits” button before entering the individual expense
accounts in the “Account” field. The “Splits” function allows
users to allocate the payment amount among multiple expense
accounts. Users may want to review the petty cash account
register to verify that they have not posted all petty cash
transactions to a single expense account (such as
“miscellaneous expense”).
Credit Card
Transactions
Setting up Credit Card
Accounts QuickBooks users should set up separate
accounts for each credit card used for business purchases.
Credit card accounts can be set up during the “Opening
Balances” portion of the “EasyStep Interview.” Users should
enter the ending balance on the last credit card statement
with an ending date on or before the QuickBooks start date.
QuickBooks users also can set up credit card accounts by
selecting “Chart of Accounts” from the “Lists” menu. In that
case, “Credit Card” should be selected as the “Type” in the
“New Account” window. The ending balance on the last credit
card statement with an ending date on or before the QuickBooks
start date should be entered in the “Opening Balance” field.
Subaccounts may be used to track purchases by multiple users
of a credit card. The user should reconcile and pay against
the “parent” account, however.
QuickBooks sets up a liability account in the chart of
accounts for each credit card account. QuickBooks users that
assign account numbers rather than account names to their
accounts should assign numbers used for current liabilities to
credit card liability accounts.
Recording Credit Card Purchases as They
Occur QuickBooks users should record each credit
card purchase as it occurs and reconcile the charges to the
credit card statement after it arrives. Individual credit card
purchases can be recorded when they occur by selecting “Enter
Credit Card Charges” from the “Banking” menu and entering the
applicable information. |
| |
| QuickBooks Updates |
| |
| QuickBooks Basic/Pro/Premier 2003
Release 7 Summary
The following list summarizes all changes or improvements
made in Release 7:
- Data File
QuickBooks now allows you
to rebuild a data file without first opening it.
- Do-It-Yourself Payroll
New add on
services available to Do it Yourself Payroll:
E-File & Pay Federal Service E-File & Pay
Federal and Quarterly State Service
- Financial Statement Reporter
The R7 update is required for customers using the new
Financial Statement Reporter product with QuickBooks.
- Help and Support
The Progress
Invoice link in the Help & Support Center now correctly
opens the appropriate Help topic.
The Payroll item interview Help button now correctly
opens the desired Help topic.
- Integrated Applications
Some
third-party vendors of integrated software applications
(applications that exchange data with QuickBooks) may
require their users to upgrade to R7 to take advantage of
additional data integration capabilities.
- Inventory
The Make Pending dialog
box is no longer displayed when a component of an assembly
falls below zero and you tab past the quantity to build
without entering a quantity.
QuickBooks now correctly prompts the customer to create
an invoice from an existing sales order, even if that sales
order has already been used to create multiple other
invoices.
- Merchant Account Service
QuickBooks
now displays a message when an error occurs while reading a
credit card. Previously, the swipe screen was closed when a
card with only Track 1 data was swiped.
The Ref./Check # field no longer overlaps the QuickBooks
Transaction ID field on printed credit card receipts.
QuickBooks now displays the message, "An error was
detected in the data read from the credit card" in every
screen in which an invalid card is swiped.
Credit Memo refunds now correctly process credit card
transactions when saved in QuickBooks.
Receive Payments Transactions are now correctly retrieved
and displayed. Previously, an error resulted when reviewing
40 or more of these transactions.
The Merchant Account Demos now fit better in screens with
larger fonts or lower resolution.
- Online Banking
QuickBooks no longer
opens extra register screens when using the Go To button in
the Match Transactions feature.
QuickBooks no longer displays an Invalid Page Fault in
QBCHAOS.DLL after a Bank ID change is completed.
- Payroll
There is no longer an
extended delay when opening the Send Payroll window.
QuickBooks can now more quickly open existing paychecks
in Multi-User Mode.
Customers who are already signed up for a Payroll service
are no longer prevented from setting up additional states
through the Payroll Setup system.
QuickBooks no longer fails to print W-3 forms that
contain long city names in the address.
QuickBooks no longer incorrectly changes the Used balance
for sick or vacation time when previous year transactions
are changed.
There is no longer an extra data sheet created when using
the Send Payroll Data to Excel feature with Microsoft Excel
XP.
- Printing
QuickBooks now supports
printing on Intuit pre-printed shipping labels.
- User Interface
In Product Messages
containing hyperlinks to an Internet Web page now show are
displayed with a lightning bolt.
The Non-Profit Edition of QuickBooks now allows a
customer to set up new accounts in the Easy Step
Interview.
QuickBooks now uses the correct account when the customer
right-clicks an account and selects Make Deposit.
Previously, the Parent Account was used when a parent
account was chosen for the account.
QuickBooks no longer displays the message when entering a
time activity but the class requirement option is not
selected: "Items not assigned classes. One or more items
have not been assigned a class. Save anyway or cancel and
return to the form?" |
| |
| Articles |
| |
The Hottest CEO in Tech Steve
Bennett has led Intuit through one of the industry's most
spectacular makeovers. Now he's aiming to conquer the last
untapped market in software. By Eric
Nee, Business 2.0 June 2003 Issue
He was about to meet his new boss -- and he didn't have
good news for him. A seven-year veteran of software maker
Intuit (INTU), Larry King Jr. had been running the company's
payroll outsourcing business for only a few months when Steve
Bennett was hired as CEO. The operation was a mess. It was
losing money. Its technology was outdated. Execution was
grindingly slow, and nothing was documented. The Intuit
management team had thrown tough problems at King before, but
he had no illusion that this would be an easy fix. Neither, he
decided, would the new chief. He encouraged Bennett to tour
the operation.
After his walk-through, Bennett sat down in King's office.
The Intuit vet braced himself. "Larry, let me tell you
something," Bennett began. "I've had 23 years of GE
experience, and I can tell you that your operation is a
classic, classic process-excellence need." King gazed at
Intuit's new leader. Bennett, then 46, looked like a casting
agent's idea of a modern CEO: tall, tanned, trim, blue-eyed.
His demeanor was authoritative but informal, almost folksy.
And King hadn't the faintest idea what the man was talking
about. "OK," he said. Then a pause. "What's process
excellence?"
The tale of Steve Bennett and Intuit is the story of one of
the most successful makeovers in recent corporate history. It
is also -- in its opening scenes, at least -- a comedy of
mutual incomprehension. Some of that, perhaps, was inevitable.
Bennett had spent his entire career at General Electric (GE)
and was steeped in its culture of results and its
near-religious faith in process excellence (basically
shorthand for the so-called Six Sigma quality-control
techniques used by GE and others). When he parachuted into the
top job at Intuit in January 2000, he landed in a $900 million
SiliconValley institution that still ran as haphazardly as a
startup. But the newcomer soon made himself understood. In
Intuit's troubled payroll business, for example, Bennett
dispatched a Six Sigma consultant who helped King double
revenues in two years. And during the next 40 months, he
remade an indecisive, complacent organization into one of the
most spectacular performers in the industry.
Consider the numbers. Since August 2000, the beginning of
Bennett's first full fiscal year as CEO, Intuit's revenues
have expanded annually at double-digit rates. Operating
profits have jumped between 40 and 50 percent each year, and
operating margins widened steadily from 14.6 to 22.4 percent.
That would be robust performance in a growing market. In the
midst of the worst tech crash in living memory, it's
positively stunning. The stock market certainly seems to think
so: As of early May, Intuit had become the eighth-largest
software company on the planet in terms of market
capitalization, ahead of far-higher-profile companies such as
BEA Systems (BEAS), PeopleSoft (PSFT), and Siebel Systems
(SEBL).
While Bennett is barely known outside Intuit's Mountain
View, Calif., headquarters, that is beginning to change.
"You'd have to call Steve Bennett one of the top tech managers
out there," says David Farina, an analyst with William Blair
& Co. (which has done no recent investment banking
business with Intuit). "Look at the numbers. They're pretty
incredible." William Sahlman, professor of entrepreneurial
management at Harvard Business School and coauthor of an HBS
case study on Intuit, compares Bennett to eBay's (EBAY) Meg
Whitman. And then there's Scott Cook, the 50-year-old tech
pioneer who co-founded Intuit 20 years ago and is now chairman
of its executive committee. He has more at stake in his
company's continued prosperity than anyone, and he fairly
gloats when describing the man he hired. "He may well be the
best new CEO in America," he says.
For all its problems, the company Bennett inherited in
January 2000 came with two important strengths: a fiercely
loyal customer base and three of the most powerful brands in
retail software: Quicken, the personal finance program that is
all but synonymous with Intuit, has 15 million active users
and owns 73 percent of its market. TurboTax holds 81 percent
of its market. And QuickBooks, the accounting program for
small businesses, has an 84 percent share.
All are legacies of Cook, who insisted from the start in
1983 that Intuit's products be designed for nontechies. A
graduate of the marketing department of Procter & Gamble
(PG), Cook made a fetish of usability: In an episode that has
risen to the status of Intuit creation myth, Cook tested the
original Quicken on a bevy of Junior Leaguers, because they
were the least tech-savvy people he could think of. Intuit
managers followed customers home from stores to watch them
install Quicken. They cold-called them from product
registration cards to ask for suggestions on improving the
software. As they drove to work, they listened to tapes of
customer service calls.
Cook insisted that his programmers incorporate what they
learned into future versions. He called it "customer-driven
innovation," and it made Intuit software dominant wherever it
competed. Customer-driven innovation is why TurboTax leads
users through a nonthreatening "interview" rather than forcing
them to confront tax forms directly. And it's why QuickBooks's
user interface resembles a checkbook rather than traditional
double-entry bookkeeping -- because most small-business owners
are not trained accountants. "Eleven years later some
traditional accounting software companies still tell me we're
doing it wrong," Cook laughs.
By the late 1990s, however, customer-driven innovation was
no longer enough. Listening obsessively to customers, after
all, doesn't necessarily alert you to new markets. Internally,
the customer-friendly culture had congealed into a feel-good,
consensus-hobbled management style that shied away from hard
choices. Employees of the time describe the atmosphere as
"nurturing." (In fact, one of Bennett's CEO predecessors, the
popular Bill Campbell, was nicknamed Coach.) But there were
few incentives to excel. The compensation system, more
appropriate to a government bureaucracy than a tech company,
made little distinction between top performers and deadwood,
awarding almost everyone the same annual raise. "We were slow
and indecisive," Cook recalls. "We weren't tough." In late
1999, when Campbell's replacement washed out, Cook went
looking for a new CEO.
Bennett was not an obvious candidate. While Jack Welch's GE
is legendary for exporting CEO-caliber execs -- Home Depot's
(HD) Robert Nardelli and 3M's Jim McNerney, to name just two
-- Bennett had zero software experience. "I'm not a technology
guy," he says without apology. Then there was the culture
thing: In 23 years at GE, he had fully internalized its
relentless drive, its emphasis on accountability, and the
let's-measure-everything philosophy of Six Sigma; Cook knew
that Bennett would hit laid-back Intuit like a locomotive. To
complicate matters, Bennett held the choice job of executive
VP at GE Capital, and just days before Cook's headhunter
called, he had gotten the biggest raise of his career.
Still, Bennett found he couldn't turn Intuit down. He liked
the strength of the company's brands, which fit with the
Welchian principle of competing only in businesses where you
can be No. 1 or 2. He also saw the offer as a chance to prove
to himself that he could thrive outside the GE hothouse. "I
wanted to see if I was more than a one-trick pony," he says.
For his part, Cook was unconcerned by Bennett's slender tech
experience and the Kulturkampf he would undoubtedly set off.
In fact, he saw those as advantages. He wanted someone to
shake things up.
That's exactly what he got. In his first six weeks on the
job, Bennett visited dozens of locations, addressed the bulk
of Intuit's 5,000 or so employees, and had one-on-one
conversations with, by his reckoning, at least 100 of the
company's top executives. The exchanges were often
eye-opening. In one early meeting, Bennett reviewed budget
proposals from a parade of department heads. The first told
him that the department had spent $15 million last year and
needed $17 million next year. The head went on to describe how
the additional $2 million would be spent. "So I asked what
they spent the $15 million on, and the person didn't know,"
Bennett says incredulously. "I thought, this executive has a
problem. But every one of them gave me the same answer. They
didn't know." Zero-based budgeting, a bedrock practice at GE,
was apparently as foreign to Intuit's culture as Samoan slap
dances.
Two months into his tenure, Bennett used his first public
appearance, a Wall Street analysts' meeting, to alert Intuit
employees that things were going to be different. "I stood up
and said, 'With our brands and customer base, we should be
doing much, much better,'" he recalls. "'We're
underperforming.'" The reaction? "They thought I was smoking
dope," he says. "The mind-set was, 'Let's budget 10 percent,
grow 11 percent, and aren't we great?' We should have been
growing 20 or 30 percent."
Bennett's first task was to jolt his new colleagues into
expanding their definition of the possible, to engender what
he calls "bullet-train thinking." (The phrase comes from the
creative problem-solving that arose when Japanese engineers
were challenged to build a train that could go from Tokyo to
Osaka in three hours instead of six.) A few weeks later, at a
meeting of the company's top 200 executives, Bennett got his
chance. He presented a document titled "Steve's Dream for
Intuit," a set of highly ambitious growth targets for
revenues, profits, stock price, and other yardsticks. Rich
Walker, head of Intuit's accountant services group, was one of
those present. "My first reaction was 'Oh, my God, how are we
going to do that?'" he recalls. "The next reaction was 'Oh, my
God, wouldn't that be great?'"
Before the dream could become reality, of course, a lot of
cozy Intuit practices had to become history. Within weeks of
his unnerving meeting with the department heads, Bennett had
trashed Intuit's old budget system; today execs with P&L
responsibility must justify every dollar they plan to spend.
He replaced the old system of guaranteed raises with a
pay-for-performance model. He laid off 60 employees at
money-losing Quicken.com and sold weak units. He also
increased the number of execs who report directly to him from
8 to 20, seeing that as a way to drive change directly and,
incidentally, keep himself from micromanaging. Any CEO with 20
direct reports, after all, has no choice but to delegate. "I
work maybe 50 or 60 hours a week," he says. "There are other
things I want to do with my life." (Like golf; a 3.3-handicap
player, Bennett got in 102 rounds last year.)
Bennett -- along with a trusted handful of GE executives he
lured to Intuit -- also began to push process excellence (PE),
a commitment to customer satisfaction built on Six Sigma
surveying and quality-control techniques. Six Sigma is rare at
software companies and it led at first to much head-scratching
at meetings with Bennett's lieutenants. Tom Allanson, hired
from GE to run Intuit's consumer tax group, spent three months
of energetic, acronym-laden whiteboarding with his staff
before they worked up the nerve to tell him they had no idea
what he was talking about. Allanson dumped the jargon and
started over from scratch.
With some of the firm's software engineers, bemusement
gradually turned to resentment. A key issue is that coders
must submit their work weekly to PE review, a violation of the
princely status most Silicon Valley engineers are accustomed
to. Some grumble that reviews are a wasteful bureaucratic
burden; one, who wished to remain anonymous, recently claimed
that colleagues have talked of resigning once the economy
picks up. "It stopped being fun working here," this programmer
said.
Most other Intuit employees have come around, however, as
they've begun to see the payoff of Bennett's disciplined
approach. One of the most fervent converts is Larry King. Now
fully clued in to the meaning of process excellence, King saw
Six Sigma help make his payroll division one of Intuit's
stars. When Bennett came onboard, it took King's unit 45 days
to get a new customer up and running. Using Six Sigma to
analyze the operation, King mapped out every step of his
unit's order process, filling dozens of yellow stickies that
he later pasted on a conference room wall. He and his team
then tossed every one that wasn't life-or-death essential on
the floor. Two-thirds of the stickies ended up on the pile,
and King had a clear vision of how to streamline order
fulfillment. Now, Intuit payroll customers wait just 7 days
for service. "This has changed me as a manager for the rest of
my life," King says.
Similar cubicle conversions popped up all across the
company. Intuit's accountant services group used Six Sigma
customer survey techniques to price new products. "Before,"
Walker says, "we'd have sat in a room and come up with
informed guesses." The new process, he says, yielded
"uncannily" precise predictions of how variously priced
packages would sell.
Many around Intuit also found themselves won over by
Bennett's direct managerial style. Dan Gilbert, chairman of
former subsidiary Quicken Loans, recalls being frustrated by
the old regime's continual groping for a strategy. "There was
a lot of vagueness at Intuit," he says. Gilbert eventually
bought the business back from the company, but not before
coming to appreciate Bennett's leadership. "No bullshit, right
to the point," he says. "Frankly, Steve Bennett was our kind
of guy."
Firing up the troops is one thing, but Intuit desperately
needed to start growing again, and Bennett had a plan. "When
Steve came in, he said the QuickBooks group was a slow-growing
unit and a giant opportunity, and we should be growing much
faster," Cook recalls. The evidence, as it happened, had been
staring Intuit in its customer-focused face: The standard
version of QuickBooks is designed for companies with fewer
than 20 employees, yet 5 to 10 percent of its most loyal users
were larger -- some had as many as 200 employees. In fact,
more of them used QuickBooks than brands of software intended
for companies their size.
As Bennett looked closer, he realized there was room for
more than just an expanded version of QuickBooks. Many small
businesses still run with pencil and paper, and of those that
embrace PCs, few have moved beyond spreadsheets or simple
accounting programs. Intuit estimates that North American
small businesses, which it defines as companies with fewer
than 250 employees, will buy $7 billion in business software
and $11 billion in related services this year. Analysts expect
double-digit growth for years to come. In an era when
corporate IT budgets have been squeezed dry, this was a rare
thing: an expanding market for business software.
Even so, by mid-2001, Intuit had made no move to capitalize
on it. The executives in the small-business group dithered
over the business model, organizational design, partnerships,
and so on -- even as Microsoft (MSFT), Oracle (ORCL), and SAP
(SAP) announced that they were entering the market. Losing
patience, Bennett went looking for a replacement to run the
group. He soon found one in a former colleague, 20-year GE
veteran Lorrie Norrington, whom he lured away with the help of
a $750,000 signing bonus and a $5 million interest-free
relocation loan.
In her new job, Norrington took all of a month to announce,
essentially, that Intuit intended to become the SAP or Oracle
of small business. The company would offer software and
services for a wide variety of enterprises, from the smallest
shops to those with a couple hundred employees. Intuit would
help not just with accounting but also with payroll and
benefits, keeping track of customers, and managing computer
systems. It would also customize its software for specific
kinds of businesses, like accountancies or construction firms.
The initiative, she explained, would be called "Right for My
Business." Norrington first turned her attention to
QuickBooks. With nearly 3 million users, the accounting
program was the obvious beachhead for a push deeper into the
small-business market. Bennett had already ordered up a new
version -- QuickBooks Enterprise Solutions -- for businesses
with more than 20 employees. Within 18 months, Norrington
added 13 more "flavors," and by the end of this year,
QuickBooks will have sliced the accounting market 25 ways,
with special editions for the smallest small companies and
larger small companies, and specific versions for retailers,
distributors, contractors, and nonprofits.
In another example of bullet-train thought, Intuit agreed
to open QuickBooks's source code to independent software
developers. The developers write highly specialized
applications for specific businesses; with an open interface,
they can easily tie their programs into QuickBooks and other
Intuit software, creating a kind of small-business
enterprise-resource-planning package. To recruit developers,
Bennett, Norrington, and Cook have been stumping conferences,
including Intuit's first-ever QuickBooks developers
conference, held in November near San Francisco. One of the
roughly 6,500 companies actively developing applications is
Clip Software in Ijamsville, Md. Some 8,000 landscape
maintenance outfits use Clip to streamline tasks such as
scheduling fertilizing and making estimates on new jobs. CEO
Dave Tucker explains his partnership with Intuit this way: "We
don't want to write general ledger or payroll applications.
Intuit can do that."
To serve the largest and richest companies in their target
audience, Bennett and Norrington have begun acquiring small
companies that make fully integrated suites of business
applications for specific industries. The packages, which
Intuit sells for as much as $100,000 per customer, now cover
property management, the public sector, construction, and
distribution, and there are plans to buy as many as six more
in different industries.
These acquired companies get the full PE treatment. "The
day we started with Intuit, our process-excellence person
started with us," says Michael Potts, the former CEO of the
Flagship Group, a Denver software firm Intuit bought in June
2002. Like most small software companies, Flagship had never
given a thought to business process. Now Potts can't imagine
life without PE. For example, he had assumed that when
Flagship lost bids, it was because the customer preferred the
winner's technology. But the new PE czar ran a survey of lost
clients and found that the decisive factor was actually price.
"If you'd asked me a year ago, I'd have said I knew all this,"
Potts says with a grin. "But I didn't really."
Other software companies, of course, have no intention of
allowing Intuit to become the SAP or Oracle of small business.
SAP and Oracle themselves, as it happens, have announced plans
to offer scaled-down versions of their software for small
businesses. Microsoft, however, is the most formidable
competitor. Although QuickBooks drove Microsoft accounting
programs like Profit (1993) and Finance Manager (2001) off the
field, the world's largest software company is nothing if not
relentless. Gates & Co.'s $1.1 billion acquisition in 2001
of Great Plains Software, which caters to businesses with up
to 1,000 employees, shows just how serious Microsoft is. At
the moment, its sweet spot is among clients somewhat larger
than Intuit's. But the two are converging on clients in the
middle, and when they do, Microsoft will be fierce
competition. On the other hand, Bennett has turned Intuit
into a serious competitor itself. The company is now much more
agile, driven by 6,800 (mostly sincere) converts to process
excellence. But the decisive weapons in any competition with
Microsoft may well be the ones Bennett inherited.
To understand why, consider Lone Star Doughnuts, a Houston
company that runs seven Krispy Kreme shops and distributes to
350 hospitals, grocery stores, and other outlets. As it
expanded, it outgrew QuickBooks a couple of years ago and went
looking for something new.
At that time, says Jason Gordon, Lone Star's CFO, Great
Plains software seemed his best choice, since it easily
handled the number crunching. But it cost $85,000, required
consultants to install, and would force Lone Star to retrain
the six people who would have to use it. Then, just before
signing the purchase order, Gordon heard that Intuit was about
to introduce a heavier-duty version of QuickBooks known as
Enterprise Solutions. As soon as it was ready, he bought it.
"I just plugged it in and was ready to go." No consultants, no
retraining. And it cost just $3,500.
In this arena, Intuit's brands remain the ones to beat. The
products' reputation for friendliness has apparently survived
the flap caused by a copy protection feature introduced on
TurboTax this year. "Customer-driven innovation is our heart,
and strategic and operational rigor is our brain," Bennett
says. "This company once had lots of heart but no brain. By
combining the two, we can perform at a much higher level." And
now no one at Intuit wonders what he means. |
| | |
|
|
|