• Home
  • Services
    • Our Services
    • Cloud Accounting Setup
    • Diagnostic Review
    • Cleanup Services
    • Bookkeeping & Accounting
    • Payroll
    • Training
  • Products
    • QuickBooks Online
    • QuickBooks Online Payroll
    • QuickBooks Payments
    • Dext Prepare
    • Rewind
  • Working With Us
  • Reviews
  • Blog
  • About Us
  • Contact
January 18, 2022

A Quick Guide to Understanding Accounting Software

acceleratorsupport Accounting Software

Tweet
Share
Share
Pin

Transport yourself back in time 50 years. An accountant sits at their desk with several big heavy ledger books in front of them. Their sharpened Number 2 pencil is posed in their hand, carefully recording numbers on scored ledger paper. A 10-key adding machine spews white rolls of paper with printed numbers as the accountant adds up the figures in the ledger, one column at a time.    

Fast forward to today, and luckily, accounting software has replaced the old-fashioned ledger books. Computer programs specialized in accounting functions now perform calculations, account postings, and other processes needed to maintain a business’s accounting records. 

An entire ecosystem of accounting software programs and the vendors who support them exists to streamline the accounting function and deliver the information you need for tax compliance and to run your business better.  At the heart of every accounting department is the core accounting software: the programs that perform basic accounting functions, including maintaining your General Ledger.

Core Accounting Software

You are likely already using one of the following accounting software programs for your business:

  • AccountRight from MYOB (popular in Australia and New Zealand)
  • FreshBooks (popular in Canada)
  • QuickBooks Online from Intuit (popular in the US and Canada)
  • QuickBooks Desktop from Intuit
  • Sage 50 from Sage (popular in Europe)
  • Wave (popular in Canada)
  • Xero (popular in Australia, New Zealand and the UK)

The above list is typically used in small businesses and supplemented by add-on accounting apps when additional functionality is needed beyond the core system.

At the mid-market level, you might see these accounting software packages and vendors: 

  • Acumatica
  • Intuit QuickBooks (Online, Desktop, Enterprise)
  • Microsoft Dynamics
  • Oracle NetSuite
  • SAP (Business One, ERP, and others)
  • Sage (Intacct, 50, 200, etc.)
  • Xero
  • Zoho Books

For large companies, accounting software is usually one or more modules within an integrated suite of software referred to as an Enterprise Resource Planning (ERP) software package. ERP software effectively runs all of the operations of a business. 

Typical Functions of a Core Accounting System

The main purpose of a core accounting system is to track accounting transactions throughout the life of your business. Each transaction will affect an account balance. These account balances make up your General Ledger, which is a detailed list of every financial transaction in your business grouped by account. Your financial reports provide a summary of all of this activity.  

The backbone of your accounting system is the Chart of Accounts. Every business is different, so your Chart of Accounts will be unique to your business. However, there are similarities too. All businesses will have bank accounts, for example. Some accounts are needed for tax reporting purposes, some accounts are traditional, and some accounts can be made up of whatever you need in your business. You can work with your accountant to customize your Chart of Accounts so that it perfectly fits your business’s needs.    

A core accounting system will also have the following functions, depending on its sophistication:

  • Banking transactions, which can come in from automated bank feeds and be coded to the correct accounts
  • Accounts receivable, or a way to record receipts from customers
  • Accounts payable, or a way to record payments to vendors
  • Customer and vendor management
  • Financial reporting

Advanced core features include:

  • Inventory functionality
  • Sales tax features
  • Customer quotes
  • Purchase orders
  • Journal entry adjustments
  • Closing functions
  • Multiple currencies
  • Recurring transactions
  • Project tracking
  • Job costing
  • Document management
  • Additional reporting
  • And others

Sometimes, core accounting software contains enough functionality for a small business that it can serve as the stand-alone accounting software for the business. Other times, a small business needs additional functionality, often due to volume, a need for additional users, or external reporting requirements unique to its industry.

That’s when add-on accounting software apps come into play.  Add-on accounting software enhances the functionality of the core system. It increases automation and efficiency in the accounting department.

