MissionBase

Great Spirit Systems
 2007 Year End /  2008 New Year Benefits Information
For MissionBase Customers

 

 

December 10, 2007

Dear Friends:

Greetings!  This document is my annual letter to benefits customers with information that is vital to closing 2007 and opening 2008.  Please email Lori Smith (lori@greatspirit.com) or me (bull@greatspirit.com) if you have any questions about the instructions and procedures below, or if anything does not appear to work correctly.

Before getting to the basic content of this communication, I want to thank all of you for your patience and support of Great Spirit Systems.  We continue to focus our efforts on additional functionality and new development, in numerous areas of MissionBase, especially in making progress towards MissionBase as a web based system.  The next two to five years will see some exciting new features in MissionBase that should be to the benefit of all.

The sections of this letter consist of:

  1. A cautionary statement about starting the new year.
  2. Information and procedures about bringing benefits balances forward from 2007 to 2008.
  3. Special Information for CRSP/CPP billing conferences.
  4. Special information for Medical insurance billing conferences.
  5. Override lists.
  6. Clergy compensation data upload to GBOPHB.
  7. Database Ready for 2008 Transactions.
  8. Important items to remember.
  9. A listing of GSS customers who are using some or all of the benefits billings modules.

Cautionary Word:

Please do not start the January 2008 billing process until you have completed the processes described in the next section.  This is an important set of procedures designed to be run only once each year.
Top

Benefits Balance Forwards From 2007 to 2008:

A critical step in opening the new year is to bring benefits balances forward into the new year.  THERE ARE FOUR IMPORTANT ITEMS TO REMEMBER WHEN BRINGING FORWARD BALANCES:

  1. Only run the balance forward procedures once.  Running them more than once will cause database integrity problems and should only be done if directed by GSS.
  2. You should run the balance forwards AFTER January 1, 2008.
  3. You should only run the balance forwards AFTER you are certain that all December payments and adjustments have been posted.  Failure to do so will result in incorrect balance forwards.
  4. If you have run the balance forwards and then decide that you need to enter additional December transactions, you should enter two complete sets of adjustments.  One would be dated in 2007.  Then you would enter an identical set of transactions dated 2008.  This approach is the preferred accounting method.  Not following this process will result in the balance forwards being incorrect for some entities.  In extreme cases where this is not feasible, please ask us to manually remove the balance forwards so you can make the necessary payment entries in 2007 only, and then you will run the balance forwards again.

The balance forward procedures are found as follows:

  1. Click the “Benefits” button on the list bar at the left of the screen.
  2. Click the “Tools” eagle button.  You may need to scroll the list of eagle buttons to see the “Tools” eagle button.
  3. After clicking the “Tools” eagle button, a number of forms will load on the right.  Look for the “Benefits Balance Forward” form.
  4. On the form, make sure the “Prior Year” box shows “2007” and the “Current Year” box shows “2008.“  If not, please enter the correct years.
  5. Select the appropriate benefit type from the tree on the left.
  6. If you want to preview the balance forwards before they actually post, click the “Preview Balance Forwards” button. This button will produce a report that will show you what the balance forwards will be for the new year. You can use the report to make any adjustments in case you notice some problems in the balance forwards. Then you can run the report again.
  7. Click the “Bring Balance Forward Into The New Year” button which will process the balance forwards for the specific benefit type selected in the tree.
  8. The progress will be reported with the progress bar and information label just above the progress bar.

All credit and debit balances will be carried forward, except for Missouri which has a customized process related to specific retiree categories where certain debit balances do not carry forward.

Note:  The balance forward procedures may take some time to execute if your conference has a large number of transactions.  Please be patient as the process must retrieve, verify, add together, and validate all 2007 invoices, payments, and adjustments for every participant and billing entity in your database to calculate the balance forward amounts. The more transactions in your system, the longer the balance forward process will take.
Top

Special Information For CRSP/CPP Billing Conferences:

CRSP/CPP billing customers should verify their 2008 CRSP and CPP settings are entered.  If you haven’t entered the CRSP/CPP settings, I encourage you to do so right away.  You may enter these settings at any time during the year when you have the information, for any year into the future.  If you have entered them, you may want to verify them at your convenience.  Note that making any changes to these factors, will change the figures on both the CRSP/CPP participation form and compensation forms.  That is especially important for you to consider if your districts use MissionBase as it will change what they see displayed for CRSP and/or CPP on the compensation form.

To enter the 2008 CRSP/CPP factors:

  1. Click the “Benefits” button on the list bar at the left of the screen.
  2. Click the “CRSP/CPP Settings” eagle button.
  3. Click the “Add New Year” button at the bottom of the form.
  4. To copy the 2007 settings into 2008, click the “Copy Most Recent Year CRSP Settings” button and/or the “Copy Most Recent Year CPP Settings.”
  5. At the top of the form, enter:
    1. Start date, which should be 01/01/2008.
    2. Stop date, which should be 12/31/2008.
    3. The 2008 DAC, which is $56,044.
    4. The 2008 CAC specific to your conference.
  6. Click the “Save” button.

To edit the 2008 CRSP/CPP factors:

  1. Click the “Benefits” button on the list bar at the left of the screen.
  2. Click the “CRSP/CPP Settings” eagle button.
  3. Make sure “0/1/01/2008” is highlighted.
  4. Examine the 2008 data and make any changes as needed.
  5. If you make changes, click the “Save” button.
    Top

Special Information For Medical Insurance Billing Conferences:

You will need to enter your 2008 premiums. You may enter the 2008 premiums at any time AFTER you have printed the final statements for your December billing.SPECIAL NOTE: The Missouri and South Georgia conferences should NOT complete this step as their 2008 premiums need to be set up by me since they are highly customized.

