9 topics in 90 minutes
This presentation is the property of its rightful owner.
Sponsored Links
1 / 108

9 Topics in 90 Minutes PowerPoint PPT Presentation


  • 128 Views
  • Uploaded on
  • Presentation posted in: General

9 Topics in 90 Minutes. Tax Lien Transfers. Tax lien transfers in ACT Reporting Senate Bill 247. Tax Lien Transfers In ACT. Client request to streamline current manual lien transfer process Reduce clerk input errors Improve efficiency

Download Presentation

9 Topics in 90 Minutes

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


9 topics in 90 minutes

9 Topics in 90 Minutes


Tax lien transfers

Tax Lien Transfers

  • Tax lien transfers in ACT

  • Reporting

  • Senate Bill 247


Tax lien transfers in act

Tax Lien Transfers In ACT

  • Client request to streamline current manual lien transfer process

    • Reduce clerk input errors

    • Improve efficiency

  • Complies with Texas Tax Code, Sec. 32.06. and Texas Administrative Code, Rule 89.702

  • Tax Lien Transfer module added to Online Products

    • Produces certified statement of transfer of tax lien

    • Creates Delinquent Status entry for transfer of lien


Online products transfer of tax lien

Online Products – Transfer of Tax Lien

  • Entitlement

    • ACT_LIEN_TRANSFER – access to Transfer of Tax Lien


Transfer of lien

Transfer of Lien


9 topics in 90 minutes

Certified Statement of Transfer of Lien

  • Client Preferences

    • CPA_NAME_ONLY – Enter name of TAC (without a title or certifications) to appear in the main paragraph.

    • TAX_LIEN_STATEMENT_FOOTER – Address or verbiage wanted on the bottom of the statement.


Delinquent status lien status

Delinquent Status – Lien Status

  • Inserts transfer of lien record and creates note


Delinquent status lien status1

Delinquent Status – Lien Status

  • Release – select Release from drop down

    • New release record inserted and note added


Tax lien transfer report

Tax Lien Transfer Report

  • BMI 673

  • List all accounts on which a lien has been transferred for a specified year.

  • Sort order option – Account, Owner, Date

  • Produces a .csv file for Excel use.


Tax lien transfer report sampl e

Tax Lien Transfer Report – Sample


Sb 247 new requirements

SB 247 – New Requirements

  • Imposes new requirements effective May 29, 2013

    • Judicial foreclosure – requires property tax lenders to use judicial foreclosure

    • Advertising – prohibits false, misleading, or deceptive advertising

      “YOUR TAX OFFICE MAY OFFER DELINQUENT TAX INSTALLMENT PLANS THAT MAY BE LESS COSTLY TO YOU. YOU CAN REQUEST INFORMATION ABOUT THE AVAILABILITY OF THESE PLANS FROM THE TAX OFFICE.”

    • Secondary market – tightens the requirements for the assignment, transfer, or sale of tax liens

    • Payoff statements – requires prompt payoff statements


Sb 247 continued

SB 247 Continued

  • Property tax loans are now prohibited if:

    • The borrower is 65 years or older and can claim a property tax exemption

    • The taxes are neither due nor delinquent and

      • The property is subject to another recorded lien

        OR

      • The property is not subject to another recorded lien

  • Additional provisions:

    • Truth in lending disclosure requirements

    • Prohibits lenders from funding subsequent year’s taxes without borrower consent


9 topics in 90 minutes1

9 Topics in 90 Minutes

TNT Update


Sb656

SB656

  • Effective September 1, 2013

  • Concerns adoption of budgets for all taxing entities (except school districts)

  • A vote to adopt the budget must be a record vote.

  • An adopted budget must contain a cover page that includes one of the following statements in 18-point or larger type that accurately describes the adopted budget:


Sb6561

