Category: Accounting

A retail store owner rarely wakes up thinking “I need to implement an ERP”. The decision usually comes through pain: two times in a row, you didn’t have enough stock for a customer’s order. Or inventory revealed a 50,000 UAH shortage. Or your manager spent the third hour reconciling supplier invoices.

This post lists 5 concrete signs that your store has outgrown Excel and needs accounting software. If even 2 of them apply to you — this isn’t “someday later”, it’s “right now”.

1. Constant stock balance discrepancies

Typical situation: 15 units physically in stock. Excel says 20. Customer orders 18. Manager says “we have it” → takes the order → can’t ship → customer leaves for a competitor.

Discrepancies appear for three reasons:

• Not every write-off is entered into the spreadsheet immediately (especially when shop-floor and warehouse are different people)
• Re-entering data introduces typos and SKU mix-ups
• Excel isn’t linked to the POS — sold but not deducted, you find out a week later

What accounting software gives you: stock balances update automatically on every movement — sale, return, transfer, write-off. Manager sees actual quantity in real time. Reservation under an order — the system locks units already promised to a customer, so the “have it → don’t have it” mistake disappears.

More on tracking goods from receiving to sale in our post.

2. You don’t know where the goods disappear to

Inventory revealed a 30-unit shortage — where did they go? If your answer is “I don’t know”, that’s the second sign. In retail, goods disappear through four channels:

• Write-offs (defects, expired) — without proper accounting, written off “from memory”
• Theft (customers or staff) — needs tracking to identify
• Receiving errors (supplier sent 5 units short — wasn’t checked)
• Sales errors (cashier sold without putting it through the system)

Without separating these channels — you only see the integrated hole at month-end.

What accounting software gives you: separate documents for each movement type (Write-off, Inventory Count, Receiving, Sale). Each has its own report. Three months in, you see: “75% of losses come from write-offs of supplier N’s defects. Time to change suppliers”.

3. Do you know what sells best?

Test: name your top-5 products by profit for last month. Not by revenue — by margin profit (revenue minus cost). Not “approximately” — specific items with numbers.

If your answer is “I’d have to calculate” — that’s the third sign. You don’t have sales analytics.

Without analytics:

• You purchase blindly — what “seems to work”
• You hold non-selling goods on the shelf (frozen capital)
• You discount items that were already in shortage
• You miss that one item has a 5% margin while the one next to it has 35%

What accounting software gives you: ABC analysis (top by revenue, profit, turnover), margin by groups, sales dynamics over a period. In ERPJS — a “Sales per day / week / month” report filtered by category, supplier, sales point.

How it looks in practice — in the post “How an AI Agent Found a Sales Anomaly in 5 Seconds”: a real example of analytics surfacing the non-obvious.

4. How much time goes into supplier reconciliation?

Case: a supplier sends an invoice with 47 line items. You need to check: do prices match the agreement, does quantity match the order, are there items you didn’t order.

If done by hand (printout + Excel + calculator) — that’s three hours of your manager’s time. Calculation errors weekly. Item-code errors too.

What accounting software gives you: the supplier order is created in the system. When the invoice arrives, its data is entered (or imported from Excel/EDI), the system automatically compares to the order and shows discrepancies — by price, quantity, new items. Reconciliation time drops from 3 hours to 15 minutes.

5. How much routine does your manager have?

Check: how much time per week these tasks take your manager:

• Inventory counts (full or partial)
• Supplier reconciliations
• Preparing accounting reports
• Issuing invoices to customers
• Creating return documents

If the total is more than 8 hours a week — that’s a full work day that can be automated. In retail, these tasks are very templated: “generate a monthly sales report in the accountant’s format” should be one button, not two hours of Excel formatting.

What accounting software gives you: all standard documents are generated automatically from primary data. Instead of “producing paperwork”, the manager focuses on what they’re really for — customer negotiations, orders, analysis.

What accounting software gives you — in one list

If you boil down 5 signs to one outcome — accounting software for a retail store gives:

• ✅ Real-time stock balances — no discrepancies between POS and warehouse
• ✅ Movement control — visibility into where and why goods disappear
• ✅ Automatic sales reports — top items, margins, dynamics by day
• ✅ Fast supplier reconciliation — the system finds discrepancies for you
• ✅ Time saved on routine — the manager focuses on the business, not on calculations

ERPJS for retail stores

ERPJS is an ERP system for small business that gives a retail store 5 integrated modules:

• Inventory — receiving, transfers, counts, write-offs
• Sales & POS — POS interface, receipts, fiscalization via Checkbox
• Suppliers — orders, invoice reconciliation, price history
• Analytics & reports — ABC, margins, sales dynamics
• Hardware integration — barcode scanners, fiscal printers, scales

