Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

## aboylikedave

243 posts

Master Geek

#80539 1-Apr-2011 07:28

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.

## Zeon

3645 posts

Uber Geek

Trusted

#454012 1-Apr-2011 07:49

Xero!

## knoydart

893 posts

Ultimate Geek

Trusted
Subscriber

#454018 1-Apr-2011 08:27

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

## aboylikedave

243 posts

Master Geek

#454219 1-Apr-2011 14:40

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.

## timmmay

16536 posts

Uber Geek

Trusted
Subscriber

#454227 1-Apr-2011 14:56

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.

## aboylikedave

243 posts

Master Geek

#454698 3-Apr-2011 06:12

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.

## foremannz

34 posts

Geek

#454700 3-Apr-2011 06:27

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!

News »

Huawei launches IdeaHub Pro in New Zealand
Posted 27-Oct-2020 16:41

Southland-based IT specialist providing virtual services worldwide
Posted 27-Oct-2020 15:55

NASA discovers water on sunlit surface of Moon
Posted 27-Oct-2020 08:30

Huawei introduces new features to Petal Search, Maps and Docs
Posted 26-Oct-2020 18:05

Nokia selected by NASA to build first ever cellular network on the Moon
Posted 21-Oct-2020 08:34

Nanoleaf enhances lighting line with launch of Triangles and Mini Triangles
Posted 17-Oct-2020 20:18

Synology unveils DS16211+
Posted 17-Oct-2020 20:12

Ingram Micro introduces FootfallCam to New Zealand channel
Posted 17-Oct-2020 20:06

Dropbox adopts Virtual First working policy
Posted 17-Oct-2020 19:47

OPPO announces Reno4 Series 5G line-up in NZ
Posted 16-Oct-2020 08:52

Microsoft Highway to a Hundred expands to Asia Pacific
Posted 14-Oct-2020 09:34

Spark turns on 5G in Auckland
Posted 14-Oct-2020 09:29

AMD Launches AMD Ryzen 5000 Series Desktop Processors
Posted 9-Oct-2020 10:13

Teletrac Navman launches integrated multi-camera solution for transport and logistics industry
Posted 8-Oct-2020 10:57

Farmside hits 10,000 RBI customers
Posted 7-Oct-2020 15:32

Geekzone Live »

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

Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.