Outgrowing QuickBooks: Entities, Locations and When an ERP Fits

Is QuickBooks still enough, or have you outgrown it?

Revenue alone does not decide it. In most cases the IRS lets you choose any recordkeeping system suited to your business that clearly shows your income and expenses, and no tax rule sets a revenue level at which an ERP (enterprise resource planning system) becomes required. QuickBooks has been outgrown when the business around it has changed in a way the file cannot follow, or when the books inside it can no longer be trusted.

The case is not simple when any of these is true:

• Two or more entities lend, rent or pay each other.
• Several locations or departments need their own results.
• Inventory sits in more than one place, or its cost is hard to tie to the balance sheet.
• Many people enter, approve or pay, and you need to control who can change what.
• A lender, investor or buyer asks for statements your file cannot produce.

Each has more than one fix: clean up the books, a higher plan, separate books for each entity, an add-on tool, or a new system. If two or more of these are true, or your accounts do not reconcile, choosing among the fixes takes a review of the books against your filed returns. That is work for a CPA or bookkeeper, not a software comparison. Gather the items in the list at the end of this page first.

What does the IRS require of any bookkeeping system?

The IRS requires records that support the return, not a particular product. Any system works if it meets these points (Publication 583).

In a broad exam, such as one that verifies gross income, the examiner will likely ask for the accounting software backup file, and examiners evaluate the taxpayer's internal controls. The IRS says a new file rebuilt by re-entering transactions is not a copy of the original books and does not meet that request (IRS FAQ on electronic accounting records). Keep the old file whole so you can still produce it, and check that your CPA can export a trial balance and a complete backup from any system you consider.

Which signs say you have outgrown QuickBooks: several entities, locations, inventory or users?

Structure, not sales volume, is what outgrows a file: entities, locations, inventory sites, users or reporting needs. Test each sign against what the system must do.

Does a business this size have to use accrual accounting?

Usually not. Revenue in the low millions does not by itself force accrual, but entity type, grouped receipts and inventory can. Section 448 generally bars the cash method for a C corporation, a partnership that has a C corporation as a partner, and a tax shelter. A C corporation or such a partnership may still use cash while its average annual gross receipts for the 3 prior tax years are $32,000,000 or less (Rev. Proc. 2025-32). An S corporation, a partnership with no C corporation partner and a sole proprietor are not covered by that bar, unless the entity is a tax shelter. Revenue in the low millions is well below the limit, but the receipts of businesses treated as a single employer count together, so check the group total (Publication 538).

A tax shelter, for this rule, includes any entity other than a C corporation that either allocates more than 35% of its losses to limited partners or to owners who do not actively manage it (a syndicate), or had its interests offered in an offering required to be registered with a securities regulator. Interests held by an owner who actively manages the entity, or by that owner's spouse, children, grandchildren or parents, do not count toward that share, and some other holdings are excluded too. A tax shelter generally cannot use cash at any size. A partnership or S corporation can make an irrevocable election to test last year's loss allocations instead of this year's, by attaching a statement to its timely filed original return, extensions included; the entity elects, not its owners (Reg. 1.448-2(b)(2)(iii)). Have your CPA test this if you have passive investors (section 448(d)(3), section 461(i)(3), section 1256(e)(3)).

Inventory is the other rule that can force accrual. If inventory is necessary to show income, the business must use an accrual method for purchases and sales, unless it is a small business taxpayer: average annual gross receipts of $32,000,000 or less for the 3 prior tax years, counted together with any group treated as a single employer, and not a tax shelter. A small business taxpayer may skip formal inventory accounting, but its inventory method must still clearly reflect income (section 471(c); Publication 538).

The method on the return follows the method used to keep the books (section 446(a)), and your accounting records must include a reconciliation of any differences between the books and the return (Reg. 1.446-1(a)(4)). So a lender or investor can ask for accrual statements while an eligible business keeps its return on cash; the reconciliation ties the two. Whether that setup fits your books, or the return should change too, depends on the facts, so settle it with your CPA before changing either. A change of the return's method needs IRS consent, requested on Form 3115; for an automatic change, the original form goes with the timely filed return for the year of change, extensions included (instructions). See switching from cash to accrual accounting for which changes are automatic.

Is the problem QuickBooks or the books?

If the same errors would follow you into a new system, the problem is the books. Signs it is the books:

• Bank, card or loan accounts are not reconciled to the statements. The IRS advises reconciling your checking account each month.
• Balances sit in suspense, uncategorized or owner accounts with no explanation.
• The books at the last filed year-end do not agree with that return's Schedule L, and no one can explain the difference.
• The close takes weeks because of clean-up, not volume.
• Personal and business spending are mixed, or money between entities is unrecorded.

If these apply, they usually need fixing before a move: unresolved errors carry into the new file, where they can be harder to find. If the clean-up reaches back more than a few months, or covers several entities, it usually takes a bookkeeper or CPA; see catching up on overdue books. To choose between fixing the old file and starting a new one, see bookkeeping cleanup or start fresh and small business balance sheet looks wrong.

What do a lender, investor or buyer expect from the books?

Each sets its own requirement, and tax law sets none of them. The IRS notes that income statements and balance sheets can help you in dealing with your bank or creditors, but the format, period, basis and any CPA involvement come from the loan agreement, term sheet or purchase letter. Ask for the list in writing before you choose a system.

