How a Multi-National Company Took Month-End Invoicing Off the Calendar

A retail-media integration rebuild that quietly retired three markets' worth of manual finance work, with three more on deck.

Challenge

The Last Day of the Month Was Always the Longest

For this food-focused multi-national company, the Retail Media team — the people who sell advertising and sampling campaigns to consumer brands like Bacardi, Nestlé, and Eckes-Granini — every month-end meant the same exhausting ritual.

Finance pulled deal data from HubSpot, looked up tax codes, routed every line item to the correct Oracle business unit, manually created Oracle customer records for new partners, generated invoice import files to Oracle's exacting specification, uploaded them, waited for the error log, fixed what broke and reissued.

It worked, but only barely, and only for a handful of markets. Every new country the business expanded into added another full afternoon of period-close work — first DACH, then Benelux, then the UK. A planned launch into Australia, the US, and Canada made it clear: the manual approach was about to hit a wall.

The brief for this project was direct.

“Make the month-end go away. Keep the audit trail. Don't break anything we already trust.”

OUR APPROACH

Don't Reinvent. Connect.

Deal data was already in HubSpot and the sales team was doing their job updating deals with the right information. Their tax matrix lived in a Google Sheet that finance owned and trusted. Oracle ERP was the financial system of record. What was missing was the connective tissue between them — a layer that could pick deals up at the end of the month, classify them correctly, hand them to Oracle in the right format, and leave an audit trail of what had happened back inside HubSpot.

We built that layer.

The result is an integration that runs on its own. At 23:00 on the last calendar day of each month, the system wakes up, pulls every Closed Won deal ready to invoice, looks up the right tax and accounting treatment from the master sheet, generates the Oracle-shaped files, delivers them via secure transfer, and stamps every deal in HubSpot with its Oracle transaction number, sync status, and timestamp. By the time everyone checks their inbox the next morning, the work is done.

Three principles drove the design

Finance keeps control of pricing and tax logic without writing code. The master table that drives every routing decision is a Google Sheet that the RevOps team owns. Edit a row, save, and the next batch picks up the change.

HubSpot is the single source of truth. Every deal carries its own audit trail of what was invoiced and when. No spreadsheet exports, no parallel ledgers.

Each market is a configuration, not a code change. Adding a new country is rows in a sheet, not a software release.

WHAT WE BUILT

Six Connected Workflows, One Quiet Month-End

An integration that handles the full lifecycle from deal in HubSpot to invoice in Oracle, with the recovery and audit machinery to make it trustworthy.

Monthly Invoice Batch

Runs automatically at month-end. Pulls Closed Won deals, classifies every line item against the master table, generates Oracle's required files per business unit, and uploads them via secure transfer.

New Partner Registration

Catches partners who don't yet have an Oracle customer record. Generates the customer file Oracle needs. Handles multi-region partners cleanly — a brand operating across three countries becomes three accounts, one per region, with no duplicates.

Retry & Recovery

If the secure upload fails, the system retries on its own. Only after exhausting retries does it escalate, by creating a HubSpot task for the deal owner.

Pre-Run Quality Checks

Catches missing data on deals (invoice contact, customer tax location, contract amount) before the batch runs, so finance isn't surprised on the 1st of the month.

Pre-Export Preview Report

Three days before each run, the system generates a Google Sheet with one tab per market summarising what's about to be invoiced. Finance and local teams have a window to flag anything before it's locked in.

Two-Way HubSpot Sync

Every processed deal is stamped with its Oracle transaction number, sync status, and timestamp, so the audit trail lives where the deal lives.

WHAT CHANGED

Three Markets Running on Autopilot

Three months in production. The DACH region — Germany, Austria, and Switzerland — closed three consecutive months in March, April, and May 2026 without manual finance intervention on the batch. Zero finger-on-the-keyboard from the month-end team.

Tax routing standardised across 14+ EU jurisdictions

The master table now encodes intra-community VAT rules, the UK's Paid-in-GBP versus non-GBP split, and Switzerland's export treatment in one place. No more per-deal tax lookups, no more month-end reissues.

204 partner companies cleaned up in a single pass

A one-time data exercise matched 204 HubSpot companies to their existing Oracle customer records, eliminating a backlog that would otherwise have shown up as failed invoice imports for the rest of the year.

The audit trail lives in HubSpot

Every deal carries its Oracle transaction number and sync status as native HubSpot properties. Finance can answer “did this get invoiced?” without opening a second window.

Oracle accepted the files on first import

The integration was validated by the client's Oracle ERP team. No back-and-forth, no rework.

BY THE NUMBERS

BUILT TO GROW

Designed For The Rest Of The Map

The architecture was built for further global expansion from day one.

Adding a market is a configuration change, not a code change

When ANZ, the US, and Canada launch later this year, the work is rows in the master table and a market entry in the workflow's target list. The same pattern that took DACH from one country to three and Benelux from one to three is already in place for the next three.

Multi-region partners are handled cleanly

A brand operating in both the UK and Benelux generates one Oracle customer record per region with a deterministic, traceable identifier. No duplicate accounts, no manual reconciliation.

Safe to test, easy to iterate

Every workflow has a test mode that lets the team re-run the workflow end-to-end without polluting their HubSpot portal with duplicate records. What used to be a multi-hour reset cycle during UAT became a single switch.

WHAT'S NEXT

Three More Markets, And A Quieter Finance Function

• Onboarding ANZ, US, and Canada using the existing pattern.
• Quarterly HubSpot-to-Oracle reconciliation reporting for finance.
• A self-service guide so the client can add future markets on their own.
• Full handover documentation and a live knowledge-transfer session.

The best month-end is one nobody notices.

Our client’s Retail Media business now closes the month on a schedule, with the audit trail intact and the team free to focus on the next deal.