How to Run Revenue Reports in Momentum AMS

Revenue Reports
Revenue reports in Momentum AMS help you track both production-based revenue (accrual) and actual cash received (cash basis). This guide explains how to run monthly or custom-period reports and how to reconcile with your bank deposits.

Step 1: Accessing the Revenue Report

Log into Momentum AMS.
Navigate to Interactive Reports.
Search for Revenue Policy Amount (or simply type “Revenue” in the search bar).
Select Revenue Policy Amount.

Step 2: Understanding Report Sections

Top Section (Accrual Basis):
Shows production-based revenue — the premium and commission you generated during the selected period.
Bottom Section (Cash Basis):
Shows commissions actually received — how much cash came in during the selected period.
- This is the most common way agencies run monthly reports.
- Key filter: Agency Commissions Received.

Step 3: Running a Monthly Report

In the cash basis section, enter your date range.
- Example: To see revenue collected in August, set the date range for August 1 – August 31.
Leave other filters blank unless you need to narrow the report.
Click Search.
Review the total commissions received for that period.

Step 4: Adjusting for Deposits Received the Following Month

Often, commissions for one month are received in the first week of the next month. To capture this:

Example: For August commissions, run the report for August 11 – September 10.
This will include checks received in early September but tied to August production.

This adjusted range will better match your bank deposits.

Step 5: Verifying with Bank Deposits

To reconcile with your bank account:

In the report filters, select Funds Received Amount.
Enter your custom date range (e.g., Aug 11 – Sept 10).
Compare totals against your bank statement deposits.
Each deposit should match a corresponding entry in the report.

This helps ensure all statements have been processed and align with actual cash received.

Step 6: Reviewing Totals

Reports will show totals by:
- Personal Lines
- Commercial Lines
- Agency Bill / Direct Bill
The grand total at the bottom is the accurate number for the period.

Key Tips

Use cash basis (bottom section) for actual commissions received.
Use accrual basis (top section) for production numbers.
Adjust your date ranges if commission checks were deposited the following month.
Always reconcile report totals with your bank account deposits.

Pro Tip:
For monthly reconciliations, many agencies run reports from the 11th of one month through the 10th of the next. This “rolling window” captures late deposits and makes reconciliation with bank statements much easier.