Forum Discussion

DiJac's avatar
DiJac
Experienced User
4 years ago
Solved

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's avatar
    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.

5 Replies

Sort By
Replies have been turned off for this discussion
  • Tracey_H's avatar
    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's avatar
      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's avatar
        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.