How Agile Reporting Helps Flatten the Month End Mountain

The accumulation of tasks and activities around the month-end close is a well-known accounting phenomenon. FSN’s recent research, “Agility in Financial Reporting and Consolidation,” calls it the Month-End Mountain, reflecting the strenuous climb that finance professionals experience every month just to get on top of their workload.

Ironically, just at the point in time when well qualified personnel should be applying their experience and technical skills to quickly dispatch statutory filings and analyze corporate performance, they are preoccupied with mundane, non-value-added tasks, that keep them from exercising their professional judgement. Worse still, it’s the same story every month. In fact, FSN’s research finds that 60% of organizations spend too much of their time chipping away at the month-end. So, the obvious question is, what causes this energy-sapping peak in activity, and what do transformational leaders do to flatten the Month-End Mountain?

The research points to three main causes: an accumulation of data errors, a lack of task management, and a process that does not encourage management to tackle certain activities earlier in the monthly reporting cycle.

Data Errors

Data errors have the most restrictive impact on the agility of the close process and the Month-End Mountain. Errors which arise early in the process, for example, in closing the books in subsidiaries or data capture from reporting entities need to be corrected quickly, at source. When errors are allowed to slip through interfaces or mapping tables (between subsidiaries and the center) they are then propagated throughout the reporting chain all the way to the center. Once these errors reach the center, they are more difficult and time-consuming to correct. This is because people at the center are often unfamiliar with the data and often because of delays in communications between people in different time zones. In general, the further away an error is discovered from its source, the more difficult it is to correct. That is why errors build up in the final stages of the close. In fact, 72% of organizations report that the agility of the close process is affected, or greatly affected, by data errors.

Task Management

The close process is made up of hundreds of closely interleaved tasks, such as reconciliations, producing and checking reports, agreeing accruals and journal entries. Usually, these tasks are managed in a spreadsheet checklist, which is onerous to maintain in real-time and share between participants. So, task completion can be rather haphazard, and the same mistakes are made month after month. But FSN’s research identifies that those companies that have invested in task management, for example, detailed workflows can more easily see the status of reporting at any point in time and reduce the burden at the month-end.

Starting Earlier

Such investments also allow for certain activities, such as agreeing inter-company balances or posting recurring journals, to be brought forward to earlier in the month. Getting these tasks out of the way reduces the burden on the month-end close.

Transformation Leaders Work Differently

Transformational leaders represent a compelling example for the value of investing in data quality, automation, and specialised reporting software. So, what do they do differently?

They seek to automate data capture and maintain good control over different data sources and mapping tables. This allows them to trap and correct errors at source, rather than allowing them to build up at the center.
They use task management capabilities to alleviate the pressure at month-end and smooth out peaks and troughs in workload between different people in the finance function.
Finally, they ensure that tasks that can be brought forward and dealt with earlier.

So, the good news is that following best practices in automation and control can greatly alleviate the congestion at month-end, allowing finance professionals to spend more time on value added activities and less time on an unproductive “paperchase.”

FSN: Agility in Financial Reporting & Consolidation

Download Now:

— Select One —

— Select an Industry –Accommodation & Food ServicesAdmin, Support, Waste Mgmt, RemediationAgriculture, Forestry, Fishing & HuntingArts, Entertainment & RecreationBiotechnologyChemicalsCommunicationsConstructionConsultingEducation ServicesEngineeringFinance & InsuranceFood & BeverageHealth Care & Social AssistanceHospitalityInformationManagement of Companies and EnterprisesManufacturingMediaMining, Quarrying, Oil & Gas ExtractionNon-ProfitOtherPharmaProfessional, Scientific & Technical SvcPublic AdministrationReal Estate, Rental & LeasingRetail TradeTechnologyTransportation & WarehousingUtilities

— Select One –DeltekEpicorInforJD EdwardsMicrosoftMRI SoftwareNetSuiteOracleOtherSageSAPViewpoint

