Double-entry bookkeeping (Excel 97 SR 2)

Topic

New Reply

I’ve been running my business with a pencil and columnar pads for 26 years, using traditional double entry bookkeeping. I know I should have done this long ago, but I want to go over to using Excel to keep my books. But I haven’t got the time or patience to learn everything there is to know about the program. Can anyone direct me to information on the Internet which would explain how to do ouble-entry bookeeping using Excel?
Pat

Reply | Quote

Replies

You would be better off looking at Quickbooks. Excel is a fine analytical tool, and I have run very simple books and statements on it, but it is not the best platform for maintaining a complete set of double entry books including G/L, journals, full transaction history, sub ledgers for Receivable and Payables, etc. Quickbooks will integrate with Excel for analysis of financial data when needed.

Reply | Quote

Quickbooks seems like a lot more of a program than I need. My bookkeeping is very simple, with just a general journal and 20 ledger accounts. I’m just looking to avoid adding up columns of numbers.

Reply | Quote

Edited by gwhitfield on 05-Jan-02 07:13.

Hyperlinks added

Hello,

you can try all the url i provide below…

http://www.geocities.com/davemcritchie/excel/excel.htm

http://www.j-walk.com/ss/index.html

http://www.erlandsendata.no/english/

http://ca.geocities.com/b_davidso/

http://www.barasch.com/excel/xlvba.htm

http://www.XL-logic.com/menu.html

http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm

maybe one of them fit you..happy new year and hope this help..regards

Reply | Quote