What is it?
The Transaction Report provides an overview of all The Transactions throughout your account.
How to Access
Navigate to Financial > Transaction Report
What does it do?
The Transaction Report shows:
-
Invoice ID
-
Transaction Date
-
Transaction Type
-
Description
-
Amount
-
Payment Method
-
Status
-
Trans/Check #
-
Revenue Account
-
First Name
-
Last Name
-
Organization
Using the Transaction Report
Each financial transaction made in your MC Professional product will be shown in the Transaction Report. There are multiple ways to filter the results of the report, and it can be exported for upload into your accounting software.
- Transaction Date Range
-
Filter By Revenue Account
-
Filter By Transaction Type
- Filter by Transaction Status
-
Filter By Payment Type
-
Filter By Credit Card Type
Filtering by a Transaction Date Range
By using the Transaction Date Range, you are able to run a report of each transaction for a specific date range.
Filter By Revenue Account
Filtering by a Revenue Account will allow you to show only the transactions related to a specific Revenue Account.
Filter By Transaction Type
Filtering by Transaction Type will allow you to show a report of each Transaction Type. A Sale is generated when an invoice is created, so all invoices will possess a Sale line item. A Payment line item will only be generated when an item within an invoice is paid. Refunds will be attached to credit memos, which are invoices that focus on providing refunds, while settlements mark credit memos that have been successfully refunded through your credit card payment processor.
Filter By Transaction Status
Filtering by Transaction Status will allow you to pull a report dependent on the Transaction Status of the the transaction. The most common statuses used are Paid, Approved, and N/A. Credit cards typically possess a status of Approved, as they are being approved by your processor. Checks often possess the Paid status, as they don't need to be approved by the processor. N/A can sometimes be used for checks while also accommodating other forms of manual payment, such as applied credits, offline credit cards, or cash. When seeking to locate all of your paid transactions, it is recommended to have at least these three options selected, as the majority of payments fall into these categories.
Filter By Payment Type
Filtering by Payment Type will allow you to pull a report dependent on the Payment Type of the transaction.
Filter By Credit Card Type
Filtering By Credit Card Type will allow you to show only the transactions related to a specific card type.
Hide Pro Forma Invoices
You are able to exclude Pro Forma invoices (classified here as being any unpaid, system-generated membership dues invoice) by clicking the "Hide Pro Forma" checkbox
Combining Filters
Multiple filters can be combined to generate a unique set of results.
Exporting Reports
The Transaction Report is exportable as an CSV or IIF file, which can be imported into your accounting software. See this article for details.
Comments
13 comments
What is the difference between transaction type "payment" and "sale"?
Hi Crystal - Each transaction will have two components -the sale and the payment. The "sale" happens when a form is submitted with a dollar amount associated - it's the agreement to pay. The "payment" occurs when the actual payment is applied. For example, if a member wants to pay immediately with a credit card, the sale and payment will occur at the same time. Alternatively, if a member chooses "Invoice Me" for their payment method and mails in a check, the sale will occur when the form is submitted, and the payment will occur when an Admin applies the check payment to the Open invoice. Hope that helps!
When I filter the transaction report, selecting Payment type of Credit Card or Credit Card Refund - why am I seeing transactions Check or Cash transactions on the screen as well?
Hello Marsha! I've submitted a Help ticket on your behalf for that question so the team can look into that for you. We'll be in touch!
Is it possible to search for profiles that have auto-renewal (recurring payment) setup?
Hello Brenda! If you pull an export of your membership, "Auto Renew" is an exportable piece of information that will be listed as either Off/On. I hope that helps!
I'm trying to run a report that just shows paid transactions with the payment method included and I can't figure out how to do it. If I filter on Transaction Status "Paid" I only get Transaction Types of "Sale" and it does not show the method of payment. If I filter on Transaction Type "Payment" I can see the payment method, but the Transaction Status is "Approved" and the only transactions showing are credit card sales. Every check payment only has a Sale transaction and the payment method is empty. I need to go to the individual profile to confirm that they paid by check.
How do I run a report that shows all paid transactions with the payment method included?
Hello Jean! I've opened up a Help ticket for you so they can investigate what Payment Method isn't showing up for you when you filter by "Payment". We'll be in touch!
Thank you!
Is it possible to tell if a payment was submitted by a member on the front end through their account, or by an admin on the back end on the member's behalf (ex: if they called to make a payment over the phone), and to filter the transactions accordingly?
Hello Emily! There isn't a differentiation between a member submitting their own payment or an admin processing it on the back-end, at this time. If that'd be helpful for you, please feel free to submit feedback for the idea.
What does Open mean?
Hey there Judith! "Open" as a status means that the Invoice is still Unpaid. I hope that helps!
Please sign in to leave a comment.