These modules work as one system — a sale at the POS automatically deducts from stock, posts to the cash book, records the margin for analytics. No need to shuffle data between tools.

When accounting software isn’t needed

Honestly: if your store is 1 location with 30-50 SKUs and 1-2 sales per day, full accounting software is over-engineering. Excel + a simple button-based POS will do.

Accounting software becomes worthwhile when:

• 100+ SKUs in the catalog
• 2+ employees handling goods
• 1+ sales channel besides the physical store (website, marketplace)
• Regular supplier reconciliations (at least weekly)
• You need to know margin per item, not just “overall profit”

If at least 3 of 5 — time to implement. A thematically close post on 5 signs your warehouse accounting isn’t working covers warehouse specifics; this one is about the store as a whole.

Frequently asked questions

Excel stock balances don’t match reality. The salesperson promises a customer an item that’s no longer in stock. Inventory again reveals a 10% shortage. If this sounds familiar — the problem isn’t people, it’s the accounting system. Proper product accounting isn’t just a spreadsheet with quantities, it’s a connected process from receipt to sale.

In this article, we’ll break down how product accounting should work in a real system: what documents you need, what FIFO is, how inventory counts, reservations, and serial numbers work — and how to transition from Excel.

Why Excel and paper notebooks fail at product accounting?

Excel is a spreadsheet; product accounting is a process. A spreadsheet doesn’t know that a shipment should automatically reduce stock, or that a return should restore it. As a result, every transaction is entered twice (or forgotten), and within a month, file balances no longer match reality.

Specific issues with running product accounting in Excel:

• No single source of truth. The salesperson has one spreadsheet, the warehouse manager another, the accountant a third. When numbers diverge — nobody knows which is correct.
• Cost calculated by guess. With different purchase prices for the same item, Excel won’t calculate real cost automatically. Selling at a profit or a loss — unknown.
• No movement history. An item “disappeared” — where? When? Who wrote it off? In Excel this is lost information; in ERP, it’s an audit trail for every unit.
• Reservations = promises from memory. A manager promises stock to one customer, then another. Excel doesn’t see this, and double-sells appear.
• Inventory counting — quarterly stress. The whole team is blocked, the store stops working, result — minus 10-15% with no explanation.

More on 5 typical signs that your accounting isn’t coping — in our separate article on warehouse accounting.

What is FIFO and why does a retail business need it?

FIFO (First In, First Out) is a cost accounting method where the oldest batch of goods is written off first when a sale occurs. It’s the standard for retail, warehousing, and manufacturing.

Example. You purchased the same item in three batches:

Batch	Quantity	Purchase price
1 (March 15)	100 pcs	$50
2 (April 1)	80 pcs	$55
3 (April 10)	120 pcs	$60

You sell 150 units. FIFO writes off: 100 pcs × $50 + 50 pcs × $55 = $7,750 cost. At a sale price of $70 × 150 = $10,500 revenue, gross profit is $2,750.

Without FIFO (or with manual calculation), you usually take “average price” — and get a distorted picture. In ERPJS, FIFO works automatically for every shipment and write-off — sorts batches by date, consumes sequentially, calculates proportional cost.

What documents do you need for proper product accounting?

In a proper accounting system, every operation is a separate document with its own status, author, and date. The minimum set is 8 document types:

1. Receipt. Incoming supply from a vendor. Increases stock, records purchase prices for FIFO.
2. Shipment. Outgoing delivery to a customer. Reduces stock, calculates cost by FIFO.
3. Transfer. Internal transfer between warehouses. Doesn’t change total quantity but records location.
4. Write-off. Item damaged, lost, used for internal purposes. Reduces stock with a stated reason.
5. Return to vendor. Defective or surplus batch. Reduces stock and liabilities.
6. Return from customer. Claim processing. Restores stock, returns cost.
7. Inventory count. Physical recount with discrepancy protocol.
8. Additional costs. Distribution of customs duties, delivery, packaging onto product cost.

Every document in ERPJS automatically updates registers: Product status (real-time stock across warehouses), Product history (full audit trail of every movement), and Serial number status (for items with unique identification).

How should inventory counting look in a normal system?

Inventory counting in Excel is a notepad where the warehouse manager writes down what was counted, and someone then manually reconciles with the spreadsheet. In a normal system, it’s a managed three-step process.

Step 1. Inventory sheet builder. You select the warehouse, date, and product categories — the system generates an empty sheet listing all items that should be in stock according to accounting records.

Step 2. Physical count. The warehouse manager (or barcode scanner) fills in actual quantities for each line. For large inventories, counting is split by zones and employees.

