Report: Most General Ledger Accounts Reconciled Manually
by Terri Eyden on
By Jason Bramwell
If you think automation is primarily being used to reconcile the general ledger accounts of public and private companies in the United States and Canada, think again.
Nearly two-thirds of finance departments in US companies and one-half in Canadian companies are still using a manual accounting system, according to Benchmarking the Finance Function 2013: The Inner Workings of Accounting and Finance, the fourth annual report from the Financial Executives Research Foundation (FERF) and Robert Half, which provides insight into professional standards across the finance function.
"The level of manual reconciliation reported in our survey is surprising; however, we've seen this same consistent response in the four years we have conducted the study," Paul McDonald, senior executive director for Robert Half, told AccountingWEB. "The most progressive companies are moving toward automating the process through in-house systems or Cloud and software-as-a-service solutions."
Rising Number of General Ledger Accounts
Finance departments at companies of all sizes are grappling with growing numbers of general ledger accounts. Of the nearly 200 American and Canadian companies surveyed, more than half say they have 500-plus general ledger accounts. Ten percent of US companies and 20 percent of Canadian companies report they have upward of 3,000 general ledger accounts.
More Key Findings of the Report
- US management-level accounting and finance employees work an average of forty-eight hours in a standard week; nonmanagement staff work an average of forty-two hours. In Canada, the average workweeks for managers and staff are forty-four hours and thirty-nine hours, respectively. When hours regularly exceed their standard workweek, especially during peak workload periods, staff are supplemented with the use of interim professionals.
- The median number of internal staff in US finance departments is eleven; the median in Canada is sixteen.
- Eighty percent of US companies and 86 percent of companies in Canada use an enterprise resource planning system. The use of on-demand software is increasing.
- Payroll is the single-most outsourced function for all respondent companies, followed by tax. Accounts payable is emerging as a possible candidate for additional outsourcing.
- Larger companies are more likely to have an internal audit function responsible for compliance activities. At smaller firms, the compliance function most often resides with the financial reporting or general accounting departments.
"Financial leaders are taking a fresh look at how their departments can commit assets to achieve the most value for the company," Paul McDonald, Robert Half senior executive director, says in a press release. "Shared services centers, new technologies, and the increased use of interim financial professionals are among the many tactics being employed to allow executives to apply resources where and when they are needed most."
As business grows more complex, so does the number of accounts that need to be reconciled on at least a quarterly basis. Twenty-three percent of US-based companies and 19 percent of Canadian businesses surveyed indicate they reconcile anywhere from 500 accounts to more than 10,000 accounts.
While many of the company executives interviewed for the study advocate automating the closing of the books, 65 percent of US companies and 50 percent of Canadian companies are still manually reconciling accounts. Only 12 percent of US companies and 23 percent of Canadian companies surveyed use third-party software for account reconciliation, while 23 percent of American businesses and 27 percent of Canadian firms have implemented internally developed systems.
Streamlining the Close
According to the report, some executives at smaller companies are not convinced that available technology for automating the close is sufficiently tailored to their needs. They expressed concerns that their teams could end up expending more time and resources setting up a custom software package than it would take to continue with a manual process.
However, organizations like Sonetics Corporation, a Portland, Oregon–based wireless communications manufacturer, and Northern Contours Inc., a manufacturing firm in St. Paul, Minnesota, report that using an automated system gives them a competitive advantage over companies that are bogged down in the process, allowing their finance departments to utilize resources in higher-value activities.
"It currently takes fifteen days for us to produce the year-end statement, and I'd like to get that down to eleven days," Mike Williams, vice president of finance for Sonetics, says in the report. "I'm looking to maximize our opportunities and add value to our forward-looking activities."
Angela Riley, CFO of Northern Contours, states the company has placed a greater emphasis on the reporting process and is increasingly turning to automation tools.
"We've reduced the time it takes to produce our monthly, quarterly, and annual financial statements by nearly 50 percent," she says in the report.
Account reconciliation is still a manual process at Employee Benefits Corporation, a third-party administrator of financial services in Middleton, Wisconsin. However, according to Don Tuscany, vice president of finance and CFO, the company has started to incorporate more automated processes in its financial reporting.
"We're getting closer to the amount of automation I'd like to see us have," he says in the report.
Using technology may not be the only answer for streamlining the close. Process design and execution play key roles, as well. When Canadian Western Bank Group in Edmonton, Alberta, instituted its new general ledger system, it implemented a more effective process to create and post entries. This process has helped reduce the number of reconciliations.
"We don't have as many intracompany reconciliations because we are able to get the entries right the first time," Carolyn Graham, senior vice president and chief accountant, says in the report.
About the survey:
In November 2012, FERF and Robert Half conducted their fourth annual benchmarking survey of finance departments at 192 public and private companies in the United States and Canada. The data contained within this report were compiled from responses to a forty-eight-question online survey. More than half (58 percent) of the respondents identified themselves as CFOs, and the majority (81 percent) were located in the United States, while 19 percent were located in Canada.
You may like these other stories...
PwC must face $1 billion lawsuit over MF Global adviceA federal judge on Wednesday ordered PricewaterhouseCoopers (PwC) to face a $1 billion lawsuit claiming that its bad accounting advice was a substantial cause of the...
Anti Burger Kings: Seven US companies shrinking tax the old-fashioned wayBurger King’s decision to combine with Canadian donut shop Tim Hortons is renewing controversy over the lengths some US companies will go to...
Read more from Larry Perry here and in the Today's World of Audits archive.Since the AICPA's Financial Reporting Framework for Small- to Medium-sized Entities (FRF for SMEs) and some other financial reporting...
Upcoming CPE Webinars
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Transfer your knowledge and experience to prepare your team for the challenges and opportunities of an accounting career.
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.