Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

QuickBooks Pro Limitations Explained

May 30, 2016 by Wayne Schulz

QuickBooks

 

Are you thinking about purchasing QuickBooks but unsure whether you can fit within the product’s limits? Not sure what those limits are?

Are you a QuickBooks users wondering when your company will hit the limitations build into the Intuit accounting system?

Luckily Intuit publishes the limitations of QuickBooks Pro on their website so that you can review them ahead of time to decide whether your company will fit into the capabilities of QuickBooks Pro.

First, consider that overall QuickBooks is designed for companies with under 20 employees and less than 2 million dollars of annual revenues. That doesn’t mean it won’t work for larger companies. It only means that the typical QuickBooks users are within these parameters. Companies that are expecting to grow beyond these capabilities might consider starting with a more robust accounting system to avoid a migration as the company grows.

Intuit provides some guidance for determining if your company will fit within their product limitations:

QuickBooks is designed for small businesses with 20 or fewer employees and annual revenue of less than two million dollars. The ideal use of QuickBooks is to keep at least two years of detailed transactions in a company data file so that you can run comparative reports and have prior-year project information.

The rate of growth of QuickBooks company data files varies significantly from company to company. There is no “average” or “typical” data file size, since businesses track different information. How quickly a file grows depends on the number of transactions, the amount of information entered per transaction, and the number of “links” per transaction.

For example, someone who enters 500 1-line invoices per month might find that their data file is smaller than another person who enters 100 5-line invoices per month, while someone who usually receives five separate payments per invoice would have a larger file than someone who typically receives only one payment per invoice.

To estimate if QuickBooks is right for your small business, take the average number of monthly transactions (remember, an invoice, payment, and deposit would be three separate transactions, and a bill and bill payment would count as two), and multiply by 2 KB to determine how much the data file will grow each month.

For example, if your company enters an average of 300 transactions per month, your data file could grow 600 KB per month (300 x 2 KB = 600 KB), or 7200 KB per year (600 KB x 12 = 7200 KB). If the annual data file size is less than 15,000 KB, then QuickBooks should be more than sufficient for your company. (Present QuickBooks users can check the size of their QuickBooks file by choosing Help > Product Information.)

One reason that Intuit talks about file size limitations is that many existing QuickBooks users could find reporting and speed of data entry gets much slower as the data files grow.

Here is a list of the limitations of field sizes within QuickBooks. The main issue with these limits could be the account number size which is restricted to only 7 characters.

Character Limitations for QuickBooks Fields

Character_limitations_for_fields_in_QuickBooks_-_QuickBooks_Learn___Support

 

Here is another Intuit QuickBooks chart showing the limits on numbers of records. Note that while you may have up to 10,500 employees, vendors and customers individually, combined they cannot exceed 14,500 or you’ll be forced to migrate. Inventory limits may seem robust however growing companies – especially wholesale distributors – often carry a broad catalog of items from multiple suppliers. These items can easily grow to exceed 14,500.

Inventory limits may seem robust however growing companies – especially wholesale distributors – often carry a broad catalog of items from multiple suppliers. These items can easily grow to exceed 14,500.

Unfortunately, too many companies don’t consider these hard limitations before investing hours of labor into using QuickBooks for their statup.

quickbook_limits

 

 

Our recommendation:

  1. If your company can fit within QuickBooks and you do not expect to grow within the next 5 years then you’re probably on the right path if you are investigating QuickBooks as an option.
  2. If your company expects to grow past $2 million in revenues or will deal with more significant inventory capabilities and pricing then consider skipping the entry-level QuickBooks Pro and looking at alternatives. Your goal should be to avoid a migration in the future just as your company is growing rapidly and can least afford to interrupt their business processes.

To speak with us here at Schulz Consulting and discuss ways in which Sage 100 might be a better fit for your company, please use our contact form. Someone will call or email within 2 hours to discuss any questions.

Filed Under: Quickbooks, Sage 100 ERP Tagged With: Quickbooks

Sage Payments QuickBooks Integration

November 10, 2012 by Wayne Schulz

I just stumbled across this literature from Sage which indicates their Sage Payments credit and debit card processing integrates to QuickBooks.  We don’t have any direct experience with this integration though their literature claims that the integration will “seamlessly flow back into your accounting software”.

Filed Under: Sage 100 ERP Tagged With: credit card, Debit Card, merchant processing, Quickbooks, sage payments

QuickBooks Payroll Alive And Well

December 14, 2009 by Wayne Schulz

This morning I received a somewhat confusing email from my local Paychex representative. The subject line of “QuickBooks May Be Discontinued” caught my attention.

emailThere was no message in the body of the email, however, attached was a graphic (see below) that stated QuickPayroll was being discontinued.

