Hi Ken,

2 questions:

1) Is the intention to update your existing Ledger with new budgets, or to create a new Ledger database with new accounts and new budgets? (I assume you are updating)

2) Are you intending to import new accounts, or only update existing accounts? (I assume you are adding new accounts, too)

If you are only updating your existing accounts with new budget figures, then the only fields you need in Excel are the Acct, Dept, and the budget fields. You would select the 'Overwrite existing accounts' and not 'Add new records'. In addition, you will want to 'Replace' amounts rather than 'Accumulate'.

If you want to add new accounts, then you will need more fields than what you listed. (Account Status and possibly Current Balance). You would also have to make sure the 'Add new Records' option is selected.

We would need more info about what is wrong. Are you 'displaying' accounts that previously existed prior to importing? That would imply that the budget updating did not proceed as expected. I would suggest looking at the options you chose during the import for how balances are handled.

If this is for new accounts, then you may need to include more fields in the import...