Working with taxable and non-taxable items and customers in QuickBooks sometimes just freaks people out and causes them to over think the entire situation. I’m frequently asked how to do this by people who are setting up our AIA billing program – here’s a question that I received recently.
I am getting ready to set the AIA billing program {Construction Application for Payment Solution} up tomorrow and just have a few questions.
Should the income items each be posted to an income general ledger account? Or will I use the subtotal line to point to an income account? If I have to post each income item to an income account – I will have to do 2 sets of them, one for wholesale (no tax) and one for retail (taxable) and I would like to avoid this if possible. I guess though we will have to post them to an income account…..thoughts?
Should we use the group items to setup our labor and materials for the schedule of values? For example, when we bill the customer- we only want DEMOLITION to show up, but for our purposes we have the DEMOLITION broken into labor and material. It seems like this would be a good place to use group items?
Each of your QuickBooks Items/Cost Codes should be set up and linked to BOTH and Income and an Expense/Cost of Goods Sold Account otherwise you’ll never get any decent job costing reports.
Subtotal Items do not link to either an Income or an Expense Account – they simply add up the numbers above it and display the amount on the Estimate and Progress Invoices that you create.
Unless you want to track Wholesale and Retail Income individually on your Profit & Loss Report, there is no need to create two sets of Items. QuickBooks can handle both taxable and non-taxable customers and sales using the same item list. You’ll just want to make sure that you have two Sales Tax Items – one that actually charges the Sales Tax Rate and one that has a 0% rate for Non-taxable sales.
Below is a YouTube video that demonstrates the procedure and shows you what your Sales Tax Liability Report will look like if you do it correctly.
As for using group items to track labor and materials for a specific cost code, there are a couple of different options that you could use, depending upon the amount of detail that you want to track. But group items are definitely the way to go if you want to job cost more information than you want the customer to see.
I hope you’ve found this article to be informative, if so please take a moment to leave a comment or share it with others on your favorite social media network using the buttons below.
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 |
| 10000-19999 | Assets
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.
|
| 20000-29999 | Liabilities
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. |
| 30000-39999 | Equity/Capital
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. |
| 70000-79999 | Other Income
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. |
| 80000-89999 | Other Expense
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. |
Using Subaccounts
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:
63300 Insurance
63310 General Liability
63320 Disability
63330 Health
63340 Life









