Master Formula for Reconciling
Posted: 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!
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!