LA Elexio - Transition: How to get historical reports from Logos Accounting

 

How to get historical reports from Logos Accounting

 
Sections in this article
 

 

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.
 
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.