Services · Finance

Financial analysis — turning numbers into sharper decisions.

Ratio and margin analysis, cash flow and receivables reviews, break-even modelling and cost variance — turning the same set of books into decisions you can act on.

Financial Reporting Power BI Xero Advisor

Credentials

Professional Certifications

guide & resources

Finance Guide for Business Owners

Bookkeeping tells you what happened; finance tells you what it means. Three ideas separate an owner who reads their numbers from one who is surprised by them — the gap between profit and cash, the ratios that reveal health, and the reporting standard that applies to your size.

01 / Fundamentals
Profit Is Not Cash

A profitable month can still run out of money. Profit is recognised when you invoice; cash arrives when the client pays. The distance between them is where small businesses fail.

1Revenue — recognised when earned/invoiced
2Receivables — earned but not yet collected
3Cash — what actually landed in the bank
4Working capital — cash tied in stock & AR
the trap
CV Solusi Digital below booked Rp180 jt of revenue but is still owed Rp72 jt. On paper it's thriving; in the bank it depends on collections. Every case here is read through this lens first.
02 / Reference
Core Financial Ratios

Five numbers that turn a stack of transactions into a health check. The targets are rules of thumb for Indonesian SMEs — the direction matters more than the decimal.

Ratio Healthy
Gross margin> 40%
Net margin> 10%
Current ratio> 1.5×
Collection (DSO)< 30 days
Inventory turnover> 6×/yr
Read together, not alone — a fat margin with a 90-day DSO is a business quietly lending money to its customers for free.
03 / Framework
Which Reporting Standard Applies

Indonesia has a tiered set of standards (SAK). The right tier depends on your size and public accountability — using the wrong one is a credibility risk with banks and the tax office.

1PSAK (SAK Umum) — public entities, IFRS-converged
2SAK EP — private entities (replaced ETAP, 2025)
3SAK EMKM — micro, small & medium (UMKM)
4SAK Syariah — Sharia-compliant entities
on this page
A café or boarding house is a textbook SAK EMKM entity; a PT or CV usually sits under SAK EP. The formal financial statements themselves — prepared to PSAK presentation — live on the Accounting page, where two cases (CV Solusi Digital, PT Bangun Sulawesi) are shown as full statements.
client casebook

Casebook — Palu Businesses

The same five Palu businesses from the Accounting page — now read through a finance lens. Each case turns the bookkeeping into ratios, cash-flow and break-even analysis. Follow View the books → on any case to see the underlying books — where two cases are also prepared as formal PSAK statements. The same data, a third professional lens.

select a case
Case 01
Kopi Tadulako
Café / F&B
Margin & Break-even
View analysis →
Case 02
Toko Makmur
Grocery · FIFO
Turnover & VAT
View analysis →
Case 03
CV Solusi Digital
IT services
Receivables & DSO
View analysis →
Case 04
PT Bangun Sulawesi
Construction
Variance & Margin
View analysis →
Case 05
Kos Pak Haris
Boarding · 20 rooms
Yield & NOI
View analysis →
CASE 01 · JANUARY 2025

Kopi Tadulako

Pak Hasan's small café. The books are clean — the finance question isn't ‘how much profit’ but ‘how safe’: margin per menu line, and the minimum turnover before it loses money.

Business Café (F&B)Location Palu, C. SulawesiRevenue Rp 32.93 M/moStatus Non-VAT registered · Small businessLens Ratios & Break-even
Ratio & Margin Analysis · January 2025

Using the corrected COGS of Rp 12 M (see the Reconciliation Finding on the Accounting page), not the erroneous Rp 14 M in the income statement. The correction lifts reported profit.

RatioValueTargetRead
Gross margin63,6%> 40%Strong
Net margin23,0%> 10%Healthy
OpEx / revenue40,0%< 45%Reasonable
Payroll / revenue24,3%< 30%Controlled
Gross Margin
63,6%
Net Margin
23,0%
Net Profit
Rp 7.58M
Margin insight
Per-menu margin drives pricing
The COGS breakdown shows espresso at only 33% GM versus 50% on snacks and 44% on non-coffee drinks. Coffee brings people in, but the food menu pays the rent. Recommendation: push food + coffee bundles and lift espresso price by Rp 1,000 — the profit impact is larger than it looks.
Break-even Point · January 2025

What is the minimum turnover that covers all fixed costs? Fixed cost divided by the contribution-margin ratio.

ComponentValue
Monthly fixed cost (opex)Rp 13,183,333
Contribution margin ratio63,6%
Break-even revenueRp 20,741,861
Actual revenueRp 32,930,000
Margin of safety37,0%
Break-even
Rp 20.74M
Actual
Rp 32.93M
Margin of Safety
37,0%
Operational translation
Break-even ≈ 63 cups/day
At a blended average price of ± Rp 11,000, the Rp 20.74 M break-even is about 1,886 servings/month or ±63 a day. Current sales run ±90/day, so there is a 37% cushion — the café can absorb a slow month or a rent increase before it slips into a loss.
Bookkeeping perspective
See the full bookkeeping for Kopi Tadulako
Same data, recording lens — cash book, COGS schedule, income statement and payroll behind these numbers, on the Accounting page.
View Bookkeeping  
CASE 02 · JANUARY 2025

Toko Makmur

A PKP grocery store. Grocery margins are thin, so the finance turns on two things: how fast inventory converts to cash, and how much VAT must be remitted to the tax office.

Business Grocery storeLocation Palu, C. SulawesiMethod FIFOStatus VAT-registered · VAT 11%Lens Turnover & VAT
Inventory Turnover & Working Capital · January 2025

Inventory is cash parked on the shelves. The faster it turns, the less capital is tied up and the healthier the cash flow.

MetricValueRead
Beginning inventoryRp 13,800,000
Ending inventoryRp 4,625,000
COGS (value out)Rp 27,460,000
Inventory turnover2.98×/moFast
Days inventory≈ 10 daysHealthy
Avg working capital in stockRp 9,212,500
Turnover
2.98×/mo
Days Inventory
≈10 days
Capital in Stock
Rp 9.21M
Margin caveat
Rebuild the true markup at close
In the source data the sales value ties to the cost basis (value-out = COGS), so the margin appears to be zero. For groceries — where margins are genuinely thin (5–15%) — the true markup must be rebuilt from the price list at close. What drives this business isn't per-unit margin but turnover speed and VAT-remittance timing.
VAT Position · January 2025

As a PKP, Toko Makmur collects Output VAT on sales and pays Input VAT on purchases. The difference is remitted to the tax office — a real cash outflow that must be planned for.

ComponentValue
Output VAT (collected on sales)Rp 3,020,600
Input VAT (paid on purchases)Rp 2,011,350
VAT payable (remit to tax office)Rp 1,009,250
Output VAT
Rp 3.02M
Input VAT
Rp 2.01M
Remit
Rp 1.01M
Cash discipline
Ring-fence VAT, don't spend it on stock
Collected VAT isn't the store's income — it's money held for the state. The most common UMKM mistake is spending Output-VAT cash on restocking, then falling short at the remittance deadline next month. My practice: move the Rp 1.01 M to a separate account the moment the periodic SPT is prepared.
Bookkeeping perspective
See the full bookkeeping for Toko Makmur
Same data, recording lens — cash book, COGS schedule, income statement and payroll behind these numbers, on the Accounting page.
View Bookkeeping  
CASE 03 · JANUARY 2025

CV Solusi Digital

A software shop billing corporate clients. On paper it's very profitable — but Rp 72.1 M is still uncollected. A textbook ‘profit isn’t cash’ case — collection risk, not profitability, is the real question.

Business IT servicesLocation Palu, C. SulawesiRevenue Rp 180 M/moStatus VAT-registered · Art. 23 WHTLens AR & Cash
Accounts Receivable & DSO · January 2025

The AR ageing shows how long money is stuck with clients. DSO (Days Sales Outstanding) measures the average days until an invoice turns into cash.

StatusInvoicesValue (DPP)Read
Paid5Rp 89,000,000Collected
Partial2Rp 51,000,000Rp 32.1 M left
Unpaid3Rp 40,000,000Due Feb
TOTAL10Rp 180,000,000
Open AR
Rp 72.1M
DSO
≈ 12 days
Ending Cash
Rp 119.1M
Concentration risk
Collection is good, but watch two large debtors
A ±12-day DSO is healthy — clients pay quickly. But the Rp 72.1 M open balance is concentrated in INV-003 (Rp 22 M) and the remainder of INV-009 (Rp 23.1 M). Recommendation: require a 30–50% deposit on projects over Rp 20 M so cash doesn't hinge on two collections. Note: the PPh 23 withheld by clients (2% × DPP = Rp 3.6 M) is a tax credit, not an expense.
Bookkeeping perspective
See the full bookkeeping for CV Solusi Digital
Same data, recording lens — cash book, COGS schedule, income statement and payroll behind these numbers, on the Accounting page.
View Bookkeeping  
CASE 04 · JANUARY 2025