SB656

  • (A)  "This budget will raise more revenue from property taxes than last year's budget by an amount of (insert total dollar amount of increase), which is a (insert percentage increase) percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is (insert amount computed by multiplying the proposed tax rate by the value of new property added to the roll).";

  • (B)  "This budget will raise less revenue from property taxes than last year's budget by an amount of (insert total dollar amount of decrease), which is a (insert percentage decrease) percent decrease from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is (insert amount computed by multiplying the proposed tax rate by the value of new property added to the roll)."; or

  • (C)  "This budget will raise the same amount of revenue from property taxes as last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is (insert amount computed by multiplying the proposed tax rate by the value of new property added to the roll).";


Sb6562

SB656

  • Adopted budget cover page must also include:

    • the record vote of each member of the commissioners court by name voting on the adoption of the budget;

    • the county property tax rates for the preceding fiscal year, and each county property tax rate that has been adopted or calculated for the current fiscal year, including:

      • (A)  the property tax rate;

      • (B)  the effective tax rate;

      • (C)  the effective maintenance and operations tax rate;

      • (D)  the rollback tax rate; and

      • (E)  the debt rate; and

    • the total amount of county debt obligations.


Sb6563

SB656

On final approval of the budget, entities must:

  • (1)  file a copy of the budget; and

  • (2)  if the entity maintains an Internet website, take action to ensure that:

    • a copy of the budget, including the cover page, is posted on the website;

    • the record vote is posted on the website at least until the first anniversary of the date the budget is adopted


9 topics in 90 minutes

SB1510

  • Effective January 1, 2014

  • Pertains only to counties and municipalities

  • Does not apply to hospital districts, ESDs, etc.

  • Removes the requirements for publishing the Notice of Effective Tax Rate and the Notice of Tax Revenue Increase

  • Updates the format for the Notice of Public Hearing-different for entities adopting a rate above the RTR or ETR

  • Replaces the Small Taxing Unit Notice


New notice of proposed property tax rate tax rate below etr rtr

New-Notice of Proposed Property Tax RateTax Rate Below ETR & RTR


New notice of proposed property tax rate tax rate above etr or rtr

New-Notice of Proposed Property Tax RateTax Rate Above ETR or RTR


Sb1510

SB1510

  • The new Notice of Proposed Property Tax Rates must be:

    • published in a newspaper with general circulation in the county or municipality, or

    • mailed to each property owner in the county or municipality

    • posted on website of the county or municipality by September 1


Questions

Questions?


9 topics in 90 minutes new feature suits by jurisdiction

9 Topics in 90 minutes New Feature:Suits by Jurisdiction!


The advantage

The Advantage….

  • Dallas County has been using a similar process for several years nowso the process is proven.

  • Allows the user to determine exactly which years are included in the suit without the need to read a user note or decipher a cryptic cause number

  • With the double click of a mouse the user can see:

    • The taxing unit(s) involved in the suit

    • The law firm that represents that taxing unit

    • The status of each taxing unit’s portion of the suit

    • And if the filing type is the original filer or an intervener


The advantage cont

The Advantage (cont)….

  • Use BMI 638, Process LGBS Lawsuit File, and the system will do all the work.

  • Or use the Delinquent Status screen to manage your suits and “you”do the work.

  • The suit roll forward process at the beginning of the tax year does NOT roll forward the “by jurisdiction” details. When the suit file is processed in February, the details for the new year’s suit information will be available.


The setup

The Setup….

  • Client pref SET_LEGAL_STATUS_BY_YEAR must be set to ‘Y’

  • Client pref SUITS_BY_JURISDICTION must be set to ‘Y’

  • Version 2 security user entitlement, CHANGE_LAWSUIT_BY_YEAR, must be granted to each user that you want to allow to create or update the jurisdiction associated to each suit via the Delinquent Status screen.


The sting

The Sting….

E = Edit

U= Update

The request sequence from your Edit run (only required in update mode)

The accounts in the file will not be updated if this code does not match the county code associated to the account on Account Master (see next slide for Account Master). You may or may not enter this parameter depending on how suits are traced by the law firm’s delinquent system.

