Working with Subledger Accounts

Use this information to add, paste as, protect, edit, or delete a subledger.

To watch a training video that explains this process, enroll in the FPS Distributed Forecasting - Forecasting with Subledger Accounts training video course on Jack Henry University. You can also enroll in the Distributed Forecasting in Financial Performance Suite learning plan.

Note: Forecasting with subledgers is only available for What If models set with the Allow Subledgers option set to Yes.
Subledger accounts let you budget with greater detail than what the forecasting grid provides. Examples of places where forecasting with subtotals is beneficial are when you are working with employee salaries, fixed asset purchases, and travel expenses. You can add subledgers to balance sheet and non-interest income/expense accounts.
  1. Navigate to Forecasting > Detail.
  2. Select a situation for your subledger and follow the corresponding steps.
    Situation Steps
    Add Subledgers

    This option allows you to add subledgers to balance sheets or non-interest/expense accounts.

    1. Select the account that you want to add a subledger to.
    2. Select Add Subledgers and choose Add.
    3. In the Add Subledger window, enter a Name for the subledger.
    4. Select either Yes or No to Protect the subledger.
    5. Select None or Custom for the Formula field.

      Select Custom if a formula determines the value of the account. Formulas are entered manually or built using the provided tools to specify and insert each component.

    6. Select Save.

      The new subledger appears in the forecast grid as a row, and the selected account becomes a subtotal.

      The existing forecasted balance in the selected account becomes the forecasted balance in the first subledger.

    7. Continue adding subledger accounts as necessary.
    Paste As

    This option offers a convenient way to add subledgers by pasting in names or titles from a spreadsheet you are already using.

    1. Copy the text from your spreadsheet that you want to become subledger titles.
    2. Select the account to add the subledgers to.
    3. Select Add Subledgers and choose Paste.

      The subledgers appear in the forecast grid as rows in alphabetical order. The account that you selected becomes a subtotal.

      The existing forecasted balance in the selected account becomes the forecasted balance in the first subledger.
    Protect Subledgers

    This option allows the creator of a subledger to protect their subledgers. It prevents others from viewing and/or changing confidential information.

    1. Select the subledger account that you want to protect.
    2. Select "" Settings.
    3. Select Yes to Protect the subledger.
    4. Select Save.

      When the subledger is protected, a "" lock appears to the left of the account.

      To remove the protection, select "" Settings and choose No next to the Protect field.

      When subledgers are protected, other users, including reviewers and administrators, see a total account for all subledgers named Protected Subledgers but not the individual subledgers.
    Edit Subledgers
    CAUTION:
    Anyone with access to accounts and organizations with subledgers can edit the subledgers unless they are protected.
    1. Select the subledger account that you want to edit.
    2. Select "" Settings.
    3. Choose to edit the subledger name, protect the subledger, or add a formula.
    4. Select Save.
    Delete Subledgers
    CAUTION:
    Anyone with access to accounts and organizations with subledgers can delete the subledgers unless they are protected.
    1. Select the subledger account that you want to delete.
    2. Select "" Delete.
    3. Select Yes in the Delete window that appears to confirm that you want to delete the subledger.

      The balance in the deleted subledger is deleted. The parent account only reflects the sum of balances in the remaining subledgers.
Parent topic: Distributed Forecasting Training Videos - End User Tasks