cancel
Showing results for 
Search instead for 
Did you mean: 
Rebecca - Product Champion
Level 3

Discrepencies between reports and BAS

I'm seeing discrepancies between the figures in my reports against what is in the Prepare BAS screen.

Solved
Best answer September 11, 2020

Best Answers
Rebecca - Product Champion
Level 3

Discrepencies between reports and BAS

The best answer to this question will depend on which section is not balancing, e.g. Sales or Wages however I have outlined below the most common reasons below and their respective workarounds:

 

1. Sales and/or Expense figures do not match P&L:

  • Review the Transaction Detail by Tax Code report to ensure the correct transactions are listed with the correct tax codes and have also been allocated to the correct accounts.
  • Run the GST Amendment Report with the Tax Agency set to Australian Tax Office and confirm if there are amendments affecting the overall Sales/Expense figures.

2. Wages and/or PAYG does not match:

  • Compare the Transaction Detail by Tax Code report with the Detailed Activity Report in Payroll to ensure there are no missing or duplicate Payroll Journals. If yes, either re-export the journal or delete the duplicate.
  • The Transaction Detail by Tax Code report will also show you if there are incorrect transactions coded to W1 or W2 that are affecting the balances.
  • Run the GST Amendment Report and switch the Tax Agency to PAYG Withholding to review payroll related amendments.

If there are incorrect, missing or duplicate transactions affecting the BAS figures it's best to edit these manually. You may also enter an adjustment journal but we only recommend doing this with the advice of your Accountant.

 

If you are seeing a number of amendments from past lodgements we recommend unlodging the summaries back to the date of the first amendment and relodging.

 

If you have exhausted the below steps or are seeing an error message please contact the Support Team for further assistance.

 

 

 

 

 

 

View solution in original post

3 Comments 3
Rebecca - Product Champion
Level 3

Discrepencies between reports and BAS

The best answer to this question will depend on which section is not balancing, e.g. Sales or Wages however I have outlined below the most common reasons below and their respective workarounds:

 

1. Sales and/or Expense figures do not match P&L:

  • Review the Transaction Detail by Tax Code report to ensure the correct transactions are listed with the correct tax codes and have also been allocated to the correct accounts.
  • Run the GST Amendment Report with the Tax Agency set to Australian Tax Office and confirm if there are amendments affecting the overall Sales/Expense figures.

2. Wages and/or PAYG does not match:

  • Compare the Transaction Detail by Tax Code report with the Detailed Activity Report in Payroll to ensure there are no missing or duplicate Payroll Journals. If yes, either re-export the journal or delete the duplicate.
  • The Transaction Detail by Tax Code report will also show you if there are incorrect transactions coded to W1 or W2 that are affecting the balances.
  • Run the GST Amendment Report and switch the Tax Agency to PAYG Withholding to review payroll related amendments.

If there are incorrect, missing or duplicate transactions affecting the BAS figures it's best to edit these manually. You may also enter an adjustment journal but we only recommend doing this with the advice of your Accountant.

 

If you are seeing a number of amendments from past lodgements we recommend unlodging the summaries back to the date of the first amendment and relodging.

 

If you have exhausted the below steps or are seeing an error message please contact the Support Team for further assistance.

 

 

 

 

 

 

cz10
Level 1

Discrepencies between reports and BAS

i have tried reviewing the transaction detail by tax code report & it correctly shows all wages are in W1, but doing the BAS they are not being picked up. yet the PAYG withheld amount is correct.

the number being brought through does not appear to be a multiple of anything that i can work out.

 

 

Intuit Zac
Content Creator

Discrepencies between reports and BAS

Hi Cz10, 

 

Thank you for reaching out on this. 

 

One of the reason that can cause what you are experiencing is due to amendment from previous BAS period(s). I would suggest contacting our support team and do a SmartLook (Screen share) session so we can help taking a better look at this with you. Please find contact details in our Contact Us page below:

 

https://help.quickbooks.intuit.com/en_AU/contact

 

Thank you and please let us know if you require any additional assistance.