Export File window

Export File window

The Export File window enables you to set some of the criteria that will determine what data will be exported from your company file.

Field Descriptions

Export File Format

Select whether you want to save the exported data in a tab-delimited or comma-separated text file format. In a tab-delimited file, the data is separated by tab spaces. In a comma-separated file, the data is separated by commas. If you will be importing this data into another company file, you can select either format.

First Record is

Select whether you want the first record in the export file to be a header record or a data record. If you select Header Record, the first record in your export file will contain the field names. If you choose Data Record, the first record in your export file will contain data. If you will be importing this data into another company file, you can select either format.

This option appears only if you’re exporting accounts.

Select the year and the month for which you want to export the ending balances of your accounts.

This option appears only if you’re exporting sales or purchases.

Select the status of the sales or purchases you want to export.

This field appears only if you’re exporting cards, reminder logs, activities, sales or purchases.

Type the identifiers you want to use to filter the cards and transactions that are exported. Only the cards who have been assigned all of the identifiers (or all of the transactions whose assigned cards have the identifiers) will be exported.

This field appears only if you’re exporting cards.

Type the postcode you want to use to filter the cards that will be exported. You can enter a partial postcode (for example, the first three digits of the postcode) to include all cards whose postcodes begin with the numbers you have entered.

This field appears only if you’re exporting journal entries.

Select the journal from which you want to export journal entries. If you select Disbursements or Receipts, you can also choose the type of disbursements or receipts that you want to export.

These fields appear only if you’re exporting journal entries, activities, inventory adjustments, reminder logs, sales or purchases.

Enter a date range if you want to filter the transactions that will be exported to only those that are dated within those dates.

These fields appear only if you’re exporting cards.

Select the custom list entries you want to use to filter which cards will be exported. Only the cards that have all of the custom list entries you specify will be exported.

Include Journal Entries in Export File

Select this option if you want to include journal entries in the export file along with the Company Information and the account balances of an AccountantLink export. Journal entries for the current financial year up to the end of the month you enter in the Dated to end of field will be exported.

Dated to end of

Select the last month of the period you want to include in the export file. The balances of your accounts as at the end of the month (from the beginning of the current financial year) will be exported. The information in the Company Information window is exported, as well.

If you don’t want to export any data, click Cancel.

If you want to continue with the exporting process, click Continue.

Tips for this window

▪	Exporting data

Top of page