By Rakibul Hasan, Moonlab
To automate QuickBooks or Xero, connect your bank feed first, then invoicing, then receipts and bills, then your CRM and payment tools. That order gives you clean data before you add anything that creates more of it.
This guide lists what to connect, why in that order, and which checks to keep so automation does not quietly put wrong numbers in your books. It applies to both QuickBooks Online and Xero, which are common in the US, UK and Europe. Features and plans change, so check each vendor's own site for what your plan includes. Nothing here is accounting advice, so ask your accountant before changing how you record things.
Start with clean foundations
Automation copies your mess faster. Before you connect anything, spend an hour on the basics: a tidy chart of accounts, customers and suppliers without duplicates, and a clear rule for who is responsible for the books each week.
Ask your accountant which categories and tax settings you should not change. Then write a one page list of what you want automated, so you can tick items off in order.
1. Bank feeds and rules
Connect your business bank and card accounts so transactions flow in each day. This is built into both products. Then create bank rules for repeat items such as software subscriptions and rent, so they are coded automatically.
Keep a weekly check: someone looks at what the rules coded and fixes mistakes. Rules that are too broad are a common source of wrong categories. Both tools suggest matches, and you stay in control of what is accepted.
2. Invoices from jobs, orders or quotes
The next win is creating invoices without retyping. Connect the place where jobs or sales are recorded, such as a booking tool, a shop or a spreadsheet, so an invoice draft appears when a job is done.
Start with drafts that a person reviews and sends. Move to automatic sending only when you trust the data. Our guide at moonlab.space/guides/invoice-automation-small-business covers money in and out in more detail.
3. Receipts and supplier bills
Receipts and bills are where most small business admin time goes. Use a receipt capture option, either the one in your accounting tool or a connected app, and a shared inbox for supplier bills.
Add checks for duplicates and unusual amounts. See moonlab.space/guides/accounts-payable-automation for the full approval flow.
4. Your CRM and quotes
When a deal is marked won in your CRM, a customer can be created in QuickBooks or Xero with the right contact details, and a draft invoice can follow. This keeps names, emails and addresses the same in both places.
- Match customers by email or an ID, not by name alone, to avoid duplicates.
- Decide which system owns contact details and let changes flow one way.
- Test with a handful of records before switching it on for everyone.
5. Payments and reconciliation
Connect your payment processors, such as Stripe, PayPal, GoCardless or Square, so payments and fees arrive in the books as they happen. Add a pay now link to invoices if your tool supports it.
Reconcile payouts, not just sales. Processors pay out net of fees and on a delay, so the bank deposit rarely equals the sales total. A good connection records fees as expenses and matches the payout.
6. Reports and reminders
Once data is clean, set up a weekly summary of cash, overdue invoices and bills due. See moonlab.space/guides/automated-business-reports for how to build it, and moonlab.space/guides/late-invoice-reminders for the reminder schedule.
Add an alert when a connection breaks. Bank feeds and app connections do expire, and a silent failure can leave weeks of gaps.
A worked example and common mistakes
Here is a made-up example. A cleaning company with six staff uses QuickBooks Online and wants to cut bookkeeping time. The owner follows the order in this guide instead of connecting everything at once.
In week one the bookkeeper connects the business bank and card feeds and writes rules for the monthly software subscriptions, fuel and insurance. She checks the coded transactions each Friday. In week two they connect the booking tool, so when a job is marked complete a draft invoice appears in QuickBooks with the right customer and price. She reviews the drafts for two weeks and then lets the invoices send themselves for regular customers only.
In week four they connect Stripe, so card payments and fees are recorded as they happen, and the payout is matched to the bank deposit. Then they add a Monday message listing overdue invoices and bills due. Each connection has an alert that tells the owner if it stops working.
At the end of each month the bookkeeper reviews a short list of exceptions with the accountant. This keeps the books clean, and avoids the mistakes below.
- Connecting everything at once and not knowing which step broke something.
- Broad bank rules that mis-code unrelated items.
- Creating duplicate customers because matching used names, not emails.
- Ignoring payment processor fees.
- No alert when a connection expires.
- Sending invoices automatically before the data has been checked.
- Changing the chart of accounts without telling the accountant.
How to decide and what to do this week
Use these criteria to decide whether a connection is ready to switch on, and keep the list short so you actually follow it.
- Do you trust the source data, for example clean customer names and prices?
- Can you see what the connection did, in a log or in the books?
- Will you be told if it stops working?
- Is a person reviewing drafts before anything is sent to a customer?
- Has your accountant agreed how it should be recorded?
- Can you switch it off in one step if something goes wrong?
How Moonlab can help
We connect QuickBooks and Xero to your CRM, shop, forms and payment tools inside your own accounts, with checks and alerts. See moonlab.space/services/finance-and-hr.
A free 30-minute automation audit at moonlab.space/contact will tell you which of these connections is worth doing first.
