Fuel and toll invoices into accounting

DKV and Eurowag statements and toll, ferry and subcontractor invoices arrive from Outlook and portals, and an accountant keys them into SAP Business One one by one. AI splits each invoice into lines, assigns them to a lorry and a trip from CargoWise, and prepares them for import into SAP Business One. The accountant approves the batch.

Built for ISO 27001NIS2 DORA

Fuel and toll invoices into accounting
  • Collection flows in Power Automate
  • Batch approval table

Trip cost is visible in CargoWise at the start of the month, not after the close

  • Batch the accountant approves the batch in SAP Business One, not one by one
  • Lorry and trip every DKV line is assigned to a trip in CargoWise
  • SAP Business One import in your accounting system's format
  • M365 Power Automate (tenant), recognition in an EU region

A transport company's accounting department receives hundreds of cost documents every month: DKV and Eurowag statements with dozens of lines per lorry (fuel, AdBlue, tolls in several countries, ferries and tunnels) and subcontractor invoices for individual trips. They arrive in Outlook, as PDFs and from supplier portals where you have to sign in and download them. The accountant keys each one into SAP Business One and assigns it to a lorry, a trip and a cost category. Errors surface when the trip cost in CargoWise does not match what management expects and someone has to find where something was assigned to the wrong place.

The solution collects invoices on a schedule from agreed Outlook mailboxes and the DKV and Eurowag portals. Each document is split into lines: supplier, number, date, location, quantity, amount, VAT. Using the number plate, card number, date and location, lines are assigned to a lorry and a trip from CargoWise, and using the supplier and item type, to a cost category in your SAP Business One chart of accounts. The prepared batch is shown to the accountant in a table: they see the document, the recognised fields and the assignment, correct what is needed and approve the whole batch, not one invoice at a time. The approved batch is imported into SAP Business One, and trip costs are returned to the CargoWise cost column. We build it with Power Automate flows in your Microsoft 365 tenant, use AI Builder or Azure AI Document Intelligence in an EU region for document recognition, integrate with SAP Business One through an import file or API, and with CargoWise through an API, a file export or an email flow, depending on the version. If your ERP runs on our ERP hosting, the integration is simpler, but the solution also works with Sage or another accounting system.

How it works

Four steps from input to a record in your system, with human approval wherever there is risk.

Invoice collection

Power Automate flows pick up invoices from agreed Outlook mailboxes and, on a schedule, download statements from the DKV and Eurowag portals and from toll operators. Each document is logged with its source and time of receipt so nothing gets lost.

What you get

Collection flows in Power Automate
Collection flows in Power Automate

Outlook mailboxes and the DKV, Eurowag and toll portals combined into a single document flow with a logging journal in your Microsoft 365 tenant.

Assignment rules based on your chart
Assignment rules based on your chart

Assignment logic for lorries, trips and cost categories, based on your SAP Business One chart of accounts and CargoWise trip data, which the accountant can extend on their own.

Batch approval table
Batch approval table

One window for the accountant with documents, recognised fields, assignment to a lorry and a trip from CargoWise and reconciled totals, with approval for the whole batch.

SAP Business One import and maintenance
SAP Business One import and maintenance

Import file generation to SAP Business One or Sage requirements, cost return to CargoWise, monitoring during the first month and adding templates for new suppliers.

What we build it with

Power Automate + document recognition + DKV and Eurowag statements + SAP Business One import + CargoWise trip data. We choose the integration method for SAP Business One and CargoWise after checking your versions. Read more about this service and its limits on the service page.

Frequently asked questions

Do invoices reach SAP Business One without an accountant?

No. Only a batch approved by the accountant is imported into SAP Business One. The accountant sees every document and assignment, and corrections are written to a log. This saves time on data entry, while responsibility for the accounting record stays with a person.

Does it work with SAP Business One, Sage and CargoWise?

Yes. We integrate with SAP Business One through an import file or API, with Sage through its import format, and with CargoWise through an API, a file export or an email flow, depending on the version. Recognition and assignment do not depend on the accounting system; only the import format changes, and we choose the integration method after a check at the start of the project.

How are DKV lines assigned when one statement covers all lorries?

DKV and Eurowag statements are split into lines, and each line is linked to a lorry by card or number plate number and to a trip by date and location from CargoWise. If a lorry had several trips that day, the line is assigned by a rule you agree on or flagged for the accountant.

Related services

Order agent from email into the TMS

Orders arrive in Outlook with a PDF, from the Trans.eu exchange and from Transporeon, and the dispatcher retypes them into CargoWise by hand.

More
Checking CMR and customs documents

Drivers send photos of CMR and declarations through Viber or Teams, and logistics checks them by eye and attaches them to the trip in CargoWise by…

More
Driver and dispatcher assistant

Drivers call the dispatcher with the same questions: how to fill in a CMR, what to do after an accident, when loading is.

More
Freight quote draft

A request from Outlook, Trans.eu or TimoCom waits while the sales rep calculates the distance, finds a similar trip in CargoWise and writes up the…

More

Expertise confirmed by certifications

This service is delivered by specialists with valid international certifications. Their expertise is confirmed by independent organisations, not by us.

All certifications
  • AISP badge
    AISP PECB

    Artificial Intelligence Security Professional

    AI systems are deployed with protection against data leakage and model abuse.

  • AAISM badge
    AAISM ISACA

    ISACA Advanced in AI Security Management

    The AI security programme and its controls are managed following the ISACA methodology.

  • AAIR badge
    AAIR ISACA

    ISACA Advanced in AI Risk

    AI risks are identified and managed like any other IT risk.

Let's discuss: fuel and toll invoices into accounting

Tell us how this process works for you today and which systems you use. Within 1 business day we will reply with how long implementation would take for a transport company.

We reply within 1 business day

Contact us 24/7
+370 630 94 909

Fill out the form, and we will contact you within 1 business day.