LDSTechForumProjects

Reconciling a ward account that has not been reconciled for more than two months

With the institution of Church Unit Banking Services (CUBS), reconciliation of the Unit Financial Statement to MLS is no longer required. In MLS 3.1.1 the Reconciliation option has been removed. Units should now look at the "Action Items" section of the Unit Financial Statement, take appropriate actions, and have the priesthood leader (bishop, stake president) and the clerk sign at the end of the section.

So you're a new assistant ward clerk over finances. The checking account does not reconcile, and it looks like it hasn't been reconciled for some time. Where to you start?

Some new clerks experience frustration with the reconciliation process, especially if the unit's checking account does not currently reconcile to zero. This article is designed to help newly-called clerks find a starting point from which they can get the reconciliation back in order.

Important rule to follow

As you follow these instructions, be sure to complete each step before moving to the next. Be precise. Even the smallest out-of-balance amount can cause problems months later. It's essential that the month you are working on is completely reconciled before moving to the next month.

Section 1: Find the last month that reconciled to zero

To find your starting point, locate within MLS the last month where the reconciliation was completed, all categories should have no unreconciled differences, and no Temporary Items were used.

To find the last month that reconciled to zero in MLS:

  1. On the main screen of MLS, from the Finances menu, click More.
  2. On the Finances screen, from the Reports/Reconcile menu, click Reconcile.
  3. On the Month for Reconciliation pop-up window, select the latest month and year of the report you believe may be reconciled to zero.
  4. On the left side of the reconciliation screen, click Report.
  5. On the reconciliation Report, view the Unreconciled Differences line.
    • All columns on the line should read $0.00.
    • If the columns don't all read $0.00, go back one month and repeat steps 4 and 5.
    • Once you find a month with all Unreconciled Differences at $0.00 and no Temporary Items entries, then the next month will be your starting point. (For example, if in March 2008 the Unreconciled Differences columns are all $0.00 and there are no Temporary Items, your starting point is the reconciliation for April 2008.)

Section 2: Review the reconciliation

Now that you have your starting month, begin the reconciliation as though you were doing it for the first time.

  1. On the Balances screen, confirm that the balances match the Ending Balance on the Unit Financial Statement.
  2. On the Other Items screen, check any existing entries to be sure they fall within the Other Items Guidelines as stated below (please check the Expenses tab as well for recorded charges). Check to see if the Ward Missionary, Distribution Services, and any other charges appearing on that month's financial statement have been entered. If not, enter them using the guidelines as stated below.
    • Other Items Guidelines
      • Other Items are for credits to the unit account appearing on the statement. An Other Item can also be used to enter charges appearing on your statement that you didn't write a check for in MLS (such as Ward Missionary payments, Distribution Services charges). In these cases be sure to enter a negative (-) amount to show the expense. Never enter an Other Item for an item meant to be a Temporary Item.
      • Expense, Not-a-Check is the preferred method for recording expenses appearing on your statement that you didn't write a check for in MLS (such as Ward Missionary payments, Distribution Services charges). Select Enter Expenses and check the Not a Check box. When entering an Expense, Not-a-Check, use the date and reference number from the Unit Financial Statement.
  3. On the Reconcile screen, click the Deposits tab and compare the deposits in MLS to the deposits on the finance statement. Check off the deposits that appear on the statement. Deposits that appear in MLS but do not yet show on the statement should be unchecked.
  4. On the Reconcile screen, click the Expenses tab and compare this to the Outstanding Checks section of the financial statement. Be sure that any outstanding checks are unchecked on the Expenses tab.
  5. On the Reconcile screen, click the Transfers tab. A brief review of this tab should be sufficient. Be sure to check off the following items on the Transfers tab:
    • Category adjustments to a donation batch may create an extra transfer that should be cleared. Note: Don't check off the adjustment if the donation batch has not cleared on the Unit Financial Statement.
    • Items that have a reference starting with the letter "T" (such as T20090401100). These are transfers created in MLS.
    • Any voided checks.
    • Other Items entries.
  6. On the Temporary Items screen, be sure that any item listed falls within the guidelines as stated below. Enter a Temporary Item for any deposit errors or returned checks that appear on your statement, or for a deposit category or check category adjustment that has been entered in MLS but hasn't been adjusted on that month's statement. Check off any Temporary Item that should not be there, or any that now show adjusted on the Unit Financial Statement. Click Save.
    • Temporary Items Guidelines
      • Never use a random Temporary Item to force your reconciliation to zero. Temporary Items are only used for categories that carry a balance on the Unit Financial Statement. When entering a Temporary Item only use the parent category (such as Ward Missionary or Other), don't use sub-categories. Only enter a Temporary Item when there is a specific line item on your Unit Financial Statement justifying the item. Enter a Temporary Item for a deposit/check category adjustment made in MLS that is not yet adjusted on the statement.
      • Temporary Items should be entered for deposit errors, returned checks, deposit category adjustments, and check category adjustments. All require that headquarters make an adjustment to the unit banking account. Never enter these adjustments as Other Items. Temporary Items have a specific reference number that should be used when the entry in made. These adjustments enable the reconciliation balance to be zero.
  7. On the Report screen, view the Unreconciled Differences line. If all columns show $0.00, move to the next month and repeat steps 1-7. If you still show an unreconciled difference, move to Section 3.

Section 3: Look for unreconciled differences in Deposits

If you still have unreconciled differences, look for Deposit category adjustments.

  1. On the Reconcile screen, click the Deposits tab.
  2. On the Date column, click the date of the last deposit that cleared during that month.
  3. The Donation Review screen appears, showing details of this batch. Look for any adjustments made to the batch. Adjustments have a triple asterisk (***) to the left of the donor name.
    • If there are no adjustments to the batch, click Close at the bottom of the review screen.
    • Under Deposits, click the next batch date in the list to view the batch details and search for for adjustments.
  4. If you find an adjustment marked with the triple asterisk, view the detail of the columns in that row to determine how the donation funds were adjusted.
    • Any adjustment made to the Other or Ward Missionary accounts may require a Temporary Item.

Section 4: Look for unreconciled differences in Expenses

If you still have unreconciled differences, review the expenses for that month.

  1. On the Reconcile screen, click Expenses.
  2. The Category column lists the category charged for each check. Any expense marked with the word Multiple indicates that more than one category was involved with this expense. It could be that the expense was charged to multiple sub-categories. Also, it could indicate that an adjustment was made between different categories for that expense.
  3. Click Multiple to see the detail of the adjustment.
  4. Any adjustment made to or from the Other or Ward Missionary categories to another category (such as Budget) may require a Temporary Item.

Section 5: Additional reconciliation resources

If you've been unable to locate the cause of the unreconciled difference using these steps, do not move to the next month. Ask your stake clerk for help. If the stake clerk is unable to help, he should contact the administrative office.

Resources

This page was last modified on 22 April 2011, at 09:48.

Note: Content found in this wiki may not always reflect official Church information. See Terms of Use.