Numerous categories of add-on accounting software exist. The specific choice depends on the core accounting software selection and whether they can be easily integrated. There’s a whole marketplace of add-on software to choose from. Let’s take a look at a few of the categories. 

Add-on Accounting Software

Payroll

The most common accounting software add-on is payroll. All businesses that hire employees will need this software to calculate paychecks, pay payroll taxes, and file payroll tax reports required by federal and state agencies. The payroll software integrates with the core accounting system to feed the payroll transactions into the General Ledger. 

Payroll software may even have add-ons of its own. For example, employers offering 401(k) plans to employees may have an add-on benefits system. Workers’ compensation is another popular add-on, as well as time tracking systems for employers that pay by the hour and require timesheets. 

Some common payroll vendors include:

  • ADP
  • Gusto
  • OnPay
  • Paychex
  • QuickBooks Payroll
  • Xero

Each of these software apps has varying features, so it will depend on what requirements your specific business has as to which solution is best for you. 

Point of Sale (POS)

Point-of-sale software is the software that you use to capture customer sales and other transactions. This type of software varies the most from industry to industry. In service industries, it may be called invoicing software instead of point-of-sale software.

Point-of-sale systems are typically used inside retail stores and restaurants, and have both a hardware component (including an ordering terminal, product scanner, cash register/drawer, and credit card terminal) and software.

For online stores, a point-of-sale system is typically an online shopping cart with a built-in payment system. It can also include the functionality of a customer relationship system or CRM.

Point-of-sale, or invoicing, systems are very common because most businesses have needs beyond what the core accounting systems can provide. These systems enhance the customer-facing front end of your accounting function, ringing up sales orders and collecting revenue. They can have very shallow or very deep integration with the core accounting system, depending on the needs of the business.  

Software vendors who sell point-of-sale systems are very often industry specific in their solutions. For example, Mindbody serves the wellness industry with scheduling and point-of-sale solutions, while Clio is extremely popular for law firms. Generic POS solutions include:

  • Clover
  • Lightspeed
  • Shopify
  • Square
  • Toast (for restaurants)

Customer Payments

One exciting aspect of accounting for most entrepreneurs is getting paid. Payment systems automate this process by enabling customer payments to be deposited directly to their business bank accounts. 

Almost all businesses take credit cards, and a merchant account is a key component of a payment system. Payment systems are usually connected to a shopping cart, POS system, or an invoicing system. The customer will either go through a checkout process or click a button that says pay bill.

From there, the system will ask for payment, usually in the form of a credit or debit card. The payment system will collect that amount, create a daily summary, and deposit the amount collected in your bank account. A fee will be charged by the merchant account or payment system, which is usually three to four percent. 

In older payment systems, there were many players and different vendors: the merchant account, a gateway, a processor, and a shopping cart vendor. Luckily, the process has been greatly streamlined and you can often get all of the functions you need within one vendor. Some common payment vendors include:

  • PayPal
  • QuickBooks Payments
  • Square
  • Stripe

Plus, there are many options that are industry-specific. For example, the healthcare system has many payment systems where patients can go to a website, enter their invoice number, and pay their bill online. 

Let’s not forget ACH. While it’s not really a payment system per se, it is a cost-effective way to collect payment, especially for recurring customer payments that are the same amount each month. To set up ACH, you would go directly to your bank. Their fee is typically per month instead of a percentage per transaction, and starts at $25 per month.  

Bill Pay and Accounts Payable Management

While core accounting systems almost always include a bill payment function, it might not be robust enough for the volume or the specific needs of your business. That’s when bill payment systems come in handy as an add-on to the core system.

Bill payment systems can receive, route, approve, code, process, pay bills, and produce receipts and expense reports for the business. Some bill payment systems focus on processing invoices and have a robust approval routing system, some specialize in employee expense report processing. Others receive receipts, apply optical character recognition to enter them into the system, and code them to the correct expense or inventory account.

