New Posts New Posts RSS Feed - Excel as accounting program
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Forum LockedExcel as accounting program

 Post Reply Post Reply
Author
amme_eilyk View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 September 2009
Location: Feilding
Points: 978
Post Options Post Options   Thanks (0) Thanks(0)   Quote amme_eilyk Quote  Post ReplyReply Direct Link To This Post Topic: Excel as accounting program
    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?
Back to Top
Sponsored Links


Back to Top
newme View Drop Down
Senior Member
Senior Member
Avatar

Joined: 11 January 2009
Location: Christchurch
Points: 703
Post Options Post Options   Thanks (0) Thanks(0)   Quote newme Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
smw85 View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 May 2010
Location: Waikato
Points: 142
Post Options Post Options   Thanks (0) Thanks(0)   Quote smw85 Quote  Post ReplyReply Direct Link To This Post 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 :-)
Back to Top
myfullhouse View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 July 2007
Location: West Auckland
Points: 2944
Post Options Post Options   Thanks (0) Thanks(0)   Quote myfullhouse Quote  Post ReplyReply Direct Link To This Post 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


Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.

This page was generated in 0.531 seconds.