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: 4516
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 (Rebecca Young), 119 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14486 Topics
70737 Posts

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