Distribution Report

Last Updated  July 14, 2021

 

The Distribution report can be run in either Summary or Detail mode.  The data should match the TCS297F report.

The Detail version shows the amount of funds due and then disbursed to each unit for each year specified.  The report displays, for each jurisdiction, the year (current or delinquent), levy collected, penalty and interest collected, miscellaneous fees collected, TIF collected, total collections (this include refunds), the amount of commission taken out before disbursement, the net payable (net collections minus commission), and the amount actually disbursed, and the balance due (net payable minus disbursed amount).  At the end of the report is a summary of the current tax year disbursements for each unit. If run with a page break between each unit's data, a page of totals for current year, prior years, and the sum of current and prior years is also provided.

The Summary version of this report displays only the amounts disbursed to each unit and attorney.  It always gives the total of all years disbursed.  For each unit, a breakdown of levy, penalty and interest, miscellaneous fees, commissions, disbursed amounts, and balance is given. Grand totals are given at the end.

A CSV file is created when the Load Type is set to Property Tax and this is run in Summary mode.

The Grand Totals on the 297F report [Attorney + TIF + Other Fees - Refund + Disburse Total (the disburse total is Current Year Total + Prior Year Total)] will equal the Distribution Summary and Detail reports' grand total for Total Collections (Levy Paid + Penalty Interest + Fees + TIF).

Users must be assigned the GLTAXLEDGE_FOUNDATION role and the user entitlements TAXLEDGE_REPORTS and GLRPTJURISDICTION_REPORT in the Tax Collection System to run this report.

To run a Distribution report:

  1. Open TaxLedge and log in.
  2. On TaxLedge’s Main Menu bar, select Reports, then select Distribution Report. The parameter screen will be displayed.
  3. Click on the Load Type drop-down menu and choose the type of file for which you want to see data: Property Tax, VIT Fines/Penalties, VIT NSF,VIT Overpayment, or VIT Penalty/Interest.
  4. Click either the Detail or Summary radio button, depending on which version of the report you want.
  5. Enter the beginning and ending dates of the Deposit Date Range you want to include on the report.
  6. If you are printing the detail report and you want data for all years on the report, leave the Number of Years field blank, otherwise enter a specific number of years (for ex., 1, 2, or 3).  The years shown on the report will then include the current year and prior years (for ex., if you enter 3 and the current tax year is 2004, the report will include data for 2004, 2003, and 2002).

For the Summary report, leave this field blank.

  1. Click the check box next to Page Break at Tax Unit if you want a new page for every tax unit.
  2. If you are running the report in Detail mode, and you also checked Page Break at Tax Unit, you must next choose of the radio buttons:
  • Create a Single File for All Tax Units - one file is created, with a page break between each tax unit
  • Create Separate Files for Each Tax Unit - a separate .pdf file is created for each tax unit
  1. Check the Show Current/Delinquent Breakdown box to see a split between current and delinquent amounts for the current year. To have the current year in one row, do not check this box.
  2. Enter the number of copies needed in the Number of Copies field.
  3. If you are printing the detail report and you want data for just some of the units, uncheck the All Tax Units box, highlight one of the units you want, then click the right arrow button ()  Continue selecting the units that you want on the report. You can also select the units for a particular attorney by selecting the attorney name in the field above the tax units, then clicking Select.. Continue selecting the individual units that you want on the report.
  4. Click Print.
  5. If your tax office wants, the reports can be tracked on the batch menu. A popup window will appear after you click Print that gives you the batch request sequence number. Contact ACT if you want this feature. PDF and text files are created.