When do you need an ERP instead of a higher plan or a better close?

Businesses usually consider an ERP when several gaps exist at once and the books are clean enough to move. No tax rule or official source sets this; the table shows common approaches, and the right one depends on your facts. A single gap can often be closed without a new system.

A late close or untrusted reports usually point to the books, not the software. A test: could you give a CPA a reconciled trial balance for last month end today? If not, you need a bookkeeper or controller who owns the close, the reconciliations and the approvals; software supports those jobs but does not do them. See doing your own books or hiring a bookkeeper. For a lighter change, see QuickBooks or Xero and software your accountant supports.

What must be true of the books before you move?

The books must be reconciled to your statements on the cutover date, and tied to the last filed return at its year-end. Work through this list for each entity:

1. Reconcile every bank, card and loan account to the statement through the cutover date.
2. Clear suspense and uncategorized balances, and make the receivables and payables lists add up to the balance sheet.
3. Count inventory and tie the count to the balance sheet.
4. Agree the balances between your entities on both sides.
5. Tie the books at the last filed year-end to that return, then carry them forward to the cutover date. The Schedule L balance sheet on Forms 1120, 1120-S and 1065 shows balances at the start and end of the tax year and should agree with the entity's books. An entity with receipts in the millions completes Schedule L. A sole proprietor's Schedule C has no balance sheet, so tie the income and expense totals instead.
6. Tie payroll and sales tax payable to the returns filed and the deposits made.
7. Lock closed periods so history cannot change. See closing date after taxes are filed.

A difference you cannot explain is a reason to fix it before moving, not after. For the mechanics, see opening balances after changing accountants.

How much history should move, and what must the new system tie to?

Move opening balances at a clean month end or year end, plus the earlier periods that comparison reports for lenders or investors need. Keep the old file whole. For the cutover date and what to bring across, see switching accounting software mid-year.

Keep the original data until the period of limitations runs out for the returns it supports (Publication 583). Keep property records until the limitations period expires for the year of a taxable disposition, so keep fixed-asset and depreciation detail that long. For property received in a nontaxable exchange, keep the records on the old and the new property until it expires for the new property's taxable disposition. Keep employment tax records at least four years after the tax is due or paid, whichever is later. See how long to keep business records and records to keep when cancelling QuickBooks. The IRS says that detail of closed years before the years under examination may be condensed if it does not include transactions that affect those years, but condensed data is not acceptable for a year under audit (IRS FAQ).

What should you gather before choosing a system?

Gather these before you compare systems or talk to an accountant.

• Every entity: legal name, owners and the type of return it files.
• Loans, rent and other agreements between entities, with the balance each side shows.
• The locations and departments you need results for.
• Inventory counts and where the stock sits.
• The last two filed returns for each entity.
• Written requests from any lender, investor or buyer.
• A list of users, what each does, and who approves and pays.
• A trial balance and bank reconciliations for each entity at the last month end.
• The reports you need each month and how soon after month end.

Example

These examples are illustrative. Amounts are in US dollars.

Three locations, one LLC

A service company with one LLC and US$4 million of sales runs three locations, and the owners want profit by location. Tracking profit by location is the need; many systems do it with locations or classes inside one company file. Cash or accrual does not change that. The first check is whether the plan's class and location limit covers three locations plus any departments. A higher plan, a tighter close, or both may be the fix, not an ERP.

An S corporation and two LLCs that own the buildings

An operating S corporation and two LLCs that own its buildings have combined sales of US$3 million. The LLCs charge rent, and loans move between the three. Each company that is a separate business keeps its own complete set of books, and where one files its own return, its balance sheet should agree with those books. The lender wants one combined view. A common setup is a separate set of books for each company plus a combined report. An ERP comes into the picture if the group adds entities or the combining becomes heavy.

A distributor with stock in two warehouses

A distributor has US$5 million of sales and US$800,000 of inventory across two warehouses. Sales volume is not the issue; inventory is. The test is whether the system tracks quantity and cost by warehouse and whether counts tie to the balance sheet. If not, an inventory tool connected to the books, or an ERP, is the candidate. If it is not a tax shelter and its average receipts for the 3 prior years, with any related group, are below the small business limit, it may be able to treat inventory as non-incidental materials and supplies, or follow its applicable financial statement or, if it has none, its books. Which applies is a tax choice for the CPA and does not replace counts.

Different for you?

• Two or more entities trade with each other, inventory is growing, or a lender, investor or buyer asks for statements your file cannot produce: the choice between cleaning up, splitting into separate books or migrating needs professional judgment, including what the new books must tie to on the filed returns before cutover. Get bookkeeping help.
• You are unsure whether a second business belongs in the same company: see running more than one business and books for several companies.
• Your books are behind or do not reconcile: start with the month-end close checklist and catching up on overdue books, and get bookkeeping help if the gaps span years.
• You want a different product, or are changing software mid-year: see QuickBooks or Xero, software your accountant supports and switching accounting software mid-year.
• You are on QuickBooks Desktop and its discontinuation or subscription is why you are looking: see QuickBooks Desktop being discontinued.
• You sell or bank in more than one currency, or have a foreign entity: this page does not cover multi-currency or cross-border books. See Wise and Stripe multi-currency balances in the books and get bookkeeping help.