Category: Technology

10 Essential Prompts for Accountants to Boost Productivity

I’m starting a series to help accounting professionals learn more about how to write prompts. This is the first one – it’s ten prompts to help you with your work. While some of these would be better categorized as tools for administrative tasks (I’m thinking of items 3-7 in this list), they all help professionals get “unstuck” and makes it easier to get more done by automating the first draft of ministerial tasks. I hope you find this helpful, and if you would like more content like this, please sign up for my newsletter using the form at the bottom of this post.

#ScenarioObjective (with Deliverable Type)Full Prompt
1Explaining new tax rules to clientsCommunicate complex tax updates clearly (client email)You are a CPA advising a small business owner. Draft a clear, professional email explaining the implications of the new Section 179 expensing rules, including examples, phaseouts, and recommended year-end equipment purchases.
2Summarizing financial statementsTranslate financial data into client-friendly insights (summary report)You are an accounting advisor. Summarize this client’s income statement and balance sheet (paste data) into plain English, focusing on trends, profitability, liquidity, and key takeaways for non-financial readers.
3Proposal for servicesPresent advisory offerings professionally (proposal document)You are a CPA firm partner preparing a proposal. Draft a detailed proposal for monthly accounting and advisory services for a new client, including scope, deliverables, timelines, and pricing tiers.
4Client onboardingStandardize client intake process (checklist)You are a firm administrator. Develop a step-by-step onboarding checklist for new clients that covers engagement letters, data access, software setup, compliance, and initial financial review.
5Engagement letter draftingEnsure clarity and compliance (engagement letter template)You are a CPA drafting a service engagement letter. Write a professional engagement letter template for bookkeeping and advisory services, referencing AICPA ethical standards and scope limitations.
6Year-end client meeting prepPrepare discussion materials (talking points memo)You are a client relationship manager. Draft talking points for a year-end meeting summarizing performance, tax strategy opportunities, and areas for process improvement.
7Measuring client satisfactionAssess and improve service quality (survey form)You are a firm manager. Create a detailed client satisfaction survey focused on communication, timeliness, accuracy, and overall value of accounting services.
8Executive summariesConvert detailed financials into highlights (executive summary)You are a CPA presenting to management. Summarize the client’s quarterly financial performance into 5 key bullet points with supporting commentary and suggested next steps.
9Missing documents follow-upEncourage client action politely (follow-up email)You are a tax professional following up with a client. Draft a friendly but firm email requesting missing tax documents, including a checklist and submission deadline.
10Discussing cash flow challengesGuide clients through financial stress (meeting script)You are a financial advisor. Write a meeting script for discussing cash flow problems with a small business client, including causes, solutions, and cash management strategies.

Subscribe

The CPA Technology Report is a periodic newsletter which highlights the latest news and trends in accounting and financial technology.  Subscription is free, and we do not share list information with others.
First Name  *
Last Name *
Subscriber Email *
Phone 
Company Name 
Title 
Twitter Handle 
City 
State 
Country 
How did you find us *
*Required Fields
I agree to the Privacy Policy.
Note: It is our responsibility to protect your privacy and we guarantee that your data will be completely confidential.

Updated Podcast Episode Listing (10/25/2025)

Podcast Episode Tracking

Here’s a table which lists the podcast episodes for the last couple of years.  This links to the YouTube page, not to the CPAPA page, which is at cpate.ch/atl.  I hope you enjoy.

