NetSuite and Choosing an ERP

Cloud accounting: when it stops being enough and an ERP comes in

Cloud accounting software handles the general ledger. Five processes it leaves out, how to test them in your company, and when an ERP makes sense.

· 5 min read

“Cloud accounting” almost always has a reasonable answer. There are systems that handle the general ledger, accounts receivable and payable, banking and invoicing without your own servers, and for many small businesses that is all they need.

The useful question is a different one: what happens with everything that occurs before an entry reaches the general ledger? This article proposes a test by process, rather than a list of symptoms, to decide whether what you have is enough or an ERP makes sense.

What “in the cloud” does and doesn't tell you

According to Oracle, a system is in the cloud when it doesn't run on hardware you maintain, is paid for by subscription and the vendor applies the patches and updates. That describes where the system lives. It doesn't say which processes it covers.

That is why two companies can both say they have “cloud accounting” and be in very different situations. One records only the result of what happens elsewhere. The other has the entire process inside the system.

Where journal entries come from

A general ledger receives journal entries. In an ERP, those entries come from subledgers: procurement and accounts payable, sales and accounts receivable, assets, inventory. Oracle's documentation refers, for example, to a cost subledger that is reconciled with the general ledger, and to reports that gather the transactions posted across different subledgers.

If your system is accounting-only, those entries are keyed in or imported from somewhere else. That is where double entry appears, and it is where most close errors originate.

The five-process test

For each process, answer three questions. Where does the document originate? Who approves it? How does it reach the accounting without someone entering it again?

  • Procurement. The requisition, the purchase order, the receipt and the vendor invoice. Oracle describes, for example, a budgetary control that validates spending before committing it and generates journal entries for purchase orders. If today the order lives in an email and accounting only sees the invoice, nobody compares what was ordered with what was received.
  • Inventory and cost. If you sell product, your cost of sales depends on what was received and how it was valued. Inventory value and its reconciliation with the accounting are part of the system in an ERP, and are usually a spreadsheet when there isn't one.
  • Sales and collections. From order to invoice, delivery and payment, with the CFDI (Mexican e-invoice) issued from the same record rather than copied from another.
  • Assets and leases. Additions, depreciation and disposals. Oracle includes them in its finance offering alongside accounting, expenses, cash, payments, receivables and revenue.
  • Multiple entities, currencies or projects. Consolidating companies, operating in dollars or measuring profitability by project requires data to be structured at the source, not reconstructed at the end of the month.

Every answer that ends in “someone enters it again” marks a process your accounting system doesn't solve. Not because of a defect, but because of scope.

Run the test with real documents from a month that has already closed. Take one purchase, one sale and one asset, and follow each from its origin to its journal entry. If the trail breaks at any point, that is where the gap is. And run it with the people who do the data entry, not just the people who run the department: that way you see the work that is actually done, not the work described in the procedure.

Mexican tax requirements count too

The electronic accounting the SAT (Mexico's tax authority) requires is not just a file. Annex 24 of the Miscellaneous Tax Resolution lists the chart of accounts with the SAT grouping code, the trial balance, the period's journal entries, the auxiliary of tax receipt folios and the account subledgers. And it states that journal entries must make it possible to identify the tax receipt that supports the transaction and the payment method.

Ask how your system links each journal entry to its CFDI. In Oracle Fusion Cloud, for example, the Mexico documentation provides fields that store the CFDI's unique identifier on supplier and customer invoices, on receipts and on manual journal entries. This article is not tax advice: work with your accountant or tax team to confirm that the link exists and doesn't depend on a manual reconciliation.

When what you have is enough

There are companies for which cloud accounting software is the right answer: a single legal entity, few transactions, no inventory and a close that already finishes on time. An ERP adds cost and discipline, and they are only justified if there are processes that truly need them.

Look at next year too, not just this one. If you plan to open another legal entity, sell outside Mexico, import or start manufacturing, what is enough today may stop being enough within a few months.

One way to look at it is to put a price on double entry: the hours per month spent copying, reconciling or correcting between systems, multiplied by what that time costs, compared with the cost difference of a broader system.

How to take the step without changing everything

You don't always have to replace everything at once. Oracle describes how many customers with on-premises systems start with the processes their current system doesn't cover, and move forward gradually. A company can start with finance and add procurement or inventory once the team has mastered the foundation.

If you are evaluating that step, tell us which system you use for accounting today and which processes are entered twice. That shows whether it makes sense to consider Oracle NetSuite or Oracle Fusion Cloud, or whether it isn't time yet. At www.ceteris.mx/guia-excel-a-erp/ there is a guide (available in Spanish) for those coming from spreadsheets.

Facing something similar?

Tell us which system you run and what it can't do for you today. The first conversation is about understanding your situation.

Request an assessment
Cover of the CETERiS guide From Excel to ERP (in Spanish)

Free guide · 24 pages · In Spanish

From Excel to ERP: how to tell if it's time

What we'd tell you in a first assessment meeting, in writing: how to know whether you need an ERP, what it costs in estimated ranges and how to migrate without disrupting operations. Currently available in Spanish; English edition coming soon.

  • The 7 signs you've outgrown spreadsheets
  • What an ERP costs and what drives the price
  • The 5 most expensive mistakes
  • A checklist to decide whether it's time
Download the guide (Spanish)Free. Delivered to your inbox.