Exported Revenue Examples
Overview
The Accounting Period Revenue Detail report provides visibility into recognized revenue for a specific accounting period as part of your accounting close and journal entry generation processing. This article provides examples that illustrate how revenue is exported and reported in the Revenue Detail export based on the selected accounting period. See Accounting Period Revenue Detail for more information about this report.
Examples
See Revenue Detail Exported Data Descriptions for descriptions of all the exported data. These examples are based on single currency exports.
All accounting periods referenced in these examples are open.
Transaction date and revenue occurs in the same period
- An invoice for $100.00 is created on January 1 with an invoice date of January 1.
- A revenue schedule is created with a revenue item of $100.00 that is recognized in January.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 01/01/2014 | Invoice Item | 01/01/2014 | 100.00 | 0.00 | 100.00 | 0.00 |
Transaction date occurs in January and revenue is recognized in a previous period
- An invoice for $100.00 is created on January 1 with an invoice date of January 1.
- A revenue schedule is created with a revenue item of $100.00 that was recognized in December.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 01/01/2014 | Invoice Item | 12/11/2013 | 100.00 | 100.00 | 0.00 | 0.00 |
Transaction date occurs in January and revenue is recognized in a future period
- An invoice for $100.00 is created on January 1 with an invoice date of January 1.
- A revenue schedule is created with a revenue item of $100.00 that was recognized in February.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 01/01/2014 | Invoice Item | 02/5/2013 | 100.00 | 0.00 | 0.00 | 100.00 |
Transaction date occurs in a previous period and the period to recognize revenue cannot be determined
- An invoice for $100.00 is created on December 1 with an invoice date of December 1.
- A revenue schedule is created in January with a revenue item of $100.00 and added to the Open-Ended period.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 12/1/2013 | Invoice Item | 01/1/2014 | 100.00 | 0.00 | 0.00 | 100.00 |
Transaction date occurs in future period and revenue is recognized in a previous period that is currently open
- An Invoice for $100.00 is created on February 1 with an invoice date of February 1.
- A revenue schedule is created with a revenue item of $100.00 that was recognized in December.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 02/1/2013 | Invoice Item | 01/01/2013 | 100.00 | 100.00 | 0.00 | 0.00 |
Transaction date occurs in a future period and revenue is recognized in a previous period and future period
- An invoice for $200.00 is created on February 1 with an invoice date of February 1.
- A revenue schedule is created with a revenue item of $100.00 that is recognized in December of previous year and in a future period.
An excerpt of the Revenue Detail Export for the January Accounting Period:
| Transaction Date | Transaction Type | Revenue Schedule Date | Revenue Schedule Amount | Recognized Prior to this Accounting Period | Recognized in this Accounting Period | Recognized after this Accounting Period |
|---|---|---|---|---|---|---|
| 01/01/2014 | Invoice Item | 02/5/2013 | 100.00 | 0.00 | 0.00 | 100.00 |