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.
Commission - Simple Commission Report with options for Commission Percentage and whether to pay by Invoice Amount or Paid Amount.
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.
Cash Receipts Journal - A report that reviews received payments.
Customer Sales History - A report that reviews customer sales records.
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.
Departmental Income Statement - A departmental income statement.
Project Income Statement - A by-project income statement.
Trial Balance - A Trial Balance report with the option to create comparative Trial Balances.
Trial Balance by Department - A Trial Balance by Department report.
Detailed Cash Flow - 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.
Pivot Table Balance Sheet with Chart - A Balance Sheet with the option to create comparative Balance Sheets.
Departmental Balance Sheet - A Balance Sheet with columns for Departments.
Grouped Balance Sheet Example - A Balance Sheet with custom grouping of Accounts.
Mapped Balance Sheet Example - A Balance Sheet with custom grouping of Accounts, mapped for multiple companies.
Consolidated Balance Sheet - A Balance Sheet consolidating multiple companies on the same sheet.
Comparative Monthly Balance Sheets - Comparative Monthly Balance Sheets - This Year vs Last Year
Income Statement - A simple Income Statement.
Pivot Table Income Statement with Chart - An income statement with the option to create comparative income statements.
Pivot Table Comparative Income Statement- Unf - The Comparative Income Statement report summarizes and compares income and expenses over two or more specified periods for better financial analysis.
Departmental Income Statement - An Income Statement with columns for Departments.
Pivot Table Departmental Income Statement - A Pivot Income Statement report per Departments.
Grouped Income Statement Example - An Income Statement with custom grouping of Accounts.
Mapped Income Statement Example - An Income Statement with custom grouping of Accounts, mapped for multiple companies.
Income Statement by Projects - An Income Statement with columns for Projects.
2-Columns Income Statement by Projects - Income Statement on two columns with Projects as rows.
Annual Income Statement with Budget - Annual Income Statement - Actual vs Budget
Income Statement - Current Month - Actual vs Budget - Current Month, Current Month LY, YTD this Year
Detailed Cash Flow - Detailed Cash Flow report
Pivot Table Cash Flow - Summary and Detailed Cash Flow report.
Summary Cash Flow - Cash Flow Summary report
Trial Balance - Simple trial balance
Pivot Table Trial Balance with Chart - Regular trial balance
Pivot Table Comparative Trial Balance - Comparative Trial Balance report compares account balances across multiple periods to track changes and ensure accuracy in financial reporting.
Trial Balance by Department - Simple Trial Balance with a column for each Department
Trial Balance- 2 Departments Comparison - Compare the trial balances of two departments side-by-side to analyze financial performance and account details effectively.
Financial statements side-by-side - Financial statements side-by-side (balance sheet and income statement)
Ratios - A financial ratio report.
Dashboard - Comprehensive Dashboard
Detailed Cash Flow - Detailed Cash Flow report
Summary Cash Flow - Cash Flow Summary report
Sales Analysis - Sales analysis by Customers & Products
Inventory Analysis - Inventory Analysis by Products & Customers
Customer Analysis - A report that reviews customer-related activity.
Product Analysis - A report that reviews product-related activity.
Purchase Analysis - A report that reviews purchase-related activity.
Gain or Loss - A report that shows the overall result of gains and losses.
Sales Analysis - A report that reviews sales-related activity.
Tax - A report that reviews tax-related activity.
Unallocated - A report that shows items not yet assigned.
Formatted Customer Aging - A customer receivable aging report.
Customer Aging - 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 List - Customer List with Revenues.
Invoice Log - List of Customer Invoices.
Customer Invoice Log - with Commission - A report that lists customer invoices along with calculated commission amounts based on specified criteria.
Product Income-Customer - Table of income by product and client.
Commissions by Percentage - A report that calculates commissions based on a specified percentage of invoice or payment amounts.
Customer Invoice Log - A detailed list of customer invoices, showing dates, amounts, and status for easy tracking.
Customer Profitability Summary - Shows each customer's quantity sold, revenue, cost of goods sold, profit, and margin.
Invoice Summary by Date - Shows a breakdown of invoices by year, month, and date, including amounts, sales tax, and totals.
Sales by Salesperson and Item - A summary of sales transactions showing item-wise performance by salesperson, including quantity sold, sales, cost, and profit.
Sales Item Summary - Shows a summary of items sold, including unit, count, quantity, and total amount.
Receipts by Payment Method - A report that summarizes receipts grouped by the payment methods used, such as cash, credit card, or check.
Formatted Vendor Aging - A vendor payable aging report.
Vendor Aging - Account Payable aging with currency and more
Vendor Aging- Detailed and Summary - Displays outstanding payables categorized by aging periods, showing amounts owed to vendors.
Vendor List - Vendor List
Invoice Log - List of Vendor Invoices
Pivot Table Vendor Invoice Log - List of Vendor Invoices
Vendor List by Department - Vendor List by Department
Pending Goods Received - Lists of pending goods received.
Pending Orders - Shows purchase orders that are still open or partially fulfilled.
Vendor Invoice Log- with Items - Tracks vendor invoices along with detailed item information.
Vendor Purchases by items - Summarizes items purchased, grouped by vendor and item.
Sales Analysis - Sales analysis by Customers & Products
Inventory Analysis - Inventory Analysis by Products & Customers
Physical Count Worksheet - Inventory Worksheet with Count & Values
Inventory List - List of Inventory Items; Qty on Hand
Fifo Costing - FIFO Costing Report tracks inventory's average costs, remaining quantities, and values.
Vacation Payable - Vacation payable for chosen date.
Detailed Employee Payroll - Comprehensive breakdown of employee earnings, deductions, and net pay for a specified payroll period.
Deductions and Expenses - The Employees Payroll Deductions and Expenses Report details all payroll deductions and employee-related expenses.
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.
Project List - Project List
Project Budget by Period - A report that tracks and compares budget allocations and expenditures across specified time periods.
Pivot Table Revenue and Expense by Project - The Revenue and Expense by Project report details income and expenses allocated to specific projects for better financial tracking and analysis.
Income Statement by Projects - An Income Statement with columns for Projects.
2-Columns Income Statement by Projects - Income Statement on two columns with Projects as rows.
Chart of Accounts - Chart of Accounts with Type, GIFI,Class...
Inventory List - List of Inventory Items & Qty on Hand
Customer Invoice Log - List of Customer Invoices
Customer List - Customer List with Revenues
Project List - Displays a detailed list of all projects.
Vendor List - A comprehensive list of vendors with relevant details for reference.
Vendor List by Department - A list of vendors categorized by department.
Cheque Log - The report tracks all issued cheques, detailing amounts, dates, and recipients for financial record-keeping.
Transaction List - A report is a detailed record within a specified period, showing the date, account, and amounts involved.
Bank Transactions - A report details all transactions made through a bank account, including deposits, withdrawals, and transfers.
Income Statement by Funds - An Income Statement with columns for Funds.
Fund Income Statement - An Income Statement with columns for Funds.
Departmental Income Statement - An Income Statement with columns for Departments.
Transactions Report - A detailed GL Transaction Report grouped by Accounts.
Revenue and Expense by Fund - The Revenue and Expense by Funds report details income and expenses allocated to specific fonds for better financial tracking and analysis.
Fond Budget by Period - A report that tracks and compares budget allocations and expenditures across specified time periods.
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.