— Select One –24SevenOfficeA+AAROAccountEdgeAccounting CSAccountmateAcumaticaAlereAnaplanApteanAssistASWAurora (Sys21)AxionAxisBAANBannerBlackbaudBlueLinkBook WorksBPCSCayentaCCHCDK GlobalCedAr e-financialsCGI AdvantageClarusCMiCCMS (Solarsoft)CodaCoinsColleagueCPSICSC CorpTaxCustomCYMADACData WarehouseDatatelDATEVDavisware Global EdgeDavisware S2KDeacomDeltek AjeraDeltek ComputerEaseDeltek CostPointDeltek MaconomyDeltek VantagePointDeltek VisionDeltek Vision CloudDPNDynamics 365 Business CentralDynamics 365 Finance and Supply Chain ManagementDynamics AXDynamics CRMDynamics GPDynamics NAVDynamics NAV C5Dynamics SLe5eCMSEden (Tyler Tech)EmphasysEntrataEpicor AvanteEpicor BisTrackEpicor CMSEpicor EnterpriseEpicor Epicor SLSEpicor iScalaEpicor KineticEpicor LumberTrackEpicor Manage 2000Epicor Prophet 21Epicor TroposEtailExpandableFAMISFamous SoftwareFernFinancialForceFireStreamFISFiServFlexiFortnoxFoundationFourth ShiftFriedmanFull CircleGEMSHarris Data (AS/400)HCSHMSIBM Cognos TM1IBSIBS-DWIn-House DevelopedIncodeINFINIUMInfor CloudSuite FinancialsInfor Distribution SX.eInfor LawsonInfor M3Infor System21Infor SyteLineIQMSiSuiteJack HenryJenzabarJobBOSSJonas ConstructionM1MacolaMACPACMade2ManageMAMMAM AutopartManmanMapicsMcLeodMEDITECHMFG ProMicrosOperaMIPMitchell HumphreyMovexMRIMRI Commercial ManagementMRI FinancialsMRI HorizonMRI Horizon CREMRI Qube HorizonMRI Residential ManagementMSGovernMunis (Tyler Tech)New World SystemsOnesiteOnestream XFOpen SystemsOracle E-Business Suite (EBS)Oracle EPM CloudOracle ERP CloudOracle EssbaseOracle Financial Consolidation and Close (FCCS)Oracle FusionOracle Hyperion EnterpriseOracle Hyperion Financial Management (HFM)Oracle Hyperion PlanningOracle PeopleSoftOracle Planning and Budgeting Cloud Service (PBCS)Oracle Tax ReportingPDIPentaPlexxisPowerOfficePRMSPro ContractorProLawQ360QADQlikSenseQuantumQube HorizonQuickBooks Desktop PremierQuickBooks Desktop ProQuickbooks EnterpriseQuickBooks OnlineQuorumRealPageREST APIRetalixRossSage 100Sage 100 ContractorSage 200Sage 300Sage 300 CRE (Timberline)Sage 500Sage 50cloud AccountingSage AccPacSage Adonix TolasSage EstimatingSage IntacctSage Intacct Budgeting & PlanningSage MASSage X3SAP BPC (HANA, MS or Netweaver)SAP Business ByDesignSAP Business One (B1)SAP Business Warehouse (BW)SAP ERPSAP ERP Central Component (ECC)SAP S/4HANASmartStreamSpokaneSpringbrookSQL Server Analysis Services (SSAS)Standalone DB with ODBC/DSN connectionStandalone IBM DBStandalone Oracle DBStandalone SQL DBSUNSunguardSunSystemsSys21SYSPROSyteLineTAM (Applied Systems)Thomson Reuters TaxTimberlineTIMELINETraverseTripleTexUnit4Unit4 AgressoUnit4 Business WorldUnit4 CodaUSL FinancialsVadimVAI-System 2000VantageVertexViewpoint SpectrumViewpoint VistaVismaWinshuttleWolters Kluwer CCH TagetikWorkDayXeroxLedgerXperiaYardiYardi-SaaS

— Select a Product –AtlasBizNetBizviewCalumoCertent- Certent Disclosure Management- Certent DisclosureNet- Certent Equity ManagementCXOEvent 1 SoftwareHubbleIDL- IDL Designer- IDL Forecast- IDL Konsis- IDL PublisherJet- Jet Analytics- Jet Basics- Jet ReportsLongview- Longview Analytics- Longview Close- Longview Plan- Longview Tax- Longview Transfer PricingMekko GraphicsSpreadsheet ServerTidemarkViareport- Viareport Conso & Report- Viareport LeaseWands- Wands for Oracle- Wands for SAP

— Select –Researching this topicEvaluating software solutionsExisting customer or partner

— Select –AfghanistanAlbaniaAlgeriaAmerican SamoaAndorraAngolaAntigua and BarbudaArgentinaArmeniaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBosnia and HerzegovinaBotswanaBrazilBruneiBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaColombiaComorosCongo, Democratic Republic of theCongo, Republic of theCosta RicaCroatiaCubaCuraçaoCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFaroe IslandsFijiFinlandFranceFrench PolynesiaGabonGambiaGeorgiaGermanyGhanaGreeceGreenlandGrenadaGuamGuatemalaGuineaGuinea-BissauGuyanaHaitiHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsraelItalyJamaicaJapanJordanKazakhstanKenyaKiribatiKosovoKuwaitKyrgyzstanLaosLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgNorth MacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMauritaniaMauritiusMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNew ZealandNicaraguaNigerNigeriaNorth KoreaNorthern Mariana IslandsNorwayOmanPakistanPalauPalestine, State ofPanamaPapua New GuineaParaguayPeruPhilippinesPolandPortugalPuerto RicoQatarRomaniaRussiaRwandaSaint Kitts and NevisSaint LuciaSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSint MaartenSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth KoreaSpainSri LankaSudanSudan, SouthSurinameSwazilandSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTogoTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTuvaluUgandaUkraineUnited Arab EmiratesUnited KingdomUnited StatesUruguayUzbekistanVanuatuVenezuelaVietnamVirgin Islands, BritishVirgin Islands, U.S.YemenZambiaZimbabwe

— Select State –AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyoming– Select Province –AlbertaBritish ColumbiaManitobaNew BrunswickNewfoundland and LabradorNova ScotiaNorthwest TerritoriesNunavutOntarioPrince Edward IslandQuebecSaskatchewanYukon

This field is for validation purposes and should be left unchanged.

The post How Agile Reporting Helps Flatten the Month End Mountain appeared first on insightsoftware.