Connect with us

Accounting

Why don’t GL systems have better bank recs?

Published

on

In an ideal world, your general ledger is streamlined, automated, and error-free financial reconciliations. Yet, in reality, when it comes to reconciling, most accountants still find themselves defaulting to Excel. 

Despite advancements in technology, reconciling accounts within GL platforms remains tedious, error-prone, and inefficient. So, why does this persistent gap exist? One fundamental issue with GL software reconciliations is rigidity. 

Most current accounting software platforms tout flexible integrations and streamlined processes, but their reconciliation functionalities often require precise matching criteria that don’t reflect real-world complexity. More specifically:

  • Transactions rarely fit neatly into a software’s predefined rules. 
  • Slight differences in dates, amounts, or descriptions can cause automated reconciliation to fail, forcing accountants into manual troubleshooting.
  • The rigidity extends further into how software platforms handle discrepancies. 
  • Even minor mismatches can cause automated systems to reject otherwise legitimate matches.

What happens is that instead of quickly isolating issues for rapid correction, accountants frequently must comb through lengthy lists of exceptions, trying to manually align what the software could not. This, in turn, diminishes the intended efficiency benefits of utilizing software for this monthly close process.
Moreover, the reconciliation tools embedded within most GL software platforms are often limited in their ability to handle the granular, nuanced requirements of real-world financial reconciliations. A single bank statement or credit card reconciliation can encompass hundreds of transactions—many of which might not follow identical patterns month-over-month.  So, while software vendors advertise their “sophisticated matching algorithms,” in practice, accountants find these to be insufficiently adaptable for varying business contexts.

Another factor exacerbating the frustration is the lack of clarity and transparency within reconciliation modules. Accountants frequently complain about opaque error messages and unclear reconciliation statuses. 

When software returns vague descriptions like “transaction mismatch,” without indicating precisely what or why a mismatch occurred, the burden shifts entirely back onto accountants to investigate manually. All of these issues consistently drive accountants back to Excel for month-end bank reconciliations, the tried-and-true method. 

Like it or not, Excel remains popular because of its flexibility, control, and familiarity. Accountants can quickly manipulate data, adjust matching criteria on the fly, and clearly document exceptions. 

Excel’s versatility allows for bespoke solutions, something software programs rarely achieve. Accountants can pivot quickly, crafting formulas tailored to their unique reconciliation needs, free from the constraints of software-imposed rules. 

However, relying heavily on Excel brings its own issues, including increased risk of errors from manual data handling, difficulty in collaboration, and challenges in auditability and traceability. Spreadsheets, while flexible, are notoriously prone to human mistakes. 

Copying errors, incorrectly entered formulas, and data integrity problems are common risks associated with manual Excel reconciliations. So why do so many accountants still swear by it? The flexibility saves more time than the automation.

The reality is, in 2025, there remains a significant gap in general ledger software: the human factor. Reconciliations are inherently nuanced tasks requiring professional judgment, something no algorithm can entirely replicate. 

Yet, instead of supporting this human element, most GL reconciliation tools limit it. Software solutions that fail to embrace the complex, adaptive nature of human decision-making inevitably push accountants toward manual alternatives.

The solution, therefore, is not simply better automation, but smarter automation that’s compatible with human judgment. Software should empower accountants, rather than constrain them, blending automated suggestions with easy, intuitive ways to adjust criteria.

Sure, some forward-thinking accounting software providers are beginning to recognize the inefficiencies of over-automation. Emerging platforms incorporate machine learning techniques that dynamically learn reconciliation patterns, accommodating slight variations without rejecting valid transactions. Interfaces are starting to provide greater transparency and ease of use, helping accountants quickly understand and address discrepancies within the software itself. 

And while we still have a ways to go, the future of GL reconciliation software is promising. The providers who prioritize user-friendly, transparent, and flexible reconciliation tools will be those who finally persuade accountants to fully adopt in-app reconciliations, transforming the reconciliation process from a burden into a genuinely streamlined activity.

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Accounting

Withum adds CTM CPAs & Business Advisors

Published

on

WithumSmith+Brown, a Top 25 Firm based in Princeton, New Jersey, is adding CTM CPAs & Business Advisors, a firm based in Lincolnshire, Illinois, a Chicago suburb, expanding Withum’s presence in the region.

As part of the deal, CTM’s four partners and approximately 50 team members will join Withum but remain in their Lincolnshire offices. Withum ranked No. 22 on Accounting Today‘s 2025 list of the Top 100 Firms, with annual revenue of $578 million, approximately 230 partners, 2,500 employees and 23 offices. Financial terms were not disclosed.

“Uniting our firms allows us to expand our portfolio of franchise clients,” said Withum managing partner and CEO Pat Walsh in a statement. “CTM’s team will bring additional depth of  service and expertise in this area. Their approach to client service, proven by a similar tenure in the profession, blends seamlessly with ours. Together, we share a people-first mentality with a vision of providing best-in-class solutions through a dynamic  approach to problem-solving for our clients’ growth and success.”

The deal will increase Withum’s Midwest footprint and strengthen its industry specialties. In addition to expanding Withum’s franchise practice, other industry practices bolstered by the CTM combination include restaurants and hospitality, professional services, real estate and construction, manufacturing and distributors, not-for-profits, client accounting and advisory services.  Withum focuses on innovation, celebrating its employees’ ideas each month.

“We are very excited and eager to become part of the Withum team,” said CTM managing partner Steven Edelheit in a statement Wednesday. “Our client promise has always been to build long-term relationships through exceptional client service to help them reach their goals. It is for these reasons, among many others, that joining forces with Withum will offer our valued clients and dedicated staff more opportunities to thrive and achieve success. Our clients will now benefit from a larger network of national and international resources, deeper technical expertise and enhanced knowledge in specialized service areas.” 

Last April, Withum added BBD LLP, an accounting, tax and advisory firm based in Philadelphia that mainly serves nonprofit and government organizations. In 2023, Withum merged in O’Connor & Drew, a firm in Braintree, Massachusetts. In 2022, it added Martinez & Associates in Winter Springs, Florida, and Martini Partners in Encino, California.

Continue Reading

Accounting

To PE, or not to PE, is that the question?

Published

on

Many small and midsize firms are seeking a sounding board for the myriad calls they are getting from private equity firms and others seeking to acquire accounting practices. They’re exhausted. And the ongoing barrage continues to add pressure for firms to make a call on whether or not they should “go PE.” 

There are benefits to upgrading aspects of public accounting with an infusion of profit-oriented owners instituting goals, accountability and growth drivers. However, each firm would do itself, and the profession, the best service by reflecting thoughtfully about the options at hand. 

Before seeing “Should we go with private equity?” as the question, firms should step back and review their specific strategy and position. Maybe whether to go PE is still a possibility, but only after they’ve answered preliminary questions that would drive them to consider private equity. 

What does a firm need to know to determine its interest, or not, in PE (or another external capital partner)?

10 critical questions for CPAs

  1. How do you measure success (profitability/financial reward, client service, internal culture, lifestyle, professional contributions, community contributions, among others)? It’s OK to measure success differently than your peers or industry benchmarks. 
  2. How satisfied are you with your firm’s success? Rate each success area you identified above. 
  3. How confident do you feel in your ability to continue your success (1) during your career, and (2) for the ongoing legacy of your firm (after you’ve retired and been paid out)? Note: Many firms feel confident enough in continuing at a rate that meets their needs, whether they are above or below traditional or industry benchmark measures of success. This is a fine place to be, and “not to PE.”
  4. How much preference do you have for autonomy in strategy and decision making versus having additional leadership and influences in these areas? 
  5. How much preference do you have for continuing to champion industry trends and challenges, such as recruiting and technology/AI, with your current or projected internal resources? 
  6. How much preference do you have for continuing to do the ongoing work related to back-office operations like billing, collections and firm administration?
  7. Do you have the internal leadership talent and culture of accountability to reach your goals?
  8. If you could have more profitability and resources along with the involvement of outside capital and influence, would you want that arrangement? 
  9. If outside capital and influence are of interest to your firm, should you look at the pros and cons of mergers (equal or up), ESOPs, family office capital or others in addition to PE?
  10. What are the pros and cons of each option as it relates to the impact on your success measures identified above? 

