General Ledger Reporting Overview

The General Ledger (GL) reporting feature of insightsoftware's Spreadsheet Server converts familiar spreadsheet software, Microsoft Excel, to a tightly-integrated analytical tool for financial systems. Spreadsheet Server uses specific formulas to retrieve General Ledger data in the spreadsheet, and gives the user the ability to drill down to detail.

Features

• Retrieve dynamic balances based on ledger-specific formats and time periods (for example, Period, Quarter, Year-to-Date, etc.).
• Retrieve balances using single value, mask, range, value list, segment list, hierarchy value, or @ field.
• Drill down to detailed account balances.
• Drill down to journal detail for selected accounts.
• Drill down to journal lines for a selected journal entry.
• Drill down to subsystem detail for a selected journal entry.
• Copy drill down data and paste into spreadsheets or other documents.

Important: Available features vary based on the selected ledger being processed.

Benefits

• Leverage spreadsheet skills and write reports within minutes.
• Eliminate the requirement for IT or super-users to create or change financial reports.
• No more downloading or rekeying of spreadsheet data.
• Reduce the number of days to close financial books; saving just three hours per month per user will fully pay for the investment in less than 12 months.
• Publish executive-quality reports from current spreadsheet software.
• Increase the efficiency and timeliness of the budgeting process.
• Build a complete Executive Information System.
• Create ad hoc reports or perform account analysis within minutes.
• Save financial user's time by combining reporting, account inquiry, and journal inquiry into one application; free up time for true business analysis.
• Perform corporate consolidations with instant access to dynamic data.
• Reduce external audit time by allowing easier, instant access to financial data with full drill down capabilities.
• Reconcile accounts.
• Print or email spreadsheets quickly and easily from a single, central application.