One of the many Financial reports you can generate is the Transactions report. This report allows you to view and export transactions in your database.
In the Search section are various fields and menus to narrow or broaden the results. To the right in the section header is a dropdown to add different search options. To the right of each option is a red X, which will simply remove them from view and place them in the Add dropdown.
If you are searching by Date, you can click the field name and choose from four different Date type options.
- Transaction Date: This is the date used for the transaction.
- Whole Date: This is the date of the transaction’s whole, if it is a non-deposit split.
- Creation Date: This is the date the transaction was created in your database. This can often be different than the date of the transaction.
- Edit Date: This is the date if the transaction was edited at any time.
Towards the bottom of the Search section are Split and Memo Handling options. These allow you to include or exclude Splits and Wholes, as well as Memos and Non-Memos.
After you’ve chosen the criteria for the report, you can then determine what specific columns of information you’d like to see, including sorting the data or aggregating transaction totals.
In the Display section is your option field for Columns. These are how your data will display on the screen, as well as export to a spreadsheet.
The Columns section contains all the ways to display the data, ranging from basic info like Amount and Date to more complex or in-depth data, such Allocation or Transaction Tags, if applicable.
It’s important to note that some Column options, such as All Emails and All Phones, take the system longer to sort through, which can cause the report generation time to be a little longer than usual.
There are three fields that, while similar, can affect your report totals in different ways:
- Amount: the raw amount of the transaction.
- Net Worth Impact: the transaction’s impact on the organization’s net worth.
- Cash Impact: the transaction’s impact on the organization’s cash.
These fields will have different numbers based on the nature of the transaction. For example, a $500 expense would have values of:
- Amount: $500
- Net Worth Impact: -$500
- Cash Impact: -$500
An In-Kind Contribution of $200 would have values of:
- Amount: $200
- Net Worth Impact: $0
- Cash Impact: $0