Customizing QuickBooks Online for Your Industry

| February 6, 2018 | By
Customizing QuickBooks Online for Your Industry
In today’s digital economy, the ability to run your business from the palm of your hand is becoming a necessity. This may include posting to your business social media accounts, accessing your marketing tools and customer relationship management platform. Being able to access your books from any device and any location should also rank high on the list.

QuickBooks also you to do just that with its Online platform which leverages cloud technology to meet your small business accounting needs.

However, the software is not without its challenges. Some functions of QBO beg questions from users who are used to a more traditional QuickBooks interface. Nonetheless, QBO still allows them to access essential functionality, including:

 

  1. Entering payroll items
  2. Tracking expenses
  3. Generating reports
  4. Connecting accounts

 

Before you begin navigating the software for your small business accounting needs, you should ensure that your Chart of Accounts (COA) is properly set up and customized for the industry in which you operate.

What is the Chart of Accounts?

The Chart of Accounts is one of the first things you will need to create after you set up a company file in your online bookkeeping system. Having a Chart of Accounts gives you a place to record the payments you receive. Without it, sending invoices and receiving payment can get confusing. Completing these steps is imperative especially around tax time, when running reports, or forecasting cash flow.

Here are a few best practices for small businesses who need to better organize their COA:

 

  1. Make a list of zero balance accounts. These are often non-essential or unnecessary.
  2. Small balance accounts may be duplicates.
  3. Audit account names for accuracy and naming conventions.
  4. Customize your chart of accounts settings.
  5. Decide if you want to use account numbers to prioritize account order.
  6. Link parent and sub-accounts.

 

Also, remember the purpose of a COA is to track and organize four categories:

 

  1. Assets (and Net Assets)
  2. Liabilities
  3. Expenses
  4. Revenue

 

Customizing the Chart of Accounts

Below are several industry-specific ways to set up a COA. The small business industry sectors we will examine are:

 

  1. Nonprofits
  2. Restaurants
  3. Real estate
  4. Construction and other contractors, like landscapers

 

QBO Chart of Accounts for Nonprofits

If you operate a religious, charitable, educational organization or other type of 501(c)(3) then you are already aware that you have to meticulously track money in and money out. Maintaining audits that show nonprofits reuse a certain percentage of revenue to fund business operations is imperative to the overall mission of any nonprofit organization.

Because of this, it’s important that nonprofits are organized in how they keep accounting records. A key component of that is having a clean and properly maintained COA.

When it comes to nonprofits, QBO can offer nonprofits assistance with the following:

  1. Organizing your chart of accounts
  2. Tracking funding sources
  3. Tracking services or programs offered

 

Functional Expenses

Under United States Generally Accepted Accounting Practices, the Financial Accounting Standards Board (FASB) mandates that nonprofit organizations divide financial information among specific categories, or funds and produce standardized reports on them.

These requirements showcase the fact that there are restrictions on the way nonprofits can use resources. Functional expenses include spending on any of the following operations across the following three categories:

 

  1. Programs
  2. Fundraising
  3. Administration

 

Having an accurate Statement of Functional Expenses is important to the IRS and taxing authorities, as well as for fundraising purposes and accountability to the Board of Directors.

Tracking Nonprofit Expenses in QBO

Before you begin tracking expenses, be sure to turn on “classes” which is how QuickBooks categorizes transactions.

Next, click the + sign, then Expenditure.

 

null

Source: Intuit.com

You can then assign multiple lines to an expenditure item as shown in the below example.

null

Source: Intuit.com

Nonprofit accounting staff can also select these categories and pull up QBO’s standard profit and loss report to collect all the information needed for a Statement of Functional Expenses.

QBO Chart of Accounts for Restaurants

The restaurant industry also has some unique needs when it comes to financial reporting and COA.

As for a chart of accounts, every restaurant owner does things a little differently. But, it’s imperative that restaurant owners set up some way of tracking the following accounts:

Revenues

Food Sales: Small business owners in the restaurant industry should use this account to track gross revenue from food sales.

Beverage Sales: Restaurateurs use this account to track gross revenue from beverage sales.

Expenses

When it comes to expenses, it is advantageous for QBO users to set up several main expense accounts with subcategories as detailed below.

General:

Cost Associated with Beverage Sales: This account tracks expense revenue for beverage sales.

Cost Associated with Food Sales: This account tracks the expense revenue for food sales.

Discounts and Comps: This account records meal discounts or comps applied.

Operating:

By definition, operating expenses are those that occur as part of the normal day-to-day running of the business. These expenses include things like cash underages and overages, bad debt, credit card chargebacks and fees, equipment leases and expenses, marketing spend, print services for menus, legal and tax preparation fees.

Labor:

This includes management and regular wages, employee benefits expenses, employee meal plan expenses and health insurance.

Occupancy:

Occupancy expenses are related to a brick and mortar (or sometimes a mobile) restaurant. This expense account includes sub-accounts like rent or lease payment, utilities, pest control expenses, cleaning and security.

Creating Sub-Accounts

Follow the same steps listed in the previous example to create major expense accounts for: General Expenses, Operating Expenses, Labor Expenses and Occupancy Expenses.

Afterward, you’ll need to create sub-accounts to track each individual line-item expense, like Rent for instance. And link them to the appropriate parent like Occupancy Expenses.

Tip: The account type must be the same for both parent and sub-account. Example: Expense accounts can only have a hierarchical relationship other expense accounts.

 

QBO Chart of Accounts for Real Estate Management

Whether you are an investor, a property manager or an agent, you already know that Real Estate Management (REM) is a tough industry that comes with risk, liability and financial unpredictability. That’s why it’s vitally important for real estate professionals to have a well-organized chart of accounts that is customized for success.

