Import Budgets

Ewan

Is there a way to import budgets from excel so that you have in the rows

Gl Account, Global Dimension 1

And in the Columns Periods 1 - 12

We have around three hundred separate cost centres so importing a separate budget for each would be very time consuming

(The standard import only appears to allow you to import a budget against a single dimension value at a time via the Filter)

Thanks for your help

BardurKnudsen

1) Export a budget (empty, if you are starting over), and specify the account number filter and dimensions you want (Cost Center in your case)
2) Fill in the Excel sheets, and for each account, you can repeat the line as many times as you want, each with different dimension values.
3) Import Again.