Some bill payment systems provide free accounts for the vendors being paid, so that the payment gets direct-deposited into their bank account. 

Common bill payment systems include:

  • Bill.com
  • ApprovalMax
  • Melio
  • Dext
  • Hubdoc
  • AutoEntry
  • Expensify

Another variation of the bill payment systems is check writing software. Some businesses may still have a requirement to write, print, and mail paper checks, but the demand for this is slowing since it’s inefficient, costly, and not environmentally friendly.   

Inventory

If your business has inventory, you may need an add-on application with extended functionality to track your items. Inventory is another area that is very different from one business to another. Some businesses may have huge transaction volume, which presents its own issues. Others may have thousands of items that need tracking. Manufacturing firms not only have items for sale but also parts, work-in-progress, and assemblies to deal with.

A sampling of other requirements of inventory include:

  • Shipping, including overseas and Customs and Border issues
  • Sales tax collection, certificates, and exemptions
  • Purchasing and receiving, including purchase orders, partial receipts, and refunds/restocking
  • Multi-location and storage of items, including warehouses, stores, and trucks
  • Bar code hardware for labeling and picking
  • Shipping labels
  • Physical inventory adjustments, spoilage and shrinkage
  • Drop shipping
  • Back orders
  • Out-of-stock conditions
  • Tracking by lot and serial number
  • Recalls
  • Special tracking and storage requirements, such as Class A drugs or certain hazardous materials
  • Measurements, such as ounces versus pounds
  • Customization and personalization
  • And so much more

For businesses with complex inventory requirements, the best solution might be a mid-market accounting system or ERP software that has a robust inventory module built in. These solutions provide much better integration than what’s available as a small business add-on. 

A small sampling of inventory systems include:

  • BigCommerce
  • DEAR
  • Katana
  • SOS
  • Unleashed

Ecommerce

Recent events have forced many businesses to develop an online store so customers can shop from the convenience of their computers and phones. Ecommerce software enables this.

Ecommerce software includes several functions that we have already talked about: payment systems, point-of-sale systems, and inventory. It all centers around a browser-based web store of products displayed on pages with shopping cart links and a checkout and payment page. The backend of the software handles merchandise picking and shipping.

Some common shopping cart software applications include:

  • BigCommerce
  • Ecwid
  • Kajabi
  • Keap
  • Magento
  • OpenCart
  • Shopify
  • Square
  • WooCommerce

The mid-market accounting systems, such as NetSuite and SAP, provide modules that contain this functionality within their ERP suites as well.

Reporting

When you need additional financial reporting that core accounting systems don’t provide, reporting add-ons are readily available. They provide many additional features, such as charts and graphs, dashboard-like reporting that displays analytics, budgeting and forecasting, and performance and specialty reports not otherwise available. 

Within the category of reporting add-ons, there is a large sub-category of cash flow reporting apps. These add-ons help entrepreneurs track and forecast their cash balance, so that any shortfalls can be predicted and remedied ahead of time.

Examples of reporting apps include:

  • Fathom
  • LivePlan
  • Spotlight
  • Syft Analytics

Other Apps

There are literally hundreds of add-on apps in the accounting software space. Some other major categories of apps include:

  • Accounts receivable collections
  • Conversions, integrations, and connectors
  • Customer Relationship Management (CRM) software
  • Document management, to track bills, receipts, invoices, and other documents tied to accounting transactions
  • Fixed assets
  • Human Resources (HR) add-ons
  • Invoicing
  • Loans
  • Project management
  • Proposal/quotes software
  • Time tracking

With all of these choices, you might wonder which of these systems is best for your business.

Which One Is Right for My Business? 

The worst thing you can do is decide you want a system for all the wrong reasons. Here are some WRONG ways to decide on software:

  • Because you received an email and maybe even a coupon
  • Because you saw it at a trade show
  • Because a friend uses it