Sort Order Considerations for Real Estate

Charts of accounts can be organized in alphabetical order or account number. The sort order is pre-set in QBO and defaults to alphabetizing accounts unless numbers are manually entered at the start of the Account Name.

You may use a format like this for major parent accounts:

 

  1. 1000 - 1999 Assets
  2. 2000 - 2999 Liabilities
  3. 3000 - 3999 Owner’s Equity
  4. 4000 - 4999 Revenues
  5. 5000 - 5999 Expenses - Costs of Properties/Services Sold
  6. 6000 - 7999 General / Operating Expenses

 

There are a number of sub-accounts REM should consider including under the appropriate expense category:

  1. 1000s: Checking Accounts, Savings Accounts, Escrow Accounts, Rent, Improvements
  2. 2000s: Accumulations and Depreciations, Credit Card Debt, Mortgages
  3. 3000s: Equity
  4. 4000s: Rental Income, Home Sales, Other REM Income
  5. 5000s: Costs of Doing Business
  6. 6000s: Marketing Expenses, Professional Fees
  7. 7000s: Property Taxes, Utilities, HOAs, Insurance, Etc.

 

Setting Up Individual Properties

As far as QBO is concerned, the best way to set up individual properties is as a sub-account of a parent. Each parent is a line item that follows the numbering schema we’ve been discussing above.

 

For example:

Let’s say 7200 is the line item sub-account for Utilities. It falls under the General, or Operating Expenses major parent account. So, the hierarchy under General / Operating Expenses looks like this:

7000 - General / Operating Expenses

  1. 7100 - Property Tax
  2. 7200 - Utilities
  3. 7300 - HOAs

If you drill down to 7200 - Utilities even further there are additional hierarchical relationships. These are properties. For the purpose of this example, the REM owns two of them.

7200 - Utilities

  1. 7201 - 1102 Springfield Dr.
  2. 7202 - 1117 Chestnut Ln.

Using this system offers the most room for a REM to grow their property portfolio. Small business owners in real estate can use the same steps for creating parent, sub-accounts, and hierarchical relationships as described above in the sections for nonprofits and restaurants.

Pro Tip: Although these account numbers can be helpful, they aren’t absolutely necessary, especially if you’re a small business. Over time, they can become confusing, complicated and cumbersome.

The key is to make sure your account line items have clear titles that are easy to keep track of and remember. Simple straightforward account titles such as “Credit Card Fees” or “Construction Materials” are a great way to start.

 

QBO Chart of Accounts for Contractors

As a small business accounting blog, we would be remiss not to include some helpful information for contractors. This includes construction firms, landscape architecture companies, HVAC companies and other small businesses that provide services on a contractual basis.

 

The recommended COA set up for contractors is actually the same as for any small business. If you choose to go with the standard formatting, your COA may look something like this:

 

  1. 1000 - 1999 Assets
  2. 2000 - 2999 Liabilities
  3. 3000 - 3999 Owner’s Equity
  4. 4000 - 4999 Income
  5. 5000 - 7999 Expenses

 

Contractors may have some unique line-item sub-accounts, however. These could include some or all of the following:

 

  1. 1000s: Cash, Short Term Investments, Contracts Receivable, Underbillings, Land, Equipment, Appreciation and Depreciation
  2. 2000s: Accounts and Notes Payable, Deferred Income, Payroll Taxes
  3. 3000s: Common Stock, Retained Earnings, Profit and Loss, Other Equity
  4. 4000s: Sales, Other Income: Rental or otherwise
  5. 5000s - 7000s: Marketing Expenses, Warranties and Bonds, Finance Expenses, Cost of Sales, Indirect Spending, etc.

 

Summary of Set Up Instructions

Here’s a quick recap:

Before you create any accounts decide on your naming convention, as this will determine your sort order. If you’ve decided to go with the number system in our examples above, be sure to include the account number on the front end of the Account Name for each account created. Then:

 

  1. Go to the Gear Icon and select Chart of Accounts.
  2. Navigate to the top right corner. Select New.
  3. Select New Account.
  4. Create the Major Parent Accounts that apply to your industry
  5. Follow instructions as detailed above
  6. Follow the prompts to the last page of New Account screen, put a check next to Is Subaccount
  7. Select the Parent Account you want to link

 

Quickbooks Online: Simplifying Bookkeeping for Your Industry

QuickBooks Online offers a number of unique benefits that are important for small business owners. These include:

 

  1. Enhanced sharing features
  2. No software management
  3. Easy app syncing, free apps for mobile use
  4. Automatically send invoices and statements
  5. Automatically send reports
  6. Variety of options for linking accounts and receiving payments

 

Having a good handle on the various accounts you need to set up based on your industry offers an excellent stepping stone to improving your business finances. However, you may still need more help with the books to ensure that all your financial records are kept up-to-date each week. Remember, having accurate real-time data in a well-organized chart of accounts will allow you to make the most informed decisions for business growth.

Instead of managing the books on your own or hiring an expensive in-house bookkeeper, consider the services of an outsourced accounting firm like Ignite Spot. We offer a complete bookkeeping solution including: bank reconciliations, customer invoicing and collections, bill payment, credit card management and more, at a fraction of the cost.

We can provide guidance for your business allowing you to focus on growing your business instead of feeling frustrated when it comes to recording journal entries, ledgers and invoices. Let us help get you started on the journey to fully automating your finances in the cloud leveraging small business accounting software like QuickBooks. If you’re a small business owner looking for fast, affordable and convenient ways to streamline your operations, improve cash flow management and scale your business, then reach out to our team today.

In-house or Outsourced ebook