Skip to content
English - United States
Contact Us
  • There are no suggestions because the search field is empty.

User Guide: Financial Report Custom Configuration

This guide demonstrates all steps required to configure customized Financial Reports for your Association(s) within Smartwebs, based on their unique needs and formatting requests. 

Report Categories

Income Statement groups

  • Income Statement Groups are created in order for the "Total" row to be relaced with "Current Year Net Income/(loss) on Income Statements
  • Navigate to Accounting > Settings > GL Funds & Categories > Report Categories
  • Select the "+ Report Category" button
  • Configure as follows:
    image.png
     
     
  • Total Label: "<br><span style="font-size:14px; font-weight:bold">Current Year Net Income/(Loss)</span>"
  • Make this group the "Parent" for all Income and Expense Categories
    image.png
     
     
  • Total Income (Bold) "<br><span style="font-size:14px; font-weight:bold">Total Income</span>"
  • Total Expenses (Bold) "<br><span style="font-size:14px; font-weight:bold">Total Expenses</span>"

Liability and Equity Groups

  • Liability & Equity Groups are created in order for the "Current Year Net Income/(Loss)" row to be in the Liability & Equity section of a Balance Sheet
  • Navigate to Accounting > Settings > GL Funds & Categories > Report Categories
  • Select the "+ Report Category" button
  • Configure as follows:
    image.png
  • Total Label: "<br><span style="font-size:14px; font-weight:bold">Total Liabilities & Equity</span> "
  • Note: The subcategory under Liabilities & Equity Group for Equity must be labeled as "Equity" in order for the option to show on the report. If you need another name displayed, such as "Capital", you can use the Name Label field to add the name.

     

    Reports

    Custom Report Configurations.docx

    Income Statement Detail – Combined

    1. Configuration

    • Config > Copy to Management
    • Remove “- Copy” from the Name field

    2. Grid Designer: Type 1

    • Values Template: "<br><span style='font-weight:bold;'></span>"
    • Total Template: "<br><span style='font-weight:bold;'></span>"
    • Expand Type 1 (auto-collapses after changes)
    • Click Apply and Save

    3. Columns Configuration

    For the following columns:

      • Current Month
      • Variance
      • YTD Actual
      • YTD Variance
    • Cost Center: Select All
    • Fund: Select All
    • Uncheck: Show Total for Report
    • Click Save

    For the following:

      • Budget Monthly
      • YTD Budget
      • Yearly Budget
    • Uncheck: Show Total for Report
    • Click Save

    4. Blank Columns

    • Go to Options > Delete
    • Click Apply and Save

    5. Resize Button

    • Widen the Account Name column as needed

    6. Template

      • Associations: Select all using this report
      • Body Tab:
    • Add margin: style="margin:0 20px;width:95%"
    • Optional: text-transform:uppercase (for all caps)
    • Click Save

    7. More Options

    • Cost Center: Select All
    • Fund: Select All
    • Options > Save
    • Hide Standard Report
     

    Income Statement Detail – Specific Cost Center / Fund

    Follow the same steps as above with these differences:

    Name

    • Rename to reflect the specific Cost Center or Fund

    Columns

      • For each column, select:
    • Cost Center: The specific one the report represents
    • Fund: Select All (or the specific Fund, for Fund reports)
    • Uncheck Show Total for Report
    • Click Save

    Template

    • Associations: Must exactly match the selected Cost Center or Fund name
    • Header Tab: Update middle column with Fund or Cost Center name or use the Name parameter
    • Click Save
     

    Income Statement Detail – Accrual vs Cash

      • Use the appropriate steps based on Combined, Cost Center, or Fund format
      • Config > Template > Header Tab: Adjust Name for Accrual/Cash
      • More Options:
      • Rename: e.g. Income Statement – Accrual or Cash
      • Balance Based On:
    • Revenue: Accrual or Cash
    • Expense: Accrual or Cash
    • Options > Save
    • Hide Standard Report
     

    2025 Budget (Combined / Cost Center / Fund)

    1. Configuration

      • Config > Copy to Management
      • Name: Remove “- Copy”
      • More Options:
    • Enable Define Cash vs Accrual by Account Type
    • Save

    2. Grid Designer

      • For each month (e.g. Jan 2025, Feb 2025...):
    • Cost Center: All or specific (depending on report type)
    • Fund: All or specific
    • Uncheck: Show Total for Report
    • Save
      • After all months:
    • Click Apply and Save

    3. Template

    • Associations: Select all associations with matching Cost Centers and Funds

    4. More Options

      • Balance Based On:
    • Revenue: Accrual or Cash
    • Expense: Accrual or Cash
    • Options > Save
    • Hide Standard Report
     

    2025 Budget – Accrual vs Cash

      • Follow applicable 2025 Budget setup (Combined, Cost Center, or Fund)
      • Update Header Tab name to include "Accrual" or "Cash"
      • More Options:
      • Name: e.g., “2025 Budget – Accrual” or “Cash”
      • Balance Based On:
    • Revenue: Accrual or Cash
    • Expense: Accrual or Cash
    • Options > Save
    • Hide Standard Report
     

    2025 Income Statement – Monthly Comparison

    1. Configuration

    • Config > Copy to Management
    • Remove “- Copy” from Name
    • Save

    2. Grid Designer

      • Account Type 1:
    • Values Template: "<br><span style='font-weight:bold;'></span>"
    • Expand after changes
    • Apply and Save
      • For each month (e.g., Jan 2025 to Dec 2025):
    • Select relevant Cost Center/Fund
    • Uncheck: Show Total for Report
    • Click Save
      • After all months:
    • Click Apply and Save

    3. Template

      • Associations: Select all using this report
      • Body Tab:
    • Add style: margin:0 20px;width:95%
    • Optional: text-transform:uppercase
    • Save

    4. More Options

    • Select appropriate Cost Center and Fund
    • Options > Save
    • Hide Standard Report
     

    Fund Balance Sheet

    1. Configuration

      • Copy to Management and rename (remove “- Copy”)
      • More Options:
    • Enable Define Cash vs Accrual by Account Type
    • Save

    2. Grid Designer

      • Report Category 1:
    • Values Template: "<br><span style='font-weight:bold;'></span>"
    • Total Template: "<span style='font-weight:bold;'>Total </span>"
    • Indent: 0px for both data and totals
    • Group Header Height: 15px
    • Save
      • Columns:
    • Operating / Reserve: Field selected, Cost Center = All
    • Totals Column: Cost Center = All
    • Additional Columns: Add by Fund, enable “Show Total for Groups” > Report Category
    • Apply

    3. Template

    • Associations: All applicable ones
    • Save

    4. More Options

    • Net Income Location: Choose “Separate Group” or “Include in Equity”
    • If Net Income should display in Liabilities & Equity, ensure the report category includes Liabilities & Equity Groups
    • Options > Save
     

    Fund Balance Sheet – Accrual vs Cash

      • Follow standard Fund Balance Sheet steps
      • More Options:
      • Balance Based On:
    • Revenue: Accrual or Cash
    • Expense: Accrual or Cash
    • Options > Save
    • Hide Standard Report
     

    General Ledger Report

      • More Options:
      • Enable Define Cash vs Accrual by Account Type
      • Balance Based On:
    • Revenue: Accrual or Cash
    • Expense: Accrual or Cash
    • Options > Save

    End of Guide