GST on Commission appearing as a negative purchase

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
SherylBT
3 Posts
User

3Posts

0Kudos

0Solutions

Solved: Go to Solution

GST on Commission appearing as a negative purchase

As a booking agent for tour operators, we enter the cost of the tour as a purchase less the commission. The purchase is an expense and the commission is income. We pay the operator the balance once the visitor has been on the tour.

This works well, however the commission appears on the GST reports and in BASLink as a negative purchase rather than income. This also reduces the G1 & G11 figures we are reporting to the ATO although doesn't affect the total GST owing.

Is there any way to correct this without going through the GST detail report and seperating the comission out? The detail report is 66 pages long and this is very time consuming.

I have thought of creating a new GST code for commission so that it will appear on the detail report seperately, however I will still need to manually adjust the G1 & G11 in BASLink. 

 

4 REPLIES 4
Steven_M
45,180 Posts
Former Staff
New Zealand
Former Staff

45,180Posts

0Kudos

6,759Solutions

Re: GST on Commission appearing as a negative purchase

Hi @SherylBT 

 

For GST purposes the type of transaction will denote which side of the GST reporting the amount will appear. Purchase & Spend Money transactions will go through to the Purchase value whereas Sales & Receive Money transactions will come through as Sale values.

 

When recording negative values it will create a negative for that GST value based on the transaction type i.e. a negative on a purchase will reduce the Purchase value whereas a negative on a sale will reduce the Sales values. If you don't wish for this occur i.e. a negative purchase value to appear as a Sales based value, you would be looking at recording that part of the transaction as a Sales based transaction (either via Enter Sales or Receive Money)

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| My Account

SherylBT
3 Posts
User

3Posts

0Kudos

0Solutions

Re: GST on Commission appearing as a negative purchase

Thank you @Steven_M , I understand the principal, but it is restrictive.

 

With the volume of Purchases we enter especially in peak season, it is just not an effecient or viable way to enter the commission we receive as income against a ticket purchase as a seperate sale. Especially as the card is either for a 'Supplier 'or a 'Customer' and MYOB won't allow payments to be applied across different types of 'cards'.

 

Is there a chance that MYOB would look at a 'fix' so that it is less restrictive and the user can choose which data they require in the GST Reports? For instance a negative value entered in a purchace against an income account should be considered income?

 

Thank you and I look forward to a reply Smiley Happy

SherylBT

CloverQ
9,085 Posts
Former Staff
Australia
Former Staff

9,085Posts

0Kudos

1,386Solutions

Re: GST on Commission appearing as a negative purchase

Hi @SherylBT 

 

The reports and BASlink calculation were designed to meet ATO's reporting requirements, I'm afraid that we do not have plan to change how data are gathered and reported in GST reports. 

 

For any incomes, we do suggest recording them accordingly. They can be recorded as sales invoices, receive money transactions, or even journal entries (sales). If you have a supplier who is also a customer, I'd suggest following this Help article to set it up as contra deals: Dealing with a supplier who is also a customer.

 

It would also be a good idea to discuss with your accountant for the best ways to set up and record these transactions for your business situation.

Kind regards,
Clover

MYOB Community Support

Online Help| Forum Search|Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

StephanieLee
Experienced Partner
20 Posts
Experienced Partner
Australia
Experienced Partner

20Posts

5Kudos

3Solutions

Accepted Solution Solved

Re: GST on Commission appearing as a negative purchase

Hi SherylBT, I use the method @Steven_M has suggested, having two cards for each supplier (one a customer and one a supplier) and using a "contra" bank account to offset the sale amount of the commissions from the suppliers purchase.  I take your point though, it certainly is a lot of work if there are a large volume of transactions.

 

One work around might be to do just two journals at the end of the BAS reporting period to "correct" the entries in bulk.  To make things easier though, you might need to have a separate Commission income account that you only use for commissions that have been deducted from purchases.  Then after the quarter you can just look at that one account to see the total value of commission that has been deducted for the period - and do the correcting entries as per below:

 

E.g.  If I have earnt (deducted from purchases) $2,000 plus GST from all my suppliers, then the following journal will reverse the negative purchase entry.  Note: before recording make sure the "Display in GST [BAS] Reports as" has Purchases selected.

Commission Earned on purchases DR $2,000.00 (plus GST)

Contra Account CR $2,200.00 N-T

 

Then do another journal, making sure the "Display in GST [BAS] Reports as" has Sales selected to make the correction and correctly record the sale:

Contra Account DR $2,200.00 N-T

Commission Earned on purchases CR $2,000.00 (plus GST)

 

As you can see, the net effect on both these journals is nil - it just moves them from a purchase to a sale on your report.

 

Hope this is of some help.

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