Report Library Downloads
Attention Excel 2007 Users
Click on the link below for a document on how to save a workbook as a Macro-Enabled Workbook.
Excel 2007 Save Directions
-
OGSQL Programmer API
Download Queries -
OGSQLai.xla Excel Add In
The SQL Excel Reports depend on an Excel Add-In named OGSQLai.xla. This file must be in the same folder as the individual reports for the reports to work properly. Once downloaded, OGSQLai.xla is configured using macros available in any SQL Excel Reports. (Caution: Sometimes the OGSQLai.xla file is renamed as OGSQLai.xls during the download process. Be sure to rename the file to OGSQLai.xla when the download is completed.)
Download OGSQLai.xla Excel Add In
SQL Reports
-
1099 Proof Report
Download 1099 Proof ReportThe 1099 Proof Report is a By Well / By owner report of 1099 fields. It will print a breakdown for each well by production month for gross amounts, taxes, and net amounts.
Download instructions -
1st AFE Report
Download 1st AFE ReportThe AFE report will display Authorization for Expenditures within the database displayed by line formats currently set up in the database. These can be filtered by completion date or close date if needed (not required).1
Download instructions -
2nd AFE Report
Download 2nd AFE ReportThis report requires that the database have the AFE module active. AFE’s must be used during data entry for the report to show any detail. The Line Format Maintenance in OGSYS will be utilized for formatting the columns of the report.
Download instructions -
AFE Report - Property Format
Download AFE Report - Property FormatThis is an AFE report that relies on the Property format codes setup in OGSYS.
Download instructions -
AP Report
Download AP ReportThe AP Report allows users to view Accounts Payable data that resides in the SQL reporting database.
Download instructions -
AR Report
Download AR ReportThe accounts receivable report is designed to provide an aged receivable report with drill down capabilities.
Download instructions -
Expense Deck Report
Download Expense Deck ReportThe expense deck report will display a list of detail lines of all expense decks for all companies within the database. It will display the Company Code, Property #, Description, Expense deck code and the Working Interest decimal amount.
Download instructions -
GL 210 Report
Download GL 210 ReportThe GL 210 Report is designed to model the OGSYS 210 report for use with the SQL database. This report supports the multi-currency option. The summary page supports drill down to Entity page on appropriate accounts. The summary page and Entity page support drill down to a Detail page.
Download instructions -
Joint Audit Data Exchange (JADE) Report
Download Joint Audit Data Exchange (JADE) ReportThis report includes graphical entity and account selections. Please note that the column descriptions in this report are an artifact of the original client driven specification. The report is based solely on the General Ledger module in OGSYS.
Download instructions -
Lease Operating Expenses (LOE) Report
Download Lease Operating Expenses (LOE) ReportThis report is designed to utilize the Line formats setup in OGSYS with Drilldown capability. This allows you to define the vertical format of the report using the power of OGSYS Report Writer, while capitalizing on the speed and drill down capability of SQL.
Download instructions -
Lease Operating Statement (LOS) Comparison – Current vs Prior Year Report
Download Lease Operating Statement (LOS) Comparison – Current vs Prior Year ReportThis report is a Lease Operating Statement comparing Current Year information to prior year information. It utilizes the OGSYS Line Format setup prior to exporting to SQL.
Download instructions -
Multi-Company Trial Balance Report
Download Multi-Company Trial Balance ReportThis multi-company Trial balance with Drill Down capability allows the user to view cross company information. This report can be run for multiple companies or a single company.
Download instructions -
Multi-Currency Trial Balance Report
Download Multi-Currency Trial Balance ReportA standard Trial Balance with the functional currency values and their historical equivalents in separate columns. This report requires that the Multicurrency option be turned on and in use.
Download instructions -
Property vs GL Comparison Report
Download Property vs GL Comparison ReportThe Property vs. GL report will compare the Property Sub Ledger to the General Ledger account totals. This can be done for one account or a range of accounts for a specific range of dates. This will help the user find out-of-balance issues within the data.
Download instructions -
Purchaser Report
Download Purchaser ReportThe purchaser report displays a complete list of all purchasers in the database. This report does not have any options, so when you run the macro it will display the report.
Download instructions -
Revenue Check Report
Download Revenue Check ReportThe Revenue Check report will display a list of revenue checks paid. When the report is run, an option box will display. This will allow the user to select what revenue checks will be displayed on the report.
Download instructions -
Revenue Deck Report
Download Revenue Deck ReportThe Revenue deck report will display a list of detail lines of all Revenue data that has been exported from
OGWIN or OGSQL into a SQL Server Database. It will display the Company Code, Property #, Description,
Revenue deck code and the Working Interest decimal amount.
Download instructions -
Schema Generation Utility
Download Schema Generation UtilityThis report will examine your OGSQL database and create a report listing tables and columns with descriptions. It is an invaluable tool for understanding your data.
Download instructions -
Vendor Report
Download Vendor ReportThe vendor report displays a complete list of all vendors in the database. The report does not have any options, so when you run the macro it will display the report.
Download instructions -
Well Report
Download Well ReportThis report will display a list of wells within the database. There are no options for this report. When the macro is run, the report will display. It will show the Well Code, Well name, Legal Description, State, County, Operating group, Field and all well comments.
Download instructions
