How to Manage Sales, Inventory and Accounting in One System

Consolidation projects fail for boring reasons rather than technical ones. The software is usually capable; what goes wrong is loading data before deciding how it should be structured, and cutting over before proving the numbers agree. This guide is the sequence that avoids both, and it applies whichever platform you have chosen.

Step 1: Fix the data model before you import anything

This is the step people skip, and it is the one that determines whether consolidation actually delivers anything. Three decisions have to be made before a single record moves.

One customer record

Every function must point at the same customer. In practice this means merging duplicates first — the same company usually exists under several spellings across three systems, and importing them all recreates the problem in a new place. Decide the canonical name format, deduplicate in a spreadsheet, and only then import.

Each customer needs credit terms, a credit limit and a tax treatment attached at this stage, because these drive behaviour later: whether an order is blocked, when a receivable ages, how tax computes on an invoice.

One product record with one costing method

Choose weighted average or FIFO now and apply it consistently. Changing costing method later means restating stock valuation and therefore cost of goods sold, which is exactly the kind of correction auditors ask uncomfortable questions about.

Set the units at the same time: purchase unit, stock unit, sales units and their conversion factors. Products that need batch or expiry tracking must be flagged as such before any stock is loaded — retrofitting batch tracking onto existing stock is genuinely painful in most systems.

One chart of accounts, deliberately rebuilt

Do not import your old chart of accounts as-is. Most have accumulated accounts nobody uses and inconsistencies nobody has fixed. Migration is the only cheap opportunity you will get to clean it up.

Make sure it distinguishes the accounts an integrated system actually posts to: inventory as an asset, cost of goods sold, a goods-received-not-invoiced clearing account for stock received before the supplier bill arrives, and separate accounts for sales returns and discounts rather than netting them into revenue.

Step 2: Design the transaction chain

In an integrated system, documents convert into each other. Nothing is re-entered, and each step leaves the previous document visible as its source. Map your real process onto this chain before configuring anything.

The purchase side mirrors it: purchase order, goods receipt, purchase invoice, payment. The goods receipt is the step most businesses under-configure and the one that causes the most month-end pain — stock arriving before the supplier invoice needs somewhere to sit, and that is what the clearing account is for.

Step 3: Decide what happens at each conversion

Two configuration choices cause most of the confusion later, so make them consciously.

1. 1Does stock deduct at delivery or at invoice? Deduct at delivery if goods routinely leave before invoicing, which is normal in wholesale and distribution. Deduct at invoice only if the two always happen together.
2. 2Can an order be partially delivered and partially invoiced? For most goods businesses this must be yes. Confirm the remainder stays open and visible rather than being silently closed.
3. 3What blocks an order — credit limit, stock availability, or nothing? Decide, configure it, and tell the sales team, because they will find out either way.
4. 4Who can override a price, and is the override recorded? Overrides without an audit trail make margin analysis meaningless.
5. 5How are landed costs allocated on imports? If freight and duty do not reach product cost, every margin figure you report afterwards is wrong.

Step 4: Migrate in the right sequence

Order matters here. Each step depends on the one before it, and doing them out of sequence is how businesses end up with a trial balance that will not tie.

1. 1Pick a cutover date at the start of a financial period. Never mid-period.
2. 2Set up the chart of accounts, tax codes, warehouses and costing method in the new system. Nothing else.
3. 3Import master data: customers, suppliers, products with units and costing flags. Verify a sample manually before importing the rest.
4. 4Take a physical stock count as of the cutover date. This is non-negotiable — starting an integrated system with wrong stock quantities poisons every valuation and margin figure that follows.
5. 5Import opening stock quantities with their costs, and confirm the stock valuation report matches the inventory figure you intend to carry.
6. 6Import opening balances: trial balance, open customer invoices, open supplier bills. Prove the trial balance matches the old system to the cent before anyone posts a live transaction.
7. 7Run one full month in parallel, including a complete close with reconciliation and reporting. Not two weeks.
8. 8Reconcile the parallel month line by line. Any unexplained difference is a migration defect, and it is far cheaper to find now than in an audit.
9. 9Cut over, and keep the old systems read-only for at least a year.

Step 5: Prove it is genuinely integrated

After go-live, run these checks. They are the difference between a system that is integrated and one that merely has all three modules.

• ✓Post one sales invoice and confirm stock, cost of goods sold, revenue and the receivable all move in that single action — not overnight, not on a sync.
• ✓Confirm the stock valuation report agrees with the inventory balance on the balance sheet. If it does not on day one, it never will again.
• ✓Check that a quote shows available-to-promise stock, not just on-hand, so sales cannot promise committed goods.
• ✓Confirm margin is visible at the point of quoting, which is the only moment it can still be changed.
• ✓Take a return against a paid invoice and verify stock, credit note and customer ledger all update without a manual journal.
• ✓Close a month and see whether anything still waits on an export from somewhere else.

The mistakes that make consolidation fail

• ✓Importing data before deciding the structure. Cleaning it afterwards costs several times more.
• ✓Skipping the physical stock count. Every downstream number inherits the error.
• ✓Cutting over mid-period, which creates a split year you will explain at every audit for the life of the company.
• ✓Running parallel for two weeks instead of a full close. The problems live in month-end, not in daily transactions.
• ✓Migrating the old chart of accounts unchanged, and with it every inconsistency you had.
• ✓Not training the people who raise documents. An integrated system fails quietly when staff work around it, and you find out from the reports three months later.