Tag Archives: accountant

Vote For The Dancing Accountant In the 2024 Top 100 ProAdvisor Awards!

So very pleased to announce that Nancy been nominated once again for Insightful Accountant’s prestigious “Top 100 ProAdvisors Award”! It’s her fifth time being nominated, and after last year’s win, we’re hoping to make it a two-fer.

One small challenge this year is that due to an administrative snafu, the name “Nancy McClelland” shows as the very last one on the list, rather than in alphabetical order. We have the utmost confidence that you can figure it out anyway — and just scroll to the end to check the box.

If you find this blog of value, please consider voting as a way to show your appreciation and support. It has been quite a labor of love these past 10 years!

QuickBooks ProAdvisors are first nominated, and then go through a lengthy vetting process, before eventually opening up to a public vote. Applicants for this prestigious award are ranked based on their performance across various categories, measuring everything from QuickBooks knowledge and continuing education, to utilizing the best tools and partner apps within the QuickBooks ecosystem. Real-world experience with clients is a requirement. For Nancy, winning last year opened up doors to additional speaking opportunities and interviews, as well as gave her the opportunity to collaborate with other awardees.

Recipients will be formally recognized at the Scaling New Heights Accounting Technology conference, to be held June 16-19, 2024 in Orlando — at which Nancy will be presenting a session called “The Tax-Ready Bookkeeper”! (Registering with this link will get you $50 off your registration, by the way.)

Voting for the Top 100 closes April 2 at midnight, so please do us the honor of popping in there as soon as possible. Awards like these drive traffic to the blog and lead to more speaking engagements; this educational component of our company’s mission is something about which Nancy is extremely passionate, and it feels meaningful and satisfying.

The voting form requests a bunch of info (it’s not a spammy organization), but you can enter N/A for some of the items (except state, zip & country) if you prefer. Although they ask about your title and number of employees in your firm, you do not need to be a business owner to participate in voting. Just complete those fields with “Owner” and “1”. Voting closes April 2, at 11:59 pm Pacific.

Thank you so very much for your support! Please vote!


QuickBooks Ledger: Welcome to the Family! We’re Glad You’re Here.

QB Ledger was announced at QB Connect a few months ago.

If you’re like me, March is that special month from hell where clients that have ignored your pleas for four quarters in a row suddenly show up again… and lucky you. Because now they’ve got a new AirBnb rental property in tow! Or yet another side gig! Or even better: an estate that they have to manage until it settles, and it’s caught up in probate!

To be honest, I’ve been slowly weeding these folks out of our client list – and I feel like a jerk about it – but it just doesn’t make sense for us to spend time during our busiest season getting them caught up on a year’s worth of transactions. Especially because these are the same characters that tend to be super price-conscious, and are somehow convinced that because they have a low volume of transactions, they shouldn’t have to pay for the monthly QuickBooks Online subscription – “can’t you just use our bank statements or a spreadsheet?”

For anyone reading this who isn’t intimately familiar with these classic dance moves already – no, we can’t just use bank statements or a spreadsheet. There’s no double-entry bookkeeping, no debits and credits, no Balance Sheet, and far too many potential lurking mysteries to be uncovered only after all the manual data entry is already complete. At some point we put a stop to these shenanigans… only to find ourselves sitting in QB Desktop, doing all the write-up work on behalf of our clients – a total reconstruction job. More reliable, but not less effort. (And moot at this point, since QB Desktop has gone subscription and is slowly asphyxiating.) And yet – I was a tiny startup at one point, too! I get not wanting to spend big bucks on a full-featured bookkeeping package for an activity that’s not earning much money.

By this point we’ve filtered out most of these types of clients, raising our minimum to price out some of the potential clients we really did (in theory) want to help – itty bitty start-ups or serial entrepreneurs, those that can’t resist a good deal on real estate, or people who sadly lost a loved one and are adrift as to how to handle the demands of bookkeeping for the estate. (I did this for both of my grandmothers back in the day, using my accountant’s copy of QuickBooks Desktop. It was not fun, but boy was my family relieved that they had a knowledgeable QB ProAdvisor handy.) But some remained. Clients who we really like who have been with us for ages, or who have another full-on business that we support, or whose side-gig really serves our community and they deserve a break.

(You read the title, right? I mean… you can see where this is going?)

Enter QuickBooks Ledger.

