Export and Import Journal Data (Rebuild Process)

This procedure will transfer journal data (transactions) from an existing Sage 50 company into your new Sage 50 company.

1. Continuing the rebuild process, close your new company, and open the original company.
2. From the File menu, choose Select Import/Export. Sage 50 displays the Select Import/Export window.

3. Export each journal from your old company. Change the Date range (on the Filter tab) to ALL; then set the beginning date back several years. This will help ensure that you access all of the data you want, including beginning balances.

   For example: Date: ALL From: January 1, 2004 To: December 31,2011

   Note: Before you export journal data, you should be aware that you cannot import journal entries dated past the end of the second open fiscal year in the new company. You will have to close the first fiscal year of the new company prior to importing these future transactions. However, you can import previous-year journal entries for beginning-balance purposes.

• General Journal* (General Ledger)
• Purchase Order Journal
• Purchases Journal* (Accounts Payable)
• Inventory Assemblies Journal (Inventory)
• Work Ticket Journal (Inventory) (Sage 50 Quantum Accounting)
• Inventory Adjustments Journal (Inventory)
• Sales Order Journal
• Sales Journal* (Accounts Receivable)
• Time Ticket Register - Time/Expense (Sage 50 Premium Accounting and higher). If you are using Sage 50 Pro Accounting, skip this register.)
• Expense Ticket Register - Time/Expense (Sage 50 Premium Accounting and higher). If you are using Sage 50 Pro Accounting, skip this register.)
• Payments (Cash Disbursements) Journal* (Accounts Payable)
• Cash Receipts Journal* (Accounts Receivable)
• Payroll Journal* (Payroll)

The Journals marked with an asterisk (*) contain beginning balance information as well as journal entries. Therefore, you must set your export date range back a few years to include all the needed information.

4. Close the original company, and open the new company.
5. From the File menu, choose Select Import/Export. Sage 50 displays the Select Import/Export window.

6. Import the journals that you exported from the original company.

   Tip: It's a good idea to make backups between each journal you import in case you run into errors. This way you do not have to repeat the entire import process.

   Import the following journals in the order in which they are listed:

• General Journal (General Ledger)
• Purchase Order Journal
• Purchases Journal (Accounts Payable)
• Inventory Assemblies Journal (Inventory)
• Work Ticket Journal (Inventory) (Sage 50 Quantum Accounting)
• Inventory Adjustments Journal (Inventory)
• Sales Order Journal
• Sales Journal (Accounts Receivable)
• Time Ticket Register - Time/Expense (Sage 50 Premium Accounting and higher). If you are using Sage 50 Pro Accounting, skip this register.)
• Expense Ticket Register - Time/Expense (Sage 50 Premium Accounting and higher). If you are using Sage 50 Pro Accounting, skip this register.)
• Payments (Cash Disbursements) Journal (Accounts Payable)
• Cash Receipts Journal (Accounts Receivable)
• Payroll Journal (Payroll)

7. After importing the journal data in the new company, post all journals, print all necessary reports, and compare the two companies. If there are any discrepancies, make necessary adjusting entries.

   Note: You cannot transfer memorized transactions between two Sage 50 companies. You must set up memorized transactions manually in the new company.

8. If you have a Paya account for storing credit card information or processing credit card transactions, be sure to enter your merchant ID and merchant key, if you haven't already done so. To do this, go to Services>Credit Card Processing.