Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Bookkeeping

    In search of an addin or template which provides for income/ expenses/ balance sheet etc., for a really poor bookkeeper who wishes to remain anaonymous <img src=/S/grin.gif border=0 alt=grin width=15 height=15>. It would be nice to have cross referencing for details of each entry (who, what, when, reason etc.) and preferably <img src=/S/free.gif border=0 alt=free width=30 height=15>. I guess I'm after something fairly standard from the accounting world, but have no knowledge of the kinds of things available. Suggestions appreciated... other than writing one myself <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

    thanks

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Bookkeeping

    You might try looking at <post#=108796>post 108796</post#>. It turns out that the link is no longer "live", but the Lounger has been online relatively recently. It is possible he could respond to a PM. Also, have you tried sifting through Google?
    Gre

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Bookkeeping

    Thanks, and I will check out that thread. I tried googling for quite a while, but everything I turned up was really overkill for the requirements. A pre-structured workbook would be ideal, and the more I think about what's needed, the closer I come to writing one myself. But as I said, I've no experince in bookkeeping, so I'd prefer to "follow the directions" rather than make up my own.

    Alan

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Bookkeeping

    Well, just to answer my own post, I've not found anything that suits my needs, so have decided to play in XL. There are a couple of quite simple things I've been able to achieve without much effort, and I present them here descriptively for anyone in a similar position who might be looking for ideas.

    First, with internet banking, it's possible to download a CSV (or even direct copy/ paste) all of the account transactions for the period of interest (calendar year, financial year etc.) These slot rather nicely into a named range called Banking on a worksheet for that year. After some simple column shuffling, it's in a form suited to my purposes. I have allocated other named ranges (same sheet in my case) for Income, Expenses and BalanceSheet for that year. The BalanceSheet is the "final presentation", suitable for direct linking into the Word document of the annual report.

    Second, dropdown lists, provided through data validation, enable each expense to be allocated against a valid cheque number in the Banking range. This enables a pseudo foreign key database-style relationship. Similarly, each item of Income is allocated a date corresponding to a valid account deposit date. Other dropdown lists can be similarly incorporated, for things like who spent the money, category of expense or deposit, whether an expense has been reimbursed etc.

    So for something simple, a few handy Excel features enabled a satisfactory solution, which will doubtless become more feature-rich with time.

    Alan

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Bookkeeping

    So when are you going to post your sample template - or at least the download link to your website? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Gre

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Bookkeeping

    As soon as I work out all the appropriate clauses to protect myself against the multitude of damages that might be caused by the application of my software to a financial situation. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I might get Jefferson to start me off with the first twenty pages or so, then I'll write the bulk of it from there.

    Alan

Posting Permissions

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