RAM Partners — CM Fee Tracker

Pipeline

New Project

Capture a project when it’s approved. Invoices are billed against it over time, and the app tracks expected vs. billed fees.

Property

Property *

Pick from the property master. Address & code fill in automatically.

Scope

Client / Owner

Director / Requestor

Project Description *

Project Type

Date Approved

Start Date

Total Contract / Project Value ($) *

Expected Completion

Billed by Draws?

Number of Draws

Fee Basis

Does a CMF apply?

Applicable CMF %

Fee Basis / Agreement Reference

Expected CM Fee (Contract × CMF%)$0.00

Billing & Notes

Bill Timing

Target Bill Month

Notes

Pipeline

Projects

Every approved project and how much of its fee has been billed — your receivables pipeline.

Project #	Property	Description	Status	Contract	Expected Fee	Billed	Remaining	Draws

Construction Management Fee

New CM Fee Invoice

Enter the invoice once — the tool generates the invoice number, the printable invoice, and the receivable for accounting.

Project *

Only Approved/Active projects appear here. Create one on the New Project tab first.

Invoice Date *

Supervisor (you)

Invoice # (blank = auto)

Line Items

Vendor	Description	Invoice $	CMF %	Fee
Balance Due (Total CM Fee)				$0.00

Notes

Population

CM Fee Tracker

Every CM fee invoice across all supervisors — the receivables corporate accounting will book.

Invoice #	Date	Property	Supervisor	CM Fee	Outstanding	Status

Overview

Reports

Where the money is — billed, collected, and what’s still owed.

Project Pipeline — Approved & Active

Open Receivables — Aging

By Supervisor

Supervisor	Billed	Outstanding

By Property

Property	Billed	Outstanding

For Corporate Accounting

Accounting Export — AR Batch

Hand accounting a clean, batched list of receivables to post. Code columns are left blank until the Yardi mappings are added.

For review before posting. This is draft receivable data generated from field-entered invoices. Verify property / customer / GL code mappings and amounts before posting to the corporate books.

Administration

Property Master

The authoritative property list. Projects and invoices pull property code and address from here. Upload a fresh Yardi export to refresh it.

Refresh from Property Information export (.xlsx)

Click to choose your PropertyInformation…xlsx file.

Refresh CM fee % from the fee-tracking sheet (.xlsx)

Sets each property's Construction Management fee % and agreement notes. Matched by property code; kept separate from the Yardi export above.

Click to choose your Construction Fee tracking…xlsx file.

Code	Name	City	ST	Units	Client	Region	CM Fee

Administration

Users

Each supervisor gets their own login. Invoices are stamped with whoever is signed in.

Add a user

Username

Display name

Temporary password

Role

Name	Username	Role	Status

Administration

Audit Log

Every significant action — payments, voids, rate changes, role changes, imports — with who did it and when. Newest first.

When	User	Action	Record	Details