Those who know me know that I don’t mince words about Intuit as a company. They’ve created a core product that I love, which I’ve been using in some form or another since 1993 (oof, that dates me) – but when they cross me (and they do, more than I’d like), I call ‘em out on it. I don’t like the constant price increases (though I do see the constant improvements), nor the aggressive marketing of corollary products to us and to our clients. I don’t understand why they haven’t fixed some basic functionalities we’ve been asking about for literally years. But the only reason I bother complaining is that I truly believe in QuickBooks products, and the ecosystem they’ve built, and that other software companies have built around them. Which is why it was delightful to be there when QB Ledger was announced at QB Connect in November (see photo above), and all the more delightful that since then, I’ve been able to honestly say I’m in love with this new product.

Why? What’s the hype?

Nothing. There’s no hype. That’s what’s so great about it. It’s just plain old reliable QB Online that we know and love, but without all the bells and whistles, and therefore totally affordable for uncomplicated files. It basically strips down the system to the core functionalities but retains the tools that are the most timesaving. And therefore, they only charge you for the basics. It’s $10/month per client.

At this price, and with the connected bank feeds, rules and reconciliation features, we can blow through an entire year of transactions on a cash-basis filer in literally a couple hours, and still make it affordable for the client, while maintaining plump margin for our firm. Since the bank and credit cards are connected, we don’t have to rely on the client for statements before we get started, so we can take care of most of the work well before tax-season begins. In most cases, the client won’t ever need access to the system, because it’s not about managerial insights and analytics – it’s just a compliance engagement that gets us to the point where we can file an accurate return. But unlike QB Self-Employed, this is real accounting software that gives us double-entry accounting, adjusting journal entries, and spits out proper financial statements. And also unlike QBSE, it allows for a full-on easy upgrade should the side-hustle turn into a more full-fledged business, or the real estate toe-dipper turns full-on house-flipper. (And yes, two accountants can be connected, just like the other QBO products, so if you’re not doing CAS and tax in-house like us, you can have a bookkeeper firm and tax prep firm both connected.)

Things to know before you dive in:
– It seems like QB Support staff haven’t all been trained yet on what it can and can’t do, how many and which types of users can be attached, and which use-cases make the most sense, so be aware of that. It’s also sometimes tricky to get the client added (to set up the bank feeds) because the accountant user gets assigned both as accountant and admin; as with other versions, when this happens it can be a pain to switch that over to the client. So, make sure not to check the box to make yourself primary admin when setting it up.
– And… they’ve got a weirdo situation where you can’t use a Customer name anywhere in the file (presumably they deactivated this because there’s no invoicing, which is fine… but we still need that field). I’ve got it on good authority that this isn’t a bug. I suspect this was done with the expectation that those who have customer reporting needs will just upgrade, but I don’t personally think that it will serve the purpose of moving them to Simple Start. They’ll just use an external invoicing or scheduling program to track income by customer instead of upgrading – especially because those third-party apps do in fact create these customers in the app – and then they’ll be hooked on that invoicing feature… instead of tracking things by customer in QB Ledger and eventually upgrading to Simple Start. I have clients in all walks of QBO and there are startups that can’t initially afford Simple Start who will eventually get there… but they’re going to need customers to make that happen. Another workaround: some folks are using the Vendor field with a “-Cust” after the name to get around this.
– And lastly, bummer – you can’t downgrade, you can only start a new QB Ledger file or upgrade that file. (Yeah, they were thinking about all the reluctant clients who we had to talk into paying for Simple Start that don’t actually need A/R and A/P and would be fine on Ledger… really wishing they’d released this version years ago.)

Hector Garcia just released a half-hour complete tutorial on QB Ledger for accountants and bookkeepers, so if you want a deep dive on the specifics, then you’ve found your instructor.

Start-ups, trusts, estates, once-a-year write-up or tax prep clients, small side-hustles, AirBnB and other rentals, your glam diva marching band (ok, maybe my glam diva marching band)… the list goes on. Intuit has finally taken the core functionalities that are the reason we celebrate QuickBooks Online, and packaged them into an affordable option. It’s earning them goodwill, providing a pipeline for future upgrading customers, and will surely make the switch from Desktop to Online more attractive for the masses. For us, it fits seamlessly into our strategy to shift away from once-a-year rush work. For bookkeepers just getting their start, it allows them to take on small freelance and hustle clients. Welcome to the QB family, Ledger! We’re glad you’re here.

(What’s that, you want to learn more about QB Ledger? I knew you were gonna want to know how – so I’ve conveniently set it up for you to check out this page here.)

Note! As my readers know, I am downright fanatical about transparency and full disclosure (often to my detriment, as you may have noticed that I have a wildly popular award-winning blog that is non-monetized). Though this particular post is a paid partnership with Intuit, I want you to know that a) I wanted to write an article on QB Ledger anyway, but couldn’t find the time; getting paid allowed me the break from client work I needed to make it happen; and b) they didn’t edit a single thing when I presented it. In fact, they were totally cool with all my Intuit-bashing… which made me pretty impressed with them, to be honest. I might just do this again sometime. We’ll see.

