How do I restore my Payroll taxes after using the Download Taxes feature in Payroll?
Description
Cause
Resolution
[BCB:1:Backup warning:ECB]


This solution requires that Download Taxes was used to install the new taxes and that no errors occurred during the update to indicate that the backup was not made.

Note: A similar restore may be done if a File Tools backup was made manually prior to downloading taxes. If File Tools was used, the locations and naming conventions will be different.

Option A: For Temporary calculations or corrections using and old tax file:

  1. Create a temporary folder on your server.
  2. Copy or Note the location of the new temporary folder (i.e. \\\Users\\Desktop\Tax 2015)
  3. Navigate to the location of where your backup taxes are stored.
    Note:If there are multiple files ensure you are selecting the correct one. Date modified should match the date that the taxes were updated and will contain taxes from before that date/time.
  4. Copy the backup file to the new temporary folder on your Desktop.
  5. In the new folder, double click the backup file to extract the files.
  6. Select Restore, in the Destination paste or enter the temporary path you created.
  7. Go to Payroll, Files, Company Settings, File Locations.
  8. Scroll down to the grid until you see the PR Tax box.
  9. Copy or note the location of your current tax file.
  10. Enter the location of your temporary tax file in the grid next to the PR Tax.
  11. Click OK to close and save. (If there is already an existing path in this location, copy and paste this to notepad as it will need to be put back in after you're finished.)
  12. Go to Set Up, Taxes, Tax Rates and confirm that the system is using the backup taxes instead of the current taxes. Confirm that the effective dates and rates on your taxes are for the current period.
  13. Once error correction is completed, go back to File, Company Settings, File Locations and clear out the PR Tax box or enter/paste the location of your original tax file you saved from step 9 back into the PR Tax box.
    Important Note: If you skip this step you will be using the wrong tax rate going forward!

Option B: Restore taxes to live data for continuous use:

  1. Determine the location of your tax file.
    1. In Payroll, from the File menu, select Company Settings, File Locations.
    2. Scroll down to locate PR Tax.
    3. Make note of the path in the Data Folder column. If there is no file path the file is in your current data folder.
    4. Click Cancel to exit the File Locations window.
  2. Rename your tax file:
    1. Use File Tools to rename the Tax.prx file.
    2. Use File Tools to rename the Pr.frm file. This file is located in the Formula folder. For example, \\\Timberline Office\9.5\accounting\Formula\
    3. Restore your tax and formula files:
      1. Use File Tools to restore the Pr.frm file from the backup to your Formula folder. All tax files that Sage backs up when you use Download Taxes appear in the Backup_tax folder in your company data folder.
        Tip: The file format is Backup_tax_123015_115013.tszip where 123015 is the date of the backup (12-30-15) and 115013 is the time (11:50 and 13 seconds). Select the appropriate backup.
      2. Use File Tools to restore Tax.prx file from the backup created by Download Taxes to the applicable location of your taxes. Select the link below for details.
        Tips:
        • If you created a manual backup with File Tools, browse to and restore from that backup.
        • All tax files that Sage backs up when you use Download Taxes appear in the Backup_tax folder in your company data folder.
        • The file format is Backup_tax_123015_115013.tszip where 123015 is the date of the backup (12-30-15) and 115013 is the time (11:50 and 13 seconds). Select the appropriate backup.
  3. Verify the correct taxes were restored:
    1. In Payroll, from the Setup menu, select Taxes, Tax Rates.
    2. Confirm that the effective dates and rates on your taxes are for the current period. For example, review the date in the Effective box on the federal withholding tax FWH.
    3. Click Cancel and then click Close.
Steps to duplicate
Related Solutions

How do I rename a file using File Tools?
How do I verify the location of my Payroll tax file?
How to download Payroll Tax Updates from the Knowledgebase