6.5.3.5 Accounting record creation table

With Version 2.158 accounting records will have the possibility to distribute Campaign items that do not have delivery data. So as of this version, it is not only site-based revenue distribution, it is revenue schedule distribution for this specific period. With this enhancement, the logic of how distribution and accrual records are created will be changed. Please see the tables below for more details.

Important information to consider

Accounting Distribution Quantity Type* on the Ad Spec level gives the logical information on how the Campaign item should be calculated, for example, if the quantity is 1 but the revenue schedule has 10,000 delivered AIs, the logic needs to know if this should be calculated by impressions, clicks, video impressions etc. When this is not filled in for the “*Other ones, Fixed Price, CPD” billing categories there will be an error in distribution record creation and no record will be created. This quantity type error will never be a problem for CPM because the Billing Category itself already defined the quantity type, e.g. for CPM it would be impressions. This field will be ignored for the Budget billing category.
When AdSpec has to be accounted for (distribution, deferral, accrual records) linearly and delivery data records should be ignored, the user can enable AdSpec for “Linear Accounting Calculation". This means that when this checkbox is enabled, Accounting Records processes will ignore the delivered quantity from a connection.

Please note that if the Campaign item is invoiced based on delivery data and this checkbox is enabled, your invoice will be generated on the actual quantity however distributed linearly.

For Enhanced delivery data Sites and Video Groups, the secondary connection ID has to be present in the Enhanced delivery data record otherwise Distribution records will not be saved and show an error message.

Distribution records

Billing Category	Connection on Ad Type	Distribution enabled on Ad Spec	Distribution Quantity Type on Ad Spec*	2.158+	Fiscal Periods version before version 2.169

Billing Category	2.158+	Fiscal Periods version before version 2.169
CPM, CPC, vCPM, CPCV	Records created based on delivery data	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on linear	Records created based on linear
CPM, CPC, vCPM, CPCV	No records created	No records created
CPM, CPC, vCPM, CPCV	No records created	No records created
*Other ones, Fixed Price, CPD, …	Records distributed on delivery data linearly	Records created based on linear
Other ones, Fixed Price, CPD, …	No records created, warning shown	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	No records created	No records created
Other ones, Fixed Price, CPD, …	No records created	No records created
Other ones, Fixed Price, CPD, …	No records created	No records created
Other ones, Fixed Price, CPD, …	No records created	No records created
Budget billing category: `Unlimited` True / `linear distribution` False	Records created based on actual media spend without limiting it to the campaign item budget.
	Records created based on actual media spend without limiting it to the campaign item budget.
	No records created
`Unlimited` false / `linear distribution` True	Records created based on actual media spend
	Records created based on actual media spend
	No records created
`Unlimited` false / `linear distribution` False	Records created based on actual media spend
	Records created based on actual media spend

*Other ones listed in the Billing Category would be Fixed Price, CPD, CPO, CPO, CPW, CPY, CPW, CPL, CPx

Accrual records

Billing Category	Connection on Ad Type	Distribution enabled on Ad Spec	Distribution Quantity Type on Ad Spec	2.158+	Fiscal Periods version

Billing Category	2.158+	Fiscal Periods version
CPM, CPC, vCPM, CPCV	Records created based on delivery data	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on linear	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on linear	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on revenue schedule	Records created based on linear
*Other ones, Fixed Price, CPD, …	Records distributed on delivery data linearly	Records created based on linear
Other ones, Fixed Price, CPD, …	No records created, warning	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear

Deferral records

Billing Category	Connection on Ad Type	Distribution enabled on Ad Spec	Distribution Quantity Type on Ad Spec	2.158+	Fiscal Periods version

Billing Category	2.158+	Fiscal Periods version
CPM, CPC, vCPM, CPCV	Records created based on revenue schedule	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on linear	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on linear	Records created based on linear
CPM, CPC, vCPM, CPCV	Records created based on revenue schedule	Records created based on linear
*Other ones, Fixed Price, CPD, …	Records distributed on delivery data linearly	Records created based on linear
Other ones, Fixed Price, CPD, …	No records created, warning	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear
Other ones, Fixed Price, CPD, …	Records created based on linear	Records created based on linear

Budget billing category Accruals / Defferal records

Billing Category	Invoicing	Linear Accounting Calculation	Connection	Distribution enabled	Expected result

Billing Category	Invoicing	Linear Accounting Calculation	Connection	Distribution enabled	Expected result
`Unlimited` True / `linear distribution` False	This means that CI will be invoiced based on actual delivery data with no limit				records created on linear
		-			based on actual media spend
					based on actual media spend
		-	-	-	based on actual media spend
`Unlimited` True / `linear distribution` True					No records created
`Unlimited` false / `linear distribution` True	This means that CI will be invoiced linearly based on number of days				records created on linear
		-			based on actual media spend
					based on actual media spend
		-	-	-	based on actual media spend
`Unlimited` false / `linear distribution` False	This means that CI will be invoiced based on actual delivery data				records created on linear
		-	-		based on actual media spend
					based on actual media spend