The Outgoing Invoices export gives you issued invoices, proof of payments, and proforma invoices. Use it to see the structure of your revenue by client - what was invoiced for which period, and what your accounting revenue consists of. You can also calculate commissions on external costs (production/media), including year-over-year growth or decline.
Where to find Outgoing invoices and Proforma export
Finance → Outgoing Invoices → Export
Note: If you issue a proforma invoice for amount X and later a settlement invoice for amount Y, the VAT shown on the settlement invoice in this export is calculated only from the difference not already covered by the proforma.
The export downloads exactly what you have on screen - no need to select anything via checkboxes.
Whatever filter you apply (e.g. a specific brand) is applied consistently across all three sheets within outgoing invoices export - issued invoices, paid proforma invoices, and unpaid proforma invoices.
What is in the Outgoing invoices export?
You can find 3 sheets in outgoing invoices export:
1. Client OI export
Regular outgoing invoices (and credit notes, where applicable).
General info
Type – The document type, e.g. Invoice (credit notes and other issued document types may also appear here).
Client
Billing entity – The client's billing entity as entered on the invoice.
Brand
Brand Code
Projects – The project(s) the invoice is linked to.
Project codes
Project statuses – e.g. Active, Finished.
Teams
Invoice No
Date of supply
Supply month
Issue month
Amounts
Without VAT
VAT
Total
Currency
Total in workspace currency € – The invoice total converted into your workspace's base currency.
Company ID – The client's company registration ID.
Company TAX ID
Project category
Text on invoice – Any custom text/note entered on the invoice.
Due date
Paid at
Sum paid with VAT – The amount actually paid against this invoice, VAT included.
Budget split - reflects the invoice according to the project's budget, and includes all budget items regardless of whether they're open or closed:
Our work – Our work invoiced.
Production – Production invoiced.
Media – Media invoiced.
(Royalties, if your workspace uses this budget category, appears here too: Royalties invoiced.)
Production Provision – The sum of expected commission on the invoiced Production budget items. This is calculated proportionally: if a Production budget item has a total budget of €10,000 and a planned commission of €1,000, and €5,000 of that item is invoiced on this particular invoice, the invoice's share is 50% — so €500 of commission is attributed here. The share is capped at 100% (never more than the full planned commission), and items with no budget return 0. If an invoice includes several Production items, their individual shares are summed into this one figure.
Media Provision – The same logic as Production Provision, applied to Media budget items.
Advanced Payment Amount – The invoiced amount drawn from an assigned credit account (prepayment).
Total Provision – The sum of all commissions (Production + Media, and Royalties if applicable).
Accounting split - reflects the invoice from an accounting perspective and includes data from closed budget items or finished projects:
Our work – Our work invoiced.
Production – Production expenses received.
Media – Media expenses received.
(Royalties, if applicable: Royalties expenses received.)
Production Provision – The sum of the final commission on Production budget items, calculated after the budget item is closed.
Media Provision – The same, for Media budget items.
Advanced Payment Amount – If the project is closed: the invoiced amount from the assigned credit account. If the project or budget item is still open: the amount still expected to be invoiced for Production + Media (+ Royalties).
Total Provision – The sum of all commissions (Production + Media, and Royalties if applicable).
In short: Budget split shows your revenue split according to the plan - everything that's been invoiced so far, regardless of whether the underlying work is finished. Accounting split shows it from a "money actually earned/received" perspective - final commissions only apply once a budget item is closed.
2. Proforma Proof of payment OI export
Proforma invoices that have already been paid.
Client, Billing entity, Brand, Brand Code
Projects, Project codes, Project statuses, Teams
Invoice No
Date of supply, Supply month, Issue month
Total
Attached proforma invoice – Reference/link to the proforma invoice this payment is attached to.
Company ID, Company TAX ID
Project category
Text on invoice
Due date
Paid at
Sum paid with VAT
3. Unpaid proforma OI export
Proforma invoices that have not yet been paid. Same structure as the previous sheet, with two differences:
Issue date appears instead of Date of supply / Supply month.
There's no Paid at or Sum paid with VAT column (since these invoices haven't been paid).