You are here: All Help Topics > Accounting and Assurance > Working Trial Balance > Creating Split-Ups for Accounts

Creating Split-Ups for Accounts

Working Papers allows you to split up accounts on the trial balance (e.g. breaking up a client supplied account into taxable and non taxable portions) for better granular control of account data throughout the entire engagement.

Note: Split-up accounts and the main account will now use the same foreign exchange rates.

Procedures

On the Working Trial balance, click the next to the account number. The Split-up Accounts dialog opens.
Tip: CTRL+SHIFT+S is the shortcut to open the Split-Up Accounts dialog.
Split-up accounts can have their own period balances. For each split-up account you create, specify the period date sequence such as Yearly, Monthly, or Quarterly, etc. from the drop-down menu. Under Account number, enter the account number for the split-up. If the account being split-up is 403, you could use 403.1 as the account number for the first split up.
Enter a descriptive name for the split up account and enter the remaining information for the split-up.
As required, follow this procedure to add more split-up accounts.
Note: Each account number must be unique.
Before exiting, ensure that the combined balances of the split-ups totals the original balance of the account.
Click Close.

Results

Account has assigned split-up and a will display beside the account name. If the split-ups become unbalanced, or if any changes have been made to the file, such as the deletion of an adjusting entry that affects this account, a warning symbol displays. When you close the dialog, the status (balanced/not balanced) will be set for the current period you are in, as well for any following periods. For example, if you change period 2 in a quarterly file, the status of balanced or not balanced will be set for periods 3 and 4. To clear the symbol, review the balances and make any changes, if necessary. To be notified when a split-up account is unbalanced, select the appropriate option in Tools | Options | Advanced | Split-up.

Notes:

Any change to the parent account will not be reflected on automatic documents until the split-up accounts are opened.
If you enter a preliminary balance of 100 in period 1 for split-up account 1000.01, then the balance in period 2 and all other subsequent periods will also be 100. Any amount changes to a split-up account will affect balances subsequent to that period by adding the difference between the previous and currently entered balance. In the same example, if you then change the period 2 balance to 200, all subsequent periods will be 200, but period 1 will still be 100. If you go back and change period 1's balance to 200, then the subsequent periods' balances will be 300 (original 200 plus the 100 change in period 1's balance).