Skip to content
ProsperSpark

Case Studies / East Coast real estate firm

Real estateSpreadsheets

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

  1. 01

    AppFolio

    Source reports exported to a folder

  2. 02

    Excel workbook

    Powered by VBA, with the client's format built in

  3. 03

    Batch run

    Statements by property and month

  4. 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

  1. Start

    Discovery

    Reviewed the source files and the format leadership needed.

  2. Build

    Working draft

    Folder import, report generation, and batch runs.

  3. Handoff

    Testing

    The team ran the workbook and follow-up sessions tightened it.

  4. After

    Support

    API connection left as a later option.

Want results like these?

Tell us what's slowing your team down. We'll walk you through what we'd build.

Book a call