The annual reporting activity is part of the three major lost opportunities for the finance team. Slow month-end reporting, long annual planning, and a never ending year-end suck the life out of far too many accounting teams.
While annual reporting is an important legal requirement, it does not create any value within your organization, and thus seldom is it a task where your team has received any form of gratitude. Accounting functions therefore need to find ways to extract value from the process, while, at the same time, bringing it into a tight time frame.
Before you can have a quick year-end, you need to speed up month-end reporting monthly so staff are disciplined to a tight month-end. Your goal should be reporting monthly numbers and comments by day 3 (see Chapter 3 on quick month-end reporting).
This chapter is a summary of the content in my white paper, “Quick Annual Reporting: Within 15 Working Days Post Year-End.”1
There are many ways in which we can improve how we process the year-end reporting, and they can all be grouped in five ways:
As stated in Chapter 2, before we can make progress, we need our organization to see the need for change. We need to change its default view so leaders can persuade themselves that changes are not only necessary but desirable. Please reread Chapter 2 for greater detail.
The costs of a slow year-end include:
In order to create a change in the way the senior management team (SMT), board, and management address the annual accounts, you need to establish what is the full cost of the annual accounts process, including all board, management, and staff time, and all external costs (audit fees, printing costs, public relations, and legal fees, etc.). Exhibit 12.1 shows how to calculate the costs of an annual accounts process. The times are estimates and show what a typical 500 full-time-equivalent organization might be investing in the annual report preparation. It does not include investor relations, and so forth.
The SMT has lower productive weeks in a year because you have to take out, in addition to holidays, training, and sick leave, the time they spend traveling and in general meetings.
Many top U.S. companies report very quickly to the U.S. stock exchange. In my days as an auditor, IBM was well known for its speed of reporting. If your organization reports very quickly at year-end, ignore this chapter; otherwise, read and implement, as you and your organization are wasting too much time in this area. There are a number of benefits, including:
Exhibit 12.2 shows a rating scale, based on my observations and benchmarking, for the time frames to have an audited and signed annual report (time from year-end date).
Exceptional | Outstanding | Above Average | Average |
Less than 15 working days | 15–25 working days | 26–35 working days | 35–45 working days |
EXHIBIT 12.2 Year-End Reporting Time Frames (from the Year-End to Signed Annual Report)
We need to treat every year-end like a military operation. Getting organized, and getting organized early, is the key.
I always point out to accountants that we are all artists. Each year-end, we sculpt the result, and it can never be the right number, as there is no such thing as a “right” number—it can only be a “true and fair” number. If ten accounting teams prepared the year-end numbers for one company, there would be ten different results. Each accounting team will have made different judgment calls, different calls on materiality, accruals, and accounting treatments.
As mentioned previously, the finance team has to realize that they only need to do enough work to arrive at a true and fair view. All work done after this point has been reached will thus not be adding value. We therefore need some rules that the year-end reporting (YER) should adhere to:
Year-end reporting is not the time for spring cleaning no matter how tempting it can be. This requires a reeducation within the finance team and with budget holders.
We want to have a regime where we catch all material adjustments and see the net result of them before any decision is made to adjust—for example, only a material year-end misstatement will result in processing an adjustment.
A draft finance team year-end rules is in the accompanying pdf download.
An audit can very easily get disorganized. The audit firm will more than likely have a change in either the audit senior or audit staff, and first-year staff members will know little about what they are trying to audit, no matter what training they have had. So, help the audit team (it is in your interests) by:
The steps in each of these stages are set out and analyzed in detail in the annual accounts checklist, which is provided in the accompanying PDF download.
Your auditors have probably delayed the audit to fit it into their work schedule. We therefore need to renegotiate the auditor's sign-off deadline. The message is, “We are going to be quick, and so are you. If you cannot make this tight deadline, we will need to go elsewhere.”
Most auditors have already signed a set of audited accounts quickly. Sometimes it is because the companies wish to seek additional finance or want to be seen as a leading organization. The auditors have standard processes in these events. The benefits include:
To enable the auditors to come in and commence their audit earlier, leading finance teams have negotiated a hard close on a shorter period. In most cases, month 11 suffices. Effectively, month 11 becomes the year-end, with all major assets, such as debtors, stock, and fixed assets, being verified. If a debtors' circularization is to be performed, this will need to be performed on month 9 or 10 balances, thus allowing enough time for responses.
Once the auditors have formed an opinion as to the P/L and balance sheet for this period, they need only to audit the movement of the numbers for month 12 transactions.
The larger and more complex the organization is, the greater the need for a hard close at month 10 results.
This electronic file, if scoped with the auditors and diligently completed by the finance team, will save hours of audit and finance team time. The electronic file:
The lessons of abandonment (Peter Drucker) and how not to be trapped into living with the results of other people's thinking (Steve Jobs), outlined in Chapter 1, need to be embraced. Your year-end processes, spreadsheets, and documentation are the “result of other people's thinking.” We need to abandon the processes that have no purpose other than doing it because we did it last year. Some easy and common abandonments to embrace:
The Post-it reengineering process was outlined in Chapter 10, and you will need to reread this section to understand the process. The suggested attendees for the reengineering of the year-end will include all those involved in year-end including accounts payable, financial and management accountants, a representative from the auditors (the audit manager), and representatives from teams who interface with year-end routines (e.g., someone from IT, payroll, and the chairman's office). The agenda for the session is set out in Exhibit 12.3.
Date & Time: _________________ Location: ___________________ Learning Outcomes: Attendees after this workshop will be able to:
|
|
9:00 a.m. | Welcome by Financial Controller |
9:10 | Setting the scene—a review of better practices among accounting teams that are delivering swift annual reporting. Topics covered include:
Senior management, PR expert involved in annual report, representative from the legal team, and a selection of budget holders (who are based in locally), will be invited to attend this session “setting the scene.” |
9:50 | Agreement on the current key bottlenecks of year-end reporting, presented by CFO or the financial controller
|
10:05 | Workshop One to analyze the year-end procedures using Post-its (different color allocated for each team involved, see Exhibit 12.4) |
10:30 | Morning break |
10:45 | Workshop One continues |
11:20 | Feedback and pulling it together. Participants will document agreed changes and individuals will be encouraged to take responsibility for implementing the steps. |
12:00 p.m. | Workshop Two to set out the appropriate implementation steps to implement quick annual reporting. Each team prepares a short presentation of the key steps they are committed to making (teams will use PowerPoint on laptops). |
12:30 | Lunch |
1:15 | Workshop Two continues |
2:00 | Each team presents reports to the group about what changes they are going to implement and when. Each team can also raise any issues it still has. The members of the senior management team and budget holders, who attended the first session, will be invited to attend this session. |
2:30 | Wrap up of workshop by CFO or financial controller |
2:45 | Finish |
EXHIBIT 12.3 Draft Agenda for the Quick Annual Reporting Workshop
The scrum techniques outlined in Chapter 10, are ideal for the annual accounts process. On the year-end accounts, those involved in the preparation would meet, every morning, for anywhere from 10 to 20 minutes in a stand-up meeting. The importance of a stand-up meeting is that it is quicker, as we are more alert. At each session, attended only by those who are currently involved in a year-end accounts activity, they are asked to talk about:
At the end of the session, the group ends the session touching fists, an homage to the source of this technique. When the auditors arrive it may be appropriate for them to join the scrum. Would it not be nice to know what they have achieved yesterday?
Please reread the section in Chapter 10 to understand all the procedures of this important process.
The use of modern technology is important, no matter what size your organization is.
Your year-end will only be efficient when you have utilized consolidation software so that you can consolidate without fear of a screen full of REF! REF! REF! As mentioned in Chapter 4, performing a consolidation in a spreadsheet is inappropriate, and adds unnecessary error factors to the process.
There are now excellent systems that organize this for you and enable the subsidiaries to have their own general ledger and account code structure. Their trial balance is simply mapped into the consolidated entity's account codes. A search with any search engine will also find some freeware, robust older versions available at no cost. Try this search in your search engine, “consolidation+software+freeware.” It worked for me.
Larger conglomerates need to have a sophisticated communication system between all related companies. Far too many finance teams are conned into thinking that they need to standardize the G/Ls for this. Yes, it will do the job, but at what cost? The primary beneficiaries are the G/L providers and the associated consultants who, no doubt, can now buy that second summerhouse that they so badly need, by their favorite lake.
The answer lies with accessing sophisticated intercompany software that enables an automatic interface for intergroup transactions where one party to the transaction does the entry for both G/Ls. This software, like the consolidation software, allows subsidiaries to keep their own G/L and account codes.
Reread Chapter 4 for a list of the intercompany and consolidation software applications.
Your G/L will have many unutilized features. So ask your G/L consultant to come for a day to see where the finance team can better use the G/L's built-in features for monthly and year-end reporting.
As mentioned in Chapter 4, this software ensures that you have one database that is the sole source of the truth. For the year-end accounts, the input into the notes to the annual accounts would be controlled this way.
I would consider this software a must have for any organization over 500 full-time equivalents. It will be invaluable for year-end, month-end, and annual planning documentation.
The year-end is a busy time, and there is a premium on being organized, as already covered, and ensuring that we undertake tasks efficiently, always using Pareto's 80/20 rule.
The first step to reducing stress and improving communication between staff and the audit team is to have a full-time audit coordinator. This person should be a staff member, not necessarily in finance, who knows most people in the company and knows where everything is, in other words, an oracle.
You may find the ideal person is someone in accounts payable or someone who has recently retired. The important point is that the individual should have no other duties during the audit visits (both interim and final) than helping the audit team. Give the individual a pleasant room and say, “When not helping the audit team, you can simply put your feet up.” Do not get tempted to give the person additional duties. The audit coordinator's tasks include:
It is desirable to complete the annual report, other than the final year's result, by the middle of month 12. This will require coordination with the public relations consultant who drafts the written commentary in the annual accounts and discussions with the chairman of the board and the CEO. Your last month's numbers will not greatly impact the commentary.
As mentioned, the annual report is not an eagerly awaited document. If you are a publicly listed company, the stock market analysts rely more on the in-depth briefing your organization provides them. Your shareholders access a summary of the results from their broker.
Year-end is not a time for spring cleaning. We will apply the rules already mentioned in this chapter. We will make the month 12 numbers the final-year numbers. The “overs and unders” schedule, as shown in Chapter 3, will be maintained, and we will record any major adjustments on this schedule. When the auditors arrive, we hand over the “overs and unders” schedule informing them that these are the adjustments to date. The auditors take ownership and update with any other subsequent adjustments.
You will often find that adjustments have a tendency to offset each other. If the auditors find a major adjustment, look in the opposite direction and you no doubt will find another to offset it.
The year-end adjustments will be reviewed as follows:
Stock takes should never be conducted at any month-end, let alone at year-end. There is no need to do this, as your stock records should be able to be verified at any point in time. It is a better practice to conduct rolling stock counts rather than one major count that closes all production. A well-organized stock take includes:
Auditors can get lost very easily in auditing the added value in work in progress (WIP) and finished goods. On one audit it took me a couple of weeks of elapsed time to trace the WIP through its stages, using random samples. In the second year, it was suggested that I look at how many weeks of production there were in WIP, which was easy to confirm, then at how many weeks of direct and indirect overhead could and should be absorbed. The audit of WIP took less than four hours. Thus, help your auditors by providing working papers to verify the reasonableness of complex valuations such as WIP.
The key to a better use of the fixed asset register (FAR) is a good attitude. Many finance teams see the FAR as a necessary evil, and thus little focus is given to really driving it properly. Few finance teams grab the opportunity and turn the FAR into a valuable system:
The internal auditors can significantly reduce the external auditors' work. Many organizations contract out this function to an independent firm. I believe an in-house internal audit team will pay for itself many times over by:
It is important that you insist that the auditors put a bit more care and attention into the management letters and that they are delivered within two weeks of the interim and final visits. Prompt management letters mean that management can rectify a problem immediately.
Management letters are often an afterthought, completed many months after the final audit, when much has been forgotten. The audit staff assigned to write the management letter are often relying on inadequate notes. The resulting letter is poorly constructed, with comments about a minor procedural failure easily being taken out of context by the board.
We need to ensure that all errors noted should be stated in context (e.g., We found 20 invoices with the wrong prices. We understand this was because _________. Management has rectified this situation and we tested a further sample of _______ and found no further errors. We note that of all the other price tests we performed, there were no other errors. We do not believe this has led to a loss of profits greater than $______).
Also, we want the auditors to comment on our strengths (e.g., “We would like to comment that the new monthly report formats are the best we have seen; they are clear, concise, and efficiently produced”).
I recommend that you insist that the draft letter is prepared before the audit team leave. Say to the visiting audit team, “We will go to the end-of-audit function when we have seen the letter.” They will thank you for making them more efficient.
In conjunction with the external auditors, look at making more use out of the interim audit. You may have implemented a new expense system, so ask the auditors to spend some time testing compliance. Ask them to cover more branches, ensuring nearly all branches are covered every two years. This will cost more but will be worthwhile.
Always remember that it is perception that rules the roost; staff members in remote branches will begin to conform to company policies if they know that auditors are to arrive and that they always test the compliance of the key systems along with all the new systems.
It is a good practice to have the first interim visit in the first half of the year to assure that the organization's staff maintains vigilance on compliance.
It is important to inform the staff and audit team about what is subject to restricted access (e.g., it might be that only the audit partner is able to see the senior management team's payroll). I remember the days when the audit team would fight over who was to look at the payroll; just remember, it is human nature to be nosy.
In order to achieve a fast year-end, Excel has to be replaced by twenty-first-century systems. There are several potential areas to consider if an organization is to achieve substantial time savings in the reporting supply chain. The main areas to tackle here include:
Those of us who have reported to a finance department in an international conglomerate will know that the reporting pack was designed by a rocket scientist without any regard to materiality. Endless pages of data are gathered and sent, most of it meaningless. “It could be useful to have this,” “Better ask for that in case I might get a question.” The result is hours upon hours spent around the world gathering the data, which, by the way, are never used by the subsidiaries to manage their business.
How did this happen? First, the CFO delegated the task and then took little or no interest in how big the reporting pack had grown. The CFO may have observed, “The reporting pack looks a bit large. Are you sure you need all of this information?” Second, nobody ever calculated the full cost of the data-gathering process and compared it against the benefit. If this task was done, common sense would have won out. Third, there are seldom effective forums for management accountants in the subsidiaries to challenge those in the head office by saying, “Why do you need this?” or, “Tell me what you do with all of this.”
Often, the mapping of data from reporting entities involves extensive manual procedures, spreadsheets, and the batch transfer of files, all of which introduce the potential for serious error every step of the way. It is often very difficult to spot these errors, which have a nasty habit of rearing their ugly heads during the final audit. In addition, the scope for mistakes increases by the number of entities involved and the frequency of changes in the group's reporting pack, brought about by management accountants having brain waves and the need to meet regulatory changes.
The efficient marshaling of information post consolidation is vital and is known as the last mile in annual reporting. In the last mile, there are PDF files, spreadsheets, PowerPoint slides, Word documents, and email communications, all of which provide input for the notes to the annual accounts. It is important that they are accessible to all those on the annual accounts team rather than residing in individuals' email inboxes and C drives.
The quality assurance steps from Chapter 7 apply here. They include:
Here are some case studies; many more can be found on the Internet.
To assist the finance team on the journey, templates and checklists have been provided. The reader can access, free of charge, a PDF of the suggested worksheets, checklists, and templates from www.davidparmenter.com/The_Financial_Controller_and_CFO's_Toolkit.
The PDF download for this chapter includes: