Total Revenue (MTD)
4.2 M
▲ 12.4%vs last month
Total Expenses (MTD)
2.6 M
▼ 3.1%under budget
Net Profit (MTD)
1.6 M
▲ 18%margin: 38%
Cash Position
8.4 M
▲ 2.1%3 bank accounts
Revenue vs Expenses — 2026
IDR
Revenue
Expenses
Expense Breakdown
2.6M
Total Exp.
COGS / Fabric
40%
Operations
25%
Payroll
18%
Logistics
11%
Other
6%
AR / AP Aging Summary
Accounts Receivable
Current (0–30 days)Rp 1.2M
31–60 daysRp 640K
60+ days OverdueRp 280K
Accounts Payable
Due this weekRp 420K
Due next 30 daysRp 560K
Recent Transactions
💵
+Rp 18.5M
Invoice INV-091 — Mira Kusuma
14 Jun 2026 · Sales Revenue
🏭
−Rp 8.4M
Vendor Payment — PT. Mulia Fabric
13 Jun 2026 · Accounts Payable
💵
+Rp 28.0M
DP Received — Villa Seminyak
12 Jun 2026 · Deferred Revenue
👥
−Rp 820K
Payroll Disbursement — June 2026
10 Jun 2026 · Salaries & Wages
🚚
−Rp 4.2M
Fleet Maintenance Cost
9 Jun 2026 · Operating Expense
Budget vs Actual — June 2026
On Track
RevenueRp 4.2M / 4.0M
+5% over target ✓
COGSRp 1.8M / 2.0M
Under budget ✓
PayrollRp 820K / 900K
91% of budget ✓
LogisticsRp 420K / 350K
Over budget ⚠️
Net ProfitRp 1.6M / 1.4M
+14% over target ✓
Total Revenue
4.2 M
▲ 12.4%vs May 2026
Total Expenses
2.6 M
COGS + OpEx
Gross Profit
2.4 M
57% margin
Net Profit
1.6 M
▲ 18% · 38% margin
Profit & Loss Statement — June 2026
REVENUEJune 2026May 2026YTD 2026
Residential Project SalesRp 1,840,000,000Rp 1,620,000,000Rp 9,200,000,000
Commercial / Hotel SalesRp 1,680,000,000Rp 1,430,000,000Rp 8,100,000,000
Corporate SalesRp 560,000,000Rp 490,000,000Rp 2,800,000,000
Maintenance ServicesRp 120,000,000Rp 90,000,000Rp 580,000,000
Total RevenueRp 4,200,000,000Rp 3,630,000,000Rp 20,680,000,000
COST OF GOODS SOLD
Fabric & MaterialsRp 840,000,000Rp 720,000,000Rp 4,100,000,000
Fabrication LaborRp 280,000,000Rp 240,000,000Rp 1,380,000,000
Installation CostRp 200,000,000Rp 170,000,000Rp 980,000,000
Import Duties & FreightRp 260,000,000Rp 210,000,000Rp 1,240,000,000
Total COGSRp 1,580,000,000Rp 1,340,000,000Rp 7,700,000,000
GROSS PROFITRp 2,620,000,000Rp 2,290,000,000Rp 12,980,000,000
OPERATING EXPENSES
Salaries & WagesRp 820,000,000Rp 820,000,000Rp 4,920,000,000
Logistics & DeliveryRp 420,000,000Rp 350,000,000Rp 2,080,000,000
Marketing & SalesRp 140,000,000Rp 120,000,000Rp 720,000,000
Office & UtilitiesRp 80,000,000Rp 80,000,000Rp 480,000,000
Technology & SystemsRp 60,000,000Rp 60,000,000Rp 360,000,000
DepreciationRp 42,000,000Rp 42,000,000Rp 252,000,000
Total Operating ExpensesRp 1,562,000,000Rp 1,472,000,000Rp 8,812,000,000
EBITDARp 1,058,000,000Rp 818,000,000Rp 4,168,000,000
Interest ExpenseRp 20,000,000Rp 20,000,000Rp 120,000,000
Tax (PPh Badan ~25%)Rp 259,500,000Rp 199,500,000Rp 1,012,000,000
NET PROFIT AFTER TAXRp 778,500,000Rp 598,500,000Rp 3,036,000,000
Balance Sheet — 30 Jun 2026
ASSETSAmount (IDR)
Current Assets
Cash & Bank8,400,000,000
Accounts Receivable2,120,000,000
Inventory (Fabric Stock)3,200,000,000
Prepaid Expenses240,000,000
Total Current Assets13,960,000,000
Fixed Assets
Vehicles & Equipment2,400,000,000
Office Furniture380,000,000
Software & Systems650,000,000
Less: Accumulated Depreciation(840,000,000)
Total Fixed Assets (Net)2,590,000,000
TOTAL ASSETS16,550,000,000
Liabilities & Equity
LIABILITIESAmount (IDR)
Current Liabilities
Accounts Payable980,000,000
Tax Payable (PPh/PPN)430,000,000
Salaries Payable240,000,000
Deferred Revenue680,000,000
Total Current Liabilities2,330,000,000
Long-Term Liabilities
Bank Loan1,200,000,000
Total Liabilities3,530,000,000
SHAREHOLDERS\' EQUITY
Paid-in Capital8,000,000,000
Retained Earnings4,984,000,000
Net Profit (Current Year)778,500,000 (YTD)
Total Equity13,020,000,000
TOTAL LIABILITIES + EQUITY16,550,000,000
✓ Balance Sheet is Balanced
Opening Balance
6.8M
Net Cash In
+4.2M
Net Cash Out
−2.6M
Closing Balance
8.4M
Cash Flow Statement — June 2026
A. OPERATING ACTIVITIES
Cash received from clients+4,640,000,000
Cash paid to vendors / suppliers−1,580,000,000
Salaries & wages paid−820,000,000
Operating expenses paid−480,000,000
Tax paid (PPh / PPN)−259,500,000
Net Cash from Operations+1,500,500,000
B. INVESTING ACTIVITIES
Purchase of vehicle (delivery fleet)−350,000,000
Software & ERP system investment−120,000,000
Net Cash from Investing−470,000,000
C. FINANCING ACTIVITIES
Bank loan repayment−100,000,000
Interest paid−20,000,000
Net Cash from Financing−120,000,000
NET INCREASE IN CASH+910,500,000
Opening Cash Balance (1 Jun)6,800,000,000
CLOSING CASH BALANCE (30 Jun)7,710,500,000
General Ledger
Date
Reference
Description
Debit
Credit
Balance
Account: 1-1001 · Cash — BCA Main Account | Opening Balance: Rp 6,800,000,000
01 JunJE-2026-180Client payment — INV-088 Bank Mandiri Project+280,000,0007,080,000,000
03 JunJE-2026-181Vendor payment — PT. Raja Kain PO-2026-036−210,000,0006,870,000,000
05 JunJE-2026-182Fleet maintenance cost — 3 vehicles−42,000,0006,828,000,000
08 JunJE-2026-183DP received — Villa Seminyak project+280,000,0007,108,000,000
10 JunJE-2026-184Payroll disbursement June 2026 — 68 employees−820,000,0006,288,000,000
12 JunJE-2026-185Client payment — INV-089 Andi Pratama+32,000,0006,320,000,000
13 JunJE-2026-186Vendor payment — PT. Mulia Fabric PO-2026-038−84,000,0006,236,000,000
14 JunJE-2026-187Invoice INV-091 — Mira Kusuma paid in full+185,000,0006,421,000,000
Closing Balance — 14 Jun 2026
Rp 6,421,000,000
New Journal Entry
Unbalanced
| # | Account Code | Account Name | Description | Debit (IDR) | Credit (IDR) |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 |
Total Debit
Rp 142,000,000
Total Credit
Rp 142,000,000
Difference
Rp 0 ✓
Recent Journal Entries
| Entry # | Date | Description | Debit | Credit | Status |
|---|---|---|---|---|---|
| JE-2026-187 | 14 Jun | INV-091 Mira Kusuma — cash receipt | 185,000,000 | 185,000,000 | Posted |
| JE-2026-186 | 13 Jun | Vendor payment PT. Mulia Fabric | 84,000,000 | 84,000,000 | Posted |
| JE-2026-185 | 12 Jun | INV-089 Andi Pratama — cash receipt | 32,000,000 | 32,000,000 | Posted |
| JE-2026-184 | 10 Jun | Payroll disbursement June 2026 | 820,000,000 | 820,000,000 | Posted |
Chart of Accounts
📦 1 — ASSETS
1-1001Cash — BCA Main AccountCurrent6,421,000,000
1-1002Cash — Bank MandiriCurrent1,979,000,000
1-2001Accounts ReceivableCurrent2,120,000,000
1-3001Inventory — Fabric StockCurrent3,200,000,000
1-4001Vehicles & FleetFixed2,400,000,000
1-4002Software & ERP SystemsFixed650,000,000
💳 2 — LIABILITIES
2-1001Accounts PayableCurrent980,000,000
2-1002Tax Payable — PPh BadanCurrent259,500,000
2-1003PPN PayableCurrent172,000,000
2-2001Bank Loan — BNILong-term1,200,000,000
🏦 3 — EQUITY
3-1001Paid-in CapitalEquity8,000,000,000
3-2001Retained EarningsEquity4,984,000,000
💰 4 — REVENUE
4-1001Residential Sales RevenueIncome1,840,000,000
4-1002Commercial Sales RevenueIncome1,680,000,000
4-1003Corporate Sales RevenueIncome560,000,000
4-2001Maintenance Service RevenueIncome120,000,000
📉 5 — EXPENSES
5-1001Fabric & Materials COGSCOGS840,000,000
5-2001Salaries & WagesOpEx820,000,000
5-2002Logistics & DeliveryOpEx420,000,000
5-2003Depreciation ExpenseOpEx42,000,000
Total Invoiced (MTD)
4.2M
Paid
2.1M
7 invoices
Overdue
280K
2 overdue
Pending
1.8M
5 awaiting
All Invoices
| Invoice # | Client | Amount | Issue Date | Due Date | Status | Action |
|---|---|---|---|---|---|---|
| INV-092 | PT. Grand Hyatt | Rp 142M | 14 Jun | 28 Jun | Pending | |
| INV-091 | Mira Kusuma | Rp 18.5M | 10 Jun | 24 Jun | Paid | |
| INV-090 | Andi Pratama | Rp 32M | 8 Jun | 22 Jun | Pending | |
| INV-089 | Villa Seminyak | Rp 56M | 5 Jun | 19 Jun | Paid | |
| INV-088 | Bank Mandiri HQ | Rp 280M | 1 Jun | 15 Jun | Overdue | |
| INV-087 | The Ritz-Carlton | Rp 220M | 28 May | 11 Jun | Overdue |
Select an invoice to preview
🧾
Click any invoice to view details
68
Total Employees
Rp 820M
Total Payroll Jun
Rp 720M
Net After Tax
Rp 100M
PPh 21 Withheld
Payroll — June 2026
| Employee | Department | Basic Salary | Allowances | Gross | PPh 21 | BPJS | Net Pay | Status |
|---|---|---|---|---|---|---|---|---|
| Budi Prakoso | Warehouse | Rp 12.0M | Rp 2.5M | Rp 14.5M | −Rp 1.45M | −Rp 290K | Rp 12.76M | Paid |
| Siti Rahayu | Sales | Rp 15.0M | Rp 4.2M | Rp 19.2M | −Rp 1.92M | −Rp 384K | Rp 16.9M | Paid |
| Linda Nuraini | Finance | Rp 13.5M | Rp 2.0M | Rp 15.5M | −Rp 1.55M | −Rp 310K | Rp 13.64M | Paid |
| Ahmad Maulana | IT / ERP | Rp 18.0M | Rp 3.0M | Rp 21.0M | −Rp 2.10M | −Rp 420K | Rp 18.48M | Paid |
| Dedi Hartono | Logistics | Rp 11.0M | Rp 2.0M | Rp 13.0M | −Rp 1.30M | −Rp 260K | Rp 11.44M | Paid |
| TOTAL (all 68 employees) | Rp 892M | −Rp 89.2M | −Rp 17.8M | Rp 785M | ✓ | |||
PPh 21 (Jun)
100M
Due: 10 Jul 2026
PPh 23 (Jun)
2.6M
Due: 10 Jul 2026
PPh Badan (H1)
259.5M
Due: 25 Jul 2026
PPN (Jun)
172M
Due: 31 Jul 2026
Tax Summary — June 2026
Jun 2026
May 2026
Apr 2026
Q2 2026
Q1 2026
| Tax Type | Description | Tax Base | Rate | Amount Due | Status | Due Date |
|---|---|---|---|---|---|---|
| PPh 21 | Employee income tax withheld from salaries | Rp 820,000,000 | ~12.2% | Rp 100,000,000 | Pending | 10 Jul 2026 |
| PPh 23 | Withholding tax on vendor services (2%) | Rp 129,600,000 | 2% | Rp 2,592,000 | Pending | 10 Jul 2026 |
| PPh Badan | Corporate income tax (installment) | Rp 1,038,000,000 | 25% | Rp 259,500,000 | Pending | 25 Jul 2026 |
| PPN Keluaran | Output VAT — sales invoices (11%) | Rp 4,200,000,000 | 11% | Rp 462,000,000 | Pending | 31 Jul 2026 |
| PPN Masukan | Input VAT — vendor purchases (11%) | Rp 1,580,000,000 | 11% | −Rp 173,800,000 (credit) | Credit | — |
| NET PPN PAYABLE | Rp 288,200,000 | Pending | 31 Jul 2026 | |||
All Transactions — June 2026
| Date | Reference | Description | Category | Debit | Credit | Balance |
|---|---|---|---|---|---|---|
| 14 Jun | JE-2026-187 | INV-091 Mira Kusuma — paid | Revenue | +185,000,000 | 6,421,000,000 | |
| 13 Jun | JE-2026-186 | Vendor — PT. Mulia Fabric | COGS | −84,000,000 | 6,236,000,000 | |
| 12 Jun | JE-2026-185 | INV-089 Andi Pratama — paid | Revenue | +32,000,000 | 6,320,000,000 | |
| 10 Jun | JE-2026-184 | Payroll disbursement — 68 staff | Payroll | −820,000,000 | 6,288,000,000 | |
| 9 Jun | JE-2026-183 | Fleet maintenance cost | OpEx | −42,000,000 | 7,108,000,000 | |
| 8 Jun | JE-2026-182 | DP received — Villa Seminyak | Revenue | +280,000,000 | 7,108,000,000 | |
| 5 Jun | JE-2026-181 | Logistics — delivery cost June W1 | OpEx | −38,000,000 | 6,828,000,000 | |
| 3 Jun | JE-2026-180 | Vendor payment — PT. Raja Kain | COGS | −210,000,000 | 6,870,000,000 | |
| 1 Jun | JE-2026-179 | Bank Mandiri project payment | Revenue | +280,000,000 | 7,080,000,000 |
Vendor Payments
| Payment # | Vendor | PO Reference | Amount | Method | Date | Status |
|---|---|---|---|---|---|---|
| PAY-2026-042 | PT. Mulia Fabric | PO-2026-038 | Rp 84,000,000 | Bank Transfer | 13 Jun 2026 | Completed |
| PAY-2026-041 | PT. Raja Kain | PO-2026-036 | Rp 210,000,000 | Bank Transfer | 3 Jun 2026 | Completed |
| PAY-2026-040 | CV. Surya Tekstil | PO-2026-037 | Rp 125,000,000 | Bank Transfer | 28 May 2026 | Completed |
| PAY-2026-043 | Toko Bahan Prima | PO-2026-039 | Rp 45,000,000 | Bank Transfer | — | Scheduled |
Trial Balance — 30 Jun 2026
| Account Code | Account Name | Debit | Credit |
|---|---|---|---|
| 1-1001 | Cash — BCA Main | 6,421,000,000 | |
| 1-1002 | Cash — Mandiri | 1,979,000,000 | |
| 1-2001 | Accounts Receivable | 2,120,000,000 | |
| 1-3001 | Inventory | 3,200,000,000 | |
| 1-4001 | Vehicles & Fleet | 2,400,000,000 | |
| 2-1001 | Accounts Payable | 980,000,000 | |
| 2-1002 | Tax Payable (PPh/PPN) | 650,500,000 | |
| 2-2001 | Bank Loan | 1,200,000,000 | |
| 3-1001 | Paid-in Capital | 8,000,000,000 | |
| 3-2001 | Retained Earnings | 4,984,000,000 | |
| 4-1001 | Sales Revenue | 4,200,000,000 | |
| 5-1001 | Fabric & Materials COGS | 1,580,000,000 | |
| 5-2001 | Salaries & Wages | 820,000,000 | |
| 5-2002 | Logistics & Delivery | 420,000,000 | |
| 5-2003 | Other Operating Expenses | 280,000,000 | |
| TOTALS | 19,220,000,000 | 20,014,500,000 | |
⚠️ Note: Retained earnings and net profit reconciliation needed to complete balance. This is a simplified view.