On this page
- What's a transaction report?
- Exporting your transaction report
- Filtering your transaction report
- Your process for financial reporting
What's a transaction report?
From the Financial module you can export a report of transactions as a CSV or IIF file. You can view this file for at-a-glance information of all transactions or only transactions made during time period. You can also generate this file to import into your organization's account software, such as Quickbooks.
To access the Transaction Report tab, follow these steps:
1. Navigate to Financial module and select the Transaction Report tab.
Exporting your transaction report
On the Transaction Report page, you can view a list of transactions made through your account. You can filter the list by:
- date range
- revenue account
- transaction type
- transaction status
- payment type
- credit card type
When you filter the list and export, your file will contain only the transactions filtered and displayed in the current list. For example, if you filter by date range, your export will contain only transactions made within that date range.
To export a transaction report, follow these steps:
1. Set your desired filters, then select EXPORT CSV or EXPORT IIF depending on which file type you require.
2. The file will download. If it's a CSV file, you can open and view the file in Excel. If it's an IIF file, you can either open it in a plain text editor, such as Notepad to check the transactions, or import the file into your desktop version of QuickBooks.
If you're unfamiliar with importing files into QuickBooks, as well as which versions of QuickBooks are compatible with an IIF file, click here to view our guide on importing files into QuickBooks.
Filtering your transaction report
By choosing a Filter or Date Range you are able to export the specific information needed from the Transaction Report. You can view our guide that details all your filter options by clicking here.
Your process for financial reporting
MC Professional should be used as your transactional system of record with your accounting system (QuickBooks, for example) used as your financial system of record. In other words, all member invoices and transactions should occur in MC Professional with the transaction amounts exported out for financial reporting in your accounting system.
Therefore, the following steps should be used as a guideline for your financial reporting process once all transactions have occurred within MC Professional:
- Ensure Revenue Account set up is complete and accurate in MC Professional.
- Use a standard cadence for exporting transactions to ensure you do not export the same transaction twice (i.e. once a month you export the previous month's transactions).
- Using the Transaction Report, filter all desired transactions using the date range and filters. NOTE: Date range is absolutely critical to ensure you do not export the same transaction twice.
- Export transactions to IIF or CSV depending on requirements.
- Import transactions into your accounting system.