Offset accounting

Knowledge Center > Zuora RevPro > Advanced functionalities > Offset accounting

Offset accounting

Offset accounting usually refers to the cancelation of an accounting entry with an equal but opposite entry. In RevPro, the initial accounting entries created can be reclassified to either Deferred Offset account or Revenue Offset account for offset accounting. The following general rules apply to offset accounting in RevPro:

  • The trigger of this reclassification is at the time of billing.

  • The offset accounting entry is created in the transactional currency of the associated transaction line.

Account type requirement

For RevPro to process offset accounting, the Revenue Offset account and the Deferred Offset account must be created based on the appropriate balance sheet account or income statement account in the system. To create an account type, navigate to Setups > Application > Account Setup > Account Type. For more information, see Accounting Setup (link to the topic under System Related Configuration when available).

Input data requirement

For RevPro to perform reclassification for offset accounting, at the time of billing, you must provide the appropriate offset account type in the uploaded invoice transactions (Line Type = INV).

One transaction line can have only one offset account specified. If both Deferred Offset account and Revenue Offset account are provided for the same transaction line, an error will be reported against this line in RevPro staging table. You must fix the error and upload the source data again to RevPro.

Accounting examples

Three examples are provided to help you understand the offset accounting behaviors in RevPro.

Offset to revenue account

The following table displays the accounting entries that are created for offsetting to the Revenue Offset account.

The Contract Liability entry is an existing entry that RevPro creates as part of billing. The first Revenue Offset entry line is created as part of reclassification. The second Revenue Offset entry line represents the entry in the upstream system, which is created as part of reclassification.

Account Type Account # Dr Cr Initial Entry Initial Entry Reporting Postable
Revenue Offset 40000 100   N Y Y
Contract Liability 23000   100 N Y Y
Revenue Offset 40000   100 Y Y N

Offset to deferred account

The following table displays the accounting entries that are created for offsetting to the Deferred Offset account.

The Contract Liability entry is an existing entry that RevPro creates as part of billing. The first Revenue Offset entry line is created as part of reclassification. The second Revenue Offset entry line represents the entry in the upstream system, which is created as part of reclassification.

Account Type Account # Dr Cr Initial Entry Initial Entry Reporting Postable
Deferred Offset 27000 100   N Y Y
Contract Liability 23000   100 N Y Y
Deferred Offset 27000   100 Y Y N

Offset for bundle lines

When a bundle line is involved in offset accounting, RevPro first performs reclassification of the offset account at the parent line level, and then reclassify the deferred or contract liability initial entries for children lines.

The following tables explain the two-step reclassification for offsetting to the Revenue Offset account.

The Contract Liability entry is an existing entry that RevPro creates as part of billing. The first Revenue Offset entry line is created as part of reclassification. The second Revenue Offset entry line represents the entry in the upstream system, which is created as part of reclassification.

For the three children lines, RevPro updates the Initial Entry flag to N and sets the Postable flag to N.

Line Item Account Type Account # Dr Cr Initial Entry Initial Entry Reporting Postable
Parent 1 Revenue Offset 40000 100   N Y Y
Parent 1 Contract Liability 20000   100 N Y Y
Parent 1 Revenue Offset 40000   100 Y Y N
Child 1 Contract Liability 21000   25 N Y Y
Child 2 Contract Liability 22000   25 N Y Y
Child 3 Contract Liability 23000   50 N Y Y
Last modified

Tags

Classifications

(not set)