Journal run options: Date options
Filter transactions by target date of date range
Filter transactions by target date or date range. Create journal entries on a specified Journal Entry Date.
Target date(s)
Date or date range for filtering the transactions included in the run:
|
Option |
Description |
Valid for Transaction Type | |||
|---|---|---|---|---|---|
|
Billing |
Cash |
Credit Balance |
Revenue | ||
|
in accounting period |
Transactions posted to a specific open or closed accounting period. By default, the current, open accounting period is selected. The open-ended accounting period is not supported. |
|
|
|
|
|
on specific date |
Transactions posted on a specified date. Used when looking to reconcile specific transaction types on a daily basis. The date must be within an open or closed accounting period. Date cannot fall within an open-ended accounting period. |
|
|
|
|
|
in time period |
Transactions posted within a specified date range. Start and end dates are required. Valid date range must be within one accounting period. End date cannot fall within an open-ended accounting period. |
|
|
|
|
Journal Entry date
Required. The date associated with the summary journal entry. By default, the end date of the selected accounting period.
Types of transactions picked up during a journal run
Transaction types not yet associated with a journal entry and that meet the following criteria are included in a journal run.
|
Transaction Type |
Date Type on or within the Period |
Transaction Has Status |
|---|---|---|
|
Invoice Item |
Invoice Date |
Posted |
|
Taxation Item |
Invoice Date |
Posted |
|
Invoice Adjustment Note : Invoice Adjustment transaction is deprecated on Production. |
Adjustment Date |
Processed |
|
Invoice Item Adjustment |
Adjustment Date |
Processed |
|
Payment |
Payment Date |
Processed |
|
Refund |
Refund Date |
Processed |
|
Credit Balance Adjustment |
CBA Date |
Processed |
|
Revenue Event Item |
Accounting Period |
N/A |
|
The following transaction types are only available if you enable the Invoice Settlement feature. Note:
The Invoice Settlement feature is generally available as of Zuora Billing Release 296 (March 2021). This feature includes Unapplied Payments, Credit and Debit Memos, and Invoice Item Settlement. If you want to have access to the feature, see Invoice Settlement Enablement and Checklist Guide for more information. After Invoice Settlement is enabled, the Invoice Item Adjustment feature will be deprecated for your tenant. | ||
|
Credit Memo Item |
Credit Memo Date |
Posted |
|
Debit Memo Item |
Debit Memo Date |
Posted |
|
Credit Memo Application Item Note that the Credit Memo Application Item transaction type of unapplied Credit Memo will not reflect in JE. |
Credit Memo Application Date |
Posted |
|
Payment Application Note that this field will be replaced by Payment Application Item if you enable both the Invoice Settlement and Invoice Item Settlement features. |
Payment Application Date |
Processed |
|
Refund Application Note that this field will be replaced by Refund Application Item if you enable both the Invoice Settlement and Invoice Item Settlement features. |
Refund Application Date |
Processed |
|
If you enable both the Invoice Settlement and Invoice Item Settlement features, Payment Application Item will replace Payment Application, and Refund Application Item will replace Refund Application. Note:
The Invoice Item Settlement feature is only available if you have Invoice Settlement enabled. The Invoice Settlement feature is generally available as of Zuora Billing Release 296 (March 2021). This feature includes Unapplied Payments, Credit and Debit Memos, and Invoice Item Settlement. If you want to have access to the feature, see Invoice Settlement Enablement and Checklist Guide for more information. | ||
|
Payment Application Item |
Payment Application Date |
Processed |
|
Refund Application Item |
Refund Application Date |
Processed |
Types of transactions excluded from a journal run
Transactions that only adjust or move amounts between applied and unapplied states between Payment/Credit memo's applied an unapplied states without altering the balance are excluded from the journal run.
This condition is also applicable to the Credit Memo Application Items.
Sample use case
Consider the payment P-00000003 as an example, applied to INV-00000005, which has two invoice items.
2024-04-21 P-00000003created with10$unapplied amount.2024-04-21 P-00000003applied toINV-00000005, which has two invoice items- The payment application with ID
8a368aeb8f00478f018f01469e545f5dand the amount of-10$reduces the payment balance after it is fully applied. - The journal run or trial balance run will exclude payment application item
8a368aeb8f00478f018f01469e545f5das it is a balance adjustment without impacting Finance.
- The payment application with ID
2024-05-09 P-00000003unapplied fromINV-00000005- The payment application with ID
8a3694f18f4d3ea5018f5de45£797664and the amount of10$increases the payment balance after it is fully unapplied. - The journal run or trial balance run will exclude payment application item
8a3694f18f4d3ea5018f5de45£797664as it is a balance adjustment without impacting Finance.
- The payment application with ID
There are seven records in the payment application item data source export result as given below:
|
Event |
Payment Application Item: ID |
Payment Application Item: Amount |
Invoice: Invoice Number |
Invoice: Payment Number |
Payment Application Item: Created Date |
Payment Application Item: Effective Date |
|---|---|---|---|---|---|---|
|
Create unapplied payment |
8a3699608006200180142be0035f5 |
10 (increase unapplied amount from 0 to 10 = 0 +10 = 10) |
P-00000003 |
2024/4/21 11:25 |
2024/4/21 | |
|
Apply payment |
8a368aeb800478018014b95455a |
3.25 |
INV00000005 |
P-00000003 |
2024/4/21 11:34 |
2024/4/21 |
|
Apply payment |
8a368aeb800478018f014b9e545f5b |
6.75 |
INV00000005 |
P-00000003 |
2024/4/21 11:34 |
2024/4/21 |
|
Record created to reclassify movement from unapplied to applied state |
8a368aeb8f00478f018f01469e545f5d |
-10 (decrease unapplied amount from 10 to 0 =10 -10 = 0) |
P-00000003 |
2024/4/21 11:34 |
2024/4/21 | |
|
8a3694f18f4d3ea5018f5de45f787661 |
-3.25 |
INV00000005 |
P-00000003 |
2024/5/9 11:06 |
2024/5/9 | |
|
8a3694f184d3ea5018f5de45787b62 |
-6.75 |
INV00000005 |
P-00000003 |
2024/5/9 11:06 |
2024/5/9 | |
|
8a3694f1 8f4d3ea5018f5de45£797664 |
10 |
P-00000003 |
2024/5/9 11:06 |
2024/5/9 |
After running the reports, only the following five reports are picked up in the AR forward report and Journal Run as given below:
|
Consolidated AR Transaction: Date |
Payment: Payment Number |
Consolidated AR Transaction: Transaction ID |
Consolidated AR Transaction: Amount |
Debit Accounting Code: Name |
Credit Accounting Code: Name |
|---|---|---|---|---|---|
|
Apr 21, 2024 |
P-00000003 |
8a3699608006200180142be0035f5 |
10 |
Payments - 10002.000.00 |
Unapplied Payments - 10488.000.00 |
|
Apr 21, 2024 |
P-00000003 |
8a368aeb800478018014b95455a |
3.25 |
Unapplied Payments - 10488.000.00 |
Accounts Receivable |
|
Apr 21, 2024 |
P-00000003 |
8a368aeb800478018f014b9e545f5b |
6.75 |
Unapplied Payments - 10488.000.00 |
Accounts Receivable |
|
May 9, 2024 |
P-00000003 |
8a3694f18f4d3ea5018f5de45f787661 |
3.25 |
Accounts Receivable |
Unapplied Payments - 10488.000.00 |
|
May 9, 2024 |
P-00000003 |
8a3694f184d3ea5018f5de45787b62 |
6.75 |
Accounts Receivable |
Unapplied Payments - 10488.000.00 |