Transactions (Comparison Report) explained
The "Transactions Comparison Report" is used to compare transaction logs on a monthly basis, allowing businesses to identify new transactions, existing ones, and dropped-off transactions. It provides insights into changes in transaction patterns over time, aiding in financial analysis and decision-making processes.
Step 1: Set Up the Report
- Navigate your Insights > Reports.
- Select the Report Category "Stats & Summaries".
- Select the Report Type as "Transactions (Comparison Report)".
- Set your date range.
To extract this report you must choose dates from two different calendar months.
Your dates should not be more than 6 months apart.
- Choose your preferred payment methods which you would like to see the transactions of.
- Generate the report. The report will be emailed to the user who generated the report.
Step 2: Define Report Parameters
Comparison Status Definitions
| Status | Definition | Explanation |
| New | Transactions that are present in the current month's logs but were not found in the previous month's logs. | These transactions represent growth of new accounts within the specified date range. They indicate new subscriptions, purchases since the last comparison month. |
| Existing | Transactions that are present in both the current month's logs and the previous month's logs. | These transactions denote ongoing or recurring transactions. They represent loyal customers. |
| Dropped Off | Transactions that were present in the previous month's logs but are not found in the current month's logs | These transactions have ceased or failed for various reasons, such as cancellation, dispute, or non-payment. They no longer appear in the current records and may require further action, such as reactivation or follow-up with the account holder. |
Sheet 1
This sheet provides an overview of the transaction comparison report. It includes the total number of records and the total amount for each month in the specified date range. Additionally, it categorises transactions into new, existing, and dropped-off, providing a comprehensive summary.
Log sheets
- Overall, each Log sheet serves as a detailed record of transactional activities for that month, allowing users to review, analyse, and track changes in financial transactions over time.
- Each row will represent an individual transaction, with columns providing detailed information about each transaction.
- Comparison Status:
- The Comparison Status column will specify whether the transaction is new or existing based on the comparison with the previous month's logs.
The comparison status provides users with insights into the changes and trends in transaction activity over time.
Dropped sheets
- The sheets titled "Dropped" will contain records of transactions that were present in the previous month's logs but are not found in the current month's logs.
- Similar to the Logs sheet, each row will represent an individual transaction that has been dropped off.
- Reason for Dropping:
- A column will specify the reason why each transaction has been dropped.
- Possible reasons may include cancellation by the account, disputes, unpaid balances etc.
- A transactions will not have a reason specified if the subscription got cancelled manually.