Master Formula for Reconciling

Discuss questions around local unit policies for budgeting, reconciling, etc. This forum should not contain specific financial or membership information.
kylems-p40
New Member
Posts: 8
Joined: Sat Jul 05, 2008 7:50 pm
Location: Wayzata, Minnesota, USA

Master Formula for Reconciling

Postby kylems-p40 » Mon Nov 03, 2008 8:56 pm

Hello all,

Thanks to everyone for this wonderful forum! I've learned so much already.

My question tonight is a rather difficult one to communicate, and even more difficult to answer. This may be a community project in proportions. What I'm looking for is a "master formula" that would explain what each total or subtotal on the CUFS and MLS represents. This may be best illustrated with examples:

Ultimately, we must reconcile so that:
CUFS = MLS.

Breaking both of those down would show:
CUFS Tithing + CUFS FO + CUFS Budget + CUFS Missionary + CUFS Other = MLS Tithing + ... + MLS Other

Furthermore:
CUFS Tithing = MLS Tithing, ..., CUFS Other = MLS Other

And so on.... Now, even more specifially, and more helpful would be an explanation as to where certain values come from within the CUFS itself.

For example, on the CUFS YTD Summary:
Total Disbursements for Budget = Checks Cleared written in that month + Miscellaneous Disbursement and Credits + Total Deposit Adjustments

Is this a practical question? I don't know enough yet to judge if it is or not. Put another way, I'd like to be able to see exactly what other values make up the total values. If the CUFS was an Excel file, I would only have to click on any cell and see what other cells it is referencing. That's what I'd like to do.

Thanks for all your help!

User avatar
aebrown
Community Administrator
Posts: 14685
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Mon Nov 03, 2008 9:10 pm

kylems wrote:Hello all,

Thanks to everyone for this wonderful forum! I've learned so much already.

My question tonight is a rather difficult one to communicate, and even more difficult to answer. This may be a community project in proportions. What I'm looking for is a "master formula" that would explain what each total or subtotal on the CUFS and MLS represents. This may be best illustrated with examples:

Ultimately, we must reconcile so that:
CUFS = MLS.

Breaking both of those down would show:
CUFS Tithing + CUFS FO + CUFS Budget + CUFS Missionary + CUFS Other = MLS Tithing + ... + MLS Other

Furthermore:
CUFS Tithing = MLS Tithing, ..., CUFS Other = MLS Other

And so on.... Now, even more specifially, and more helpful would be an explanation as to where certain values come from within the CUFS itself.

For example, on the CUFS YTD Summary:
Total Disbursements for Budget = Checks Cleared written in that month + Miscellaneous Disbursement and Credits + Total Deposit Adjustments

Is this a practical question? I don't know enough yet to judge if it is or not. Put another way, I'd like to be able to see exactly what other values make up the total values. If the CUFS was an Excel file, I would only have to click on any cell and see what other cells it is referencing. That's what I'd like to do.

Thanks for all your help!


There's not really any reason to reconcile the sum of all the categories; only Missionary and Other have non-zero balances on the CUFS, and if you reconcile them separately, then their sums will obviously reconcile.

But there is definitely value in understanding the YTD section for Budget in particular, and also for Fast Offerings, and perhaps for Tithing. This YTD section is the only possible means for double-checking the Budget and Fast Offering sections to make sure you didn't miss anything. I'll be reconciling my October statement in the next couple of days; if no one has supplied the details in the meantime, I'll do it then.


Return to “Local Unit Finance”

Who is online

Users browsing this forum: No registered users and 1 guest