Financial Transactions Report

This report shows detailed financial transactions within the selected time period. Use this report to view all transaction details including type, transaction reference, description, debit/credit accounts, amount and date.


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Reporting PeriodAllow user to select the reporting period from a list of options are set custom a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report.


Fields
Supplier/CustomerSupplier or Customer associated with the transaction if applicable
PO/SOPurchase order or sale order number associated with the transaction if applicable
TypeTransaction type
ReferenceDocument reference number and link to document
DebitDebit account
CreditCredit account
DescriptionTransaction description
DateEffective date of transaction
YearYear in which the transaction took place
QuarterQuarter in which the transaction took place
Month
Month in which the transaction took place
Debit Job #Debit sub-account of Job # if applicable
Credit Job #Credit sub-account of Job  # if applicable
Invoice #Invoice # of the transaction if applicable
Data Headers
Amount
Value of transaction in base currency.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.