The Confluence of Bookkeeping, Tax & Advisory: How to Thrive in the New Accounting Landscape (12/6 @ 3:30 pm ET)

Insightful Accountant is hosting their last Future Forward virtual conference of the year on December 5-6, and I’m delighted to be presenting an exciting topic that resonates with the theme of Niches, Trends, and Predictions for 2024.

I love this particular webinar series, as it’s a fabulous opportunity to connect with peers, get the latest industry updates, and explore best practices, new tech, and other developments in accounting. They do a nice job of speaking both to bookkeepers and tax professionals, as well as tech-related and accounting-adjacent firms. This round will comprise 2 days, 9 speakers, and 11 topics as we share our knowledge, strategies and tactics. If you’re focused on launching, transforming, or growing your business — this is for you. Plus, it’s free if you attend live ($25 fee for the recording, which is totally worth it, as they’re able to subsidize the education without your having to sit through vendor commercial plugs).

My session will be held on Day 2 December 6th at 3:30 pm Eastern, and is called “The Confluence of Bookkeeping, Tax, and Advisory: How to Thrive in the New Accounting Landscape“. It was written with two groups in mind — bookkeepers and tax preparers, both running their own practices — who are getting all sorts of pressure to expand into advisory services. It’s about the trend toward co-firming and other ways to work together in order to serve the clients better, add value/charge more, and develop professional relationships that will bring you more business.

I recently attended QuickBooks Connect, and it got me all riled up (again) about the confluence we’re seeing between CPA firms moving into Client Accounting & Advisory Services (CAAS) and bookkeeping firms moving into advisory services… two previously distinct worlds starting to converge. I feel like the bookkeeping and accounting practices are often dancing technology circles around tax firms — and yet CPAs still look down on them as if they were data entry robots.

It’s time to start communicating with each other!

Bookkeepers –> learn how to “speak tax” with CPAs. Own your spot at the table.

CPAs/EAs –> bookkeepers are your friends! They have the personal relationships and tech know-how that you lack!

Let’s talk about co-firming as one of the accounting trends of 2024.

1. Discover how the scope at CPA and bookkeeping firms is starting to overlap and converge, and why that’s a good thing for you and your clients.

2. Identify the potential challenges and opportunities that this new accounting landscape brings, and how to turn them to your advantage.

3. Apply strategies and techniques to partner across or within firms, to update your accounting practice and stay ahead of the curve.

Join Insightful Accountant and me at Future Forward on December 6th as we talk about what this landscape can look like.

The Confluence of Bookkeeping, Tax, and Advisory: How to Thrive in the New Accounting Landscape – Future Forward December 5-6 2023 by Insightful Accountant (heysummit.com)

But it’s not just me! There’s an amazing lineup of speakers and sessions:

Day 1 – Dec 5

  • Checking in with QuickBooks Checking + Envelopes with Alicia Katz Pollock with Royalwise Solutions, Inc.
  • Strategies For Niching Success with Kellie Parks from Calmwaters Cloud Accounting
  • Niche to an Ideal Client Roster with Debra Kilsheimer from Profit Creator
  • Firm of the Future: Unlocking the Power of the Vertical Niche with Gregg Bossen – Creator/President of QuickBooks® Made Easy™

Day 2 – Dec 6

  • 5 Strategies to Maximize Firm Success Through Onboarding Mastery and Strategic Outsourcing with Vanessa Vasquez from QuickBooks en Espanol
  • Automate Tax Season with AI with Christine Gervais from Epiphany Group
  • Grow Your Practice with Highly Profitable Reporting for Multi-Entity Clients with Charles Nagel from Qvinci and William Murphy from Insightful Accountant
  • The Confluence of Bookkeeping, Tax, and Advisory: How to Thrive in the New Accounting Landscape with Nancy McClelland from the Dancing Accountant

The live event is free, the recordings will be made available for a nominal fee. Just click on this link to sign up.

See you there!


Conference Alert: The Unique CPA “Bridging The Gap”, Aug 29-30, 2023

I’ve been a fan of Randy Crabtree’s Unique CPA podcast for a while, and though we’ve run across each other at accounting technology conferences here and there, I had no idea that he was so committed to our industry as to hold an entire in-person event for us! The upcoming “Bridging The Gap” conference will be held right near Chicago’s O’Hare International Airport, and promises two full days of education and networking (plus an optional pre-conference).

