Logos Accounting to Elexio Financials - Archiving Data

 

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.
 

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://getstarted.church/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://getstarted.church/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.