Financial Reconciliation Activity Report

The Financial Reconciliation Activity Report provides a detailed Excel spreadsheet with a single line item for every financial transaction recorded in your event. This report is commonly used to reconcile payments, verify transaction history, and analyze financial activity across your event.

💡 Good to Know: This report can be found under Reports > Financial Reports > Financial Reconciliation Activity Report.

In the Financial Reconciliation Activity Report Popup

When opening the report, you can choose one of the following options:

• All Transactions – Includes every financial transaction recorded for the event.
• Select Date Range – Generates the report for transactions within a specified date range.

1. Review the Report

The report includes:

• A single line item for every financial transaction recorded in the event.
• Contact ID
• First Name and Last Name
• Company Name
• Phone Number
• Email Address
• Mailing Address
• City, State, and ZIP Code
• Transaction Date
• Payment Amount
• Payment Type
• Card or Check Number
• Item Price
• Fair Market Value (FMV)
• Item Type
• Item Name

💡 Good to Know: Each row represents a single financial transaction, making it easy to review payments, purchases, and other financial activity.

2. Export the Report

After clicking Submit, the report will save to your computer and automatically open as an Excel spreadsheet.

The spreadsheet version is useful for:

• Sorting and filtering transaction data.
• Reconciling deposits and payment activity.
• Reviewing financial records.
• Performing additional analysis.

3. Use the Report

Use this report to:

• Reconcile financial activity for a specific day or date range.
• Verify payment amounts and payment methods.
• Review purchases and other financial transactions.
• Search for transactions by Contact ID, guest name, or company.
• Sort transactions by date, Contact ID, guest name, or company.
• Analyze financial activity using Excel's filtering and sorting tools.

💡 Good to Know: This report is commonly used to reconcile deposits, verify payment activity, and research transaction history.

Printable Quick Help Guide:

(see  below for printing instructions)

How to Print This Guide

1. Right-click on the image of the guide
2. Select Save Image As…
3. Save the file to your computer
4. Open the saved image
5. Click Print (or use Ctrl + P / Command + P)

💡 Good to Know

For best results, print using Full Page or Fit to Page settings to ensure proper sizing and clarity.