Logos Accounting to Elexio Financials - Data Migration

 

Index

 

Overview
Details of what is included
Process 
Help Resources
Archiving Historical Logos Data for Safe Keeping

 

 

Migration Overview

Data Migration is a service that moves information between software products. Data Migration is one component of your implementation process. Project management and change management are also required to effectively engage your people, develop new processes and configure new technology.  

Migration Details

Here's what is migrated:

  1. Demographic information from customer records for Accounts Receivable. Included fields: name, address, phone, if it's a business or not.
  2. Demographic information from vendor records for Accounts Payable. Included fields: name, address, phone, if it's a business or not.
  3. Demographic information from employee records for Payroll (not deductions, history, etc.). Included fields: name, address, phone, birth date, hire date, termination date, marital status, dependent exemptions, full-time or not.

     Additional details:

  • It includes only active records for each of the above.
  • To be clear, the following are not included in the migration:
    • transactions of any kind
    • journal entries
    • chart of accounts
    • payroll compensations, etc.
  • Vendors and customers do not associate with a particular company. All vendors and customers go into tables that aren't linked in any way to a company.
  • Employees are linked to a company.  
  • The data migration is typically done right away even if you are not ready to transition to using Financials immediately. If you add employees, vendors or customers into Logos Accounting after the migration, you will also have to add them into Financials. 

Migration Process

  • Pre-migration:
    • We send instructions for how to back up your data, create a free box.com account and upload the zip file to us
    • You back up the Logos Accounting data into a zip file and upload to the box.com folder we have emailed you. If you have checked all your email folders including the spam folder and don't see a box.com invitation email, please email support@elexio.com with the Subject of Logos Accounting Migration and text asking for a box.com invitation.
  • Migration
    • We create your instance and run the migration
    • We email you with the website link, login credentials and getting starting instruction links
  • Post-migration:
    • You login (your password is case sensitive and you will be prompted to reset it after your first log in)
    • You contact your trainer to schedule your sessions if you haven't already
    • You begin setting up and using the system

Please note the following regarding the migration:

  1. We recommend that you schedule time with a trainer to help with set-up and developing a proper chart of accounts before you begin creating your chart of accounts. 
  2. Vendors are created but you have to create a chart of accounts in the General Ledger and a bank account in Bank Account Management before you can get to Accounts Payable to see the vendors.
  3. Similarly, with employees, you need to do some setup to see the employee records. 
    • In Payroll you will have to setup the Employer Information under Modify and setup at least one compensation and deduction.

Help Resources

If you have the Assisted Training Success Plan, it includes access to our library of Financials Education Webinars as well as two 1-hour sessions with a Financials trainer. Please use the following information to access your Education Webinars and schedule your Assistance Sessions. 

Financials Education Webinars: https://launchchms.com/financials-webinars Password: (emailed to you)

Financials Assistance Sessions: To schedule a trainer, please go to: https://calendly.com/financials/financials-assistance-session 

We have also put together a number of help resources at https://launchchms.com/launch-pads/financials 

If you have questions about the product features, open a support request by sending an email to financialssupport@elexio.com or call our Support Team at 888-997-9947 ext. 2. 

If you have questions about the migration specifically, please email support@elexio.com with the Subject of Logos Accounting Migration.

Archiving Historical Logos Data for Safe Keeping

Why? In case you need to refer to it after losing access to Logos Accounting. You could lose access in multiple ways. If you are using the hosted version, the server will be turned off and will no longer be accessible. If using a local copy, you could lose access if the computer dies, if the computer gets too old to run or maintain, if the computer gets a virus, if Windows is updated and the Windows version is no longer compatible with Logos, etc.   

It is best to save the archive report files on a cloud drive like google drive or a network drive and not just on your hard drive unless your hard drive is regularly backed up. If not, your hard drive could break and you could lose the files.

Sections include:
  • Setting up reports
  • How to print an employee report
    • How the active date affects report data
    • How to ensure all accounts print on reports: even those with zero balances or those that are inactive
  • How to print an annual transaction report
  • How to get a report of all accounts with their ending balances
  • How to get a Vendor Payments Report sorted by Vendor
  • How to print a Vendor Master List
  • How to print a list of Vendors and their 1099 amounts 

Setting up reports 

How the active date affects report data

For any report, if you would like the report for a different year, you must set the active date to any date in that year and run the report. 
File → Set Active Date: Use the arrows to the right and left of the Month and Year to change either. Once you select any date in the correct year, click OK at the bottom. To set it to today's date, click the middle button at the bottom.
setactivedate.jpg
 

How to ensure all accounts print on reports: even those with zero balances or those that are inactive

Before printing any reports, go to File → Preferences → Settings
pirntzeroandinactive.jpg
  • Mark Print Inactive Accounts
  • Mark Print $0.00 Balance Accounts  

How to print an employee report

Click Payroll → Employee Reports → Employee Profile
  • Select the option to print all employees
  • Do not use the 1 line listing
  • Do not exclude inactive employees
  • On the Output Destination screen, choose the option to Send to PDF or the option to Export and then choose the Delimited with Comma format then select Print. Save the report to your hard drive. 

How to print an annual transaction report for each year which also lists the ending account balances

The Trial Balance Detail is a good way to get all of your transactions for the year.
 
Click General Ledger → Trial Balance → Trial Balance Detail
  • Select Next and Click the Periods Tab.
  • Change the Period Range to 1 - 13
  • Run this for each year you need
  • On the Output Destination screen, choose the option to Send to PDF or the option to Export and then choose the Delimited with Comma format then select Print. Save the report to your hard drive. 

How to print a Vendor Payments report sorted by Vendor

The best way to get the detailed payment transactions for each vendor is to use the Journal Reports for AP and for periods 1 through 13 for each fiscal year. Export the report to a CSV file and then you can sort it however you want. This report will show the payment date, Vendor, Check#, and Amount. It also shows the GL Account numbers and the Reference field from the bill.
 
Click General Ledger → Other Reports → Journal Reports
Under Print Journal select AP and choose By Period and enter 1 - 13 as follows: 
apbyperiod.jpg 
  
How to print a Vendor Master List
Click Accounts Payable → Vendor List → Mark Profile 
  • On the Output Destination screen, choose the option to Send to PDF or the option to Export and then choose the Delimited with Comma format then select Print. Save the report to your hard drive. 
To Print a list of Vendors and their 1099 amounts for each year
Click Accounts Payable → Vendor List → By Name (leave defaults) → Next
  • On the Output Destination screen, choose the option to Send to PDF or the option to Export and then choose the Delimited with Comma format then select Print. Save the report to your hard drive.