Consolidation books list

The Books list is the central place to go to view, edit, and delete Global Consolidation and Domestic Consolidation books or add new ones.

About consolidation books

Global Consolidation: A consolidation book takes entities that perform their day-to-day operations in different accounting currencies and consolidates them into a single currency for reporting. A typical example would be a region that has areas that operate in different currencies, but results must roll up into the regional totals. This requires converting operating currencies into the reporting currency, posting any currency translation adjustments that occur, and eliminating inter-entity balances that are conducted in different operating currencies.

Domestic Consolidation: A consolidation book created with Domestic Consolidation consolidates day-to-day operations across entities in a multi-entity company with a single base currency. Domestic Consolidation books provide accurate auto-eliminations for inter-entity transactions. You can still transact in more than one currency when using Domestic Consolidation, as long as you use a single base currency.

You must set up at least one consolidation book before you can run or view any consolidation information.

Edit a book

What happens when you edit a consolidated book

• After running a consolidation, you can change the book setup by adding a new entity or account; and changing the historical rate date option (above the table of accounts, Consolidation only) and consolidated dimensions.
• If you change your book setup and then re-consolidate a previously consolidated period, then your posted entries will change.
For example, suppose you enable the Customer dimension for a particular book, and then consolidate that book. Then you decide to disable the customer dimension for that book, and re-consolidate. Your posted entries will not include the Customer dimension.
• You can't remove entities, change the translation method or reporting currency, or switch to automatic elimination of inter-entity balances. If you need to make changes to the book setup, delete the book and then create a new book.

1. Go to Consolidation > Setup > Books.

2. On the Books list, select Edit for the book you want to change.
3. Update the consolidation book.
4. Select Save to save your changes.

If the book doesn't appear in the list, try enabling Include inactive to see books that were marked as inactive. When you include inactive, the system adds a Status column to the list.

View a book

1. Go to Consolidation > Setup > Books.

2. On the Books list, select View for the book you want to change.
3. On the Book setup page that appears, select Edit to make changes, or Done to close Book setup page and return to the list.

Add a book

1. On the Books list, select Add at the upper right of the page.
2. Follow the procedure for adding a book.

Delete a book

1. Go to Consolidation > Setup > Books.

2. On the Consolidation books page, select the book you want to delete.
3. Select View to verify the book information.
4. Select Done to return to the list.
5. Select Delete next to the book.

Delete a user-defined book with previously consolidated transactions

If you want to delete a user-defined book that includes previously consolidated transactions, you'll need to take specific steps to do so.

1. Delete the accrual transactions from the user-defined journal.

   1. Go to General Ledger > All > Journal entries > User-defined.

   2. Find the user-defined journal and select View transactions.
   3. Select Delete at the top of the Delete column to select all the transactions for deletion.
   4. Select Delete to remove all transactions.
2. Re-consolidate the book that includes the user-defined book you want to delete. Use the period with consolidated data from the book.
3. Delete the user-defined book. Intacct automatically deletes the book's journal.

   1. Go to General Ledger > Setup > More > User-defined books.

   2. Find the user-defined book and select Delete next to it.

What happens next: Intacct automatically deletes the user-defined journal associated with the user-defined book you just deleted. Go to General Ledger > Setup > Journals > User-defined to confirm the user-defined journal has been deleted.

Field descriptions

The following table describes each item in the consolidation books list.

Columns

Field	Description
Book ID	Select to sort the list by book ID. Enter text in the text box, then select Book ID to filter the list.
Description	View the book description, if one was included.
Consolidation currency	Shows the currency used for consolidation.
Edit (link)	Open the book for editing.
View (link)	View the details about the book.
Delete (link)	Delete the book.
Add (button)	Add a new book to the consolidation configuration.
Done (button)	Close the list.
Export (button)	Export the list of books to a CSV, Excel, Word, or PDF document.