WORKPAPERREADY · PREPARATION SUPPORT

See what a working file contains.

Follow a fictional corporate file from trial balance to financial schedules, retained earnings and a provisional E&P bridge. Inspect the formulas, source trail and questions that remain for review.

Fictional ExampleForeignCo · 2025 · EUR throughout · Editable Excel · No client documents included

Inside the delivery

01 / Delivery

A concise summary of the prepared figures, unresolved conclusions and engagement boundaries.

02 / Financials

Source-linked income statement, balance sheet and retained-earnings rollforward.

03 / E&P bridge

A provisional bridge from book profit using illustrative supplied adjustments. A separate reviewed distribution-reduction input stays blank.

04 / Trial balance

Editable debit and credit inputs, account mapping and independent statement controls.

05 / Sources

A register of fictional document IDs, page references and the purpose of each input.

06 / Open items

Evidence requests, technical decisions, responsible parties and four arithmetic tie-outs.

AN EXCERPT FROM THE FILE

The number and the trail behind it.

Illustrative amounts in EUR. All figures and references are invented.
Working lineAmountSource or calculation
Book net profit120,000Financials → TB01 / TAX01
Opening retained earnings280,000TB01 / account 3100
Cash distributions(50,000)BANK01 / p. 2
Closing retained earnings350,000280,000 + 120,000 − 50,000
Provisional current-year E&P140,000120,000 + supplied 12,000 + 8,000
Closing E&PNot determinedReviewed reduction not entered

The EUR 12,000 and EUR 8,000 adjustments are illustrative supplied inputs, not tax rules or approved positions. Cash paid is not automatically treated as an E&P reduction. Closing E&P remains “Not determined” until the separate reviewed input is entered.

A file you can inspect.

Change a blue input and follow the linked schedules. Compare calculated assets and retained earnings with separate reported controls. The Open items tab shows differences and unresolved questions; a zero difference establishes only the illustrated arithmetic, not source completeness or tax accuracy.

Income-statement and balance-sheet schedules can support Form 5471 preparation within the agreed scope. This example stays in EUR and does not supply completed form entries, currency translation, a tax opinion or filing conclusions.

Preparation, decisions and filing.

We organize supplied records, prepare agreed schedules and document source references and open questions. The responsible CPA or filer approves technical treatment, elections and filing positions. Deliverables, records, deadlines and revisions are agreed before work starts.

This is a fictional delivery-format example, not a client case, an independent review or a completed tax return. See the IRS Form 5471 instructions for official form guidance.

A simpler example for individual records.

The original four-tab book-profit reconciliation remains available for a shorter introduction to source references and open questions.

Download the simpler example (.xlsx) ↓