The format of the file to be imported may be formatted in for a full year or for certain periods of the year.
Period
Typically, this option is used when importing for a single month or only a few months. Formatting requirements are as follows:
Download Template
| Column | Data |
| A | G/L Account – may be up to 8 numbers |
| B | Profit Center – may be up to 8 numbers In case that Account Structure has 2 or more segments, combine the codes of these segments. Add trailing zeros at the start of the segment if combined code is less than 8 digits to complete the required length. |
| C | First Period # – must be numeric (next period number in column F) |
| D | First Period Data Type (A = Amount or U = Units) – must be capital A or U and must be left justified (next period type in column G) |
| E | First Period Budget Amount or Budget Quantity – must be numeric, no commas, decimal not required if whole number, minus sign (-) is required only for credits and may be leading or trailing (next budget amount or quantity in column H) |
An example of a “Period” formatted file, is shown here with three budgeted periods. Columns C through E contain information for period 1, F through H contain information for period 2 and I through K contain information for period 3.
Full Year
All twelve (or thirteen) general ledger periods will need to be included into the import file. Formatting requirements are as follows:
Download Template
| Column | Data |
| A | G/L Account – may be up to 8 numbers |
| B | Profit Center – may be up to 8 numbers In case that Account Structure has 2 or more segments, combine the codes of these segments. Add trailing zeros at the start of the segment if combined code is less than 8 digits to complete the required length. For instance, if you have Location 2005, add leading zeros to complete the 8 digits total length.
|
| C | Data Type (A = Amount or U = Units) – must be capital A or U and must be left justified |
| D thru O | Budget Amount or Budget Quantity – must be numeric, no commas, decimal not required if whole number, minus sign (-) is required only for credits and may by leading or trailing |
An example of a “Full Year” formatted file is shown here with twelve budgeted periods.
Overview
Content Tools