Introducing eSheets

Excel Spreadsheet Reporting for Oracle E-Business Suite Financials

Such Finance Systems was born out of the frustration with the limitations of Oracle Standard Reporting. The desire was to unlock the potential of these reports using the power of Microsoft Excel but without compromising the data integrity provided by Oracle.

We have more than 40 years of experience in using, implementing, and supporting Oracle EBusiness Suite solutions across Europe, North America, and Asia/Australasia.

Advantages

Speeds up business process

Users do not have to spend time converting output into a usable format. Output can be integrated seamlessly with other MI Reporting in Excel

Reduces expense

Minimises the need for expensive Custom/BI Reporting. Shortens timelines during Upgrade or Implementation

Data is supported by Oracle

The data is created by the seeded Oracle Reports and therefore fully supported by Oracle

Report layouts

eSheets output splits different layers of data over multiple Excel Worksheets allowing end users to easily analyse the level they require.

No additional Oracle Licensing

eSheets has no additional Oracle E-Business Suite Licensing costs

Unlocks potential of Seeded Reports

Oracle EBS Reports are often unused as their output cannot be easily interpreted. eSheets unlocks this potential using the power of Excel.

Technical

Compatible with MS Excel

eSheets adds a layer of business intelligence to the data and opens in all versions of Microsoft Excel

Compatible with Oracle R12

Works with all versions of Oracle E-Business Suite Release 12. eSheets reports are accessed through using the Concurrent Request Output Button

Faster publishing

eSheets Excel based output publishes faster than the equivalent RTF based Oracle Standard Report output.

The Problem

Oracle EBS includes a full suite of standard reporting across all modules. These reports can produce large output files which are usually presented in .txt, .rtf, or .pdf output. The problem with these types of output are as follows:

  • Unable to sort analyse or drill down
  • Difficult to integrate the results
  • Different levels of information displayed on the same page
  • Report width is fixed causing headings & data to be wrapped