Especially exciting is the lineup of sessions by some of my favorite speakers, including Dawn Brolin, Nayo Carter-Gray, David Leary, Kellie Parks, Blake Oliver, John Garrett, Paul Hamann, and Gaynor Hardy-Meilke. (I’m sure the other presenters are delightful as well, but this tried-and-true list is GOLD, in my opinion.) Check out the agenda here.

Randy’s conference has been virtual the past two years, and this is the first time it’s being held in-person. The focus is on bringing a fresh focus to work-life balance and how it relates to making us better professionals and people. The emphasis on physical and mental health truly makes this a unique conference in the accounting world. I think this was the claim that got me to click the sign-up button:

And even better… you can use code BTG23RTDISC for $150 off the In-Person Conference ticket!

Just to be clear — I’m not being paid to promote this conference… any of our regular readers already knows that I’m passionate about education and community. Realizing that there’s yet one more opportunity to find both at this under-promoted conference motivated me to share — to make sure that my colleagues know not to miss it. Register here and join me August 29-30. Leave a note in the comments if you’ll be there and we’ll try to connect!


If this or any other posts on the website were useful to you, and your financial situation permits it, please consider contributing to my tip jar. Ths allows me to continue to provide free accounting resources to small businesses who do not have the funds available to hire a CPA.

National Society Of Accountants For Co-ops Upcoming Webinars

I often write and speak about my experiences as a co-op accountant, and how challenging it was to become an expert in the field with so few resources. Things have changed a lot since back then, with the National Society of Accountants for Co-ops (NSAC), National Cooperative Business Association (NCBA), and the Co-op Professionals Guild (CPG) all offering online education.

The NSAC line-up for the next few months is seriously powerhouse. For anyone in the field or looking to get into it, I strongly recommend a membership, which gets you into all of these webinars below at no extra charge. That said, if you only want to know the specifics of one topic or another, they are affordably priced at $56 each for non-members.

Note: I am not paid or given a discount to promote NSAC — I just think they’re great!

Behavioral Ethics March 9, 2022 | 11:00 AM EST
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
As we continue to be challenged by an increasingly complex business environment, it is important to develop ethical reasoning skills that allow us to put ethical decision-making into practice. In this session, attendees will discover how to identify ethical paradigms and learn how stakeholders are impacted by their ethical choices. Additionally, participants will explore real-life cases that will allow them to rehearse ethical practices. Be prepared for any ethical dilemma and register now! Click for more info. 
Agricultural Economic Outlook April 5, 2022 | 11:00 AM EST
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
Want to know more about current and expected market conditions affecting agricultural co-ops? This CLN will address the core issues impacting the macroeconomy, agricultural commodity markets, and the agricultural economy with particular focus on the effects of COVID-19 and inflation. Attendees will get an outlook on the agricultural commodity markets; including corn, wheat, soybeans, rice, cotton, hay, cattle, hogs, and dairy, as well as the impact of rising production costs. Gain valuable insight into current market conditions by registering today! Click here for more info.
Financial Ratios for Agricultural Co-ops April 20, 2022 | 11:00 AM EST
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour 
Designed specifically for Agricultural Co-ops, this session will explore how to analyze company performance based on an evaluation of financial statements, and introduce ratios used in the financial analysis of cooperatively structured organizations. Learn what to look for when comparing a company to its peers and industry norms, and how to analyze company performance compared to strategic business objectives. Take advantage of this revealing CLN today! Click here for more info.
Financial Ratios for Electric Co-ops April 20, 2022 | 2:00 PM EST
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
Designed specifically for Electric Co-ops, this session will explore how to analyze company performance based on an evaluation of financial statements, and introduce ratios used in the financial analysis of cooperatively structured organizations. Learn what to look for when comparing a company to its peers and industry norms, and how to analyze company performance compared to strategic business objectives. Don’t miss out on this engaging session! Click here for more info. 
Tax Update April 28, 2022 | 11:00 AM EST 
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
This session will bring attendees the latest and up-to-date tax law changes and new tax return reporting items. Additionally, the CLN will explore any anticipated future tax law changes. Some of the topics that will be covered include: Meals and Entertainment, 163(j) Interest Expense Limitation, Net Operating Losses, R&D Tax Credit Update, and State Taxes Post Wayfair. Stay informed about the latest developments that are most likely to affect your organization with this 60-minute zoom! Click here for more info.
Processing of Work Orders for Electric Co-ops May 5, 2022 | 2:00 PM EST
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
In this CLN, participants will review the accounting process for construction and retirement of utility plant from the work order stage to unitization. This will include the audit perspective of this process, along with industry trends and common mistakes to avoid. Sign up today for this exclusive guidebook to processing work orders! Click here for more info.
Navigating New FASB Guidance: Your 2022 Guide May 12, 2022 | 2:00 PM EST 
FREE NSAC Members | $56 Non-Members 
CPE: 1 Credit Hour
Join us for an informative overview of new FASB standards that could impact your organization. This session will explore recent developments in the financial accounting standards relevant to cooperatives. Guest speakers Randy Throener and Amy Schreck will discuss the latest FASB guidance so attendees can successfully implement these recent amendments. Take advantage of this educational CLN! Click here for more info.
How Electricity and Demand Really Work & How it Impacts Rates May 19, 2022 | 11:00 AM EST
FREE NSAC Members | $56 Non-Members 
CPE:1 Credit Hour
As cooperatives consider moving from traditional to more innovative rate design structures, it is increasingly important to understand the different billing units required for each innovative design. Three-part, Four-part, Time-of-use, Critical peak, Super off-peak, and other innovative rate designs require an understanding of and access to a range of billing units. These include Non-coincident demands, Coincident demands, Time-based energy usage, KVar, and more. In this encore session from TFACC 2021, attendees will learn some of the billing units required for innovative rate designs, and explore some of the challenges involved in obtaining, using, and explaining them to members. Don’t miss out on this specialized presentation! Click here for more info.