Law firm that provided the file to process (optional).


The sting cont

The Sting (cont)….

The county code must match that entered in BMI 638 in order for the account to be updated by that program and visible in Delinquent Status.


The end game

The End Game….

The year the suit began

The Operator ID shows the BMI 638 automated process


The end game cont

The End Game (cont)….

The year the suit began

Taxing unit Involved

Attorney that represents the taxing unit

Filing Type


Suits by jurisdiction

Suits by Jurisdiction

Let ACT help you maintain accurate suit information! 

Any Questions?

Thank you for your attention.


9 topics in 90 minutes act statement log

9 Topics in 90 MinutesACT Statement Log

ACT records information about every batch and online statement that it generates.


Act statements

ACT Statements


Statement log data

Statement Log Data


Statement log columns

Statement Log Columns


Batch statements

Batch Statements


Online statements

Online Statements


Accessing the log

Accessing the Log


Statement log window

Statement Log Window


Deleting log entries

Deleting Log Entries


Conclusion

Conclusion

  • ACT automatically logs every statement

  • ACT provides integrated access to the log

  • ACT allows deletion of sets of log entries


Account summary account history and payment history

Account Summary, Account History and Payment History

Roy Seaman

June 20, 2013


Account summary report

Account Summary Report

  • The Account Summary Report is designed to give a summary of a given account. It includes levy, levy balance, P&I due, attorney fees, payment date of last payment, total amount paid and balance due.

  • It is broken down by year and jurisdiction, and gives a total balance due at the bottom as well as a payment amount due for the following 3 months.


Account summary report quarter account

Account Summary Report – Quarter Account

P&I is dictated by amounts due in each quarter


Account summary report multi jurisdiction

Account Summary Report – Multi-Jurisdiction

Broken down by year and jurisdiction


Account history report

Account History Report

  • This report lists payment activity and appraisal district changes for a specified account.  The data is shown for each rec type, year, and tax unit, although the data can be restricted to a single year or single unit if desired.  If no appraisal district changes have been made for the account, just the certified information will be printed.  Ag rollbacks and quarter pay accounts that have been split are displayed separately from regular tax levy data.  Fees have their own unit number and thus are also shown separately within each rec type.

  • The payment portion of the report lists payments beginning with the most recent one.  The payments are sorted by validation number.  The following information is shown in this portion of the report:  year, tax unit, rec type (TL, OS, etc.), deposit number, validation number, remit sequence number, deposit and receipt dates, paid levy, discount, penalty, interest, collection fees, refund, variance, total paid, and fiduciary number (payer).  If no payments have been made for a particular year, unit, and rec type, a message to that effect will be printed on the report. This part is sorted in descending chronological order.


Account history report1

Account History Report

  • The Certified Owner will always be the owner for the current tax year.

  • For the appraisal district change portions of the report, the following information is provided: rec type, receipt number, gross value, homestead total amount, revision code, HOVDFAER exemption info, exemption amount, taxable value, levy, levy change, date of change, and operator code of the person who made the change.  This part is sorted in descending chronological order.

  • This report is also available from the Payment History screens: a report produced from the Payment Summary screen lists all years and units; a report produced from the Unit Transactions screen shows data only for the year displayed on that screen.

  • Some clients want to have a page print at the end of the report that can be signed and used if refunds are pending.  If you want this page, set the client preference SIGNATURE_YES to Y.  Otherwise, set it to N.  Set the COLLECTOR preference to the name you want to use as the signature on the left side of the page. Set the CPA preference to the name to use on the right side. The title on the right side, under the CPA name, is created by using both the COUNTY_NAME and CPA_TITLE preferences.


Account history report2

Account History Report

Levy change due to adding HOM


Payment history report

Payment History Report

  • The Payment History report contains details of the payments. This report provides data by year, deposit, and tax unit.

  • If you click on the Unit Transactions tab for a given year, then the Payment History and Account History reports will be for that year only. If you click on those buttons on the first tab (Payment Summary) then it will be for all years.


