Articles in this section

See more

Gravity GASB 103 Updates Instructions

Below are the two main sections in Gravity that the GASB 103 Updates affect. Select either to navigate directly to it:

  1. Governmental Funds Budgetary Schedules
  2. Proprietary Funds Statement of Revenues and Expenses

Governmental Funds Budgetary Schedules

These instructions detail the changes required to update your Governmental Funds Budgetary Schedules (General Fund and Major Special Revenue Funds) to the new GASB 103 compliant layout. Select a section of the process to navigate directly to it.

  1. Create New Column(s) in the MDFM
  2. Create New Column(s) in the Statements (Spreadsheets)
  3. Make Formula Modifications in Column A (Query)

New column(s*) to be created in MDFM

One or Two columns should be added: 

  • Original Budget
  • Variance between Final and Original Budgets. 

Please submit a ticket to support with the subject “GASB 103 - Add new metric columns in MDFM - Governmental Funds - Budgetary Schedules”. 

Note: Processing of the ticket may take 3-5 working days.

New column(s) to be created in the Statements (Spreadsheets)

Template-Based Schedules with No Excel Formulas

To add the columns to a template-based schedule, you will have to complete the following steps. 

1. Right Click one 3 lines / dots icon near the name of the object. 

2. Press “Edit Import”.

 3. When the Edit window with Edit appears, click next in the right bottom corner.

4. Click again next in the right bottom corner to be moved to step 3 “Customize Data”.

 5. Click icon “Field Chooser”. 

6. Select newly created metrics in the list of “ALL Fields”. 

7. Reorganize metrics in the “Data fields” in the Right bottom corner of the “Field Chooser” window, so they appear in the following order: 

  • Original Budget (Data Column) 
  • Final Budget (Data Column) 
  • Variance with Original Budget (New Data Column) 
  • Actual Amounts (Data Column) 
  • Variance with Final Budget (Data Column). 

8. Close “Field Chooser” 

9. Click “Next” 3 times more, then “Finish”. 

Afterwards, check that the schedule is updated as expected. Repeat the same steps for all other budgetary schedules which need to be updated.

Formulas-Based Schedule

Part 1: Follow the same as for Template-based Schedule (select the link to navigate directly above).


Part 2. Update spreadsheet layout and formulas.

To accomplish this: 

Note: Select any bolded section above to navigate directly to it. 

Insert the New “Original Budget” Column

  1. Open the spreadsheet in Gravity.
  2. Find the Final Budget column.
  3. Right-click on the column at the top of the grid.
  4. Select “Insert 1 column left”.
  5. Do the same to add one more column.

Two new columns will be created.

  • Original Budget column (Column D).
  • Empty Spacer column (Column E).

Insert the New “Variance with Original Budget” Column

  1. Open the spreadsheet.
  2. Find the Actual Amounts/Actual column.
  3. Right-click on the column at the top of the grid.
  4. Select “Insert 1 column left”.
  5. Do the same to add one more column.

Two new columns will be created.

  • Variance with Original Budget column (Column H)
  • Empty Spacer column (Column I)

To Match Column Widths Perfectly

  1. Right-click on a column on the table you want to match.
  2. Scroll down the context menu and select the Resize column.
  3. A small pop-up box will appear showing the current width in pixels (e.g., 90 pixels
    for data columns and 10 pixels for spacers). Take note of this number, then click “Cancel”.
  4. Right-click on the newly created column.
  5. Select “Resize column” from the menu.
  6. In the pop-up box, delete the default number and type in the exact pixel number you
    noted from previous column, then click OK.

Formula Modifications in Column A (Query)

Because columns were inserted to accommodate the new layout, the lookup/query formula in Column A (which dynamically pulls data from your MDFM Import or Split source sheet) must be expanded to scan the newly widened range. It should be done for different categories in the schedule (Revenues, Expenditures, Other Financing Sources (Uses)). 

Find examples of formulas below: 

Before (e.g., cell A6): =ifna(query(Split!A:H,”select * where A matches ‘(“&A5&”).*’ “,0),””)

After (Cell A6): =ifna(query(Split!A:L,”select * where A matches ‘(“&A5&”).*’ “,0),””)G

The array range should be extended from A:H to A:L to ensure that the newly created columns (Original Balance and Variance columns) are included in the range. If you added only Variance column change will be shifted by +2 columns, e.g. range will be extended from A:H to A:J.

Proprietary Funds Statement of Revenues and Expenses

Under GASB 103, the Statement of Revenues, Expenses, and Changes in Net Position (St-t of Revenues, Expenses) for Proprietary Funds requires a revised presentation to distinguish between operating results, noncapital subsidies, and other nonoperating items. Select a section of the process to navigate directly to it.

  1. Update Structure in the MDFM
  2. Update Structure in the Statements (Spreadsheets)
  3. MDA Tables - Add a Percentage Column as needed
    1. Add a new column
    2. Match Column Widths
    3. Set up Calculation logic

Update structure in MDFM

Please submit a ticket to support with the subject “GASB 103 - Update Structure in MDFM - Proprietary Funds - SRE."

Note: Processing of the ticket may take 3-5 working days.

Update structure in the Statements (Spreadsheets)

Template-based Statement (no Excel formulas)

Open St-t of Revenues, Expenses for Proprietary Funds, click edit MDFM Import, check where all required lines are presented. Where applicable, expand folders in the “Field Chooser”.

Formulas-based Statement

Part 1. Edit the import as described above.

Part 2. Renaming and Repositioning Statement Lines

  1. Update names in column B in the lines of headers for rows
    • For example: Capital Contributions and Transfers —> Noncapital Subsidies
    • Income before contributions and transfers —> Operating income (loss) and noncapital subsidies.
  2. Rename Subtotals in accordance with headers
  3. Reposition Categories:
    • PF.2.06 Noncapital Subsidies: Move this block (from header to total) directly below PF.2.03 Operating income (loss)
    • PF.2.05 Operating income (loss) and noncapital subsidies: Place this subtotal row
      directly below PF.2.06
    • PF.2.04 Nonoperating Revenues (Expenses): Place this section directly below
      PF.2.05.

MDA Tables - Adding Percentage Change column, if needed

To add a new column do the following steps:

  1. Open the spreadsheet.
  2. Locate the column to the right of your current data columns (e.g., the last column with
    the Data).
  3. Right-click on the column letter header at the top of the grid for the last column with
    the Data).
  4. Select “Insert 1 column right”.
  5. Repeat two previous steps to add a second name column to the right.

To Match Column Widths Perfectly

  1. Right-click on a column you want to match.
  2. Scroll down the context menu and select the “Resize” column.
  3. A small pop-up box will appear showing the current width in pixels (e.g., 90 pixels for
    data columns and 10 pixels for spacers). Take note of this number, then click “Cancel”.
  4. Right-click on the newly created column.
  5. Select “Resize” column from the menu.
  6. In the pop-up box, delete the default number and type in the exact pixel number you
    noted from the previous column, then click OK.

Note: Ensure that the named range for Print Preview includes a new created column. 

Set up calculation logic

Add calculation to the column with the Percentage change. 

You can use an array formula:

Example: =ARRAYFORMULA(IF(N7:N23=””,””,IF(N7:N23=0,1,round(L7:L23/N7:N23-1,3))))

Where range L7:L23 includes all lines from the statement for Total column for current year while N7:N23 includes all lines from the statement for Total column for prior year.

Select appropriate format for the new Data column. A custom format (0.0%) can be applied.



Have more questions or need assistance? Submit a Request