Skip to content
logo Knowledgebase

Exception: Negative Tax Total 3698

Created on  | Last modified on 


How to clear this exception in Sage Pastel Payroll?


This exception states that there are transactions linked to the calculation total “Non Retirement Funding Income” with negative amounts where the cumulative negative total for these transactions exceeds the cumulative positive total of the transactions with positive amounts linked to this calculation total.


  1. Click on View, Payroll Reports, Monthly Analysis
  2. Filter the report to show only the employee in question
  3. Ensure to run the report from the beginning of the tax year to the current period. Click ok to print the report. In the Income section you will see a code that has been processed as a negative (in most cases it will be the code 5020, 5018 or 5014). Also make a note of what transaction you are making use of to process the employee’s salary (code 5000, 5002, 5001). Once you have taken down the salary transaction and the negative income transaction you can close the Monthly analysis.
  4. Click on Setup, Transaction. Click on the Magnifying glass and select the code that is used as the Basic Salary (eg. Code 5000, 5002, 5001).
  5. Click on the Calculation Total Button. Scroll down and you will note that this code has been selected as Retirement Funding Income.
  6. Click Ok on the Calculation Total screen.
  7. Click on the Magnifying glass again and this time search for the negative income code (Code 5020, 5018, 5014). Select this transaction.
  8. Click on the Calculation Total Button. Scroll down and you will see that this code is specified for Non Retirement Funding Income (it will usually not be the same as the salary). Unselect Non Retirement Funding Income and select Retirement Funding Income (If you can’t unselect or select these fields you have processed employees that first needs to be clear run flagged).
  9. Click Ok on the Calculation Total screen and close Setup Transactions.

NOTE: A progress indicator will run through. If this does not clear the exception, your employee probably has a RFI profile. If this is the case you will have to add the negative income code to your RFI profile with the same percentage as your Basic Salary

  TIP: The negative income transaction (code 5020, 5018 or 5014 etc.) must always match the RFI or Non-RFI of the basic salary used.  If both are the same, please check if the employee has an RFI Profile, and make sure to add this code to the profile.