Forum Discussion

Aratula's avatar
Aratula
Experienced Cover User
3 years ago
Solved

Entering Rent Received with Expenses and how it is processed through to BAS

Hi Everyone

I have rent received every month, and it does not go correctly through to MYOB's BASlink the way I have tried to enter it.

 

I have tried through Receive Money, and also as a General Journal.  The transaction is for rent deposited to our account, some is rent with no gst, the rest is real estate fees and repairs and maintenance to the property that is all deducted, with gst. 

 

I keep getting negatives in the BAS for GST Purchases or the GST free sales comes out completely wrong.

 

I don't know what I'm doing wrong.  I have been using MYOB for 20 years and never had this issue.

 

Thank you if there is anyone who can help me!

Kerri

  • Hi Kerri

     

    The best thing to do would be

     

    Receive money and record the entire rent to undeposited funds then do a spend money for the expenses to undeposited funds and then do a [repare deposit.

     

    By using the N-T code you are not reporting the income through to ATO so that may also be the issue, I hope my suggestion gives you the solution you need 

     

    Lisa

     

     

7 Replies

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi Kerri

     

    The best thing to do would be

     

    Receive money and record the entire rent to undeposited funds then do a spend money for the expenses to undeposited funds and then do a [repare deposit.

     

    By using the N-T code you are not reporting the income through to ATO so that may also be the issue, I hope my suggestion gives you the solution you need 

     

    Lisa

     

     

  • Aratula's avatar
    Aratula
    Experienced Cover User
    3 years ago

    Hi Lisa

     

    Just wanted to say thank you again, I have followed your advice and this is the only way that works.  It's a roundabout way, and I think the software should be able to handle negatives in the receive money window better than it does, particularly with regards to gst, but your advice does work, and at this point after all the time I have spent on it, I am just glad to have come out with a win.

     

    After deleting all my previous transactions and running the BAS again, the reports and figures now make sense. 

     

    I am very grateful, thank you!

     

    Kind regards

    Kerri

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi
    the received money should be

    4-xxxx income account tax code - gross rent

    6-xxxx expense account neg tax code 

     

    eg rent payment received $650

     

    4-xxxx 700.00 (tax code ITR? FRE) 

    6-xxxx -50.00 (GST)

     

    that should put the correct amounts in the correct BAS categories 

     

    hope that helps

     

    Lisa

  • DuncanS's avatar
    DuncanS
    Ultimate Partner
    3 years ago

    Aratula LRBooks61 

     

    As Residential Rent is Input Taxed, I understand that GST cannot be claimed on Expenses.

    Commercial Rent is GST and GST can be claimed on Expenses.

     

    Have a talk to the ATO and/or your Tax Accountant.

     

    Duncan

     

     

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Also make sure your baslink is set up to capture the tax codes correctly 

     

    Lisa

  • Aratula's avatar
    Aratula
    Experienced Cover User
    3 years ago

    Hi Lisa

     

    Thank you for your response to my problem.

     

    This is basically what I am doing, with the exception that I use N-T for the rent as the code rather than FRE. 

     

    What is happening in the GST reporting is that the negative portions of the receive money transaction which are the expenses with GST go into the sale value column in negative, with tax collected also as a negative.  This is not necessarily incorrect as these are expenses so they are just being reported as a negative sale with negative gst, and at the end it should work.  However in the BASlink, these go across as negative figures into the sales, and into gst collected.  And the ATO do not accept negatives in the BAS.

     

    We have no sales in this entity that are recorded with gst to offset the above. 

     

    I have tried entering the transactions as a GJ instead, hoping that the affect on the GST reporting and therefore BASlink are not the same, but have found this also does not work.  There are negatives in the N-T values which again just throw the BASlink out completely.

     

    I guess I have always had other sales in the same company with gst as well as income of rent without gst minus expenses with gst and this has offset these negatives. 

     

    Im not sure if there is anything I can set up in BASlink differently? 

     

    Thank you so much for your advice, it is greatly appreciated, I am so frustrated by this.

     

    Thank you

    Kerri

     

     

  • Aratula's avatar
    Aratula
    Experienced Cover User
    3 years ago

    Thank you so much Lisa

     

    This makes a lot of sense and is not something I have tried. 

     

    Also agree the N-T code should probably be more like a gst free code in this instance, I just didnt think about it.

     

    I appreciate your thoughts on this very much, I knew there had to be another way, but after all the years of using myob I tend to stick with the way I have always done it.

     

    I will definitely be giving your advice a go.

    Kind regards

    Kerri