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
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: 4531
Loc: Wynnewood, PA
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
1 registered (1 invisible), 90 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14509 Topics
70865 Posts

Max Online: 432 @ 01/20/25 10:17 PM
July
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