MJE upload

Before you begin

• Ensure that MJE related configuration is set up appropriately based on your business needs. For example, at least one MJE approval rule is created and related accounting segments are enabled. For more information, see MJE setups.
• Be familiar with the related fields of the journal entry. Some fields are mandatory no matter whether you will upload JE lines in a local file or on the UI directly. For details, see the section below.
• To use the new Manual JE page (Workbench > Journals) for uploading JE lines, Zuora Revenue 37.008.00.00 or a later version is required. Besides, unified authentication must be enabled for the Zuora Revenue instance. Otherwise, you have to use the previous UI page (File Upload > Manual JE) for uploading JE lines.
• There are different ways to upload JE lines to Zuora Revenue. If you want to upload them in a local file, be aware of the following security requirement:

  Starting from version 37.004.02.00, to remediate CSV injection software attack, ensure that no cells in the uploaded file begin with any of the following characters:

  • Equal sign (=)
  • Plus (+)
  • At (@)

  During file upload, use the ENABLE_CSV_DATA_SANITIZATION profile to specify how to handle the file that has these special characters as a starting character in any cell. Valid values for this profile include the following:

  • BLOCK: The file will be blocked if any cell begins with the above special characters.
  • SANITIZE: The above special characters will be removed if any cell begins with them. Then, the file can be processed by the system.
  • RAW: The file can flow into the system as it is even if there is a potential security risk.

Fields related to JE lines

No matter whether you manually enter the JE lines in the UI or in a local file, you can specify the following fields for the journal entries.

Procedure (37.008.00.00 or later)

If you are using version 37.008.00.00 or later, complete the following steps to upload MJE:

1. Navigate to Workbench > Journals. The Journals page opens. 
2. Click Download Template to download the JE template file, which is to be used in the subsequent steps.
3. To create a journal entry, click the New icon . 
4. Specify the following details for the journal entries directly in the UI. Some fields already contain the default values as applicable. The required field is indicated by a red asterisk in the UI.

   

   Field	Description
   JE Name	A unique name of the journal entry. This field is required.
   Org ID	The ID of the organization for the journal entry. This field is required.
   Book ID	The ID of the appropriate book for the journal entry. This field is required.
   Posting Period	The period for posting the journal entry. This field is required.
   SOB Name	The name of the set of books, which is populated from the Oracle application or other ERP system. This field is required.
   Category Code	The category code, which is defined by the CATEGORY_CODE lookup. This field is required.
   Reversal Period	The period to reverse the journal entries.
   Functional Currency	The functional currency used for the journal entries. This field is required.
   Exchange Rate Type	The type of exchange rate to be used. This field is required. To use the exchange rates that are specified in the uploaded file, select User. To derive the exchange rates from the Oracle application or from the RPRO_EX_RATE table by providing the related dates in the upload file, select other options accordingly. The options on the drop-down list are defined by the EX_RATE_TYPE lookup.
   Accounting Method	The revenue accounting method of the journal entries. This field is required.
   GL Transfer	Indicates whether the journal entries are eligible for accounting transfer. By default, it is Yes.
   Approval Currency	The currency that is used when the journal entries are submitted for approval. The value is configured by the  APPRV_RULE_CURR profile and automatically populated in the UI.
   Memo	Additional information as plain texts.

5. After all the required fields are specified, you can either upload the JE lines in a file or directly add the JE lines on the UI.
6. To directly add the JE lines on the UI, complete the following steps:
   1. Scroll down to the Lines tab and click the Add Two Rows icon. Two empty rows are added to the table for one set of the JE lines. One is for the debit amount and the other for the credit amount.

      

   2. Manually enter the details for each JE line. 
   3. Repeat the above steps to add more sets of JE lines as needed.
7. To upload the JE lines in a CSV file, complete the following steps:
   1. Use the file that you downloaded in Step 2 as a template to fill in the JE details in a local file.
   2. After the local file is ready, scroll down to the Lines tab and click the Upload icon .
   3. Browse to the local file and upload it. After file upload is completed, JE lines in the uploaded file are displayed in the UI. 
