What is the excel file format (character position, length, etc) for importing entries into the GL? The “How To” video demonstrates “how to” import BUT there is NO instruction, or information, with regard to the design of the excel format.
When Cetec pulls in a file, it will look at the columns and rows, then provide a drop down menu above those columns that tells Cetec what data is in that column. For example if you have a spreadsheet and column A lists account numbers to debit and column B has an account numbers to credit, you would choose the applicable drop down options “Debit Account Number” and “Credit Account Number”. This screen shows up after choosing a file and clicking import.