Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Info
titleDownload Template

 

Column Data 
 AG/L Account – may be up to 8 numbers
 B

 Profit Center – may be up to 8 numbers

Note

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 your Location is 2005 add leading zeros to complete the 8 digits total

length.

Image Removed

 CFirst Period # – must be numeric (next period number in column F)
 DFirst 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)
 EFirst 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)

...