10 Warning Signs It May Be Time to Give Up Spreadsheets | AccountingWEB

10 Warning Signs It May Be Time to Give Up Spreadsheets

Gary Levine - At Two Step Software, we sometimes feel like the Good Samaritans hot line when a CFO, Controller, or stock plan administrator tells us confidentially that they think they may have a “spreadsheet problem.” They don’t know who to turn to. They call us, often late at night, since we’re just a warm body at the other end of the line. Someone to talk to. Some don’t even call. They use email. A few … anonymously.

Well, we know what they’re going through and it’s so much more common than they realize. We see it every day, but they think they’re the only one who’s ended up this way. They imagine they’re the last CFO in Silicon Valley who’s afraid to move away from the comfort of their old, trusted Excel spreadsheets. There’s no question that converting to a fully-automated stock plan administration system is a big step. But like so many other important decisions in life, there are classic tell tale signs that it may be the right time.

At Two Step, we use a list of 10 warning signs to determine whether it's time for someone to stop using spreadsheets for stock plan administration:

  1. You’re starting to feel pressure from those who care about you (maybe the CFO, General Counsel, or your auditors) to get control of your spreadsheets.
  2. You’re no longer proud of your capitalization tables and corporate governance practices.
  3. Handling stock option exercises and vesting schedules is starting to get in the way of other work and even family matters.
  4. You haven’t been honest with your colleagues about how much time you’ve been spending updating the fully-diluted capitalization tables.
  5. You’ve been postponing getting up to speed on FAS 123R and once you even “blacked out” doing a Black-Scholes valuation with a high expected volatility.
  6. You’ve exceeded the 100 stock and option record limit.
  7. You have a dangerous combination of common stock, convertible preferred stock, and stock options.
  8. You’re using more than 3 spreadsheets at the same and you can no longer figure out how to calculate the number vested and exercisable at any point in time.
  9. You’re required to report your capitalization information to third party stakeholders, such as outside investors, lenders, an insurance company and the Board of Directors.
  10. You plan to seek outside financing in the next 12-24 months or your exit strategy includes being acquired by a publicly-held company.

If you answered yes to at least three of those cases, “you have a problem.” It’s not too late to seek help, but it is time to consider moving to a fully-integrated, consolidated, browser-based, stock plan administration system. You’ll not only improve your stock and option tracking, but you’ll be able to automate complex calculations, generate great looking reports that you can be proud of, create fully-diluted capitalization tables in real time, and ease the accounting burden of FAS 123R reporting.

Like so many other major decisions in life, if you postpone for another week, another month, or another year, it will only make the eventual transition even more difficult. As the camera pans around the cheap motel room full of family, friends and co-workers, you hear their voices calling out: “Do it today. You’re a wreck. We’re only looking out for your best interests.”

Gary D. Levine, President and CEO
Two Step Software, Inc.

This blog

by Gary Levine - Gary Levine is the CEO and Founder of Two Step Software which provides market leading solutions for stock plan administration and corporate governance. His perspective is based on 20 years of experience.


More from this blog

Bloggers crew

Steve Knowles has spent 25 years in business and practice in the UK, but he also worked in the states and the years haven't dulled his way of seeing an alternative view to everyone else, and every day is a new adventure.


Joel M. Ungar, CPA is a lifelong resident of the Detroit area and a graduate of The University of Michigan. He is a principal with Silberstein Ungar, PLLC, a Top 15 auditor of SEC public reporting companies.


Allan Boress, CPA, with over 25 years as a practitioner and consultant to the accounting profession. Mr. Boress is the author of 12 published books in 6 different languages, including a best-seller, The "I-Hate-Selling" Book.


Larry Perry, CPA, CPA Firm Support Services, LLC, is the author of accounting and auditing manuals, author and presenter of live staff training seminars, and author of webcast and self-study CPE programs. He blogs about small audits, reviews, and compilations.

