Adagio Support Tip Of The Month: Importing Into General Ledger

Jan 10, 2019

Question: I am trying to import into Ledger but it keeps telling the Fiscal Date is wrong. How do I fix this?

Answer: It sounds like your date format in the import template is not the same as the date format in the import file.
If you are importing the data as a CSV file, you can see the date format if you open up the CSV file with Notepad. The default on the import template is YYYYMMDD, and so you need to match or create a custom template to match the layout of the date in your import file. You choose the date format options under the type, and you will see YYYYMMDD, or Date, or Windows m/d/yyyy or custom.

If you are importing as a XLSX or XLS file, the date displayed as a display format is underneath in Excel and is often a Julian date (as raw data). For most Excel date fields you can use the “Date” type which is really the Julian Date format. If the date file being imported is a text field within Excel, then you can custom modify to match that text exactly with the custom option, similar to matching formats in CSV files.

Save the revised template format and attempt the import again. This date format info is the same for importing dates into any module in Adagio.

The only issue you could have is that moving fields around in the import template will often revert a saved date format back to YYYYMMDD without changing or editing the date field in your template. Someday this will be fixed but for now you can always go back and re-edit the template field properties.

Best practice is to normally use the XLS or XLSX format to import files into Adagio so that you are not derailed by the commas in the fields that add extra fields to your records and mess up your template format.

This tip was inspired by a posting on the Softrak Technical Support Forum, where registered Adagio Accounting users can post questions to get answered by Softrak, members of the Adagio Consultant community, and fellow Adagio Accounting users. Be sure to check it out!