To enter the 2008 premiums:

  1. Click the benefits button on the list bar at the left of the screen.
  2. Click the “MFL Settings” button.
  3. On the right look for the premiums setting form. It will probably be the second form in the list.
  4. Change the premiums in the grid as needed.
  5. Click the “Save” button on the form. The premiums will be changed for all participants in your database with the exception of overridden premiums and other special cases. After you click the “Save” button and the premium updating is completed, a report will be printed providing you with a list of those participants whose premiums were not changed, and why. This report can then be used to manually change the premiums for those persons on the list.
    Top

Override Lists for Premiums and Billings:

Each conference has some overrides for premiums and/or billing amounts. These overrides are used in instances where your regular billing formulas or other special reasons don’t apply to unique circumstances.

Note that when a person has a 2007 override set, the override billing amount will also be used in 2008 unless it is changed. In other words, since compensation will likely change on January 1 affecting CRSP and CPP, and since insurance premiums change, you may want to look at the list of overrides to see what changes need to be made before your January billing cycle.

To get a list of overrides, you can go to either any of the benefits reports trees.  Look for the “Override List” report in the tree.  If the tree has folders, it will be found in the “Other” folder.  Note that UMPIP does not use the override concept at this time, so there is no override report in the UMPIP report tree.
Top

Clergy Compensation Upload to GBOPHB:

Usually this is one of the two times during the year when clergy compensation changes need to be reported to GBOPHB. The program to prepare the file for uploading may be found in one of two places in your Report Tree, depending on which MissionBase modules you have installed. For some, it will be found under Clergy Reports. For others it will be found under “Pension Reports”. In both cases, the report name is "Clergy Compensation Reporting Batch File".

Here's how it works.

  1. Select the report in the Report Tree and click the "Print/Preview Report" button.
  2. Select January 1, 2008 as the date, and click “Continue.”
  3. The report will process all compensation records that have a January 1, 2008 start date, where the pastor's appointment start date is prior to January 1, 2008 (see note below). The CashSal, Pars, HsngAllow, and HsngExcl fields should be calculated according to the same rules that are used on the Compensation form within MissionBase.
  4. When processing is completed, you will see a grid display on the screen. The grid will display all of the compensation records that will be included in the batch file.
  5. YOU MAY DELETE any compensation records from the grid at this time. Reasons to delete may include persons who receive compensation but are excluded form making CRSP/CPP contributions; and any errors that you spot but do not have the correct information at the current time. (You will undoubtedly have to enter a few "late arrivals" manually through the PARK interface.)
  6. After completing any deletions, you may click the “Export to ASCII” button. This will create a file in the format that is acceptable to GBOPHB's PARK system. Please make a note of the location of this file on your hard drive. You will need to enter this location later when you are logged into PARK.
  7. You may also want to click the “Print Report” button to get a paper listing of the file. Some folks find it handy to run this report ahead of time and print it out, as a worksheet/checklist to be sure that they get all the compensation records entered prior to uploading.
  8. Log into GBOPHB's PARK system, look for the Compensation Upload function, and upload the file. We at GSS do not have regular access to PARK, so if you have problems with this step, please contact GBOPHB's help desk.
  9. The PARK system will let you know if you have any errors according to its filters. If so, edit the information in MissionBase and run this process again.

NOTE: GBOPHB's system will only accept uploaded compensation change records for clergy whose appointment is unchanged.  Therefore if any of your clergy are changing appointments on January 1, you will need to enter that information manually through PARK.
Top

Database Ready for 2008 Transactions:

Your database has already been prepared to receive 2008 transactions, so you can begin your January billing cycle when you are ready.

Important Items To Remember:

Here are some other important items for you to consider:

GSS Benefits Customers:

For your information, here is the list of our current benefits billing customers:

Arkansas – Medical Insurance
East Ohio – CRSP/CPP, medical Insurance, and flexible benefits
Kansas East – CRSP/CPP, medical insurance, and flexible benefits
Kansas West – CRSP/CPP, medical insurance, and flexible benefits
Kentucky – CRSP/CPP, medical insurance, flexible benefits, vision insurance, and dental insurance
Louisiana – CRSP/CPP and medical insurance
Minnesota – CRSP/CPP and medical insurance
Missouri – CRSP/CPP, medical insurance, and flexible benefits
North Central New York – CRSP/CPP
Nebraska – CRSP/CPP, medical insurance, and flexible benefits
New Mexico – CRSP/CPP, medical insurance, flexible benefits, and life insurance (BPP)
Northwest Texas – CRSP/CPP, medical insurance, and flexible benefits
Puerto Rico – CRSP/CPP
Rocky Mountain -- CRSP/CPP, medical insurance, and flexible benefits
South Georgia – CRSP/CPP, medical insurance, and flexible benefits
Southwest Texas – CRSP/CPP, UMPIP, medical insurance, flexible benefits, and life insurance
West Ohio – CRSP/CPP  and life insurance
Wyoming (of NY and PA) – CRSP/CPP, medical insurance, and flexible benefits

Thank you for your continued confidence in Great Spirit Systems to provide your benefits management and billing information system needs. GSS continually works to improve our overall product design and function. We have made, and will continue to make, enhancements based on your suggestions, so keep those ideas coming to us. Also, please remember that GSS offers several other modules for MissionBase in addition to benefits billing when your conference is looking for software for other functions.

Please let Lori or me know if you have any questions on any the above.

I hope your seasons of Advent and Christmas are blessed and that your New Year will be spiritually prosperous.

Bill Johnson
Vice President of Software Development
Great Spirit Systems
bull@greatspirit.com
www.greatspirit.com