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


# 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
3506 posts

Uber Geek

Trusted

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

Xero!




Speedtest 2019-10-14


877 posts

Ultimate Geek

Trusted

  # 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


  # 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.


15392 posts

Uber Geek

Trusted
Subscriber

  # 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.



243 posts

Master Geek


  # 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


  # 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 and LinkedIn »



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 »

Samsung Galaxy Fold now available in New Zealand
Posted 6-Dec-2019 00:01


NZ company oDocs awarded US$ 100,000 Dubai World Expo grant
Posted 5-Dec-2019 16:00


New Zealand Rugby Selects AWS-Powered Analytics for Deeper Game Insights
Posted 5-Dec-2019 11:33


IMAGR and Farro bring checkout-less supermarket shopping to New Zealand
Posted 5-Dec-2019 09:07


Wellington Airport becomes first 5G connected airport in the country
Posted 3-Dec-2019 08:42


MetService secures Al Jazeera as a new weather client
Posted 28-Nov-2019 09:40


NZ a top 10 connected nation with stage one of ultra-fast broadband roll-out completed
Posted 24-Nov-2019 14:15


Microsoft Translator understands te reo Māori
Posted 22-Nov-2019 08:46


Chorus to launch Hyperfibre service
Posted 18-Nov-2019 15:00


Microsoft launches first Experience Center worldwide for Asia Pacific in Singapore
Posted 13-Nov-2019 13:08


Disney+ comes to LG Smart TVs
Posted 13-Nov-2019 12:55


Spark launches new wireless broadband "Unplan Metro"
Posted 11-Nov-2019 08:19


Malwarebytes overhauls flagship product with new UI, faster engine and lighter footprint
Posted 6-Nov-2019 11:48


CarbonClick launches into Digital Marketplaces
Posted 6-Nov-2019 11:42


Kordia offers Microsoft Azure Peering Service
Posted 6-Nov-2019 11:41



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.

Support Geezone on PressPatron



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.