Case Studies / East Coast real estate firm
Monthly cash flow reporting went from about 15 hours to under 2
- Client
- East Coast real estate firm
- Industry
- Real estate
- Services
- Spreadsheets
- Tools
- Excel, VBA, AppFolio
A family-led commercial real estate firm was assembling custom cash flow reports by hand from AppFolio exports. ProsperSpark built a macro-enabled workbook that batches those reports.
- About 15 hrs
- Monthly time before
- Under 2 hrs
- Monthly time after
- About 85%
- Less time on the report
- About 25
- Properties in the portfolio
The challenge
The platform report was not the report leadership needed
The firm redevelops historic industrial properties into office, retail, industrial, and mixed-use space. It manages the portfolio in-house and runs accounting in AppFolio.
Each month the team exported three to four reports per property and combined them by hand, including balance sheet adjustments. Across roughly 25 properties, that was about 15 hours.
They looked at AppFolio API access. The workbook was designed to work with the subscription they already had, with an API connection left as a later option.
What a typical day looked like
- Export three to four reports for each property
- Paste them into a custom cash flow format
- Adjust balance sheet items by hand
- Repeat the same assembly next month
What we built
A workbook that batches the report they already wanted
The team still exports from AppFolio into a folder. A macro-enabled button refreshes the data and generates cash flow statements for a chosen month and property. A batch run covers the selected properties in one pass, with print-ready output.
Custom formatting and the balance sheet adjustments sit in the tool, so the report is assembled the same way every month.
How the tools connect
01
AppFolio
Source reports exported to a folder
02
Excel workbook
Powered by VBA, with the client's format built in
03
Batch run
Statements by property and month
04
Leadership pack
Print-ready output for review
Before and after
Assembling the monthly pack
Before: About 15 hours by hand
After: Under 2 hours
Per property
Before: Several exports, combined manually
After: About 4 minutes to export, then one batch
Refresh and batch
Before: Rebuilt every month
After: About 5 minutes for the portfolio
Format and adjustments
Before: Applied by hand
After: Built into the workbook
How the project ran
Start
Discovery
Reviewed the source files and the format leadership needed.
Build
Working draft
Folder import, report generation, and batch runs.
Handoff
Testing
The team ran the workbook and follow-up sessions tightened it.
After
Support
API connection left as a later option.
Dealing with something similar?
More Real estate work
- U.S. property valuation firm: Property valuation firm saves an estimated 12,000 hours a year
Spreadsheets · Excel, VBA, C#
Want results like these?
Tell us what's slowing your team down. We'll walk you through what we'd build.
