Multibook Ledgers

The PeopleSoft Multibook feature enables you to maintain multiple ledgers, sharing the same physical structure, in different base currencies, resulting in a real-time balance in multiple currencies. This functionality is also called dual-book due to the requirement for a company to carry one set of books in its local currency (functional currency) and another set of books in the currency of its parent company (reporting currency).

Multibook supports multiple base currencies, each in the form of a ledger, defined for a business unit. Optionally, you can post a single transaction to all base currencies (all ledgers) or to only one of those base currencies (an individual ledger). With multibook, the system automatically converts transactions to the applicable base currency and then posts to the corresponding ledger. This gives you full drill-down support and cross-currency comparisons at both the summary and the transaction levels.

You can use a secondary multibook ledger within a ledger group as a currency translation ledger. This ledger can function as your reporting ledger because it maintains real-time balances for all accounts in the specified currency during the accounting period. At the end of the accounting period, you can run the Translate Within Ledger process to generate a translation gain or loss adjustment within the multibook translation ledger for any selected account.

PeopleSoft maintains translation ledgers differently from other secondary ledgers within a multibook ledger group. Typically, when the system posts a transaction to a multibook ledger group, it uses the transaction currency amount of the primary ledger as the transaction amount of the secondary ledger. However, translation ledgers use the base currency amount of the primary ledger as the transaction amount. For multibook translation ledgers, the system generates lines with the transaction currency and foreign amount equal to that of the base currency and base amount of the primary ledger.

Within a ledger group, an in-sync accounting entry is a group of accounting entries for one transaction that the system distributes to different ledgers. These accounting entries have the same ChartFields, transaction currency, and foreign amounts. PeopleSoft applications support multibook and generate in-sync accounting entries to most ledgers within a ledger group. For the currency translation ledger, the Journal Edit process adds the in-sync entries before posting and creates completely in-sync journals. The Journal Generator recognizes these lines as in-sync accounting entries and generates the in-sync journal entries in General Ledger. You can specify the field order on the Journal Generator Accounting Entry Definition page. When generating the journal entry, the Journal Generator process uses these fields to determine how to group accounting entries for one transaction and generates an in-sync journal.

Note:

Some PeopleSoft products may not include the currency translation ledger. Refer to the individual product documentation to see if this feature is available.