Journal Entry reports can be viewed on a single unit, filing group, sub-consolidated or consolidated basis (if the local currency is the same). All users can view the Journal Entry reports.

To access the Journal Entry reports, select Reporting > Journal Entry > Output Journal Entries.

 

ONESOURCE Tax Provision Reports are self-reconciling, and some tax calculation balances, in Output Journal Entry Reports, will tie back to other reports using the correct filters, for example, Tax Provision and Deferred Balances.

 

Output JE – Base (Unit Summary and Unit Detail, FG Detail)

This report will yield all calculated JE values based on Debit/Credit “GL Account” designation within the profile. It will list as many Journal Lines as you have created and show the value under the Debit or Credit column based on whether the balances net to positive or negative (Debit = Positive, Credit = Negative).

Unit Summary will net all units in the consolidated, sub-consolidated report level. Unit Detail will break lines out by unit.

FG Detail report will net values across the FG parent and child units. You will not see a breakout of units on this report, just the parent unit.

 

Output JE – JE by GL Account

This report will net the GL account values from the Output JE Base report, regardless of jurisdiction. The total of this report may not match the Base due to the way the numbers net together. For example, two GL Accounts with a Debit balance net with a GL Account that has a Credit Balance can net to a Debit or Credit designation.

 

Output JE – JE by GL Account (by Locality, by Unit, by Unit and Locality)

By Locality: this report will respect jurisdictions and separate the JE Base report into Federal and State.

By Unit (available in consolidated or sub-consolidation): Each unit section should tie back to the unit level report for the JE by GL account since this report just combines those individual reports and displays them together.

By Unit and Locality (available in consolidated or sub-consolidation): This report will give you the JE by GL account (by Locality) for each unit.

 

Output JE Calculation Detail (Unit Summary and Unit Detail)

Book values come from Trial Balance Tax Basis data entry screen. These are the GL sources specified in the Profile.

Tax values are calculated based on tax calculations in JE Profile.

The most detailed Output JE that will give you information on the JE Profile associated with the Locality, GL Account, JE Profile, Journal Line Code and Name, the Locality, Book or Tax designation, and Amounts).

 

Output JE – JE Summary by GL Account

Similar to the JE by GL account, this report utilizes the JE Summary field in the JE Profile Journal Lines setup to breakout JE reports further.

 

Output JE – JE Summary by GL Account (by Locality)

Similar to the JE by GL account (by Locality) report, this report will net values between Fed and State, while still breaking out the report by JE Summary.

 

Output JE – Export Detail

This report is the same as the JE Base (unit detail) with extra details from the JE Profile Line including supplemental data, an audit trail of when the JE was created, and details of whether any system, dataset, or unit-dataset parameters are associated with the line.

 

Output JE – Configuration Detail

This report details the JE Profile configuration details regarding the number of JE lines, number of Tax Calculations, number of GL sources (book), and whether a unit is assigned to the JE profile in question.

Best report to validate across Reporting Datasets as this report gives you a dataset column.

 

Journal Entry Support Report

This report summarizes Tax Calculations and Book GL Source values with acronyms.