Reports

The purpose of this chapter is to give you a description of each report provided by Jewel. These reports are made automatically, with no extra work from you. Jewel simply takes the data that you have entered week to week and organizes it in these reports, providing a clear picture of your church's financial status currently, as well as compared to the last couple of years. Jewel is capable of storing many, many years of data.

There are a few common elements throughout most of these reports. Firstly, as you look through them, notice in the upper left corner of each report is a section titled Dates. Here, you can select from a list of date ranges by clicking the down arrow. These include ranges such as this month to date, last month to date, last fiscal year, etc. You can also choose to see a report of a more specific date range. If so, just to the right you can type in the beginning and end dates of the report you would like to see. As you change the date, notice that the report below changes according to the time frame you have chosen.

The other functions common to all of the reports are Copy to Clipboard and Print, both located in the upper right corner of the screen. Clicking Copy to Clipboard enables you to copy the report and paste it into another document, such as Microsoft Word. Simply right click in the new document and choose Paste, or select Paste from the menu at the top of your text editor. The Print button enables you to print the report. You can also select how many copies of the report you would like printed, by clicking the up and down arrows in the small text box beside the Print button. Also, notice especially in the first column of most of the reports, some of the text is too lengthy to fit in the area provided for. If you want to see all the text, simply move your cursor over the header line between the first column and second column. The cursor will change into a different symbol. When it does, click and drag the column to the right until you can see all of the text. You can also make the columns smaller with the same process, but by dragging the line to the left.

Financial Summary

This report is likely the one you will encounter and use the most. It is generally reported monthly and annually and Jewel will print the Financial Summary as part of Month- and Year-End reports. This is an excellent summary of all the financial transactions which have taken place during the time period you have selected. The financial summary is very useful for presenting to the church board, and you may want to consider printing out a copy to distribute to each board member.

This report is the equivalent of what you may have heard referred to as a "Balance Sheet." The first section of the report shows all conference funds. This is the equivalent of your Liabilities (these are funds you owe to another party). If the report you are viewing was after the close of a month or year, the ending balance should be zero. If not, it means you have not remitted all conference funds yet.

The middle section shows Local Church Funds, which is the equivalent of your Fund Equity. This shows how the money you have in the bank is to be spent in your church.

The third section is your bank account(s), which refers to your Assets. The money amount in your bank account(s) must be equal to the amount listed under Local Church Funds (Assets = Liabilities + Fund Equity). As you look at this report, notice that it shows all deposits made, checks written, as well as any funds transferred between accounts. It also shows your beginning and ending balances.

Notice to the right of the date selection box there are is an option to select either Summary or Detail. The report defaults to Summary, which only shows all parent accounts. If you click on Detail, the report will show all of the sub accounts falling under the parent accounts and the specific transactions taken place in each.

Monthly Budget

This report is only useful if you have made a budget allocation for your church budget. It shows you on a month by month basis how your actual spending compares to what was budgeted for each month. It also shows a year-to-date (YTD) comparison so you can see how your spending compares overall to the budgeted amount since the beginning of the year. This report is fairly self-explanatory, but we will discuss what each column of data shows. The first column to the left is the Accounts which have been budgeted for under Church Expense. The second column entitled "Month Actual" shows the amount of money which has been spent on each account. Say you wrote a $100.00 check for your electric bill for the current month. This check will show up under the Month Actual beside the Utilities account. The next column over is Month Budgeted, which tells you the amount which was budgeted for this month (calculated by Jewel when performing Budget Allocation). The next column is Difference, which tells you what the difference is between what you have spent and what was budgeted for each account. The next three columns show the same information, but for year-to-date. This may also be a very useful report to present to the church board to illustrate how your church is doing regarding following the planned budget.

Near the bottom is a summary of Church Budget income and income from all other funds as well as funds spent and difference for current month and year-to-date. The last line shows a total of all funds at the beginning of the year, beginning of the current month, and end of the current month.

Contribution Report

This report shows how much money has been contributed during the selected time frame, and which accounts the monies were donated to. You can either view all accounts, or select only one to view. Do this by clicking the down arrow by the text box in the upper left corner, and select which account you would like to view. This report defaults to showing All Accounts. This report also defaults to a detailed report, showing the contributions by donor and date. However, you can also look at a Summary report which adds up the totals donated from each donor for all dates within the time frame selected and shows you how much total was donated to each account for conference and local funds.

The detail report does have a summary at the bottom of the report as well. When viewing the detail report, notice that your cursor changes to a magnifying glass when you are over any of the entries. This means then when you click, it will take you to the contribution entry screen for the entry you clicked on. You can use this either to view the entry screen, or to actually make changes. You may have noticed while looking at the Contribution Report, that the wrong amounts may have been keyed in to the account. You can correct this by clicking on that entry and making the appropriate changes in the Contribution Entry screen. However, you can use this method ONLY to change how much was in each account. You CANNOT make a change to the total amount contributed.

Contribution Statistics

This report summarizes church giving patterns. For each fund which received contributions during the report period, several pieces of information are shown:

