Financial Reports Hub Setup

Body

Overview

The Accounting Seed Financial Reports Hub enables users to create and format reports using a dynamic grid where users can change periods, dimensions, and groupings on the fly without rerunning reports (similar to Excel pivot tables). Your org must have the Financial Suite Winter '26 version 3.363 or later installed to use this feature.  You can watch a configurations overview in this video.

Note: if your org has more than 1M transactions, follow steps 1 through 7, then create a ticket for Support so they can assist you with some configurations before you perform step 8.

Setup

Prerequisite: Financial Suite Version 3.363 or later

You must be using the Financial Suite Winter '26 version 3.363 or later. Click here to update your version, if necessary.

 

Step One: Set up Permissions for the Hub user and Report users

Permissions for AS Hub Authorization:

  1. Identify an admin user to authorize the AS Hub and assign the appropriate permissions to them. Some organizations have an "integration user", follow the same steps.
  2. Assign the AS Full Admin permission set to this user and ensure they have a full Financial Suite license.
  3. The next step depends on the Financial Suite release version on your org:
  • Option A: If your org is on the Summer '26 Preview release  (3.401) or later:
    1. Navigate to Setup > Permission Sets and click the “AS Hub Authorization” base permission set.
    2. Click Clone and rename it to something like "AS Hub Additional".
      1. Click System Permissions. Click the Edit button.
        1. Search for Approve access to connected apps that aren’t installed in this org and select the checkbox. Click Save.
      2. Click Object Settings > click Accounts > click Edit then check Read access for the following fields on the Account object: 
        1. Id
        2. Name
        3. Type
        4. Industry
        5. BillingState
        6. BillingCountry
        7. AcctSeed__Accounting_Type__c
        8. AcctSeed__Accounting_Active__c
    3. Navigate to Setup > Users; find the user who will authorize the AS Hub, and assign both the “AS Hub Authorization” base and the "AS Hub Additional" permission sets to them.
    4. Assign the “AS Hub Authorization” base permission set to this user and save your changes. Skip to #4.d below to add the System permission.
  • Option B: If your org is on a release earlier than Summer '26 Preview  (3.401):
    1. Navigate to Setup > Permission Sets
    2. Click New to create a custom permission set named “AS Hub Authorization”. 
    3. Click Object Settings > click Accounts > click Edit then check Read access for the following fields on the Account object: 
      1. Id
      2. Name
      3. Type
      4. Industry
      5. BillingState
      6. BillingCountry
      7. AcctSeed__Accounting_Type__c
      8. AcctSeed__Accounting_Active__c
    4. Click Apex Classes and add the following to the permission set: 
      1. AcctSeed.AccountingSeedHubHelper
      2. AcctSeed.AccountingSeedHubService
    5. Click System Permissions. Click the Edit button.
      1. Search for Approve access to connected apps that aren’t installed in this org and select the checkbox. Click Save.
    6. Assign this permission set to the user authorizing the Accounting Seed Hub.

Permissions for Financial Reports Hub Users:

  • If you use Accounting Seed’s out of the box permission sets and your users have the permissions to access the existing Financial Reporter, no additional permissions are necessary to use the Financial Reports Hub.
  • If you use custom permission sets, then extend permissions to these three objects: Financial Report Category, Financial Report Type, and Financial Report Detail.

 

Step Two: Authorize the Accounting Seed Hub

Important: Apart from the permissions in Step one, the authorizing user must be an admin user with a full Financial Suite license, and a Salesforce license assigned. If using an integration user, you must login using the credentials to authorize the AS Hub. Follow these steps to authorize the AS Hub: 

  1. Navigate to Accounting Home and click the Setup tab. Then, under the Utilities menu, click Accounting Seed Hub.
  2. Click the Authorize Accounting Seed Hub button. The Allow Access dialog box opens.
  3. Click Allow.

The Accounting Seed Hub Authorization page refreshes and the email address of the person who authorized the Hub is displayed.  The button changes to Re-Authorize Accounting Seed Hub. The org is now ready to send and receive real-time information.  For more information, see Authorize the Accounting Seed Hub.

 

Step Three: Activate Remote Site Setting

  1. In a production org, navigate to Setup then search for and click on Remote Site Settings.
  2. In the list check if ASQProd_AccountingSeed.
    1. If it is not listed, click New Remote Site and set the Remote Site Name as ASQProd_AccountingSeed.
    2. Set the Remote Site URL as https://asqprod.accountingseed.com
  3. Next click on Active, to activate it.
  4. Click Save.
  5. Similarly, ensure the Remote site URL https://api.accountingseed.com is listed and is active.

Note: If you are testing in a sandbox org, ensure these Remote Site URLs are listed and active. You may need to add them manually; set the Name to be unique and without spaces:

 

Step Four: Enable Session Setting

  1. Navigate to Setup and search for Session Settings.
  2. On the Session Settings screen, find and select the checkbox next to Use Lightning Web Security for Lightning web components and Aura components.
  3. Click Save. 

 

