Monthly income check

Compares rent and household data with income statements (PDF) and reports discrepancies.

Overview

Every month, rent and household data must match the income statements. This automation exports the data, locates the statement PDF for each unit, extracts the values, and compares them against the source. Matches, discrepancies, and input issues are compiled into separate logs and emailed.

What has changed

  • Eliminates repetitive manual checks
  • The check is performed the same way every month
  • Auditable logs show successful checks, discrepancies, and input issues

At a glance

SECTOR:
Housing and property management
System:
Dynamics 365 Business Central, eContent, Excel, email
RUNS:
Monthly
Technique:
Rule-based

In één oogopslag

SECTOR:
Housing and property management
Systeem:
Dynamics 365 Business Central, eContent, Excel, email
RUNS:
Monthly
Techniek:
Rule-based

Overzicht

Every month, rent and household data must match the income statements. This automation exports the data, locates the statement PDF for each unit, extracts the values, and compares them against the source. Matches, discrepancies, and input issues are compiled into separate logs and emailed.

Wat er verandert

  • Eliminates repetitive manual checks
  • The check is performed the same way every month
  • Auditable logs show successful checks, discrepancies, and input issues

How it works.

Business Central rental data
Unit 12Adone
Unit 14Bdone
Unit 17Crunning
Reporting period set
Monthly
Y
Yara reads
every PDF
Comparison rent, income, household
Unit 12Amatch
Unit 14Bmatch
Unit 17Cmismatch
Mismatches logged
The output files come by email.

What it does per property

  1. Determines the reporting period
  2. Exports rent data from Business Central
  3. Locates the corresponding income statement PDF for each unit in the document system
  4. Extracts rent, income, and household size from the PDF
  5. Compares the values with the source and logs discrepancies and input issues
  6. Emails the output files

Rules

The reporting period is the previous month, unless a date range is specified, and the month determines whether the live environment or the archive is used. Extracted values are compared with the source, and any difference or unreadable document is logged. Because the logic is fixed, the same input always yields the same result, and every run is logged.

Frequently asked questions.

Do we need to change our system?

No. The digital colleague works in the screens and systems your team already uses, whether they are legacy applications without an API or modern ones, so there is nothing to replace.

Who builds and maintains the automation?

Yarado builds it, runs it and monitors it. When a screen or a system changes, we adjust the automation, so your team needs no developer or automation skills of its own.

Can we see what it did?

Yes. Every run is recorded in the Yarado portal, where you can see which processes ran, when they last ran, what they produced and what went wrong. Depending on the automation, the processing log is also emailed to the team that needs it.

What happens if something goes wrong?

Yarado monitors every run and is alerted automatically when one fails, so a problem is picked up on our side. Cases that need a person are reported to your team with the reason, in the portal or by email.

Can it work for our process, even if it differs from this example?

Yes. Automations are built around your own steps and systems, and this page is just one example of what is possible. A first automation is typically live in weeks, not months.

Process not found?

Don't see your process listed? Let us know. We'll start with an automation scan to see what can be automated.