How to set up Multi-Book Accounting in NetSuite OneWorld
Multi-Book Accounting lets one set of transactions post to several accounting books at once - for example local GAAP and IFRS - each with its own base currency, account mapping and revenue or depreciation rules. You enable the feature, create the secondary book, assign subsidiaries, set per-book rules, then transact once and post to all books.
Prerequisites
You need the Administrator role, or a role with the Accounting Books and Manage Accounting Books permissions; enabling features requires Administrator.
- A NetSuite OneWorld account with subsidiaries, base currencies and chart of accounts already set up.
- The Multi-Book Accounting feature licensed - it is a paid add-on; confirm Adjustment-Only or full Multi-Book entitlement with your account team.
- A clear statement of why a second book exists (different GAAP, different functional currency, different revenue or asset rules) so the mapping is purposeful.
Steps
- Enable the feature. Go to Setup > Company > Enable Features > Accounting and tick Accounting Books (and Adjustment-Only Books if licensed). Enabling Multi-Book cannot be cleanly undone once transactions post, so confirm the design first.
- Create the secondary accounting book. Go to Setup > Accounting > Manage Accounting Books > New. Name the book, set its base/representation requirement, and leave it in a pending state until mapping is complete.
- Assign subsidiaries to the book. On the accounting book, add each subsidiary that should post to it and set the book's base currency per subsidiary. Only assigned subsidiaries generate postings in the secondary book.
- Map accounts and set per-book rules. Where the secondary book uses a different chart or treatment, configure account mapping and book-specific rules (revenue recognition, depreciation, currency) so each book posts under its own policy.
- Activate the book and transact. Set the book to active. From then on, each transaction posts to the primary and the secondary book simultaneously, each under its own rules - you enter the transaction once.
- Report per book. Run financials with the Accounting Book filter to produce statements for each book; reconcile the books to confirm the mapping behaves as designed before relying on it for close.
Gotchas
- Enabling Multi-Book is effectively one-way once transactions post - plan the book structure before you turn it on, not after.
- Adjustment-Only Books are cheaper but only hold manual adjustments, not full parallel postings - confirm which entitlement you have before promising full dual-GAAP statements.
- Foreign-currency books need their own exchange-rate and revaluation treatment; a secondary book in a different base currency revalues independently of the primary.
- Not every transaction type and SuiteApp is Multi-Book aware - test the full transaction set, including revenue and fixed assets, before go-live.
Where this bites in an implementation
Multi-Book is usually scoped for groups that must report under two standards at once (local GAAP plus IFRS) or hold a different functional currency for management reporting. The cost driver in an implementation is the account mapping and the per-book revenue and asset rules, plus the extra testing to prove both books reconcile - it materially adds Design, Build and Test effort.
Frequently asked questions
- What is the difference between a full and an Adjustment-Only Book?
- A full accounting book records complete parallel postings for every transaction under its own rules. An Adjustment-Only Book holds only manual adjustment entries on top of the primary book. Adjustment-Only is lighter and cheaper but cannot produce fully independent statements.
- Can a secondary book have a different base currency?
- Yes. Each subsidiary-book combination has its own base currency, so a secondary book can report a subsidiary in a different functional currency, with its own exchange-rate and revaluation treatment, independent of the primary book.
- Can I turn Multi-Book off later?
- Practically, no. Once transactions post to a book the feature cannot be cleanly reversed, so the book design must be settled before you enable it. This is why Multi-Book belongs in the design phase, not as a later add-on.
Last reviewed: by Wouter Nortje, CA