Founded in 1807, John Wiley & Sons is the oldest independent publishing company in the United States. With offices in North America, Europe, Asia, and Australia, Wiley is globally committed to developing and marketing print and electronic products and services for our customers' professional and personal knowledge and understanding.
The Wiley Corporate F&A series provides information, tools, and insights to corporate professionals responsible for issues affecting the profitability of their company, from accounting and finance to internal controls and performance management.
Copyright © 2020 by John Wiley and Sons, Inc.
Published by John Wiley & Sons, Inc., Hoboken, New Jersey.
Published simultaneously in Canada.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750–8400, fax (978) 646–8600, or on the Web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748–6011, fax (201) 748–6008, or online at www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.
For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762–2974, outside the United States at (317) 572–3993, or fax (317) 572–4002.
Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.
Library of Congress Cataloging-in-Publication Data
Names: Doxey, Christine H., 1955- editor.
Title: The fast close toolkit / edited by Christine H. Doxey.
Description: Hoboken, New Jersey : Wiley, [2020] | Series: Wiley corporate F&A | Includes index.
Identifiers: LCCN 2019024543 (print) | LCCN 2019024544 (ebook) | ISBN 9781119554493 (hardback) | ISBN 9781119554523 (adobe pdf) | ISBN 9781119554448 (epub)
Subjects: LCSH: Closing (Accounting) | Financial statements.
Classification: LCC HF5681.C45 F37 2020 (print) | LCC HF5681.C45 (ebook)| DDC 657—dc23
LC record available at https://lccn.loc.gov/2019024543
LC ebook record available at https://lccn.loc.gov/2019024544
Cover Design: Wiley
Cover Image: © fanjianhua/Getty Images
REGARDLESS OF COMPANY SIZE or complexity, all successful fiscal close processes require continuous communication, comprehensive documentation, and a flexible, responsive organization that is focused on people, processes, transactions, reconciliation, and reporting. The degree to which each building block is implemented will vary based on company size, type of industry, availability of resources, and management commitment.
However, omitting one or two of these building blocks may result in some type of failure during a month-end close. The building blocks for the fiscal close are explored in Chapter 3, “The Components of the Fiscal Close.” When executing these building blocks, executing the fiscal close correctly helps achieve the following benefits.
The fiscal close process is one of the most fundamental indicators of the efficiency of your fiscal infrastructure, and is the critical foundation that must be in place before your finance and accounting team can even begin to optimize its role as a true consultative business partner and trusted advisor, assisting in achieving strategic goals and creating shareholder value.
Over the last decade, the financial reporting landscape has seen significant change. Finance executives face mounting pressure to increase the accuracy of financial reporting while decreasing turnaround time. Costs are being highly scrutinized as the longest recession in U.S. history continues. Regulatory agencies have introduced a host of new standards and accounting rules changing materiality thresholds and requiring detailed schedules and new disclosures for public filings. To complicate matters, many finance organizations are being asked to do more with less as headcounts are reduced in response to economic pressures.
The current legislation has strict requirements for the timing of preparation and the quality of financial statements. It is especially important for chief financial officers (CFOs) of large companies who receive fiscal information from multiple entities, from different systems, and in incompatible data formats.
Since the adoption of the IFRS throughout the EU and the demand for greater transparency as far as external reporting is concerned following the collapse of corporate giants such as Enron and WorldCom, there is a great need for reliable fiscal information on a real-time basis.
Today's finance organizations face multiple priorities that include the oversight of fiscal transactions, management of enterprise performance, attestation of financial reporting, and timely close and consolidation of fiscal data. As they grapple with these issues, CFOs are always seeking ways to increase the efficiency and timeliness of their fiscal close and compliance processes. However, merely improving the speed of the fiscal close process is not enough.
There is a competing demand for improved fiscal governance and increased transparency and reliability of data. The pace of regulatory change also continues to increase as a result of the current economic challenges as well as ongoing regulatory initiatives such as the mandate of eXtensible Business Reporting Language (XBRL) as the reporting standard format and the likely move to International Financial Reporting Standards (IFRS).
Finance organizations need to proactively manage the challenges of data quality and prepare for new regulatory requirements to avoid creating a “perfect storm” for their fiscal close and consolidation processes. As regulations and requirements become tighter around responsibility accounting, more and more companies are continually reevaluating their closing processes to meet up with their statutory requirements, but also to integrate multiple financial reporting systems requiring a “Fast Close Toolkit.”
This toolkit provides the guidance, best practices, tools, templates, and policies to enable a faster fiscal close. The Guide to Toolkit Organization table provides the applicable chapter number for each section.
For easy reference, each best practice, policy, checklist, process narrative, and standard of internal control is numbered throughout this toolkit. Tables for these important references are provided in the following tables:
Chapter Number | Chapter Title |
Introduction | |
Executive Summary | |
1 | Why the Continued Focus on the Fiscal Closing Process? |
2 | Key Pain Points and Bottlenecks |
3 | The Components of the Fiscal Close |
4 | Governing the Fiscal Close Process |
5 | The Transaction Accumulation, Reconciliation, and Sub-Ledger Close |
6 | Introduction to the Standards of Internal Control |
7 | Roles and Responsibilities During the Fiscal Close |
8 | The General Ledger and Trial Balance |
9 | The Common Chart of Accounts |
10 | Cost Centers |
11 | The Journal Entry Process |
12 | Spreadsheet Controls |
13 | Checklists for Transaction Accumulation, Reconciliation, and Sub-Ledger Close |
14 | Sample Policies for Transaction Accumulation, Reconciliation, and Sub-Ledger Close |
15 | Process Narratives for the Transaction Accumulation, Reconciliation, and Sub-Ledger Close |
16 | Standards of Internal Control for the Transaction Accumulation, Reconciliation, and Sub-Ledger Close Process |
17 | Corporate Close and Consolidation |
18 | The Number of Consolidation Points |
19 | The Number of Closing Cycles |
20 | Post-Closing Entries |
21 | Communication and Accountability |
22 | Financial Statement Assertions |
23 | Checklists for the Corporate Close and Consolidation Process |
24 | Sample Policies for the Corporate Close and Consolidation Process |
25 | Process Narratives for the Corporate Close and Consolidation Process |
26 | Standards of Internal Control for the Corporate Close and Consolidation Process |
27 | Analysis and Reporting (The Final Mile) |
28 | Internal and External Reporting |
29 | Budgeting and Forecasting |
30 | Reduce Fiscal Close Cycle Times by Moving Your Finance Function to “Dynamic” Budgeting and Planning |
31 | Fixed Assets and the Capital Budget |
32 | The Forecast Process |
33 | The Fiscal Close and Strategic Planning |
34 | Analytics to Detect Financial Statement Fraud |
35 | Checklists for the Analysis and Reporting Process |
36 | Sample Policies for the Analysis and Reporting Process |
37 | Process Narratives for the Analysis and Reporting Process |
38 | Standards of Internal Control for the Analysis and Reporting Process |
39 | The Virtual Close: Myth or Reality? |
40 | Roadmap: Benefits of the Fast Close |
41 | Accelerating the Close with Automation |
Addendum: Fast Close Tools and Additional Best Practices
Glossary |
Best Practice Number | Best Practice |
1 | Consider the Use of a Single ERP System |
2 | Employ Cloud-Based Computing |
3 | Implement Cutoff Dates |
4 | Implement a Fiscal Close Governance Process |
5 | Complete General Ledger Reconciliations |
6 | Implement an Internal Controls Program |
7 | Implement a Common Chart of Accounts |
8 | Define Business Rules for Establishing Cost Centers |
9 | Define Allocation Risks |
10 | Implement an Indirect Cost Allocation Methodology |
11 | Streamline Recurring Journal Entries |
12 | Address Spreadsheet Risks and Implement Controls |
13 | Automate the Consolidation Process |
14 | Include the People Who Impact the Close |
15 | Create Consistent Closing Schedules |
16 | Consider Fiscal Close Process Improvements |
17 | Reduce the Number of Closing Cycles |
18 | Develop Business Rules for Post-Closing Entries |
19 | Ask Key Questions to Define Your Internal Financial Reporting Process |
20 | Consider Five Steps for a Successful Budget Process |
21 | Establish a Capital Budget Process |
22 | Implement the Capital Review and Approval Board (CARB) Process |
23 | Include Finance and Accounting in the Strategic Planning Process |
24 | Use a Strategic Planning Readiness Checklist |
25 | Follow These Seven Steps for Your Strategic Planning Process |
26 | Implement Six Key Elements for Your Strategic Plan |
27 | Use a Standardized Table of Contents for Your Strategic Plan |
28 | Establish Performance Metrics to Determine the Effectiveness of Your Strategic Plan |
29 | Use Red Flags to Detect Financial Statement Fraud |
30 | Establish Escalation Procedures |
Policy Number | Best Practice |
1 | Account Reconciliation Policy |
2 | Accounts Payable Accruals |
3 | Spreadsheet Controls |
4 | Financial Close and Consolidation Process |
5 | Basic Policies on Financial Reporting |
Checklist Number | Best Practice |
1 | Transaction Accumulation and Fiscal Close Checklist |
2 | Fiscal Year-End Sample Schedule |
3 | Accounts Payable Roles and Responsibilities Year-End Checklist |
4 | Reconciliation Template |
5 | Corporate Close and Consolidation |
6 | Executive-Level Closing Checklist |
7 | Twenty Critical Areas to Review at Year-End |
8 | The Year-End Financial Statement Checklist |
9 | The Year-End Transaction Checklist |
10 | The Year-End Payroll Process Checklist |
11 | Quarter-End Fiscal Close (10Q) |
12 | Year-End Fiscal Close (10K) |
13 | Performing Financial Statement Analysis |
14 | Trend Analysis |
Process Narrative Number | Best Practice |
1 | Journal Entry (JE) Process |
2 | Management Approval of Journal Entries |
3 | Other Current and Long-Term Assets |
4 | Other Current and Long-Term Liabilities |
5 | Balance Sheet Consolidation |
6 | Assets Held for Sale Due to Discontinued Operations |
7 | Disclosure Checklist |
8 | Fluctuation Analysis |
9 | Cash Flow Reconciliation |
10 | Reporting Debt |
Standards of Internal Control Number | Best Practice |
1 | Journal Entry (JE) Process |
2 | Management Approval of Journal Entries |
3 | Other Current and Long-Term Assets |
4 | Other Current and Long-Term Liabilities |
5 | Balance Sheet Consolidation |
6 | Assets Held for Sale Due to Discontinued Operations |
7 | Disclosure Checklist |
8 | Fluctuation Analysis |
9 | Cash Flow Statement Reconciliation |
10 | Reporting Debt |
ACCORDING TO THE Journal of Accountancy, fiscal close systems, processes, people, and their interconnectivity can be complex, but successful improvements to the process can be achieved by introducing some simple building blocks and basics as provided throughout this toolkit.
No matter what the company size, industry, or complexity of systems and process, all successful fiscal close processes require a solid governance and infrastructure, checklists and documentation, standards of internal controls, and continuous communication throughout every phase of the process to ensure accurate and timely fiscal results and reporting.
There are many factors that place the spotlight on the fiscal close process, which is usually led by a team of individuals in the corporate finance and accounting department managed by the corporate controller. The complexity of the process is driven by the nature of the company (private, public, nonprofit, or government subcontractor) and the type of industry or industries the company has responsibility for. Well-defined fiscal closing processes for monthly and quarterly close are foundational to establishing the discipline needed to obtain accurate and timely results throughout the fiscal year.
The fiscal year (FY) is usually the primary accounting year for a company, organization, or government. The fiscal year serves as the organizing basis for economic measurement and financial reporting. The fiscal year also serves as a basis for budgeting and planning. The budget, forecast, and planning process will be discussed later in this toolkit.
Sometimes the organizational structure of the company, the fiscal systems and tools, and the management style can impact the fiscal close. As an additional consideration, a company that has recently been through a merger or acquisition (M&A) activity will have a whole new set of “closing challenges.”
This toolkit will focus on the general best practices for the fiscal close that will enable a “fast close.” With the closing process, I've found that it's critical to do the basics well. In comparing the monthly, quarterly, and annual processes, I've determined that there may be differences in closing schedules, the number of journal entries processed, the types of reporting, the level of scrutiny for external and internal reporting, and the preparation of external communiques for public companies but the need to “close the books” sooner and more efficiently is a universal goal. The ultimate deliverables for the fiscal close process include the following two requirements.
Operational and strategic decisions are dependent on this rapid, precise, and reliable data. This data drives the planning and budget processes of an organization. The digital age has created a class of investors and shareholders who expect immediate access to the data created by current business activities for rapid decision making, to meet regulatory requirements and to complete reporting and review results with metrics and analytics.
The Sarbanes Oxley Act of 2002 (SOX) was designed to enhance the reliability of financial reporting and to improve audit quality. SOX strengthened corporate governance, shifting responsibility for the external auditor relationship away from corporate management to independent audit committees. It instituted whistleblower programs, CEO and CFO certification requirements, and stricter criminal penalties for wrongdoing, including lying to the auditor. These measures and others were geared toward improving the reliability of corporate financial reporting.
The Foreign Corrupt Practices Act (FCPA) adds a new level of anti-bribery controls to the closing process for global organizations. Under the FCPA's Anti-Bribery Provision, it's unlawful to make a corrupt payment to a foreign official (official, political party, political official, or candidate for political office) for the purpose of obtaining business, retaining business, or directing business to any person. This includes ordering, authorizing, or assisting others to violate or conspire to violate these provisions. This applies not only to a successful corrupt payment—the offer or promise of such payment can also cause violation. Under the Accounting Provision, corporations must make and keep books and records that accurately and fairly reflect the transactions of the corporation. Corporations must devise and maintain an adequate system of internal accounting controls.
Many chief fiscal officers (CFOs) and controllers face ongoing challenges with the fiscal closing process. In some cases the process is still very manual and spreadsheets are used throughout the process. Many companies can't seem to get a handle on the fiscal closing process and find that a checklist with well-defined roles and responsibilities is needed for every component of this critical and highly visible business process. In some cases, automation is not always the “silver bullet” but gaining a true understanding of the full fiscal closing cycle along with the processes that impact the cycle is a recommended direction.
Several years ago, I managed the fiscal consolidated process at Digital Equipment Corporation (DEC), which is now merged with Hewlett Packard. We faced two very unique challenges that I had the opportunity to address.
I mention these two examples because best practices cannot replace empowerment and a culture of continuous improvement. Lastly, technology and automation are great tools to support the fiscal close, but it's important to ensure that your staff understands how to use them. I suggest the ultimate best practice combines people with automation, and when establishing a goal for the completion of the fiscal closing process, ensures there is enough time to analyze results, metrics, and potential risk. Let's take a look at some best practices.
Gartner's current definition of ERP in the postmodern era is:
Postmodern ERP is a technology strategy that automates and links administrative and operational business capabilities (such as finance, HR, purchasing, manufacturing and distribution) with appropriate levels of integration that balance the benefits of vendor-delivered integration against business flexibility and agility.i
The original ERP systems were developed for product-centric companies, which typically have the broadest ERP functional footprint. Product-centric companies traditionally are manufacturing companies and distribution companies.
A single- instance ERP reduces the number of consolidation points and allows the integration of financial transactions across a company. There is no need for uploads to a “system of record” to properly record a transaction.
A single-instance strategy is compelling in that it helps lower cost in the many organizations that struggle with redundant data, high training costs, and lack of insight across disparate systems and processes. A single-instance strategy is related to the desire of a business unit for more autonomy; others are of a more technical nature. There are three factors to consider when evaluating a single instance deployment:
Cloud-based computing (also called software as a service, or SaaS) allows users access to software applications that run on shared computing resources (for example, processing power, memory, and disk storage) via the Internet. These computing resources are maintained in remote data centers dedicated to hosting various applications on multiple platforms.
Cloud ERP is software as a service that allows users to access Enterprise Resource Planning (ERP) software over the Internet. Cloud ERP generally has much lower upfront costs, because computing resources are leased by the month rather than purchased outright and maintained on premises. Cloud ERP also gives companies access to their business-critical applications at any time from any location and is an excellent enabler of a faster close process and supports business continuity and contingency requirements.
INTRODUCTION: THE FISCAL CLOSING process is one of the most fundamental indicators of the efficiency of your fiscal infrastructure, and is the critical foundation that must be in place before your finance and accounting team can even begin to optimize its role as a true consultative business partner and trusted advisor, assisting in achieving strategic goals and creating shareholder value. Getting accurate and timely fiscal information is critical in today's global market because:
If your finance organization is bogged down in a never-ending closing process, they have little time to focus on enhanced reporting or analytics. Visibility to accurate fiscal information and underlying operating metrics are critical to your management team in any economic environment, but particularly in times of uncertainty, where rapid and knowledgeable responses to changing business and market dynamics are imperative.
There are many factors that place the spotlight on the fiscal close process, which is usually led by a team of individuals in the corporate finance and accounting department managed by the corporate controller. The complexity of the process is driven by the nature of the company (private, public, nonprofit [tax-exempt or mission based], or government) and the type of industry or industries the company has responsibility for. Sometimes the organizational structure of the company, the fiscal systems and tools, and the management style can impact the fiscal close process cycle time and the resources needed.
Key Point: The signs that the fiscal close needs attention include:
The fiscal closing cycle is also referred to as the Record to Report (R2R) process. Record to Report (R2R) forms an important aspect of the finance and accounting process. It provides the necessary insights on the strategic, operational, and fiscal facets, which gives an in-depth idea of an organization's performance. It involves complex processes of gathering, converting, and supplying information to stakeholders who want to know if their expectations have been met.
Regulatory bodies and analysts expect organizations to review their account books in less than a week and release their earnings statements within a month. Industry-specific regulations and the ever-increasing financial reporting has put a huge burden on an organization's reporting process.i
Key Point: When fewer days are devoted to month-end close activities, more time can be spent providing performing analytics and addressing finance and accounting process improvements.
The accounting process can differ slightly from one business to another based on variances in the chart of accounts, revenue and expense recognition, and cost center breakdown. Despite these differences, the overall monthly closing process is the same. Following the same standard procedures to close the books each month will help ensure consistent and accurate reporting. Here are some basic processes that will add discipline to the fiscal close. These processes will also help to expedite closing processes.
Establish a closing date by which all expenses and revenue must be posted. Communicate the closing date to everyone who has access to modify the ledger. Close the books for the month as of the date communicated, prohibiting any further changes to the ledger for the period.
Start the closing cycle with a trial balance report. Review the balances to identify any anomalies from what is expected. Review the transaction details for any accounts you are uncertain of and note any adjustments that need to be made.
Create the adjusting entries to recognize prepaid expenses, accrue outstanding invoices, relieve accruals that have been paid, and recognize depreciation and other amortizations. Post adjusting entries to correct the current balance of any ledger account that reflects expense postings in error.
Generate an adjusted trial balance report to review the final balances in the ledger. Verify that the trial balance matches on the debit and credit side. Verify that the balances are accurate, checking the account activity if needed. Trial balances will vary from the initial report due to the adjusting entries. This helps you identify any entries that posted incorrectly.
Create reporting to show the final expense activity for the period and year-to-date. Include documentation of the balance sheet, income statement, and depreciation schedules. Save copies of the entire journal entries posted along with the documentation supporting their necessity for audit purposes.
The following background on the “cycle time to monthly close” comes from APQC's General Accounting Open Standards Benchmarking survey. For this open-ended question, the metric is defined as the cycle time in calendar days between running the trial balance to completing the consolidated financial statements. Cycle time is the total time from the start of the process to process completion, including time spent actually performing the process as well as time spent waiting to move forward.
Of the 2,300 organizations that answered this survey question, the bottom 25% said they need 10 or more calendar days to perform the monthly close process. The top performers, or the top 25%, can wrap up a monthly close in just 4.8 days or less—about half the time of the bottom 25%. At the median are the organizations that need 6.4 calendar days to close out a month's books.ii
For multisite companies with separate reporting entities, finance has to ensure the chart of accounts' naming and numbering conventions are as closely matched as possible. Organizations that strictly adhere to common fiscal definitions need fewer days to complete their monthly consolidated financial statements.
Common data definitions set the business rules for every aspect of the fiscal close and can prevent transactional errors and will help set the foundation for accurate metrics and support consistency through all phases of the fiscal closing process.
INTRODUCTION: ALTHOUGH THERE ARE different reporting requirements and levels of complexity for each fiscal close process, the closing is very similar regardless of industry or company size. Here are some of the common challenges that continue to place the fiscal close in the corporate spotlight. Understanding these key pain points and bottlenecks will help identify the areas of focus when implementing process improvements to achieve a faster close.
Common Financial Close Process Challenges |
|