Step 3. Inventory comparison. The system automatically generates a discrepancy report: where there’s shortage, where there’s surplus, for what amount. Based on the report, write-off or receipt documents are created — stock is reconciled.

In ERPJS, this process takes hours instead of days — and gives exact numbers instead of “plus-minus 10%”. Another benefit — partial inventory: you can check one category or zone without stopping the whole warehouse.

How to reserve stock for a customer order?

Reservation is the difference between “item is in stock” and “item is available for sale”. You received an order for 50 units with shipment tomorrow — these 50 units must be reserved so another manager doesn’t sell them today.

In Excel, reservations lead to two problems: either nobody tracks them (and double-sales occur), or they’re tracked in a separate column everyone forgets to update.

In ERPJS, reservations are automatic:

• Customer places an order → system reserves the needed quantity with “reserved” status.
• Available stock for new sales = Physical stock − Reserved.
• After shipment, the reservation is released, stock is reduced.
• If the order is cancelled — the reservation automatically returns to available stock.

The “Shortage” report shows how much stock is missing to fulfill all active orders — and needs to be reordered. This is especially useful for stores with pre-orders and online sales, where 1-3 days pass between order and shipment.

How do serial numbers help in service and retail?

Serial numbers are needed where every unit is unique: electronics, appliances, auto parts, warranty-covered furniture. ERPJS tracks serial numbers as a separate accounting layer: for every number, you can see when it arrived, from which vendor, at what price, when and to whom it was sold.

Practical use cases:

• Warranty. Customer brings an item with a claim — by serial number, you see when it was sold and whether warranty is still active.
• Batch recall. Vendor reports a defect in batch #X — you find all customers who bought items from that batch in seconds.
• Service intake. The technician receives a device for repair — the serial number is already in the database with full history.
• Theft prevention. Every unit has a unique ID — writing it off “into the shadows” is harder.

How to transition from Excel to product accounting software?

You don’t have to transition in one day. For a store or warehouse with up to 1,000 SKUs, a realistic plan is 2-3 weeks:

Week 1. Reference data. Upload the product catalog (units, categories, barcodes), counterparties (vendors, customers), and warehouses. ERPJS supports Excel import, so existing data doesn’t need manual entry.

Week 2. Starting balances and current operations. Run inventory, enter real balances into the system. From this point, run all receipts and shipments through the new system, in parallel with Excel.

Week 3. Full switchover. After a week of parallel work, compare reports. Usually at this stage, it’s already clear where Excel had “gaps”. Turn off Excel for current accounting, keep only as an archive.

How to choose an accounting system that fits your business — see our guide with 7 selection criteria. And for how product accounting affects financial results, see our article on financial accounting.

Frequently asked questions

Inventory management software becomes essential when Excel spreadsheets can no longer handle stock levels, mix-ups, and stocktaking. Research shows that businesses without automated inventory management lose up to 5% of goods due to manual tracking errors. Here are 7 criteria to help you choose the right software.

When does Excel stop working for inventory?

Excel breaks down when you have more than 200-300 SKUs and 30-50 daily transactions. Three main symptoms:

• Mix-ups. The product exists but it’s the wrong one — positions, sizes, colors get confused. Customer ordered one thing, received another.
• Unknown stock levels. To know how much is in stock, you need to physically count. The spreadsheet says 50 units, reality shows 37.
• Stocktaking nightmare. Two days of manual counting, printing lists, reconciling with the spreadsheet. After stocktaking — another day fixing discrepancies.

If you recognized even one point — it’s time to look for software. More signs: 5 Signs Your Inventory Management Isn’t Working.

What 7 criteria matter when choosing inventory software?

Not all software is equal. Here’s what to pay attention to:

1. Real-time stock levels

Basic requirement — see current stock for every product at any moment. Not “as of yesterday”, but right now. In ERPJS, stock levels update instantly with every operation — sale, purchase, or write-off.

2. Mobile stocktaking

Stocktaking should take hours, not days. Look for software with a mobile scanner — scan the barcode, the system compares with records, discrepancies are visible immediately. In ERPJS, stocktaking a warehouse with 500 items takes 2-3 hours instead of 2 days.

3. Serial numbers and batches

If your products have serial numbers (electronics, equipment) or expiration dates (food, medicine) — the software must support this. Without it, you can’t track a specific unit.

4. Receipts and shipments with documents

Every product movement must be documented: receiving note, shipping note, write-off act. This is the foundation for accounting and tax reporting.

5. Financial integration

Inventory without finances is half the picture. The software should calculate product cost, margin on each sale, total inventory value. In ERPJS, inventory management is linked to management accounting — P&L, balance sheet, and cash flow account for inventory operations automatically.

