1 / 15

Knowing When to Leave QuickBooks

Knowing When to Leave QuickBooks. Presented by Lee Bengston, CPA. Objective. Help nonprofit decision-makers recognize that their organization is outgrowing QuickBooks, why, and know what to do about it. Agenda:. Introductions – Why are you here? Software and organizational growth

poppy
Download Presentation

Knowing When to Leave QuickBooks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Knowing When to Leave QuickBooks Presented by Lee Bengston, CPA

  2. Objective Help nonprofit decision-makers recognize that their organization is outgrowing QuickBooks, why, and know what to do about it.

  3. Agenda: • Introductions – Why are you here? • Software and organizational growth • Reviewing where QBs is a good fit and getting the most out of it • Some leading indicators that QB is no longer up for the job • Accounting requirements that are challenging to QB • Alternative solutions when leaving QB • Developing a transition plan • Additional links and resources

  4. When is QuickBooks a Good Solution for Nonprofits? • Basic financial management best practices in place • Management values financial information and understands risks. • There is a qualified accounting person on-staff or available. • Accounting member is part of the management team. • There is a qualified Board member or other resource to provide oversight of the accounting function. • An early- to mid-growth organization • Annual operating budget not too much over $2m ?? • A single main organizational entity • No more than a 2 or 3 main funding sources • Most funding is program generated or from unrestricted contributions

  5. Best Practices for QB’s Use in Nonprofit Organizations • The basic account structure and use • GL account – the what? (assets, liabilities, net assets, revenue, expenditures) • Class – the purpose or why? (programs, fund raising, administration, restrictions) • Programs • Fundraising • Administration • Form 990 categories • FASB 117 restrictions • Board designations • Job – available to track projects, grants, contracts, special events, etc.

  6. Best Practices for QB’s Use in Nonprofit Organizations (cont) • Use numbered accounts and class codes. • Sub-accounts and sub-classes not more than two levels • Prompt to assign classes. • Code transactions at lowest account and class levels. • Periodically review coding structures, use tools to revise and reorganize. • Setup customer and job types for report filtering. • Memorize key recurring reports and assign to report sets. • Export report sets to consistently named Excel workbooks. • Reconcile donor software reports to pledges receivable and cash • Use Accountant’s or Enterprise edition and Intuit Statement Writer

  7. Some leading indicators that QB is no longer up for the job • 3 or more concurrent users • Fairly frequent workstation slowdowns and freeze-ups • Multiple grants with different fiscal reporting periods and rules • Direct or indirect federal funding over $500k (OMB Circular A133 audit) • Manual interfaces with other systems • Distribution of labor and other costs to grants and programs burdensome • Need for indirect cost allocation • Budget inflexibility • Financial analysis all off-line • Over-use of Excel for subsidiary records

  8. Some leading indicators that QB is no longer up for the job (cont) • Excel reporting more time-consuming and error-prone • Audit preparation and coordination are a big extra workload • Restricted funds growth • True fund accounting required or advisable • Need to track revenue/expenditures and budgets to multiple objects (departments, locations, projects, etc.) • Chart of accounts bastardized beyond repair • Internal control and security issues • Audit trail issues • More and more workarounds • Pressure from outside auditors and funders

  9. Accounting requirements that challenge QuickBooks • Tracking beyond GL/Class/Job • Direct cost allocation (splits) • Indirect cost allocation capability • Grant budgeting and tracking for cross-FY reporting • User access security limited • Multiple budgets and forecasts • Budget control • GAAP for nonprofit (FASB 117) and gov’t (GASB 34) not supported • Internal control • Audit trail • Reporting scope and flexibility

  10. Alternative accounting solutions when leaving QuickBooks • Commercial ERP systems • Sage ERP 100, MS Dynamics GP • NetSuite or Intacct • Others • Specialized nonprofit or governmental system • Abila Fund Accounting 100 (formerly Sage MIP) • Financial Edge (Blackbaud) • AccuFund, Fund E-Z, Cougar Mountain • In-house or hosted (the ‘cloud’) • Client-server or web-based • Perpetual license or subscribed (SaaS)

  11. Developing a transition plan • Get realistic; adjust attitude on price; usually dealing with organizational transition • Be prepared to justify the investment to Board and get it in the budget: • Staff time spent on extra work outside the system that could be saved and re-deployed • Compliance with GAAP and following best practices • Opportunity cost of missed revenue opportunities • Audit and internal control issues • Risk of fraud or misallocation of assets • Frame in an organizational growth context • Value of better strategic decisions based on accurate, relevant and timely information

  12. Developing a transition plan (cont) • Evaluate needs – what are the 3-4 main issues to solve • Consider hiring an independent consultant • Appoint lead internal person for project • Frame acceptable alternative • In-house • Hosted • Web-based • Client-server • Find potential providers (Web, peers, published reviews) • Hold preliminary conversations with vendor or VARs • Attend overview demos • Get preliminary pricing

  13. Developing a transition plan (cont) • Ask for references of similar organizations • Narrow the field to one or two potential solution sources • Share time and information with providers • Prepare a needs analysis • Have software demonstrated to address main issues • Select provider • Finalize agreement • Develop implementation plan

  14. Additional links and resources landing page http://www.nfppartners.com/quickbooks-and-sage-fund-accounting-downloads-and-links/

More Related