Buyer/Recipient Created Tax Invoice - How to Account for Service Fee in MYOB???

Highlighted
3 Posts
Cover User
Cover User

3Posts

0Kudos

0Solutions

Buyer/Recipient Created Tax Invoice - How to Account for Service Fee in MYOB???

Hi all

 

Hoping someone might be able to help with my question/problem.

 

As a supplier of professional services in New Zealand, I have recently started a role where I complete a timesheet for a Mon-Fri period, then in the middle of the following week receive a buyer created tax invoice along with the associated payment from the buyer.

 

Part of the overall calculation includes a buyer 'service fee', that is a percentage of the gross amount, and this is deducted before determining earnings that are subject to income tax.

 

The service fee itself is made up of the base service fee plus GST.

 

So, my question/issue is - I need to find out how to deal with the service fee in MYOB (and I need to deal with the parts of this that are the base service fee and that are the GST).

 

I'll explain the situation with an example (using fictional amounts that demonstrate the issue):

 

Lets say I work 4 hours at $10 per hour so my gross earning is $40.

 

The service fee is 0.5% ('half a percent'), relative to the gross earning, so is 20 cents (so the base service fee is approx 17.4 cents and the GST is 2.6 cents).

 

The service fee of 20 cents is deducted from the gross earning of $40, leaving $39.80 which is then subject to income tax.

 

The buyer withholds 25% PAYG relative to the $39.80 amount, so keeps $9.95 that they forward to the Government later on my behalf, and so they pay me the remainder of $29.85.

 

The buyer also pays me 15% GST on the gross earning of $40, so pays me another $6 (so in total I receive $29.85 + $6 = $35.85 from the buyer).

 

From the $35.85 I set aside the $6 GST to pay to the Government later.

 

From the remaining $29.85 I also set aside several small amounts to pay remaining income tax owed and ACC insurance fees later.

 

Lets say this leaves me with approx $25 in the hand as an owner drawing.

 

As I am GST registered, I can offset the GST I have paid against the GST I have collected before paying the remaining amount to the Government.

 

So as raised above,  given the buyer has calculated their service fee against the gross amount, where I have paid the base service fee and paid GST, how do I handle this service fee in MYOB so that it appears as a payment I've made for the 'service' I've received, and indeed how do I account for the base service fee of 17.4 cents and GST of 2.6 cents in MYOB, so that later when I come to do my GST return the 2.6 cents can be deducted from GST I've collected etc?

 

Note up until this role I have always raised invoices to buyers myself, and so have had most of the situation as above, except for this service fee item. I have bank feeds setup. As previous buyers have still withheld PAYG I have been creating Take Payments so that I can reconcile the amount the buyer paid to me and the amount the buyer paid to the Government on my behalf, and I have been transferring the GST collected amounts, remaining income tax amounts and ACC insurance amounts to a savings account so normally get transactions in MYOB that I can allocate all these parts to. If I have bought services I have done this myself so again have received bank feeds into MYOB that I can allocate purchases against.

 

But this new setup of the buyer deducting the service fee before income tax, and so on, has me stumped as to what to do in MYOB.

 

Note I've seen this post from a while back, but not sure if it helps - https://community.myob.com/t5/MYOB-Essentials-Accounting/Essentials-Recipient-Created-Tax-Invoice-Su... ?

 

Apologies for the long post, but I hope someone can give me a hand on what I need to do.

 

Thanks so much for your help in advance!

 

Kind regards,

 

Tony

3 REPLIES 3
Highlighted
MYOB Moderator
4,061 Posts
MYOB Moderator
MYOB Moderator

4,061Posts

623Kudos

623Solutions

Re: Buyer/Recipient Created Tax Invoice - How to Account for Service Fee in MYOB???

Hi @Tony_S 

 

My apologies for the delay in replying. In this situation I would recommend speaking to your accountant about how this needs to recorded to ensure all amounts are reported correctly. Once you know the applicable accounts and tax codes we can assist with entering this into your software.

 

Please do let us know if you need further assistance.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Highlighted
3 Posts
Cover User
Cover User

3Posts

0Kudos

0Solutions

Re: Buyer/Recipient Created Tax Invoice - How to Account for Service Fee in MYOB???

Hi @Tracey_H 

 

Thanks for your reply Smiley Happy.

 

I don't have an accountant at present as I'm trying to do my books just using MYOB (don't see the point of paying twice!).

 

Regarding the answer to my question, I believe I have found the general approach required, this is as per the attached file (noting this is for Quickbooks and from the late 2000's, but the principles still apply).

 

Keen to see what you think of this at some stage.

 

Best regards,

 

Tony

 

Highlighted
MYOB Moderator
4,061 Posts
MYOB Moderator
MYOB Moderator

4,061Posts

623Kudos

623Solutions

Re: Buyer/Recipient Created Tax Invoice - How to Account for Service Fee in MYOB???

Hi @Tony_S 

 

Unfortunately, as I'm not an accountant or registered Tax agent I can't give you advice or thoughts on the best way to record these transactions. This help article does have some information which you may find useful: Recipient created tax invoices

 

Please let me know if you need further help.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post