6. Multi-warehouse

If you have more than one warehouse (or warehouse + store + production) — the software must support transfers between locations and show stock per warehouse.

7. Cloud or on-premise?

Cloud software — access from any device, no installation, automatic updates. On-premise — full data control, works offline. ERPJS supports both: cloud for convenience, on-premise for those who want to control their data.

Comparing types of inventory management software

There are three main types of solutions on the market. Here’s a comparison for a typical store with 500-1000 products:

Criteria	Excel	Legacy (1C/SAP)	Cloud ERP (ERPJS)
Real-time stock	No — manual updates	Yes	Yes
Mobile stocktaking	No	Requires add-on	Yes, from phone
Cost & margin	Manual formulas	Yes, complex setup	Automatic
Mobile access	Inconvenient	No (or via RDP)	Yes, browser
Cost	Free	License + implementation	From free
Implementation time	0	1-3 months	1-2 weeks
Open source	—	Partially	Yes (ERPJS)

More on transitioning from Excel: Excel vs ERP: When Spreadsheets Stop Working.

What to check when testing?

Before choosing software — test it with real data. Three tips:

1. Upload your products. Check if CSV/Excel import works. If loading 500 products takes more than an hour — that’s a problem.
2. Try typical operations. Receiving goods, making a sale, processing a return, transferring between warehouses. How many clicks? Is it intuitive?
3. Do a test stocktake. This is the best test — if stocktaking is convenient, everything else will work.

How does inventory management work in ERPJS?

ERPJS inventory management covers all 7 criteria from this article. Real-time stock, mobile stocktaking, serial numbers, documents, financial integration, multi-warehouse — all in one system.

The main advantage — inventory is integrated with sales, purchasing, and financial accounting. Sold a product — stock updated, cost deducted, revenue recorded. No need to duplicate data between different programs.

Free plan with no time limits — enough for testing and getting started.

FAQ

Small business accounting in ERPJS starts with three steps: products in stock, cash flow, and client database. First results — in 2 weeks. No accountant needed, no Excel — just a system that works for you.

80% of small businesses track their accounting “in their head” or in Excel. While you have 10-20 transactions a day, it works. But as the business grows, chaos begins: products are in stock but can’t be found, money comes in but profit is unclear, customers return but you don’t remember their history.

Why do small businesses avoid proper accounting?

Three main reasons: fear of complexity, the belief “we’re still too small for ERP,” and the habit of using Excel. In reality, each of these reasons is a mistake that costs money.

“It’s too complex” — modern accounting systems don’t require a bookkeeping degree. In ERPJS, basic setup takes 1-2 hours: add products, set prices, connect your cash register.

“We’re still too small” — small businesses actually suffer the most from lack of accounting. Large businesses have a CFO and accounting department. Small businesses have an owner who simultaneously sells, purchases, and counts money. Without a system, they lose control first.

“Excel is enough” — up to a point. When you have 500+ products, 3+ employees, and 50+ transactions per day — Excel stops working. Formulas break, files get lost, data doesn’t sync.

What 3 things should you track first?

Don’t try to automate everything at once. Start with three basics — this is enough for 90% of small businesses.

1. Products and services

What’s in stock, what it costs, what price you sell at. This is the foundation — without it, you don’t know your stock levels or margins. ERPJS inventory management includes receiving, shipping, stocktaking, and serial numbers. Adding 100 products takes 30-40 minutes.

2. Money (cash + bank)

Where money came from and where it went. This is Cash Flow — the most important report for a small business. If you don’t know your Cash Flow, you’re not managing the business — the business is managing you. In ERPJS, cash movement is recorded automatically with every payment.

3. Clients

Who buys, how often, for how much. Even a simple client database gives insight: who are your best customers, who hasn’t returned in a while, who needs a reminder. In ERPJS, the CRM module is built-in — no separate software needed.

How to start accounting in 2 weeks?

A step-by-step plan, tested with dozens of small businesses. No need to dedicate entire days — 1-2 hours per day is enough.

Week 1 — products and prices:

1. Day 1-2: Register in ERPJS, create your company, set up warehouse
2. Day 3-4: Add products/services (name, purchase price, selling price)
3. Day 5: Run initial stocktaking (enter current quantities)

Week 2 — finances and reports:

1. Day 1-2: Set up cash register and bank account
2. Day 3-4: Start entering transactions (sales, purchases, payments)
3. Day 5: Check your first report — Cash Flow and stock levels

After 2 weeks, you have a working system: real-time stock visibility, clear cash flow picture, and a client database.

