In our budgeting process this year I basically began by copying my data directory to a new "budget" directory and then exported by department, to excel all our revenue and expense codes, including buget and prior year period results.

I then used excel to create my budgets and then imported back into my "budget" adagio data files. While in excel, I did create new line items as required.

To this point everything worked very well. However, when I completed the budget and exported all my revenue and expense codes to a single excel spreadsheet in order to bring into my the new year data directory, I ran into problems.

The data imported without any errors, but the actuals and hisotry seemed to be screwed up. For example, when I clicked on "display" the accounts that had been imported showed a balance of zero. But if I clicked on a given account, there were actual entries in the acount. (Note: in the Gl for the 2003/04 fiscal year there are already transactions posted, but our final budgets have not yet been loaded.) Basically, all I want to do is:

1. Add the new codes created in excel to the existing 2003/04 gl.
2. Add the budget figures for all codes.
3 Not impact on either the prior year or current year actual results.

Seems simple, but I am doing something wrong.

For the final budget load into the new year gl I am:

1. Exporting from my working budget adagio files:

Account code
dept code
description
period 1 budget
period 2 budget
period 3 budget
period 4 budget
period 5 budget
period 6 budget
period 7 budget
period 8 budget
period 9 budget
period 10 budget
period 11 budget
period 12 budget
Account Type
Consolidation Option

Do you see something I am missing to cause this problem?

Thanks,

Ken