How to create the OK Expenditure Report in Munis

Owned by Knowledge Assistant
Jul 26, 2021
1 min read
Description of Issue

How do I create the OK Expenditure Report in Munis?

Context
  • Financials
  • Oklahoma
  • Excel Cubes
Cause


Resolution

Use State Reporting GL Cube to produce the file required by the reporting agency. 

Additional Information

State Reporting Cubes Guidance:

Reference Munis KnowledgeBase article http://muniskb.tylertech.com/DocumentViewer.aspx?doc=5Qy4xMRLLEbPPM6zTqp7fA== (note that link works best in Internet Explorer)

Reporting agency guidance: 

The reporting agency expects an Excel file.

Reference "Major Components of the Code Structure" section in the OK State Auditor and Inspector (SAI) Chart of Accounts and Standard Operating Procedures for Oklahoma Counties document for account structure. 

An example of how the Major Components would be exported and read are as follows:

The code for an expenditure would be exported as:
    2720000115300111000000000026678453

This code would be read as:

2720000115300111000000000026678453      County 27 (Grant County)
2720000115300111000000000026678453      Fiscal year 2020
2720000115300111000000000026678453      Fund 0001 (General fund)
2720000115300111000000000026678453      Function 1 (General)
2720000115300111000000000026678453      Department 5300 (Rural Fire)
2720000115300111000000000026678453      Account 1110 (Full time salaries)
2720000115300111000000000026678453    Amount of $266,784.53

The code for a revenue would be exported as:
    2720000100000960700000000012761966

This code would be read as:

2720000100000960700000000012761966    County 27 (Grant County)
2720000100000960700000000012761966    Fiscal year 2020
2720000100000960700000000012761966    Fund 0001 (General fund)
2720000100000960700000000012761966    Function 0 (Non-Function)
2720000100000960700000000012761966    No departments assigned to revenues
2720000100000960700000000012761966    Account 9607 (State aid)
2720000100000960700000000012761966    Amount of $127,619.66

Exported data should be done at the combined level. Combining the data lowers the amount of calculations performed by Excel, speeding up the process. As an example, if two revenue transactions happened as:   

2720000100000960700000000002480747
2720000100000960700000000010281219

These two would be combined to make a single data point of:   

2720000100000960700000000012761966