TMT Fleet Maintenance Generic Accounting Export

The Generic Accounting Export allows you to export your company’s accounting data from TMT Fleet Maintenance (TMT) using basic file formats that are compatible with most accounting software systems. The export tool offers adjustable layout options and custom field selection which can be exported in fixed length or delimited file formats.

To use the Generic Accounting features within TMT, your company must have an active Generic Accounting license. If you do not have a license, contact your regional account manager if applicable. Otherwise, contact Trimble support for assistance.

Access the Export Transactions page

If you are running V.2024.2 or later, you have two ways to open the Export Transactions page.

Dashboard menu

  1. From the TMT dashboard, select Activities from the dashboard menu. The menu expands to list all options under activities.

  2. Select Accounting. The Export Preview page opens.

  3. Select Export Transactions. The Export Transactions page opens.

Legacy menu

  1. From the TMT dashboard, select the Trimble icon. The menu opens.

  2. Go to Activities > Accounting > Accounting. The Export Preview page opens.

  3. Select Export Transactions. The Export Transactions page opens.

Manage your Export Configurations

You can create multiple export configurations to set the parameters used to export specific accounting data to a file.

  1. From the Export Transactions page, select the Options icon Options icon. The Options pane opens.

  2. Do one of the following:

    • Select an existing Export Configuration from the dropdown list.

    • Create a new export configuration.

      1. Select Add New.

      2. Enter a configuration name in the Export Configuration field.

      3. Enter a description in the Description field.

      4. Select OK to save the export configuration.

  3. Set up your export file by completing these fields within the Options pane.

    Field Definition

    Decimal Places

    Use the Up and down arrows icon arrows to set the number of decimal places you want to see in the export file.

    Export Format

    A fixed-length text file will maintain the same number of characters for every data column or row. Delimited text files separate each value by a defined separator, usually a comma. Your file type should be determined by how you intend to use the export file, including any 3rd party software requirements.

    Select Fixed-Length Text File or Delimited Text File to set the export format.

    Separator (Delimited Text File only)

    Select the Separator field and enter the delimiting character you want to use for the export list.

    It is best practice to leave this set to "," unless you require a specific character when importing to third-party software.

    Enclose in Quotes (Delimited Text File only)

    Select Dropdown arrow to open the Enclose in Quotes dropdown list and select one of the following options:

    • None

    • Strings

    • All Fields

    Include Debits and Credits on Same Line?

    To include debits and credits on the same line in the export file, set the toggle button to YES.

    Include Field Names on First Row?

    To include field names on the first row in the export file, set the toggle button to YES.

    Export AR Cost Orders with GL?

    This option allows you to include direct issue and credit issue cost orders when exporting general ledger transactions. The direct issue and credit issue order types are tied respectively to direct sale and credit sale invoices. Direct issue and credit issue cost orders account for the removal of a part from your inventory when it is sold to a customer over the counter.

    To export AR cost orders with GL, set the toggle button to YES.

    View Transaction Tables

    To view transaction tables and include them in your export file, set the toggle button to show YES. The Account Transactions and Transaction Details tables are displayed.

    Date Format

    Select Dropdown arrow to open the dropdown list and select one of these options:

    • YYYYMMDD

    • MMDDYYYY

    • DDMMYYYY

    Date Delimiter

    Select Dropdown arrow to open the dropdown list and set the date delimiter by selecting / or -.

  4. In the Fields pane, select the checkbox next to each field you want included in your export file.

  5. Select Save Options. Your settings and fields are saved to the selected export configuration.

Export the data

  1. From the Export Transactions page, complete these fields in the Export pane.

    Field Definition

    Type

    Select Dropdown arrow to open the dropdown list and select an option:

    • GL Transactions

    • AP Transactions

    • AR Transactions

    Retrieve Options

    Select one of the buttons to define which transactions will show in your export file. There are three options you can select:

    • Non-Exported

    • Exported

    • Exported & Non-Exported

    From

    Select Calendar icon to open the calendar pop-up window and choose the start date of the data range you want to export.

    To

    Select Calendar icon to open the calendar pop-up window and choose the end date of the data range you want to export.

  2. Select Dropdown arrow in the Export Configuration field to open the dropdown list and select an export configuration. Once you select a configuration, its name appears in the heading of the Export pane.

  3. In the Fields pane, select Preview if you want to view the export file format before exporting. The Export Preview window opens and shows a preview of the export file.

  4. Select Close to close the Export Preview window.

  5. Select Export to create your export file. A .txt file is generated.

    If your company uses an integrated accounting system within TMT, you will see a warning popup prior to the .txt file being generated.

    • To generate the file, select Continue.

    • If you have requested the file export in error, select Cancel to cancel the request.