Excel as accounting program
Printed From: OHbaby!
Category: General Chat
Forum Name: General Chat
Forum Description: For mums, dads, parents-to-be, grandparents, friends -- you name it! And you name the topic you want to chat about!
URL: https://www.ohbaby.co.nz/forum/forum_posts.asp?TID=38044
Printed Date: 28 August 2025 at 10:54pm
Software Version: Web Wiz Forums 12.05 - http://www.webwizforums.com
Topic: Excel as accounting program
Posted By: amme_eilyk
Subject: Excel as accounting program
Date Posted: 16 February 2011 at 8:47pm
| Has anyone used excel to do the day to day accounts for a small business. Does anyone have any tips or ideas on how to set it up? |
Replies:
Posted By: newme
Date Posted: 16 February 2011 at 9:19pm
|
I have used it for our accounts.
Our accountant gave us a template to use. If you have an accountant maybe ask them - that way it will match their systems when it comes to year end. |
Posted By: smw85
Date Posted: 19 February 2011 at 11:40am
|
Yip, I use it for my husbands farming business. I export the transactions from Internet banking into excel. I then classify each transaction, from there you can do either sumif formulas or create pivot tables. Depending on how you want your info. I find this is great for doing GST Returns, and just have to put it all together at year end.
I'm a bit of an excel geek, so any questions just ask :-) |
Posted By: myfullhouse
Date Posted: 21 February 2011 at 7:25pm
|
I have used it for Playcentre (I am the treasurer), we had a brilliant spreadsheet system which was very well developed. However I have just got approval to move to a web based accounting system and finding it heaps easier and quicker. I suppose it depends on what you are wanting to do with the system and how big your small business is ------------- Lindsey 
|