Using Account Numbers in Your QuickBooks Chart of Accounts
The QuickBooks Chart of Accounts is the framework used to categorize the information and transactions used to create reports. By using a chart of accounts and creating reports, you will always know the current state of your business.
The chart of accounts is made up of five types of accounts common to all businesses- the income and expense accounts used by the Profit and Loss Statement, and the asset, liability, and equity accounts used by the Balance Sheet. Each time you enter a transaction, QuickBooks will prompt you to categorize it into one of these five types of accounts.
|Questions & Answers:
Why is the chart of accounts important?
The Chart of Accounts is the backbone of your accounting system. It is the complete list of all the accounts you need to categorize your business activities. Based on the information you provide in this interview, QuickBooks will create a recommended Chart of Accounts that is designed to track your business and help you to make good financial decisions for your company.
As your business grows, you can tailor your Chart of Accounts to meet your business needs.
Understanding your chart of accounts.
The chart of accounts is the backbone of your accounting system. That’s why it’s so important to understand how it works. Think of a chart of accounts as a file cabinet, with a file for each type of accounting information you want to track. For example, if you need to know how much money you spend on postage, you’ll set up a file (an account in the chart of accounts) for Postage Expense.
Although you aren’t required to use account numbers in your chart of accounts in QuickBooks, your accountant may recommend that you do so.
What are standard chart of accounts number ranges?
You’ll find that many accounting professionals will have their “own” numbering theory, however, below is a list of Standard chart of accounts number ranges that we feel is best suited to the construction indusry – you may wish to print this article for future reference.
|Account #||Type, Description, and Examples
Assets are things your company owns. They’re usually divided into two groups-current assets and fixed assets.
Current assets are generally numbered from 10000- 14999. These are assets that you can easily turn into cash, such as checking accounts, savings accounts, money market and CD accounts, accounts receivable, and inventory. So you might want to use account number 10000 for your company checking account because a checking account is a current asset.
Fixed assets are usually numbered from 15000 – 19990. These are items with a minimum cost (for example, $500.00 or more) that you would have to sell to generate cash. Automobiles, equipment, and land are examples of fixed assets. For example, suppose last year your company bought a new computer system for $1,100. Since the cost of the system was more than $500, the purchase was entered to an asset account rather than to an expense account. Consult your accountant or tax preparer to determine the actual minimum cost you should use to determine fixed assets.
Liabilities are funds your company owes. For example, say your company borrowed $20,000 from the bank. When the $20,000 loan was deposited to the checking account, the deposit was entered in the liability account Bank Loans, not an income account. Liabilities are usually broken down into two groups.
Current Liabilities are generally numbered 20000-24999. These are liabilities that will be paid off within a year, this would include accounts payable, credit cards, payroll taxes, etc.
Long-term Liabilities are generally numbered 27000-29999. These are liabilities that will take more than a year to pay off, this would include a truck loan, equipment loan, a loan to buy a piece of property, etc.
Your capital account structure depends on whether your company is organized as a sole proprietorship, partnership, or corporation.
If your company is a sole proprietorship, you need an Equity account and an Owner’s Drawing account. Use the Equity account to keep track of the total amount of money you’ve invested since starting the business. Use the Owner’s Drawing account for money you take out of the business for personal use, such as checks to the grocery store, dry cleaners, ATM transactions, your salary, and any money that gets deposited into your personal accounts. It’s important to keep in mind that the owner of a sole proprietorship doesn’t get a regular “employee” paycheck with money deducted for payroll taxes. Instead you pay quarterly estimated taxes, which you should always allocate to the Owner’s Drawing account.
If your company is a partnership or LLP (Limited Liability Partnership), you need to set up Equity and Drawing accounts for each partner.
If your company is an “S or C corporation” or an “LLC corporation,” it should have a Common Stock account and sometimes a Preferred Stock account. Common stock and preferred stock represent the total sum of stock the company has issued. An LLC might have Member stock if there is more than one person who owns stock.
|40000-49999||Income or Revenue
“Income” or “revenue” is the income you get from your normal day-to-day business tasks, such as professional fees, income for services rendered, reimbursable expenses, or products you sell.
|50000-59999||Cost of Goods Sold/Job or Project Costs/Direct Expenses
Job or Project Costs, or Cost of Goods Sold (as it is called in QuickBooks), are all the costs associated with your line of business.
For example, if you’re a home builder, the job costs are whatever it costs you to build a home, including direct labor, materials, subcontractors, dump fees, and equipment rental.
If you sell products, this includes cost of inventory, raw materials, freight charges, and any labor for building the finished goods. Other examples of project costs include reimbursable expenses such as overnight mail, court costs (for an attorney’s office), blue prints (for an architect), and purchases made on behalf of the customer such as furnishings bought by an interior designer or auto parts bought by a mechanic.
If you design homes, the job costs include all your costs of designing a home, such as design labor, drafting materials, supplies, and engineering costs. If you do both designing and building, you’ll have both sets of costs.
For professional service businesses, project costs are the costs that you incur in order to complete a project. Project costs are also referred to as direct costs. For example, if you hire an outside consultant and his or her time is billable to the customer, that is a direct or project cost. Other examples of project costs are reimbursable expenses such as overnight mail, messenger service, court costs (for an attorney’s office), blue prints (for an architect or engineer), and purchases made on the behalf of a customer, such as furnishings bought by an interior designer or computer parts bought by a computer technician.
Cost of Goods Sold also includes the cost of raw materials, freight charges for getting raw material to a warehouse, labor for building the finished goods, and freight charges for getting the goods to the customer. For manufacturing businesses, the Cost of Goods Sold includes the costs incurred in producing or building a product. For a wholesale business, Cost of Goods Sold are the costs of the goods you purchase for resale. for a distributor business, Cost of Goods Sold are the costs to purchase and distribute goods to the customer.
|60000-69999||Expenses or Overhead Costs
Overhead Costs, or Expenses, are fixed costs you have even if you run out of work. Examples include rent, telephone, insurance, and utilities.
Other Income is income you earn outside the normal way you do business, including interest income, gain on the sale of an asset, insurance settlement, a stock sale, or rents from buildings you own.
Other Expense is an expense that’s outside of your normal business, such as a loss on the sale of an asset or stockbroker fees.
If you intend to use subaccounts (and we recommend that you do), when you set up your main/parent accounts, be sure to leave enough “open numbers” to be able to fit in all the subaccounts that you’ll need. It’s a good idea to plan to increment subaccount numbers by 10 and to try to number your accounts so that the names will end up alphabetically, just to make reading easier. For example you might have a main account for Insurance, and want to track subaccounts for General Liability, Health, Life & Disability; you would set it up as follows:
63310 General Liability
5 Responses to Using Account Numbers in Your QuickBooks Chart of Accounts
Leave a Reply
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks 2012 Announced
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- Frequently Asked Questions - California Prevailing Wage
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- QuickBooks Tip - Child Support Garnishments
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks 2011 - New Balance Sheet by Class Report - Part 1
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
Webinar - QuickBooks Job Costing from A-Z
Having trouble getting job costing reports out of QuickBooks? Or maybe you are wondering if the information you see is accurate. Setup is KEY! Join us for an intensive 1 1/2 hour webinar covering job costing techniques and procedures on Wednesday March 26, 2014 from 1-2:30 p.m. EST. Sign up here.