Transaction Export

The Transaction Export function is selected by clicking the Transaction Export icon from the Financial tab, in the General group of the ribbon menu.

Transactions created can be exported in CSV (Comma Separated Value) format which can then be imported into Excel and other financial packages.

The export file contains the following fields:

ID
Added Date and Time
Due Date
Product ID
Product External Account Code
Product Description
Cost Centre ID
Cost Centre External Account Code
Cost Centre Description
Contact ID
Contact Name
Contact Type
Property ID
Property Name
User ID
Statement ID
Invoice ID
Tax Rate
Payment Method ID
Payment Method Description
Credit
Debit
Credit Tax
Debit Tax
Status
Status Date
Statement Notes
Tenancy ID
Split ID
Bank Reconciliation
Bank Account ID
Bank Account Name
Banking Date

Producing the Transaction Export

The location of where the file will be produced will be shown in the File Name field.
The Date Range field enables you to specify a Due Date range, by default this will be today.
The Bank Account field enables you to choose the Bank Account the Statements were produced against.
Click Run.
A message will confirm the file has been produced, click Yes if you want to view the file now.