Hi Jeff,

You are using Ledger 6.8B, and should be aware that the newest version 8.0A has had all import functions improved. Are you trying to import new accounts, update existing accounts, or both?

There are 3 screens you can visit when import either accounts or batches in Adagio Ledger. Let me describe each one briefly and perhaps this may shed light on what's happening.

The first screen allows you to select the file name and location, the file type, and some options specific to what you are importing.If you are importing new accounts, then there are a minimum number of required fields that must either be imported or defaulted. For Excel formatted files, you might have column labels in the first row, and need to select the 'Header included' to ignore row 1.

The second screen allow you to match up the fields that exist in your (Excel) import file. As you said your 4 fields are account, department, description, and account type, those should be the only 4 fields in the Selected box on the right, in the proper order.

The third screen allows you to set default values for fields that don't exist in your import file. This would be useful if every account will have the same value for a certain field; you can default it here rather than repeat it for every record in the Excel file. An example would be setting Consolidated to No.

Does the error message you are receiving indicate a record number or a field? This might help narrow things down. You probably should format the account and department codes as Text in the Excel file (if you haven't already).

Hopefully this will help narrow things down.