Importing Data

Instead of manually entering the associations between GL accounts and format and concept codes, you can enter the data on a spreadsheet or in a comma-separated values file (CSV) and then import the data. You must set up your spreadsheet or CSV file with columns in the same order as the fields appear on the Setup Multiple Accounts form. The values for some fields must exist in the UDC tables that the system uses to validate the data.

See Setting Up UDCs for Colombian Taxes.

Set up the spreadsheet with these columns and fields values:

Column	Field Name	Comment About Values
A	Format Number	The values for format numbers must exist in the DIAN Magnetic Media Formats (76C/FM) UDC table. Note: The values in the 76C/FM UDC table have a leading 0 (zero). The values in your spreadsheet must include the leading zero.
B	Account Number	The account number that you enter must exist in the F0901 table.
C	Account Description	You must reserve column C for the account description, but you do not have to populate the column. The system uses the account description from the F0901 table when you complete the import process.
D	Business Unit	You must reserve column D for the business unit, but you do not have to populate the column. The system uses the business unit from the F0901 table when you complete the import process.
E	Object Account	You must reserve column E for the object account, but you do not have to populate the column. The system uses the object account from the F0901 table when you complete the import process.
F	Subsidiary	You must reserve column F for the subsidiary, but you do not have to populate the column. The system uses the subsidiary from the F0901 table when you complete the import process.
G	Concept Code	The values for the concept code must exist in the Concepts (76C/00) UDC table.
H	Account Type	The values for the account type must exist in the Type Account (76C/TA) UDC table. Note: The values in the 76C/TA UDC table include a leading 0 (zero). The values in your spreadsheet must include the leading zero.
I	Deductible	The values for the deductible field must exist in the Deductible (76C/DA) UDC table.