Skip to content
  • There are no suggestions because the search field is empty.

EOM Programmatic Billing Reporting

Instructions for compiling and sending monthly consolidated revenue reports to finance.

WHAT

On the first working day of each month, we need to send finance a consolidated report on revenue per demand partner.

This needs to be sent to:

  • Katie Gould-Thorpe <Katie.Gould-Thorpe@nzme.co.nz>
  • Terri Logan <terri.logan@nzme.co.nz>
  • David Yan <david.yan@nzme.co.nz>

Cc:

  • Andy Wylie <Andy.Wylie@nzme.co.nz>
  • Carolyn Luey <carolyn.luey@nzme.co.nz>
  • Lana Philson <Lana.Philson@nzme.co.nz>
  • Stella Shin <Stella.Shin@nzme.co.nz>
  • Alex Jordan <Alex.Jordan@nzme.co.nz>
  • Juliet Greer <juliet.greer@nzme.co.nz>
  • Greg Lockton <greg.lockton@nzme.co.nz>

WHY

The automated reports (Programmatic Dashboard, Power BI dashboards) that are provided daily can have intra & inter day variations vs EOM final numbers (~20K total on any given month), so we need to manually pull the numbers from each individual platform once the month has ended and send to finance for accrual. This also allows them to keep track of payments done by each partner.

WHEN

Monthly on the 1st working day of the following month - try to block a morning to do so – finance don’t like it when it’s late.

HOW

We need to log into each of the demand partners' individual platforms and pull a report/look at statements from the previous month.

Some general rules:

  • Some of the demand partners will report on a foreign currency. In these cases, we need to convert to NZD using the latest FX rate available. I just use the one provided here or Google search "USD to NZD"). I also provide the FX rate calculations in the excel sheet. Actual FX rate on any given month will still differ slightly due to daily fluctuations and delivery weightings.
  • We need to provide both gross & net (e.g., after take rates) revenue figures where possible. We report on gross for targets but receive net payments. Take rate is automatically calculated in most cases. If unknown gross = net. For reference fees can be found here.
  • The excel sheet clarifies who sends the payment from the DSPs to NZME – if it comes straight from the partner (e.g., as is on header bidding or tag-based integrations) or Google (e.g., on open bidding integrations). This allows finance to track & consolidate payments more easily. All Open Bidding activity is paid for by Google in a lump sum that also includes all ADX + PG payments.
  • In case we onboard new partners, these need to be added as new lines with all same details.
  • Numbers can differ slightly from payment after these have been accrued. There’s really no way around this as we need to do the accrual on the first days of the month. Finance should be able to adjust for any small difference with payments as they’re received.

Where are they saved:

I save a different file per calendar month. Please clone the template from the latest month here and SAVE AS new month file.

Instructions:

  • Update the FX rates for the historical monthly average.
  • Verizon is a combination of 2 SSPs so it has its own little table at the top of the template that feeds into the main tables.
  • Please don’t edit anything on the left-hand table as it’s all formulated from the table on the right.
  • The grey squares are also formulas so do not edit these.
  • Please hide the right-hand table before sharing on email to avoid any confusion.

Monthly reporting previous to Feb 22 can be found in the MONTHLY BILLING folder on the handover directory.