How to resolve this error in Sage 50 Accounting, which occurs when going to File, Payroll Formulas, User-Maintained.
- The TAXTABLE.DAT file contained in your individual company directory has become damaged.
- This happens when a tax update goes to a specific company folder instead of the data path.
- User Account Control can block access to the network data location.
CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. Extract TAXTABLE.DAT file from a Backup (.PTB) File
- Make a backup of your company.
- Find your company location and make a note of the directory.
- Close Sage 50 on all computers.
- Open File Explorer and browse to the company directory noted in step 2.
- Right-click TAXTABLE.DAT and select Rename.
- Rename the file to OLDTAXTABLE.DAT.
- Find a backup file (.PTB) created before the error occurring.
- Right-click and Copy the file. Then go to the Desktop.
- Right-click a blank area of the Desktop and select Paste.
- Right-click the backup file and select Rename. Change the PTB extension to ZIP.
- Right-click the .ZIP file and choose Extract All.
- Open the extracted folder, right-click TAXTABLE.DAT, and select Copy.
- Open File Explorer and browse to the individual company directory.
- Right-click and Paste.
- Open Sage 50.
- Verify that User-Maintained Payroll Formulas can open without error and that payroll calculates.
If the backup that contains the good TAXTABLE.DAT is old, then any missing User-Maintained formulas may need to be recreated manually. Follow How to update User-Maintained formulas for further details.
Recreate the file when there isn’t a valid backup
NOTE:
You'll need to recreate User-Maintained formulas when using this method.
- Make a backup of your company.
- Find your company location and make a note of the directory.
- Close Sage 50 on all computers.
- Open File Explorer and browse to the individual company directory.
- Right-click TAXTABLE.DAT and select Rename. Rename the file to OLDTAXTABLE.DAT.
- Open the company and answer Yes when prompted to create a new TAXTABLE.DAT file.
- Go to File, Payroll Formulas, User-Maintained and verify the error doesn’t occur.
- Create a new company.
- Select Maintain, Payroll, Payroll Setup Wizard.
- Click Next, and then click Next again.
- Answer the questions as they relate to your company on the following screens to recreate the needed formulas.
- Click Finish.
- Go to Maintain, Company Information and make a note of the directory.
- Browse to the directory noted above.
- Right-click TAXTABLE.DAT and select Copy.
- Browse to the directory noted in step 2.
- Right-click TAXTABLE.DAT in that directory and select Rename.
- Rename the file OLD2TAXTABLE.DAT.
- Right-click in a blank area and select Paste.
- Close all screens and open Sage 50.
- Select File, Payroll Formulas, User-Maintained and verify the formulas are now in your original company.
- Solution ID
- 220924350010375
- Last Modified Date
- Wed Jul 09 16:31:21 UTC 2025
- Attributes
-
Product Details
Integrated Product: Blueprints
- Views
- 0