Contact Brad@rpfin.org is you have questions
RE: Big Pix Finance Reporting at a Church Originated March 2000
Below is a hypothetical Online Email thread (THRD) between any of the following MFTeam members: PAT (Ministry Chief Executive), LEE: (Ministry Volunteer Treasurer), or FRAN: (Ministry Computer Bookkeeper) and Jim@bcidot.org Click here and go to List of threads (THRDs) at www.bcidot.org
Hi Jim Bee ..... appreciate your help in the past. Am now faced with presentation of condensed financial information to various Church Ministry groups, like periodic Church congregational meetings and even Board of Leadership meetings..
Please provide me with some thoughts along these lines.
FR JIM BEE
OK, Lee. As I remember you are using our recommended QB Fund Accounting system via Method One where Special Purpose Funds - SPFund - appear as QB Equity accounts. Go to to the "QB Fund Acctg FAQ" publication within the WEB Publication List below to remind you re the definition of SPFunds and other detail about this QB Fund Accounting method. Please also read two publications found in the Web Publications List below: "Board Members and Ministry Finance Info" and "Church Membership-Finances". Reading these will give you a little of my perspective.
We believe that the Sunday church bulletin should continuously provide readers with the status of the Church GPFund ..... specifically what is needed each week in comparison to what has been received. See "Church Membership- Finances" below. Then the periodic Church Business meeting reports should feed from this information.
Fundamentally, I believe the Church Ministry Finance Team needs to provide complete info, but keep it short and simple -- all on one page. A reporting perspective might mean that, on an average, you are communicating such info to the spouse who maintains the family budget and check book - so share with that in mind. Let us know, Lee, if your Ministry Finance Team would like to use Chart and Graphs to provide such information. Also, go to 5022 for a detailed BIG PIX information.
Appreciate the overview, etc ....... please provide some examples with the above in mind.
FR JIM BEE:
OK ..... please note that the report below is from the basic numbers appearing within the referenced "QB MinFin Samples".
As pointed out below in the "Key Item Trend Statements" publication, Ministry Board members need to have a "big pix" grasp of relevant Ministry Finances. So the one-page example below is a suggested way to accomplish this. You as Church Treasurer, in my opinion, can then make copies of this for the Church Business meeting and then highlight key data. Sometimes colored highlights appearing on such a report can serve that purpose. Also note the columns and line Identifications (like in a Excel Doc) that helps you reference applicable areas of the report; like H 19 or the $5, 376 deficit, etc..
I am VERY much aware that the ideal is to enter transactions once and then have ALL of the financial reports flow from the QB System (or similar system), but, unfortunately, this is not always possible. The report below was done via Excel ... let us know if you would like a copy of the Template .... but it easily could be originated in a Word document and saved also as a Template. Then update the Word Template by typing in applicable whole numbers from subsequent reports already being produced via QB, etc.
|3||O P E R A T I O N S R E C A P|
Sample Church -
Begin July 1, xxx8 thru May 31, xxx9
|16||New Capital Assets||$79,500||$74,500||$5,000||$5,000|
|19||Excess Revenue (Expend)||($74,526)||($5,376)||Annual Budget||$100,000|
|20||Divided by 52|
|23||Begin||$95,000||GPF Income to date||$79,300|
|24||Ending Balances as computed $20,474||Divided by 48|
|26||"Spoken For" as listed below||Wkly Difference||271|
|28||#2-Donor Restriction||$1,200||Ending Bank Balance||$16,879|
|29||Board SetASides||$13,550||Less Unpaid Bills|
|31||Fund Totals||$20,474||($5,376)||Fund Balances||$15,098|
NOTE: The lines and rows above are similar to a spreadsheet so that you can reference, when discussing with someone, a certain area of the report; e.g., line 27, row G informs you that there is $3,500 on hand of Donor Restricted monies. Also see more samples re Building/Construction funds when you click here
Wow, that is great information, Jim Bee ...... all on one page. Be interested in your view, after looking at the info, just what you would 'highlight' as key information.
FR JIM BEE:
I would point out at least the following.....
General Fund deficit for the 11 months is $5,376;
Or the Church has used all of the Board Discretionary Funds ($2,224) and erroneously borrowed the remainder from other SPFunds; or this is Flagable situation and it appears that this Church is a candidate for the alternative budget system that we describe when you go to 0002 whereby your income is placed in applicable Ministry area BuxBoxes and you can only spend if there is money in such a BuxBox, etc.
The weekly Budget need is $1,923 as compared to what has come in of $1,652.
And the Church has spent since the first of the fiscal year ($84,076) less that it's year to date authorized budget ($85,089) by $383.
Right on ...... I could distribute such a report to those at the applicable meetings. Then mention highlighted key items like above and then be available to answer questions.
Seems the Church Ministry Finance Team and members of the Board of Leadership should understand a report like this. Again highlight items, distribute, and discuss more in depth with them.
Thank you, Jim ..... will let you know if we have any questions..
- - - - - Web Publication List - - - -
Spending Control website - effective July 2006
Annual GAAP Church Financial Info
Bank Balance, Beyond the
Board Members & Ministry Finance Info
Church Membership-Finances to
Key Item Trend Statements -
Ministry Accounting Issues
QB Church Samples List
QB Fund Accounting FAQ
QB MinFin Samples List
Reports, Ministry Finance
Reports - Photo and Video
Please Click here for list of Church resources here on www.bcidot.org The bulk of this Publication originated in March 2000 and was UPTD: February 24, 2013
| OUR PURPOSE | WHY "NEST OF BEES" | WHO WE ASSIST | ASSISTANCE EMPHASIS | ASSISTANCE SPECIFICS | INFO ABOUT BRAD