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.
Choose your Sage 50 edition
U.S. Edition reports
Trial BalanceStandard Trial Balance.
Balance SheetStandard Balance Sheet.
Balance Sheet- 12 Periods FiscalA Balance Sheet report displaying financial data across 12 months of the fiscal year for a comprehensive overview.
Comparative Balance SheetMonthly, Quarterly and Yearly Comparative Balance Sheets.
Income StatementStandard Income Statement.
Income Statement- 12 PeriodsThe 12-Period Income Statement provides a monthly breakdown of income and expenses over the past 12 periods for financial performance tracking.
Comparative Income StatementMonthly, Quarterly, and Yearly Comparative Income Statements.
Income Statement with BudgetsIncome Statement with Budget and Variance.
Budget ReportA report showing only the budgeted income and expenses for a selected period.
Cash FlowCash Flow Statement.
Cash Flow-EnhancedA cash flow report displaying both debit and credit transactions for each line.
General LedgerGeneral Ledger Report.
Trial BalanceStandard Trial Balance.
Balance SheetStandard Balance Sheet.
Income StatementStandard Income Statement.
Income Statement with BudgetsIncome Statement with Budget and Variance.
Aged ReceivableCustomers with Aging Invoice, including Payment Transactions.
Cash Receipts JournalA report that reviews received payments.
CommissionSimple Commission Report with options for Commission Percentage and whether to pay by Invoice Amount or Paid Amount.
Customer Management DetailCustomer report with invoice details and credit status.
Customer Sales HistoryGross Margin Report by Customer.
Invoice LogInvoice Log.
Invoice RegisterInvoice Register Report.
Item Sold to CustomersItems Sold by Customer Report.
Sales AnalysisQuantity, Average Unit Cost, Amount, and Gross Profit of Item Sales.
Sales JournalSales Journal Report.
SalesSample Sales Report.
Sales OrderSales Order Report.
Sales Order RegisterSales Order Register Report.
Sales and Outstanding BalancesA report that reviews sales and unpaid balances.
Sales Order JournalA report that reviews sales order activity.
Aged PayableVendors with Aging Invoice, including Payment Transactions.
Aged Payable- All transactionsA report that lists all payables, including fully paid invoices, organized by aging periods.
Vendor Invoice LogInvoice Log.
Purchase AnalysisTotal Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Purchase DashboardTotal Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Purchase JournalA report that details all purchase transactions, including dates, amounts, and account allocations, for accurate tracking and analysis.
Items Purchased by VendorsA report that reviews vendor-related purchases.
Proposal ReportA report that reviews proposals.
Quote RegisterA report that reviews quotes.
Vendor Purchase and OutstandingA report that reviews vendor purchases and balances.
Employee CompensationThe Employee Compensation Report provides an Overview of the Compensation and Benefits Awarded to Employees.
Payroll RegisterPayroll Register.
Payroll Check RegisterPayroll Checks.
Time Slip ReportA report that shows hours worked or time entries recorded.
Vacation and Sick TimeEmployees Vacation and Sick Time.
Inventory AnalysisItem Cost and Quantity Information for a Selected Date Range.
Inventory AgingThis report produces a number of metrics associated with Inventory Aging.
Inventory Assemblies on OrderInventory Assemblies Currently on Order.
Items Sold to Customers by LocationItems Sold to Customers organized by location, including a dashboard of Top Locations and Customers.
Inventory on Hand AnalysisInventory on Hand Analysis Report with Breakdown and Charts.
Inventory ProfitabilityInventory Profitability Report.
Inventory Stock StatusInventory Stock Status Report.
Item ListItem List.
Job LedgerLedger Report Grouped by Job.
Job ProfitabilityThis report helps analyze the profitability of jobs.
Job RegisterJob Register Report.
Job RetainageReceivable and Payable retainage on Jobs.
Unbilled Job ExpenseUnbilled Job Expense.
Customer Standard InvoiceA standard invoice.
Dashboard Analysis 1-0Graphical 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-1Item Cost and Quantity Information for a Selected Date Range.
Purchase Analysis 1-1Total Quantity and Amount of Items Purchased from Vendors for a Selected Date Range.
Sales Analysis 1-4Quantity, Average Unit Cost, Amount, and Gross Profit of Item Sales.
Canadian Edition reports
Balance SheetA Balance Sheet with the option to create comparative Balance Sheets.
Income StatementAn income statement with the option to create comparative income statements.
Income Statement- DepartmentalA departmental income statement.
Income Statement- ProjectA by-project income statement.
Trial BalanceA Trial Balance report with the option to create comparative Trial Balances.
Trial Balance- DepartmentalA Trial Balance by Department report.
Cash Flow- DetailedA detailed cash flow report with the option to create a comparative cash flow report.
Transactions ReportA detailed GL Transaction Report grouped by Accounts.
Balance SheetA simple Balance Sheet.
Balance Sheet- Comparative MonthlyComparative Monthly Balance Sheets - This Year vs Last Year
Balance Sheet- ConsolidatedA Balance Sheet consolidating multiple companies on the same sheet.
Balance Sheet- DepartmentalA Balance Sheet with columns for Departments.
Balance Sheet- GroupedA Balance Sheet with custom grouping of Accounts.
Balance Sheet- MappedA Balance Sheet with custom grouping of Accounts, mapped for multiple companies.
Balance Sheet- Pivot table with chartA Balance Sheet with the option to create comparative Balance Sheets.
Income StatementA simple Income Statement.
Income Statement vs BudgetAnnual Income Statement - Actual vs Budget
Income Statement- Actual vs BudgetCurrent Month, Current Month LY, YTD this Year
Income Statement- Comparative UnfThe 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 tableA Pivot Income Statement report per Departments.
Income Statement- GroupedAn Income Statement with custom grouping of Accounts.
Income Statement- MappedAn Income Statement with custom grouping of Accounts, mapped for multiple companies.
Income Statement- Pivot Table with ChartAn income statement with the option to create comparative income statements.
Income Statement- ProjectsAn Income Statement with columns for Projects.
Income Statement- Projects 2 columnsIncome Statement on two columns with Projects as rows.
Cash Flow- DetailedDetailed Cash Flow report
Cash Flow- Pivot TableSummary and Detailed Cash Flow report.
Cash Flow- SummaryCash Flow Summary report
Financial Statements- Side-by-SideFinancial statements side-by-side (balance sheet and income statement)
Trial BalanceSimple trial balance
Trial Balance- DepartmentalSimple Trial Balance with a column for each Department
Trial Balance- Departmental ComparisonCompare the trial balances of two departments side-by-side to analyze financial performance and account details effectively.
Trial Balance- Pivot Table ComparativeComparative Trial Balance report compares account balances across multiple periods to track changes and ensure accuracy in financial reporting.
Trial Balance- Pivot Table with ChartRegular trial balance
Customer AnalysisA report that reviews customer-related activity.
Sales AnalysisSales analysis by Customers & Products
Sales AnalysisA report that reviews sales-related activity.
Purchase AnalysisA report that reviews purchase-related activity.
Inventory AnalysisInventory Analysis by Products & Customers
Product AnalysisA report that reviews product-related activity.
Cash Flow- DetailedDetailed Cash Flow report
Cash Flow- SummaryCash Flow Summary report
DashboardComprehensive Dashboard
Gain or LossA report that shows the overall result of gains and losses.
RatiosA financial ratio report.
TaxA report that reviews tax-related activity.
UnallocatedA report that shows items not yet assigned.
Customer Aging- CurrencyAccount Receivable aging with currency and more.
Customer Aging- Detailed and SummaryShows outstanding receivables grouped by aging periods, tracking amounts due from customers.
Customer Aging- Formatted A customer receivable aging report.
Customer Invoice LogA detailed list of customer invoices, showing dates, amounts, and status for easy tracking.
Customer Invoice Log with CommissionA report that lists customer invoices along with calculated commission amounts based on specified criteria.
Customer Invoice Summary by DateShows a breakdown of invoices by year, month, and date, including amounts, sales tax, and totals.
Receipts by Payment MethodA report that summarizes receipts grouped by the payment methods used, such as cash, credit card, or check.
Sales Item SummaryShows a summary of items sold, including unit, count, quantity, and total amount.
Product Income- CustomerTable of income by product and client.
Customer ListCustomer List with Revenues.
Commissions by PercentageA report that calculates commissions based on a specified percentage of invoice or payment amounts.
Customer Profitability SummaryShows each customer's quantity sold, revenue, cost of goods sold, profit, and margin.
Sales by Salesperson and ItemA summary of sales transactions showing item-wise performance by salesperson, including quantity sold, sales, cost, and profit.
Vendor AgingAccount Payable aging with currency and more
Vendor Aging- FormattedA vendor payable aging report.
Vendor Aging- Detailed and SummaryDisplays outstanding payables categorized by aging periods, showing amounts owed to vendors.
Vendor ListVendor List
Vendor List- DepartmentalVendor List by Department
Vendor Invoice LogList of Vendor Invoices
Vendor Invoice Log- Pivot TableList of Vendor Invoices
Vendor Invoice Log- ItemsTracks vendor invoices along with detailed item information.
Goods Orders- PendingShows purchase orders that are still open or partially fulfilled.
Goods Purchases- ItemsSummarizes items purchased, grouped by vendor and item.
Goods Received- PendingLists of pending goods received.
Inventory ListList of Inventory Items; Qty on Hand
Inventory and Services ListShows all inventory items and services available in the system.
Inventory and Services SummarySummarizes quantities, sales, costs, and profits for all inventory items and services.
Inventory SummaryProvides an overview of total inventory levels and values.
Inventory AnalysisInventory Analysis by Products and Customers
Sales AnalysisSales analysis by Customers and Products
Pending Delivery Orders by ItemShows items that are yet to be delivered to customers.
Pending Goods Received- InventoryLists supplier orders that have not yet been received.
Items Sold by CustomersDisplays a list of items sold, grouped by customer.
Items Sold by LocationLists items sold organized by sales location or branch.
Fifo CostingFIFO Costing Report tracks inventory's average costs, remaining quantities, and values.
Physical Count WorksheetInventory Worksheet with Count and Values
Deductions and ExpensesThe Employees Payroll Deductions and Expenses Report details all payroll deductions and employee-related expenses.
Detailed Employee PayrollComprehensive breakdown of employee earnings, deductions, and net pay for a specified payroll period.
Employee CompensationA payroll report that shows each employee’s name, department, type, and gross pay for payroll tracking.
Payroll Check RegisterShows a list of all payroll issued, including employee names, reference, pay type, net pay, and dates.
Remittances- AgenciesA report showing payroll remittances made to CFF, Ministry of Finance, and other agencies.
Timesheets Daily SummaryShows a detailed or summarized list of hours worked by employees over a period of time.
Vacation PayableVacation payable for chosen date.
Income Statement by ProjectsAn Income Statement with columns for Projects.
Income Statement by Projects 2 columnsIncome Statement on two columns with Projects as rows.
Project Budget by PeriodA report that tracks and compares budget allocations and expenditures across specified time periods.
Project ListProject 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 TransactionsA report details all transactions made through a bank account, including deposits, withdrawals, and transfers.
Chart of AccountsChart of Accounts with Type, GIFI,Class...
Cheque LogThe report tracks all issued cheques, detailing amounts, dates, and recipients for financial record-keeping.
Customer ListCustomer List with Revenues
Customer Invoice LogList of Customer Invoices
Inventory ListList of Inventory Items & Qty on Hand
Project ListDisplays a detailed list of all projects.
Vendor ListA comprehensive list of vendors with relevant details for reference.
Vendor List- DepartmentalA list of vendors categorized by department.
Transaction ListA report is a detailed record within a specified period, showing the date, account, and amounts involved.
Income Statement- DepartmentalAn Income Statement with columns for Departments.
Income Statement- ProgramAn Income Statement with columns for Programs.
Income Statement- ProgramAn Income Statement with columns for Programs.
Program Budget by PeriodA report that tracks and compares budget allocations and expenditures across specified time periods.
Revenue and Expense- ProgramIt details income and expenses allocated to specific programs for better financial tracking and analysis.
Transactions ReportA detailed GL Transaction Report grouped by Accounts.
Customer Standard InvoiceA standard invoice.
Invoice with Taxes at BottomSimple Invoice with taxes at the bottom.
Standard ReceiptA standard receipt.
Single Stub ReceiptA receipt with a single stub.
Vendor Standard InvoiceA standard invoice.
Standard PaymentA standard cheque.