Overview
Company-wide finance snapshot — all-time Cashbook, this month for context, profitability estimate, savings, and open items.
Cashflow
Both branches combined. Void rows and savings-fund withdrawals excluded from Money Out (same as Cashbook).—
Rp0
Rp0
Rp0
Rp0
—
Net Cashflow — Since July 2026
Loading…Balances & Open Items
Live positions — not month-scoped.
Rp0
—
Rp0
Loading…
Rp0
—
| Savings fund | Balance |
|---|---|
| Loading… | |
Branch Profitability (estimate)
Since Jul 2026 — same rules as Branch P&L.| Branch | Revenue | Cost | Net |
|---|---|---|---|
| Loading… | |||
Cashbook
Manual money-in and money-out for HO. Paid client invoices plus expenses.
Cashbook basis
Money in minus money out. Edits are logged with manager name and change note.
Not loaded
Period status —
Checking…
Rp0
Paid invoices in period
Rp0
Expenses in period
Rp0
In minus out
0
Rows in selected view
Month P&L by category
Paid rows in selected filters. Savings withdrawals excluded from totals.Income
Total
Rp0
Expenses
Total
Rp0
Distributions
Total
Rp0
Rp0
Rp0
Cashbook entries
Latest rows in selected view| Date | Subject | Amount | Actions | |
|---|---|---|---|---|
| Sign in and load cashbook data. | ||||
Monthly Expenses
Recurring money-out checklist — snapshot from Cashbook, then post once per month when paid.
How it works
Add once from a Cashbook money-out (or type manually). Each month, check what was paid and Post — creates new Cashbook OUT rows and marks the checklist. Not automatic.
Not loaded
This month’s checklist
Active items only. Posted rows stay locked for that month. Remove deletes the recurring checklist item (Cashbook posts already made stay).| Name | Category | Party | Branch | Amount | Status | ||
|---|---|---|---|---|---|---|---|
| Sign in and open Monthly Expenses. | |||||||
Add from Cashbook
Search paid money-out rows (system commission/payroll/profit-share categories are excluded). Snapshot — later Cashbook edits do not sync back.| Date | Party / Subject | Category | Branch | Amount | |
|---|---|---|---|---|---|
| Search to list recent money-out entries. | |||||
All checklist items
Inactive items stay on this list but never appear in the month checklist.| Name | Category | Party | Branch | Default amount | Active | |
|---|---|---|---|---|---|---|
| No items yet. | ||||||
Agent Commissions
Level Up 2026 — monthly THP from approved paymentlog collections × stage rate + transport.
Level Up 2026 basis
Stage from users.commission_stage. Senior Steady from users.senior_steady (manual). Calendar month from paymentlog.
Not loaded
0
With approved payments
Rp0
Total approved in month
Rp0
After tax + adjustments
Agent breakdown
Select a month and click Calculate| Agent | Calc tier | Pay | Month | Qtr | Bracket | Rate | Comm. | Trans. | Pre-tax | After tax | Adj. | Final | Net % | Adjust |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Load commission data for a month. | ||||||||||||||
Commission Adjustments
Recorded penalties, owed amounts, bonuses, and other per-agent adjustments for each month.
Adjustment ledger
Each record is stored with type and notes. Totals flow into the commission calculator after tax.
Not loaded
Records
Select a month and load records| Date | Agent | Type | Amount | Notes | By | Files | |
|---|---|---|---|---|---|---|---|
| Load adjustment records for a month. | |||||||
VOIP Usage
Dankom call logs, monthly seconds, estimated cost, and recording follow-up.
VOIP route
Provider IP 202.52.48.70; VPS IP 212.85.26.247. Recordings are tracked until Dankom confirms the owner.
Not loaded
Active softphone trunk
Company-wide — softphones follow this setting (CEO/COO only)
VOIP tables are not installed yet. Run finance_schema_v0.7_voip.sql, then refresh this page.
Usage filters
Full month when no dates are set
0
0 answered
0
0.0 minutes
Rp0
Rate not set
0
VPS storage
Call logs
10 calls per page| Started | Agent | Route | Loan | Product | Status | Duration | Billable | Cost | Recording | Reference | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Load VOIP usage for a month. | |||||||||||
Page 1 of 1
Agent Usage
No calls loadedVOIP Extensions
Create extension inventory first, then assign each agent to an extension when ready. Use 1xxx for MicroSIP (UDP) and 2xxx for the in-app browser phone (WebRTC).
Restricted management
Create extensions without agent assignment first. Assigning an agent is a separate Edit step after provisioning.
Not loaded
Extension tables are not installed. Run finance_schema_v0.8_voip_extensions.sql.
0
Inventory rows
0
Currently reachable
0
Waiting for VPS worker
Offline
Never seen
Extension inventory
Extension 1001 remains manual until explicitly migrated.| Extension | Agent | Device | Management | Provision | Registration | Last seen | Actions |
|---|---|---|---|---|---|---|---|
| Load extension inventory. | |||||||
Payroll & Schemes
Dynamic commission schemes and staff payroll.
Staff Payroll
CEO/COO/Support/etc. Shows unpaid staff only for the selected month (already posted to Cashbook are hidden). 2% tax on management payroll; OfficeBoy + Helper are tax-exempt (gross = net). Money owed and Reimbursement adjustments are applied after tax — they never change the taxable amount.| Staff | Level | Branch | Adj | Amount | After tax | Effective | Ends | ||
|---|---|---|---|---|---|---|---|---|---|
| Load a month. | |||||||||
Position levels
Reusable templates the Staff picker pre-fills from — edit or deactivate here.| Name | Default amount | Active | ||
|---|---|---|---|---|
| Loading… | ||||
Commission Schemes
Editable flat rate, collection floor, and optional TL team %. Assign to any agent/TL — not hard-coded.| Name | Rate % | Floor | Team % | Team from | Transport | Active | |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Expense Templates
Reusable named amounts kept for Payroll & Schemes reference. Cashbook Record entry no longer quick-fills from these.| Name | Default amount | Active | |
|---|---|---|---|
| Loading… | |||
Vendors
Saved payees for Cashbook Record entry’s Party dropdown. Bank details are reference only — not used to send money.| Name | Bank | Account number | Active | |
|---|---|---|---|---|
| Loading… | ||||
Employee Loans
Money the company lent to staff, repaid through salary deductions.
0
Not yet fully repaid
Rp0
Still owed to the company
Rp0
Deductions in posted payroll
Loans
Repayments are Money owed deductions on Staff Payroll linked to the loan (pick the loan in + Adj). A deduction counts as paid once that payroll month is posted to Cashbook.| Loan ID | Employee | Loan | Sent | Amount | Plan | Repaid | Outstanding | Status | |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Branch Profitability
Rough monthly profit estimate per branch — client-rate weighted collections minus commission, payroll, VOIP, and expenses.
Branch Profitability (estimate)
Select a month and branch, then Calculate.
Rp0
Client-rate weighted collections
Rp0
Commission + payroll + VOIP + expenses
Rp0
Revenue − cost
| Line | Amount |
|---|---|
| Select a month and branch, then Calculate. | |
| Month | Revenue | Cost | Net |
|---|
Client Revenue Rates
The % of each collection counted as revenue in the estimate above — e.g. Longan collections currently count at 35% revenue, not 100%.| Client | Rate % | Active | |
|---|---|---|---|
| Loading… | |||
Reimbursements
Expenses covered personally, batched up, and paid back — flag on Cashbook entry, batch here, mark Reimbursed once the transfer lands.
Pending expenses
Check the ones going into this reimbursement. Flag new ones from Cashbook's "Record entry" form.Selected: Rp0
| Reference | Paid to | Owed to | Category | Date | Amount | ||
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Batches
Pending batches can still be edited or cancelled. Reimbursed batches are locked history.| Created | Entries | Total | Notes | Status | ||
|---|---|---|---|---|---|---|
| Loading… | ||||||
Company Savings
Named funds (e.g. "The 5%", "Rent Reserve") that a Cashbook expense can be tagged as contributing to — the running balance below is just the total of those tagged entries.
Profit Sharing
Company-wide Cashbook net (both branches) since the last full withdrawal. Withdraw one positive month without waiting for the running pool to turn positive — losses stay in the pool. Savings-fund withdrawals are excluded so they aren’t counted twice.
Current Pool
Loading…
Rp0
Remaining months not yet withdrawn
| Month | Net | |
|---|---|---|
| Loading… | ||
Participants
Active shares must add up to 100% before a withdrawal can be posted.| Name | Share % | Running Share | Active | |
|---|---|---|---|---|
| Loading… | ||||
Withdrawal History
| Date | Period | Amount | Breakdown | By |
|---|---|---|---|---|
| Loading… | ||||
Invoice Maker
Pick a client, type Description + Amount — invoice # (MNM-INV-YY.MM-xxxx), due date, PPH 23, and total are computed. Cashbook keeps a separate MNM-YY.MM-nn series.
New invoice
Everything below is editable — changes to Due days / PPH 23 / Signer become the new default for next time.Editing
Recent invoices
| Invoice # | Client | Subject | Submitted | Due | Total | Status | |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Activity Log
Finance sign-ins, sign-outs, saved changes, and blocked edit attempts. Page views and filter changes are intentionally not recorded.
Retention
Log writes are indexed and disk-backed; this page displays the newest 200 matching events.
Not loaded
| When | Person | Event | What | Target | Access | IP |
|---|---|---|---|---|---|---|
| Open Activity Log to load events. | ||||||