problem
  • The Problem

    • The eSheets Solution

    eSheets uses the existing standard reports for generating the data and produces the results in Excel. Oracle end-users can then use the power of Excel to enhance productivity and perform complex data analysis tasks which have not previously been possible.

    • Data can easily be manipulated using the power of Excel
    • eSheets output is ready to be integrated with other MI Reporting
    • Multiple layers of data over multiple worksheets
    • Data columns are always consistent and sized according to data
    asset-register-report2
  • The eSheets Solution

    • The Reports

    The reports produced cover the most commonly used and useful reports across the Core Oracle EBS Financials Modules. Many business processes especially around closing ledgers rely on standard reports which through eSheets are now displayed in Excel.

    • Over 130 of the most commonly used standard reports available
    • Covers the 10 most commonly used Financials Modules
    • Continually expanding list of reports
    • Clients can suggest additional standard reports
    report
  • The Reports

      • Report Features

      Excel Formatting Features Already Embedded Into eSheets Reports

      screen-a-new

      • Headings displayed in bold and panes are frozen

      • Data can easily be manipulated using the power of Excel

      • Data columns are always consistent and sized according to data

      • Parameters and different Data Sets displayed on separate worksheets

      • Existing controls provided by Key Flexfield Security, MOAC, and Segregation of Duties are preserved using the eSheets product

      screen-b-new

      • Negative financial values are highlighted in Red

      • Separate layers of data split over multiple worksheets

      • Reports can be opened in any version of Microsoft Excel

      • Numbers are displayed in number format compatible with formulas

      • Sheets processing is performed and contained within your Oracle EBS Instance so data is never exposed outside of your firewall

      eSheets Reports

      eSheets come with a comprehensive and constantly updated suite of reports

      General Ledger

      • Account Analysis – (132 Char)
      • Account Analysis – (180 Char)
      • General Ledger – (132 Char)
      • General Ledger – (180 Char)
      • Journals – (132 Char)
      • Journals – (180 Char)
      • Journals – Document Number
      • Journals – Entered Currency (132 Char)
      • Journals – Entered Currency (180 Char)
      • Journals – Entry
      • Trial Balance
      • Trial Balance – Additional Segment Detail
      • Trial Balance – Budget
      • Trial Balance – Detail
      • Trial Balance – Expanded

      Accounts Payable

      • Accounts Payable Trial Balance
      • Bank Account Listing
      • Cash Requirement Report
      • Employee Listing
      • Invoice Aging Report
      • Invoice Audit Listing
      • Invoice Audit Report
      • Invoice On Hold Report
      • Invoice Register
      • Matching Hold Detail Report
      • Payables Lookup Listing
      • Payment Terms Listing
      • Scheduled Payment Selection Report
      • Supplier Audit Report
      • Supplier Paid Invoice History
      • Supplier Payment History
      • Suppliers Report
      • Unaccounted Transactions Report (XML)

      Accounts Receivable

      • Account Status Report
      • Adjustment Approval Report
      • Aging – 7 Buckets Report
      • Aging – 4 Buckets Report
      • Aging – 7 Buckets – By Account Report
      • Aging – 7 Buckets – By Collector Report
      • Aging – 7 Buckets – By Salesperson/Agent Report
      • AR to GL Reconciliation Report
      • Customer Listing – Detail
      • Customer Listing – Summary
      • Customer Relationships Listing
      • Ordering and Grouping Rules Listing
      • Payment Terms Listing
      • Sales Journal by GL Account Report (XML)
      • Transaction Detail Report
      • Transaction Types Listing
      • Unposted Items Report

      Cash Management

      • AutoReconciliation Execution Report
      • Bank Account Balance Actual vs Projected Report
      • Bank Account Balance Range Day Report
      • Bank Account Balance Single Date Report
      • Bank Statement Detail Report
      • Bank Statement Summary Report
      • Bank Transaction Codes Listing
      • Cash Forecast Report
      • Cash In Transit Report
      • Cleared Transactions Report
      • General Ledger Reconciliation Report
      • Transactions Available for Reconciliation Report

      Purchasing

      • Blanket and Planned PO Status Report
      • Blanket and Planned PO Status Report (XML)
      • Buyer’s Requisition Action Required Report
      • Buyer’s Requisition Action Required Report (XML)
      • Expected Receipts Report
      • Expected Receipts Report (XML)
      • Financials/Purchasing Options Listing
      • Financials/Purchasing Options Listing (XML)
      • Invoice Price Variance Report
      • Item Detail Listing
      • Item Detail Listing (XML)
      • Location Listing
      • Location Listing (XML)
      • Matching Holds Report by Buyer Report
      • Matching Holds Report by Buyer Report (XML)
      • Open Purchase Orders Report(by Buyer)
      • Open Purchase Orders Report(by Buyer) (XML)
      • Open Purchase Orders Report(by Cost Center)
      • Open Purchase Orders Report(by Cost Center) (XML)
      • Purchase Order and Releases Detail Report
      • Purchase Order and Releases Detail Report (XML)
      • Purchase Order Detail Report
      • Purchase Order Detail Report (XML)
      • Receiving Transactions Register
      • Receiving Transactions Register (XML)
      • Uninvoiced Receipts Report

      Fixed Assets

      • Account Reconciliation Reserve Ledger
      • Additions by Source Report
      • Asset Additions Report
      • Asset Category Listing
      • Asset Description Listing
      • Asset Inventory Report
      • Asset Reclassification Reconciliation Report
      • Asset Register Report
      • Asset Retirements Report
      • Asset Transfers Report
      • Assets By Category Report
      • Calendar Listing
      • CIP Assets Report
      • CIP Capitalization Report
      • CIP Detail Report
      • CIP Summary Report
      • Cost Adjustments Report
      • Cost Detail Report
      • Cost Summary Report
      • Mass Additions Create Report
      • Mass Additions Delete Report
      • Mass Additions Posting Report
      • Mass Additions Status Report
      • Reserve Detail Report
      • Reserve Summary Report
      • Tax Retirements Report
      • Transaction History Report
      • Unposted Mass Additions Report

      Payments

      • Payment Instruction Register
      • Payment Process Request Status Report

      Subledger Accounting

      • Account Analysis Report
      • Journal Entries Report
      • Open Account Balances Listing
      • Subledger Period Close Exceptions Report

      E-Business Tax

      • Tax audit trail report
      • Tax Exempt Customer Report

      System Administration

      • Active Responsibilities and Users
      • Active Users
      • Completed Concurrent Requests Report
      • Concurrent Programs Report
      • Cross-Validation Rules Listing
      • Function Security Menu Report
      • Report Group Responsibilities
      • Signon Audit Concurrent Requests
      • Signon Audit Forms
      • Signon Audit Responsibilities
      • Signon Audit Users
      • User Profile Option Values
      • Users of a Responsibility

      Contact

      To arrange a demo or to contact us for more information about eSheets, please enter your details in the enquiry form and we’ll be in touch.

      such-logo

      eSheets - Excel Spreadsheet Reporting for Oracle EBS Financials

      +44 (0)113 323 5773
      info@suchfinance.co.uk