GL summary data specifications

The Axiom Financial Institutions Suite offers three import utilities configured for common data file layouts, which are described in detail in this section. You can tailor these specifications to accommodate the unique circumstances of your organization.

TIP: Most clients use the 12 periods 12 balance column layout to load historical years and one of the other files for their monthly data loads.

Axiom can accommodate multiple GL summary data file layouts. The following GL summary file specifications are variations of data file layouts that Axiom typically encounters during an implementation. These file specifications are generic and, if necessary can be tailored to accommodate the unique circumstances of your institution.

1 balance column, data type in rows

General file specifications

File Specification Description
Number of Periods This column includes a single period of GL summary data.
Data Types

The data type (DTYPE) refers to the following balance types that are typically housed within a financial institution general ledger system:

  • Day weighted average balance (balance sheet only)
  • End of month balance (balance sheet only)
  • Month to date (income statement)
Column Names This column can include or exclude column names in the first row data file.
File Type .txt and .csv
Delimiters The comma, pipe, period, space, tab, semicolon, colon are most common. The pipe delimiter is preferred due to the rarity of the pipe symbol occurrence within financial data.

Column specifications

Column Name Column Data Type Primary Key Description
AsOfDate Date Yes The As Of date of the data. See Date string formats for acceptable date string formats.
ACCT Integer Yes The account number found in the general ledger chart of accounts.
Company Integer Yes The general ledger company number.
DEPT Integer Yes The general ledger department or cost center number.
DTYPE String(10) Yes

The Axiom data type code:

  • AVG - Day weighted average balance (balance sheets only)

  • EOM - End of month balance (balance sheet accounts only)

  • MTD - Month to date balance (income statement accounts only)
NaturalBalance Numeric No The natural balance of the GL account that is not converted to a reporting balance.

3 balance columns, data type in columns

General file specifications

File Specification Description
Number of Periods This column includes a single period of GL summary data.
Data Types

The data type (DTYPE) refers to the following balance types that are typically housed within a financial institution general ledger system:

  • Day weighted average balance (balance sheet only)
  • End of month balance (balance sheet only)
  • Month to date (income statement)
Column Names This column can include or exclude column names in the first row data file.
File Type .txt and .csv
Delimiters The comma, pipe, period, space, tab, semicolon, colon are most common. The pipe delimiter is preferred due to the rarity of the pipe symbol occurrence within financial data.

Column specifications

Column Name Column Data Type Primary Key Description
AsOfDate Date Yes The As Of date of the data. See Date string formats for acceptable date string formats.
ACCT Integer Yes The account number found in the general ledger chart of accounts.
Company Integer Yes The general ledger company number.
AVGBal Numeric No The day weighted average natural balance of the balance sheet account.
EOMBal Numeric No

The period end natural balance of the balance sheet account.
MTDBal Numeric No The month-to-date balance of the income statement account.

12 periods, 12 balance columns, data type in rows

General file specifications

File Specification Description
Number of Periods This column can includes up to 12 months of data for a single fiscal year.
Data Types

The data type (DTYPE) refers to the following balance types that are typically housed within a financial institution general ledger system:

  • Day weighted average balance (balance sheet only)
  • End of month balance (balance sheet only)
  • Month to date (income statement)
Column Names This column can include or exclude column names in the first row data file.
File Type .txt and .csv
Delimiters The comma, pipe, period, space, tab, semicolon, colon are most common. The pipe delimiter is preferred due to the rarity of the pipe symbol occurrence within financial data.

Column specifications

Column Name Column Data Type Primary Key Description
FiscalYear Integer Yes The fiscal year of the GL data.
ACCT Integer Yes The account number found in the general ledger chart of accounts.
Company Integer Yes The general ledger company number.
DEPT Integer Yes The general ledger department or cost center number.
DTYPE String(10) Yes

The Axiom data type code:

  • AVG - Day weighted average balance (balance sheets only)

  • EOM - End of month balance (balance sheet accounts only)

  • MTD - Month to date balance (income statement accounts only)
M1 Numeric No The natural balance for the fiscal period 1.
M2 Numeric No The natural balance for the fiscal period 2.
M3 Numeric No The natural balance for the fiscal period 3.
M4 Numeric No The natural balance for the fiscal period 4.
M5 Numeric No The natural balance for the fiscal period 5.
M6 Numeric No The natural balance for the fiscal period 6.
M7 Numeric No The natural balance for the fiscal period 7.
M8 Numeric No The natural balance for the fiscal period 8.
M9 Numeric No the natural balance for the fiscal period 9.
M10 Numeric No The natural balance for the fiscal period 10.
M11 Numeric No The natural balance for the fiscal period 11.
M12 Numeric No the natural balance for the fiscal period 12.