Defining Excel Trial Balance Templates

To define an Excel trial-balance template, you define a metadata header. The header contains tags that FDM uses to interpret the data contained in the template.

Excel trial-balance templates use a tabular format. The first row contains the metadata tags.

The following template contains one line of metadata (row 1) and three lines of imported data (rows 5–7).

The image shows an example of an Excel-based trial balance template defined in the text preceding the image.