Reconcile Shopify Sales With Xero Using AI
Shopify and Xero rarely agree. Three prompts that reconcile the gap, find refund and fee drag by product, and flag overdue customers.
Harvest’s own MCP logs time from Claude and reports what you’re allowed to see. For utilisation, effective rates and unbilled work across the team, Tugger gives Claude the whole dataset.
Harvest has its own MCP server, so there are now two ways to connect Harvest to Claude: Harvest's own connection, which is built for logging time and running simple reports from inside a chat, and Tugger, which syncs your Harvest data into a managed warehouse for reporting across the whole team and alongside your accounts. This guide covers both, and when you'd use each.
Either route lets Claude read your Harvest data. With Tugger, your time entries, projects, clients, invoices, expenses and estimates sync on a schedule into a managed data warehouse, and Claude queries that warehouse through Tugger's read-only MCP server, so it never touches Harvest directly.
Typical questions:
Claude writes the query, runs it and explains the result. You can follow up in the same conversation, ask for a chart, or ask Claude to build a utilisation dashboard and bake the figures in.
Harvest publishes a hosted MCP server that you add to Claude as a custom connector. On an individual Claude plan:
Once it's on, Claude can start and stop timers, log time on a project and task, review time entries for a date range, and run a time report grouped by project, client or person, split into billable and non-billable hours. Admins and managers can log time on behalf of a teammate where their Harvest role allows it.
Harvest's MCP is a good way to work Harvest from a chat window. It's less suited to reporting, for four reasons.
The two aren't exclusive. Keep Harvest's own connection for logging time from Claude, and use Tugger for the questions that need the whole dataset.
Tugger's Harvest connector authenticates with Harvest directly, so there are no API keys to generate.
Tugger runs a first sync and then refreshes on a schedule, daily by default, which you can change in Tugger. You can see sync status and history in the Tugger dashboard. If you have more than one Harvest account, each needs its own connector.
In any new chat, open the connectors menu and switch Tugger on. Claude can now see the tables Tugger has synced from Harvest.
Start with something simple to confirm the connection is working:
"Show me billable and non-billable hours by person for last month."
Claude will find the time entry, user and task tables, run the query and return the result. From there you can ask follow-ups, request a chart, or ask Claude to explain how it built the query.
Tugger brings across time, money and the people and project tables you need to join them.
| Area | Data |
|---|---|
| Time entries | Every entry with user, client, project, task, hours, billable flag, billable rate, cost rate and whether it's been invoiced |
| Projects and tasks | Projects with budgets, billing method and dates; task types; project task and user assignments |
| Clients and contacts | Client organisations and their contacts |
| Invoices and payments | Invoices and line items with state and due dates; payments by gateway; invoice messages and reminders |
| Estimates and retainers | Estimates and line items with state; estimate messages; retainer agreements |
| Expenses | Expenses by project, user and category, billable flag, receipts |
| People and rates | Users with capacity and roles; billable and cost rate history with effective dates |
If you need something that isn't listed, ask us. Tugger's connectors are extended based on customer requests.
| You want to | Use |
|---|---|
| Start a timer or log time from Claude | Harvest's own connection |
| Check your own hours this week | Harvest's own connection |
| Report on utilisation, budgets, effective rates or unbilled work across the team | Tugger |
| Combine Harvest with Xero, QuickBooks or Breathe HR | Tugger |
| Give the finance team read-only access without Harvest admin rights | Tugger |
| Feed the same data to Power BI or Tableau as well as Claude | Tugger |
Tugger is UK-based and ISO 27001:2022 certified. Your warehouse is hosted on Azure, in the UK by default or any Azure region on request, and the same warehouse feeds Power BI and Tableau if you use them. Tugger's MCP server works with Claude, ChatGPT and Gemini.
Connecting Harvest to Claude with Tugger takes no code and no faff. Try Tugger free for 10 days or book a demo and we'll walk through it with your own Harvest data.
Don't just take our word for it.
It’s helped me keep my finger on the pulse of each department without having to be down in the trenches to get that pulse.
Working with the AI agent through Tugger, blending Simpro, Xero and my other systems together, I came up with a really detailed, factual investigation.
Batch invoicing and reporting used to eat hours of admin time each week, chasing details back and forth between Simpro and our spreadsheets. Now it runs on its own, and because Tugger guides the AI to the right figures, I can trust what comes out.
One of our customers wants a monthly evaluation pack built from thousands of Simpro jobs. It used to take a full day. Now our data reaches Claude through Tugger and the pack comes back in ten minutes, exactly how they want it.