How is ERP different from Excel for small business?

An ERP system automates what you’d do manually in Excel. Here’s a concrete comparison for a typical store with 500 products:

Task	Excel	ERPJS
Check product stock	Find file → find row (2-5 min)	Search by name (5 sec)
Process a sale	Manual: deduct from stock + record payment (3-5 min)	One document: stock + cash auto (30 sec)
Monthly report	Build formulas, verify (2-4 hrs)	One click (instant)
Find client debt	Search through files (5-10 min)	Client card (3 sec)
Stocktaking	Print list → manual count → enter (1-2 days)	Mobile scanner → reconcile (2-3 hrs)

More on transitioning: Excel vs ERP: When Spreadsheets Stop Working

How much does small business accounting cost?

From $0 to €50 per month — depending on scale. ERPJS has a free plan with no time limits: 1 user, 512 MB storage. This is enough for a sole proprietor or micro-business with 1-2 employees.

When to upgrade to paid? When you need:

• 3+ users (salesperson, warehouse worker, bookkeeper) — from €30/month
• More storage for product photos and documents
• Management reporting: P&L, balance sheet, analytics by business unit

Frequently Asked Questions

Most business owners track management accounting in Excel. First it’s one spreadsheet, then ten, then chaos: broken formulas, file versions, and manual data copying. Sound familiar?

Automating management accounting isn’t about million-dollar ERP implementations. It’s about seeing the real picture of your business without spending hours in spreadsheets every day.

What is management accounting and why automate it?

Management accounting is a system for collecting and analyzing financial data to make business decisions. Unlike statutory accounting (required by law), management accounting is for you.

Three key reports:

• P&L (Profit & Loss) — how much you earned, how much you spent, what’s the profit
• Cash Flow — where money came from, where it went
• Balance Sheet — what the company owns, what it owes

When these reports are prepared manually, they’re always late and often contain errors.

5 signs Excel is no longer enough

1. Reports take a week after month-end close — decisions are based on outdated data
2. Formulas break — someone accidentally changed a formula, and numbers don’t add up
3. Multiple file versions — the accountant has one set of numbers, the CFO has another
4. Manual data entry — data from the bank, from legacy systems, from CRM is copied by hand
5. No drill-down analytics — can’t quickly check profitability by client, project, or product

What does automation give you?

Real-time reports

P&L, Cash Flow, Balance Sheet — generated automatically from entered transactions. Not in a week — now.

Single source of truth

All data in one system. The accountant, CFO, and owner see the same numbers.

Multi-dimensional analytics

Profitability by client, project, or business unit — without manual work.

Control points

Cash reconciliation, inventory checks, counterparty reconciliation — the system reminds and helps you stay in control.

How to start automating?

You don’t need to automate everything at once. Start with three steps:

1. Define your chart of accounts — which accounts do you need (cash, bank, inventory, receivables, payables)
2. Start entering transactions — at minimum, cash movements. Even this alone gives you a Cash Flow picture
3. Set up reports — P&L and Balance Sheet. Verify: balance = financial result minus withdrawals

The key rule: identical events must be recorded identically. This is your accounting policy — the foundation of reliable accounting.

Why not QuickBooks or SAP?

For small and medium businesses, three things matter:

• Simplicity — no specialist needed for daily operations
• Price — free plan to start, no hidden fees
• Accessibility — runs in the browser, no installation, access from any device

ERPJS is a management accounting system that combines finance, inventory, CRM, and manufacturing in one solution. Free plan with no time limits.

FAQ

Can you do management accounting in Excel?

Yes, but only up to a point. When you have more than 50-100 transactions per month, Excel starts creating more problems than it solves: formula errors, file versioning issues, and no real-time analytics.

How much does management accounting automation cost?

From free (ERPJS free plan) to millions (SAP, Oracle). For small businesses, starting with a free solution and scaling as needed is optimal.

What’s the difference between management and statutory accounting?

Statutory accounting is for tax reporting as required by law. Management accounting is for business decisions: what’s your margin, cash flow, asset balance. These two systems can and should exist in parallel.

You don’t know exactly how much stock you have in your warehouse. You know approximately. And that “approximately” costs your business money every month — on unnecessary purchases, lost sales, and inventory that vanished without a trace.

If you recognise yourself in at least three of the five signs below, it’s time to change your approach to inventory management. Inventory management is a system for tracking the movement of goods and materials: receiving, transfers, write-offs, and shipments. Without it, your business operates blind.

Why do Excel and notebooks fail at warehouse management?

Excel works for tracking 20-30 items when one person is responsible. As soon as you add a second warehouse worker, two shifts, or 100+ SKUs, problems begin. Someone forgot to enter data, someone overwrote a formula, someone is working with yesterday’s version of the file.

