Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Double-entry bookkeeping (Excel 97 SR 2)

    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

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Double-entry bookkeeping (Excel 97 SR 2)

    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.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Double-entry bookkeeping (Excel 97 SR 2)

    <P ID="edit" class=small>Edited by gwhitfield on 05-Jan-02 07:13.</P>Hyperlinks added

    Hello,

    you can try all the url i provide below...

    <A target="_blank" HREF=http://www.geocities.com/davemcritchie/excel/excel.htm>http://www.geocities.com/davemcritchie/excel/excel.htm</A>

    <A target="_blank" HREF=http://www.j-walk.com/ss/index.html>http://www.j-walk.com/ss/index.html</A>

    <A target="_blank" HREF=http://www.erlandsendata.no/english/>http://www.erlandsendata.no/english/</A>

    <A target="_blank" HREF=http://ca.geocities.com/b_davidso/>http://ca.geocities.com/b_davidso/</A>

    <A target="_blank" HREF=http://www.barasch.com/excel/xlvba.htm>http://www.barasch.com/excel/xlvba.htm</A>

    <A target="_blank" HREF=http://www.XL-logic.com/menu.html>http://www.XL-logic.com/menu.html</A>


    <A target="_blank" HREF=http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm>http://www.rb-ad.dircon.co.uk/rob/ex...tils/index.htm</A>


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

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Double-entry bookkeeping (Excel 97 SR 2)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •