Blog · Appraisers

Tracking AMC Orders From Email Without Retyping Them

AppraiseQ team · 6 min read · 31 October 2026

If you take work from more than two or three AMCs, your inbox is already your order system whether you planned it that way or not. Every engagement letter, assignment notice, due-date change and "please provide an update" request lands there first. The trouble is that an inbox is a terrible place to see what is due this week. Orders get buried under revision requests, portal notifications and newsletters, and the one email that changed a due date from Friday to Thursday is easy to miss.

Most appraisers respond by copying each new order into a spreadsheet or a planner. That works until a busy week, when the copying stops and the spreadsheet quietly goes stale. This post walks through a way to track AMC orders straight from the emails you already get, so the order list stays current without you retyping anything.

Why retyping orders breaks down

Retyping feels harmless because each order takes only a minute or two. The real cost is not the minutes. It is what happens when you skip it.

• It happens at the worst time. New orders tend to arrive in clusters, often while you are in the field or finishing another report. That is exactly when you postpone the data entry.
• Changes don't get copied. You might log the original order, but a later email that moves the due date, adds a second unit or changes the product from a 1004 to a 1073 often never makes it into the sheet.
• Typos hide. One wrong digit in a due date or a fee looks fine in a spreadsheet and only shows up when an AMC asks where the report is, or when a payment does not match.
• It lives in one place. A spreadsheet on your laptop does not help when you are standing in a driveway on your phone trying to remember whether the next job is due today or tomorrow.

What an AMC order email usually contains

Formats vary a lot from one AMC to the next, but most assignment emails carry the same core facts somewhere in the message or in an attached engagement letter. When you set up any tracking system, these are the fields worth capturing:

If a field is not in the email, leave it blank rather than guessing. A blank fee is a reminder to check the engagement letter. A guessed fee is a future argument.

Step 1: Get all AMC mail into one stream

The first job is to stop AMC email from mixing with everything else. In Gmail, a filter on the sender addresses or domains your AMCs use can apply a label, skip the inbox, or forward the messages somewhere else. Build the filter from real messages: open a recent order from each AMC, note the exact sender address, and add it to the filter's "From" field. Many AMCs send from a no-reply address for assignments and a different one for payments or account notices, so check a few emails from each.

We cover the setup in detail, including the common mistakes, in Gmail filters for vendor order emails. The short version: one filter per AMC is easier to maintain than one giant filter, and you should test each filter against old mail before trusting it.

Step 2: Decide where the order list lives

You have three realistic options, each with trade-offs.

1. A labeled Gmail folder you review daily. Zero setup, but you still have to open each email to see the due date, and nothing sorts orders by when they are due.
2. A spreadsheet fed from email. Some appraisers use email-to-sheet add-ons or scripts. These can work, but AMC emails change format without warning and the parsing breaks quietly. See tracking orders from email vs a spreadsheet for a fuller comparison.
3. An order tracker that reads the emails for you. A tool that pulls the address, client, product, fee and due date out of each order email and keeps one list sorted by due date. The emails stay the source of truth, and the list updates itself.

Whatever you choose, the test is simple: can you see every open order, sorted by due date, on your phone, in under ten seconds? If not, the system will fail you on a busy day.

Step 3: Handle the emails that change an order

The first order email is the easy part. The harder part is the follow-up mail that changes something. Make sure your routine catches these:

• Due-date extensions or accelerations
• Fee changes, including approved fee increases for complexity or rush
• Product changes (for example, a traditional order converted to a hybrid)
• Cancellations and on-hold notices
• Revision requests, which reopen a "submitted" order

A good habit: whenever an AMC email mentions an existing order number, open that order in your list and confirm it still matches. If you use a tool that reads email, check that it links the follow-up to the original order rather than creating a duplicate.

Step 4: Keep a short review loop

No automated system reads every email perfectly. AMCs redesign their templates, some orders arrive only as a portal link, and some details live only in a PDF. Build a two-minute review into your morning:

• Scan the list for any order with a missing due date or fee and fill it in from the engagement letter.
• Look for emails from AMC senders that did not turn into an order and check whether they should have.
• Confirm today's and tomorrow's due dates against the AMC portal for anything that looks off.

This is far less work than typing every order, and it catches the exceptions instead of the routine.

A worked example

Say you work with four AMCs. On Monday morning you get three new assignments, one due-date extension and a revision request. With a retyping workflow, you would open five emails, copy the details of three orders into a sheet, find and edit the extended order, and change the revised order's status. On a quiet Monday that is fifteen minutes. On a Monday when you are already driving to an inspection, it is "later," which often means never.

With a forwarded-email workflow, the three new orders appear in your list with their due dates, the extension updates the existing order, and the revision request flags the submitted order as needing work. Your job is to glance at the list at lunch and confirm nothing looks wrong.

This is the approach the AppraiseQ order tracker takes: you forward your AMC emails with a Gmail filter, it reads orders, due dates and fees, and it reminds you the evening before and the morning a job is due. It never logs into AMC portals or accepts orders for you.

Common mistakes to avoid

• Forwarding all your mail. Only forward AMC senders. Personal and client mail has no place in an order tracker.
• Trusting the email's time zone blindly. If an AMC states a due time without a zone, confirm it in the portal or engagement letter.
• Ignoring the portal entirely. Email is a good feed, but the AMC's portal is still the official record of the assignment. When the two disagree, the portal usually wins, so check it.
• Never pruning. Mark orders completed and paid so the open list only shows what still needs you.

The bottom line

You already receive every fact you need to track your AMC work. The goal is to stop moving those facts by hand. Route AMC mail into one place, let something sort it by due date, and spend your attention on the exceptions. Once the list keeps itself current, it becomes the foundation for everything else: tracking turn times, following up on payments and knowing which clients are worth your time.