Step Five: Update Navigation, Page Layout, List views and Custom Field Sets

  1. Recommended: Add Financial Reports Hub to the navigation bar.
    1. Click the edit icon (pencil) on the tab navigation ribbon.
    2. Click the Add More Items button.
    3. Click the plus sign (+) next to Financial Reports Hub in the list (you may need to scroll).
    4. Click Add 1 Nav Item.
    5. Click Save.
  2. Add new fields to the General Ledger Account page layout: 
    1. Navigate to Setup > Object Manager > General Ledger Account > Page Layouts.
    2. Click the Page Layout being used and drag these three fields to the Information section of the page layout:
      • Include in COGS
      • Include in Other Income/(Expense)
      • EBITDA Adjustment
  3. Add fields to the General Ledger Account list view for quick access when updates are needed.  Do this if you intend to update your GL Accounts for Gross margin, EBITDA or Other Income/Expense.
    1. Navigate to App Launcher > General Ledger Accounts
    2. Select your list view that shows all GL Accounts.
    3. Click the list view controls gear drop-down, then click Select Fields to Display.
    4. In the Available Fields list, find Include in COGS, Include in Other Income/(Expense), and EBITDA Adjustment and move them to the Visible Fields list.
    5. Click Save. 
  4. Add buttons to the Accounting Period list view. Do this if you intend to update your GL Accounts for Gross margin, EBITDA or Other Income/Expense.
    1. Navigate to Setup > Object Manager > Accounting Period > List View Button Layout.
    2. On the row level action drop-down on the right, click Edit.
    3. Move the Create Accounting Periods and the Refresh Accounting Periods buttons to the Selected Buttons list. 
    4. Click Save.
  5. Optional: Configure custom Field Sets to define additional fields available in the report grid that be can selected as columns or filters in the report.
    1. In Salesforce Setup, navigate to Setup > Object Manager > Transactions.
    2. Select Field Sets on the left pane.
    3. Choose the field set you want to modify:
      1. To add a custom field as a column, choose one of the reports' field sets with “Column” in the name.
      2. To add a custom field as a filter, choose one of the reports' field sets with “Filter” in the name. 
    4. On the right drop down, click Edit.
    5. Drag the custom fields you want to make available into the field set.
    6. Save the field set.
    7. Repeat these steps for any of the other field sets you want to configure.
    8. Important: Once you have saved the field set, go to the Financial Report Data Manager and refresh your report data. Once the refresh is complete, the fields appear and can be selected as columns or filters in the Financial Reports Hub report grid.
  6. Optional: Rename GL Account Variables (GLAVs) in the Financial Reports Hub. If your organization has already renamed the GL Account Variables, they will display with these renamed labels (Version 3.398 or later) and no further configuration is required.  However, if you would like to rename them using the Translation Workbench. Custom GLAV labels will display throughout the Financial Reports Hub, including in the Filters panel, Columns panel, row grouping area, column grouping area, and as column headers on the GL and drill-down reports.
    1. Navigate to Setup > User Interface > Translation Workbench > Translate.
    2. In the Language dropdown, select your default language (for example, English).
    3. In the Setup Component dropdown, select Custom Field.
    4. In the Object dropdown, select Transaction.
    5. Locate the GL Account Variable fields (GL Account Variable 1, GL Account Variable 2, etc.) in the list.
    6. In the Translation column next to each field, enter the custom label you want to display.
    7. Click Save.
    8. Important: Once you have saved changes to GLAV's label, go to the Financial Report Data Manager and refresh your report data. Once the refresh is complete, the labeled GLAVs will appear and can be selected as columns or filters in the Financial Reports Hub report grid.

 

Step Six: Set up GL Accounts for Gross margin, EBITDA or Other Income/Expense (Optional)

To include gross margin, other income/expense, or EBITDA sections on reports, evaluate your P&L GL Accounts (Type = Revenue or Expense) and select the appropriate checkbox.   

  1. Navigate to General Ledger Accounts.  
  2. Either using the list view you set up with the 3 new fields or by editing each P&L GL Account separately, select the box(es) based on where the GL Account should be shown: 
    • Select Include in COGS if the account should appear in the Cost of Goods Sold/Gross Margin section.  
    • Select Include in Other Income/(Expense) if the account should appear in the Other Income & Expense section.  
    • Select Include as EBITDA Adjustment if the account should be included in EBITDA calculations.  
    • If no boxes are selected, the account appears in the Operating Expenses section. 

 

 Step Seven: Set up Accounting Period Quarters and Years (if not already done)

All Accounting Periods require Year and Quarter information before data is displayed in the Financial Report Hub grid.

  1. Follow the steps in this article: Set up Accounting Periods to set up Period Quarters and Years, if you have not already done so.

 

Step Eight: Run/schedule an initial Data Refresh

Before you can run reports in the Financial Reports Hub, you must first run or schedule an initial data refresh.  

Data Source is Local

On the Financial Report Data Manager tab if your Data Source is set as Local follow these steps to refresh your data:

  1. On Financial Reports Hub, click on the Financial Report Data Manager tab.
  2. Select the report categories to refresh (P&L, Balance Sheet, Trial Balance, and/or General Ledger).
  3. Click the Refresh Data Now button to start the data refresh immediately.  You can alternatively schedule the data refresh for a later time.
  4. When the Last Refresh Status displays the status of Completed, reports in the refreshed Report Category can be viewed.

Data Source is External Storage

On the Financial Report Data Manager tab if your Data Source is set as External Storage follow these steps to refresh your data:

  1. On Financial Reports Hub, click on the Financial Report Data Manager tab.
  2. Select the report categories to refresh (P&L, Balance Sheet, Trial Balance, and/or General Ledger).
  3. Click the External Storage button.
    1. Best practice: Schedule the refresh: enable the toggle "Enable this Data Refresh Schedule".  Pick a non-peak time to run this and save your changes.
    2. Alternatively, if you want to begin the refresh right away, click Refresh Data Now and then Close.  
  4. When the Last Refresh Status displays the status of Completed, reports in the refreshed Report Category can be viewed. Note that there are some indexing jobs that run after the refresh to help query data quicker, so our recommendation is to schedule the refresh.

Financial Reports Hub Configuration (video)

This video walks through the Setup steps in this article.

     

        See also:

        Return to top

        Title
        Financial Reports Hub Setup
        URL Name
        2051018129
        ReportingFinancial Reports Hub
        Skip Feed

        Nothing here yet?

        Log in to post to this feed.

        End of Feed
        Nothing here yet?Log in to post to this feed.