How do I read and use the Allocation report?
How does the Allocation Report calculate amounts due?

The allocation report is designed to give you all the information you need in order to meet your allocations in full. The Allocation Report will calculate your World Evangelism Fund (WEF), Pensions and Benefits, Education and District allocations. To access the report, got to the Checkbook screen, click on Reports and then click on Allocations.

We recommend using the Allocation Report in the following way.

  1. After opening the report, choose the "Year-to-Date" option at the top of the report.
  2. If necessary, you can change the end date to an earlier date. Example, today is November 12, but you only want to pay allocations through the end of October. Change the end date to October 31.
  3. If your church will not be paying the full WEF allocation, choosing the Total Paid calculation option will give you total due for your other allocations based on the reduced WEF payment. See below for more information.
  4. To see how much you need to pay to meet your allocations, look at the Net Due column (very last column). Paying the amount in that column will get you up-to-date on your allocation payments.
  5. To print the report, click the print button in the upper right corner of the report window.

Here is a sample report and explanation of all calculations.

Allocation Report Example

Report Date Range - There are 3 options given and a manual override. The This Week option give you a date range of the current week, Sunday through Saturday. The This Month option will give you a date range of the current month, up to the current date. The Year-to-Date option will give you a date range for the entire year, up to the current date. Use this option to determine if you are ahead or behind for the year. Many users will want to use this option to determine the amount to pay on a weekly or monthly basis by looking at the Net Due amount. To choose a different date range, click on the start date and/or end date to change the dates.

Calculation Option (Total Due/Total Paid) (available on NTS version 4.70 and above) - When calculating allocation exemptions, the system will use the Total Due by default unless the Total Paid is more than the Total due, in which case, Total Paid is used. The system calculates the correct amount due for the other allocations based on the larger of these 2 numbers.

When more is paid for WEF than what is due, it reduces the amount due for the other allocations. If less than the Total Due has been paid, the system uses the Total Due to calculate the other allocations. Then when the full WEF payment has been made, the amount for the other allocations is also correct. Using the lesser of these two numbers results in an overpayment of the other allocations assuming the WEF is or will be paid in full.

If the church is not going to pay the full WEF allocation, using the Total Paid option will allow for a more accurate calculation of the other allocations. Paying less than the full WEF allocation will result in the other allocation amounts increasing. Using the Total Paid option, the report will reflect the higher amounts due to the lower WEF payment amount.

Gross Income - This is the total of all Tax deductible contributions. This number is determined by adding all funds designated as tax deductible posted to Contributions in NTS. Click the down arrow button next to the gross income to see a detailed listing of the funds included. Double click on any fund to see a detailed listing of all contributions made to that fund. Please see the links below for more information on how income is calculated and what money is to be included in income.

Allocation Name - The name of the allocation.

% - The percentage column is the percentage of your income you will pay for your allocations.

Exemptions - This is the amount of exemptions, if any, that apply to the allocation. The amount of any exemptions is subtracted from the Gross Income before percentages are calculated. The amount of exemptions is calculated using the exemption settings for the allocation report. See Allocation Setup for more information.

Net Income - This is the amount that is multiplied by the percentage to determine the amount due for the allocation. Net Income = Gross Income - Exemptions.

Total Due - The amount due necessary to fully pay your allocation. Total Due = Net Income × percentage. The WEF allocation is slightly different. See the note below for more information.

Amount Paid - The amount of any money paid during the report time frame. Double click on any amount in this column to see a detailed listing of all payments made to the allocation. In the example, no checks have been posted from January 1 to January 31 for any of the allocations. Only payments made to the expense accounts linked to the allocation will appear as a payment.

This Payment (This Pymt.) - If you are planning on paying some amount other than the Total Due, enter in the amount you are going to pay. If the amount you are going to pay is less than or greater than the Total due, it could change the Total due for other allocations. If you will be making a payment for an Approved Special but you haven't entered it into the checkbook, enter the amount on the Missions Special line and the report will deduct that amount from your gross income. After you enter an amount in this column, press Enter on your keyboard and the report will recalculate your allocations based on the amount you entered.

Total Paid - This is the amount already paid plus the any amount entered into the "This Payment" column.

Paid % - Based on the Total Paid figure, this is the percentage of your income you have or will have paid toward this allocation.

Net Due - Based on the Total Paid and the Total due, this is the amount that you are over or under paying your allocations in full. If the amount is negative, you have over paid your allocations.

At the bottom of the report, there are totals for Total Due, Total Paid and Net Due. The amount of total paid does NOT include amounts paid towards Missions Specials. If the total for net due is less than zero, the total will be zero.

It is important to know that this report will only show report income and amounts paid during the specified date range. If the date range is August 1 through August 7, the report will only show income and payments made from August 1 to August 7. It will not show income or payments made for any dates prior to August 1 or after August 7.