Create new company

SOLVED

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.

Top Replies

  • +1
    verified 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 [email protected] or 918-851-9713 and I can give you a quote.

    How do I rebuild a company?

    Products
    Sage 50—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
    1. Select File, and then select New Company
    2. Click Next
    3. 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
    4. Select Copy settings from an existing Sage 50 company, and then click Next
    5. If changing accounting period structure, be sure to clear Accounting Periods, and then click Next
    6. 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
    7. Select a posting method, and then click Next
    8. If you chose not to copy Accounting Periods, you will need to choose an accounting period structure, and then click Next
    9. Choose the month of Period 1, and then click Next
    10. Click Finish

    Section II: Export and Import Maintenance Records

    1. Select Maintain, Company Information, and then note the Directory
    2. Close Sage 50
    3. Open Computer or My Computer and browse to the original company's Directory
    4. 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)
    1. Right-click, and then click Paste into the new company's directory

    Note: If prompted, overwrite the existing files in the destination.

    1. Open Sage 50 and the original company
    2. 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)
    1. Close the original company and open the new company
    2. Select File, and then select Backup and make a backup of your company
    3. Go to File, and then click Select Import/Export
    4. 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)
    1. Manually enter inventory item beginning balances and/or job beginning balances, if needed
    2. If you using Sage Payment Solutions, select Services, Credit Card Processing and enter your Merchant ID and Merchant Key
    3. 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.