DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

BAS G10 figure replicated at G20 with latest update

#1

Hi, I’ve been reading through all the forum questions regarding how Manager comes up with the figure for G10 on the GST Calculation worksheet and tearing my hair out trying to work out why I have a number in this field and where it has come from. I have a couple of businesses using Manager on my computer and I updated recently to the latest version 19.2.58.

I have found that in both businesses, all BAS GST Calculation Worksheets have suddenly changed the values at G10 (usually zero) to match the amount at G20. I’ve attached a screen grab of a BAS worksheet that I previously saved (showing zero at G10), and the same worksheet in Manager. This is the same for all previous BAS worksheets for both businesses.

I’ve also had this warning pop up a couple of times now too.

Is there something that I’ve done wrong??? TIA

0 Likes

#2

G10 is for capital purchases or asset purchases such as motor vehicles, furniture, equipment, commercial properties, etc. If you didn’t make any capital purchases the zero under G10 is correct.

0 Likes

#3

Thanks Tony. Yes, zero is correct, however since I’ve updated Manager it has automatically inputted the the figure shown at G20 into G10 on all my BAS worksheets, which is clearly wrong. Not sure why this is happening and how to fix it?

0 Likes

#4

Have you entered a payment of the tax owing of the $547 to the tax department dated within the period of the report and used tax code other than “No Tax”? If so, this will affect the report in the manner you have described.

0 Likes

#5

No, I haven’t entered any payment to the tax department during this period. I’ve checked that other tax payments outside of this period use the tax code ‘No Tax’.

0 Likes

#6

Next step would be to check the “Tax Audit” report, for the period, and check the amounts next to the balance sheet accounts as these contribute to G10.

0 Likes

#7

I’ve gone through the Tax Audit report and drilled down but can’t find any figures that account for the amount.

0 Likes

#8

My apologies. I have re-checked mine again and I can reproduce what you describe.

0 Likes

#9

Are you seeing the same thing in your BAS worksheets?

0 Likes

#10

Maybe not, I have just realized that the amounts in the Tax Audit report are exclusive while the amounts in the Worksheet are inclusive. This confused me for a minute. My reports appear to be correct.

0 Likes

#11

Hmm, strange that it’s happening to both of the businesses I have setup with Manager.

0 Likes

#12

Here’s a copy of a section of the the BAS Calculation Worksheet that I exported previously for a different business:

And here’s the same report since upgrading Manager. I haven’t changed anything or even hit ‘update’ and this is what it’s showing at G10, mirroring G20:

I’m so confused.

0 Likes

#13

Just checked my calculation sheet and I now have a figure at G10??
Will check into it further and post.

Edit: The figure at G20 is being put into G10 as well in 19.2.54. Now also 19.2.62.
gstwrong

0 Likes

#14

I have done some more testing and believe that the problem is as follows:

The amounts at G10 and G11 are derived by starting with the total of the ex GST amounts for each tax code and then adding the total of the GST on these amounts per code. However, the program is adding all the GST to the G10 code instead of splitting the appropriate amounts between each code.

The below test example may make my explanation clearer.

image

The example shows:
$550,000 ($500,000 + GST $50,000) of capital purchases
$660.00 ($600 + GST $60) of non-capital purchases

The $60 GST is incorrectly being included at G10 instead of G11.

The original post before and after shots also confirm this explanation.

I would classify this as a bug.

0 Likes

#15

Relying on @AJD’s example, I will put this into the bugs category.

0 Likes

#16

Thanks for the replies. Good to know it’s not just me. All other fields seems to be working normally.

0 Likes

#17

Fixed in the latest version (19.2.64)

Also, the latest version is adding tax code GST 10% (Capex) for the purpose of reporting under G10.

I think that’s probably cleaner and more straightforward solution.

0 Likes

Non-capital expense GST showing on G10 (Capital Purchases)
#18

Hi Lubos
I just upgraded from version 18.10.65 to 19.2.66
I did have a figure in G10 - correct as it is capital expenditure. With new version this amount is now included in G11 and not shown in G10.
This is not really a problem for me to submit BAS as (in Australia) doing BAS online you only need to enter the figure at G20 for purchases. It may be important for others.

0 Likes