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

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