Tips for QuickBooks and Chart of Accounts

Many companies fail to set up their charts of accounts correctly in QuickBooks. Over the years Jackson Accountants have seen charts of accountants that look like a collage of accounts in helter skelter format without any logical order, containing duplicate if not triplicate accounts, inconsistent protocols, and even inappropriate, if not undecipherable, names.

Jackson Accountant - Quickbooks

At tax time, when their Jackson Accountant receives either a backup or Accountants copy of the file like OR reports that have been created from the file, it becomes an even bigger mess. The trial balance that must be created by the tax preparer requires countless hours of reclassifications and groupings to mesh and coordinate the amounts within the file to the classifications required on tax returns and financial statements. Business owners then bear the costs of needless and expensive clean ups, often tacking on an additional $500 to $1000 per year to their annual accounting bills.

There is no excuse for not having a QuickBooks chart of accounts set up in a format compatible with what is reported on a company's tax return as well as their financial statement. Once set up, a simple click in QuickBooks prints a readable and well-organized financial report for internal management, bankers, other creditors, bonding companies, shareholders, etc. In addition, with some mapping to an Intuit tax software program, the client's trial balance amounts can be exported to the company's tax return by the tax preparer with another click of the mouse.

In order to minimize the costs associated with having their tax returns prepared, as well as interim and year-end financial reports, businesses owners would be well advised by Jackson Accountant to adopt account names, groupings, and an overall format required by their tax returns. A good general ledger can accommodate the requirements of both internal and external financial reporting, since subaccounts would provide any necessary detail required by management and interested outside parties - while a simple click of the Modify Report button in QuickBooks re-arranges the expense accounts in alphabetical order - often the desired presentation for banks.

Many Certified Public Accountants (CPA's) and Certified Public Bookkeepers (CPB) prefer to have their clients set up the chart of accounts using account numbers. Many clients do not want to use numbers because they find them cumbersome.

A compromise by Jackson Accountant is to turn on the "Use account numbers" preference (Edit menu -> Preferences -> Accounting -> Company Preferences tab -> Use Account Numbers) when setting up the chart of accounts. Then, turn off the preference for the clients daily use. When the preference is off, the numbers are not eliminated, simply hidden from view. At the end of the year, the CPA can turn the preference back on and add numbers to any accounts created by the client during the year.

When the "Use account numbers" and "Reports-Show accounts by Name only" preferences (Edit menu -> Preferences -> Reports & Graphs -> Company Preferences tab -> Reports - Show Accounts by: Name Only option) are activated, numbers appear next to the name in QuickBooks financial reports.

Many users prefer not to have numbers display on financial reports. If, instead, the preference "Reports-Show accounts by Description only" is activated, the account description entered when the account was setup is used. Therefore, when using account numbers, enter an account description. (This description can be identical to the account name.)

QuickBooks accounting article provided by Nancy Smyth

  

Jackson Accountant

 

 


More articlesIncome Taxes - 6 Tax Tips For Filing - Jackson Accountant
Jackson Accountant Tax Tips Before the March 1st RRSP deadline, tax payers are asking themselves important tax related questions; Should I put my money in a Tax Free Savings Account (TFSA) or in ...
More articlesJackson Accountant - Big Changes to CPA Exam in 2011
Big changes are coming to the Certified Professional Accountant Exam next year! Are you ready for the new exam? It's important to keep up to date on the latest changes on the exam and what topics ...
More articlesJackson Accountant - Understanding Basic Accounting Guidelines
Jackson Accountant I am going to confine myself with the various Debits & Credits which are published on the Balance Sheet. The reader is most probably going to ask "What about the Income Sta...

News Headlines

Accountant uses green fingers to reach ...
Published:Mon, 05 Sep 2011 01:12:47 -0700
AN accountant who traded a calculator for a lawnmower has made it to the finals of a prestigious gardening competition.......

Microsoft accountant facing prison for ...
Published:Mon, 05 Sep 2011 20:18:45 -0700
An accountant who admitted to stealing from Microsoft Corp. to teach his bosses a lesson will likely be sentenced to prison Tuesday.......

Accountant on bail for fraud...
Published:Tue, 06 Sep 2011 05:35:48 -0700
TOOWOOMBA accountant William John Dingle has been charged with fraud to the value of more than $50,000.......

Burbank accountant held in fraud case...
Published:Mon, 05 Sep 2011 15:31:58 -0700
Kinde Durkee, who served as treasurer for many Democratic Party campaigns, is charged with one count of mail fraud in connection with work she did on behalf of a member of the sta......

Nigeria: Councils Chief Accountant Dies...
Published:Mon, 05 Sep 2011 06:36:28 -0700
THE Chief Accountant of Kwali Area Council, Mr. Micah Gyere Samuel, last Tuesday afternoon died mysteriously inside a deep well at Tika village in the council.......

Accountant Turned Massage Therapist Cel...
Published:Tue, 06 Sep 2011 07:00:00 -0700
With a name like Hippy Chick Massage, owner and operator Sharon Wattam-Nelson wants to clearly communicate her state of mind and business philosophy. Â......