Dashboard

A snapshot of every plot, statement and figure on file.

Recovery: not loaded Previous: not loaded
Macho Homelands Β· MH Agency

Rent Statements

Every plot, every payment, every statement β€” in one place.

πŸ’° Financial Snapshot

πŸ•˜ Recent Activity

πŸ“‚
Step 1 of 6

Upload the Recovery Workbook

This is the master file everything else builds from β€” every plot section, every tenant, every month of arrears, read automatically.

1
Drop the file
Any workbook with CODE + ARREARS columns per plot section β€” .xlsx, .xls, or .csv.
2
We read every plot
Plot sections, tenant codes, and however many month-debt columns are present are picked up automatically β€” no fixed layout.
3
Ready for every statement
Once loaded, every plot is available on Generate Statement β€” for as many months as you need this session.

Upload

πŸ“Š

Drop the Recovery workbook here

or

Accepts .xlsx, .xls or .csv

2. Upload Previous Statement

Optional, but recommended β€” auto-fills tenant names, deposits, landlord, commission % and bank details from last month's exported statement.

πŸ“„ Drop last month's exported statement here, or

3. Add Water / Garbage / Electricity

Import a sheet with CODE + AMOUNT columns, or add charges one at a time. Matched by CODE into their own columns on the statement.

CodeTypeAmount
No charges yet for this plot & month.

4. Add Expenses

Manual costs for the plot this month (repairs, supplies, etc.) β€” deducted from gross rent before net pay to landlord.

DateDescriptionAmount
No expenses logged yet for this plot & month.

5. Upload Bank Statement

Upload one or more reconciled bank statements (CODE + Reference + Amount, or a full reconciliation export). Once uploaded, Rent Paid on Generate Statement uses these figures instead of the Recovery-sheet guess.

CodeReferenceAmountDateStatus
No reconciled transactions yet for this plot & month.

β‘  Setup

A statement is loaded in the background.

πŸ•˜ Statement History

PlotMonthStatusGross RentNet PayUpdated
Nothing generated yet. Head to Generate Statement to create your first one.

Agency Profile

Bank & Defaults