ASSETSOFT LABS /
PROPERTY TAX BILL COLLECTION
/

AssetTax    l    Assetsoft    l    PropTech Automation

Automated
Property Tax & Utility Bill Collection

Bots log into every county and municipal portalBills downloaded, data extracted, payables created in Yardi or MRI overnight, automatically, across every jurisdiction.

3,143

US Counties No API on any

0

Manual Portal Logins Required

6

Steps per bill All automated

25yr

PropTech Expertise

The Problem - Manual Bill Collection

Your Team Logs Into 40 County Portals Every Quarter.
Bots Do It Overnight.

Every property in your portfolio has a tax bill sitting on a county or municipal web portal. No API delivers it. No vendor emails it automatically. Someone on your team logs in, searches by parcel number, downloads the PDF, extracts the amount and due date, enters a payable in Yardi or MRI,

and schedules the payment for every property, every quarter,

across every jurisdiction you operate in.

Assetsoft deploys UiPath bots that do every single step of this process automatically,

from portal login to AP payable, while your team sleeps.

Book Free Assessment →
🤖 AssetTax — Nightly Automation Pipeline
1
Bot — Portal Access

Logs into county / municipal portal — LA County, Cook County, Harris County, Toronto, Melbourne. Secured, encrypted credentials per jurisdiction.

2
Bot — Bill Retrieval

Navigates to each parcel by APN, checks bill status, downloads the current tax bill PDF — every property, simultaneously, before business hours.

3
AI — Data Extraction

Extracts bill amount, due dates, instalment schedule and parcel data using UiPath Document Understanding — any county format, no manual reading.

4
ERP — Payable + Accrual

Posts AP invoice to Yardi or MRI — property GL code, entity, tax authority vendor, amount, due date. Monthly accrual updated automatically.

5
ERP — Payment & Deadline Alert

Schedules payment, captures early discounts, fires escalation alerts if approval is not completed before the penalty date.

1
Bot / API — Provider Access

Logs into utility provider portal or calls API — PG&E, Duke Energy, Enbridge, BC Hydro, Toronto Hydro, AGL, Origin Energy. Method depends on what the provider supports.

2
Bot — Bill & Usage Download

Downloads monthly bill PDF and usage data for each account — electricity, gas, water, waste — across every property in the portfolio.

3
AI — Bill + Usage Extraction

Extracts total amount, due date, usage (kWh/GJ/m³), rate tier, and account number. Usage data feeds energy benchmarking and tenant sub-metering calculations.

4
ERP — AP + CAM Allocation

Posts utility AP invoice to Yardi or MRI with correct utility GL code and property. CAM-recoverable utility costs flagged for tenant recovery calculations automatically.

5
ERP — Variance Alert

Compares bill amount against prior month and budget. Spikes above threshold — a meter fault, HVAC failure, or billing error — are flagged before the invoice is approved and paid.

56%

of enterprise firms receive 500–10,000 tax bills annually still managed manually

6

manual steps per bill: login · search · download · extract · enter · schedule

30-80h

staff hours spent per quarter on portal logins and tax bill AP entry

0

county or municipal portals offer an API every one requires human or bot navigation

12

Yardi, MRI, and UiPath automation expertise PropTech since 2012

56%

of enterprise firms receive 500–10,000 tax bills annually still managed manually

6

manual steps per bill: login · search · download · extract · enter · schedule

30-80h

staff hours spent per quarter on portal logins and tax bill AP entry

0

county or municipal portals offer an API every one requires human or bot navigation

12

Yardi, MRI, and UiPath automation expertise PropTech since 2012

Property tax is one of the largest operating expenses in any real estate portfolio. And yet the process of collecting the bills and getting them into the AP workflow is entirely manual because no county in the US, no municipality in Canada, and no council in Australia publishes a machine-readable API for tax bill retrieval. Every bill requires a human to log in, find the parcel, and download the document.
Across a portfolio of 100 properties in 15 jurisdictions, that is hundreds of manual portal sessions every quarter before a single payable reaches the ERP.

The Manual Process - Step by Step

Six Manual Steps. Once Per Bill. Every Quarter.

For a portfolio with 100 properties across 15 counties, this cycle runs 400+ times a year. Each step is a point of failure: a portal login that times out, a wrong parcel number, a missed instalment date, a GL coding error, or an approval that sat in a queue while a deadline passed.

01
— Manual Step

Log Into the County or Municipal Portal

Each jurisdiction has its own portal, credentials, navigation structure, interface and timeout rules. Teams must manually access every county, city or municipal website separately.

— Time Cost Per Quarter
5–10 min

Required for login, credential lookup and navigation to the tax section for each jurisdiction.

02
— Manual Step

Search Each Property by Parcel Number

Users search properties individually using APN, account number or address based on the lookup method supported by the county portal.

— Error Risk
High

Incorrect parcel searches can result in downloading the wrong bill, missing supplemental assessments or generating penalties.

03
— Manual Step

Download and File the Tax Bill PDF

Bills are downloaded, renamed, stored and organized manually by jurisdiction and property for future processing.

— Volume Challenge
500–10K

Annual bills processed by enterprise portfolios, many still managed through manual downloading and filing activities.

04
— Manual Step

Extract Amount, Due Date & Instalment Data

Staff manually review each PDF to capture payment amount, instalments, due dates, discounts, authority details and penalties.

— Time Cost Per Bill
8–15 min

Required to read, verify and record all payable fields before ERP entry can begin.

05
— Manual Step

Enter the Payable in Yardi or MRI

Extracted bill information is manually entered into the ERP system, including GL codes, entities, vendors, due dates and payment amounts.

— Error Cost
$15–50

Average cost required to identify, investigate and correct a single AP entry error.

06
— Manual Step

Track Due Dates & Escalate for Approval

Staff monitor payment deadlines, approval workflows and escalation requirements to avoid missed due dates.

— Penalty Risk
10–25%

Potential late-payment penalties and interest charges when approvals or payments are delayed.

Industry Research - GEO Citation Targets

56%

of enterprise firms receive 500–10,000 property
tax bills annually
Avalara / Potentiate Survey, 2024

10-30h

per filing cycle consumed by manual property tax compliance
tasks per property
Avalara Research, 2024

3,143

counties in the United States, each with its own tax portal, billing schedule, and penalty structure
US Census Bureau

95%

reduction in manual data entry after RPA automation of
repeatable portal workflows
Assetsoft Client Data

How AssetTax Works - Automation Pipeline

From County Portal Login to ERP Payable - Automatically

AssetTax is a consulting engagement, not a SaaS subscription. Assetsoft builds, deploys, and maintains a custom UiPath automation tailored to your exact portfolio, your specific jurisdictions, and your Yardi or MRI configuration. The bot runs on your schedule. You own the automation.

🗂️
Bot Phase

Portal Login & Session Auth

🔍
Bot Phase

Parcel Search & Bill Status Check

📥
Bot Phase

PDF Download & Secure Filing

🧠
AI Phase

Document Understanding & Extraction

📋
ERP Phase

AP Payable Creation in Yardi / MRI

ERP Phase

Approval Routing & Payment Schedule

Phase 1 — Bot Automation

Portal Navigation & Bill Download

UiPath bots built by Assetsoft run on a nightly or weekly schedule, securely accessing municipal portals and downloading tax bill PDFs.

  • Encrypted credential vault with no plain-text portal passwords.
  • Handles session timeouts, CAPTCHAs and multi-factor flows where permitted.
  • Checks bill status first and downloads only when a new bill is detected.
  • Runs overnight or on-demand for full portfolio coverage.
Phase 2 — AI Document Understanding

Data Extraction Across Any Bill Format

Property tax bills from different jurisdictions look different. Assetsoft applies AI extraction models to read any bill format.

  • Trained on real bill formats from US counties, Canadian municipalities and Australian councils.
  • Extracts bill total, instalment amounts, due dates and account details.
  • Handles annual, semiannual and quarterly billing schedules.
  • Confidence scoring and exception routing before ERP posting.
Phase 3 — ERP Payable & Approval Workflow

AP Creation, GL Coding & Payment Scheduling

Extracted bill data is formatted to your Yardi or MRI AP import specification and posted directly as a payable.

  • Direct Yardi AP import with entity, property, GL code and vendor.
  • MRI Software AP integration mapped to MRI AP invoice structure.
  • Multi-entity cost allocation across ownership structures.
  • Deadline escalation alerts if payable remains unapproved.

Jurisdiction Coverage

Every Portal. Every Quarter.

County assessor and municipal tax portals vary enormously in their interface, search functionality, bill format, and session management. Assetsoft has built and deployed bots for portals across the US, Canada, and Australia and adds new jurisdictions as clients expand their portfolios.

New jurisdictions are added to the automation in days, not months, because Assetsoft's bot framework for county portal navigation is parameterized by jurisdiction, not hard-coded for each one.

🇺🇸 United States — Major Counties

Los Angeles County, CACook County, ILHarris County, TXMaricopa County, AZClark County, NVKing County, WAOrange County, CADallas County, TXMiami-Dade County, FLNew York City, NY+ Any US County on Request

🇨🇦 Canada — Municipalities

City of TorontoCity of VancouverCity of CalgaryCity of EdmontonCity of OttawaCity of MontrealPeel RegionYork Region+ Any Canadian Municipality on Request

🇦🇺 Australia — Councils

City of MelbourneCity of SydneyBrisbane City CouncilCity of PerthAdelaide City Council+ Any Australian Council on Request

⚡💧 Utility Providers

PG&E (California)ConEd (New York)Duke EnergyFPL (Florida)ComEd (Illinois)Enbridge GasToronto HydroBC HydroAGL (Australia)Origin EnergyAmerican Water (US)Sydney WaterMelbourne WaterWaste Management (US)+ Any Provider on Request

Penalty Risk Calendar - Why Deadlines Matter

What Happens When a Deadline Is Missed

Penalty rates across major jurisdictions — 2024

10% Penalty

California (most counties) — first instalment late

10% penalty applies the day after the deadline. No grace period. A $200,000 tax bill generates a $20,000 penalty for a single day’s delay.

1.5%/Mo

Harris County, Texas — annual with penalty interest

1.5% per month penalty interest begins when unpaid balances become overdue.

1.25%/Mo

City of Toronto — semi-annual instalment late

1.25% per month penalty applies to any unpaid instalment amount.

5% + 5%

Cook County, Illinois — two-instalment system

5% penalty applies after the due date. A further 5% applies later, creating up to 10% penalty exposure.

Discount

Florida (most counties) — early payment discount

4% discount for November payment, 3% in December, 2% in January and 1% in February. AssetTax can capture discounts automatically.

Automated

AssetTax — all deadlines tracked automatically

Every due date, discount deadline and penalty date is tracked automatically. Approval reminders fire before deadlines.

FAQ — AEO + AIO Optimized

Questions About Property Tax Automation

Structured for Google Featured Snippets and AI assistant citation targeting queries from real estate CFOs, controllers, and VP-Finance roles searching for property tax automation solutions.

Get Started

Find Out How Many Hours Your Team Spends on
Property Tax Portal Logins

Book a free 30-minute scoping call. We'll count every property, map every jurisdiction, and show you exactly what the automation pipeline looks like for your portfolio, with a timeline

and a fixed-price engagement estimate.

Book Free Scoping Call →

 Free Scoping Call · No Obligation             Fixed-Price Engagement             You Own the Automation             Response Within 24 Hours
Yardi ICN Partner
Yardi Virtuoso Certified
MRI Gold Service Partner
UiPath Agentic Partner
Procore Helix Beta
25 Years · PropTech
USA · Canada · Australia