Reports available in the latest Logicim XLGL version
Ready-to-Use Reports, Fully Customizable
Logicim XLGL provides Ready-to-Use Reports that you can work with as-is or format to your liking. You can also easily customize them using Microsoft Excel features, VBA macros, and Logicim XLGL functions for maximum flexibility.
Visually Appealing Reports Across Key Business Categories
With Logicim XLGL, you gain access to visually appealing Reports across the most common business categories, helping you make informed and strategic decisions:
- Financials
- Payroll
- Customers
- Inventory
- Projects / Funding
- And more
Powerful Features to Save Time and Reduce Errors
These reports are designed to save you valuable time by automating data extraction and formatting. They reduce manual entry and minimize errors, helping you maintain data accuracy. Plus, they optimize your Sage 50 Reporting process directly in Excel, simplify complex tasks while organizing your data in a comprehensive manner.
Included FREE with Logicim XLGL
Logicim Ready-to-Use Reports come bundled with Logicim XLGL, delivering immediate value from day one.
Explore the Logicim Ready-to-Use Report Set
Discover the Logicim Ready-to-Use Report set, tailored specifically for your Sage 50 U.S. or Sage 50 Canadian edition.
Find out which Reports are included in your Sage 50 edition.
Trial Balance - Standard Trial Balance.
Balance Sheet - Standard Balance Sheet.
Balance Sheet- 12 Periods Fiscal - A Balance Sheet report displaying financial data across 12 months of the fiscal year for a comprehensive overview.
Comparative Balance Sheet - Monthly, Quarterly and Yearly Comparative Balance Sheets.
Income Statement - Standard Income Statement.
Income Statement- 12 Periods - The 12-Period Income Statement provides a monthly breakdown of income and expenses over the past 12 periods for financial performance tracking.
Comparative Income Statement - Monthly, Quarterly, and Yearly Comparative Income Statements.
Income Statement with Budgets - Income Statement with Budget and Variance.
Budget Report - A report showing only the budgeted income and expenses for a selected period.
Cash Flow - Cash Flow Statement.
Cash Flow-Enhanced - A cash flow report displaying both debit and credit transactions for each line.
General Ledger - General Ledger Report.
Trial Balance - Standard Trial Balance.
Balance Sheet - Standard Balance Sheet.
Income Statement - Standard Income Statement.
Income Statement with Budgets - Income Statement with Budget and Variance.
Aged Receivable - Customers with Aging Invoice, including Payment Transactions.
Cash Receipts Journal - A report that reviews received payments.
Commission - Simple Commission Report with options for Commission Percentage and whether to pay by Invoice Amount or Paid Amount.
Customer Management Detail - Customer report with invoice details and credit status.
Customer Sales History - Gross Margin Report by Customer.
Invoice Log - Invoice Log.
Invoice Register - Invoice Register Report.
Item Sold to Customers - Items Sold by Customer Report.
Sales Analysis - Quantity, Average Unit Cost, Amount, and Gross Profit of Item Sales.
Sales Journal - Sales Journal Report.
Sales - Sample Sales Report.
Sales Order - Sales Order Report.
Sales Order Register - Sales Order Register Report.
Sales and Outstanding Balances - A report that reviews sales and unpaid balances.
Sales Order Journal - A report that reviews sales order activity.
Aged Payable - Vendors with Aging Invoice, including Payment Transactions.
Aged Payable- All transactions - A report that lists all payables, including fully paid invoices, organized by aging periods.
Vendor Invoice Log - Invoice Log.
Purchase Analysis - Total Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Purchase Dashboard - Total Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Purchase Journal - A report that details all purchase transactions, including dates, amounts, and account allocations, for accurate tracking and analysis.
Items Purchased by Vendors - A report that reviews vendor-related purchases.
Proposal Report - A report that reviews proposals.
Quote Register - A report that reviews quotes.
Vendor Purchase and Outstanding - A report that reviews vendor purchases and balances.
Employee Compensation - The Employee Compensation Report provides an Overview of the Compensation and Benefits Awarded to Employees.
Payroll Register - Payroll Register.
Payroll Check Register - Payroll Checks.
Time Slip Report - A report that shows hours worked or time entries recorded.
Vacation and Sick Time - Employees Vacation and Sick Time.
Inventory Analysis - Item Cost and Quantity Information for a Selected Date Range.
Inventory Aging - This report produces a number of metrics associated with Inventory Aging.
Inventory Assemblies on Order - Inventory Assemblies Currently on Order.
Items Sold to Customers by Location - Items Sold to Customers organized by location, including a dashboard of Top Locations and Customers.
Inventory on Hand Analysis - Inventory on Hand Analysis Report with Breakdown and Charts.
Inventory Profitability - Inventory Profitability Report.
Inventory Stock Status - Inventory Stock Status Report.
Item List - Item List.
Job Ledger - Ledger Report Grouped by Job.
Job Profitability - This report helps analyze the profitability of jobs.
Job Register - Job Register Report.
Job Retainage - Receivable and Payable retainage on Jobs.
Unbilled Job Expense - Unbilled Job Expense.
Customer Standard Invoice - A standard invoice.
Dashboard Analysis 1-0 - Graphical Summary of Aggregated Key Performance Indicators, including Profit and Loss Summary, Top 5 Expenses, Top 5 Customers, Top 5 Products, etc., presented in two distinct layouts. The Dashboard layout reflects primarily current period values, while the Dashboard YTD layout displays year-to-date (YTD) amounts.
Inventory Analysis 1-1 - Item Cost and Quantity Information for a Selected Date Range.
Purchase Analysis 1-1 - Total Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Sales Analysis 1-4 - Quantity, Average Unit Cost, Amount, and Gross Profit of Item Sales.
Balance Sheet - A Balance Sheet with the option to create comparative Balance Sheets.
Income Statement - An income statement with the option to create comparative income statements.
Income Statement- Departmental - A departmental income statement.
Income Statement- Project - A by-project income statement.
Trial Balance - A Trial Balance report with the option to create comparative Trial Balances.
Trial Balance- Departmental - A Trial Balance by Department report.
Cash Flow- Detailed - A detailed cash flow report with the option to create a comparative cash flow report.
Transactions Report - A detailed GL Transaction Report grouped by Accounts.
Balance Sheet - A simple Balance Sheet.
Balance Sheet- Comparative Monthly - Comparative Monthly Balance Sheets - This Year vs Last Year
Balance Sheet- Consolidated - A Balance Sheet consolidating multiple companies on the same sheet.
Balance Sheet- Departmental - A Balance Sheet with columns for Departments.
Balance Sheet- Grouped - A Balance Sheet with custom grouping of Accounts.
Balance Sheet- Mapped - A Balance Sheet with custom grouping of Accounts, mapped for multiple companies.
Balance Sheet- Pivot table with chart - A Balance Sheet with the option to create comparative Balance Sheets.
Income Statement - A simple Income Statement.
Income Statement vs Budget - Annual Income Statement - Actual vs Budget
Income Statement- Actual vs Budget - Current Month, Current Month LY, YTD this Year
Income Statement- Comparative Unf - The Comparative Income Statement report summarizes and compares income and expenses over two or more specified periods for better financial analysis.
Income Statement- Departmental - An Income Statement with columns for Departments.
Income Statement- Departmental Pivot table - A Pivot Income Statement report per Departments.
Income Statement- Grouped - An Income Statement with custom grouping of Accounts.
Income Statement- Mapped - An Income Statement with custom grouping of Accounts, mapped for multiple companies.
Income Statement- Pivot Table with Chart - An income statement with the option to create comparative income statements.
Income Statement- Projects - An Income Statement with columns for Projects.
Income Statement- Projects 2 columns - Income Statement on two columns with Projects as rows.
Cash Flow- Detailed - Detailed Cash Flow report
Cash Flow- Pivot Table - Summary and Detailed Cash Flow report.
Cash Flow- Summary - Cash Flow Summary report
Financial Statements- Side-by-Side - Financial statements side-by-side (balance sheet and income statement)
Trial Balance - Simple trial balance
Trial Balance- Departmental - Simple Trial Balance with a column for each Department
Trial Balance- Departmental Comparison - Compare the trial balances of two departments side-by-side to analyze financial performance and account details effectively.
Trial Balance- Pivot Table Comparative - Comparative Trial Balance report compares account balances across multiple periods to track changes and ensure accuracy in financial reporting.
Trial Balance- Pivot Table with Chart - Regular trial balance
Customer Analysis - A report that reviews customer-related activity.
Sales Analysis - Sales analysis by Customers & Products
Sales Analysis - A report that reviews sales-related activity.
Purchase Analysis - A report that reviews purchase-related activity.
Inventory Analysis - Inventory Analysis by Products & Customers
Product Analysis - A report that reviews product-related activity.
Cash Flow- Detailed - Detailed Cash Flow report
Cash Flow- Summary - Cash Flow Summary report
Dashboard - Comprehensive Dashboard
Gain or Loss - A report that shows the overall result of gains and losses.
Ratios - A financial ratio report.
Tax - A report that reviews tax-related activity.
Unallocated - A report that shows items not yet assigned.
Customer Aging- Currency - Account Receivable aging with currency and more.
Customer Aging- Detailed and Summary - Shows outstanding receivables grouped by aging periods, tracking amounts due from customers.
Customer Aging- Formatted - A customer receivable aging report.
Customer Invoice Log - A detailed list of customer invoices, showing dates, amounts, and status for easy tracking.
Customer Invoice Log with Commission - A report that lists customer invoices along with calculated commission amounts based on specified criteria.
Customer Invoice Summary by Date - Shows a breakdown of invoices by year, month, and date, including amounts, sales tax, and totals.
Receipts by Payment Method - A report that summarizes receipts grouped by the payment methods used, such as cash, credit card, or check.
Sales Item Summary - Shows a summary of items sold, including unit, count, quantity, and total amount.
Product Income- Customer - Table of income by product and client.
Customer List - Customer List with Revenues.
Commissions by Percentage - A report that calculates commissions based on a specified percentage of invoice or payment amounts.
Customer Profitability Summary - Shows each customer's quantity sold, revenue, cost of goods sold, profit, and margin.
Sales by Salesperson and Item - A summary of sales transactions showing item-wise performance by salesperson, including quantity sold, sales, cost, and profit.
Vendor Aging - Account Payable aging with currency and more
Vendor Aging- Formatted - A vendor payable aging report.
Vendor Aging- Detailed and Summary - Displays outstanding payables categorized by aging periods, showing amounts owed to vendors.
Vendor List - Vendor List
Vendor List- Departmental - Vendor List by Department
Vendor Invoice Log - List of Vendor Invoices
Vendor Invoice Log- Pivot Table - List of Vendor Invoices
Vendor Invoice Log- Items - Tracks vendor invoices along with detailed item information.
Goods Orders- Pending - Shows purchase orders that are still open or partially fulfilled.
Goods Purchases- Items - Summarizes items purchased, grouped by vendor and item.
Goods Received- Pending - Lists of pending goods received.
Inventory List - List of Inventory Items; Qty on Hand
Inventory and Services List - Shows all inventory items and services available in the system.
Inventory and Services Summary - Summarizes quantities, sales, costs, and profits for all inventory items and services.
Inventory Summary - Provides an overview of total inventory levels and values.
Inventory Analysis - Inventory Analysis by Products and Customers
Sales Analysis - Sales analysis by Customers and Products
Pending Delivery Orders by Item - Shows items that are yet to be delivered to customers.
Pending Goods Received- Inventory - Lists supplier orders that have not yet been received.
Items Sold by Customers - Displays a list of items sold, grouped by customer.
Items Sold by Location - Lists items sold organized by sales location or branch.
Fifo Costing - FIFO Costing Report tracks inventory's average costs, remaining quantities, and values.
Physical Count Worksheet - Inventory Worksheet with Count and Values
Deductions and Expenses - The Employees Payroll Deductions and Expenses Report details all payroll deductions and employee-related expenses.
Detailed Employee Payroll - Comprehensive breakdown of employee earnings, deductions, and net pay for a specified payroll period.
Employee Compensation - A payroll report that shows each employee’s name, department, type, and gross pay for payroll tracking.
Payroll Check Register - Shows a list of all payroll issued, including employee names, reference, pay type, net pay, and dates.
Remittances- Agencies - A report showing payroll remittances made to CFF, Ministry of Finance, and other agencies.
Timesheets Daily Summary - Shows a detailed or summarized list of hours worked by employees over a period of time.
Vacation Payable - Vacation payable for chosen date.
Income Statement by Projects - An Income Statement with columns for Projects.
Income Statement by Projects 2 columns - Income Statement on two columns with Projects as rows.
Project Budget by Period - A report that tracks and compares budget allocations and expenditures across specified time periods.
Project List - Project List
Revenue and Expense by Project- Pivot Table - The Revenue and Expense by Project report details income and expenses allocated to specific projects for better financial tracking and analysis.
Bank Transactions - A report details all transactions made through a bank account, including deposits, withdrawals, and transfers.
Chart of Accounts - Chart of Accounts with Type, GIFI,Class...
Cheque Log - The report tracks all issued cheques, detailing amounts, dates, and recipients for financial record-keeping.
Customer List - Customer List with Revenues
Customer Invoice Log - List of Customer Invoices
Inventory List - List of Inventory Items & Qty on Hand
Project List - Displays a detailed list of all projects.
Vendor List - A comprehensive list of vendors with relevant details for reference.
Vendor List- Departmental - A list of vendors categorized by department.
Transaction List - A report is a detailed record within a specified period, showing the date, account, and amounts involved.
Income Statement- Departmental - An Income Statement with columns for Departments.
Income Statement- Program - An Income Statement with columns for Programs.
Income Statement- Program - An Income Statement with columns for Programs.
Program Budget by Period - A report that tracks and compares budget allocations and expenditures across specified time periods.
Revenue and Expense- Program - It details income and expenses allocated to specific programs for better financial tracking and analysis.
Transactions Report - A detailed GL Transaction Report grouped by Accounts.
Customer Standard Invoice - A standard invoice.
Invoice with Taxes at Bottom - Simple Invoice with taxes at the bottom.
Standard Receipt - A standard receipt.
Single Stub Receipt - A receipt with a single stub.
Vendor Standard Invoice - A standard invoice.
Standard Payment - A standard cheque.