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

Question

Hi EveryoneI have rent received every month, and it does not go correctly through to MYOB's BASlink the way I have tried to enter it.&nbsp;I have tried through Receive Money, and also as a General Journal.&nbsp; 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.&nbsp;&nbsp;I keep getting negatives in the BAS for GST Purchases or the GST free sales comes out completely wrong.&nbsp;I don't know what I'm doing wrong.&nbsp; I have been using MYOB for 20 years and never had this issue.&nbsp;Thank you if there is anyone who can help me!Kerri

lrbooks61 · Accepted Answer

Hi Kerri&nbsp;The best thing to do would be&nbsp;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.&nbsp;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&nbsp;&nbsp;Lisa&nbsp;&nbsp;

aratula · Answer

Hi Lisa&nbsp;Just wanted to say thank you again, I have followed your advice and this is the only way that works.&nbsp; 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.&nbsp;After deleting all my previous transactions and running the BAS again, the reports and figures now make sense.&nbsp;&nbsp;I am very grateful, thank you!&nbsp;Kind regardsKerri

lrbooks61 · Answer

Hithe received money should be4-xxxx income account tax code - gross rent6-xxxx expense account neg tax code&nbsp;&nbsp;eg rent payment received $650&nbsp;4-xxxx 700.00 (tax code ITR? FRE)&nbsp;6-xxxx -50.00 (GST)&nbsp;that should put the correct amounts in the correct BAS categories&nbsp;&nbsp;hope that helps&nbsp;Lisa

duncans · Answer

Aratula&nbsp;LRBooks61&nbsp;&nbsp;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.&nbsp;Have a talk to the ATO and/or your Tax Accountant.&nbsp;Duncan&nbsp;&nbsp;

lrbooks61 · Answer

Also make sure your baslink is set up to capture the tax codes correctly&nbsp;&nbsp;Lisa

aratula · Answer

Hi Lisa&nbsp;Thank you for your response to my problem.&nbsp;This is basically what I am doing, with the exception that I use N-T for the rent as the code rather than FRE.&nbsp;&nbsp;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.&nbsp; 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.&nbsp; However in the BASlink, these go across as negative figures into the sales, and into gst collected.&nbsp; And the ATO do not accept negatives in the BAS.&nbsp;We have no sales in this entity that are recorded with gst to offset the above.&nbsp;&nbsp;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.&nbsp; There are negatives in the N-T values which again just throw the BASlink out completely.&nbsp;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.&nbsp;&nbsp;Im not sure if there is anything I can set up in BASlink differently?&nbsp;&nbsp;Thank you so much for your advice, it is greatly appreciated, I am so frustrated by this.&nbsp;Thank youKerri&nbsp;&nbsp;

Forum Discussion

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

7 Replies

Related content

Final Pay Processing

Invoices receivable not showing

Receivables Reconciliation Report

BPAY PAYMENT NOT RECEIVED

Entering pay wrong

2FA verification process - need to repeat twice whole process

Entering an invoice

Trying to Process Payroll