What’s The Difference Between A CPA, Bookkeeper, And A CFO?

I have often imagined what my firm might look like in five years and how what I do then might be different than now. And when I watch videos by Hannah Smolinski of Clara CFO, I think: “that’s it! I want to do what she does.”

No, I don’t necessarily want to specialize as a fractional/outsourced CFO (although we already do a lot of this type of work for our clients). What I mean is that I love teaching small business owners how to better manage their companies, and training other bookkeepers and accountants how to better help their clients.

This video was a great example of that — a topic that small business owners need to understand but that few folks take the time to explain. (Although I have one complaint: she should have made it clear that “CFO” is just a title — it’s not a credentialed designation like EA or CPA. As with “tax preparer,” “bookkeeper,” or “accountant,” anyone can call themselves a CFO. So be careful.)

I agree with Hannah that our profession has done a poor job at explaining exactly what it is that we do. My clients mistakenly referred to me as their CPA for years before I actually sat for (and totally killed, mind you) the exams — and I’d have to correct them to make sure they knew I wasn’t qualified to do public accounting (for which the exams certify you). And they were like, “well, once you’re a CPA, how will what you do for us change?” The answer… um… it won’t, not at all. My firm will still do your bookkeeping, accounting, tax preparation, tax planning, financial analysis; and some things Hannah forgot to mention in her video: accounting technology consulting, internal controls/systems design, HR/payroll/benefits, and local/state tax compliance (sales/use, restaurant, soda, liquor taxes). We pride ourselves in straddling the worlds of bookkeeping, accounting, analysis, and tax — providing holistic small business financial consulting.

I think that’s the reason we don’t do a great job of explaining what we do — there’s no requirement to get a certification or degree to perform any of these duties. I did them before I became a CPA, I did them afterwards, I still do them. And a lot of my non-CPA colleagues in Bookkeeping Buds, for example, absolutely dance circles around certified accountants when it comes to accounting technology, clean-up and problem-solving, local/state law compliance, and designing efficient and accurate systems and processes.

And if you’re wondering why I bothered sitting for one of the hardest exams in the world (four parts, over a period of more than a year), it was because my colleagues took me more seriously as a CPA — not my clients. (At conferences, many CPAs and EAs were entirely dismissive of those of us who hadn’t tested their mettle against the exam process.) It was my Master’s Degree in Accounting & Financial Management — not preparing for the CPA exams — that taught me the additional skills I wanted to use with clients: financial analysis, strategy, managerial accounting, cost accounting, etc.

Long story longer: check out the video above. It does a nice job of explaining the breakdown among job titles — and I think the most important takeaway is to make a list of the duties you’d like fulfilled, and then ask around your network of other small business owners until you find a professional who knows which of these they can perform, and has a solid network to find others who can fill in the missing pieces. A good bookkeeper, accountant or CPA doesn’t work in a vacuum — we refer the work that isn’t in our wheelhouse to other talented professionals. For example, it’s prohibited by law for us to perform legal or investment services, but we’ve worked with many lawyers and investment advisors and know where you point you. Hiring any of these roles should be an addition to your team that is greater than the sum of its parts.


If this or any other posts on the website were useful to you, and your financial situation permits it, please consider contributing to my tip jar. Ths allows me to continue to provide free accounting resources to small businesses who do not have the funds available to hire a CPA.