Skip to content
logo Knowledgebase

How do I archive my Oldest Fiscal Year in Sage 100 Contractor SQL

Created on  | Last modified on 


Important : Only the latest version of Sage 100 Contractor is supported for the current tax year. Year-End updates will not be issued for older versions of Sage 100 Contractor. To ensure that your software is current with all government-required processing and reporting changes, open your Sage 100 Contractor company and click Home & Resources, Sage Support, Downloads and Updates.


To archive your oldest fiscal year follow these steps:

  1. Ensure you have completed Archive Oldest Payroll Year, before embarking on Archive Oldest Fiscal Year. It is also important to note if you used the Close Payroll Year process in menu 5-3-8 and wish to Archive Oldest Fiscal Year for that same tax year, you must also Archive the Oldest Payroll Year for that tax year. See Related Solutions for more information.
  2. Ensure all users are logged out of the Sage 100 Contractor company database.
  3. On the server, connect to Database Administration for Sage 100 Contractor
  4. Click Tune Up/Back Up/Restore. Select Back Up Companies. Create at least two (2) backups of the company database.
  5. Click Archive Company Data, Archive Oldest Fiscal Year
  6. Select the company to archive and follow the prompts to work through the Archive Oldest Fiscal Year wizard.

 NOTE: Data from the oldest fiscal year will be archived, and only 12 periods of data can be archived at one time. If you have data from multiple previous years, perform the Archive Company Data, Archive Oldest Fiscal Year process for each year you want to archive. Each year is archived individually in a separate company folder located on the database server machine in \\Sage100Con\Company

Related Solutions

´╗┐How to Archive Oldest Payroll Year

How do I back up and restore my company data in Sage 100 Contractor SQL?

U. S. Edition Recommended Timeline of Year-End Tasks. When and what to do for Sage 100 Contractor SQL

CANADIAN: Recommended Timeline of Year-End Tasks. When and what to do for Sage 100 Contractor SQL

When should I archive last year's company data?

How do I access my fiscal year and payroll archives?