Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tax_coll:reports_menu_form [2020/05/20 16:16 UTC] – matt | tax_coll:reports_menu_form [2021/02/25 20:00 UTC] (current) – [Transfer School Taxes] mwolfe | ||
---|---|---|---|
Line 1: | Line 1: | ||
=====Reports Menu===== | =====Reports Menu===== | ||
+ | {{map>: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | * [[tax_coll: | ||
+ | {{<map}} | ||
+ | |||
When you Export Payments you should also create the New Bills report, Assessment Report and Treasurer Report on the same schedule. This will insure that your records and those of the taxing bodies will remain in synch and will avoid many problems. | When you Export Payments you should also create the New Bills report, Assessment Report and Treasurer Report on the same schedule. This will insure that your records and those of the taxing bodies will remain in synch and will avoid many problems. | ||
Line 6: | Line 23: | ||
Most reports include the date in the title bar of the preview. If you print the report to PDFCreator this becomes the default name for report making it easy to keep and identify multiple copies of the same report. | Most reports include the date in the title bar of the preview. If you print the report to PDFCreator this becomes the default name for report making it easy to keep and identify multiple copies of the same report. | ||
+ | {{: | ||
====Receipt Report==== | ====Receipt Report==== | ||
In order to create one of these reports you must enter the start and end dates that you entered the receipts in the program and the order in which you wish to view the report. Receipt order prints the receipts in the order you entered them in the program, bill order prints them sorted by the bill number and Tax Map prints them in order by the parcel number. The receipts are grouped by batch and tax type, Municipal or School. Grouping payments by batch is optional but may be helpful during periods when you receive a large number of payments. This report includes the payer’s name, bill number, check number, date the receipt was entered in the computer, taxes received and any adjustment required to reconcile with the total amount paid by the taxpayer. This report is intended to help the tax collector reconcile the amounts posted in the computer with the payments received. | In order to create one of these reports you must enter the start and end dates that you entered the receipts in the program and the order in which you wish to view the report. Receipt order prints the receipts in the order you entered them in the program, bill order prints them sorted by the bill number and Tax Map prints them in order by the parcel number. The receipts are grouped by batch and tax type, Municipal or School. Grouping payments by batch is optional but may be helpful during periods when you receive a large number of payments. This report includes the payer’s name, bill number, check number, date the receipt was entered in the computer, taxes received and any adjustment required to reconcile with the total amount paid by the taxpayer. This report is intended to help the tax collector reconcile the amounts posted in the computer with the payments received. | ||
+ | \\ \\ \\ \\ \\ | ||
+ | {{: | ||
====Receipt Labels==== | ====Receipt Labels==== | ||
This process creates labels that you can use to post payment to the paper duplicate. The program will print on either standard address labels, 30 to sheet or on smaller labels that come 80 to a sheet and correspond to Avery 5167 or 8167. The program creates labels for both the municipal and school taxes at the same time. The first line starts with an M or S for the bill type, then the district number, bill number and payment date. The second line has the name of the payee. The third lists the payment amount and the fourth displays the check number. The program will prompt you for the number of labels to skip. This will allow you to use the remainder of partially used sheets of labels. If you are using a new sheet of labels, then enter 0 labels to skip. | This process creates labels that you can use to post payment to the paper duplicate. The program will print on either standard address labels, 30 to sheet or on smaller labels that come 80 to a sheet and correspond to Avery 5167 or 8167. The program creates labels for both the municipal and school taxes at the same time. The first line starts with an M or S for the bill type, then the district number, bill number and payment date. The second line has the name of the payee. The third lists the payment amount and the fourth displays the check number. The program will prompt you for the number of labels to skip. This will allow you to use the remainder of partially used sheets of labels. If you are using a new sheet of labels, then enter 0 labels to skip. | ||
+ | \\ \\ \\ \\ \\ \\ | ||
====Refund Report==== | ====Refund Report==== | ||
This report lists payments that have overages that exceed the refund level established in the program settings. It includes the payment date, tax type, bill number, payer and any information you entered in the PaidBy field when posting the payment. | This report lists payments that have overages that exceed the refund level established in the program settings. It includes the payment date, tax type, bill number, payer and any information you entered in the PaidBy field when posting the payment. | ||
+ | {{: | ||
====Distribution Report==== | ====Distribution Report==== | ||
In order to create one of these reports you must enter the start and end dates that you entered the receipts in the program and the tax authority, county, municipal or school. It is important to remember the ending date of the report you submit so that you do not overlap or leave a time gap the next time you run the report. Using an incorrect date could result in under or over remitting taxes. This system allows the tax collector to collect taxes for two different payment periods at the same time and to remit them together. These reports show the payer’s name and bill number along with the amounts to remit to the respective taxing bodies grouped by bill type and payment period in bill number order. Voids appear as negative numbers on the distribution report for the void date. This means that if a check fails to clear after remitting the payment to the taxing authority, the program will reduce total amount to remit on a subsequent report by the amount of the returned payment. | In order to create one of these reports you must enter the start and end dates that you entered the receipts in the program and the tax authority, county, municipal or school. It is important to remember the ending date of the report you submit so that you do not overlap or leave a time gap the next time you run the report. Using an incorrect date could result in under or over remitting taxes. This system allows the tax collector to collect taxes for two different payment periods at the same time and to remit them together. These reports show the payer’s name and bill number along with the amounts to remit to the respective taxing bodies grouped by bill type and payment period in bill number order. Voids appear as negative numbers on the distribution report for the void date. This means that if a check fails to clear after remitting the payment to the taxing authority, the program will reduce total amount to remit on a subsequent report by the amount of the returned payment. | ||
- | ====Export | + | {{: |
+ | ====Export | ||
These processes create files containing receipt information that corresponds to he Disbursement Report. When you export data, the program will ask you the start and end dates to export. The program will create this file in the TaxCollection folder for this tax year and your designated Export Drive, if it is different than C. The county export file will have the name County## | These processes create files containing receipt information that corresponds to he Disbursement Report. When you export data, the program will ask you the start and end dates to export. The program will create this file in the TaxCollection folder for this tax year and your designated Export Drive, if it is different than C. The county export file will have the name County## | ||
+ | {{: | ||
====New Bills==== | ====New Bills==== | ||
After you click this button, the program will prompt you for a start and end date and a tax type. It will then create a file containing the bills that you created between the specified dates. The program will name the file for the county NewBillsXXMuniYYYYMMDD.txt and the file for the school NewBillsXXSchoolYYYYMMDDZ.txt where XX is your district number, Z is the school district letter and YYYYMMDD is the ending date. When the export is complete, the program will display a report showing the bills stored in the file. It is important that the treasurer and schools have your new bills before they receive payments for those bills. If you always Export Payments and Export New Bills at the same time with the same start and end dates, you will have fewer dates to keep track of and the taxing bodies will always have the bills ahead of the payments. This export only exports the bills the tax collector creates, the ones numbered 20, | After you click this button, the program will prompt you for a start and end date and a tax type. It will then create a file containing the bills that you created between the specified dates. The program will name the file for the county NewBillsXXMuniYYYYMMDD.txt and the file for the school NewBillsXXSchoolYYYYMMDDZ.txt where XX is your district number, Z is the school district letter and YYYYMMDD is the ending date. When the export is complete, the program will display a report showing the bills stored in the file. It is important that the treasurer and schools have your new bills before they receive payments for those bills. If you always Export Payments and Export New Bills at the same time with the same start and end dates, you will have fewer dates to keep track of and the taxing bodies will always have the bills ahead of the payments. This export only exports the bills the tax collector creates, the ones numbered 20, | ||
- | ====Assessment Report==== | ||
- | This report produces a list of changes made between two specified dates for reporting to the Assessor’s office. These include changes of name and address and deletion and exoneration requests. Do not report changes made from Transfer Listings or letters sent by the Assessor’s office. See the section titled Changing Bill Information for more information on including items in this report. When the program produces this report it also creates a file named AssessorDDYYYYMMDD.txt in the TaxCollection folder for this tax year which contains the same information. Wayne County tax collectors should send this file to the Assessment Office. | ||
- | ====Treasurer Report==== | ||
- | This report produces a list of all changes made between two specified dates that affect the amount of tax the taxing bodies should expect to receive. Send the municipal Treasurer’s report to the office responsible for receiving your county taxes and the school Treasurer’s report to the School Districts. The Treasurer’s Report will include bill amount changes so it is important that they receive it before they receive the payments for the effected bills. If you send these reports in each time you do a distribution, | ||
- | |||
- | ====Check Lookup==== | ||
- | This provides a way to lookup a payment based on the check number used to pay it. | ||
+ | {{: | ||
====Return Report==== | ====Return Report==== | ||
This report lists all of the unpaid tax bills as separate reports for the county, municipality and school district. You can run separate reports for real estate and per capita. You also have an option to put the taxpayer’s address on the report. Which reports you need to create and in which formats depends on the reporting requirements of your taxing districts. The prompts for this report include a receipt cutoff date. When printing the list of unpaid bills the program will only consider receipts up to and including the cutoff date. This will allow you to create the same report as you did at an earlier date even after you post additional payments. The bills for which you have requested exoneration, | This report lists all of the unpaid tax bills as separate reports for the county, municipality and school district. You can run separate reports for real estate and per capita. You also have an option to put the taxpayer’s address on the report. Which reports you need to create and in which formats depends on the reporting requirements of your taxing districts. The prompts for this report include a receipt cutoff date. When printing the list of unpaid bills the program will only consider receipts up to and including the cutoff date. This will allow you to create the same report as you did at an earlier date even after you post additional payments. The bills for which you have requested exoneration, | ||
When you create the Return Report the program will also export the data to a CSV (text) file. When it completes it will display a message box with the location and name of the file. CSV files can be opened by a variety of programs including Excel which may be helpful to some users. | When you create the Return Report the program will also export the data to a CSV (text) file. When it completes it will display a message box with the location and name of the file. CSV files can be opened by a variety of programs including Excel which may be helpful to some users. | ||
+ | \\ \\ | ||
====Tax Claim Return==== | ====Tax Claim Return==== | ||
Line 43: | Line 62: | ||
When you close the Tax Claim Summary the program will ask if you want to have lien records created for the ledger. Lien records will bring the final balance on the Monthly Report to zero, reflecting that you have turned the taxes in to Tax Claim. If, for any reason, you do not want the program to create the lien records then click No. | When you close the Tax Claim Summary the program will ask if you want to have lien records created for the ledger. Lien records will bring the final balance on the Monthly Report to zero, reflecting that you have turned the taxes in to Tax Claim. If, for any reason, you do not want the program to create the lien records then click No. | ||
+ | {{: | ||
====Late Notice==== | ====Late Notice==== | ||
This process creates a late notice for each unpaid bill. You may create late notices for real estate bills, per capita/ | This process creates a late notice for each unpaid bill. You may create late notices for real estate bills, per capita/ | ||
Line 48: | Line 68: | ||
If a taxpayer owns multiple parcels the program will combine the bills onto a single notice. It will not combine real estate bills with per capita/ | If a taxpayer owns multiple parcels the program will combine the bills onto a single notice. It will not combine real estate bills with per capita/ | ||
- | ====Transfer School Taxes==== | + | ====Check Lookup==== |
- | This process is used only by some School Districts in Adams County. Please contact your school district to determine whether or not to perform the transfer. If you are going to perform the Transfer School Tax process you must do it before importing your regular school tax file. This process will transfer unpaid school taxes with a mail date after the first of the year from the current file to the file for the following year. For instance if you are transferring unpaid school bills from the 2009 file to the 2010 file you would open the 2009 file and click on Transfer School Taxes. The program will prompt you for a date. All unpaid bills and any bills paid on or after the date you enter, with a Mail Date after the first of the year, will be copied | + | This provides |
- | Normally this transfer will take place immediately after unpaid taxes are turned in to Tax Claim so your records should match the school district’s records. It is especially important that you coordinate | + | {{: |
+ | ====Assessment Report==== | ||
+ | This report produces a list of changes made between two specified dates for reporting | ||
+ | {{: | ||
+ | ====Treasurer Report==== | ||
+ | This report produces a list of all changes made between two specified dates that affect the amount of tax the taxing bodies should expect to receive. Send the municipal Treasurer’s report to the office responsible for receiving your county taxes and the school Treasurer’s report to the School Districts. The Treasurer’s Report will include bill amount changes so it is important that they receive it before they receive the payments for the effected bills. If you send these reports in each time you do a distribution, | ||
+ | |||
+ | {{: | ||
====Misc Change Form==== | ====Misc Change Form==== | ||
This form allows you to report changes not related to a bill. For example if you identify a new resident you can report their name and address on this form. The program will report these changes on the Assessment Report. | This form allows you to report changes not related to a bill. For example if you identify a new resident you can report their name and address on this form. The program will report these changes on the Assessment Report. | ||
+ | \\ \\ \\ | ||
+ | |||
+ | ====Transfer School Taxes==== | ||
+ | This process is used only by some School Districts in Adams County and Montgomery County. Please contact your school district to determine whether or not to perform the transfer. If you are going to perform the Transfer School Tax process you must do it before importing your regular school tax file. | ||
+ | |||
+ | This process will transfer unpaid school taxes with a mail date after the first of the year from the current file to the file for the following year. For instance, if you are transferring unpaid school bills from the 2009 file to the 2010 file you would open the 2009 file and click on Transfer School Taxes. The program will prompt you for a date. All unpaid bills and any bills paid on or after the date you enter, with a Mail Date after the first of the year, will be copied to the 2010 file. If you only want to transfer unpaid bills leave the date blank. If you have chosen to copy any paid bills, their receipts will also be copied to the new file so they will still be marked as paid. | ||
+ | |||
+ | The program will also create starting balance ledger entries for the total of the bills transferred in the new file and deduction records in the old file. If you have already created collection records for the paid bills in the old file you will have to create them again in the new file. After you have transferred the taxes to the next year you will be unable to accept payments for them in the old year. | ||
+ | |||
+ | If you transfer the unpaid taxes to the next year and they remain unpaid they will be turned in to Tax Claim when you do the return for that year. If you do not transfer them, you will need to create a Tax Claim return from both files. | ||
+ | |||
+ | Normally this transfer will take place immediately after unpaid taxes are turned in to Tax Claim so your records should match the school district’s records. It is especially important that you coordinate the transfer with your school district as they will have to transfer the records in their system too and we want to ensure that the same records are transferred in each system. | ||
+ | |||
+ | School districts please note that your transfer process works one district at a time. In this way, you can make sure your records match before performing the transfer. It is important that once you have transferred the first district that you do not create or import any new bills until the last district is transferred. This should not be a problem but you need to be aware of it. |