Studies show that manual inventory tracking leads to 8-15% discrepancies between actual stock and records. For a business turning over 500,000 UAH/month, that’s 40,000-75,000 UAH in “invisible” losses.

Key problems with Excel-based warehouse accounting:

• No change history — who changed what and when is unknown
• Impossible for two people to work simultaneously
• No automatic stock recalculation after each operation
• No link to documents (delivery notes, acts)

Read more about comparing approaches in Excel vs ERP: When Spreadsheets Stop Working.

Sign 1 — You don’t know your real stock levels right now?

If answering “how much of product X do we have in stock?” requires physically going to count — that’s the first and most obvious sign of a problem. In proper inventory management, the answer takes 5 seconds: open the system, see the number.

When stock levels are unknown in real time, businesses face two consequences:

• Unnecessary purchases — buying what you already have because you can’t see current stock
• Lost sales — promising a customer a product that’s actually out of stock

In ERPJS, stock levels update automatically after every operation — receiving, dispatch, transfer. No manual counting needed.

Sign 2 — Does stocktaking bring surprises?

A difference of more than 5% between “on paper” and “in reality” after stocktaking is a serious red flag. It means errors have been accumulating for months without anyone noticing. Often it’s theft, mix-ups, or simply unrecorded write-offs.

Regular stocktaking isn’t just “count everything once a year.” It’s a control tool that should run monthly or even weekly for critical items.

In ERPJS, stocktaking is a separate document: you enter actual quantities, the system compares them with recorded figures and generates a discrepancy report. The entire process takes an hour instead of a full day.

Sign 3 — Has product mix-up become routine?

Shipping the wrong product to a customer because items got confused in the warehouse isn’t just a mistake — it’s lost trust and direct financial losses: returns, re-shipping, compensation. If this happens more than once per 100 shipments, the problem is systemic.

The root cause is lack of clear product identification. When a warehouse worker relies on memory instead of scanning a barcode or checking an SKU in the system, mistakes are inevitable.

An accounting system solves this at the process level: every shipment is linked to specific items with SKUs, serial numbers, and specifications.

Sign 4 — You don’t know the true cost of your products?

Cost isn’t just the purchase price. It’s procurement + shipping + customs + storage + handling. If you calculate profit as “sold for 1000, bought for 600, earned 400,” you’re likely missing 30-40% of real expenses. This means your management accounting is showing an illusion of profit.

Automatic cost calculation in ERPJS accounts for all components: from purchase price to logistics costs. You see the real margin on each product and can make decisions based on facts, not intuition.

Sign 5 — Write-offs and returns go unrecorded?

Stock disappearing from the warehouse without a document is a black hole in your accounting. Broken, expired, returned by a customer, used internally — if it’s not recorded, discrepancies at stocktaking are guaranteed. And you won’t be able to explain to auditors where the goods went.

Every warehouse operation must be documented: write-off act, return act, transfer act. In an inventory management system, this takes a minute — select the operation type, specify items, confirm.

What to do if 3+ signs match?

If you recognised yourself in three or more points, it’s time to move from manual tracking to a system. Here’s a concrete 2-week plan:

1. Week 1: Stocktaking. Count everything in your warehouse. Record actual quantities. This is your “point zero.”
2. Week 1: Enter stock levels. Upload quantities into the accounting system. In ERPJS, you can import from an Excel file.
3. Week 2: New rules. Every warehouse operation goes through the system. Receiving, shipping, write-offs, returns — everything is recorded.
4. Week 2: Verification. At the end of the week, compare system quantities with reality. Discrepancy should be minimal.

ERPJS lets you start for free: inventory management, stocktaking, product tracking — all available on the free plan.

Get your warehouse in order
ERPJS is a management accounting system with a complete inventory module: real-time stock levels, stocktaking, cost tracking, goods movement. Free plan with no time limits.

Try it free

There’s money in the account. Orders keep coming. Clients are paying. Everything seems fine. But at the end of the month, there’s not enough for salaries, rent, or restocking. Sound familiar?

Most small business owners don’t know their real profit. Not because they’re lazy, but because they confuse revenue with profit, don’t account for all expenses, or simply lack a convenient tool for tracking. In this article, we’ll break down 5 common mistakes and show how to fix them.

5 Mistakes That Hide Your Real Profit

1. Confusing revenue with profit

The most common mistake. You received 50,000 this month — and it feels like the business earned 50,000. But that’s revenue, not profit. From that amount, you need to subtract the cost of goods, salaries, rent, taxes, logistics, advertising, and utilities.