The best way to decide which software you should be using involves a careful, deliberate process. The larger your business, the more time you can afford to spend on selecting the right software. In essence, here are the steps:

  1. Map out your current process of the function you plan to automate. By doing this, you will be able to see what your requirements are for a system.
  2. Make a list of requirements that you need the system to perform for your business. If your list is long, you may want to categorize them by importance. You may not find a system that meets all of your requirements, so you will want to know which requirements are your “show stoppers” (what you can’t live without).
  3. Decide on other criteria you will use to select a vendor. For example, how long a vendor has been in business, how large their installed base is, and how good their customer service is could make up three criteria to consider.
  4. Go to the marketplace and choose several vendors to consider.
  5. From your vendor list, look at the features and vendor criteria for each one, and try to eliminate all but 3-5 vendors based on your requirements, and especially, your “show stoppers”.
  6. Schedule demos of the short list of vendors. Continue to eliminate based on your requirements.
  7. Make a chart of your requirements (use rows) and your shortlist of vendors (columns). Score each vendor.
  8. Get trial software for the 2-3 highest scoring vendors.
  9. Run some test transactions through the trial software. Eliminate any that fall short of the requirements. Is there one that has a user interface that feels better than the others? What does your gut tell you?
  10. Make a final choice.

Too often, businesses choose software that doesn’t meet their basic requirements. When you follow this process, that is less likely to happen. You’re more likely to find software that is more efficient and higher value, rather than if you played darts with your software selections.

And, of course, you can adjust the steps above to be cost-effective for your business. 

Your Accounting Tech Stack

Don’t be surprised if it takes more than a few accounting apps to fully automate your accounting department. The average employee in the U.S. handles 13 apps per day, although not all of these are accounting apps (Source: Asana).  

Your tech stack is simply a list of all of the apps you use in your business, and your accounting tech stack will consist of your core accounting system, plus all of the app add-ons that integrate with it. 

Selecting and implementing the right accounting software combination for your business is essential and can make all the difference in your efficiency and profitability. Most importantly, it can also reduce you and your employees’ frustration levels when the software simply does what it should.

If we can help you select and implement the right accounting tech stack for your business, please reach out to us any time.

Tweet
Share
Share
Pin
Five Ideas to Attract Staff During the Great Resignation How Variance Reporting Can Keep Your Profits on Track

Related Posts

Accounting, Accounting Software, Blog, Business Tips

30 Reasons Why It’s Better to Have Professional Help with Your QuickBooks® Software

Accounting, Accounting Software, QuickBooks Help

How to Properly Track Payments for Forms1099-MISC and 1099-NEC Reporting

Accounting, Accounting Software, Business Growth, Business Tips

5 Signs You Need to Upgrade Your Accounting System

Search

Archives

Categories

Sitemap

  • Home
  • Services
  • Products
  • Working With Us
  • Blog
  • About Us
  • Contact

Contact Us

Scott Springer CPA logo icon
Accounting and Bookkeeping Services for QuickBooks® Online

Scott Springer, CPA PLLC

402 A West Palm Valley Blvd #182
Round Rock, TX 78664

(737) 471-4272
howdy@ScottSpringerCPA.com

Stay Connected


Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.

Client Portal

Client Appointments

Current clients may book an appointment here:

Copyright Scott Springer CPA | Professional Site Design by Accelerator Websites | Powered By ThriveFuel Marketing | Privacy Policy

If you track transactions by the QBO fields for Class, Location or Project, but this information is missing on relevant transactions, it can result in incomplete or misleading reports. We assign the proper values to those transactions based on information you provide.

We will provide guidance on how to set up, enter and modify budgets in QBO. In addition, for each budget you set up, we will create, customize and share two budget reports in QBO that you may run on demand: Budget Variance Report and Budget Remaining

We will categorize and record your vendor bills and expenses in QBO. We will do so based upon information you provide and our increasing knowledge of your company. We will ask for clarification, as needed, to ensure transactions are recorded properly.

All packages include unlimited support incidents for issues encountered when using the software subscriptions in your package. You also get unlimited consultations with us for advice on ad-hoc accounting matters.

We will create, customize and configure Accounts Receivable and Accounts Payable Aging Summary and Detail reports to be emailed to you on a weekly basis. This provides more current information so that you may act more quickly.

