State and Local Government Financial ReportTurn your major financial statements into a comprehensive annual financial report with a simple, repeatable, and reliable process. Use this example to build your next report using connected data in the Workiva platform.
Automate the creation of your next annual financial report for state or local government.
Stop wasting time navigating between the balance sheet and income statements and copying and pasting the figures in the annual report. This template will show you how you can bring in a copy of the trial balance and general ledger into the Workiva platform and automate the process. Cut down on manual tasks loaded with risk and create more time for financial statement reviews.
- Sample spreadsheets
- Built-in formulas
- Instruction sheet included
Frequently Asked Questions
How are the statements automated?
Statements are automated by formulas referencing the updated and imported General Ledger and/or Trial Balance.
How are the formulas written?
Formulas are written in the same manner as formulas in Excel. Most utilized formulas are: Sum, SUMIFS, VLOOKUP, INDEX(MATCH).
What information is needed for the General Ledger and Trial Balance?
A clean flat file in a .csv, .tsv or .psv format that can be pulled from your current ERP system.