Real profit is often 5–10 times less than revenue. Sometimes it’s even negative — while there’s still cash in the account.

2. Not fully accounting for cost of goods

Bought an item for 10, sold it for 20 — seems like you earned 10. But did you account for shipping to your warehouse? Storage? Packaging? The manager’s time processing the order? Returns and defects?

Without full cost accounting, you’re seeing a “gross” margin that could be 2–3 times higher than the real one.

3. Forgetting fixed expenses

Rent, salaries, software subscriptions, accountant fees, bank charges — these costs exist every month, regardless of sales. When you estimate profit “by feel,” it’s easy to undercount or forget them.

Then you wonder: sales are up, but there’s less money. Because fixed costs ate up all the growth.

4. Mixing business and personal money

A classic small business problem: the owner takes cash from the register for personal needs, then puts personal money back into the business. After a month, it’s impossible to tell how much the business earned versus how much was spent personally.

This isn’t a moral issue — it’s an accounting issue. Without clear separation, you’ll never see the real picture.

5. Checking profit once a year (not monthly)

Some owners only learn their profit when the accountant files the annual report. But by then it’s too late to change anything — the year has passed, mistakes were made, money was spent.

Management accounting isn’t an annual tax report. It’s monthly (ideally weekly) reporting for yourself.

Why This Is Dangerous

So what if you don’t know your exact profit? Problems start when decisions are based on inaccurate data:

• You hire a new employee because “sales are growing” — but the margin doesn’t actually cover their salary
• You open a second location because “the first one is profitable” — but it’s barely breaking even
• You offer discounts because “we can afford it” — but cost of goods has already eaten the margin
• Cash flow gap — client payments arrive in 30 days, but salaries are due tomorrow

Without clear numbers, every business decision is a gamble.

What Is Management Accounting and Why You Need It

Management accounting is a system of tracking for the owner, not for the tax office. Tax accounting answers “how much tax to pay.” Management accounting answers “how much am I earning and where is the money going.”

Sounds complex? It’s really not. At a basic level, it’s three reports:

Report	What it shows	In plain terms
P&L (Profit & Loss)	Revenue minus expenses for a period	How much you earned/lost this month
Cash Flow	Where money came from and where it went	Why there’s cash but no profit (or vice versa)
Balance Sheet	What the business owns and owes	The big picture on a specific date

You don’t need to be an accountant to read these reports. You just need a system that collects data automatically.

How to Get Your Finances in Order in 4 Steps

Step 1. Define what you’re tracking

Before counting anything, you need to understand — what exactly to count. Products? Services? Projects? Orders? This determines your accounting structure. Start with understanding what your business needs to track — it will save time and frustration. Also consider what exactly your business should track — this determines your entire accounting structure.

Step 2. Consolidate all expenses in one place

Rent, salaries, purchases, advertising, logistics — everything should go into one system. Not three different Excel files, not a notebook, not “in your head.” One system — one source of truth.

Tip: start with fixed expenses (they don’t change monthly) and add variable costs gradually.

Step 3. Set up regular reporting

A P&L report once a month is the minimum. Ideally — every week. It shouldn’t take an hour: if data is entered consistently, the report generates in seconds.

The key: reports should be generated automatically from already-entered data, not assembled manually from multiple sources.

Step 4. Automate the routine

Manually entering every payment, every transaction, every inventory movement — that’s a guarantee of errors and lost motivation. Automated financial accounting frees your time for decisions, not data entry.

Automation isn’t “someday later.” It’s what makes accounting sustainable. Without it, even the best system gets abandoned within a month.

Why Excel Won’t Help Here

We covered this in detail in our previous article. In short: Excel has no business logic, doesn’t link operations together, doesn’t generate reports automatically, and doesn’t scale. For basic calculations — yes. For management accounting — no.

Conclusion

Not knowing your real profit isn’t something to be ashamed of. Most small businesses start without proper accounting, and for a while that works. Problems begin when the business grows but management stays at the “seems fine” level.

Management accounting isn’t complex science for large corporations. It’s a simple tool that answers the most important question: how much am I really earning?

Ready to see the real picture?
Try ERPJS for free — set up basic accounting and see your real profit within the first month.
Try for free →

Sound familiar? Your business is growing, Excel files keep multiplying, formulas break, and data across different spreadsheets never quite matches up. Your accountant spends half a day just to compile a monthly report. And you, the owner, can’t quickly answer a simple question — how much did we actually earn this month?

Excel is a great tool. But it was built for calculations, not for running a business. When the volume of operations grows, spreadsheets turn from a helper into a problem. In this article, we’ll look at when that moment comes — and what to do about it.

