Report: Most General Ledger Accounts Reconciled Manually

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, Oregonbased 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...

Event Date: May 15, 2014, 1 pm ETThis presentation will review basic concepts of the FRF for SMEs and discuss the presentation of a statement of financial position. This webcast will focus on accounting policies for certain...
London Stock Exchange switches auditing to EYThe London Stock Exchange will drop PwC as its auditor and replace it with EY after completion of the audit for the year ending March 2014, Harriet Agnew of the Financial Times...
The Financial Accounting Standards Board (FASB) had hoped to issue a final standard on revenue recognition during the first quarter of this year. However, the standard-setting organization confirmed today that the timetable...

Upcoming CPE Webinars

Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
Apr 30
During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.
May 1
This material focuses on the principles of accounting for non-profit organizations’ expenses. It will include discussions of functional expense categories, accounting for functional expenses and allocations of joint costs.