BAS

The BAS figures produced from `Prepare BAS/IAS' within the Accounts Page do not match to the Payroll Summary and GL Summary reports. The BAS figures do not pick up all the payroll/wage allowances.

How can I display the transactions that the BAS is reporting, so as to compare with the summary reports?

Thanks

Tracey_H
4 years ago
DiJac

Hi Dianne

Since you're using BASlink the first thing I'd check is the dates, make sure you've selected the correct financial year and the period is correct under PAYG tax withheld:

Can I also get you to run the Payroll Activity summary and Payroll Register summary reports and make sure they are the same? The Payroll Summary report and Payroll Register summary get their figures from the Pay History in the employee card. The Payroll Activity report and the W1 field get their figures from pays allocated to payroll categories in Process Payroll.

A difference in the Activity and Register reports will mean that the Payroll Summary and BAS will not balance either. This is caused by manual changes made to the Pay History in the employee card. If you find that the Activity and Register reports are different, you will need to change the Pay History back to what it was and process any adjustments through Process Payroll.

Please let me know how you go with this.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Tracey_H
Former Staff
4 years ago
Hi DiJac

Thanks for your post. If you are lodging your BAS online, open the BAS then click on Settings and Set up activity statement fields. Make sure all applicable wage categories have been selected for W1 and W2. Once that is done click on Update from ledger in the top right corner:

The BAS doesn't filter by transactions but by the Tax codes and wage categories selected for each field so if the BAS is incorrect it generally indicates your set up is wrong.

Please let me know how you go with this.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
- DiJac
  Experienced User
  4 years ago
  Thanks Tracey, I am not lodging online, however I use the manual figures to lodge manually.
  
  I had verified, through the Setup button, that all Category/Desciption selections were selected correctly.
  
  I noticed that one of the W1 selections had a zero balance, even though amounts had been allocated during the last 3 months. And the other selections had incorrect amounts.
  
  For example, I checked the weekly payslips for one employee for the last 3 months - they matched the Payroll Summary report. However, the Payroll Summary Report does not match the totals in the W1 BAS Setup.
  
  I even tried to remove the totals from either end of the quarter to try and recreate the figures, no matter what I tried, I could not balance.
  
  I am concerned that every single BAS I have submitted is incorrect.
  
  All this is hard to articulate without both of us using the same data ....
  
  Thanks for your reply though.
  
  Dianne
  - Tracey_H
    Former Staff
    4 years ago
    DiJac
    
    Hi Dianne
    
    Since you're using BASlink the first thing I'd check is the dates, make sure you've selected the correct financial year and the period is correct under PAYG tax withheld:
    
    Can I also get you to run the Payroll Activity summary and Payroll Register summary reports and make sure they are the same? The Payroll Summary report and Payroll Register summary get their figures from the Pay History in the employee card. The Payroll Activity report and the W1 field get their figures from pays allocated to payroll categories in Process Payroll.
    
    A difference in the Activity and Register reports will mean that the Payroll Summary and BAS will not balance either. This is caused by manual changes made to the Pay History in the employee card. If you find that the Activity and Register reports are different, you will need to change the Pay History back to what it was and process any adjustments through Process Payroll.
    
    Please let me know how you go with this.
    
    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.