7 Signs That Excel Is No Longer Enough

If you recognize at least three of these — it’s time to think about a change.

1. Data diverges across files

Every manager has their own copy of the spreadsheet. Inventory in one file, sales in another, finances in a third. Totals never match on the first try, and every time you need a manual reconciliation.

2. Monthly reports take 2+ days to compile

Manual copying from multiple files, checking formulas, fixing errors. What should take an hour stretches into days. And by the time the report is ready — the data is already outdated.

3. Inventory doesn’t match reality

Sold an item — forgot to subtract from stock. Returned an item — didn’t add it back. Ran an inventory check — discrepancies in the thousands. Without automated inventory management, this problem only grows month after month.

4. You can’t see real profitability

Revenue is not profit. Cash in the account is not profit. But in Excel, these concepts often get mixed up. To see the real picture, you need management accounting — not another pivot table.

5. The file has become “sacred” — nobody dares touch it

Complex formulas, macros, cross-references between sheets. One person knows how it works. If they’re on vacation or quit — nobody understands what’s going on.

6. No change history

Someone deleted a row — and nobody knows who or when. No versioning, no audit trail. If an error is discovered a month later — finding its source is nearly impossible.

7. Can’t work simultaneously

One employee opens the file — another waits or creates a copy. Then copies multiply, and it’s unclear which version is current. Google Sheets partially solves this, but creates new problems.

What Excel Can and Can’t Do

Let’s be fair — Excel has its strengths. Problems begin when you demand things it wasn’t designed for.

Criterion	Excel	ERP System
Getting started	Instant, free	Initial setup required
Simple calculations	Perfect	Overkill
1 user	Fine	Fine
5+ users	Version chaos	Single database
Inventory tracking	Manual, error-prone	Automated
Financial overview	Separate unlinked sheets	End-to-end analytics
Scaling	Dead end	Add modules as needed
Data security	File on someone’s desktop	Roles, permissions, backups

Excel is a calculation tool. ERP is a business management system. You don’t need to replace Excel entirely — you need to understand which processes have outgrown it.

“What About Google Sheets?”

Fair question. Google Sheets solves the collaboration problem — multiple people can edit simultaneously. But it doesn’t solve the core issues:

• No business logic — the chain “order → inventory → payment → profit” doesn’t work automatically
• No automatic transactions — every operation must be entered manually
• No record-level access control — it’s either access to everything or nothing
• Same formula and scaling problems remain

Google Sheets is a more modern Excel, but not a replacement for an accounting system.

What the Transition to ERP Looks Like

The biggest fear: “we’ll drop everything and be in chaos for a month.” In reality, the transition is a gradual process.

Step 1. Audit

What’s currently tracked in Excel? Which processes are critical? What hurts the most? Usually it’s either financial accounting, inventory, or payment tracking. Start with understanding what your business actually needs.

Step 2. Pilot

Start with one process. For example, only financial accounting or only inventory. Don’t try to migrate everything at once.

Step 3. Data migration

Import your reference data — products, customers, balances. Most ERP systems have Excel import tools. Your spreadsheets won’t disappear — they become the source for migration.

Step 4. Expansion

Add new modules as you get comfortable. First accounting, then inventory, then orders. No need to buy everything upfront.

Realistic timeline for basic accounting: 2–4 weeks. Not months, not years.

What to Look for When Choosing an ERP

The ERP market is large. Here are 5 criteria worth checking before you choose:

1. Accounting as the core, not an add-on

Many systems position themselves as CRM with “bonus” accounting. But if your main problem is financial chaos and inventory discrepancies, you need a system where accounting is the foundation — not a secondary feature.

2. Cloud or on-premise — your choice

Not every business is ready to store data on someone else’s servers. Ideally, the system offers both options: a cloud solution for a quick start and the ability to move to your own server when you’re ready.

3. Open source

If the vendor doubles the price next year — what will you do? If you need a custom modification — how much will it cost? Open-source business logic means you’re not locked into a single vendor.

4. Affordable start

It’s great when you can start for free or at a minimal cost. This gives you time to learn the system without financial risk. “$500/month minimum” for a small business isn’t a starting point — it’s a barrier.

5. Support and partners

Being left alone with a new system is a recipe for failure. It’s important to have support, documentation, and ideally a partner network that can help with implementation.

Conclusion

Excel was the right first step. Every business starts with spreadsheets. But as your business grows, your tools need to grow with it.

If you recognized three or more of the 7 signs — it doesn’t mean you’re doing something wrong. It means your business has outgrown its current tools and is ready for the next level.

Ready to see the difference?
Try ERPJS for free — migrate one process from Excel and compare in a week.
Try for free →