Templates

What is a Template?

A template is a predefined set of options used to generate an exportable flat file for an accounting system. To export transactions, a template is required to create the exported file.

Each template has a number of configurable properties, including:

• Summarization option (Batch/Detail/Day/Month)

• File extension

• Custom field delimiter

• Field quote

• Option to separate files by financial entity

• Option to display file header

• Option to hide Due To/Due From entities

• A predefined set of fields with editable headers and user-defined values

Creating a Template

To create a template, select the Templates → + New… menu option from the top navigation bar. You will be asked to choose the export file format:

Delimited - Compatible with multiple accounting software applications

IIF - To use with QuickBooks Desktop

A template name is required when creating a template along with a number of configurable settings.

You must create and save the template before you can edit the template fields.

Once you have created a template, the template fields can be configured to your specificity. Clicking the Edit Fields Schema button will navigate you to the Template Fields page.

Template Fields

Template fields are placeholders for transactional data created in the export process. Each export format provides a predefined set of fields that can be exported.

Fields can be updated, moved, and deleted. New fields can also be inserted anywhere within the list.

1 - Drag/Drop functionality

2 - Add new field to the bottom of the list

3 - Delete a field

4 - Move a field to the top or bottom, insert a field, or use our template editor.

GL Processor Cloud contains a template expression engine allowing you to insert dynamic data into your exports.

Refer to our Template Expressions documentation for instructions on how to use expressions.

Code Editor

To assist in creating the appropriate field expression, we’ve provided a code editor that will provide samples of common expression filters and even an expression tester to evaluate sample data using your expression.

To launch the code editor, click on the blue icon in the top left corner of the template field, see below:

The code editor page contains the following areas:

1. Editor Text Area - enter your expression in the editor text area

2. Available Fields - list of available fields based on the template file format. Clicking on the field will populate the editor text area.

3. Expression Browser - Examples of expressions for common data manipulation filters. Clicking the example will populate the editor text area.

4. Save/Cancel - Save changes and return to the list of template fields.

The Expression Tester allows you to evaluate your expression with sample data and validate the result. To use the expression tester,

1. Enter your expression in the editor text area.

2. Enter your sample data in the text box.

3. Click the execute button.

4. Validate the expression output.