Revenue Reports offers many reports to summarize various revenue data, such as accounts receivable summary, collection reports, and revenue by type. It contains sections for Accounts Receivable Reports, Invoice Reports, Payment Reports, Statement Reports, Billing Reports, Transaction Reports, Cross Tab, and Pledge Reports.
-
Accounts Receivable Reports:
- Accounts Receivable Summary: This report shows an accounts receivable summary based on a specified date. It is broken down by revenue item and then by age.
- Accounts Receivable Summary By Profile: This report shows an accounts receivable summary as of a specified date. Very similar to the Accounts Receivable Summary, but broken down by profile instead of revenue item.
- Aging Overview: This report offers a breakdown of outstanding balances. On the first page, there is a bar graph that shows the overall outstanding balance (y-axis) for each age range (x-axis).
- Aging By Profile: This report shows all profiles, with main contact information, and a list of all unpaid invoices.
- Aging by Revenue Item (All Open Invoices): This report shows all selected revenue items and, underneath each revenue item, a breakdown of profiles that have unpaid invoices with that revenue item.
- Aging by Revenue Item as of Specified Date: This report shows all selected revenue items and, underneath each revenue item, a breakdown of profiles that have unpaid invoices with that revenue item, based on a specified date.
- Aging Details: This report shows accounts receivable information. It is broken down by selected revenue items, and includes the invoice date and number.
- Collections Report: Each section of this report shows a profile (member and non-member) with open invoices. This can be configured to include all invoices, only invoices that are classified as dues, or only non-dues.
- Pre-Pays: This report summarizes all pre-payments made within a specified time frame.
- Unapplied Payments Outstanding: This report summarizes all unapplied payments with outstanding balances, and lists the profiles and their unpaid balances.
-
Invoice Reports:
- Invoices By Date Range: This report shows all invoices from within a specified date range.
- Invoices By Creation Batch: This report shows all invoices from a specified invoice creation batch.
- Invoices By Posting Batch: This report shows all invoices from a specified invoice posting batch.
- Invoices By Invoice Number: This report pulls an invoice based on the invoice number.
- Invoices By EventID: This report pulls all invoices associated with a specified event.
- Open Invoices By Aging Period: This report shows all open invoices based on a specified aging period.
- Open Invoices By ProfileID: This report shows all open invoices, sorted by Profile ID.
- Invoice Creation Log (Auto Generate Log): This report creates a log of all invoices that have been created in a specific invoice batch.
-
Payment Reports:
- Payment Totals: This report lists all profiles and the total spend within each payment category (Dues, Non-Dues, Event Sponsorship, Event Attendance, and Other), and the member's total payments from within a specified date range.
- Payment Listing by Date: This report provides a list of all payment listings, both applied and unapplied, from a specified date range.
- Payments Processed: This report shows a breakdown of all payments within a specified date range, including payment type, batch number (if posted), revenue item, profile name and ID, payment date, and amount.
- Unapplied Payments Received: This report summarizes all unapplied payments received within a specified date range.
- Unapplied Payments Outstanding: This report lists all outstanding unapplied payments beginning from a specified date.
- Payments and the Revenue Items They Were Applied Against: This report lists all revenue items, and lists payments made for this item below.
- Cash Receipts: This report shows a breakdown of all payments (not just cash) within a specified date range.
- Credit Card Transactions: This report provides a list of all credit card transactions within a defined date range. It includes fields such as invoice date, profile, and amount, and includes transactions that have not been processed.
- Top 20 Profiles by Payments: This report lists the top 20, 50, or 100 profiles based on total amount paid.
- Holding Tank Payments: This report applies only to the desktop version of MC Trade. This report summarizes all membership requests in the holding tank with payments attached.
-
Statement Reports:
- Statement (All Profiles With Open Invoices): This report creates a statement for each profile with open invoices.
- Statement By ProfileID: This report creates a statement for a specified profile.
-
Billing Reports:
- Annual Billings by Anchor Month: This report provides an overview of annual, semi-annual, quarterly, and monthly billing records based on anchor month.
- Projected Billings for All Months: This report lists projected billings, sorted by month.
- Billings for All Months by Revenue Item: This report summarizes billing by revenue item based on a specified date.
- New Billing Records Created: This report summarizes all new billing records created within a specified time frame.
-
Transaction Reports:
- Accounting Package Journal Entries: This report summarizes all journal entries for a specified batch number.
- Transactions Posted By Debit/Credit By Batch: This report summarizes transactions posted within a specified time frame, sorted by batch, and my debit/credit transaction.
- Transactions Posted for Selected Account: This report summarizes all transactions posted for specified account codes, within a specified date range.
- Transactions Posted for Selected Class:Subclass: This report summarizes transactions posted based on class or subclass.
- Transactions By Debit/Credit (Posted or Unposted): This report summarizes all transactions completed with debit or credit, whether it's posted or not posted.
- Unposted Transactions: This report provides an overview of each day within a specified time frame, and summarizes all posted and unposted transactions.
- All Transactions for a Profile: This report creates a full transaction history for each profile.
- Adjustments by Type: This report lists all invoice adjustments made within a specified time period.
- Revenue By Type: This report shows a list of selected revenue types with the total revenue for each type.
- Dues Vs. Non-Dues Revenue: This report provides a pie chart breaking down all due and non-dues revenue within a specified time period.
- Dues Billed And Paid By Due Date: This report lists all dues that have been billed to member profiles based on a specified time frame.
- Two-Year Comparison of Revenue Invoiced: This report creates a comparison chart for a selected year's revenue invoiced, and compares it to revenue from the previous year.
- Batch by Payment Type: This report shows all transactions sorted by payment type within a specified date range.
- Batch by Product: This report shows all transactions grouped grouping by product within a specified date range.
- Invoices Billed And Paid By Month: This report summarizes all invoices that have been billed and paid within a specified time frame, and organises them by month.
- New Member Income: This report summarizes all revenue from new memberships made within a specified time frame.
- Deferred Revenue Recognition: This report shows all transactions marked with deferred revenue.
- Deferred Revenue Recognition (Invoice Based): This report shows all transactions marked with deferred revenue, organised by invoice.
- Deferred Revenue Recognition (Payment Based): This report shows all transactions marked with deferred revenue, organised by payment type.
- Sales By User: This report shows all sales opportunities created and closed, organised by system user.
-
Cross Tab:
- Profiles and Revenue Items: This report provides a breakdown of each profile's total revenue interaction with specified revenue items.
-
Pledge Reports:
- Pledge Campaign Totals: This report shows all totals from a specified pledge campaign.
- Pledges And Invoices/Payments: This report shows all invoices and/or payments for specific pledges.