We will allocate revenue and/or expense by a single segment (QBO Class, Location or Project) using either fixed or variable percentages depending on your needs.

To help ensure your accrual-basis reporting is even more accurate and meaningful, we will periodically record the following entries:

  • Income accruals – used to record income that has been earned but not invoiced or collected yet
  • Expense accruals – used to record expense that has been incurred but not billed or paid yet
  • Income deferrals – used to record customer payments received before the income has been earned
  • Expense prepayments – used to record vendor payments made before the expense has been incurred
  • Allowance for doubtful accounts – used to recognize bad debt expense and to reflect the current net realizable value of Accounts Receivable

For clients with construction projects that have binding contracts with enforceable rights, we also offer contract accounting using the Completed Contract Method (CCM) or Percentage of Completion Method (PCM).

After calendar year-end, we will prepare and e-file your federal Forms 1099-NEC and 1099-MISC.

Rewind automatically backs up your QBO file, providing the ability to restore your entire QBO file or individual transactions and items.

We will reconcile your payroll tax liabilities as well as other liability accounts such as cafeteria plan withholdings and garnishments where applicable.

We will assist you with setting up your QBO Payroll subscription so that you will be ready for your first payroll. Our assistance includes an online working session where we will walk through the setup steps together including:

  • adding employees
  • adding pay types, deduction types and tax information
  • connecting your bank
  • setting up tax payments and filings
  • entering tax payments already made this year, if applicable

Our assistance doesn’t end with the initial setup. The unlimited ad-hoc support and advice extends to your payroll subscription as well. Need help setting up a new employee? Not sure how to properly record an employee advance? How to record tax value of a gift card provided? How to record an employee bonus? We’re here to help.

QBO Payroll is a full-service payroll subscription. You specify how much and when to pay your employees. Payroll calculations, tax deposits, payroll tax returns and W-2 filing are all done for you. Pay employees by check or direct deposit. Employees have an online portal to view pay stubs, W-2s and more. We will help you select the specific edition that best meets your needs.

We will prepare your Balance Sheet and Income Statement. These are key reports to help you understand your company’s financial position as well as the amount of revenue and profit you’ve made for the period. We will also provide Accounts Receivable and Accounts Payable Aging Summary reports to help you better understand who owes you and who you owe.

We will compare your statement balances and transactions with the ones in QBO and make corrections as needed. Reconciliations help ensure your account balances are correct by identifying missing, duplicate or incorrect transactions. We will also alert you regarding any old, uncleared items that may need your attention.

We will perform ongoing, limited review of your transaction entry to look for anything out of the ordinary or likely incorrect.

We will categorize and record your fixed asset acquisitions, depreciation, and disposals in QBO. We will do so based upon information you provide and our increasing knowledge of your company. We will ask for clarification, as needed, to ensure transactions are recorded properly.

We will categorize and record your bank, digital wallet, and credit card transactions in QBO. We will do so based upon information you provide and our increasing knowledge of your company. We will ask for clarification, as needed, to ensure transactions are recorded properly.

Go paperless! We provide a subscription to receipt capture software using optical character recognition (OCR), and we integrate it with QBO. The allows you to easily and securely capture and store supporting documentation for your expenses and vendor bills in the cloud.

QBO is the cloud accounting software we use with all our clients. We will help you select the specific edition that best meets your needs.

If a customer is not assigned to a sales receipt or refund receipt, it can result in incomplete or misleading customer reports. We assign customers to those transactions based on information you provide.

If a vendor is not assigned to a check or expense transaction, it can result in incomplete or misleading customer reports as well as incorrect totals for Form 1099. We assign the proper vendors to those transactions based on information you provide.

We will prepare your Balance Sheet and Income Statement. These are key reports to help you understand your company’s financial position as well as the amount of revenue and profit you’ve made for the period.

