Create new company

Question

I'm trying to create a new company but copy all the information from an existing company. Like company info, vendors, payroll employees, etc. I can't figure out how to do it.

StephenC · Accepted Answer

These instructions are from the knowledgebase entry ID: 13021 
 If you have quotation marks in your data they will interfere with the import process. I see this most often in inventory where the quotation mark is used as an inch symbol for product descriptions. You must remove quotation marks before exporting your data for this process to work. 
 Sometimes this process goes very smoothly and sometimes it is the complete opposite. If you decide you would like to outsource this project, you can contact me at scollins@iqacct.com or 918-851-9713 and I can give you a quote.

How do I rebuild a company?

Products

Sage 50&mdash;U.S. Edition

Country

North America

Description

How to rebuild a company 
 Can the accounting method or fiscal year be changed? 
 How to change Fiscal Year 
 How to change Accounting Method 
 How to change the number of accounting periods per year or fiscal year setup 
 How to change Accounting Method from Cash to Accrual basis 
 How to change Accounting Method from Accrual to Cash basis 
 How to change fiscal year period structure 
 How to change accrual method

Disclaimer

Support

Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.

Resolution

Note: 
 
 If changing your Accounting Method, you cannot transfer journal data (transaction history) only maintenance records may be imported (vendors, customers, chart of accounts, Inventory Items, etc.) 
 A technical support plan provides support for the errors that come up during process (refer to Sage Business Care Support Services for the defined scope of support ) 
 It is highly recommended you select Include Headings on the Options tab when you export, and then select First Row Contains Headings when you import 
 It is also highly recommended to make a unique backup after each successful import 
 When performing a rebuild, all Direct Deposit information for the company and employee will have to be re-entered. Please see Article ID 51773: Direct deposit account info not being brought over in company rebuild for more information. 
 
 Warning: If your data is damaged it is not recommended to rebuild your company using this method, as the damaged data may be transferred. If done, do not remove the original company until sure the rebuild was successful. Section I: Create a New Company 
 
 Select File , and then select New Company 
 Click Next 
 Enter the company information for now, add New to the company name so you can distinguish it from the original company (this will be changed back to the real company name once the rebuild is complete), and then click Next 
 Select Copy settings from an existing Sage 50 company , and then click Next 
 If changing accounting period structure, be sure to clear Accounting Periods , and then click Next 
 Select an accounting method, this should be the same as in the original company, unless you are rebuilding to change accounting methods, and then click Next 
 Select a posting method , and then click Next 
 If you chose not to copy Accounting Periods, you will need to choose an accounting period structure, and then click Next 
 Choose the month of Period 1, and then click Next 
 Click Finish 
 
 Section II: Export and Import Maintenance Records 
 
 Select Maintain , Company Information , and then note the Directory 
 Close Sage 50 
 Open Computer or My Computer and browse to the original company's Directory 
 Copy the following files:

RECUREX.DAT 
 REPORT.DAT 
 RPTDATA.DAT 
 TAXAUTH.DAT 
 TAXCODE.DAT 
 TAXTABLE.DAT 
 TEMPLATE.DAT 
 QTYDISC.DAT (Premium for Distribution, Premium for Manufacturing and Quantum Accounting only)

Right-click, and then click Paste into the new company's directory 
 
 Note: If prompted, overwrite the existing files in the destination. 
 
 Open Sage 50 and the original company 
 Select File , Select Import/Export , and then export each of the following items:

Chart of Accounts List (General Ledger) if using Budgets 
 Budget List (General Ledger) 
 Employee List (Payroll) 
 Vendor List (Accounts Payable) 
 Customer List (Accounts Receivable) 
 U/M List (Inventory) Premium for Distribution, Premium for Manufacturing and Quantum Accounting only 
 Inventory Item List (Inventory) 
 Bill of Materials Listing (Inventory) 
 Phase List (Jobs) for Complete, Premium, and Quantum Accounting only 
 Cost Code List (Jobs) for Complete, Premium, and Quantum Accounting only 
 Job List (Jobs)

Close the original company and open the new company 
 Select File , and then select Backup and make a backup of your company 
 Go to File , and then click Select Import/Export 
 Import each of the following items: 
 
 Note: You must import in the exact order listed and make a unique backup after each successful import. 
 
 Chart of Accounts List (General Ledger) if using Budgets 
 Budget List (General Ledger) 
 Employee List (Payroll) 
 Vendor List (Accounts Payable) 
 Customer List (Accounts Receivable) 
 U/M List (Inventory) Premium for Distribution, Premium for Manufacturing and Quantum Accounting only 
 Inventory Item List (Inventory) 
 Bill of Materials Listing (Inventory) 
 Phase List (Jobs) for Complete, Premium, and Quantum Accounting only 
 Cost Code List (Jobs) for Complete, Premium, and Quantum Accounting only 
 Job List (Jobs)

Manually enter inventory item beginning balances and/or job beginning balances, if needed 
 If you using Sage Payment Solutions, select Services, Credit Card Processing and enter your Merchant ID and Merchant Key 
 Select File , and then select Backup and backup your company 
 
 Note: If you are rebuilding to change accounting methods, or due to corruption in the original company, stop here. You will need to enter beginning balances for your customers, vendors, and employees.

Sage 50 US

Create new company

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING