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: 4548
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:  Softrak Support 
Who's Online
5 registered (Mr. Webmaster, Howard S.-MMA, Softrak Support, Sudhakar, Warren Karges), 362 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14576 Topics
71139 Posts

Max Online: 1408 @ 12/09/25 01:48 AM
December
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