If you require historical reports, then it’s important to resolve issues that affect your Income Statement as well. It’s not uncommon for us to find numerous issues, but not all of them necessarily need to be resolved. We let you decide how extensive you want the cleanup to be based on your needs. How do we do this? By separately identifying:

  • issues that affect section subtotals (such as total income, total cost of sales, total operating expenses)
  • issues that do not affect section subtotals but are not categorized properly within a section

If you require historical reports, then it’s important to resolve issues that affect your Income Statement as well. It’s not uncommon for us to find numerous issues, but not all of them necessarily need to be resolved. We let you decide how extensive you want the cleanup to be based on your needs. How do we do this? By separately identifying:

  • issues that affect section subtotals (such as total income, total cost of sales, total operating expenses)
  • issues that do not affect section subtotals but are not categorized properly within a section

Issues affecting your balance sheet account balances (assets, liabilities, equity) should always be resolved even if you don’t need historical reports. That’s because you need accurate balances as a starting point going forward.

If your bank and credit card reconciliations have not been done or are done but need to be fixed, we will take care of it for you. Reconciliations help ensure your account balances are correct by identifying missing, duplicate or incorrect transactions.

If your diagnostic review revealed that your QBO file has unprocessed bank feed items or there are missing transactions (based on bank or credit card statements), we will record those for you. We will ask for clarification, as needed, to ensure transactions are categorized properly.

If your diagnostic review revealed that some of the QBO “products” and “services” are assigned to incorrect income accounts, we will make the proper adjustments to prevent invoices from continuing to be incorrectly categorized.

We will design your new chart of accounts, tailored to your company’s needs, based on information gathered during the diagnostic review as well as other discussions with you. We will then implement the new design in QBO for you. This includes carefully mapping existing accounts to the new ones.

We will prepare your Balance Sheet and Income Statement. These are key reports to help you understand your company’s financial position as well as the amount of revenue and profit you’ve made for the period.

We will set up the open Accounts Receivable invoice balances for each customer, and we will set up the open Accounts Payable bill balances for each vendor. For each customer or vendor, you have the option of having us set up the balance for each individual unpaid invoice/bill OR you may combine the open invoice/bill balances for each customer or vendor.

We will meet with you in a screen sharing session and walk you, step-by-step, through creating your QuickBooks Payments account and connecting it to QBO. If you already have a payment account with Inuit, we will walk you through connecting it to QBO.

If you want financial statements for additional historical periods, we will prepare your Balance Sheet and Income Statement for those periods.

We will reconcile bank, digital wallet, credit card, line of credit and loan accounts. This means we will compare your statement balances and transactions with the ones in QBO, and we will make any necessary adjustments. We will alert you regarding any uncleared items that may need your attention.

We will categorize and record the following transactions to QBO. We will ask for clarification, as needed, to ensure transactions are recorded properly.

  • bank, digital wallet, and credit card transactions
  • vendor bills and expenses
  • fixed asset acquisitions, depreciation, and disposals
  • payroll journals for non-integrated payroll, if applicable

We will set up your budget(s) in QBO using information you provide.

“Products” and “Services” are used in QBO to record customer invoices, sales receipts and credit memos. We will set them up for your use in QBO and map them to the correct income accounts.

If you want to track income and costs by specific projects, we will set up your client projects in QBO using the information you provide.

We will set up your customers/clients and vendors in QBO using the information you provide.

You provide your general ledger account balances to us from your previous accounting system or tax return. We will provide guidance if you’re not sure how to get the information we need. We will set up your account balances in QBO.

For each of your financial accounts supported by QBO, we will either set up the bank feeds for you or we will meet with you and walk you, step-by-step, through setting it up.

We will design your chart of accounts, tailored to your company’s needs, based on information gathered during the planning meeting. We will then implement the new design in QBO for you.

We will configure your QBO settings optimally for your company based on information collected during the planning meeting. We will explain the types of QBO user permissions available, and we will set up your users and permissions based on a list of users that you provide.

We will set up your QBO subscription on your behalf after the planning meeting.

The planning meeting is critically important because we will ask you questions about your company processes and accounts. This information will help us properly plan your implementation.