# Episode
ATL233 ATL233:
2025 CPAPA Tech Innovation Award Nominees (2/2)
ATL232 ATL232:
2025 CPAPA Tech Innovation Award Nominees (1/2)
ATL231 ATL231:
Mary Delaney, CEO, Karbon (Part 2/2) – AI
ATL230 ATL230:
Mary Delaney, CEO, Karbon (Part 1/2) – Industry, Tech
ATL229 ATL229:
Audit Sight
ATL228 ATL228:
2025 AICPA Blockchain Symposium
ATL227 ATL227:
What is Advisory?
ATL226 ATL226:
Audit Automation Solutions
ATL225 ATL225:
Zoho – SMX and Balance
ATL224 ATL224:
Agentic AI Developments, Summer 2025
ATL223 ATL223:
BlueJ
ATL222 ATL222:
Ricoh 2500
ATL221 ATL221:
AI Regulation Update
ATL220 ATL220:
Small Business Accounting Innovations 1H 2025
ATL219 ATL219:
AI Tax Developments 1H 2025
ATL218 ATL218:
AI Auditing Innovations 1H 2025
ATL217 ATL217:
Talent Shortage
ATL216 ATL216:
Scaling New Heights 2025 – AI Observations
ATL215 ATL215:
Scaling New Heights Show Floor
ATL214 ATL214:
Scaling New Heights 2025 Overview
ATL213 ATL213:
Key OBBBA Tax Changes
ATL212 ATL212:
AICPA ENGAGE 2025 Show Floor
ATL211 ATL211:
Accounting Leaders Think Tank Symposium 2025
ATL210 ATL210:
Microsoft Bookings
ATL209 ATL209:
AICPA ENGAGE 2025
ATL208 ATL208:
Microsoft Forms
ATL207 ATL207:
Power Automate
ATL206 ATL206:
CPAPA Readers Choice Awards
ATL205 ATL205:
Excel 40th Anniversary
ATL204 ATL204:
AICPA/CPA.com Startup Accelerator 2025
ATL203 ATL203:
AICPA/CPA.com AI Symposium
ATL202 ATL202:
Elizabeth Beastrom – TR
ATL201 ATL201:
Microsoft 50th Anniversary
ATL200 ATL200:
Safesend
ATL199 ATL199:
Brian Weiner – Family Office Resource Group
ATL198 ATL198:
Family Office Fundamentals
ATL197 ATL197:
CryptoCurrency Reserve
ATL196 ATL196:
End User Tech 1Q 2025
ATL195 ATL195:
Zoho For Firms: Practice, Payroll, Books, and Invoice
ATL194 ATL194:
Zoho’s Platform for Finance and Operations
ATL193 ATL193:
AI in Practice: Zoho One
ATL192 ATL192:
AI in Practice: Acumatica ERP
ATL191 ATL191:
Payroll Solutions
ATL190 ATL190:
CES 2025: Personal Tech
ATL189 ATL189:
CES 2025: ShowStoppers/Pepcom
ATL188 ATL188:
CES 2025: Award Winners
ATL187 ATL187:
Intuit Enterprise Suite
ATL186 ATL186:
Apxium
ATL185 ATL185:
2025 Predictions
ATL184 ATL184:
Intuit QuickBooks Connect
ATL183 ATL183:
homson Reuters Synergy 2024
ATL182 ATL182:
CCH Connections
ATL181 ATL181:
blue J
ATL180 ATL180:
Hubsync
ATL179 ATL179:
Soraban (PBC Tax Product)
ATL178 ATL178:
Tax GPT
ATL177 ATL177:
Liscio
ATL176 ATL176:
Syft Analytics
ATL175 ATL175:
Time Credit
ATL174 ATL174:
AI Privacy Laws and Regulations
ATL173 ATL173:
Software licensing and privacy
ATL172 ATL172:
2024 Tax & Accounting Awards
ATL171 ATL171:
Supervizor
ATL170 ATL170:
Aider
ATL169 ATL169:
Thomson Reuters Edge CoCounsel
ATL168 ATL168:
Wolters Kluwer T&A AnswerConnect
ATL167 ATL167:
ChatGPT and Copilot Prompting
ATL166 ATL166:
CYMA and CYMA Payroll
ATL165 ATL165:
SuiteFiles
ATL164 ATL164:
Canopy
ATL163 ATL163:
BQE Core
ATL162 ATL162:
Knuula and QuickFee
ATL161 ATL161:
CPA Practice Advisor Mashup
ATL160 ATL160:
Quickbooks Price Increases
ATL159 ATL159:
AICPA ENGAGE 2024
ATL158 ATL158:
Laurel
ATL157 ATL157:
Black Ore Tax Autopilot
ATL156 ATL156:
SayAnchor – Tal
ATL155 ATL155:
Artificial IntelligenceGENCY / LLM’s Passing the CPA Exam
ATL154 ATL154:
MakersHub.ai
ATL153 ATL153:
Digilence
ATL152 ATL152:
Datamatics
ATL151 ATL151:
AssurancePrep
ATL150 ATL150:
Aiwyn
ATL149 ATL149:
Rahul Mahna, Outsourced IT, Eisner Advisory
ATL148 ATL148:
CPAPA TLS 2024
ATL147 ATL147:
SOBusiness Intelligence Analytics
ATL146 ATL146:
FedNow
ATL145 ATL145:
Microsoft 365 Plans and Options
ATL144 ATL144:
StanfordTax
ATL143 ATL143:
QuickBooks Desktop Discontinuance
ATL142 ATL142:
Zoho Analyst Day 2024
ATL141 ATL141:
Oracle NetSuite Influencer Event 2024
ATL140 ATL140:
Acumatica Summit 2024
ATL139 ATL139:
CES 2024: Personal Tech
ATL138 ATL138:
CES 2024: Innovation Awards
ATL137 ATL137:
CES 2024: Best Tech for Accountants

