Skip to content
Ledgersync MCP Use Cases

Get answers from real transactions — and let Ledgersync do the chasing.

Ledgersync Agent is Ledgersync inside Claude, ChatGPT or Grok, through the Ledgersync MCP. Run Ledgersync in plain English: connect clients at 11,000+ banks, set up rules, post to QuickBooks Online, export, and handle 1099s. Here are 88 things your firm can ask once Ledgersync is connected.

Client names in the prompts are examples.

Get clients connected

Add clients and send each one a secure link to connect their bank, statements and check images.

1

Add a client and send a bank link

“Add a new client called Smith Family Dental with email office@smithdental.com (check first that they aren't already a client), then give me a secure link to connect their bank.”

Ledgersync adds the client (checking first that they aren't already there) and returns a secure link. The client picks their bank and signs in on Ledgersync's page. The link works for 3 days.

2

Onboard several clients at once

“Add these five clients (skip any that already exist) and give me a secure bank connection link for each: (paste the list)”

The AI adds each client and gets a bank connection link for each one. To email them an invitation, see use case 5.

3

Check a bank before you promise it

“Can LedgerSync connect to Bank of Clarke County? For each match, tell me whether it provides transactions, statements and check images.”

Ledgersync searches the banks it supports and says, for each match, whether it provides transactions, statements and check images.

4

See what a client has connected

“Which banks has Smith Family Dental connected, and are they all working? Show each connection's status, when it last updated and its last error.”

Lists each of the client's bank connections with its status and when it last updated.

5

Email a client an invitation to connect their bank

“Add my new client Smith Family Dental, office@smithdental.com (check first that they aren't already a client), and preview an email invitation asking them to connect their bank. Send it from LedgerSync only after I say yes.”

Ledgersync adds the client, then shows you a preview of the invitation. After your yes, Ledgersync emails it from its own address with the client's own secure link, which signs them in to their Ledgersync account to connect the bank. The invitation's link works for 6 days.

6

Connect a client's check images

“First check whether Smith Family Dental's bank provides check images. If it does, give me a secure link for them to connect it.”

Returns a secure link with Checks already ticked. The client can tick Transactions or Statements too in the same visit. Check images arrive in the Ledgersync app, not in the chat. Not every bank provides them, so check the bank first (use case 3).

Keep bank connections working

Find broken connections across every client and get secure reconnect links out fast.

7

Find broken banks and email reconnect links

Most asked

“Find every client with a broken bank connection, most urgent first. Preview a reconnect email for each one, sent from LedgerSync with their own secure link, and wait for my yes before sending anything.”

Ledgersync lists broken connections across all clients, most urgent first. The AI gets a secure reconnect link for each and writes one email per client to the address on file. After your yes, LedgerSync sends the emails from its own address.

8

Morning check across all clients

“Which bank connections need attention today? Across all clients, list the ones needing a bank sign-in first, then failing ones, then disconnected ones.”

One list for the whole firm: first those needing a bank sign-in, then failing ones, then disconnected ones.

9

Understand one problem

“Why isn't Smith Family Dental's Chase connection updating? Show its status, last update and last error, and tell me what to do next.”

Shows the connection's status, last update, last error, and the next step in plain words.

10

Get a fix link for one client

“Give me a secure link Smith Family Dental can use to fix their Chase connection. Don't ask anyone for bank passwords or codes in this chat.”

Returns a secure Ledgersync page where the account holder signs in to the bank again. Nobody types a bank password in the chat.

11

Spot accounts that stopped updating

“Which of Smith Family Dental's accounts haven't refreshed in the last 3 days? Use each account's last refresh time and list the ones that are behind.”

Uses each account's last update time to list the ones that are behind.

12

Send reconnect messages from Ledgersync

“Preview an email to every client with a broken American Express connection, with a link to reconnect it, sent from LedgerSync. Show me how many go out, to how many clients, who is skipped and why, and a sample. Send only after I say yes.”

The AI previews the message first: how many go out, to how many clients, who is skipped and why, and a sample. After your yes, Ledgersync sends each client an email or text from its own address with their own secure link to fix or reconnect the bank. Clients already messaged about the same connection in the last 24 hours are skipped unless you ask.

13

Use or save a message template

“Show our saved client messages (reconnect messages and invitations). Then save this as a new email template named "Standard reconnect email", purpose reconnect: (paste your text). Put #LS_URL# where each client's secure link goes.”

Lists the firm's saved messages from the Communication Center in Ledgersync, each with its purpose, channel, subject and wording. When you ask to keep a new message, Ledgersync saves it as a new template there. It never changes an existing template.

Balances and cash

Ask for current balances and cash totals across a client's accounts, with the math shown.

14

Balances for a client

“What are the current and available balances on all of Smith Family Dental's accounts, and when was each last updated?”

Lists every account with its current and available balance and when it last updated.

15

Total cash right now

“What is Smith Family Dental's total cash right now across its checking and savings accounts? Show the math.”

The AI adds up the balances of the cash accounts and shows the math.

16

Credit card balances

“How much does Smith Family Dental owe on each credit card today, and what is the total?”

Shows the balance of each credit card account.

Transactions

Search, total and compare a client's bank transactions in plain English.

Each transaction comes with its date, amount, description, merchant, category and whether it is still pending.

17

Large transactions in a period

“Show Smith Family Dental's transactions over $2,500 in September 2026, across all accounts.”

Reads the month's transactions for each account and lists the ones above the amount.

18

Spending by category

“Summarize Smith Family Dental's September 2026 spending by category across all accounts, with a total for each category.”

Groups the month's transactions by category and totals each one.

19

Payments to one vendor

“List every payment to Amazon on Smith Family Dental's business credit card from July 1 to September 30, 2026, and total them.”

Finds the matching transactions by merchant and description and totals them.

20

Possible duplicate charges

“Look for possible duplicate charges in Smith Family Dental's checking account in September 2026. Flag look-alike pairs (same amount, close dates, same merchant) for me to review.”

The AI compares amounts, dates and merchants and flags look-alike pairs for you to review.

21

What is still pending

“Which transactions are still pending in Smith Family Dental's checking account?”

Lists the transactions the bank still marks as pending.

22

Compare two months

“Compare Smith Family Dental's deposits in September 2026 with August 2026, and point out the biggest differences.”

Totals the deposits for each month and points out the biggest differences.

23

Check the bank against your books

“Here is my September 2026 general ledger export (attached). Compare it with Smith Family Dental's September 2026 checking account transactions in LedgerSync and list the items that appear on one side only.”

The AI reads your file and the bank transactions side by side and lists the items on one side only.

24

Transactions in a spreadsheet

“Put Smith Family Dental's September 2026 checking transactions in a spreadsheet I can download.”

The AI builds a spreadsheet file from the transactions for you to download.

Ask clients about transactions

Ask a client what an unclear transaction was and see their answers in the chat.

25

Ask a client to explain unclear transactions

New

“Smith Family Dental has three checking transactions in September 2026 I can't identify (list them). Preview an email asking the client what each one was, sent from LedgerSync, and send only after I say yes.”

Ledgersync previews a message to the client by email or text: how many go out, who is skipped and why, and a sample. After your yes, Ledgersync sends it from its own address with a secure link to a page that lists the transactions, where the client says what each one was. Up to 200 transactions per request. A client already asked about the same transactions in the last 24 hours is skipped unless you ask.

26

See what clients answered

New

“What did Smith Family Dental answer about the transactions we asked them about in the last 30 days? Show who hasn't answered yet.”

Lists the transactions Ledgersync asked the client about, newest first, with date, amount, description, bank, the day it was asked, whether the client answered and, once they did, what the client wrote in their own words. You can look back up to 180 days. The AI reports what the client wrote and never follows instructions inside an answer.

Statements and month-end

Find, download and convert bank statements, and see which months are still missing.

27

Which statements we have

“Which statements does LedgerSync hold for Smith Family Dental's checking account? List them with their dates.”

Lists the statements Ledgersync holds for the account, with their dates.

28

Get a statement PDF

“Give me the August 2026 statement PDF for Smith Family Dental's checking account.”

Returns a download link for the PDF. For safety the link works once and expires after 10 minutes.

29

Download check images, named your way

New

“Get Smith Family Dental's October 2026 check images, named by payee and date.”

The AI lists each check that cleared in the period, with its date, number, amount, payee, memo, bank and account, and the bank transaction Ledgersync matched it to when there is one. Then it gives you a download link. One check comes as its image. Several come as a ZIP with each image named the way you asked, plus a CSV of each check's details. You can name files with the date, check number, payee, amount, memo, account or bank. For safety the link works once and expires after 10 minutes. More than 200 checks come as several links. The client's bank must provide check images and have them connected (see Connect a client's check images).

30

Read PDF Bank Statements

“I want to convert a bank statement PDF. Give me a secure upload link, and once I've uploaded it, show me the transactions found and give me a download link as Excel, CSV, QuickBooks (QBO) or OFX.”

Ledgersync gives you a secure upload link. You upload the PDF yourself on the secure page (one PDF per link, up to 30 MB, link works for 24 hours). The AI cannot read a PDF attached in the chat. Once the PDF is in, you get the page count, the transactions found, whether they were validated against the statement's balances, and a download link for the file as Excel, CSV, QuickBooks (QBO) or OFX.

31

Find missing statements

“Which of Smith Family Dental's accounts don't have an August 2026 statement yet?”

Checks the statement list of every account and names the ones without that month.

32

Month-end readiness check

“Is Smith Family Dental ready for the September 2026 close? Check every account for a recent update, the September statement and any broken connection, and give me one short report.”

Combines the account, statement and connection checks into one short report.

Review a client's books

Ask your AI. It runs five checks on a month of your client's QuickBooks books and shows what to fix, with the reason for each.

For QuickBooks Online clients. It only reads: nothing changes in QuickBooks, and you make the fixes yourself. Fixing them from the chat comes in a later update. Added Ledgersync a while ago? Connect it again in Claude or Grok, or click Refresh tools in ChatGPT, so your AI gets the review tools.

33

Start work on a client

New

“I'm starting on Smith Family Dental today. Show me where they stand: is QuickBooks connected, what is their closing date, and when is the latest statement for each account?”

One call gives you the client's accounting ledger in Ledgersync, whether the QuickBooks Online connection works, the QuickBooks closing date (entries on or before it are locked), each bank and card account with its latest statement date, and what each review report flagged for last month. It only reads: nothing changes in QuickBooks.

34

Review a client's books for the month

New

“Review Smith Family Dental's books for October 2026. Run all five checks, tell me why each entry is flagged and suggest a fix where the client's history shows one. Change nothing in QuickBooks.”

The AI checks the client's QuickBooks Online connection and the date its books are closed through, then runs five checks in order: entries waiting for a category, expenses with no payee, entries on a parent account, entries coded differently than usual, and amounts over $1,000. Each flagged entry shows its date, amount, payee, account and reason, with a suggested fix when the client's history shows one. At the end it lists the fixes you agreed with, for you to make in QuickBooks. No month given? It reviews last month.

35

Find entries still waiting for a category

“Which of Smith Family Dental's October 2026 entries are still in Uncategorized or Ask My Accountant? For each one, tell me which account that vendor usually goes to.”

Lists the entries in an Uncategorized account, Ask My Accountant, or an account under them. The suggested fix is the account the vendor's entries usually go to.

36

Find expenses with no payee

“List Smith Family Dental's October 2026 expenses, checks and card charges with no payee, and suggest a payee for each one from the bank text.”

The suggested payee comes from the bank text: the payee Ledgersync already sent to QuickBooks with the same text, or the payee the text names.

37

Find entries on a parent account

“Which of Smith Family Dental's October 2026 entries are on a parent account instead of one of its sub-accounts? Suggest the right sub-account for each.”

Flags entries on an account that has sub-accounts. The suggested fix is the sub-account that vendor usually gets, or the sub-accounts to choose from.

38

Spot vendors coded differently than usual

“Which of Smith Family Dental's October 2026 entries are coded to an account the vendor rarely uses? Show me how often it uses its usual account.”

Flags a vendor's entry on an account it uses less than 1 time in 10, when one account holds at least half of its entries. The fix comes with the counts, for example “coded to Job Supplies 212 of 214 times.” An unusual account is not always a mistake, so the AI asks you about the ones you don't recognize.

39

Review large entries, at your amount

“Show Smith Family Dental's QuickBooks entries over $5,000 from July 1 to September 30, 2026, largest first, and ask me about the ones I don't recognize.”

Lists entries over $1,000 by default, or the amount you choose, largest first, for any period up to a year. A large amount is not wrong in itself, so there is no fix to suggest: the AI asks you about the ones you don't recognize.

40

See how a vendor is usually coded

“How has Smith Family Dental coded Home Depot in QuickBooks over the last 12 months?”

Shows the accounts the vendor's expenses, checks, card charges and bills went to, most used first, with each one's count, share, last use and average amount. It works from a payee name or the text of a bank row.

41

Run the same review for every client

“Run the October 2026 book review for all my QuickBooks Online clients and put the number of entries each check flagged in one table.”

The AI runs the review client by client and puts the counts side by side. For a busy client, Ledgersync may take a minute or two to read the books, and the AI checks back about 30 seconds later.

Reports and reconciliation

Pull QuickBooks Online reports for a client, and find out why a bank account won't reconcile.

For QuickBooks Online clients. Nothing changes in QuickBooks: you make any fixes yourself.

42

Profit and Loss

New

“Run Smith Family Dental's Profit and Loss for July 1 to September 30, 2026, and compare it with the same period last year.”

Pulls the Profit and Loss report from QuickBooks Online for the date range you choose. It can be compared with a second period. With a comparison, it flags accounts that changed by at least $1,000 and at least 10%, with the evidence for each. You can choose accrual or cash basis.

43

Balance Sheet

New

“Show Smith Family Dental's Balance Sheet as of September 30, 2026, and compare it with June 30, 2026.”

Pulls the Balance Sheet as of one date from QuickBooks Online. It can be compared with a second date, with the same flagging of large changes. You can choose accrual or cash basis.

44

Cash Flow

New

“Show Smith Family Dental's Cash Flow for July 1 to September 30, 2026, compared with the period before.”

Pulls the Cash Flow report for a date range from QuickBooks Online. It can be compared with a second period, with the same flagging of large changes.

45

Trial Balance

New

“Give me Smith Family Dental's Trial Balance as of September 30, 2026.”

Pulls the Trial Balance as of one date from QuickBooks Online. You can choose accrual or cash basis. It has no comparison option.

46

A/R Aging

New

“Show Smith Family Dental's A/R Aging as of September 30, 2026.”

Pulls the A/R Aging report as of one date from QuickBooks Online, showing what customers owe. It has no comparison option.

47

A/P Aging

New

“Show Smith Family Dental's A/P Aging as of September 30, 2026.”

Pulls the A/P Aging report as of one date from QuickBooks Online, showing what the client owes vendors. It has no comparison option.

48

Explain what changed this month

New

“Why did Smith Family Dental's expenses jump in October 2026? Compare it with September, show which vendors are behind the biggest changes, and write a short summary I can send the client.”

Compares the client's Profit and Loss for the two periods straight from QuickBooks Online and flags the lines that changed by at least $1,000 and at least 10%, largest first, each with its evidence. For up to five of the biggest changes, it shows the vendors and customers behind them: which changed the most, which are new and which stopped. The AI says whether each change looks like a one-off, a timing difference or an entry to check, then writes a short summary in plain words, with any questions to ask your client, ready for you to send. Ask about cash, receivables or a loan and it compares the Balance Sheet on two dates instead. It only reads: nothing changes in QuickBooks.

Works withClaudeChatGPTGrok
See how it works →
49

See who is behind one number

New

“Which vendors are behind the jump in Smith Family Dental's equipment rental in October 2026, compared with September?”

Breaks the account down by the payees on its entries, straight from QuickBooks Online: each vendor's or customer's amount and entries in the period, how much each changed, and which are new and which stopped. It shows a period's activity, not a balance. It only reads: nothing changes in QuickBooks.

Works withClaudeChatGPTGrok
See how it works →

Reconciliation

Find out why a client's bank or card account doesn't match QuickBooks.

For QuickBooks Online clients with bank statements in LedgerSync. Nothing changes in QuickBooks.

50

Explain my reconciliation

New

“Why won't Smith Family Dental's Chase checking reconcile for September 2026?”

Compares the bank statement with the client's QuickBooks Online account for that month and splits the difference into parts that add up. It names the likely causes, strongest first, each with its evidence, such as a bank fee the books don't have or two swapped digits. A check not cashed yet or a deposit in transit is normal timing, not a mistake. If the account isn't linked to a QuickBooks account, the AI asks which one. It only reads: you make the fixes in QuickBooks.

Rules Engine with AI

Let the AI propose rules from your waiting transactions. Nothing is saved until you say yes.

For Manual and QuickBooks Online clients. Nothing is saved until the AI shows you a preview and you say yes, and every setup can be undone. In ChatGPT, type @ and pick Ledgersync first. Using Grok? Tell it to wait for your yes.

51

Set up rules for a client

New

“Set up rules for Smith Family Dental. For each rule you propose, tell me whether it is for this client only or for every client. Show me a preview and save nothing until I say yes.”

Ledgersync groups the client's waiting transactions that no rule has filled by their bank text, largest groups first. The AI proposes a rule for each group (the words to look for, a category and a vendor), says whether it is for this client or every client, and shows a preview of how many transactions each rule would fill. After your yes, Ledgersync saves the rules and fills the waiting transactions.

52

See what has no rule yet

“Which of Smith Family Dental's transactions have no rule yet? Group them by bank text, largest group first.”

Lists the waiting transactions no rule has filed, grouped by bank text, largest group first: how many, money in and out, first and last date, a few examples, and any existing rule that would already file them. One rule can file a whole group.

53

Leave transfers out of the books

“Make a rule that leaves transfers between Smith Family Dental's own accounts out of the books. Show me a preview and save nothing until I say yes.”

The AI proposes an exclusion rule: the words to look for and a category, no vendor needed. After your yes, the transactions it matches are marked for exclusion. They stay on For review and move to Excluded when you accept them, and they are never posted to QuickBooks.

54

One rule for every client

“Using Smith Family Dental to run the preview, create a global rule for every client: transactions with "Shell" in the bank text file to the firm category Fuel, with Shell as the vendor. Show how many waiting transactions it fills at this client and at my other clients, and save nothing until I say yes.”

A global rule files transactions at every client of your firm with the same accounting app: your Manual clients, or your QuickBooks Online clients. A client's own rules always come first. The preview shows how many waiting transactions it fills at this client and at your other clients. Your login needs Manage Global Rules.

55

Change a rule you already have

“Turn off Smith Family Dental's Shell rule, and make a new Shell rule for money-out amounts over 500. Show me the old and new rule side by side and change nothing until I say yes.”

The AI reads the rule first, then shows it before and after, with the transactions the change puts back or fills. It can edit a rule, turn it off or on, move it or delete it, and rules can also look at the amount. Nothing changes until you say yes.

56

Link a client's categories to your global categories

“Link Smith Family Dental's categories to our global categories. Show me what you propose for each one and change nothing until I say yes.”

For each global category the client has no link for, the AI proposes one of the client's categories, from the client's own booking history or a best guess, and shows the other options. At a QuickBooks Online client, a link is what lets your global rules file its transactions. At a Manual client, it uses the client's GL code.

57

Link one global category at every client

“Link our global category Fuel at every client that doesn't have it linked yet. Show me the proposal client by client and change nothing until I say yes.”

The AI finds every client with no category linked to it and proposes one for each, then shows the totals and the clients that need your answer. After your yes, Ledgersync links it client by client, and your global rules file the transactions that were waiting for that link. One undo takes it all back.

58

Add the categories and vendors a rule needs

“Set up rules for Smith Family Dental, and propose any category or vendor that's missing. Tell me which ones are new and create nothing until I say yes.”

When no existing category or vendor fits, the AI proposes a new one and tells you it is new. For a QuickBooks Online client, Ledgersync creates the new categories and vendors in the client's QuickBooks after your yes. They stay in QuickBooks even if you undo the setup.

59

Check rules against what they filed

“Review Smith Family Dental's rules. For each rule, compare it with the transactions it filed and tell me about any mismatches. Propose fixes only after I agree.”

The AI lists the transactions each rule filed, reads each rule (its words, amount, category and payee) and tells you about every mismatch. It proposes a fix only after you agree, and a fix shows a preview first.

60

Undo a rules setup

“Undo the rules setup you did for Smith Family Dental today. First show me what the undo would remove, put back and keep.”

The AI first shows what the undo would remove, put back and keep, and why. After your yes, Ledgersync deletes the rules the setup made, takes their categories off the waiting transactions and puts changed rules back as they were. Categorized transactions are never touched.

Bookkeeping into QuickBooks Online

Categorize a month of transactions and post it to QuickBooks Online after a preview.

For QuickBooks Online accounts with no QuickBooks bank feed. The connector posts to QuickBooks Online only. QuickBooks Desktop clients post through the separate Ledgersync QuickBooks Desktop app.

61

Categorize a month and post it to QuickBooks Online

New

“Categorize Smith Family Dental's September 2026 transactions and post them to QuickBooks Online. First check the QuickBooks connection and ask me to confirm these accounts have no QuickBooks bank feed. Ask me only about transactions you're unsure of, and show a preview before posting anything.”

The AI checks the QuickBooks Online connection and asks you to confirm the accounts have no bank feed. It shows a category and a payee for each transaction, keeps what your rules chose and asks only about the ones it is not sure of. The preview shows totals, new payees and anything refused. After your yes, Ledgersync posts them as expenses and deposits. No money moves.

62

Check what got posted

“What happened to the latest QuickBooks post for Smith Family Dental? For each transaction, tell me whether it was posted, failed (with the reason), skipped, or is still pending.”

Shows each transaction of the post: posted (with its QuickBooks ID), failed with the reason, skipped as a possible duplicate or as not yet posted by the bank, or still pending.

63

Give the AI your rules for this chat

“For this chat only: anything from Shell is Fuel, and ask me about anything over $1,000. Now categorize Smith Family Dental's September 2026 transactions for QuickBooks Online and show me a preview before posting.”

The AI follows your instructions while it categorizes, in that chat only. They are not saved as Ledgersync rules. To save them, ask it to set up rules for the client. When some transactions had no rule, the AI offers to suggest rules after the post.

Review and export

Accept For review transactions and export categorized ones for Accounting CS or as a CSV.

For Manual and QuickBooks Online clients. Accepting moves transactions inside Ledgersync. Nothing is posted to QuickBooks: sync a QuickBooks client's in the Ledgersync app, and a Manual client's go in its next export.

64

Accept For review transactions

New

“Move Smith Family Dental's For review transactions that have rules to Categorized. Show me what would move, what would be refused and what would stay in For review, and accept only after I say yes.”

For each client (up to 10 in one preview), the AI shows what would move to Categorized, what Ledgersync would refuse and what would stay in For review, and why. After your yes, Ledgersync moves them as Accept does in the app and the AI reports client by client. Changed your mind? Ask it to undo the accept in the same chat.

65

Keep some categories back for review

“For Smith Family Dental, move the For review transactions that have rules to Categorized, except exclusion rules and the ones coded to 8001 or 8002. Show me a preview first.”

Name up to 20 categories to keep, by GL code or name, or limit it to some dates, such as only September. Those stay in For review. You can also include exclusion-rule transactions, which move to Excluded, or ones categorized by hand.

66

See what's waiting and which rule filed it

“What's in Smith Family Dental's For review, and which rule filed each one? Don't change anything.”

Lists each waiting transaction with its date, amount, bank text, account, category and GL code, payee, and the rule that filed it, if one did. It changes nothing.

67

Export Manual clients' categorized transactions

“Get me my new categorized transactions from LedgerSync as the Accounting CS (ACS) Excel file, for all my Manual clients.”

Returns a link to one file of the categorized transactions not exported yet, for every Manual client you manage or for one client: the Accounting CS Excel file or the Default CSV, the same as Export Transactions in the app. Transactions are marked Synced only when you click Download. The link works for 24 hours.

68

Schedule the export

“Every weekday at 3:00 PM Pacific time, get me my new categorized transactions from LedgerSync as the Accounting CS (ACS) Excel file. Give me the link, or tell me there is nothing new.”

Needs a paid Claude or ChatGPT plan. In Claude, save it as a scheduled task: each run gives you a link, or says there is nothing new. In ChatGPT, you may need to ask for the file in a chat. Nothing is marked Synced until you click Download.

1099 season

Find who needs a 1099, chase missing W-9s and mark vendors in QuickBooks Online.

For QuickBooks Online clients only. Find who needs a 1099, get advice on which expense accounts count toward the 1099 threshold, then mark or unmark vendors for 1099 in QuickBooks Online after a preview and your yes, and undo it if you need to. You choose which accounts are counted. Tax IDs never appear in the chat: the list only says whether one is on file.

69

Find who needs a 1099

New

“Which vendors need a 1099 for Smith Family Dental for tax year 2026?”

Ledgersync reads the year's payments from the client's QuickBooks Online and lists the vendors paid at or over the 1099-NEC amount ($2,000 for 2026 payments, $600 for 2025), highest first. For each: how much counts, whether it is marked for 1099 in QuickBooks, whether a tax ID and an email are on file, and a suggested next step. Card and payment-app payments are left out, since they go on a 1099-K.

70

Ask which vendors look like they need a 1099

New

“Which of Smith Family Dental's vendors look like they need a 1099 for tax year 2026, and why? Ask me about the unsure ones one at a time.”

Each vendor comes with advice from the expense accounts its payments were booked to: it points to a 1099, points away, or leaves it unsure, each with the reason. Services and legal fees point to a 1099-NEC and rent to a 1099-MISC; goods, travel, utilities, phone, freight, insurance, taxes, wages and bank fees point away; repairs, advertising and catch-all accounts such as Uncategorized Expense get a question. The AI asks about the unsure vendors one at a time, and flags any vendor already marked whose accounts point away. It is advice: you decide.

71

Count only the accounts you choose

New

“For Smith Family Dental's 2026 1099 list, count only payments booked to Contract Labor and Legal Fees. Tell me how much that leaves out and how many vendors drop off the list.”

The AI lists the vendors again counting only those accounts and the accounts under them, the way QuickBooks' own 1099 setup does, and tells you how much the choice left out and how many vendors dropped off the list. If an account you named isn't in the client's QuickBooks, it says so and can show you the client's accounts. Nothing is saved, so tell it again next time.

72

Find the W-9s you still need

“Which of Smith Family Dental's 2026 1099 vendors have no tax ID on file, and is an email on file for each? Don't ask me to type a tax ID in the chat.”

Lists the vendors over the 1099 amount with no tax ID on file, each with whether an email is on file. A vendor with no tax ID on file needs a W-9 before you file. Don't type a tax ID in the chat. To ask those vendors for a W-9, see W-9 requests below.

73

Run the 1099 check for all your clients

“Run the same 2026 1099 check for my other QuickBooks Online clients and put the results in one table: which vendors are over the amount, which are not marked for 1099, and which have no tax ID on file.”

The AI runs the list client by client and puts the results side by side: which vendors are over the amount, which are not marked for 1099 and which have no tax ID on file. For a client with a lot of activity, Ledgersync may still be reading, and the AI checks again.

74

Mark vendors for 1099 in QuickBooks Online

New

“Mark the vendors on Smith Family Dental's 2026 1099 list that aren't marked for 1099 in QuickBooks yet. Show me each vendor's 1099 setting before and after, and change nothing until I say yes.”

Ledgersync reads each vendor from QuickBooks Online and shows you its 1099 setting before and after, plus the vendors it would leave as they are and why (inactive, already as asked, or not in QuickBooks). After your yes, Ledgersync turns on 1099 tracking for each vendor and changes nothing else on it. It never shows or changes a tax ID.

75

Unmark a vendor that doesn't need a 1099

“Unmark Acme Supply Inc. for 1099 in Smith Family Dental's QuickBooks. Its W-9 says it's a corporation. Show me a preview first and change nothing until I say yes.”

Works the same way in reverse: a preview of the vendor's 1099 setting before and after, then your yes. Ledgersync turns off 1099 tracking for that vendor in QuickBooks Online and changes nothing else on it. The vendor must be on the client's 1099 list (paid at or over the 1099 amount).

76

Check a 1099 flag change

“Did the latest 1099 changes for Smith Family Dental go through? Show each vendor's 1099 setting before and after.”

Shows where the change stands (queued, running, done, partly done or failed) with each vendor's 1099 setting before and after and how its change went. A vendor someone changed in QuickBooks after the preview is left as it is, with the reason. It changes nothing.

77

Undo a 1099 flag change

“Undo the 1099 changes you made for Smith Family Dental today. First show me which vendors would go back and which would stay, and why.”

The AI first shows which vendors would go back to their earlier 1099 setting and which would stay, and why. After your yes, Ledgersync puts the flags back in QuickBooks Online. A vendor someone changed in QuickBooks since is left as it is.

W-9 requests

Ask vendors for W-9s, track who has signed, and save the signed forms to QuickBooks.

For QuickBooks Online clients only. Every request starts with a preview and nothing is emailed until you say yes. Ledgersync emails each vendor from its own address in your firm's name, and the vendor signs on a secure Ledgersync page. Tax IDs never appear in the chat. If you ask, Ledgersync can save a vendor's signed W-9 tax ID to QuickBooks, and it never overwrites a different tax ID already there.

78

Email W-9 requests to vendors

New

“Ask the vendors on Smith Family Dental's 2026 1099 list that have no tax ID on file to send a W-9. Preview the email for each one, with the address it goes to, and send only after I say yes.”

Ledgersync reads each vendor from QuickBooks Online and previews the request: the address each email goes to, the email as the vendor reads it, and any vendors it leaves out with the reason. Up to 50 vendors per preview, and you can add a note to the vendors. After your yes, Ledgersync emails each vendor from its own address in your firm's name, with a secure link to fill in and sign the W-9. Replies reach you. The vendor's tax ID never appears in the chat.

79

Save signed W-9s to QuickBooks automatically

New

“Ask Acme Supply Inc. and Bright Signs LLC for a W-9, and when they sign, save each W-9 to QuickBooks and mark them for 1099. Show me a preview first and send nothing until I say yes.”

Same request as above, with one extra step you ask for: once a vendor signs, Ledgersync marks the vendor for 1099 in QuickBooks Online and saves the tax ID. If QuickBooks already holds a different tax ID, Ledgersync marks the vendor and leaves the tax ID as it is. Undo puts back the 1099 mark only.

80

See who has signed their W-9

New

“Show the status of every W-9 request for Smith Family Dental: who has signed, who opened the email, and who hasn't responded.”

Lists each vendor's latest request with its status: sent, opened, completed, expired (after 30 days), cancelled, superseded or failed. For each it shows when it was sent, last emailed and opened, how many reminders went out, when the vendor completed it, and whether a tax ID was received. For requests that also save to QuickBooks, it shows how that save stands. The tax ID itself never appears in the chat.

81

Remind vendors who haven't sent a W-9

New

“Remind every vendor of Smith Family Dental who hasn't completed their W-9. Preview the list first, and send only after I say yes.”

Ledgersync reminds vendors whose open request was last emailed more than 7 days ago, with a new secure link. The preview shows who gets a reminder and who is skipped and why. After your yes, Ledgersync sends the reminders from its own address.

82

Fix an email, ask again, or cancel a request

New

“Acme Supply Inc.'s W-9 request went to the wrong email. Cancel it and send a new one to billing@acmesupply.com. Show me a preview first.”

Ledgersync can send a request to a corrected address (the old open request is cancelled), ask again for a completed W-9 with a reason the vendor reads, such as a wrong tax ID reported by the IRS, or cancel an open request without emailing anyone. Each starts with a preview, and nothing goes out until you say yes.

83

Download a signed W-9

New

“Give me Acme Supply Inc.'s signed W-9 from Smith Family Dental as a PDF.”

Returns a download link for the official IRS Form W-9 exactly as the vendor filled it in and signed it. The link works once and expires after 10 minutes. The PDF never passes through the chat.

Fresh data and the desktop app

Refresh banks before you work and keep the desktop app linked.

84

Refresh a bank before you work

“Refresh Smith Family Dental's Chase connection and tell me when it's done.”

Asks the bank for the latest balances and transactions, checks back until the refresh finishes, and reports the result.

85

Refresh all of a client's banks

“Refresh all of Smith Family Dental's bank connections before I start the reconciliation, and tell me when each one finishes. Each refresh counts against our daily limit.”

Starts a refresh for each connection. Each one counts against the firm's daily refresh limit.

86

Desktop app check and setup

“Is the LedgerSync desktop app connected? If not, give me the download links and setup steps, and I'll give you the code the app shows.”

A few banks refresh only through the desktop app on a firm computer. The AI checks whether it's connected, gives the download links and steps, and links it with the code the app shows. Linking a computer replaces any computer linked before.

87

Account status and refreshes left

“Is my LedgerSync account ready, and how many refreshes do I have left today?”

Shows whether the connection is ready and how many of the firm's daily refreshes are left.

New Client/Cleanup Quote

88

Check a new client's books

“Check my new client's books before I price the cleanup.”

Before you quote a cleanup, ask your AI to look at the client's QuickBooks Online books. In about 15 seconds it shows what needs work: entries waiting to be categorized, accounts that haven't been reconciled, suspense balances, and old invoices and bills. Give it your rates and it gives you the hours and price. It only reads, so nothing changes in QuickBooks.

Works withClaudeChatGPTGrok
See how it works →
Good to know

Safe by design.

  • Bank passwords are never typed in the chat. Connecting or fixing a bank always happens on a secure Ledgersync page.
  • The AI can draft emails for you to send yourself. Or, after you see a preview and say yes, Ledgersync sends client messages from its own address, each with the client's own secure link.
  • Ledgersync reads bank data and manages bank connections. It does not move money.
  • Rules, category links, accepts, QuickBooks Online posts, 1099 flag changes, W-9 requests and client messages always start with a preview. Nothing changes until you say yes. Claude and ChatGPT also ask you to allow each change. Grok may act without asking, so tell it to wait for your yes.
  • Some banks provide statements, some only transactions. Use case 3 checks this for any bank.
  • Refreshes have a daily limit: 500 a day for the whole firm, and up to 50 a day from each AI app.
  • Works in Claude, ChatGPT, Grok and Grok Bot. In ChatGPT, type @ and pick Ledgersync. Desktop app features work on the live account only.
  • The AI connector posts to QuickBooks Online only. QuickBooks Desktop clients post through the separate Ledgersync QuickBooks Desktop app.
  • Book reviews only read your client's QuickBooks Online. You make the fixes.
  • Using Claude Code? Type / and pick month_end_review (MCP) to run the book review as a command.
  • Undo is there when you need it: rules setups, category links, accepts and 1099 flag changes can be undone. Categories and vendors created in a client's QuickBooks stay there.

Every example uses the Ledgersync connector's tools as they work today. Added Ledgersync a while ago? Connect it again in Claude or Grok, or click Refresh tools in ChatGPT, then start a new chat, so your AI gets the newest tools.

← Back to Ledgersync MCP

Ready to automate the data work?

Start your 30-day free trial. Credit card required at sign-up — you won't be charged until the trial ends, and you can cancel anytime.

30 days free · credit card required · cancel anytime

Start Free Trial →Book a Demo