Payment history report1

Payment History Report


33 01 d effective jan 1 1982

33.01(d) (effective Jan 1, 1982)

9 Topics in 90 Minutes


33 01 d

33.01 (d)

  • (d) In lieu of the penalty imposed under Subsection (a), a delinquent tax incurs a penalty of 50 percent of the amount of the tax without regard to the number of months the tax has been delinquent if the tax is delinquent because the property owner received an exemption under:

    • (1) Section 11.13 and the chief appraiser subsequently cancels the exemption because the residence was not the principal residence of the property owner and the property owner received an exemption for two or more additional residence homesteads for the tax year in which the tax was imposed;

    • (2) Section 11.13(c) or (d) for a person who is 65 years of age or older and the chief appraiser subsequently cancels the exemption because the property owner was younger than 65 years of age; or

    • (3) Section 11.13(q) and the chief appraiser subsequently cancels the exemption because the property owner was younger than 55 years of age when the property owner’s spouse died.


33 01 e

33.01 (e)

  • (e) A penalty imposed under Subsection (d) does not apply if:

    • (1) the exemption was granted by the appraisal district or board and not at the request or application of the property owner or the property owner’s agent; or

    • (2) at any time before the date the tax becomes delinquent, the property owner gives to the chief appraiser of the appraisal district in which the property is located written notice of circumstances that would disqualify the owner for the exemption.


33 01 d1

33.01 (d)

  • Receiving the code from the appraisal districts

  • Calculating the 50% ONLY on the amount that was exempted incorrectly


33 01 d2

33.01 (d)

  • ACT recommends communication with your CAD to determine if/how they will communicate these to the tax office.

  • Manually or by trigger table set a stop payment flag on the account and send a manual notice showing the amount due on the account.

  • Post the payment using special payment screen to insert the correct amount into the penalty column.


Using trigger tables

Using Trigger Tables

9 Topics in 90 Minutes


What is trigger table

What is Trigger Table?

  • Table in the Oracle DB which can hold collections of data.

  • The collections are stored by client ID/year/account/fiduciary number.

  • Each collection of data is grouped by a Request Sequence Number,or RSN.

  • Each data set can be further divided with a batch sequence no.


How do you create trigger table collections

How do you create Trigger Table collections?

  • BMI 1057 will load a flat file into the table.

  • Use a scanner to create a flat file to be loaded.

  • Screen in TCS called statement Table.

  • Use Account Search to select accounts.


Using bmi 1057

Using BMI 1057


Using a scanner

Using a Scanner


Using the statement table

Using the Statement Table


Using the account search

Using the Account Search


Now that you have data what can you do with it

Now that you have data, what can you do with it?

On Account Master and Account Status


Editing the select l ist

Editing the Select List


Various screen s can make use of the request seq no

Various Screenscan make use of the Request Seq. No.

  • Payment Process

  • Payment Agreement


Payment process selection of request seq no

Payment Process Selection of Request Seq. No.


After query

After Query


Payment agreement query accounts

Payment Agreement Query Accounts


Payment agreement after import

Payment Agreement After Import


Many batch menu items bmis can use a request seq no

Many Batch Menu Items ( BMIs) can use a Request Seq. No.

For instance,

BMI 605, to

update

bad address

flags...

and

BMI 1009, to

producestatements


Discoverer

Discoverer

  • Intuitive ad-hoc query reporting

  • Analysis

  • Web-publishing tool

  • Empowers business users at all levels of the organization to gain immediate access to information.


Tips for sit

Tips for SIT

Jonathan Martin

June 20, 2013


Tips for sit1

Tips for SIT

We will be highlighting the following features:

  • Multi-Payment Per Month Warning Message

  • Creating a Refund Deposit


Multi payment per month warning

