Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




243 posts

Master Geek
+1 received by user: 4


Topic # 80539 1-Apr-2011 07:28
Send private message

Hi there

My partner is going self employed and needs simple software to enter income (weekly) and business expenses, get a net income figure and work out NZ tax and ACC due. Also calculate GST received, paid and due. She has only one customer (is a contractor). Essentially its just cashbook accounting.

I'd do it all on Excel but I don't know how to do a formula or otherwise get it to do different rates of tax st different bands of net income.

Does anyone have any recommendation or a suggestion for the formula?

Cheers




My EPL football websites: Get the results but hide the score of your team at HidetheScore.net. Compare league positions with wage bills at RealPremierLeague.net.


Create new topic
3384 posts

Uber Geek
+1 received by user: 389

Trusted

  Reply # 454012 1-Apr-2011 07:49
Send private message

Xero!





833 posts

Ultimate Geek
+1 received by user: 114

Trusted

  Reply # 454018 1-Apr-2011 08:27
Send private message

Hi,

having contracted before, for the low cost solution Excel is perfect.

I've looked at Xero and I like the idea, but for the amount of income I earn and what I need to do - 2 GST returns a year and 1 personal tax return, an excel sheet is fine. Not many formulas to deal with, working out GST content and putting enough aside for the tax bill at the end of the year is about all that's required.

If you want the reporting and direct banking interface, then Xero does look rather nice however.

cheers

knoydart

 
 
 
 




243 posts

Master Geek
+1 received by user: 4


  Reply # 454219 1-Apr-2011 14:40
Send private message

If anyone's interested I've got it now:

If you put this in cell A2:


=IF(A1>70000,(A1-48000)*0.33+14020,IF(A1>48000,(A1-48000)*0.3+7420,IF(A1>14000,(A1-14000)*0.175+1470,A1*0.105)))

And your income in cell A1, it works it out for you!




My EPL football websites: Get the results but hide the score of your team at HidetheScore.net. Compare league positions with wage bills at RealPremierLeague.net.


13448 posts

Uber Geek
+1 received by user: 2274

Trusted
Subscriber

  Reply # 454227 1-Apr-2011 14:56
Send private message

Xero works really well. It tracks income and expenses, depreciation if you have any equipment, and gives you all the information for your tax and GST returns.

You can also claim office space (home office is fine), rent or mortgage, a percentage of your cell/phone/internet, etc. It's probably worth having an accountant look over it too, because it does get semi complex. A decent accountant should save you more than they cost. You do all the day to day stuff, they just advise and check things, and generally file your returns electronically.

Your formula doesn't take into account expenses, the change in GST or income tax rates, etc. I believe it's incorrect, but i'm not an accountant.




AWS Certified Solution Architect Professional, Sysop Administrator Associate, and Developer Associate
TOGAF certified enterprise architect
Professional photographer




243 posts

Master Geek
+1 received by user: 4


  Reply # 454698 3-Apr-2011 06:12
Send private message

timmmay:

Your formula doesn't take into account expenses, the change in GST or income tax rates, etc. I believe it's incorrect, but i'm not an accountant.

Yes, it was the formula I was after, I can change the key numbers, and I just need it to calculate from income after expenses, as I can work that out quite easily.




My EPL football websites: Get the results but hide the score of your team at HidetheScore.net. Compare league positions with wage bills at RealPremierLeague.net.


34 posts

Geek


  Reply # 454700 3-Apr-2011 06:27
Send private message

What about MYOB LiveAccounts - $25/mth, and online all the time means you can use it anywhere on anything, and you can give your accountant their own login!

http://myob.co.nz/products/small-business/accounting-finance/liveaccounts-1257828259130

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

$3.74 million for new electric vehicles in New Zealand
Posted 17-Jan-2018 11:27


Nova 2i: Value, not excitement from Huawei
Posted 17-Jan-2018 09:02


Less news in Facebook News Feed revamp
Posted 15-Jan-2018 13:15


Australian Government contract awarded to Datacom Connect
Posted 11-Jan-2018 08:37


Why New Zealand needs a chief technology officer
Posted 6-Jan-2018 13:59


Amazon release Silk Browser and Firefox for Fire TV
Posted 21-Dec-2017 13:42


New Chief Technology Officer role created
Posted 19-Dec-2017 22:18


All I want for Christmas is a new EV
Posted 19-Dec-2017 19:54


How clever is this: AI will create 2.3 million jobs by 2020
Posted 19-Dec-2017 19:52


NOW to deploy SD-WAN to regional councils
Posted 19-Dec-2017 19:46


Mobile market competition issues ComCom should watch
Posted 18-Dec-2017 10:52


New Zealand government to create digital advisory group
Posted 16-Dec-2017 08:47


Australia datum changes means whole country moving 1.8 metres north-east
Posted 16-Dec-2017 08:39


UAV Traffic Management Trial launching today in New Zealand
Posted 12-Dec-2017 16:06


UFB connections pass 460,000
Posted 11-Dec-2017 11:26



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.