Julia Chirkova
By Sahibzada Behram Khan
The perennial question of "how long does the financial close take?" elicits a frustrating chorus of divergent answers across the business world. Yet, when probed about the specific bottlenecks, a striking consensus emerges: the delay is rarely rooted in the complexity of accounting judgments. Instead, the hours evaporate in the mundane yet critical processes of data retrieval, matching, and formatting – the mechanical scaffolding that supports the final pronouncements. This distinction is not merely academic; it forms the bedrock of a sound automation strategy for modern finance departments. The protracted nature of financial closes is less a symptom of difficult accounting and more a consequence of unwritten, un-automated, deterministic, and repetitive steps that are dutifully, and expensively, re-performed by hand each accounting period.
The Dichotomy of Financial Close Tasks: Judgement vs. Mechanics
At the heart of an effective automation strategy lies the clear segregation of tasks into two distinct categories: those that are deterministic and those that require professional judgment.
Deterministic Tasks: These are the workhorses of the close. They are characterized by their predictability: given the same inputs, they will consistently yield the same output. Examples abound in the financial close process. Extracting a trial balance from an accounting system, matching cleared bank transactions against statement entries, rolling forward a schedule of prepaid expenses, or meticulously rebuilding a recurring financial reporting pack in a standardized format all fall into this bucket. Crucially, these activities demand precision and diligence, but they do not inherently involve the application of professional acumen or subjective decision-making.
Judgment-Based Tasks: This category encompasses the higher-order cognitive functions that clients ultimately pay for. It includes the critical analysis of whether an accrual is reasonable, the investigation of significant variances in financial performance, the assessment of the ongoing supportability of estimates, and the decision-making around reclassifying accounts to ensure accurate financial representation. These are the areas where accountants leverage their expertise, experience, and understanding of the business to provide strategic insights and ensure financial integrity.
Firms that misinterpret this fundamental distinction and invest in tools that promise to "do the accounting" often find themselves in a counterproductive loop. They end up expending valuable time reviewing and validating machine-generated judgments, which is invariably a more time-consuming and less effective process than applying their own seasoned judgment. The core principle, therefore, is clear: automate the deterministic, mechanical processes to liberate the professional judgment for the tasks that truly add value.
Persistent Bottlenecks: Four Deterministic Steps That Still Consume Hours
Despite widespread modernization in accounting software and financial systems, four fundamental deterministic steps continue to drain significant time and resources in most organizations. Their persistence is a testament to the inertia of ingrained manual processes.
1. Data Extraction from the Ledger: The journey often begins with a laborious manual process. An accounting professional logs into the core accounting system, navigates to generate a specific report, exports it, opens it in spreadsheet software, and then embarks on a series of data cleanup tasks. This typically involves deleting extraneous header rows, correcting date formats that arrive as text, and repairing account numbers that are also often misinterpreted as alphanumeric strings. Only after this extensive preparatory work can the actual accounting analysis commence. When this process is replicated across multiple clients and numerous reports, it frequently emerges as the single largest consumer of financial close hours, representing pure, unadulterated mechanical labor. Industry data suggests that this initial data wrangling can account for as much as 20-30% of total close time in some organizations, particularly those relying heavily on legacy systems or manual data handling.
2. Reconciliations: A cornerstone of financial control, reconciliations – whether for bank accounts, credit cards, intercompany transactions, or various clearing accounts – are inherently ripe for automation. The core matching process, which involves comparing individual transactions against a defined set of rules (e.g., deposit against a receipt within a specific tolerance and date window), is entirely deterministic. While identifying and investigating exceptions invariably requires human intervention, the vast majority of transactions that match cleanly and effortlessly do not. Automating the bulk of this matching can dramatically reduce the time spent on reconciliations, allowing accounting teams to focus their expertise on resolving the truly complex discrepancies. Studies have shown that well-implemented automated reconciliation systems can reduce reconciliation time by up to 70%.
3. Schedule Roll-Forwards: Processes involving prepaid expenses, accrued liabilities, fixed asset depreciation, and deferred revenue all necessitate periodic schedule roll-forwards. The arithmetic required to advance these schedules by one accounting period is entirely mechanical and follows predictable formulas. The decisions regarding what items should be included on these schedules, or the initial establishment of their terms, are judgmental. However, the subsequent period-over-period updates are a prime candidate for automation. This frees up accountants from tedious recalculations and allows them to concentrate on the strategic aspects of financial planning and analysis. For instance, in a company with a large volume of recurring revenue, automating the deferred revenue schedule roll-forward can save hundreds of hours annually.
4. Assembling the Reporting Pack: The final compilation of financial statements and supporting schedules into a cohesive reporting pack is another area prone to manual inefficiencies. This often involves copying figures into pre-defined templates, manually refreshing charts and graphs, verifying that all financial statements reconcile, and then exporting the entire package into a portable document format (PDF). While the overall structure might be standardized, the act of populating and verifying each element is time-consuming and, critically, introduces a significant risk of transcription errors, especially when performed under the pressure of tight deadlines. The potential for a simple data entry mistake at 9 PM on a reporting deadline can have cascading consequences. Automation in this area can ensure consistency, accuracy, and significantly reduce the time from final data to disseminated report.
Strategic Sequencing: Prioritizing Automation for Maximum Impact
The effectiveness of an automation strategy hinges not just on the selection of the right tools, but on the strategic sequencing of implementation. A logical progression ensures that the most impactful, mechanically repetitive tasks are addressed first, creating a ripple effect of efficiency gains.
The recommended order of automation typically begins with the most foundational and repetitive tasks:
- Data Extraction and Transformation: Automating the process of getting clean, usable data out of the accounting system and into a format suitable for analysis is paramount. This includes standardizing formats, correcting data types, and eliminating unnecessary information.
- Reconciliation Matching: Implementing systems that can automatically match the majority of transactions in bank, intercompany, and other reconciliation processes.
- Schedule Roll-Forwards: Automating the periodic updates of schedules like prepaids, accruals, fixed assets, and deferred revenue.
- Reporting Pack Assembly: Streamlining the process of populating templates, refreshing data visualizations, and generating final reports.
Notably absent from this list are the core judgmental tasks. Accrual estimations, variance investigations, the review of financial estimates, and reclassification decisions remain firmly within the purview of the accountant. The purpose of automating the deterministic steps is precisely to buy back the time and mental bandwidth required to perform these critical judgmental activities with greater rigor and insight. This strategic alignment ensures that automation serves to augment, rather than replace, the valuable analytical contributions of finance professionals.
Essential Cautions for Effective Automation
While the benefits of automation are substantial, two critical caveats must be heeded to ensure successful and sustainable implementation.
1. Document Before You Automate: The adage "garbage in, garbage out" is particularly relevant to automation. Attempting to automate a poorly defined or undocumented process is akin to paving over a pothole; it merely makes the problem faster and harder to detect. Automation is designed to fix a process in place, not to fundamentally improve a flawed one. Before embarking on any automation initiative, the underlying process must be meticulously documented, with each step clearly defined. In many cases, the mere act of documenting a process will reveal redundancies, inefficiencies, and opportunities for simplification that can eliminate entire steps before automation is even considered. This foundational step ensures that automation is applied to a sound, optimized process, maximizing its effectiveness.
2. Maintain an Unimpeachable Audit Trail: Any automated step within the financial close process must provide a clear, reconstructible audit trail. This is not merely a matter of compliance; it is a fundamental requirement for accountability and trust. Whether the information is being reviewed by an internal auditor, a successor in the finance department, or an external regulator, the ability to trace the inputs, the logic applied, and the resulting output is non-negotiable. If an automated step cannot demonstrate its provenance – what data went in, what rules were applied, and what the final output was – it introduces an unacceptable level of risk and should not be incorporated into the close. A robust audit trail builds confidence in the automated process and ensures compliance with evolving regulatory landscapes.
A Practical Starting Point: Measuring to Master
The most effective way to initiate an automation strategy is not through vendor demonstrations or theoretical discussions, but through empirical measurement. Identify your most repetitive client or internal process. Then, conduct an honest, timed assessment of a complete close cycle. This is not an exercise in recalling past efforts but a meticulous, stopwatch-guided recording of every single step undertaken. The results are often surprising, revealing that the judgmental work, which accountants often perceive as dominating the close, typically consumes less time than the surrounding data handling and mechanical operations.
This empirical timing sheet, rather than sales pitches or abstract promises, should serve as the definitive guide for determining which processes to automate first. It provides objective data that highlights the true bottlenecks, allowing for the prioritization of automation efforts where they will yield the most significant return in terms of time saved, accuracy improved, and professional resources liberated. This data-driven approach ensures that automation investments are targeted and effective, directly addressing the most pressing inefficiencies within the financial close.
The journey towards an efficient financial close is one of strategic discernment. By meticulously separating the deterministic mechanics from the invaluable art of professional judgment, organizations can leverage automation to transform a time-consuming obligation into a streamlined, insightful process that drives greater business value.
Sahibzada Behram Khan is the Founder of HISAB 360, a company specializing in AI and automation tooling designed to operate within Microsoft Excel for accounting and finance teams. Further information is available at https://hisab360.net.
