Skip to content
Workflow · Finance close · Opening soon

Owner statement by property

Export the AppFolio Property Ledger and the AppFolio Management Fee List. Then map the owner fee rate and make the monthly statements.

Early access opens shortly. Check back soon.

Someone typed

“build each owner's monthly statement lines: rent collected, management fee, repairs and other expenses for each property, and the net amount owed to the owner”

The agent read it as

Build each owner's monthly statement lines: rent collected, management fee, repairs and other expenses for each property, and the net amount owed to the owner for AppFolio Property Ledger and AppFolio Management Fee List.

What the agent built

2 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    AppFolio Property Ledger
    CSV export · 41 rows
  2. File
    AppFolio Management Fee List
    CSV export · 5 rows
  3. Join
    Add owner fee rate
    41 of 41 paired
  4. Step
    Make monthly statements
    Step 2
  5. Result
    Owner Monthly Statements
    8 rows
  6. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 41 of 41 rows.

What you get back

The result of that run, the rows to look at first.

Owner Monthly StatementsSample data8 rows
OwnerPropertyRent collectedManagement feeRepairsOther expensesNet amount owed to owner
Amber Lane PartnersCedar Flats4,280321-425-348.203,185.80
Amber Lane PartnersMaple Court3,970297.75-260-269.603,142.65
Harborview CapitalWillow Ridge4,820457.90-390-135.553,836.55
Keystone ResidentialLinden House3,520299.20-285-227.502,708.30
Keystone ResidentialPine Terrace4,550386.75-1,040-261.902,861.35
Northstar CapitalBirch Grove3,250260-310-202.752,477.25
Northstar CapitalOakview Apartments3,700296-245-231.402,927.60
Solstice PropertiesSpruce Meadows3,190255.20-210-190.252,534.55
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Owner Monthly Statements workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Owner Monthly Statements: questions

How do you build an owner statement template by property?
Export the AppFolio Property Ledger and the AppFolio Management Fee List. Then map the owner fee rate and make the monthly statements. Mammoth groups the rows by owner and property, calculates the statement lines, and gives you the net amount owed to each owner.
What export should you use?
Use the AppFolio Property Ledger and the AppFolio Management Fee List. Export them in the format you normally use for those reports, then upload the files to the workflow.
What happens to rows that do not match?
Rows that do not match the rules are left out of the statement output. You can review them, then adjust the rules or the source file and run the workflow again.
How do you change the rules?
Edit the rule names in plain words, like owner fee rate or statement line types. Then rerun the workflow so it uses the updated rules on the exported files.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →