How to Track Appraisal Fees and AMC Splits in a Spreadsheet

Residential appraisers often work through AMCs — customer-facing fee splits, net to appraiser, and payment delays of weeks. A free appraisal fee tracker spreadsheet logs each order, gross fee, AMC split, net to you, invoiced, and paid.

One row per order

1. Order ID / property
2. Client or AMC
3. Gross appraisal fee
4. AMC split — dollar or percent per your contract
5. Net fee — what should land in your account
6. Invoiced date and paid date

Monthly sum of net paid is your real revenue — gross fee fantasy numbers mislead tax planning.

Reconcile AMC statements weekly

Import AMC payment batch totals and match to open rows — short pays and clawbacks get a notes column. Unmatched rows are either not yet paid or disputed; both need action.

Direct lender work separately

Orders billed directly to lenders or attorneys skip AMC split columns — filter order type so averages do not blend incompatible economics.

Pair with rental property tracking only for your own portfolio — appraisal fee tracking is business AR, not property cash flow.

When appraisal management platforms win

Integrated order intake, UAD delivery, and AMC portals at high volume reduce double entry. Solo and small-group appraisers often track fees in a sheet until AMC reconciliation errors cost more than software.

These templates are fee tracking tools, not appraisal reports or USPAP compliance systems. Verify appraisal standards and state requirements independently.