Dashboard
AUGUST 2026Weekly IncomeActive
Top Expenses
Profit & Loss Statement—
| Line Item | Amount | Detail |
|---|
Summary
CUMULATIVE TOTALSIncome Summary$0
| Day | Date | Amount | Running Total |
|---|
Expense Summary — All Categories$0
| Category | Amount | % of Total |
|---|
Net Profit / Loss—
| Metric | Amount |
|---|
Year to Date
ALL MONTHS · RUNNING TOTALSMonth-by-Month SummaryYTD = running total
Income
EDIT DAILY INCOMEImport from Secure CRM
Drag & drop your CRM export CSV here
— or —
Browse Files
Collection Weeks$0
Daily Income Log$0
| Week | Day | Weekday | Date | Completed | Pending | Submitted |
|---|
Expenses
EDIT EXPENSESAugust Expenses$0
Expense Rate
Fixed vs. Variable
Expense Breakdown
Notes & Memo
Monthly Trends
ALL MONTHSGross Collections by Month
Month-Over-Month Detail
Payroll & Bonus
EDIT PAYROLLMonth Payroll (Regular)
$0
Both pay periods, no bonus
Aggregate Bonus
$0
Total incentive earned
Total Payroll + Bonus
$0
Full labor cost
Bonus Period — 1st–15th (paid 20th) · bonus from prior-month collections$0
| Employee | Rate | Hours | Payroll | Bonus % | Collected (prior mo.) | Bonus | Total |
|---|
Non-Bonus Payroll — 16th–End of Month (paid 5th)$0
| Employee | Rate | Hours | Total |
|---|
Owner Withdrawals
EDIT DRAWSWithdrawal Log$0
| Date | Recipient | Amount |
|---|
Withdrawal History$0
Chargebacks
DISPUTE TRACKINGThis month
Running total — all months
Chargeback Rolling Recovery$0
| Chargeback | Charged Off | Recovered | Days | Amount |
|---|
Chargeback Cases$0
| Name | Status | Amount | P&L Impact |
|---|
Chargeback Trend — cost only (lost + pending)$0
Office & Supplies
AUGUST 2026Office Supplies$200
| Date | Description | Amount |
|---|---|---|
| Nov 3, 2025 | Doug / Maintenance | $200.00 |
Fixed Monthly Costs
| Item | Amount |
|---|---|
| Rent | $3,300.00 |
| Internet | $500.00 |
| Phone | $444.85 |
| Software | $399.99 |
Company Analysis
THIS MONTHPayment Economics—
| Metric | Value | How it is calculated |
|---|
Payment Mix — every payment attempt0
| Outcome | Payments | Amount | % of attempts |
|---|
Month-by-Month Payment AnalysisCOMPANY-WIDE
NSF & Chargebacks
YEAR TO DATE▶ ⚠ How NSF works in Secure CRM — and what "recovery" counts as
A payment never moves out of NSF. Each instalment on a plan is its own payment record that goes pending → completed or pending → nsf; there is no retry-in-place. The CRM's own payment-change log confirms it — of 4,090 recorded status changes there is not one transition out of
nsf.So recovery can only mean a new completed payment entry dated after the NSF. That is what the numbers below measure, per account.
Ever paid again = the account took a completed payment after its first NSF. Still paying now = it took one after its most recent NSF — the stricter test, and the one that tells you the plan is genuinely alive.
Recovery Summary—
| Measure | Accounts | Payments | Amount | % of NSF $ |
|---|
Recovery by Month of First NSF—
| Month | Accounts | NSF Amount | Recovered Accts | Recovery Rate | Recovered $ | $ Recovery Rate |
|---|
NSF & Recovery by Collector—
| Collector | Accounts | NSF Pmts | NSF Amount | Recovered Accts | Recovery Rate | Recovered $ |
|---|
Repeat Offenders — accounts that bounced more than once—
| Account | Collector | NSF Count | NSF Amount | First | Last | Recovered |
|---|
Chargebacks—
| Collector | Accounts | Chargebacks | Amount | Paid Again | Recovered $ |
|---|
Collector Analysis
THIS MONTHOptional: import a transaction report
Payment data below is pulled from the Secure CRM Payment Management screen and baked in. Only drop a CSV here if you want to override a month (needs Collector, Status, Amount, Date).
— or —
Browse Files
Payments by Collector$0
| Collector | Payments | Collected | Avg Payment | Share |
|---|
NSF, Chargebacks & Charge-Offs by Collector$0
| Collector | NSF | Chargebacks | Charge-Offs | Recoveries | Net Loss | Loss Rate |
|---|
Seat Cost & Break-Even—
| Collector | Payroll Match | Labor | Overhead | Seat Cost | Collected | Over / (Under) | Cost per $1 |
|---|
Payment Statuses — how each one is counted0
Suggestions
HOW TO USE📋 How to Update Your Data
1. Go to Income, Expenses, Payroll, or Withdrawals in the side menu.
2. Click any input field to type or change a value — everything is editable inline.
3. Use the + Add button below any table to create new rows.
4. Hit ✕ on any row to remove it.
5. Click back to Dashboard — all totals and the P&L statement recalculate automatically.
6. Use Export CSV below to download a snapshot of your current data.
7. Your edits now save automatically in this browser and reload next time you open the page. Use Reset to Defaults to wipe them and start fresh.
💡 Recommendations
1
Payroll is trending up fast. $8.5K → $14K in 4 months (65% increase). Watch this against revenue growth.
2
Chargebacks dropped dramatically in Oct — from $3,400+ to $100. Track what changed so you can sustain it.
3
Owner draws decreasing ($16K → $9K → $4K). Good sign of reinvestment if intentional.
4
Fixed costs = ~$4,645/mo. Knowing this helps you calculate break-even each month.
5
This dashboard now gives you a live P&L. Mirror it in your spreadsheet's BACKEND tab for consistency.
Backup downloads everything (all months, expenses, payroll, notes) as a file. Restore loads that file into this browser — use it to move your data to the live site or to another computer.