The Office 365 Outlook “Coming Soon” Switch

Change is coming, but you don’t have to rush things.

Microsoft has announced a new interface for the Office 365 applications which is simpler and has fewer icons on the ribbons.  While the current “ribbon” interface has been in place since roughly 2007 (for perspective, Adobe Acrobat has had at least two major UI updates during the same period (Acrobat X in 2010 and Acrobat DC in 2015).  The mouse-click masters at Microsoft have decided that we need a change in how we use Outlook.  Unfortunately, this update is just now being noticed by many practitioners during the time of the year when we need to be the most productive.

OutlookPreviewSwitch

The “Coming Soon” button in Outlook for Office 365 gives you an opportunity to “evaluate”…. er, test, new features in Outlook, and give Microsoft feedback on the new features.  Unfortunately, this switch is getting turned on sometimes by accident, resulting in some confusion, like this e-mail I received yesterday from one of the gentle readers of this blog:

Yesterday when I booted-up my Outlook365 I noticed a significant change in the “look”. My main complaint is the double line-spacing. I can now only see a portion of the emails in my inbox (as well as the other boxes). Even the From/To/Cc/Subject lines are now double spaced. Heck, everything, including the Ribbon, is double-line spaced. When composing a new email Microsoft has inverted the To/From lines. What’s that about? I know I’m sending it out.  This makes working in Outlook365 much less productive.

Fear not, gentle reader.  Nobody moved your cheese.  The old interface is still alive and well – you just have to know how to “re-enable” it.  In the upper right corner of the screen is a on/off switch that is labeled “coming soon” (shown in the picture above).  Flip it to the off position, restart Outlook, and you probably will be back to what it was before.

For my friends who wish to block this tool from being implemented in their organizations, there’s a link at the bottom of this blog post which  allows you to update your group policy templates to allow you to disable this feature for your users.  (If the last sentence you read sounds like gibberish, or Charlie Brown’s parents speaking, then forward it to your friendly neighborhood network administrator, and they will help you take care of this issue).

Have a great year end/tax season/first quarter, and I look forward to seeing many of you in my travels for K2 Enterprises later in 2019.

Blockchain is a Database. Get Over It. Really. (Part Two)

(Editor’s note: I recently penned a column for The CPA Practice Advisor titled,
“Blockchain is a Database. Get Over It.” This article is a followup to that article which addresses some additional issues which I was unable to address in the original article. This article has been adapted from an e-mail I sent in response to a reader’s comment about my lack of enthusiasm for current deployments of blockchain in accounting – because it’s an emerging technology.)

Here are direct quotes from two major media articles from Q1 2018 which I reference in my CPA Practice Advisor article titled, “Blockchain is a Database. Get Over It.”:

“It reflects that (blockchain is) a big bubble,” said Huy Nguyen Trieu, an associate fellow in fintech at the Oxford Said Business School, on the spate of company rebrands.

From Reuters’ Alasdair Pal, “Blockchain Name-Grabbing has Echoes of Dotcom Bubble”, February 8, 2018

And here’s another quote from The Atlantic:

Bitcoin might be where Pets.com was in 2000—a technological curiosity in search of an enduring business need. But blockchain is not where the internet was in 2000. Even blockchain’s biggest defenders can’t say what the technology’s most obvious consumer use-cases are going to be, because they plainly don’t exist yet. It is possible they never will.

(From The Atlantic’s Derek Thomson – “It is Silly Season in the Land of Cryptocurrency”, January 10, 2018 (emphasis added)

The point I’m trying to make is that blockchain is an application platform, and the applications – not the platform itself – are what’s going to change how we work, and they largely don’t exist outside of a few pilot projects as of yet. I feel like much of the current fascination/obsession/cult of blockchain is not much more than misplaced enthusiasm for the get rich quick schemes surrounding the cryptocurrency asset bubble – say 80% of it is this – there are some important parts (20%), but you should be careful. While those apps will be useful eventually, I think you should focus on what will make you money instead of what is shiny.

Let’s take another approach to explaining this- imagine if you and I were transported back in time to our 1970’s selves (sans cigarettes and leisure suits) and someone was talking about how SQL-based databases were going to change the world. I would say sure, SQL is an important technology for software developers, it’s a great technology, and the applications did change the world – but for the end user accountant, auditor, or bookkeeper, SQL in 1975 was a tool which needed to be dealt with once there were applications which used this platform. From an accounting and auditing perspective, IT auditors, internal auditors, and IT specialists who worked with CPA firms were the only people who did much with SQL until the late 90’s.

For the average, non-Big Four firm, there are so many other technologies which need to be higher than blockchain on the priority list – CRM, social media, automation of bank feeds and transaction recording, OCR and AI technologies like those utilized by Receipt Bank and others, data analytics and testing tools like TeamMate Analytics – the list goes on and on. (On that list, blockchain should be just below a Myspace page and just above alpha-testing a self-driving car on the current technology priority list for most users and firms.) While the tools utilizing this platform are evolving, the apps just aren’t there on a widespread production basis at this point. In my opinion, there is much more profit to be earned by dealing with practical, actionable technology which you’re not currently using rather than trying to leapfrog to blockchain unless you have specialized needs and are going to have custom code written, and then, it’s still a crapshoot.

I do think that blockchain will be a bigger deal in the governments of most other industrialized countries before it is in the US due to the comparatively poor state of US government-side technology and the fragmented nature of regulation in the US compared to the rest of the world. In Canada, everyone can file all federal and provincial tax filings with the Canadian Revenue Agency online using the same set of rules and they take all returns. Canada also has a standardized system for classification of accounts which allows financial reports to be filed electronically with the government (GIFI), which is built into Caseware Working Papers (90% market share in Canada). In the US, we have to file with so many different jurisdictions and regulators, with different taxability rules, and many of the states can’t really handle e-filing, so there’s not the incentive for a centralized blockchain like some of the ones proposed for recording VAT in Europe (See https://blog.kpmg.lu/how-blockchain-could-help-fight-or-even-end-vat-fraud/ for more information here). As a result, there’s not the same need

The Indian financial system has had a number of radical reforms after its implementation of a national value added tax (GST) in 2017. The government is trying to eliminate the non-taxed cash economy by (1) eliminating large denomination bills, (2) making their version of ACH payments very inexpensive (but not free), and (3) reducing the supply of paper banknotes in circulation. While some think that blockchain may eliminate banks in India by 2030 (https://yourstory.com/2018/02/blockchain-state-bank-of-india/), my gut says that the political power of banks/financial intermediaries and the state’s compelling interest in controlling money laundering and the cash economy will present massive barriers to its implementation and widespread adoption of cryptocurrencies. Anything that takes political power away from those who have it (and the related money and control of institutions) will be resisted vigorously – and remember that the money laundering penalties in many countries are beyond draconian in most cases – so the penalties for being an early adopter are more like “life in prison” and less like the fines for driving a cab without a medallion.

I hope I’m wrong and blockchain changes our lives sooner rather than later, because it’s a very cool technology and addresses the data integrity issues associated with electronic data very elegantly in a tamper-resistant ledger.

The reality of the 25 years I have been in the profession is that some really smart people said that computers were going to displace all accountants by 2000, then other experts said that outsourcing was going to kill the jobs in profession by 2010, and now we have people saying that blockchain/AI/machine learning is going to kill all accounting by 2020. My response to them is that it’s 2018, and we’re all still here – I don’t think anything will kill accounting totally. While it may change the way we work eventually, consider how much accounting has changed in my 26 years in the profession:

  • Have you seen a 4, 5, 7, or 14-column pad lately? (I saw the first one I’ve seen in about three years being used by a CPA at an industry meeting in New York a couple of weeks ago)
  • When was the last time your hand touched a colored pencil, other than when doing art or helping your kids with their homework?
  • Do you have a 10-key adding machine on your desk? When was the last time you used it? Can you still buy ribbons/ink for the one you have?
  • When was the last time you wrote and mailed a paper letter to anyone other than a government employee or an attorney?
  • When was the last time you sent a fax to anyone other than a government employee who doesn’t have the technology they need at the office? Do you still even have a physical fax machine?
  • Do your new staff know how to use cursive handwriting? (Surprisingly, many do not.)

(By the way, I did all of those things on a daily basis when I started in the profession, and now I do almost none of them in a given day.)

Technology isn’t going to eliminate us unless we let it by trying to stay in the past and ignore how it changes our work. I would argue that the tools we’re going to use in the future and how we work in the future are going to change in the next 25 years at least as much as they changed for me in the last quarter century. We’ll have to have new tools which don’t yet exist to audit blockchains effectively – but those tools will become available in the next couple of years. So learn a little bit about blockchain – I’ll be doing some webinars to explain some of the concepts in the future – but don’t let the fear of missing out (FOMO) drive you to try to force-adopt it before the tools are ready for what you do.

Right now, for most people, blockchain is a bleeding edge technology, and almost all of you should wait until it’s a little farther along before you try to embrace it – but you should learn about it and be ready when the apps arrive.  I hope you’ll join me at the remaining 2018 K2 Technology Conferences to learn about this topic and many more strategic technologies which will affect you in the future.

Some CPE webinars which may help you learn more include:

AICPA will also be releasing a report from the Blockchain Symposium in the near future, and I’ll link it here when it’s available

Dear Brian: Clearing Out Old Vendors, Customers, Items, and Accounts in Desktop QuickBooks

Dear Brian:

My client has been using QuickBooks Pro for well over 10 years.  They upgrade every few years however the file size is getting very large.  They do not want to switch to another program and do not want to switch to QuickBooks Online.

I was under the impression that the newest versions of QuickBooks allows you to purge old data or allows you to reduce the file size.

What should I do?

Sincerely,
Carl in Philadelphia


Dear Carl,

You may want to consider using the Condense Data feature in QuickBooks (File, Utilities, Condense Data from the menu)- it will let you remove the old data as well as the old list items – vendors, customers, accounts, etc. which you haven’t touched in years.

You can download a PDF file with directions on how to do this by filling out the form below:

The World Continues to Evolve. Will You?

I’ve been part of the CPA profession since I graduated from the University of Tennessee and joined one of the “Big Six” accounting firms in 1992.  I started during the waning days of working papers which were made of paper, and had the privilege of carrying a 40 pound Compaq “luggable” transportable PC as my first work computer shortly thereafter – so I’ve been around a while.  During the last 25 years, we’ve transitioned from paper to computer-based documentation, and have also seen the rise of the internet.  The changes we’ve seen – the rise and fall of Yahoo, Amazon’s domination and disruption of everything, and the rise of smart phones – are nothing short of breathtaking.  When viewed in the context of how we worked 40 years ago, it’s important to remember they didn’t change overnight – it took decades for things to shift to the new paradigm.

A two-sided

The late Roy Amara, a respected researcher, scientist, and futurist who led The Institute for the Future during the 1970’s and 1980’s, is credited with creating “Amara’s Law”.  His maxim states, “We tend to overestimate the effect of a technology in the short run and underestimate the effect in the long run.” If you think about the tools we use in our offices every day, almost none of the tools we used forty years ago are used today.  Gone are the paper rolodex cards, typewriters, 10-key adding machines, workpaper binders, 5-column paper, phone books, and colored pencils from the past, replaced by multiple monitors, printers, e-mail, and software like ProSystem fx Engagement.  An accountant from 1978 who visited a cloud-based accounting firm without a physical office wouldn’t recognize what he or she saw.  They would be shocked how simple tasks like payroll have been automated and centralized into computer data centers operated by ADP, Paychex, and Intuit which are accessed using the internet– they would be completely lost in today’s world.

We are all learning about emerging technologies like blockchain, artificial intelligence, machine learning, and process automation.  While most of these technologies are platforms for software developers instead of applications you can use to solve a specific business problem.  As I write this in the spring of 2018, there aren’t many ways I can utilize these technologies today – but I believe that they will impact how we work in the future in ways we can’t imagine.

It’s important to stay current on technology, but that doesn’t mean that you have to know everything about it – or as my friend Gary Boomer often says, “you don’t have to know how the movement mechanism in a wristwatch works in order to tell what time it is.”  The time to change your work processes is when it makes financial and operational sense to do so, not when “the cool kids” say it’s OK.  Keep up with your competitors and don’t get behind on technology– because there are a lot of dinosaurs with dusty offices full of paper who upon retirement will realize smaller gains when selling their practice because they didn’t keep up.

You can subscribe to my newsletter and get articles periodically by clicking here.