Multi-Payment Per Month Warning

  • When entering payments in SIT, there is a popup that lets us know if a payment for the same month already exists

  • Option to override and add a second payment if necessary

  • Controlled by a client pref (SIT_MULTIPAYMENT_ALERT)


Multi payment per month warning1

Multi-Payment Per Month Warning

  • Select Maintenance tab


Multi payment per month warning2

Multi-Payment Per Month Warning

  • Select System Configuration


Multi payment per month warning3

Multi-Payment Per Month Warning

  • Press F7 to ensure you are in 'search'mode

  • Enter client pref ‘SIT_MULTIPAYMENT_ALERT’ in Code


Multi payment per month warning4

Multi-Payment Per Month Warning

  • Press F8 to execute query

  • Ensure client pref set to ‘Y’


Multi payment per month warning5

Multi-Payment Per Month Warning

  • Payment Entry screen

  • Select month ‘Feb’, which already had a $0 amount posted


Multi payment per month warning6

Multi-Payment Per Month Warning

  • Select ‘Apply’

  • Popup displays


Multi payment per month warning7

Multi-Payment Per Month Warning

  • Displays warning message

  • Option to continue


Multi payment per month warning8

Multi-Payment Per Month Warning

  • Account Status/Detail

  • If selected ‘Yes’, 2ndpayment is displayed for Feb.(02)


Creating a refund deposit in sit

Creating a Refund Deposit in SIT

  • Create/verify refund tax units in Tax Unit Maintenance

  • Make sure that the refund amount has been transferred from the payment tax unit (unit 94) to the correct refund unit (the overpayment unit is 8060)

  • Create Refund deposit


Creating a refund deposit in sit1

Creating a Refund Deposit in SIT

  • Select Tax Unit Maintenance


Creating a refund deposit in sit2

Creating a Refund Deposit in SIT

  • Tax Unit 8060 for Owner Refunds has been created


Creating a refund deposit in sit3

Creating a Refund Deposit in SIT

  • Displays escrow/refund amount of $89.16


Creating a refund deposit in sit4

Creating a Refund Deposit in SIT

  • Select Transfer Deposit


Creating a refund deposit in sit5

Creating a Refund Deposit in SIT

  • Select the Col/Tax Unit Transfer tab


Creating a refund deposit in sit6

Creating a Refund Deposit in SIT

  • Select the ‘Tax Units’ button and popup is displayed

  • Select 8060 for Owner Refund


Creating a refund deposit in sit7

Creating a Refund Deposit in SIT

  • Enter same amount in Move & Receive ($50)

  • Then select ‘Apply’


Creating a refund deposit in sit8

Creating a Refund Deposit in SIT

  • Confirmation popup is displayed


Creating a refund deposit in sit9

Creating a Refund Deposit in SIT

  • Account Status/Detail displays transfer to refund unit


Creating a refund deposit in sit10

Creating a Refund Deposit in SIT

  • Select Refund/Disbursement


Creating a refund deposit in sit11

Creating a Refund Deposit in SIT

  • Enter deposit info,then select ‘Refund Transaction’


Creating a refund deposit in sit12

Creating a Refund Deposit in SIT

  • Form is in query mode

  • Enter account number,then press F8


Creating a refund deposit in sit13

Creating a Refund Deposit in SIT

  • Displays refund with an ‘TI’ status

  • Selected ‘Include’,then ‘Refund Process’


Creating a refund deposit in sit14

Creating a Refund Deposit in SIT

  • Status was updated to ‘RF’


Creating a refund deposit in sit15

Creating a Refund Deposit in SIT

  • Account Status/Detail displays refund deposit

  • Is ready to be disbursed


Checkbook view

Checkbook View


Launches from any tcs form

Launches from any TCS form


B rowser app

Browser App.


Drill down

Drill Down


Transactions types vary from year to year

Transactions types vary from year to year


More drill down

More Drill Down


A name change

A Name Change


Transaction log

Transaction Log


Report

Report


Spreadsheet

Spreadsheet


  • Login