Sensing that something wasn’t right and that there’s no way that QuickBooks was going to be discontinued I contacted Intuit for their feedback.

quickpayroll

As it turns out the notification, sent by my local Paychex representative, was only partially correct.

QuickBooks Payroll is not being phased out.

An older low-end version product called QuickPayroll is being discontinued in favor of any of Intuit’s other three payroll processing options.

With over 1.2 million payroll customers there’s a slim chance that Intuit’s going to turn their back on the payroll market. In July of 2009 Intuit actually increased their presence in the payroll market with a $170 million acquisition of Paycycle which also brought 85,000 additional small business payrolls under their arm.

Here is Intuit’s response:

Discontinuation of QuickPayroll

As of December 31, 2009, Intuit will discontinue its stand-alone QuickPayroll, a very basic payroll service that did not require the use of QuickBooks. We have notified the QuickPayroll customers (http://payroll.intuit.com/support/kb/kbitem/1012532.html) and have provided them with two offerings so that customers can continue their payroll services with Intuit. With its advertising,

  1. QuickBooks Basic and Enhanced Payroll – payroll services that link to QuickBooks desktop
  2. Intuit QuickBooks Assisted Payroll – payroll service in which Intuit handles the tax forms and payments; payroll integrates with QuickBooks desktop
  3. Intuit Online Payroll – cloud-computing payroll service that runs stand-alone or integrates with QuickBooks desktop and QuickBooks Online.

intuit payroll options

So rest assured that QuickBooks and QuickBooks Payroll are both alive and well.  While we don’t offer services on the Intuit product we wanted to provide this update for any users who might have received the same type of email with mis-information about the status of QuickBooks Payroll.

A full comparison of each option:

http://payroll.intuit.com/compare/compare-quickbooks-payroll.jsp

Filed Under: Quickbooks Tagged With: Intuit, online, paychex, payroll, Quickbooks, quickpay

Sleeter Group QuickBooks Conference November 9-12 Registration Open

May 28, 2009 by Wayne Schulz

sleeter group.jpg

If QuickBooks Consulting is your forte – then be sure you register for the Sleeter Group’s annual conference (November 9-12, 2009 in Florida) which has just started early registration.

I attended the conference last year and found it to be extremely helpful in learning more about a product that we compete often against.

You may ask why we would attend a QuickBooks conference for a product that we don’t represent

The answer is simple. No one product can offer a solution that fits every business. Where our solution isn’t the right fit – we often (and regularly) recommend other possible solutions for our prospective clients to investigate. Having a good solid knowledge of the marketplace is what sets Schulz Consulting (in our humble opinion) apart from competitors who might be focussed on only moving boxes of software.

Three Days of Intense QuickBooks Training and Networking

The Sleeter Conference features multiple tracks of QuickBooks learning sessions which are offered on a variety of topics including report writing, add-ons, upgrades, new features, etc.

Each day begins with a keynote address that sets the stage for the day’s events. Intuit addresses the group and can be expected to give a road map and overall discussion about the newer features coming in any expected upgrades.

What I liked the best about the conference was not the Intuit keynotes but rather the impromptu demonstrations given by the technical support managers from Intuit. These informal demos contained loads of information, were totally live, totally interactive and didn’t contain one boring Powerpoint!

Doug Sleeter and his group also offer a great collection of training materials and users guides that any QuickBooks consultant will find helpful.

Highly recommend.

Links:

QuickBooks Consulting Conference

Sleeter Group Conference Site

QuickBooks Training Guides and Manuals

Sleeter Group Educational Guides

Sleeter Group Web Site

Sleeter

Filed Under: Quickbooks, Technology Tagged With: Quickbooks, sleeter group

QuickBooks vs MAS 90 comparison guide now available

October 20, 2008 by Wayne Schulz

quickbooks 2009Outgrowing QuickBooks?

Thinking about switching to Sage MAS 90 or Sage MAS 200?

Unsure about what the differences between the products are and whether you’ll get enough of a benefit from making the move from Intuit’s Quickbooks software to MAS 90? Then take a look at this new 86 page QuickBooks vs MAS90 document that goes into depth about  the differences between these two products.

Here’ a quick breakdown of the included chapters:

    Chapter 1 – Introduction

    Chapter 2 – Price Value

  • Generally Accepted Accounting Principles (GAAP)
  • Retail Limitations vs. Value Added Reseller Consulting
  • Integration
  • Customization
  • Enhanced User Interface
  • Flexibility to Add Modules as You Grow
  • Core Accounting
  • Distribution
  • Manufacturing
  • Resource and Project Management
  • Business Intelligence and Customization
  • Customer Relationship Management
  • Business Management Applications
  • Add Users as You Need Them
  • Chapter 3 — Feature and Workflow Comparison

  • Feature Comparisons
  • Available Modules
  • System Options
  • Accounts Receivable
  • Accounts Payable
  • General Ledger
  • Inventory
  • Sales Order
  • Purchase Order
  • Payroll
  • Customizer
  • Bar Code
  • Job Cost
  • Visual Integrator
  • Workflow Differences
  • Real-Time and Batch Processing
  • Cash Basis vs. Accrual Accounting
  • Audit Trail
  • Adding Customers and Vendors
  • Working in More Than One Company
  • Memorized Transactions vs. “Copy From”
  • Data Entry
  • Navigation
  • Viewing and Editing Open Sales Orders and Quotes
  • Inventory Costing
  • Functionality That’s the Right Fit
  • Alerts vs. Business Alerts
  • QuickBooks Welcome Window vs. Sage MAS90 Special Edition for QuickBooks Users
  • Business Insights Dashboard
  • Chapter 4 — Conversion Expectations

  • Conversion Specialist Program
  • Training Requirements
  • Before You Begin the Conversion Process
  • What Is Data Migrator?
  • What Data Can Data Migrator Convert?
  • Which Versions of QuickBooks Data Will Data Migrator Convert?
  • What Does the Migration Process Entail?
  • Printing QuickBooks Reports Before Migration
  • Data Migrator Checklists
  • QuickBooks Data Migration Checklist
  • Sage MAS90 Special Edition for QuickBooks Users Pre-Data Conversion
    Checklist
  • Sage MAS90 Special Edition for QuickBooks Users Post-Data Conversion
    Checklist
  • Data Integrity
  • Time Expectations
  • Downtime
  • Chapter 5 — How to Get the Most Out of Your Software

  • Implementation
  • Training
  • Tutorials
  • Anytime Learning and Instructor-Led Training
  • Authorized Training Centers (ATCs)
  • Certified Trainers (CTs)
  • Business Partner Training
  • Support
  • Certified Support Specialists
  • Certified Support Centers
  • Sage Software Support Plans
  • Conclusion

From the guide:

What are Generally Accepted Accounting Principles (GAAP)?

GAAP is a widely accepted set of rules, conventions, standards, and
procedures for reporting financial information that are established by
the Financial Accounting Standards Board (FASB). Sage MAS90
Special Edition for QuickBooks Users adheres closely to these
important industry guidelines.

For example:

  • In Sage MAS90 Special Edition for QuickBooks Users, a user
    cannot change or delete posted transactions without an audit trail.
    With an audit trail of changes to posted transactions, you will
    maintain a clean general ledger that will make your accountant
    and the IRS much happier!
  • QuickBooks allows you to use either cash-basis or accrual-basis
    accounting methods. Cash-basis accounting does not follow
    GAAP. Sage MAS90 Special Edition for QuickBooks Users uses
    accrual-basis accounting, which closely follows GAAP.
  • Although this guide has been designed by Sage Software (developers of Sage MAS 90 and 200) and can understandably be considered a little biased toward their product – it still contains lots of helpful information.

    Whenever I review a vendor provided guide such as this I will use it as a starting point. If you can get even one question from it to ask about a prospective new accounting system then it is worth it.

    Even though this guide is designed by Sage Software, there is an unusual amount of fact checking that happens before it is published.

    For example, there are plenty of charts like this which compare and contrast the available features in QuickBooks and MAS 90.

    quickbooks vs mas90 chart.jpg

    The guide is available now through your friendly local Sage Business Partner. If you don’t have a friendly (or a local) partner to ask – then hit up the link below for your very own free copy.

    Depending upon the version of Sage MAS 90 or 200 that you are considering, you should be asking as well about any promotions that are available for owners of QuickBooks (or other competing products) who are upgrading. Sometimes the promotions are only valid on certain versions of MAS 90 – but you won’t get the discount unless you ask!

    Link: QuickBooks Conversion Guide
    (PDF)

    Filed Under: Quickbooks, Sage 100 ERP, Sage software, upgrades Tagged With: mas90 consultants, Quickbooks, quickbooks alternatives, quickbooks comparison guide, quickbooks vs mas200, quickbooks vs mas90, Wayne Schulz

    • 1
    • 2
    • Next Page »

    Search Our Site

    Sage 100cloud Latest News

    • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
    • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
    • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
    • There is No Sage 100 IRD for 2020 January 6, 2021
    • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
    • Sage Announces Sage Partner Cloud December 16, 2020
    • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
    • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020

    Our sponsors

    Contact Us

    Schulz Consulting
    Connecticut Office
    Phone: 860.657-8544
    Email Us
    Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
    New York, New Jersey. Available remotely nationwide.
    We are a local branch of DSD Business Systems Connecticut.

    Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in