Sage 50 Export and Import Journal Data

Sage 50 Export and Import Journal Data process

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.

Accounting Professionals & Specialized Experts

Want quick help from accounting software experts? Get in touch with our team members who can install, configure and configure your software for you. Proficient in fixing technical issues, they can help you quickly get back to work whenever you encounter an error in Sage software. Our team is available 24/7 365 days to assist you. To get in touch.

Frequently Asked Questions (FAQs)

How can one Export Journal Entries from Sage 50?

In order to export journal Entries from Sage 50, you need to:
Note: Sage 50 exports will only operate with Sage 50 products, and not with other Sage products such as Sage 100, Sage 300, etc.
1. Start by Click on Billing located within the left-hand navigation panel.
2. Next, Click on the Reports tab.
3. Now Click on the Journal Entry Export – Accrual Basis or Journal Entry Export-Cash 4. Basis in the Executive section.

Is it possible to import Journal Entries into Sage 50?

Yes, for this you need to:
1. Make sure that no user is working for the company you are importing into.
2. Start by Clicking on File 
3. Next, click Import. 
4. To back up click Backup 
5. Finally, follow the prompts.

How can One Export Data from Sage 50?

For this, you need to:
1. Start by Clicking on File 
2. Next, click Data Export.
3. Now Click Payroll Data Export then click Next.
4. Next click Select the Company details you would like to export from the list of options, then click Next.
5. Select the details you would like to export. 
6. Finally, Click Next

Related Posts

Further Reading