Exporting Transactions to CSV Files

You can export transaction information and data to CSV-format data files. You can export transactions that are associated with a property and person (resident/tenant, owner, or vendor). Voyager exports one record for each line-item detail in a transaction. For transactions with multiple details, the export file contains multiple lines of data. When imported, the lines recombine to form one transaction in the destination database. You can also select or create a format template (FMT) file to specify and define the exported data for importing back into Voyager or to other financial applications. For more information, see “Using format templates for exporting to CSV files”. Exporting transactions does not affect the source database.

How to...

To export transactions to a CSV file

To create a default format template file

To export transactions to a CSV file

1	From the Voyager System Administration side menu, select Toolbox > Import/Export > Export Tran - CSV. The Export Transactions - CSV filter appears.

2	Complete the following fields, as needed:

Property Type or select the code of the property from which you want to export transactions.

Person If you want to export only those transactions that are associated with a person (resident/tenant, vendor, or owner), type or select the code for that person. If you want to export transactions regardless of any associations to specific people, leave this field empty.

Tran Type Select the types of transactions that you want to export.

Post Month Type a post-month range for the transactions that you want to export. If you want to apply a date filter, do one of the following:

n	If you want to export all transactions that were posted on or after a certain month, type the month and year in the first field and leave the second field empty.

n	If you want to export all transactions that were posted before or in a certain month, type the month and year in the second field and leave the first field empty.

n	If you want to export transactions for only one post month, type the same month in both fields.

n	If you want Voyager to use the current operating month as the default post month, leave both fields empty.

Date Type a date range for the transactions that you want to export. If you want to apply a date filter, do one of the following:

n	If you want to export all transactions that were made on or after a certain date, type the date in the first field and leave the second field empty.

n	If you want to export all transactions that were made on or before a certain date, type the date in the second field and leave the first field empty.

n	If you want to export transactions for only one month, type the same month in both fields.

Exclude Reversals Select Yes or No, depending on whether or not you want to export reversed transactions from the export file (for example, those resulting from operations such as Reverse Receipt, Reverse Invoice, Void Check, or Reverse Journal Entry).

Open Only If you want to export only open transactions, select Yes. If you want to export all transactions, both open and closed, select No.

If you select Yes, this option will strictly limit the transactions eligible for export and can override other import filter selections, such as date ranges.

FMT File If you want to apply a format template file to the export data, type or select the template file name and path in the FMT File field.

For more information about creating a default format template file, see “To create a default format template file”.

For more information about using format template files, see “Using format templates for exporting to CSV files”.

3	Click Submit. The File Download screen appears. Do one of the following:

4	If you want to open the file in a CSV editor, click Open.

5	If you want to save the file, click Save.

To create a default format template file

1	If the Export Transactions - CSV filter is not already open, open the screen. For more information, see “To export transactions to a CSV file”.

2	Click Default Format. The File Download screen appears. Do one of the following:

n	If you want to open the file in a text editor, click Open.

n	If you want to save the file, click Save.

The format file name that you specify is the one that you will type or select in the FMT File field on the Export Transactions - CSV filter. For a list of the format template fields (current at time of publication), see “Format template files”.

3	You must adjust the format template so that you export only the fields that you need. If you remove any fields, you will have to renumber the template rows so they are sequential.

Additional Information

Transaction and Trial Balance Exports

Using format templates for exporting to CSV files

Exporting Transactions to XML Files