Sandra Wiley, COO and Shareholder, is ranked by Accounting Today as one of the 100 Most Influential People in Accounting as a result of her prominent role as an industry expert on HR and training as well as influence as a management and planning consultant. She is also a founding member of The CPA Consultant's Alliance. Sandra is a certified Kolbe™ trainer who advises firms on building balanced teams, managing employee conflict and hiring staff.

Maria Calabrese, CIR, Human Resources manager for Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC in Cranford, New Jersey, Maria's topics revolve around the world of: Mentoring, Performance management, and The "Y Generation," a.k.a. "The whY generation".


William Brighenti is a CPA, Certified QuickBooks ProAdvisor, and Certified [Business] Valuation Analyst, operating an accounting, tax, and QuickBooks consulting firm in Hartford, Connecticut, Accountants CPA Hartford.


Ken Garen, CPA, is the co-founder and President of Universal Business Computing Company (www.ubcc.com), a software development firm of high-volume, high-productivity accounting and payroll technology.


Eva Rosenberg, MBA, EA, is the publisher of TaxMama.com, and author of the weekly syndicated Ask TaxMama column. She provides answers to tax questions from taxpayers and tax professionals worldwide.


Amy Vetter, CPA, CITP is the CPA Programs Leader for Intacct Corporation responsible for leading the CPA/BPO Partners nationally.

Brian Strahle is the owner of LEVERAGE SALT, LLC where he provides state and local tax technical services to accounting firms, law firms and tax research organizations across the United States. He also writes a weekly column in Tax Analysts State tax Notes entitled, "The SALT Effect." For more info, visit his website: www.leveragestateandlocaltax.com
Scott H. Cytron, ABC, is president of Cytron and Company, known for helping companies and organizations improve their bottom line through a hybrid of strategic public relations, communications, marketing programs and top-notch client service. An accredited consultant, Scott works with companies, organizations and individuals in professional services (accounting, finance, medical, legal, engineering), high-tech and B2B/B2C product/service sales.

Rita Keller is a nationally known CPA firm management consultant, speaker, author, mentor and blogger. She has over 30 years hands-on experience in CPA firm management, marketing, technology and administrative operations.

Stacy Kildal is the mom of two fantastic kids, an Advanced Certified QuickBooks ProAdvisor, Certified Enterprise Solutions ProAdvisor, Sleeter Group Certified Consultant, a nationally recognized member of the Intuit Trainer and Writer Network, and co-host of RadioFree QuickBooks.
Michael Alter's blog specializes in providing practical advice to those who seek greater profitability and practice management tactics that enhance deeper client relationships.

Sally Glick, CMO, Principal, Marketer of the Year in 2003 and AAM Hall of Famer in 2007, leads a lively discussion of the constantly expanding roles of marketing and the professional marketers that drive this initiative in accounting firms of all sizes.


The IMA Young Professionals Blog features the insights of IMA’s Young Professionals Committee. Committee members share advice and experiences on careers, continuing education, work/life balance, and other issues affecting young accounting and finance professionals.


FEI Financial Reporting Blog provides highlights from SEC, PCAOB, FASB, IASB, and other regulatory news, including reporting under Sarbanes-Oxley Sect 404. It is written by Edith Orenstein, Director of Technical Policy Analysis at FEI.


Sue Anderson has 30 years of experience in continuing education for accountants. Currently she is the program director for online CPE provider CPE Link.


Jim Fahey is COO of Apple Growth Partners, a regional CPA firm in Ohio. His focus is on the effective and efficient use of technology within the firm by all team members.

Caleb Newquist is the Editor-in-Chief of Sift Media US, overseeing content for both AccountingWEB and Going Concern.

Leita Hart-Fanta, CPA, CGFM, and CGAP is the author of "The Yellow Book Interpreted" and owner of Yellowbook-CPE.com a website devoted to training for governmental auditors.


AccountingWEB is more than just a U.S. team of journalists and financial and technology experts - we have an international side, too! Members of our British team who publish AccountingWEB.co.uk share their ideas, insights, and perspectives from across the pond.