General Ledger

[Guest]

I do manual accounting for several small businesses. I'd like to put it all on my computer. Is it practical to set up a general ledger in Excel? I've used Excel for some reporting and some calculating, but not the entire ledger. I'd appreciate any suggestions. Thank you so much.

 

[Peo Sjoblom]

I work in the field and I am fairly proficient in Excel and I would never
use Excel for this (at least if there weren't any other programs around). I
would get a small business package like Peachtree
or QuickBooks and then use Excel to analyze reports from those programs.
Since they are fairly inexpensive and you can probably deduct the cost you
are better off
using a program developed for this. Most database programs have a finance
part (at work we use Dataworks)
and you might be able to use MS Access for General Ledger type of entries
and it is pretty
powerful to use in queries and reports as well.

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

I do manual accounting for several small businesses. I'd like to put it

all on my computer. Is it practical to set up a general ledger in Excel?
I've used Excel for some reporting and some calculating, but not the entire
ledger. I'd appreciate any suggestions.
Thank you so much.

 

[Guest]

Thank you for your response. This affirms what I already suspected. I have Quicken 2000 and was working with it setting up my accounts yesterday when I somehow lost what I had entered. I've also had a little experience with Excel and had doubts that it would achieve what I need. Several years ago, I took a course in Peachtree Acctg. at a local community college, but I'm not sure Peachtree is still available. I'll just have to look a little further.