Chart of Accounts Import

Use the Chart of Accounts Import file to manage your chart of accounts values. With this import file, you can add, update, and delete the segment values in your chart of accounts.

File opens in a new window Chart of Accounts Import Template

Note:The structure of a chart of accounts is created within PaymentNet. The Chart of Accounts Import file can only be used to manage segment values; it cannot be used to create, modify, or delete the chart of accounts structure.

The Chart of Accounts Import File Layout table outlines the requirements for entering your data into a Chart of Accounts Import template. To ensure a successful import, review the considerations outlined below before beginning the import. In addition, be sure to familiarize yourself with the guidelines found in General Import File Tips.

In a Chart of Accounts Import file, semicolons [;] and commas [,] are not allowed (in addition to the other restricted characters listed in General Import File Tips).
Create a Chart of Accounts Import file from the top down, and establish the lowest numbered segments first.
If you have dependencies in a Chart of Accounts Import file, you must have dependencies selected (or turned on) within PaymentNet before you import the file.
If you use an import file to delete values that correspond to default chart of accounts values, you must reconfigure the default values.
Spaces in the Add/Update/Delete Flag field of the import file will cause the import to fail. Verify that only the words Add, Update, or Delete appear in this column.
When you complete an import, you have the option on the Import Detail screen to replace values. If you replace your chart of accounts, you will need to re-import all your default values.

Chart of Accounts Import File Layout
Column	Name	Description	Required	Valid Codes
A	Chart of Accounts	The name of the chart of accounts to be edited.	Yes	Must be: Specified exactly the same way as the name appears in PaymentNet Alphanumeric 30 characters max Less than or equal to the maximum length defined for the corresponding chart of accounts segment Spaces are allowed
B	Segment	The name of the segment where the value is found	Yes	Must be: Numeric Value from 1-50 2 characters max
C	Value	Actual chart of accounts value	Yes	Must be: Alphanumeric 50 characters max; length based on chart of accounts definition No spaces allowed The following special characters are allowed: ‘ : ! () * & ^ % $ # ? + — _ = { } [ ] . @ ~ < > / \ embedded space (space must be used with another character) “ (a single set of quotation marks must be used with another character) ‘ (a single quotation mark must be used with another character) The following special characters are not allowed: \| ,
D	Description	Description of the chart of accounts value	Yes	Must be: Alphanumeric 50 characters max The following special characters are allowed: ‘ : ! () * & ^ % $ # ? + — _ = { } [ ] . @ ~ < > / \ embedded space (space must be used with another character) “ (a single set of quotation marks must be used with another character) ‘ (a single quotation mark must be used with another character)
E	Key Segment	Dependency segment	No	Must be: Numeric Value from 1-50 2 characters max
F	Key Value	Dependency value	Required if Key Segment is not blank	Must be: Alphanumeric 50 characters max; length based on chart of accounts definition The following special characters are allowed: ‘ : ! () * & ^ % $ # ? + — _ = { } [ ] . @ ~ < > / \ embedded space (space must be used with another character) “ (a single set of quotation marks must be used with another character) ‘ (a single quotation mark must be used with another character) The following special characters are not allowed: \| ,
G	Add/Update/Delete Flag	Indicates whether the record is for creating, updating, or deleting segment values.	Yes	Valid values are: Add: for new rows containing data Update: for existing rows to be updated Delete: for rows to be removed
H	Blank Override	Specifies whether or not to replace existing values with null values when import file columns are blank. Blank Override is only used where the Add/Update/Delete Flag is set to “Update” and only affects the “Description” field. Best Practice: Set Blank Override to 0.	Yes	Valid values are: 0: Retain the existing description if the Description column is left blank 1: Overwrite the existing description with a null value if the Description column is left blank