• Donors: The number of donors or families who gave to this fund. (A husband and wife, for example, are a family, not two individual donors, if they are listed together in the Names List, and receive a single receipt.)
• Donor %: The percentage of donors who gave to this fund, out of all donors who gave anything for any fund.
• Amount: The total amount contributed to this fund.
• Amount %: The percentage given to this fund, of the total contributed to all funds.
• Per Capita: The per capita (average) amount given by those who donated to this fund.
• Average: The average amount given to this fund by all donors who gave for any fund.

One useful calculation that can be made from this report is Church Budget as a percentage of Tithe. This can also be seen in graphical form by choosing Reports and Graphs, Graphs, Percentage Comparison.

Deposit Report

The Deposit Report shows all deposits you have made into your checking account(s) during the selected time frame. This includes offering deposits as well as any interest earned. If you have multiple bank accounts (such as checking and savings), you can choose to view any of these individually by clicking the down arrow in the upper left corner text box and selecting the desired account. This is an easy way to view only the deposits made, and how each deposit was divided into the church accounts. As with the contribution report, you can click on any deposit which will take you to the Edit Deposit screen for the respective deposit. You can also make corrections here if needed, by clicking Make Corrections on the Edit Deposit screen, and then making the appropriate changes in the Contribution Entry. Any new changes will be stored, overriding previous entries. However, remember that you cannot change the total amount deposited - you can only make corrections to how much was to be put in each account - the total MUST remain the same, as this has already been deposited in your banking account.

Check Report

This is a report of all checks which have been written during the selected time frame. This will also include any bank fees, etc which were keyed in as a General Journal Entry. As with the deposit report, you can also choose which account to view in the upper left corner. Notice to the right of account and date selection is a box entitled Sort Order. Here you can choose in what order you would like your checks to be sorted in. You can sort by date, check number, payee, or account. Notice that your cursor turns into a magnifying glass over this report as well. By clicking, you will be taken to the actual check written. However, you cannot make any changes if the month is closed where the check was written, as the check has already been processed! You may want to view the details of the check, such as the memo written. This is a convenient way to view the check.

Transfer/Allocation Report

This report shows you all the transfers which have been made between accounts. Also, if you have made a budget allocation for the year, this report will show the allocation as well. The memo will indicate the allocation and what month it was for.

Account Journal

The Account Journal is a summary of the deposit report and checking report combined - showing all monies which have been deposited into or taken out of the account you have selected (by default, your checking account). It will also show fund transfers and budget allocations. The first column "Type" shows what type of transaction it was - if it was a check, the check number will show here; if it was a deposit, this column will say "DEP". The next column is date, showing what date the transaction took place. The To/From Account column lists the account the transaction took place for. Under Amount, the amount added or subtracted is listed. Positive numbers under this column indicate a deposit or interest earned. Negative numbers indicate checks written or bank fees. The Account Journal should match up exactly with your bank's records.

Receipts

This is a report of all contributions, listed by donor and in the form of the Contribution Receipts you will send out at the end of each calendar year. Printing contribution receipts is included in the "Next Step" process of calendar year end, but you may need to look at the receipts at other times during the year. If for some reason a donor wants to see their donations so far in the year, you can print their year-to-date contribution receipt from this report. When you click on Receipts on the Reports & Graphs main screen, a dialog box will come up asking which receipts you would like to view. You have the option of viewing all, a single donor, or a range of donors. Fill in the appropriate range and click OK. If you are viewing All receipts, they will appear in alphabetical order. Each ****** line indicates a page break. This means that when you print, all the information between these lines will print on its own page.

Lists

Names

The Names List is a record of all donors and vendors. You can view donors, vendors or both. You can also view names by hidden or active status. This list shows donor/vendor ID number, address, phone number, and codes. These codes indicate whether they are a donor(D) or vendor(V) and whether or not they are to receive receipts at year end(R). You can also edit any name by clicking on it - you will be taken to the Edit Names screen where you can make appropriate changes.

Accounts

The Accounts List is a record of all accounts listed in Jewel for your local church as well as your local conference. This list can be sorted by ID number or account name. For each account, this list shows tax-deductible status (TD) and Non-posting (NP) status. You can edit an account from this report by clicking on the account you want to edit. You will be taken to the Edit Accounts screen.

Comparisons

This is a report comparing your current monthly expenses with the same month's expenses from the last year. There is also a year-to-date(YTD) comparison. This is useful for finding spending trends and catching any significant differences in spending from year to year.

Annual This report is just like the Monthly expense report except that it is comparing the entire year with previous years. This is more useful for finding overall spending trends. You can compare your spending with up to two years previous from the current year.

Graphs

This is yet another convenient method of presenting your church's financial status. This is an excellent tool to help visualize your church's finances. You can view graphs of contributions, percentage comparison, and donor counts. As with all other reports, you are able to select the time frame you would like to view. You can also view by account - conference, local, individual, or all accounts. Notice that you can change the format of your graph to either line, bar, area, step, or pie chart. Whether or not you use this will depend on the preferences of your church board and how you would like to present your data to them.

FAQs

Can I transfer Jewel reports into an Excel or Word document so I can change the report format?

Yes. All you need to do is select the report and Copy to Clipboard (Ctrl+C) and then Paste (Ctrl+V) into your Excel document.