Much like a choose-your-own-adventure story, the answer to each of the 10 questions above doesn’t always lead where you might expect. You may find that PE is clearly the best choice for your firm. You may find that an ESOP is very attractive, or that selling to a larger CPA firm would be the best fit for your team and clients. You may feel more confused than ever. You may find that you remain content with your partnership-model firm, just as you were before. 

Here are a few vignettes from firms I’ve talked with recently, and which options they are considering:

In one case, a $5 million firm wants to take a new step forward, something other than “what we’ve done” to propel it to future success. The partners want to continue to develop their next generation, allow current (not-quite-retirement-age) partners more opportunities, either via ongoing client service and less admin, or by moving from a client service role to an M&A role seeking out acquisitions for growth. 

It’s likely this firm’s leaders would feel satisfied with their success but have some concern about their ability to continue it, especially in the realm of recruiting and the administrative work required to operate a CPA firm. They are interested in pursuing PE to expand their options and seek a secure future for retirees, partners, staff and clients. 

In another case, an $8 million firm is content with its $600,000 average income per partner, and sufficient talent pipeline, including newer partners to replace upcoming retirements. The partners share a desire to keep buyouts at a reasonable price to allow newer partners similar current income success as earlier partners. They feel confident their in-house decision-making and governance will perpetuate the investments, profits, culture and client service they have enjoyed to date. 

It’s likely this firm’s partners would feel satisfied with their success and are content with their leadership group’s abilities and capacity to continue it. They are interested in staying independent to continue the legacy, including autonomous decision-making and profits that they’ve built to date. 

Making a decision

Along with those firms that know which option they would choose, many are in the land of uncertainty. For this I recommend continuing your quest to learn more about various options, engaging in a deeper strategic planning process and ultimately making a call, even if it’s for a limited timeframe, like six months, at which point you can revisit. 

Decision-making will allow you to move on with your goals and objectives and know clearly whether you should pick up that next inbound call offering the riches of capital or continue to champion the business you’ve already built. 

Continue Reading

Accounting

FASB proposes ASU on debt exchange transactions

Published

on

The Financial Accounting Standards Board issued a proposed accounting standards update Wednesday offering guidance for debt exchange transactions involving multiple creditors.  

The proposed ASU stems from a recommendation of FASB’s Emerging Issues Task Force. 

Under the current rules, when an entity modifies an existing debt instrument or exchanges debt instruments, it’s required to determine whether the transaction should be accounted for as (1) a modification of the existing debt obligation or (2) the issuance of a new debt obligation and an extinguishment of the existing debt obligation (with certain exceptions).

The proposed update would specify that an exchange of debt instruments that meets certain requirements should be accounted for by the debtor as the issuance of a new debt obligation and an extinguishment of the existing debt obligation. The amendments would apply to transactions involving the contemporaneous exchange of cash between the same debtor and creditor in connection with the issuance of a new debt obligation with multiple creditors and the satisfaction of an existing debt obligation.

FASB anticipates this change would improve the decision usefulness of financial reporting information given to investors by requiring that economically similar exchanges of debt instruments be accounted for similarly. It also would decrease differences in practice in accounting for such debt instrument exchanges.

FASB is asking for comments soon on the proposed ASU by May 30, 2025.

Continue Reading

Trending