Topic Options
#8984 - 05/09/07 10:31 AM Export from TB/Import to ledger
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
(64.26.156.65)
Is there an easy way to export monthly disbusements on certain projects to a file that I can import to the GL?

We have internal corporate projects that we track using TB. Since the expenses will never be recovered, at the end of each month, I am billing them out for $0, then manually distributing them to the appropriate expense accounts.

I am thinking that there has to be a better way.

If I export the disbursements from Gridview into an Excel spreadsheet amd make the adjustments, is there a way to import them into the ledger as a batch that I can post?

Thanks.

Top
#8989 - 05/09/07 03:09 PM Re: Export from TB/Import to ledger [Re: bal]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4544
Loc: Wynnewood, PA
(71.224.211.228)
Hi bal

If you can export something to Excel, then, by definition, you can import it to Ledger as a batch. You may have to massage the Excel file a bit.

Look at the sample Excel import templates in the sample Ledger data (\SOFTRAK\ALWIN\SAMDATA)

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 78 Guests and 11 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14566 Topics
71090 Posts

Max Online: 1148 @ Today at 01:55 AM
November
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