Disclaimer: The inclusion of products or services in this article does not constitute an endorsement by The Woodard Report, Woodard Events, LLC, or affiliated companies. Readers should evaluate each solution and carefully consider any associated financial, operational, security, compliance, or data privacy risks before use.
Most accounting firms are already using AI, but they're using it in a separate window, with Claude or ChatGPT in one tab and QuickBooks (QBO) in another, copying and pasting between them. A Model Context Protocol (MCP) server (a standardized way for AI applications to connect to external tools and data) closes that gap. It gives the agent a direct connection to the books, so it can pull the numbers and write entries back.
I’ll walk through how to set it up and give you three examples of what you can do with it.
We built a free hosted connector for this (no email required), so there is nothing to install or developer accounts to create.
Now that you’re connected, let's verify that it works.
Pull up a P&L for a client whose books you’ve already closed, so you know what the numbers should be. Then add this prompt into the AI tool you just connected:
Run a P&L for [client] for [month].
If the totals match what you already know, the connection is pointed at the right company and you're ready to go. Your AI agent can now do anything in QuickBooks that you could have done via the API.
Some of the most interesting use cases we’ve come across:
Every firm has a client who just won’t connect their bank feed. They send you a PDF every month and someone has to type 50 or 60 lines and code every one of them against the last few months of history.
Skip the manual work by attaching the statement to your chat and use this prompt:
Import the transactions from the attached statement into [client] as credit card charges on [account]. Match vendors to existing vendor records where you can. Categorize each transaction based on how similar ones were coded in the last three months. Show me the full list with your proposed categories, and flag anything you're unsure about before creating anything.
You'll get back a table with every transaction, the vendor it matched, the category it picked, and a flag on the ones it wasn't confident about. Fix what needs fixing, then tell it to post to QBO. The transactions will post to QuickBooks with their GL accounts already applied.
Most firms have a custom client-facing report format with their branding, section order, and account groupings. The numbers don’t take as long, but getting them into the template for each client every month takes someone hours of time.
Attach the template file, then use this prompt:
Use the attached template to build a P&L for [client] for [month]. Keep the layout, section order, and account groupings exactly as shown in the template. Return it as a PDF.
What you’ll get is the report in your firm’s custom format with the numbers already populated in it. Be sure to check the account mapping the first few times to make sure the layout is consistent with your prior reports.
(Warning: this can be very slow, but it’s magical when it works.)
Because you can connect to more than one QuickBooks company at once, you can easily work across files in a given request. For example:
In [Company A], draft a journal entry dated [date] for [dollar amount] to Due From [Company B]. Then draft the mirrored entry in [Company B] to Due To [Company A]. Show me both before creating either one.
You'll see both entries before either one exists in QBO, and once it looks right, tell it to post, and both sides will land in their respective QuickBooks companies.
These three use cases are just the beginning of what you can do with this. The QuickBooks Connector itself is free to use (no email required), just connect your QBO instance to get started: QuickBooks Connector by Meridian
Sponsored Content: This article is generously brought to you by one of our valued sponsors. Their support enables us to continue delivering expert insights and the latest industry trends to our dedicated community of accounting professionals.