Master Article - ACFR

Is there a single point of reference to help address ACFR questions and issues?

• Annual Consolidated Financial Report (ACFR)
• Configuration & Set Up
• Tyler Deploy
• TCP Ecosystem (portal)
• Admin Center

Questions about administration, configuration, or common issues.

• Contract Support if there are any questions on the following:
  • CAFR Upgrades and Migration to ACFR
  • New CAFR ACFR Installations
  • ACFR - Confirm site has program available
• Identify site ACFR Administrator
  
  1. ACFR - Portal administrator
     • Support relies on this being correctly defined when directing clients to site admin for ACFR user access needs
  2. Adding technical contact to Admin Center workspaces 
     • This can be a single administrator or a group email if IT shares responsibly
  3. How to gain Org Admin access to Admin Center
     • All site administrators should be configured as Org Admin in Admin Center, Org Admin administrate all other users.
     • Support has instructions Org Admin can follow to correct Groups and Links are added to administrate and access ACFR
     • Site Admins then setup other users to use email to OKTA authenticate then create users and roles for ACFR use
  4. Import or manually add users to Okta
     • If site wants Support to access ACFR and do independent review site admin must setup specific Support tech with OKTA and ACFR role and permissions to assist.
  5. ACFR - OKTA authentication inactive user
• Has ACFR been deployed? Is ACFR ready for implementation training or site use?
  
  1. ACFR - Dashboard URL
     • If OKTA authentication screen does not display the URL is wrong or site has not been fully deployed to use ACFR.
     • Can users access the dashboard URL, does it prompt for OKTA authentication by email and credentials?
     • Users that are not configured for OK
  2. Unable to see content in ACFR
  3. ACFR - Add users as role members
     • ACFR User role and permission migration
     • ACFR - Add roles
     • ACFR - Update roles
     • ACFR - Administration audit for roles and security
     • How to add a new user to ACFR
  4. ACFR - Train database
• ACFR Training
  • ACFR Training Material
  • https://tylercommunity.tylertech.com/acfr_statement_builder/m/acfr-statement-builder-cloud---training
• ACFR Menu
  • ACFR - No menu or program options display for user
• ACFR Backups, Restore, Refresh
  • ACFR - Snapshot Live and restore Test or secondary workspace
  • https://tylercommunity.tylertech.com/acfr_statement_builder/m/cloud-training-videos/42090
  • ACFR - Snapshot backup restore download process log options
• ACFR Imports & Enterprise ERP Export for ACFR
  • Export Munis Data for ACFR
  • ACFR- Import balances to prior years
  • ACFR SB - How to remove duplicated accounts
  • ACFR Import Error - Fund Account number cannot contain a single quote
  • Account is not listed in Account Maintenance after being imported into ACFR Statement Builder
• ACFR Templates & Reports
  • ACFR - Templates - File Types
  • ACFR custom report migration
  • ACFR - Not all reports available in Account Groups
  • ACFR - Report field amount is in question or wrong
  • ACFR - Cannot edit cell function in report Template
  • ACFR - How to run Account Group Integrity Check report
  • ACFR - Unassigned Expenditures on Governmental Statement of Revenues Expenditures and Changes of Net Position Report
  • ACFR - System default Comparative Statement of Changes in Net Position Report - The selected template could not be loaded
  • ACFR - Proprietary Statement of Revenues account groups carry over to the expense account groups
  • ACFR - Net Position Beginning Balance is different than prior year Ending Balance
  • ACFR - Net Position Restatement - Equity Restatement type description cannot be empty
  • ACFR - Governmental Statement Report missing General Fund
  • ACFR - Governmental Statement Report has no report options available
  • ACFR - Governmental Statement of Revenues Expenditures and Changes in Fund Balance - The selected template could not be loaded
  • ACFR - Combining Governmental Balance Sheet split out restricted fund balances
  • ACFR Report missing column for External Investment Pool Fund
  • ACFR Statement Builder - Funds are not showing as columns in reports
  • ACFR - External Investment Pool Fund option unable to save
  • ACFR Fund Name incorrect on reports
  • ACFR - Template not rounding numbers to thousands
  • ACFR - Print Report - This report is not available
• ACFR Reconciliation Notes
  • ACFR - Error saving Reconciliation Notes data
  • ACFR - Add option grey or unavailable for Reconciliation Notes
• ACFR Agency & Entity
  • How to create an Agency in ACFR SB
  • https://tylercommunity.tylertech.com/tyler/acfr_statement_builder/b/annual-comprehensive-financial-report-statement-builder-cloud/posts/acfr---agencies-and-entities
  • ACFR - Fiscal Year not showing in drop down
• ACFR Account Groups
  • ACFR - Adding Account Groups
  • ACFR - Delete Account Groups
  • ACFR- Update Account Group in Account Maintenance
  • ACFR Statement Builder - Move account from a group in one category to a group in another category
  • ACFR Statement Builder - How to edit the properties of an Account group
  • ACFR - Error updating Account Groups
  • https://tylercommunity.tylertech.com/tyler/acfr_statement_builder/b/annual-comprehensive-financial-report-statement-builder-cloud/posts/acfr---account-groups
  • ACFR - Fund Maintenance - Uncheck General Fund option
• ACFR Fund Maintenance
  • ACFR - Fund Maintenance - Uncheck General Fund option
• ACFR Fund Level Adjustments
  • How to import fund level adjustments in ACFR Statement Builder
  • ACFR - Fund Level Adjustment doubled amount
  • ACFR - Error occurred while performing copy reverse of Fund Adjustment Entry
• ACFR Cash Flow Adjustments
  • ACFR - What makes cash flow off
• ACFR Adjusting Entries
  • Modify or reverse Adjusting Entries- ACFR
  • ACFR - Do Adjusting Entries carry forward by design
• ACFR Attachments
  • ACFR - Document Attachments
• ACFR Close & Open Fiscal Year
  • ACFR - Munis Fiscal Year close and ACFR
  • Closing Current ACFR Fiscal Year and Opening New ACFR Fiscal Year
  • Set Balance Sheet Beginning Balance to Zero option when Closing ACFR Fiscal Year
  • ACFR - Close Fiscal Year Error - Funds have already been rolled to the next year
  • ACFR - Close Fiscal Year Error - Error processing Equity Allocation
  • Purge ACFR Fiscal Year data
  • https://tylercommunity.tylertech.com/acfr_statement_builder/b/annual-comprehensive-financial-report-statement-builder-cloud/posts/best-practice-for-adjustments-for-yec
• Enterprise ERP & SSRS
  • How to verify if the year has been closed in MUNIS
  • https://confl.tylertech.com/display/MKKB/ACFR+-+Munis+Fiscal+Year+close+and+ACFR
  • SSRS report needed that includes ACFR Fund Type as shown in Chart Manager

• Site Administrates their own ACFR setup and configuration. This is due to OKTA 2 factor authentication limiting support access. Turnover at site can cause confusion and administrative gap that needs to be addressed so sites can continue to manage their system and users.
• Join ACFR Statement Builder group on Tyler Community to receive email updates, change notifications, access available documentation and training materials
  •  https://tylercommunity.tylertech.com/acfr_statement_builder
• ACFR Help Option