8. To save the JE lines as a draft, click Save on the top right side of the UI. After that, the MJE status changes to New.
   
   If you are using version 37.012.00.00 or later, the validations are initiated when you save an MJE. This will help you identify your errors and resolve them before submission for approval.
    

   The Save button shows up only when all required fields are specified in the JE header section and on all JE lines. 

9. (Optional): To review the waterfall or JE schedules based on the MJE draft, use the Waterfall or Entries tab. 

   It is recommended to review this data before the MJE is submitted for approval.

10. To submit the MJE draft for approval, click Submit. 

    If you are using a version prior to 37.012.00.00, the system will perform validations on the JE details upon submission. If any validation issue is identified, the MJE status changes to Error. The problematic lines will be highlighted in the UI.

11. To fix the validation issue, edit the JE details, save your changes and then click Submit again.

After the MJE is submitted with no validation issues, the MJE status will change from New to Approval Pending.

Procedure (prior to 37.008.00.00)

If the version of Zuora Revenue is prior to 37.008.00.00, complete the following steps to upload MJE to Zuora Revenue:

1. Navigate to File Upload > Manual JE.

2. To create an MJE, complete the following steps:

3. On the Manual JE page, click  to add a journal entry.

4. In the New Manual JE window, provide detailed information about the journal entry.

   Field	Description
   Name	A unique name of the journal entry.
   Book	The appropriate book for the journal entry.
   Period Name	The accounting period for the journal entry.
   Ex Rate Type	The type of exchange rate to be used. To provide the exchange rates in the upload file, select User. To derive the exchange rates from the Oracle application or from the RPRO_EX_RATE table by providing the related dates in the upload file, select other options accordingly. The options on the drop-down list are defined by the EX_RATE_TYPE lookup.
   SOB Name	The name of the set of books, which is populated from the Oracle application or other ERP system. For more information, see Upload SOB information.
   Currency Code	The currency code, which is populated based on your selection of SOB Name.
   Category Code	The category code, which is defined by the CATEGORY_CODE lookup.
   Reversal Period	The period to reverse the JEs. The field is applicable only when Standard is selected for the MJE Type filed.
   Accounting Method	The revenue accounting method of JE.
   SOB ID	The ID of the set of books in the Oracle application or other ERP system.
   MJE Type	The type of MJE. Standard: The current open period or the specified period is used to create the new manual JE. Based on this template, debit and credit entries are created as different line entries, and the schedules are not ratable. Waterfall: The revenue start date, revenue end date, and the duration are provided and considered for schedules. Based on this template, a single line entry is created for both credit and debit entries, and the schedules are ratable.

   1. Click . The manual JE is created and its status is displayed as New.

5. To download the JE upload template, click Download Waterfall Template or Download JE Standard Template depending on the MJE type that you selected in the previous step.

6. Fill in the data in the downloaded CSV file and save your changes in the local file.

7. To upload the JE, hover the mouse over the JE line that you created in Step 2 and click the Upload icon .

8. The selected file is listed in the Uploaded Files section with more details. After the status of the uploaded file changes to Successfully Uploaded, the status of the JE line changes from New to Validated.

   If an error occurs during the upload, the status of the JE line changes to Error. You must fix the error and then click the Validate icon . For more information, see MJE validation error messages.

9. To submit the MJE for approval, hover the mouse over the JE line in the Manual JE Entries section and click the Submit Approval icon .

You can review the JE summary and the approval information anytime. To do it, hover the mouse over the JE line and then click the JE Details icon .

• Review the summary in the JE Summary tab.
• Review the errors reported during the MJE upload and validation in the Errors tab. If necessary, fix the errors and upload MJE again. For more information, see MJE validation error messages.
• Review the approval information and related MJE approval rules in the Approvals tab.
• Use the Manage JE Schedules tab to see the created manual journal schedules.

What to do next

Before the MJE is approved, you can still do the following things:

• Delete it after the MJE batch is created, after the MJE file is uploaded, or after the MJE data is validated. 
• Cancel the MJE approval request when the approval status is Pending.

After MJE is uploaded and submitted to be approved, the approver must log into Zuora Revenue to review the MJE and then approve or reject it. For more information, see Approve or reject MJE.