AI and MCP

Bulk importing a small business's transactions with an AI assistant

A small business owner's guide to bulk importing a backlog of statements across current account, card and wallet, with AI help and totals checks per account.

Editorial illustration for Bulk importing a small business's transactions with an AI assistant

Many small business owners reach the same moment: the quarter is over, three accounts have unrecorded months, and the accountant is asking for figures. Here is a way to clear the backlog without retyping, using an AI assistant for the fiddly bits and the tracker's file import for the loading.

List your accounts before anything else

Write down every place money moved: the current account, the business card, and any wallet or payment app balance you use for suppliers. Each is a separate account in the tracker, and SpendixAI wants you to pick the account before importing, so each transaction keeps its own. Mixed-up accounts are the most common reason a reconciliation later refuses to tie.

Worked example: one month, three accounts

Say one month's statements have 186 rows on the current account, 64 on the card and 22 on the wallet. That is 186 + 64 + 22 = 272 rows. Pro allows 2,000 transactions a month, so volume is no concern. Before importing, note the row count for each file.

AccountRows in fileRows after importMatch?
Current account186186Tick when equal
Business card6464Tick when equal
Wallet2222Tick when equal
All three272272Tick when equal

How the assistant helps

  • Turning a wallet's screenshot-and-notes history into a tidy sheet when no proper statement exists.
  • Pointing out rows that look like the same payment recorded in two accounts, such as a card payment and the later settlement on the current account.
  • Suggesting names for categories that fit a trading business, for you to accept or change.

What order should I do things in?

  1. Import one account at a time and check the row count each time.
  2. Clear the possible-duplicate flags.
  3. Fix the largest uncategorised rows first, because they move the totals most.
  4. Add rules for recurring suppliers and bills, so the next quarter loads itself in order.
  5. Add cash expenses by hand, several at a time, with their receipts attached to the transactions.
  6. Only then export for your accountant, in the template they use.

The export centre has templates for Tally, Zoho Books and QuickBooks, plus a standard all-transactions file and a categories-and-tax-codes file. Ask your accountant which they want.

Can the assistant add the rows directly?

Claude or ChatGPT can be connected through MCP, with a scope you choose, an option to start read-only and a way to disconnect. Whether it can add rows depends on the scope you grant. For a quarter's backlog, we would use the file import with its review screen, and keep the assistant for questions and tidying.

Quarter-end tidy before the accountant calls

Say the quarter's three months loaded as 272, 291 and 268 rows. That is 272 + 291 + 268 = 831 rows in all. Ask your accountant whether they want the whole quarter in one file or month by month, and what they want done about cash sales and owner withdrawals. Agree it before you export, because a re-export for a different layout is wasted time.

  • Note the three row counts and the quarter's total.
  • Keep a copy of every source file in one folder, named by account and month.
  • Write down any category you changed after the import, so you can explain it.

Before you hand it over

  • Row counts match for every account.
  • Uncategorised rows are cleared or explained.
  • GST figures from reports are treated as estimates, to be checked against invoices and with your CA.
  • You know where each source file is stored.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports