Automation library
>
Finance
>
Validate invoice export

Validate invoice export

Validates test invoice exports using fixed quality checks and initiates production exports upon approval.

Overview

Before invoices move to production, test exports must be complete and cover the correct period. This automation downloads three test exports, verifies the period, checks that the error and warning sheets are empty, and only then starts the production exports. If a check fails, the file is emailed.

What has changed

  • Reduced manual follow-up for invoice preparation
  • Exports are complete and period-accurate before release
  • Invoice batches are released in a controlled and traceable manner

At a glance

SECTOR:
VVT
System:
Nedap ONS (IO Service), Excel, email
RUNS:
On demand, with up to 20 retry attempts
Technique:
Rule-based

In één oogopslag

SECTOR:
VVT
Systeem:
Nedap ONS (IO Service), Excel, email
RUNS:
On demand, with up to 20 retry attempts
Techniek:
Rule-based

Overzicht

Before invoices move to production, test exports must be complete and cover the correct period. This automation downloads three test exports, verifies the period, checks that the error and warning sheets are empty, and only then starts the production exports. If a check fails, the file is emailed.

Wat er verandert

  • Reduced manual follow-up for invoice preparation
  • Exports are complete and period-accurate before release
  • Invoice batches are released in a controlled and traceable manner

How it works.

Test exports quality checks
Period checkdone
Exceptions sheetdone
Warnings sheetrunning
Pending exports finished
On demand
Y
Yara runs
the checks
Production exports started
Invoice period 1started
Invoice period 2started
Invoice period 3started
All checks passed
A check fails? You get the file by email.

What it does per export

  1. Checks if pending exports are ready
  2. Downloads the test export files
  3. Verifies that the period runs from January 1st to the end of last month
  4. Checks that the error and warning sheets are empty
  5. Emails the file if a check fails
  6. Starts the production export per invoice period

Rules

Two quality checks determine whether production can start: the export period must run from January 1st to the end of the previous month, and the error and warning sheets must be empty. The run attempts to retry up to 20 times. The same input always leads to the same outcome, and every run leaves an audit trail that can be reviewed.

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.