On this page
What's a transaction report?
The Transaction Report exports all or filtered transactions from the Financial module as a CSV or IIF file. Use it to review transaction data or import it into your accounting software, such as QuickBooks.
Go to Financial > Transaction Report.
Exporting your transaction report
The Transaction Report page shows all transactions in your account. Filter the list by:
- Date range
- Revenue account
- Transaction type
- Transaction status
- Payment type
- Credit card type
Exported files contain only the transactions currently displayed — apply all filters before exporting. For example, filtering by date range exports only transactions within that range.
To export a transaction report:
- Set your filters, then select EXPORT CSV or EXPORT IIF.
- Open the downloaded file:
- CSV: Open in Excel to review transactions.
- IIF: Open in a plain text editor such as Notepad to verify, or import directly into QuickBooks Desktop.
For more information on importing IIF files and QuickBooks version compatibility, see Financial accounting overview in Oasis.
Filtering your transaction report
Apply filters before exporting to control which transactions appear in your file. See Transactions Overview for a full list of filter options.
Your process for financial reporting
Use MC Professional as your transactional system of record and your accounting software — such as QuickBooks — as your financial system of record. All invoices and transactions should occur in MC Professional; export transaction amounts for financial reporting in your accounting software.
Use this process after all transactions have been recorded in MC Professional:
- Confirm revenue account setup is complete and accurate in MC Professional.
- Export on a consistent schedule to avoid duplicating transactions — for example, export the previous month's transactions at the start of each month.
-
In the Transaction Report, filter by date range and any additional filters needed.
Caution: Always set a specific date range. Exporting without one may include transactions already exported in a previous run. - Export transactions as an IIF or CSV file.
- Import transactions into your accounting software.