Welcome to Zuora Product Documentation

Explore our rich library of product information

Manual journal entry linkage options

Zuora Revenue supports various Manual Journal Entry (MJE) linkage options, including unlinked, line-linked, and contract-linked types, which determine how MJEs associate with Revenue Contracts and appear in revenue reports.

Overview

Zuora Revenue supports the following Manual Journal Entry (MJE) linkage options as a part of the RC linked manual journal entry feature.

  • Unlinked
  • Line-linked
  • Revenue Contract-linked

These linkage types determine how manual journal entries associate with Revenue Contracts and how they appear in revenue reports. Further in this topic we explain the above-listed linkage options and,

  • What happens when each type is booked and approved
  • How MJEs appear in Revenue reports

Unlinked MJE Lines

Unlinked MJE lines are not associated with a Revenue Contract. When an unlinked MJE line is booked and approved, Zuora Revenue automatically creates a new RC that includes an MJE line and a corresponding performance obligation. No Revenue Schedule is created.

Line-linked MJE lines

When line-linked MJE lines are booked and approved, only RC Schedule (RC Schd) entries are created. Note that, as the MJE is already linked at the line level, the system does not need to create duplicate transactional data.

Revenue Contract-linked MJE line

When booked and approved, Zuora Revenue establishes the required contract-level revenue structure for the adjustment and creates the following:

  • RC line entries
  • RC POB entries
  • LN Cost (for cost-type lines)
  • Line PA (for Variable Consideration lines)

An MJE line is treated as Revenue Contract–linked when:

  • RC ID is populated on the JE line, and
  • Sales Order Line ID (Doc Line ID) is left blank.

Field Reference

  • RC ID – Establishes the link between the JE line and a specific Revenue Contract.
  • Sales Order Line ID (Doc Line ID) – Establishes the link between the JE line and a specific sales order line.

Examples

Below are some examples for each linkage type and how data looks like in these scenarios.

JE Line

ID

HEADER_ID

CURR

AMOUNT

DR_ACTIVITY_TYPE

CR_ACTIVITY_TYPE

RC_ID

DOC_LINE_ID

RC_LINE_ID

3609000612408USD1000Revenue10783
3609000712408USD1000Contract Liability10783

RC Line

ID

RC_ID

TYPE

RC_POB_ID

1600010783SO12200
1600110783SO12201
1600310783SO12202
1600510783SO12203
1600710783SO12204
1600910783SO12205
1601110783SO12206
1601310783SO12207
1601410783SO12208
1601510783SO12209
1601610783SO12210
1601810783SO12211
3609000810783MJE12900
3609000910783MJE12901

RC POB

ID

NAME

POB_ID

POB_VERSION

RC_ID

12900MJE2110783
12901MJE2110783
12200TEST TST_0335_710020110783
12201TEST TST_0335_710020110783
12202TEST TST_0335_710020110783
12203TEST TST_0335_710020110783
12204TEST TST_0335_710020110783
12205TEST TST_0335_710020110783
12206TEST TST_0335_710020110783
12207TEST TST_0335_710020110783
12208TEST TST_0335_710020110783
12209TEST TST_0335_710020110783
12210TEST TST_0335_710020110783
12211TEST TST_0335_710020110783

RC Schedule

ID

REL_ID

RC_ID

RC_VER

LINE_ID

POB_ID

CURR

AMOUNT

REL_PCT

7136200219911709506319196161078303609000612900USD-10000
7136200319911709514581975041078303609000712901USD-10000

RC Rollforward Report

In the RC Rollforward Report, the Revenue line shows up like this:

BOOK NAME

ORG NAME

RC LINE RC ID

RC POB NAME

POB TMPL NAME

POB SATISFIED FLAG

EVENT NAME

SALES ORDER NUM

F TOTAL RELEASE

GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)4-4942010.87
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)3-782832.88
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)63119422.34
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)122076806.97
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)7-3437383.33
GAAPDEFAULT10783MJEAUTO POBPoint In TimeManual1000
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)1-52.47
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)2-145.32
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)5-2060548.59
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)11-783713.62
GAAPDEFAULT10783TEST TST_0335_7Upon_bookingPoint In TimeUpon Booking (Full Booking Release)80