http://www.ogsys.com/index.php en barbara@ogsys.com Copyright 2007 2007-12-02T03:14:00-06:00 http://www.ogsys.com/site/1099_tips_and_news/ http://www.ogsys.com/site/1099_tips_and_news/#When:03:14:00Z Download newsletter Tips and News Always review all 1099 instructions and publications from the IRS before filing Download 1099 updates for OGwin versions 1.80, 2.0, and 2.1 from our website http://www.ogsys.com. Then, apply the updates to your database. To receive 1099 changes, you must upgrade to at least version 1.80. Consider filing 1099s electronically through the IRS website http://file.irs.gov DBA 1099 The DBA 1099 field in Vendor and Owner Maintenance has been modified. Anything entered in the DBA 1099 field will be used as the name on all 1099 processes with the name field printed below it. Example Vendor Maintenance: Name: Joe’s Wreckers DBA 1099: Joe Smith Printed on 1099s as Joe Smith dba Joe’s Wreckers This allows you to use the name by which you know the company for search purposes and check printing, but have the 1099s use the name associated with the federal id. If the DBA 1099 field is left blank, the name field in the Vendor or Owner Maintenance will be used for 1099s. Hottest FAQ about 1099s Q: What’s the difference between “Print Non-qualifying Amounts?” and “Print Non-flagged Vendors?” on the Vendor 1099 Proof Report? A: Printing all “non-qualifying amounts” will print all amounts . . . regardless of the minimum you have set on the 1099 run. Printing “Non-flagged vendors” will print all vendors . . . regardless of the flag in the master file for “Send-1099:” Q: What if I void a 2007 check in 2008, after I have already sent out 1099s? A: When the 2007 check was voided, OGSYS updated the 1099 file for 2007, which you will not see unless you decide to re-run your 2007 1099s. What happens in 2008 depends on whether you re-issue the check. If you issue it with a 2008 date, OGSYS will update the 1099 file for 2008, so that the amount is reported for 2008. If this is not the desired result, you can adjust the 1099 amount using the adjustment entry screens. Q: When I start to close January 2008 for Revenue, OGSYS indicates it will purge prior year’s 1099 information. Does this mean for 2007? A: Yes. OGSYS purges the prior year’s 1099 information with the January Revenue Close. Make sure you have a year-end backup before proceeding. Q: Does the system allow me to print 1099s more than once? A: Yes. You may print 1099s repeatedly until the information is purged. OGSYS does not purge 1099 information until the 1099s have been printed after the December month has been closed for that module. Q: OGSYS says I didn’t print 1099s for last year, but I did. What does this mean? A: Run the December close prior to the final 1099 run. If 1099s are run prior to the December close (not after), OGSYS does not recognize the 1099 run as an “official” run. Therefore, it does not purge the information for that year and could blend it into the next year. Q: Can I run electronic 1099s more than once? A: Yes. You may generate electronic 1099s as many times as necessary until the information is purged. Make sure you generate 1099 information to an electronic file before closing January for the module. Q: Which address box do I use for 1099s? A: 1099 forms take the address from the default screen of the master file record. Electronic and substitute 1099 forms also take the address from the first screen. Q: How do I get Vendor 1099s to print in the “Rentals” box? A: By default, Vendor 1099s print in Box 7 (the non-employee compensation box). However, it is possible to choose the payment type, and therefore the box for a vendor’s 1099 amount. Vendor maintenance allows you to choose from the following payment types: 1 – Rents, 2 – Royalties, 3 – Other Income, 6 – Medical Payments, 7 – Non-employee Compensation, and 14 – Gross Attorney Fees. Q: What are substitute 1099s? A: The IRS gives you the option to send substitute 1099 rather than the standard 1099 for Owners/Vendors. If you file electronically, the substitute form is the way to go. Send the electronic file to the IRS, then print substitute 1099s to send to the Owners/Vendors. A side benefit is, you don’t have to buy the standard 1099 forms. NOTE: Do not send substitute forms to the IRS. You will be charged a penalty fee for filing incorrectly. Q: The 1099s for electronic ask the question, “Prior Filing Year?” Does this mean I can run 1099s for 2006? A: Under normal processing, you would not be able to print 1099s for 2006 now, since that information was purged in January 2007. This field is part of the record layout for electronic 1099s, so it must be included here. To answer “Yes” in this field, you would have to take extra steps to ensure that the data is available. Q: May I select and sort by vendor/owner codes for 1099s? A: Yes. You have entity selecting and sorting capabilities for all 1099 processes. Q: I need a list of all the vendors/owners with no federal ID. How do I get it? A: You may select and sort by a federal ID number any place where you have entity selection capabilities, including all the 1099 processes and entity listings. When you sort by federal ID, it places all vendors/owners without an ID at the beginning of the report. The federal ID also prints on the brief entity listing. A Timely Refresher — 1099 Procedures 1099s and 1099 balances are integral parts of OGSYS. Enter balances only during installation, as OGSYS maintains 1099 information automatically. OGSYS provides 1099 updates as a normal part of the support services. The system supports 1099 forms, electronic 1099 reporting, and substitute 1099 forms. Make sure you have loaded the latest release (either 1.8, 2.0, 2.1 or 2.2) and service pack for current 1099 programs. Remember, the IRS will not return problem files. Keep a copy of the 1099 files you submit to the IRS. Five Rules for Processing 1099s 1. Always run an Accounts Payable Close Month for December before printing Vendor 1099s for a year. Always run a Revenue Close Month for December before printing Owner 1099s for a year. Always run a Lease Records Close Month for December before printing Land-Owner 1099s for a year. You may print the 1099 Proof Reports at any time during the year. 2. Print the 1099 Proof Report to verify 1099 amounts and which entities should receive a 1099. 3. You may adjust 1099 amounts. For vendor 1099 adjustments use the Vendor 1099-History Entry function from the Vendor History/1099s Menu. OGSYS will display a screen showing the check detail total and the 1099-history amount. The sum of these two figures is equal to the amount that will be printed on the 1099 form. To make adjustments to a Vendor’s 1099 amount, increase or decrease the 1099-history amount as needed. This is a replacement amount, and it will be added to the check detail total to give you the actual 1099 amount. For Owner 1099 adjustments, use the 1099 Adjustment Entry function from the Owner 1099s/Balances menu. Enter adjustments as replacement amounts in the appropriate fields. For Land-Owner 1099 adjustments, use the Land-owner 1099-History Entry screen on the Lease-records Maintenance menu. Enter the adjustment as a replacement amount in the appropriate field. 4. Always verify 1099 amounts for at least one vendor/owner prior to mailing 1099s. 5. If December Close Month is not run prior to printing 1099s, subsequent years’ 1099s will include amounts from the prior year. To correct, reprint 1099s for the prior year, and run the module Close Month for December of the current year. NOTE: OGSYS includes items netted within the current 1099 calendar year in that year’s 1099 amounts. Therefore, do not run the cross-clear program using a December voucher date, unless the items being netted are to be included in the current year’s 1099s. Items to be included in the next year’s 1099 must have a January-or-later voucher date. Substitute 1099s are available for Vendor 1099s, Owner Royalty 1099s and Land-owner 1099s. Use these substitute forms to mail to the Vendors/Owners. These forms are not intended for the IRS. You will see Substitute 1099s in each respective 1099s menu. Waltz through Year-end with Fewer Problems Make a year-end backup before closing the General Ledger Most important—include ALL OGwin files; data, programs, and control files. By copying all of OGwin, you are ensuring that you can restore the database for that time period, if necessary. Retain this backup permanently, do not overwrite with a later backup. NOTE: If only the data files are backed up and your current database has been upgraded with a release, you will not be able to use the year-end backup. The year-end General Ledger Close performs some extra step The close routine will take the balances in the Profit and Loss (P & L) accounts and zero them into the Retained Earnings account for corporations, and into the Capital account for partnerships. Because of this, it is important to make sure your Fixed Account Maintenance is set up accurately. Make certain the first P & L account is specified correctly. The system will take every account from the first P & L account forward and zero it to Retained Earnings. Also, make sure the Retained Earnings or Capital account is coded correctly in the fixed accounts. DO NOT close the General Ledger for the year without having the first P & L, Retained Earnings, and Capital accounts coded correctly. Otherwise, you will not be able to correct the incorrect balances by re-closing the year for the P & L accounts without restoring your database. The year-end General Ledger may be re-closed, however, for any adjusting entries that are posted in the new year. Operator Online 2007-12-02T03:14:00-06:00 http://www.ogsys.com/site/ogsql_advances_to_alpha_testing/ http://www.ogsys.com/site/ogsql_advances_to_alpha_testing/#When:02:15:00Z Download newsletter In early September, OGSYS R&D personnel completed the developmental phase of the native OGsql base system. Subsequently, several volunteer clients began working with us to alpha test the base system, and we hope to complete alpha testing by mid-October. Here are our objectives in alpha testing – • To process as many transactions as possible • To exercise every possible program in OGsql • To test OGsql for specific user-defined job functions The flow diagram below shows the steps involved in the alpha test. We will begin beta testing as soon as the alpha phase is complete in mid October 2007. In the beta phase, selected volunteer clients will go live on the native OGsql base system in their production environments. These clients on beta OGsql will have priority access to our support staff. Our plan is to complete the OGsql base-system beta testing in December 2007. During the months of testing of the base system, we will continue development of the Land and Fixed Assets programs. We plan alpha testing Land Management in early November and alpha testing Fixed Assets in late November. We will complete beta testing of both programs by late January 2008. We will complete OGsql development for all other programs in early 2008. If you would like a periodic status report via email, contact the Manager of Operations, Barbara Schweitzer (). Want to Help Test OGsql? If your company has an interest in participating in the alpha or beta testing program, contact Chuck Blanton () or Jody Vasquez () for more information. New Tool to Track Changes to Decks and Other Data When you save a deck in OGwin 2.0 or later, you may have noticed a new popup screen—“Change Control.” OGwin links this popup to the new Disbursement Change History report found under the Exceptional Processing menu. We designed this report to track changes to decks and—optionally—to other data items that have a bearing on cash disbursements. The feature records every deck creation or saved change in the report . . . along with a change control number, user ID, station ID, date and time. If you want a record of changes to additional items like vendors, owners, lease financials, you may activate Option 203. Recording changes to decks reinforces program security, and enhances the way that deck changes are integrated into normal processing and posting. Your decks can continue working essentially as they always have. Previously, an entry program – such as AP invoice entry – would select a deck. Changes to that deck were then locked until you posted the AP invoice voucher. OGwin 2.0 does not lock the deck. Instead, the program provides Option 204 (default-freeze), so that deck selection in AP invoice entry pins that invoice to use that specific version of the deck . . . even if you change the deck (same effective date) prior to final posting. OGwin can now reconstruct archived versions of a deck using the change control number for pinning. Leave off Option 204, and the deck selection floats to use the version of the deck that is on file at the time of posting (same effective date). With 2.0, the system allows floating so long as the total company interest in the deck has not changed since entry. If you violate that restriction, the system rejects the posting, and you must alter the AP invoice entry with a reselection of a deck. The new Change Control popup screen allows the user to enter a description that streamlines deck selection from archived decks. The deck scan process is now a two-level scan. The first level is the same as always – the current version of each effective date shown. If you want an archived version of a deck, a drill down to archived decks is available. On the deck scan screen, you may specify that you want to place a freeze on the deck all the way through posting. The new version enhances modeling in AP invoice entry, manual journal entry, and purchaser check entry. This enhancement enables you to use the same deck from the original entry (even if archived) or to float the new voucher to use the most recent deck version. Option 205 sets the default to use the same pinned deck when modeling. Option 206 sets the default to use the same pinned deck when modeling and reversing. You may override either default on the model selection screen. The Disbursement Change History Report affords various filters and time period selection. The report contains separate sections for expense decks, revenue decks, owners, etc. It also provides a continuity section to prove that the change history itself has not been altered. Redistribute Netted Items You may now redistribute netted items, using Revenue Redistribution. See The Operator, July 2007 for detailed information on the revenue redistribution application. Upload CDEX Go to our website—www.ogsys.com—for instructions for the CDEX upload and a formatted Excel spreadsheet. Look for it under “Support / Upload Tools.” Use Adjustment Entry to Adjust an Owner’s AR Make adjustments to an owner’s accounts receivable by using the Adjustment Entry application found on the Accounts Receivable Processing menu. Make the adjustments by owner to individual invoices. OGwin assumes a debit to the Accounts Receivable fixed account, and therefore prompts for the credit account to be entered. If you are entering a credit to the A/R account, the adjustment amount will be a negative number. The credit account may be the cash account if you are reimbursing an owner for an overpayment. It may be an expense account if you are reversing a billing error, or it may be any other account that requires an adjustment. Warning: Do not make the credit account the AR fixed account. This will result in a zero effect to that account in the General Ledger with a real effect to the A/R subledger – which means that they would not balance. With invoice selection, you may adjust paid or unpaid invoices or create a new invoice – • Simply select the invoices by well, or leave the well field blank to view all invoices for the owner, regardless of well • Click the file tab “AR invoices” to see the list of invoices • Highlight the invoice to be adjusted • Click the Change button or just double-click the invoice line to enter the adjustment amount • Save the line • Once all invoice adjustments for the owner have been made, save the voucher • Respond “Yes” to the prompt “OK to post adjustments?” to post the entry to accounts receivable and the general ledger Operator Online 2007-10-02T02:15:00-06:00 http://www.ogsys.com/site/ogsys_options_custom_programming_that_may_fit_your_needs/ http://www.ogsys.com/site/ogsys_options_custom_programming_that_may_fit_your_needs/#When:02:46:34Z Download newsletter Throughout our 25-year history, many clients have requested custom programming. When we reprogram OGSYS, we make all changes available to our client base. You see many of them in our regular system updates. When a custom programming request is more specific, we assign it an option number to make it available to all clients. Options fall into two categories: (1) formatting and (2) extra cost functions. You may directly manage some formatting options — like JIB formats — through Site File Utility on the Supervisor menu. Activation of some formatting options requires a file from OGSYS support. Extra-cost options include OGwin add-on modules, such as Lease Records, Production, Fixed Assets, and Inventory. Subledger upload functions, such as CDEX and AP Invoice upload (as well as some additional reporting capabilities like Net Distribution reports and the OGsql reporting module), also are extra-cost options. To receive an updated options list, please email . Whenever you make changes to the Site File Utility, email OGSYS support including your company name and the option you turned on or off. This will prevent the loss of the option setting when future releases are loaded against OGwin. OGwin ‘Loaded’ with Upload Tools Take advantage of OGwin’s many built-in upload capabilities. You may upload a journal entry, an AP invoice, budgets, and many more items. OGwin requires a certain layout for the upload files. Therefore, we have recently created Excel macros for various system uploads. You will find these macros and related instruction documents on our Upload Tools page. Right-click on a specific spreadsheet and save it to your system. Do not enter your data directly into the spreadsheet on our website. OGwin 2.0 – New Opportunities in Revenue Redistribution OGwin allows the redistribution of revenue from one owner to another or from one owner to a company (not from a company to an owner.) With the new 2.0 version, you will see some changes to the Revenue Redistribution program. You also may redistribute revenue by creating temporary decks with the new and old owners and posting negative revenue amounts to one deck and positive amounts to the other. Revenue Redistribution works only between outside owners. OGwin will not allow use of Revenue Redistribution to reduce a company’s share of revenue. OGwin will not allow redistribution in cases when an owner has been netted or had a partial payment made against the revenue you wish to redistribute. Use the Unpaid History entry to make this change. Call OGSYS Support for procedures if netting has been done. To redistribute an owner’s revenue: Select NEW [F3 key] for a new voucher number. OGwin 2.0 introduced the use of a voucher number with redistribution. Enter the owner code. Complete the Revenue Selection window for the redistributed items. (You may filter the items to be redistributed by well, product, deck, production month ranges, voucher, interest type and payment type.) Then click RETRIEVE The Selected Revenue Items tab will show all items to be redistributed. Use the Del Line button to delete individual lines that you do NOT want to be redistributed. OGwin will display the total amount to be redistributed as “Total Payable.” To create a reversing entry in a memo company for each line to be redistributed (not just the lines with an entry in the MemoAlso column), enter a company code in Memo Comp. If a revenue item was associated with a memo company at the time of posting, that memo company code will be reflected in the MemoAlso column. The Memo Comp replaces that MemoAlso code for those revenue items. Specify one or more owners or companies to receive the redistribution of the revenue item(s) being selected. Click the Target Entities tab to enter the owners and/or companies to receive the redistribution. Click Add Line. Enter the owner or company code. The program does not allow code duplication. To remove an owner or company from the screen, select Del Line. OGwin assigns a share of the revenue according to their share of the total decimal interests of all owners or companies on this screen to each of the owners or companies. OGwin calculates this share by the formula: Revenue * (Their-Decimal-Intr / Total-Intr-on-Screen) One simple way to use this formula is to enter each owner or company’s share of the well. Example: Suppose you wish to replace one owner having a 20% share with three owners having shares of 10, 6, and 4%. Simply enter the decimal interests as .1, .06, and .04, and the program will assign the three owners a proportional share of the existing revenue. To calculate the percentage of the total to be redistributed to each of the owners/companies listed, click the Scale button. OGwin will prompt you to enter the new owners/companies and their relative percentages. IMPORTANT — If the original owner is to retain a portion of the revenue, you must list them with the percentage to be retained. In the example below, owner 105200 is retaining a 50% interest in the revenue. The remaining 50% is to be redistributed to owner 100000 and 100007. To also show the amounts to be redistributed in a memo company, enter the memo company code in the Memo space. The sample (above) shows the revised percents after you click the Scale button. OGwin will redistribute 100%, according to the owner’s percentages; the total should be 100%. OGwin will not show an amount for redistribution if it has been netted or otherwise adjusted. The program allows redistribution only of the original amount. To allow users to specify a well/deck for redistributing the items, use the Target Deck tab (new in version 2.0), rather than listing individual owners/companies. This is useful particularly in instances where the true ownership was originally unknown and a “dummy” owner was specified. Once you determine the ownership, use the Target Deck tab to select an expense deck to specify the ownership percent to redistribute the “dummy” ownership interest. Specify the payment type of the newly redistributed revenue. Select “Same” (same as the original revenue item), “Fully Payable,” “Suspended,” or “Suspend Code” (1-9). Indicate if revenue redistributed to a company should have the gross volumes and values suppressed in the company’s general ledger. This is useful if the company already has an interest in the well’s revenue to prevent duplicate gross amounts in property reports. This is new in version 2.0 To save your selections, click “Save.” OGwin may display the message shown below if any of the revenue items show ??? in the MemoAlso company column on the Selected Revenue Items tab. The message indicates that some revenue was posted in an earlier release of OGwin and allows the user to choose whether to reverse revenue from a memo company. To enter a Memo Company, enter “No.” To proceed without entering a Memo Company, enter “Yes.” Go to Post Revenue Redistribution (new in version 2.0). Select the appropriate Report Version to trial post, then final post the redistribution. Select Audit-Listing to print the G/L detail reports. New Service Pack Impacts Cross Clearing and Netting In OGwin 2.0 service pack 6/28/07, you gain the new capability to suppress cross clearing, while running the netting process. (Cross clearing is clearing a credit AR invoice for an owner against debit AR invoices. Netting is applying Revenue for an owner to AR invoices.) When you apply the pack to your database, a new checkbox will appear in Owner Maintenance, “No A/R Cross Clear during Rev. Netting.” If the box is checked, the owner will not have any AR credits cleared against AR debits. All existing owners, as well as new owners will default to the box unchecked. NOTE: If you loaded OGwin 2.0 service pack 4/26/07, this feature was handled with a dropdown list in Owner Maintenance for the Net Rev vs. Exps field. Load the 6/28/07 patch for the more simplified checkbox. Operator Online 2007-07-03T02:46:34-06:00 http://www.ogsys.com/site/use_ogwin_to_allocate_to_a_group_of_wells/ http://www.ogsys.com/site/use_ogwin_to_allocate_to_a_group_of_wells/#When:03:41:00Z OGwin gives you options to allocate expenses, revenues, production, and sales based upon previously defined well allocation tables. Use the “Well Allocation Maintenance” function to define the allocation percentages. Well-Allocation Record Usage Use Well Allocation Records to allocate one amount to a group of wells. You may allocate expenses or revenues over a group of wells. OGwin will divide the total amount of the items according to the percentages on the allocation deck, then use the well deck to disburse the revenue or costs to the participants on those decks. To spread costs or revenues over the wells: Enter the code for the allocation deck Choose type (“Field” or “Group”) from the pull-down menu Enter the effective date for the allocation deck Enter the total tokens for the distribution or the total of 100 percent Either enter a percentage directly for each well or enter tokens. OGwin will calculate the interests for each well. You may use token amounts to enter the production meter for each well in a gathering system. Use the OGwin Purchaser Check entry to Enter total sales for the system Code total sales to the system well allocation record OGwin will split the revenue based on the relative meter readings in the tokens columns of the well allocation record. You also may allocate accounts payable and journal entry amounts by using the allocation decks. NOTE: All of the wells in the allocation deck must have a common revenue or expense deck code to use for the allocations to the owners. The deck code is identified in the Purchaser Check Entry, A/P Invoice Entry, or Manual JE where applicable. To use the allocation in Accounts Payable, change the type on the Invoice Distribution to “Field,” rather than “Well.” Create a Partnership in Nine Easy Steps Use the OGwin Partnership Module to create a company with general and/or limited partners. Subsequently, you may record contributions, generate partnership distributions and print K1s for the year. In a partnership, the P&L account balances are taken to the capital accounts for General Partners and Limited Partners rather than to a Retained Earnings account. NOTE: To work with a partnership, the partnership must be established by the creation of the General Partner or Limited Partner list in Partnership Partner’s Maintenance BEFORE you do any processing. A company that already has activity cannot be converted to a partnership. 1. Create any entities that will be partners in the partnership as either companies or owners. If a company in the database will also be a partner, use that same company code. Otherwise, set up the partner in Owner Maintenance. 2. Use Partnership Partners Maintenance to set up the General Partners (if any). OGwin will list the partners with their proportionate share of the general partnership (to total 100%). 3. Use Partnership Partners Maintenance to setup the Limited Partners (if any). OGwin will list the partners with their proportionate share of the limited partnership (to total 100%). 4. Use Partnership Accounts Maintenance to establish the “appropriate split” between the general partners and limited partners by GL account. The default for each account is 100% to the general partnership. Therefore—whenever 100% to the general partnership is not appropriate—use OGwin’s option to change the default setting to reflect the proper percent for that fiscal year. You may change this setting any time before the fiscal year is closed. Once the year is closed, OGwin will reflect any changes in the next year. 5. Use Chart of Accounts Maintenance to create the following GL accounts: • General Partner Distributions • General Partner Capital • General Partner Contributions • Limited Partner Distributions • Limited Partner Capital • Limited Partner Contributions To keep partner activity by partner, give each of these accounts a location code: “Entity.” 6. To reference the GL accounts above in the appropriate categories, use Company Fixed Accounts Maintenance. Remember: all six partnership categories must be populated. Once you have completed the maintenance, enter and post activity as needed. Close the GL and subledgers according to the standard processing rules. 7. To post contribution amounts for each partner as needed, use the Capital Contributions Entry. 8. Use Capital Check Print to generate partnership checks to the General or Limited Partners. (As with other OGWin check programs, you may record checks manually or void as needed). 9. With OGwin, you may create General Ledger Reports for the partnership as a whole, for general partners only, limited partners only, or for individual partners with the 230-Financial Reporting and 250-Property Reporting. (See Report Version in the report setup window.) Subledgers VS General Ledgers—Learn the Keys to Maintaining Agreement By design, OGwin maintains agreement between the subledgers and the general ledger. However, certain manual entries can create havoc and cause ledger agreement to disintegrate. One key to maintaining agreement is avoiding manual entries to the GL accounts that control the subledgers. These controlling accounts include Accounts Payable Trade, Accounts Receivable Trade, JIB Clearance, Revenue Receivable, and Owner Advances. The golden rule is, “Never make manual journal entries coded directly to these accounts, bypassing the subledger.” The Royalties Payable account also controls a subledger. While this account would not usually allow manual entries, some exceptions apply. (For more information, contact OGSYS Support.) After each month’s processing, it is important to check each subledger balance to make sure it is in agreement with the controlling account balance in the general ledger. Get started by running the following reports: 1. The GL report (210-01) for each controlling account, for the current processing month and with prior balances. Run this report on a journal date basis. 2. The subledger report for each module: a. Accounts Payable Run Report 340-AP Detail, for all vendors, for Unpaid Items Only and by Transaction Date and Payment Date. The starting date field should be left blank while the cut-off date field should be the end of the current processing month. This report should agree to the GL report for the AP Trade account. b. Accounts Receivable Run Report 640-Aged AR Listing, for all owners. Any Aging Dates may be used as long as the latest date is the end of the current processing month. This report should agree to the GL report for the AR Trade account. c. Joint Interest Billing Run Report 720-JIB Billing Prelist for all owners (or wells). Use a “bill-thru” date of the end of the current processing month. Include suspended items but do not include future items. This report should agree to the GL report for the JIB Clearance account. d. Revenue Run Report 420-Revenue Check Prelist for all owners. Use a check date of the end of the current processing month. Include suspended items. This report should agree to the GL report for the Revenue Payable, Legal Suspense and Minimum Suspense accounts. e. Revenue Receivable Run Report 490-Aged Revenue Receivable Listing, for all purchasers. Any Aging Dates may be used as long as the latest date is the end of the current processing month. This report should agree to the GL report for the Revenue Receivable account. TIP: When the subledger controlling account has the proper location, it is easier to see the agreement or disagreement to the subledger report on the general ledger report. The location is defined in the chart of accounts maintenance as “None,” “Well,” or “Entity.” For example, the Accounts Payable report shows by-vendor activity; therefore, keep the AP Trade account by Location: Entity, so that the GL report shows by-vendor subtotals. If there are any differences between the GL and subledger reports, contact OGSYS System Support. New Excel® Macro for the Journal Entry Transfer For many years, OGwin has provided a journal entry upload feature. This program creates an unposted manual journal entry from an ASCII file in a specific file layout. Recently, however, OGSYS has added an extra benefit—an Excel macro for the JE transfer that will check your data prior to the upload. It also helps format the data correctly for the upload file by automatically editing field sizes and checking for proper structure. This macro ensures that each voucher balances by date, flags missing data or values that are too long, and inserts quotations for text. Provided the system detects no problems, the macro will create the transfer ASCII file automatically. To receive this macro, contact OGSYS support . . . or download from http://www.ogsys.com. Also note “coming attractions”—an Excel for budget and AFE uploads. Operator Online 2006-10-02T03:41:00-06:00 http://www.ogsys.com/site/16_reports_you_can_save_to_xls/ http://www.ogsys.com/site/16_reports_you_can_save_to_xls/#When:04:01:00Z OGwin allows you to save up to 16 reports in XLS format for use with Excel. This versatile feature provides you relevant data as a basis for the simplest to the most intricate spreadsheet. Here’s a menu of OGwin reports you can save: 210 – General Ledger 212 – Trial Balance 230 – Financial Report 240 – Property Sub-ledger 250 – Property Report 330 – A/P Check Register 340 – A/P Detail Listing 430 – Revenue Check Register 440 – Revenue Suspense 520 – Production Reporting 640 – Aged A/R Listing 650 – Delinquency Analysis 830 – Capital Check Register OWM – Owner Master Listing PUM – Purchaser Master Listing VNM – Vendor Master Listing Here’s how to get started: In the Output Options find “Send to” Select “ XLS File” Specify the File Location and Name to be used for this file Use the default extension of XLS so that the file is recognized by Excel as a file in the proper format. You may further customize the resulting output file using selections found on the “Customize XLS File” tab. These customizing selections allow you to convert the data and remove items that can become superfluous in an XLS file. Enable any of the following options by using a checkmark: Remove Empty Lines – generates the report without empty lines Remove Total Lines – generates the report without total lines Remove Report Headings – generates the report without the usual report headings. Change Categories To Columns – can be used only with a Report 230 and will cause the lines of data to be preceded by columns containing the category title Ignore Page Breaks – generates the report without page breaks Remove Text Lines – generates the report without text lines When you generate a report as an XLS file, the system holds a copy of that file in the Output Manager. To open the file using Excel, double click the file from the Output Manager. Use “Save As” to save any report to another directory (possibly an Excel folder). Note: OGwin will not recognize an XLS file unless your machine has Excel software. To send these XLS files via email, use the “Send Mail” button in the Output Manager. Look Ma, No Mouse! Even though the mouse is an essential and useful computer tool, sometimes it is nice to enter information without using it. Several OGwin features allow you to operate “mouseless” -- Enter as tab Use this feature to enter data in AP Invoice Entry, Manual Journal Entry, Purchaser Check Entry, AR Invoice Entry, and AR Payment Entry. Just key in the data and press “Enter.” To activate the feature— • In the System menu, select “User Preferences” • Click the file tab “Custom Actions” • Go to “ Key Action/Enter Key” section (top right on your screen) and click the Recommended button • The system will check the appropriate boxes for the ideal setting of the feature After the initial activation, turn the feature on/off using the Standard Toolbar button Underlined Character OGwin menus and buttons have lots of underlines. You may use the underlined letter in conjunction with the ALT key or CLTR key to activate the function. For example, the letter “P” is underlined in the word “Process” on the action line. To open the process menu, simultaneously press the “ALT” and “P.” Once the Process menu is open, use the “Up” and “Down” arrow keys to move around on the menu . . . or type the letter that is underlined for the application you would like to access. When you are in an entry screen, you may see file folder tabs for the different input screens. To access another screen, hold down “CTRL” and type the letter that is underlined on the tab. There are usually several buttons available in entry screens. A dotted line will appear around the edge of a button when your cursor is sitting on it. To activate the button, hit “ENTER.” Function Keys A number of functions keys are available in OGwin— • “F4” opens the Output Manger • “F5” opens the Task Manager • “F3” takes you to the next available voucher number on all the voucher entry screens • “F2” opens the search list for a field with search capabilities How to Create Net Distribution History An easy-to-use OGwin option — “Net Distribution” — allows you to create net distribution history and carry it over to a report for an owner. This useful function summarizes revenue and JIB detail by product, account, and well for each owner who is flagged to receive the net distribution statement. Run the Net Distribution History Generate function after final posting revenue but prior to netting of revenue vs. expense and revenue check printing. When you are running the netting process or printing revenue checks, the system will warn you if history has not been generated. When performing Net Distribution History Generate, you have options for setting up the posting date—you may choose between the “activity date’ and the “statement date.” If you opt for “activity date,” the system posts history entries in the journal date month for revenue and expenses. If you choose “statement date,” the system prompts for the month to use for the statement. If you choose “statement date,” the system will post all revenue received and JIBs processed since the last generation in the statement month. Therefore, revenue will be posted based on the deposit date, and JIBs (since they are fairly current) will be posted based on the journal date. If you want revenue posted based on the production month, choose “activity date.” The Statement Date selection should agree with the Revenue Summary Statements and JIB invoices for the month. The reporting function allows six report variations. Three variations are for historical reporting, while three are for current period. Reports 425-01, -02, and –03 are the historical reports. Run them before or after the check print and netting. To produce the reports after check print or netting, you would have run the history generate. The historical reports use a property format in combination with the programmed report layout. The columns in the format must call for net values. Reports –04, -05, and –06 are the current period reports. You must run these after the final A/P, JE, and Revenue postings but prior to the Net Distribution History Generate. These reports will print information for the current period revenue and expense. Contact OGSYS support for cost and additional information on the Net Distribution Reports. The Doctor is IN Q: Is it possible to turn off the system minimize feature, so I don’t have to continue to enter my password? A: Yes. Here’s how your Supervisor can get the job done— • From the Supervisor menu, select Station Maintenance • Click the Options button. • Locate the appropriate station ID • Click the Change button • Find a check box (right side of screen) for “Minimize and require password when idle” • Set the minutes to “0” (zero) and • Uncheck the box Q: In deck maintenance, I noticed there are two codes for each interest type — W or X for working, R or E for royalty, and O or N for override. What is the difference between the two codes? A: There is no difference. Within a deck, an owner may have only one of each interest type. In some cases, you may need to have two of a single interest type for the same owner. Therefore, OGSYS has established two acceptable codes for each type. An owner code may have two of the same type of interest using the two codes. There is no difference in the recording of the entries to the owner. Q: What controls the default date for reports like the AP Detail? A: The system date controls it. Prior to the 15th day of any month, the system will default to the prior month. From the 15th day to the end of a current month, it will default to the current month. For example, suppose the system date is “7/10/06.” The default report date would be “6/30/06.” Suppose the system date is “7/15/06.” The default report date would be “7/31/06.” Operator Online 2006-07-02T04:01:00-06:00 http://www.ogsys.com/site/too_many_pending_reports/ http://www.ogsys.com/site/too_many_pending_reports/#When:05:31:01Z If you have reports that go to “Pending” and never process after changes have been made in your workstation, the problem usually is that your station ID has changed. When processing reports in OGwin, you have an option to save the report print selections. Simply check the box on the Output Options tab to “Save these settings as the default settings for this report and user.” One of the settings is the station ID used to process the report. OGwin provides an option to prevent your future reports from going to “Pending”—even in cases of a change in the station ID. Here’s what to do: In Output Options, click the Task Schedule tab Change the station ID to run on your new station ID under “Run on Station” Go back to the Output Options tab and click the “Save these settings as the default settings for this report and user” This procedure will re-record the new settings for each of your reports. Repeat the procedure once for each report that goes to pending. To run the “currently pending” reports: • Press the Task Manager (F5 key) and click on “Schedule” • Change the “Run on Station” ID to your new station ID • When you click “OK,” the report will process • Delete any duplicate reports still pending in Task Manager Between Major Changes . . . Downloadable Updates Periodically, we send you CDs with major changes to OGwin . . . to update your release version. Meantime, we continuously update our software and post downloadable, interim changes on our website as service packs. A service pack quickly updates programs, so it just takes a few seconds to download and apply to your database. It’s a good idea to check our website, http://www.ogsys.com, for interim updates. Find the service packs in the “Support” section of the website. Positive Pay vs. Check Fraud Check fraud is becoming a bigger problem each year. To help prevent check fraud, many banks today provide a positive pay solution for their customers. To expedite the feature, OGSYS now offers an optional Excel Macro that translates your check register to a bank-required format. For more information or to purchase this custom feature, contact support@ogsys.com. New Procedures for Voucher Tagging Over the past several months, in response to client issues, OGSYS has initiated several significant changes to the voucher tagging in the OGwin posting routines. Here’s the new procedure— • Posting routines default to post all vouchers in the module you are working • If you go into the voucher selection line, the default changes to Tagged Vouchers for the User ID you used to sign-on to OGwin • When you retrieve the vouchers, only the nonposted vouchers that user entered will appear • To view all nonposted vouchers (regardless of user), enter a nonvalid User ID in the User ID to Process field • When you retrieve the vouchers, OGwin will display all nonposted vouchers for that module (regardless of the User ID) • You may tag and untag the vouchers you wish Navigate the Latest SOX Enhancements and Master File Controls OGSYS has been making changes to comply with SOX (Sarbanes-Oxley) requirements and to allow for more control over master file changes. For many years, OGwin has included the Event Log in the Supervisor menu. It monitors entry into the database and marks the date and time a user enters an application. The system also allows you to designate certain applications to monitor in the Event Log Maintenance by check marking the application. At any time, you may view or print the log in the Event Log Maintenance. Change List reports have always been available in many of the master file “Run Reports.” These Change List reports identify the number of changes made to a master file record since the change count was zeroed. OGSYS also has created new OGwin options for password requirements. Option 193 sets up a 30- or 60-day expiration for user passwords. The user must change their password when alerted by OGwin. The system no longer allows the OGwin supervisor to view user passwords. Option 195 raises the minimum required password characters from four to eight. The required password remains alphanumeric. Option 49 allows the OGwin Supervisor exclusive responsibility to zero the change count in the master file Run Report feature. Here’s how to use this feature to monitor changes in the Master File (when a supervisor is logged in): 1. As a starting point, print the full list from all Master File-Run Report screens. 2. Check the box next to “OK to zero the change-count also?” This will print the Master Files as currently saved and mark the change count as zero for each master file. 3. Create a log of Master File changes. Use the log to maintain copies of approved master file changes, indicating what specific change was made, the user who made the change in OGwin (with the date and time), and any approvals required by your company. 4. In Supervisor-Event Log Maintenance, use a green check mark to designate each master file menu item that you want to monitor. This will make a log entry in the Event Log every time a user makes a change in the master file – it logs only the user ID, date, and time. It does NOT log exactly what was changed. 5. Weekly, supervisors should print a Changes List from master file maintenance and check the box next to “OK to zero the change-count also?” 6. Compare the Changes List to the log of Master File changes. If a master file record is listed as changed (but no record is found in the log), print the Event Log and determine what user(s) accessed that master maintenance menu item without an entry in the log. In order to meet requirements, OGwin version 2.0 (now in beta testing) will make available additional changes. The new version will track changes to any data item or record that has a bearing on disbursements (checks). Examples include items such as vendor or owner name and address, bank information, and decks. “Tracking” involves noting when such things change, asking the user for a brief note or reason for the change, and creating a change history record in a new file (HC) tagged with the user ID, workstation, date and time. You may request the change note for bank maintenance, vendor maintenance, owner maintenance, wire-transfer maintenance, deck maintenance (expense, revenue, and deck entity), and Lease Maintenance financial controls. Other changes – such as mass code changes that may affect decks – also will have a change history entry. When decks are involved, OGwin will try to protect against unauthorized changes, and substantially enhance the way deck changes are integrated into normal processing and posting. In version 2.0, OGwin will provide a Disbursement Change History report. This report will have various filters, a time period entry, and will allow you to fully audit changes to any of the data items that are being tracked. It also will provide a separate section for owners, vendors, decks, etc. In addition, the upgrade will include a continuity section to prove that the change history itself has not been altered. Operator Online 2006-04-02T05:31:01-06:00 http://www.ogsys.com/site/new_180_option_streamlines_ach_payments/ http://www.ogsys.com/site/new_180_option_streamlines_ach_payments/#When:03:38:00Z OGwin version 1.80 provides an optional, extra-cost feature designed to streamline ACH payments to vendors and owners. The $1,000 feature works in conjunction with the OGwin automatic emailing feature. It also adds new maintenance items found in Miscellaneous Maintenance. Email Maintenance Be sure to populate the tabs for “Payable Check” (PCK) print and “Revenue Check” (RCK) print with the return email address, email subject line, and email body. Bank Maintenance Create a Bank Maintenance record for the processing company’s bank and each bank receiving ACH payments. EFT Account Maintenance EFT Account Maintenance will link the processing company’s cash account to the Bank Maintenance and other bank information. EFT Vendor Maintenance EFT Vendor Maintenance identifies the method of payment for each vendor and links the vendor to a bank. Key Fields : Payment Mode This field determines whether the vendor will receive a check, wire transfer, draft, or ACH. A/P Check Email Enter the email address where the vendor will receive confirmation of the ACH. Option When using the payment mode of ACH, you must select one of the email options. Generate ACH Pre Note? This will flag OGwin to generate a pre-note to be sent to the vendor’s bank for testing purposes. You must run the ACH Pre-Note Generation program. ACH Pre-Note Generation Use ACH Pre-Note Generation to create a test file to be sent to the receiving bank. This will determine whether the bank coding was entered correctly. AP Check Print To generate the ACH payments, you must go to AP Check Print. The payment method line on the setup screen displays options to allow payments by checks, wire transfer, bank draft, or ACH. Identify the ACH file and designate a place to store it. Once the ACH file is created, the processing company must transmit the file to the bank according to the bank transmittal requirements. To purchase and activate the feature or for more information, click . Upgraded Search Tool for Vendor Invoice Information The AP Check Status Inquire/Edit, found on the AP Checks menu has always been a great tool to look up vendor invoice information. We now have improved on the lookup. With the upgrade, you may search for an invoice, by invoice number, invoice date, due date, discount date, or invoice amount. Top Two Questions for a Quarter Q: Where can I turn the OGwin toolbars on and off? A: The View menu will lead you to a list of OGwin toolbars. Click any item, and the toolbar will turn on or off. An active toolbar has a check mark beside it. Q: I see buttons—“Next” and “Previous”—in some maintenance items. What are they for? A: Pressing the “Next” button directs the system to advance to the next record in code number order; while the “Previous” button directs the system to display the previous record. If you change the record, the system gives you an opportunity to save before advancing. These two buttons are found in Vendor Maintenance, Owner Maintenance, Well Maintenance, Chart of Account Maintenance, and report format maintenance. Version 1.80 Changes—Purchaser Check Control Maintenance and Purchaser Check Entry 1. Version 1.80 introduces a new deduction field—“Other Deductions #2.” This new field allows users to accommodate up to six deduction fields for purchaser checks (four tax fields and two other deduction fields) in addition to operating expenses. Tax fields allow users to exempt specific owners in the revenue deck from the “tax” and can specify names and tax computation methods (using Revenue Tax Rate Maintenance). Other Deductions #1 and #2 must apply to all participants in the revenue deck. You cannot specify a name or calculation method for other deductions. 2. Version 1.80 also provides a new “Generate 100%” option for tax fields. Previously, a “Generate” option was available only for each tax field. The difference between “Generate” and “Generate 100%” is that the “Generate” box will calculate the tax based on the rules in Revenue Tax Rate Maintenance and allocate the tax to owners using the revenue deck’s total taxable interest for that tax column. This generates a net less than 100% of the gross, if there are some exempt owners. The “Generate 100%” flag forces the net tax amount to be equivalent to the gross tax amount. This means that—if some of the owners in the revenue deck are exempt from the tax—other owners must make up the extra tax.  NOTE: The “Generate 100%” option should be used only if the revenue deck equals 1.0 and the purchaser check mask is applicable for Interest Type = T-Total. Operator Online 2005-07-02T03:38:00-06:00 http://www.ogsys.com/site/ogwin_180_feature_packed_upgrade/ http://www.ogsys.com/site/ogwin_180_feature_packed_upgrade/#When:03:23:00Z New Capability to Reprint JIB Invoices One of the most-requested features of 1.80 is the ability to reprint a JIB. Our users let us know, and we responded. The OGwin JIB print process transfers owner JIB activity to Accounts Receivable and doesn’t allow reprocessing a JIB from the JIB system. Therefore—in developing 1.80—we included a JIB print feature to the AR Invoice Print. This allows you to reprint a JIB, until it is reduced by a payment entry. New Option—‘Close Deck’ Another new design feature in OGwin1.80 allows you to close decks. In both Revenue Deck Maintenance and Expense Deck Maintenance, we have added a field—“Close Deck.” When you click that field, the deck will no longer be available for use during entry of an AP invoice or Journal Entry for expense decks, and Purchaser Check Entry for revenue decks. The system will hold the deck in the database for viewing in revenue or expense deck maintenance. Automatic Email—Its Time Has Come Version 1.80 provides some advanced new options for automatic emailing. As a result, you can now email to selected owners -- · Revenue Summary Statements · Accounts Receivable Summary Statements · Joint Interest Bills · Net Distribution Statements Friendly Email Maintenance Here’s how to define Email Maintenance for each company that will use automatic email. Key Fields: · Server Enter the IP address of the email server. Test this address by clicking the test button to the right. · User Name The user name for your mail server is required only for special server configurations. · Password The password for the user name entered is required only for special server configurations. For each statement to email, enter the following information on the appropriate tabbed screen: · Return Address The emails will be sent from this address. · Subject Line Enter the text for the subject line of the email. · Body Enter any text you would like to print in the body of the email. The actual statement will be a PDF file attachment to the email. You may enter the link for Adobe Reader in the email body, http://www.adobe.com/products/acrobat/readstep2.html . Adobe Reader is required to view the PDF file. Blind Copy all reports sent to the return email address above. The blind copy checkbox will provide you an email record of the statements being sent. Note: OGwin email does not automatically send copies of messages to the “Sent Folder.” To create a record of emails “sent,” check the “ Blind Copy” box. Owner Maintenance for Email Receipt For each owner to receive statements by email, go to the “Email” tab found in Owner Maintenance and identify the email address for each statement type. Also indicate whether to print the statement only, email only, or both. Do not use the email address on the general screen of Owner Maintenance for automatic emailing. It serves only as a reference field. Easy Setup for Emailing Statements Each statement that allows automatic email includes the following box on the setup: “Send Statement emails immediately.” Click the box to send email to owners formatted for email. All statements—except for JIB—give you the option to email. OGwin automatically emails JIBs. Large statement processes will slow down your mail server. To minimize mail server slow downs, consider running the statements with emails during a time when no one is in the database. OGwin will create a report showing each owner who received an email, and any email errors. The recipient will receive an email with a PDF file attachment of their statement. Viewing the PDF attachment requires Adobe Reader software. The PDF is programmed to print on 8 1/2 x 11 paper. The page setup and page breaks may not be the same as OGwin. To open the email attachment for viewing, some recipients may have to save the PDF attachment to their system. Operator Online 2005-03-02T03:23:00-06:00 http://www.ogsys.com/site/1099_tips_just_in_time/ http://www.ogsys.com/site/1099_tips_just_in_time/#When:03:06:00Z Printer Friendly Version • Before filing, always review all 1099 instructions and publications from the IRS • Download 1099 updates for OGwin versions 1.70 and 1.80 from our website – http://www.ogsys.com . Then, apply the updates to your database. • Consider filing electronically through the IRS website (See http://fire.irs.gov ) • Note the new field in OGwin’s new Version 1.80—DBA (Doing Business As)—in Owner Maintenance and Vendor Maintenance. Use this field to input the name that coincides with the Federal ID number for owners and vendors who operate under a different name. The 1099 programs will use the DBA field, if populated, for the recipient name on 1099s. If the DBA field is not populated, then the 1099 programs will use the Name field in the maintenance. The Top 12 Questions about 1099s Q : On the Vendor 1099 Proof Report, what’s the difference between “Print Non-qualifying Amounts” and “Print Non-flagged Vendors”? A : Printing all “Non-qualifying Amounts” will print all amounts . . . regardless of the minimum you have set on the 1099 run. Printing “Non-flagged Vendors” will print all vendors . . . regardless of the flag in the master file for “Send-1099.” Q : What if I void a 2004 check in 2005, after I have already sent out 1099s? A : When you voided the 2004 check, OGSYS updated the 1099 file for 2004 (which you will not see unless you decide to re-run your 2004 1099s). What happens in 2005 depends on whether you re-issue the check. If you issue it with a 2005 date, OGSYS will update the 1099 file for 2005, so that the amount is reported for 2005. If this is not the desired result, you may adjust the 1099 amount using the adjustment entry screens. Q : When I start to close January 2005 for Revenue, the system says it will purge prior year’s 1099 information. Does this mean for 2004? A : Yes. OGSYS purges the prior year’s 1099 information with the January Revenue close. Make sure you have a year-end back-up before proceeding. Q : Can I print 1099s more than once? A : Yes, 1099s can be printed over and over again until the information is purged. OGSYS does not purge 1099 information until the 1099s have been printed after the December month has been closed for that module. Q : OGSYS says I didn’t print 1099s for last year, but I did. What does this mean? A : It’s best to run the December close prior to the final 1099 run. If 1099s are run prior to the December close (not after), OGSYS does not recognize the 1099 run as “officially” being run. Therefore it does not purge the information for that year and could blend it into the next year. Q : Can I run Electronic 1099s or Disk Media more than once? A : Yes. You may generate 1099 electronic or disk media as many times as necessary until the information is purged. Make sure you generate 1099 information to an electronic file or disk media before closing January for the module. Q : Which address box is used for 1099s? A : 1099 forms use the address from the default screen of the master file record. Electronic, disk media and substitute 1099 forms also use the address from the first screen. Version 1.80 has a field in owner maintenance and vendor maintenance called, “DBA.” If it is populated, OGwin will use that field for the recipient name in 1099s. Q : How do I get Vendor 1099s to print in the Rentals box? A : By default, Vendor 1099s print in Box 7—the non-employee compensation box. However, it is possible to choose the payment type, and therefore the box for a vendor’s 1099 amount. Vendor maintenance allows you to choose from the following payment types: 1 – Rents, 2 – Royalties, 3 – Other Income, 6 – Medical Payments, 7 – Nonemployee Compensation, and 14 – Gross Attorney fees. Q : What are substitute 1099s? A : A substitute 1099 is an IRS-approved optional form for Owners/Vendors. This is especially helpful to users who file electronically or by disk media. Send the electronic file or disk media to the IRS, then print substitute 1099s to send to the Owners/Vendors. Then, it will not be necessary to buy the standard 1099 forms. NOTE: Do not send substitute forms to the IRS. You will be charged a penalty fee for filing incorrectly. Q : The 1099s for Electronic and Disk Media ask the question, “Prior Filing Year?” Does this mean I can run 1099s for 2003? A : Under normal processing, you would not be able to print 1099s for 2003 now. That information was purged in January 2004. This field is part of the record layout for electronic and disk media 1099s, so it must be included here. To be able to answer “Yes” to this field, you would have to take extra steps to ensure that the data is available. Q : May I select and sort by vendor/owner codes for 1099s? A : Yes. You have entity selecting and sorting capabilities for all 1099 processes. Q : I need a list of all the vendors/owners with no federal ID. A : You may select and sort by a Federal ID number any place where you have entity selection capabilities, including all the 1099 processes and entity listings. When you sort by Federal ID, the system places all vendors/owners without an ID at the beginning of the report. The Federal ID also prints on the brief entity listing. Processing 1099s in Five Easy Steps 1099s and 1099 balances are integral parts of OGSYS. Enter balances only during installation, as OGSYS maintains 1099 information automatically. OGSYS provides 1099 updates as a normal part of support services. The system supports 1099 forms, disk media, electronic 1099 reporting, and substitute 1099 forms. Make sure you have loaded the latest release and service pack for current 1099 programs. Remember, the IRS will not return problem media. Keep a copy of the 1099 files you submit to the IRS. 1. Lay the groundwork: • Always run an Accounts Payable Close Month for December before printing Vendor 1099s for a year. • Always run a Revenue Close Month for December before printing Owner 1099s for a year. • Always run a Lease Records Close Month before printing Land-Owner 1099s for a year. • You may print the 1099 Proof Reports at any time during the year. 2. Print the 1099 Proof Report to verify 1099 amounts and to verify which entities will receive a 1099. 3. You may adjust 1099 amounts. For vendor 1099 adjustments, use the Vendor 1099-History Entry function from the Vendor History/1099s Menu. OGSYS will display a screen showing the check detail total and the 1099-history amount. The sum of these two figures is equal to the amount that will be printed on the 1099 form. To make adjustments to a Vendor’s 1099 amount, increase or decrease the 1099-history amount as needed. This is a replacement amount, and the system will add it to the check detail total to give you the actual 1099 amount. For Owner 1099 adjustments, use the 1099 Adjustment Entry function from the Owner 1099s/Balances menu. Enter adjustments as replacement amounts in the appropriate fields. For Land-Owner 1099 adjustments, use the Land-Owner 1099-History Entry screen on the Lease-Records Maintenance menu. Enter the adjustment as a replacement amount in the appropriate field. 4. Always verify 1099 amounts for at least one vendor/owner prior to mailing 1099s. 5. If you do not run December Close Month prior to printing 1099s, subsequent years’ 1099s will include amounts from the prior year. To correct, reprint 1099s for the prior year, and run the module Close Month for December of the current year. NOTE: OGSYS includes items netted within the current 1099 calendar year in that year’s 1099 amounts. Therefore, do not run the cross-clear program using a December voucher date, unless the items being netted are to be included in the current year’s 1099s. Items to be included in the next year’s 1099 must have a January-or-later voucher date. Substitute 1099s are available for Vendor 1099s, Owner Royalty 1099s and Land-Owner 1099s. Use these substitute forms to mail to the Vendors/Owners. These forms are not intended for the IRS. You will see Substitute 1099s in each respective 1099s menu. NOTE: OGwin users filing disk media 1099 should save the file to a network or local drive using any file name. You will then go to the Split Program for 1099 found on the Exceptional Processing menu. This program will copy the file to the diskette assigning the IRS filename. This process should be performed even if the file spans only a single diskette. Extra Tips to Brighten Your Year-end! Make a year-end backup before closing the General Ledger. Most important—This backup should include ALL OGwin files; data, programs, and control files. By copying all of OGwin, you are ensuring that you can restore the database for that time period, if necessary. Retain this backup permanently. Do not overwrite with a later backup. NOTE: If you back up only the data and your current database has been upgraded with a release, you will not be able to use the year-end backup. The year-end General Ledger Close performs some extra steps. The close routine will take the balances in the Profit and Loss (P & L) accounts and zero them into the Retained Earnings account for corporations, and into the Capital account for partnerships. Because of this, it is important to make sure your Fixed Account Maintenance is set up accurately. Make certain the first P & L account is specified correctly, the system will take every account from the first P & L account forward, and zero it to Retained Earnings. Also, make sure the Retained Earnings or Capital account is coded correctly in the fixed accounts. DO NOT close the General Ledger for the year without having the first P & L, Retained Earnings, and Capital accounts coded correctly because you will not be able to correct the incorrect balances by re-closing the year for the P & L accounts without restoring your database. You may re-close the year-end General Ledger, however, for any adjusting entries that are posted in the new year. New Version 1.80 — Loaded with Wow! Factors The company is releasing the much-anticipated OGwin Version 1.80. Major changes and new features include -- • New capability to reprint JIB Invoices • New capability to automatically email Owner Joint Interest Billing Invoices, Revenue Summary Statements, and Accounts Receivable Statements • ACH payment capability for owner revenue checks and vendor accounts payable checks. This module is an extra-cost item ($1,000) and includes the existing wire transfer module. • Batchname Maintenance programs allow 9999 entries. • New field in Revenue and Expense Decks that adds capability to close the deck for use, but maintain it within the system • Implemented due date cut-off in A/P check pre-list • Added functionality to search grid detail by Invoice date, Invoice number and Amount in Invoice Entry and Inquire Edit modules • New capability to enter 8/8s and net volumes in AP invoice entry • A second Other Deduction field for Purchaser Check Entry • Expanded, five-character Recording Book field • Capability to use an expense deck less than 100% with Lease Maintenance billees • New “Document Class” as a maintenance function of its own (Land Module) • New capability to print a Lease Records check register by-owner Coming newsletters will expand and discuss these new features and changes. Initially, we are distributing the new release slowly to all clients who maintain an OGSYS support agreement. If you have an urgent need, expedite your shipment by contacting . Operator Online 2004-12-02T03:06:00-06:00 http://www.ogsys.com/site/entity_reporting_set_account_location_for_specific_result/ http://www.ogsys.com/site/entity_reporting_set_account_location_for_specific_result/#When:02:56:00Z When running your General Ledger, OGwin gives you the option to have the accounts provide subtotals by “well” or by “entity.” To accomplish this, set the account location in Chart of Account Maintenance. For the location field, the program will indicate choices of “None,” “Entity,” or “Well.” If you prefer no subtotals within an account on the General Ledger report, select “None” To subtotal activity within an account by an entity code such as vendor or owner, select “Entity.” Select “Entity” for the accounts that coordinate with the subledgers, such as Trade Accounts Payable and Accounts Receivable. This will make easy reconciliation of the subledger to the General Ledger. To subtotal activity within an account by well code, select “Well.” Select “Well” for any account for which well level reporting is appropriate. These accounts will appear on the Property Subledger report, which is a General Ledger report that you may select by well. Generally, select “Well” for oil and gas income accounts, IDC accounts, LOE accounts, and tax accounts. Selecting vs. Sorting. What’s what? The road to success in producing well and/or lease reports demands that you know the difference between selecting and sorting. Selecting involves choosing certain properties (wells or leases) to appear on a report. Meanwhile, sorting involves determining the order in which the properties should be listed and subtotaled. In OGwin, the screens for selecting and sorting look similar because property fields are used for both functions. But the headings are different. The heading for the selection screen is “Property Filter Selection,” while the heading for the sorting screen is “Property Sorting Sequence.” Selection screen: Sorting screen: Depending on the type of report, the fields that appear on the selecting and sorting screens are pulled from well or lease maintenance. Both system fields and user-defined fields appear. When selecting, choose a field, such as “County.” Enter a single county, range of counties, or group of counties. The report will list only properties in the counties selected. You may select up to nine property fields on a single report. Determine sorting after you make property selections. Choose a field, such as “Operating Group.” OGwin will list all properties in the same operating group together and give a subtotal for the operating group. A well report allows up to five levels of sorting, with the last level always the well code. A lease report allows up to eight levels of sorting, with the last level always the lease code. Subtotaling will appear on a lease report only if it is included in the report template. Get More out of Property Reports with Extra Information Feature Do your property reports provide all the information you would like? A special OGwin option will enable you to bring in extra information. The extra data comes from the system-designed fields and the user-defined fields in well maintenance. For example, when you are reviewing by well financials, you may easily recap the following for each well: revenue interest, operator, oil purchaser, gas purchaser, and perhaps even the field from which the product is produced. The Extra Information option may be available on your system already. To determine this availability, search the Property Maintenance section for a selection called “Extra Information.” Once you have this option, you may set up the extra information maintenance. Begin by creating an Extra Info name and specifying all the well fields you would like to see on a property report. Then, when you run a property report, indicate the appropriate extra information name. The report will print as always—except the extra field line below each property will appear. You also have the ability to sort the report, based on the extra fields. The reports with this special option include: Report 230 (Financial Report) if the report is limited to certain properties, Report 240 (Property Subledger), Report 250 (Property Reporting), and Report 520 (Production Reporting) if you have the Production module. For a report enhancement, contact OGSYS support, . Answers to Key Questions Q: What month should I use for closing Revenue . . . the current month, or the month of production? A: The revenue month should match the general ledger month. When closing the accounting period for the GL, that same period would be closed for the Revenue. An important consideration is the 1099 process at the end of the year. Since December must be closed before the 1099s are generated, it is better to close December than to wait for December production before closing. Q: What happens if I redistribute revenue through the Revenue Redistribution program to an owner or company that already has an interest in the property? A: OGwin doesn’t determine whether a prior interest exists before performing the redistribution; therefore, the gross (8/8) amount will be overstated for an owner or company that already has an interest in the property. You may reverse out the gross amount through a manual JE. The manual JE will reference the income accounts only because you are adjusting just gross amounts—not net value. Q: Is there any way to be alerted when an incorrect date is entered? A: Set a reasonable date range in System Parameter Maintenance. Find this setting on the second screen of the maintenance and identify how many months are reasonable for previous and future dates. OGwin looks at the last month closed in the module you are working. The system will display a warning message if the date you entered is outside the month range you specified. The warning appears on the entry screen and posting report. It will not prevent you from final posting. Operator Online 2004-10-02T02:56:00-06:00