bas incorrect sales amount

Question

I am trying to lodge my September 2022 BAS online but it is stating the incorrect amount at 1B.

I processed the manual BAS and that has the correct amount but when I go to lodge online it is stating the incorrect amount.

I can see a lot of other people have had the same issue but I cant find any solotions?

tracey_h · Answer

Hi&nbsp;Danhunter&nbsp;
&nbsp;
Thanks for your post. The amounts prefilled in activity statements are determined by the field set up. As the manual and online BAS are set up separately it is possible for them to have different figures.&nbsp;
&nbsp;
The 1B field is calculated on the Purchases (G10, G11) fields, so check the correct GST codes have been selected for these fields in the online BAS. If you make any changes to the online BAS set up make sure you click on Update from ledger to refresh those fields.
&nbsp;
The Help Article, Get ready to lodge activity statements online, has detailed instructions to assist with setting up BAS fields.
&nbsp;
Please let me know if you need further help.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

danhunter · Answer

Thanks for the reply Tracey, but i cant see that it help me unfortunatley.. the amount shown in G1 is about $160k more than it should be! nothing about myob seems to add up correctly other than the profits and loss statement!! Im hoping I can find someone who can actually help me sort out myob as im paying $62 a month for somthing thats not working

danhunter · Answer

Tracey, this is a copy of what i have sent my accountant

MYOB just doesn't balance/add up correctly

the profits and loss statements looks close, however, the quotes I sent out that didn't go ahead have been added into my income/sales amount!! even though the quotes have been marked as declined.

sales

ive tried to lodge a BAS and myob is saying that the sales for the quarter is $509,118 this is incorrect as the sales for the quarter are $347,022.57 ( this is the amount I have invoiced for in the last quarter).

expenses

I believe that the profits and loss are correct when calculating the expenses, BUT if I go to my Purchase BILLS list on myob then the total is only $135,759....so I'm roughly $200k out on this one! Some expenses would have gone into Banking Spend Money BUT around 90% of expenses go through Purchase Bills!

TPAR

I spent over two hours on the phone with the ato the other night and went through the process of setting up and lodging the TPAR list to the ATO...it all went through as successful with the receipt numbers etc but I then got an email to say it was rejected because it has ASCII characters!!! no idea where or how.... I have tried a total of six times to get this to work.

It's very frustrating to spend $62 a month on myob and I have no faith in it whatsoever! If you know of anyone that can assist me in getting this working that would be very much appreciated.... or if you have time yourself.

tracey_h · Answer

Hi&nbsp;Danhunter&nbsp;
&nbsp;
There's a couple of things I need to check first:
&nbsp;

are you using AccountRight or MYOB Essentials? You've posted on the AccountRight board and mentioned manual BAS which points to AccountRight. But the account linked to your Forum log in is using MYOB Essentials and you mention Purchases&gt;&gt;Bills list which points to MYOB Essentials. If you can clarify which software you're using I can provide software specific information
what is your BAS accounting method, cash or accrual? Are you running the Profit &amp; Loss using the same accounting method?

If your accounting method is cash, only bills and invoices paid in that quarter will be reported in your BAS.&nbsp;
If your accounting method is accrual, bills and invoices recorded in that quarter will be reported in your BAS, regardless of whether they have been paid.
&nbsp;
Make sure you're selecting the applicable accounting method when running the Profit &amp; Loss.
The Purchases&gt;&gt;Bills and Sales&gt;&gt;Invoices lists won't necessarily match the Profit &amp; Loss. For example, if you filter those lists by the period 1 July to 30 September they will show all bills and invoices recorded in that period. If you run a cash Profit &amp; Loss for the same period it will only include paid bills and invoices.&nbsp;
&nbsp;
When reconciling your BAS run the GST reports to see which transactions are included in the BAS.
&nbsp;
For the TPAR error check for any invalid characters in the supplier cards.
&nbsp;
Please let me know how you go.

danhunter · Answer

Hi Tracey, first of all, thank you for taking the time to try and help me with this!&nbsp;I have checked and i am using&nbsp;&nbsp;MYOB Essentials Accounting + Payroll&nbsp;I can confirm my accounting method is set to ACCRUAL.&nbsp;I can confirm that ACCRUAL has been selected when running a profits/loss report&nbsp;I have run a GST report and I can confirm&nbsp;that the same sales amount of $343,774.18 has come in identical to the profits&nbsp;loss report, however, purchases/expenses seem to be&nbsp;varying with the gst report showing $20,369.37 less than the amount of expenses listed on the profits/loss? is this because of what you've said below in red?&nbsp;The Purchases&gt;&gt;Bills and Sales&gt;&gt;Invoices lists won't necessarily match the Profit &amp; Loss. For example, if you filter those lists by the period 1 July to 30 September they will show all bills and invoices recorded in that period. If you run a cash Profit &amp; Loss for the same period it will only include paid bills and invoices&nbsp;I don't know if the following&nbsp;makes any sense to you but I was speaking to my accountant today who seemed to be thinking that.....He thinks that because&nbsp;I am writing an invoice and then when it's&nbsp;getting paid to me I go into my sales, invoices, open invoices and then I select that invoice and&nbsp;create a payment&nbsp;that somehow it's been recorded&nbsp;twice???? He thinks that my&nbsp;bank is calculating the amounts&nbsp;automatically&nbsp;and then I'm writing&nbsp;it off as received&nbsp;(creating a payment) and somehow it's been recorded more than once??? not really sure if he thinks the expenses are doing the same or not???&nbsp;&nbsp;&nbsp;I still cant understand how when I go into BILLS and select the dates between 1/7/22-30/9/22 the amount only comes to $135,759.50 and yet the profit loss amount for bills/expenses&nbsp;is $349,974.05,and&nbsp; the purchases amount on the activity statement is $323,961....none of it seems to add up or make sense!&nbsp;&nbsp;I am 99.99% sure that the amounts shown in the profits/loss statements are correct.&nbsp;Amounts shown in the bas are definitely incorrect&nbsp;&nbsp;I really appreciate your help...I just hope we can resolve it otherwise i don't know what to do.&nbsp;&nbsp;&nbsp;&nbsp;I have also had a look at the supplier list and I cant see any&nbsp;invalid characters? I always check the abn lookup and copy and paste the correct name etc into the supplier name....&nbsp;

Forum Discussion

bas incorrect sales amount

10 Replies

Related content

Incorrect amounts

Incorrect items on hand amounts

Finalized BAS Report - Incorrect

Incorrect Billing

Problem with MYOB calculating incorrect amount of GST

backup date incorrect

incorrect overtime payment

Incorrect Due date on Sales Invoice