Topic Options
#8160 - 12/18/06 04:38 PM Budget import
Anonymous
Unregistered


Hi there,

I currently use csv imports for my month end journal entries and would like to use a similar format for importing our annual budget. I'm unsure where to start - could you steer me in the right direction?

Thanks,

Steve Scott

Top
#8161 - 12/18/06 04:56 PM Re: Budget import [Re: ]
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
Steve,

First, export a file with Acct, Dept, Description and all 12 period's budgets.

Edit the file in Excel to create the new budgets.

When you are done, delete the description column and import the file.

(You could also export actuals instead of budgets if you want to use those figures as the starting point for next year's budgets.)
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada

Top
#8162 - 12/18/06 05:15 PM Re: Budget import [Re: Ralph Allan]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Ralph,

Actually, you don't have to delete the description column. In the import template, just choose a "Filler" entry to skip the column.
_________________________
Andrew Bates

Top
#8167 - 12/18/06 09:00 PM Re: Budget import [Re: ]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3641
Loc: Toronto ON, Canada
Steve:

And if I could add 1 small suggestion to Ralph's note:

Make a copy of your GL files using the Adagio Backup feature before importing. Just in case!
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
4 registered (Softrak Support, Salman, Bruce Gardner, Lauren Stief), 81 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14528 Topics
70938 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31