PT Bangun Sulawesi

A building contractor on a Rp 2.8 B, 3-month contract. The finance is project control: are costs on budget, and what the true project margin is as the work progresses.

Business ConstructionContract Rp 2.8 BDuration 3 monthsStatus VAT-registered · Final Tax Art. 4(2)Lens Variance & Margin
Cost Variance & Project Margin · January 2025

Budget vs actual gives an early warning on cost overruns. A positive variance is under budget; negative is overspend to chase down before the next progress claim.

ItemBudget JanActual JanVariance
Materials555.000.000540.000.00015.000.000
Labour115.000.000114.500.000500.000
Equipment (plant hire)43.000.00041.000.0002.000.000
Overhead & safety50.000.00029.300.00020.700.000
TOTAL763.000.000724.800.00038.200.000
Actual vs Budget
95,0%
Variance (under)
Rp 38.2M
Est. Contract Margin
33,2%
Read the variance
Under budget — but check why
January actuals are 5% under budget (Rp 38.2 M). Most of it comes from finishing items (paint, tiling) that haven't started — so this is timing, not a true saving. The overall contract margin is projected at a healthy 33.2% (Rp 930 M on Rp 2.8 B). The thing to watch: the 2.65% final PPh 4(2) withheld by the client each progress claim — Rp 22.26 M on Termin I.
Bookkeeping perspective
See the full bookkeeping for PT Bangun Sulawesi
Same data, recording lens — cash book, COGS schedule, income statement and payroll behind these numbers, on the Accounting page.
View Bookkeeping  
CASE 05 · JANUARY 2025

Kos Pak Haris

Pak Haris's 20-room boarding house. A small-property case: what matters isn't sales but occupancy, yield per room type, and net operating income (NOI) after the final rental tax.

Business Boarding houseCapacity 20 roomsStatus Non-VAT · Final 10%Occupancy 85%Lens Yield & NOI
Occupancy & Yield by Room Type · January 2025

Occupancy measures how many rooms are filled; yield measures actual revenue against full potential. An empty room is permanently lost revenue — it can't be ‘sold’ next month.

Room typeUnitsFilledPotentialActualYield
AC Deluxe556.000.0006.000.000100%
AC Standard544.500.0003.600.00080%
Non-AC1086.500.0005.200.00080%
TOTAL201717.000.00014.800.00087%
Occupancy
85% (17/20)
Potential Revenue
Rp 17.0M
Yield
87%
The weak spot
Two empty Non-AC rooms = Rp 1.3 M/mo lost
AC Deluxe is full (100%) — strong demand at the premium tier. The weakness is Non-AC (80%): two empty rooms are Rp 1.3 M of revenue lost every month, and it never comes back. Recommendation: narrow the Deluxe–Non-AC price gap or add fans/ventilation to make Non-AC more sellable — filling those two rooms adds roughly 47% to net profit.
Net Operating Income (NOI) & Break-even · January 2025

NOI is the profit from running the boarding house after all costs and the final rental tax. Break-even occupancy shows the minimum rooms that must be filled to avoid a loss.

DescriptionAmount (Rp)
Rent received15.450.000
Operating cost(11.109.000)
PROFIT BEFORE TAX4.341.000
Final PPh 4(2) — 10% of gross(1.545.000)
NET PROFIT (NOI)2.796.000
Monthly NOI
Rp 2.80M
Break-even Occupancy
≈ 65% (13 rooms)
Cushion
20% (4 rooms)
Strength & risk
Safe today, but thin against the mortgage
Break-even is ±13 of 20 rooms (65%); actual 85% occupancy gives a 4-room cushion. But NOI of Rp 2.8 M/month is thin against the Rp 4.5 M mortgage instalment — real cash flow depends on avoiding prolonged vacancies. The 10% final tax is exactly that: it can't be credited and can't offset other income.
Bookkeeping perspective
See the full bookkeeping for Kos Pak Haris
Same data, recording lens — cash book, COGS schedule, income statement and payroll behind these numbers, on the Accounting page.
View Bookkeeping  

Start

Numbers that guide decisions?

Let's turn your books into insight you can act on. The first consultation is free, answered within 24 hours, directly by me.

Get in Touch