The quick answer
Open a prepared multi-book income statement, select both accounting books for the same subsidiary and period, and confirm the report's Difference formula. Click the linked Book 2 expense amount to open Multi-Book Income Statement Detail. Reconcile the journal rows to the summary and record the journal number with the filters you used.
This example investigates 6205 Payroll Adjustments for Alder Ridge India in Sep 2026. The prepared report shows INR 0.00 in Primary Accounting Book and INR 72,000.00 in India Statutory. The walkthrough identifies JE2046 as the journal contributing that difference. It uses an existing journal; no transaction is created or changed. Screenshots use sample data and fictional person and operating-company names.
Before you start
The account needs OneWorld with Multi-Book Accounting and both books associated with the selected subsidiary. Your role needs access to the financial report, both books, the subsidiary and the relevant transaction detail. The example uses a saved report named India Book Comparison with two book columns and a Difference column. Prepare that report first, or use an existing comparison whose definition you understand.
Confirm the reporting currency, cash or accrual basis, and the account's Report by Period preference. The standard Difference column is blank when the accounting-book currencies differ. Oracle describes the currency requirement here. Here the currency is INR, and India Statutory is a full secondary book. An adjustment-only book has different reporting behavior, so establish which type you're comparing before interpreting its balance.
For this prepared report, Difference = Book 1 minus Book 2. That formula is a prerequisite in this walkthrough; the recording does not open the report definition or configure its columns.
01. Set the comparison scope
In the demonstrated menu, go to Reports > Saved Reports > All Saved Reports and open India Book Comparison. In the footer, set the period from Sep 2026 through Sep 2026, Subsidiary Context to Alder Ridge India, Accounting Book 1 to Primary Accounting Book, and Accounting Book 2 to India Statutory. Click Refresh and check the selections again. If your report uses dates instead of accounting periods, use the corresponding September date range and keep that mode consistent in the detail.
02. Read the expense difference
Expand Ordinary Income/Expense > Expense and the account group containing 6205 Payroll Adjustments. Read across that account's row: Amount (Book 1) is 0.00, Amount (Book 2) is 72,000.00, and Difference is (72,000.00).
With this report's formula, 0.00 − 72,000.00 = −72,000.00. The parentheses display a negative result. They do not, by themselves, identify a debit or credit on the journal. A zero in Book 1 describes this filtered report result; it doesn't establish that the book has never contained a related posting.
03. Identify the journal in detail
Click the linked Book 2 amount on 6205 Payroll Adjustments. On Multi-Book Income Statement Detail, check that the subsidiary, period and books still match the summary. Expand the account if necessary.
The example has one journal row: JE2046, dated 09/18/2026. That transaction date alone does not establish its posting period. It contributes 0.00 in Book 1 and 72,000.00 in Book 2, with (72,000.00) in Difference. The account subtotal agrees with the summary. If your report has several rows, reconcile all of them to that subtotal.
The detail identifies a journal to investigate. If you need to establish that it is a book-specific journal, open the transaction when your access permits and inspect its accounting-book information. That additional check is outside this recording.
04. Return and verify the summary
Click Back to Summary. Check the account amounts and footer filters again. The result should still be 0.00, 72,000.00 and (72,000.00) for the same two books, Alder Ridge India and Sep 2026.
Document the conclusion with its scope: “For Alder Ridge India in Sep 2026, JE2046 contributes INR 72,000.00 to Payroll Adjustments in India Statutory and zero to the same row in the primary-book comparison.” Explaining why the journal was posted or whether its treatment is correct requires the transaction and supporting documentation.
Common questions
Does zero in Book 1 mean the expense was never posted?
Zero describes the amount included in this report's selected scope. It does not prove that no related posting exists in another period, account or reporting context. Record the scope with the amount before investigating the journal.
Does a negative Difference mean the journal is a credit?
No. Here Difference is Book 1 minus Book 2, so 0.00 minus 72,000.00 gives −72,000.00, displayed in parentheses. That subtraction does not identify the journal's debit or credit lines.
How do I know which book is primary?
Read the Accounting Book 1 and Accounting Book 2 selections in the report footer. The column labels alone don't identify the primary book. This example selects Primary Accounting Book first and India Statutory second.
Why is the Difference column blank?
On the standard Multi-Book Income Statement, Difference is blank when the selected accounting books use different currencies. Check the book currencies and the report definition before treating a blank as zero.
What should I check if detail doesn't match the summary?
Compare the subsidiary, period or date range, selected books, currency, basis and report filters. Check whether your role can see all the contributing detail. A mismatch needs investigation; the report alone does not establish its cause.
Does the report prove that JE2046 is book-specific?
No. It shows JE2046's contribution under the selected book filters. Open the journal and inspect its accounting-book information when you need to establish its book-specific status. The recording stops at report detail and returns to the summary.
Can I use an adjustment-only book for the same comparison?
Confirm its reporting behavior first. An adjustment-only book stores adjustments, and financial reporting can combine them with its base book. The prepared example uses a full secondary book. Don't interpret an adjustment-only result as though it were a separate complete ledger.