Trading businesses / Finance, stock & cash
Your Sales Report Shows Profit. Your Bank Balance Tells Another Story. Why?
The orders are coming in. The margin looks healthy. Yet paying suppliers still feels uncomfortable. One fictional trading business shows how profit can grow while cash runs down.
By the Craft Interactive team · Published
Why can a profitable business be short of cash?
Profit measures revenue earned less the related costs and expenses. Cash flow measures money actually received and paid. Customers may still owe you, stock may absorb funds before it sells, and supplier payment dates may arrive before customer collections.
There is one more distinction worth making: a sales dashboard may show gross profit, not the profit left after operating expenses. Neither figure, on its own, tells you how much money is available in the bank.
To see the difference, let’s follow one month at a fictional UAE trading company, Harbour Tools Trading, which supplies maintenance tools and consumables to business customers.
Meet Harbour Tools Trading
Harbour Tools starts the month with AED 100,000 in the bank and AED 80,000 of stock at cost. It has no opening customer receivables or supplier payables. Together, those opening assets are funded by AED 180,000 of equity.
The business buys more stock, delivers goods to customers and offers credit terms on some sales. Its simplified month looks like this:
| What happens during the month | AED |
|---|---|
| Sales earned, delivered and invoiced | 200,000 |
| Cost of the stock sold | 140,000 |
| Operating expenses incurred and paid | 30,000 |
| Customer receipts against those sales | 90,000 |
| Stock purchased and received, at cost | 160,000 |
| Payments to suppliers against those purchases | 140,000 |
Harbour Tools and every figure in this article are fictional. Amounts are in AED. To isolate working capital, the example excludes VAT, taxes, depreciation, interest, stock write-downs, capital expenditure, borrowing and owner transactions. It assumes no other transactions and no opening unpaid expenses. Real accounts may include all of these items.
The sales report looks encouraging
Harbour Tools sold goods for AED 200,000. The stock it sold cost AED 140,000, so its gross profit is AED 60,000—a 30% gross margin on sales.
| Simplified profit calculation | AED |
|---|---|
| Sales revenue | 200,000 |
| Less: cost of goods sold | (140,000) |
| Gross profit | 60,000 |
| Less: operating expenses | (30,000) |
| Profit for the month in this simplified example | 30,000 |
If the owner only checks a sales report showing gross profit, AED 60,000 may look available to spend. It is not. Operating expenses already reduce that figure to AED 30,000, and the timing of cash receipts and payments creates another difference.
Here, revenue is earned when the goods are delivered and the sale is recognised—not when the customer eventually pays. A sales order or quotation alone is not the earned revenue used in this example.
The bank account tells a different, equally valid story
Only AED 90,000 reached the bank from customers during the month. Meanwhile, AED 140,000 went to suppliers and AED 30,000 went towards operating expenses.
| Bank movement | AED |
|---|---|
| Opening bank balance | 100,000 |
| Add: customer receipts | 90,000 |
| Less: supplier payments | (140,000) |
| Less: operating payments | (30,000) |
| Closing bank balance | 20,000 |
AED 200,000Sales earned
AED 30,000Profit for the month
AED 20,000Closing bank balance
The business made a profit, yet its bank balance fell by AED 80,000. Those statements do not contradict each other. The explanation sits in receivables, inventory and supplier credit.
Where did the cash go?
1. AED 110,000 is still with customers
Sales of AED 200,000 minus receipts of AED 90,000 leave AED 110,000 in accounts receivable. This is money customers owe Harbour Tools, not money already available to pay its bills.
Outstanding does not automatically mean overdue. Some invoices may still be within agreed terms. The owner needs due dates and collection expectations, not just a total unpaid balance.
For example, if customers had paid another AED 40,000 before month-end, the closing bank balance would have been AED 60,000 and receivables AED 70,000. Profit would still be AED 30,000: collecting an existing invoice does not create the sale a second time.
2. Another AED 20,000 is tied up in stock
Harbour Tools started with AED 80,000 of inventory, received purchases costing AED 160,000 and sold goods costing AED 140,000.
AED 80,000 + AED 160,000 − AED 140,000 = AED 100,000Opening stock + purchases received − cost of goods sold = closing stock at cost
Closing inventory is therefore AED 100,000: an increase of AED 20,000. That increase is additional stock investment. Unsold goods remain an asset in this example; their purchase cost does not all become an expense immediately.
This is why the AED 160,000 purchase figure is not deducted in full in the profit calculation. The expense is the AED 140,000 cost of goods sold. Deducting both purchases and cost of goods sold would count costs twice.
3. Suppliers are temporarily funding AED 20,000
Harbour Tools bought AED 160,000 of stock and paid AED 140,000, leaving AED 20,000 in accounts payable. That supplier credit cushions the cash outflow for now, but it remains an obligation.
If Harbour Tools had settled the additional AED 20,000 within the month, its closing bank balance would have been zero. Profit would remain unchanged under the example’s assumptions.
The complete profit-to-cash bridge
| Reconciliation for the month | AED |
|---|---|
| Profit | 30,000 |
| Less: increase in receivables | (110,000) |
| Less: increase in inventory | (20,000) |
| Add: increase in supplier payables | 20,000 |
| Net operating cash movement in this example | (80,000) |
Add that negative AED 80,000 movement to the opening bank balance of AED 100,000 and the result is AED 20,000. The cash has not disappeared: more of the business’s resources now sit in customer balances and stock, partly financed by suppliers.
A final balance check: the business still balances
At month-end, Harbour Tools has AED 20,000 in the bank, AED 110,000 of receivables and AED 100,000 of inventory. Total assets are AED 230,000.
Those assets are funded by AED 20,000 owed to suppliers and AED 210,000 of equity: the opening AED 180,000 plus the AED 30,000 profit. The arithmetic balances even though liquidity has tightened.
Inventory and receivables can support future cash generation, but they are not interchangeable with cleared bank funds. Customers may pay late, and some items may take longer to sell than expected.
What should Harbour Tools change next month?
Follow receivables by due date and likely collection
Instead of asking sales to “collect faster,” the owner should review the AED 110,000 invoice by invoice. Which payments are due soon? Which are overdue? Which depend on a delivery document, dispute resolution or customer approval?
Assign a follow-up owner and record realistic collection dates. A customer promise belongs in the forecast; it should not be treated as money already in the bank.
Buy against demand, not just supplier discounts
The AED 20,000 stock increase deserves a closer look. Is it a sensible buffer for confirmed demand, or slow-moving stock bought to reach a discount threshold?
Review quantities, movement and committed orders before replenishing. Cutting every purchase can damage availability, while buying more of the wrong stock can intensify the cash problem. Reducing a planned payment is also different from selling stock already on the shelf.
Match the payment calendar to the collection calendar
Put supplier due dates beside expected customer receipts. Supplier credit is useful working-capital support, but overdue payments are not a sustainable substitute for a plan.
If the AED 20,000 payable falls due before major customers pay, Harbour Tools needs to resolve that timing gap. Options should be assessed against actual terms and commitments, rather than assuming next month’s sales will cover everything.
Build a weekly cash forecast
Start with the AED 20,000 closing bank balance. Add expected receipts by week and subtract scheduled supplier, payroll, rent and other payments. Include taxes, loans, equipment purchases and owner transactions where relevant to the real business.
A rolling 13-week forecast is one practical planning horizon. Keep it separate from the historical cash flow report and update it as collection dates change. Test a delayed-collection scenario to see when a shortfall could emerge.
Five questions to ask at the weekly review
- What was earned? Review sales, gross profit and operating profit with consistent dates and definitions.
- What was collected? Compare expected customer payments with actual bank receipts.
- What is tied up? Review receivables and stock that is not moving as planned.
- What must be paid? Check supplier and other commitments against their due dates.
- What happens next? Refresh the cash forecast and assign actions for the largest timing gaps.
For Harbour Tools, the most useful conversation is no longer “Why does the bank disagree with sales?” It is “Which part of our working capital needs attention, and who will act?”
How connected ERPNext reporting helps explain the gap
Separate sales, warehouse and accounting files make this review harder. A connected ERPNext setup helps teams relate the underlying transactions, provided invoices, stock movements and payments are recorded and reconciled correctly.
| Business question | Report or view to review |
|---|---|
| Did we earn a profit after expenses? | Profit and Loss, rather than gross margin alone. |
| Which customers owe us, and when? | Accounts Receivable, including outstanding amounts and ageing. |
| What do we owe suppliers? | Accounts Payable and the upcoming payment schedule. |
| How much stock are we holding? | Stock balances and movement, with ageing reviewed against item demand. |
| Why did cash change? | Cash Flow and reconciled cash/bank records. |
The standard cash flow report explains historical movements across operating, investing and financing activities. A forward-looking weekly forecast may need a separate planning view or agreed custom report; it should not be presented as an automatic substitute for collection judgement.
We help trading businesses in Dubai and across the UAE define these reporting needs during ERPNext implementation. Where a team needs a specific collection worklist or forecast, we assess the configuration, reporting and customisation scope around its actual decisions.
Software can make the gap visible. Turning receivables and inventory back into cash still depends on customer follow-up, purchasing discipline and timely decisions.
Profit and cash flow: common questions
Can a profitable trading business run out of cash?
Yes. Receivables and inventory can absorb funds before customer payments arrive. Equipment purchases, debt repayments, taxes or owner withdrawals can also affect cash without matching the period’s profit in the same way.
Are unpaid sales invoices always overdue?
No. A receivable may be within agreed credit terms. Use the due date and ageing basis to distinguish outstanding balances from overdue amounts.
Does buying stock reduce profit immediately?
Not necessarily. In this example, unsold inventory remains an asset at cost, while the cost of sold stock is recognised as an expense. Write-downs and other adjustments can change the position in real accounts.
Does collecting an old invoice increase profit again?
No. If the sale was already recognised, collection increases cash and reduces the receivable. It does not recognise the same revenue a second time.
Is a sales report enough to manage cash flow?
No. Review it alongside expenses, receivables, stock, payables, reconciled bank records and a forward-looking payment and collection forecast.
See the business behind the bank balance.
If your sales, stock and accounting reports tell disconnected stories, we can help you trace the transactions and define a clearer reporting workflow in ERPNext. Bring a real month’s figures, and let’s start with the questions your team needs to answer.
Discuss your trading business workflow
hello@craftinteractive.ae · +971 56 259 8881
Further reading
The Harbour Tools example is an educational illustration, not a customer case study. Report interpretation depends on the transactions, accounting policies and data recorded in your business.
