Affiliate Invoicing at Month-End: A Step-by-Step Checklist

Month-end is where affiliate teams lose the most hours to manual work. The numbers live in the tracker, the invoice lives in a document, the totals go into a finance sheet, and someone has to check all three agree before anything is sent. The fix is a fixed sequence of steps, done the same way every month.

Here is that sequence, from closing the period to sending the last invoice.

1. Lock the period and the timezone

Decide what "October" means before you pull a single number. Your tracker, your advertisers and your traffic sources may each report in a different timezone. A conversion at 23:30 in New York is already the next day in London.

• Pick one timezone for invoicing and write it into your partner terms.
• Use full calendar days: the 1st at 00:00 to the last day at 23:59 in that timezone.
• Pull the same date range in every system you reconcile against.

Skip it, and the first reply you get may be "your numbers don't match ours".

2. Let pending conversions settle

Conversions often arrive as pending and are approved or declined later, after the advertiser checks them. Invoicing while many are still pending means re-issuing invoices later.

A common approach:

1. Wait a set number of days after month-end, long enough for your advertisers to finish their checks.
2. Invoice approved conversions for the period.
3. Carry anything still pending into the next period once it's confirmed.

Whatever you choose, apply it the same way every month and state it in your terms.

3. Reconcile with advertiser numbers

Before you invoice a partner, check that the advertiser agrees with the totals you will pay out on. If an advertiser scrubs conversions for quality, those declines should reach your tracker before you invoice partners, not after.

A quick reconciliation table per advertiser helps. For example:

Small differences are normal. Large ones need an answer before money moves.

4. Apply your payout rules

Now turn approved conversions into amounts per partner:

• Payout per conversion from the offer, including any custom payouts for that partner.
• Minimum payout: if a partner earned less than your threshold, roll the balance into next month instead of invoicing.
• Adjustments: bonuses, chargebacks and corrections, each on its own line so the partner can see them.
• Currency: invoice in the currency of the payout, and note the exchange rate if you convert.

5. Number every invoice from one sequence

An invoice number has to be unique. In the EU, VAT invoices need a sequential number that uniquely identifies the invoice, and the series can be split into several sequences if each one runs in order. UK guidance says every invoice needs a number unique to that invoice.

In practice:

• Use one pattern, for example INV-2026-0142, and never reuse a number.
• Don't leave gaps. If an invoice is wrong, cancel it with a credit note rather than deleting it.
• Keep separate series only when there's a reason, such as a second legal entity.

Tax rules differ by country, so check what applies to you with your accountant.

6. Build the invoice on a template

Each invoice should carry the same essentials: your details and the partner's, the invoice number, issue date, the period covered, line items with conversions and payout, any VAT, the total and the payment terms. A template with placeholders for those fields keeps every invoice consistent and stops copy-paste errors between partners.

What every invoice should show

1Unique invoice number

2Dates, issued and period covered

3Line items and total due

4Payment terms and due date

7. Approve, send and log

Have one person check the batch before it goes out. They should spot-check a few invoices against the tracker, not re-do the whole month. Then send each invoice to the partner's billing contact, and log it.

The log can be a single Google Sheet with one row per invoice: partner, period, invoice number, amount, currency, sent date, paid date. It answers most questions finance will ask later, and it makes the next month's numbering obvious.

Doing it in your tracker vs. automating it

Some platforms cover part of this. Affise, for example, can generate affiliate billings on a weekly, bi-weekly or monthly schedule inside the platform. If your partners are happy with that, use it.

If invoices need your own layout and numbering, an approval step and a finance sheet, the checklist above maps onto one automation. In AffZero, the monthly invoicing preset does exactly this for one partner, and you copy it for the next:

Month-end, automated

1. 1Pull statsLast month, by affiliate
2. 2FilterThe partner being invoiced
3. 3Invoice numberNext in your series
4. 4Create invoiceYour HTML or Google Doc template
5. 5Write to SheetsOne row per invoice
6. 6Send for approvalSent once someone approves

The presets guide walks through each step with screenshots, and invoice numbering explains how the next number is worked out from your recent invoices.

The short version

Lock the dates, let conversions settle, reconcile, apply your rules, number carefully, use a template, and get a second pair of eyes before sending. Done by hand, that's a day or more for a busy network. Written down once, it can run on its own.