Sage 50 Export and Import Journal Data

One can easily import the trial balance and general ledger details from Sage 50 Accounting over to the Working Papers file. The import method is different depending on the version of Sage 50 Accounting that is being used. To take a look at the list of supported Sage 50 Accounting versions, you need to check out the Software Import Index .

Import from Sage 50 Accounting (Canada)

Sage 50 Accounting (Canada) is previously known as Simply Accounting. The import process is also applicable to the Simply Accounting software.

Before proceeding, you need to complete the following pre-requirements:

• The user needs to Install either Sage 50 Accounting (Canada) or the Sage 50 Connection Manager utility. The user should include one of any of these applications to perform the import; however, it is recommended to not install both.
• In case you are importing data from a version older than 2008, it is advised to install the DAO import update.
• In case the Protection is activated within the Working Papers file, the user should have the Import file permission.

Read More : Importing and Exporting Transactions in Sage 50

Export and Import Journal Data

This process will transfer journal data or transactions from an existing Sage 50 company over to the new Sage 50 company.

Tip: You might want to print these instructions to be used as a checklist. Also, refer to Import/Export Tips for additional assistance.

• Focus on Continuing the process of rebuilding, for this, you need to close your new company, and then open the original company.
• Go to the File menu, next choose Select Import/Export. The Select Import/Export window displays the Sage 50.
• Next, you need to export each journal from the previous company. Change the Date range within the Filter tab over to ALL; next set the beginning date back to several years. This will help make sure that you access all of the data you require, including the beginning balances.
• For example: Date: ALL From: January 1, 2004 To: December

Note: Before exporting the journal data, you need to be aware that you cannot import journal entries dated past the end of the second open fiscal year within the new company. You will have to shut down the first fiscal year of the new company before importing these future transactions. Nevertheless, 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 (*) include the beginning balance details as well as journal entries. Hence, you need to set your export date range back a couple of years to include all the required information. Now shut the original company, and open the new company.

• Go to the File menu, and choose Select Import/Export. Sage 50 displays the Select Import/Export window.
• Import the journals that you exported from the original company.
• Tip: It is recommended to create backups between each journal you import in case you run into errors. This way you will not have to repeat the entire import process all over again
• Next, you need to Import the following journals in the order in which they have been 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)
• Once you have imported the journal data within the new company, post all journals, print all the required reports, and compare the two companies. In case there are any discrepancies, you need to make the required adjusting entries.

Note: One cannot transfer the memorized transactions between two Sage 50 companies. Bear in mind that you must set up the memorized transactions manually within the new company.

• If you own a Paya account for storing credit card details or processing credit card transactions, make sure to enter the merchant ID and merchant key, in case you have not done so already. To get this done:
  • Go to Services
  • Next, click on Credit Card Processing

Also Read : How to Export & Import Data Using CSV Format in Sage 50

Conclusion

So, there you have it people, these are some of the main aspects related to Sage 50 Export and Import Journal Data. However, if you have any doubts regarding the same you can still visit www.accountingadvice.co.

Frequently Asked Questions (FAQs)