Jane App to QuickBooks Online: the honest guide (and the Jane Payments trap)

Jane runs your clinic floor beautifully. It just does not talk to your accounting system. There is no native QuickBooks Online integration, no Xero sync, and no scheduled export. So every month someone on your team downloads CSV files and moves the numbers over by hand. That is not a knock on Jane. It is a deliberate gap. But it is where clinic books go wrong, and the most expensive mistake hides inside Jane Payments.

This is the honest version: the real QuickBooks workflow, the one thing that quietly misstates your revenue, and the four other places multi-practitioner clinics lose the thread. If you would rather see roughly what the manual close is costing you first, the Clinic Close Scorecard gives you an estimate in about two minutes.

First, the part nobody tells you: Jane does not sync

Jane says it plainly in its own guides. It does not directly integrate with any accounting system, but most financial reports export to a spreadsheet you can then import into QuickBooks or Xero. Two things follow from that.

There is no automation. No API push, no nightly sync, no scheduled report. A person pulls the reports on a weekly or monthly basis, and that manual step cannot be automated away without building around it. And whatever you export is only as good as how you map it. Get the mapping wrong once and you will repeat the same error every month until someone catches it at year end.

So the goal is not really to connect Jane to QuickBooks. It is to set up a clean, repeatable monthly method that ties your Jane numbers to your bank and holds up when your accountant, your lender, or the CRA looks at it.

The four Jane reports that actually matter

Jane produces a lot of reports. For the books, these are the ones you will use.

• The Sales Report lists every invoice in a date range, with payer, treatment versus product, subtotal, tax, total, invoice number and date. This is your source for pushing revenue into QuickBooks.
• The Daily Transactions Report gives collected totals per payment method, per day, and shows Jane Payments processing fees as a negative line. Jane formats this one specifically to import into QuickBooks and Xero, so it is the most accountant-ready export you have.
• The Billing Summary Report is the cleanest view of tax invoiced and collected by tax type, plus sales by location and treatments versus products. You will want it for GST/HST.
• The Jane Payments Payouts Report shows each deposit Jane sends to your bank, net of fees, with the date it was created and the date it landed. That is what you reconcile the bank against. One thing to know: it is capped at about 100 lines, roughly six months, which matters at year end.

Two ways to bring revenue into QuickBooks

Jane gives you a fork, and it is worth choosing on purpose. You can import invoice by invoice, so each Jane invoice becomes its own invoice in QuickBooks. More detail, more rows, more ways to break. Or you can post a summarized journal entry once a month, reflecting the period's revenue, tax, and fees as one set of numbers.

For most multi-practitioner clinics, the monthly summary is the right call. You do not need every patient's invoice cluttering QuickBooks, and you really do not want patient names in there anyway. Keep the health information out of your ledger. What you need is revenue, tax, and fees stated correctly and tied to cash. Ask your accountant which fits, but if you are drowning in rows, the summary is almost always the answer.

Here is the import method, because it is the one people most often attempt and most often get wrong.

Importing Jane sales into QuickBooks, step by step

1. Export the Sales Report to CSV from Jane. Filter by location, practitioner, and date range first. Watch the volume, because QuickBooks caps invoice imports at 1,000 invoices per import. If you are over that, split the date range. Check the report's summary count before you start.
2. Add a Due Date column. Jane has no concept of a due date and QuickBooks wants one. Add a header called Due Date and a formula like =C2+30 (where C2 is the invoice-date cell and +30 is net 30). Fill it down.
3. Add a Tax Code column if you track tax on the line. The values have to match your QuickBooks tax codes exactly as spelled under Taxes, then Manage Sales Tax. For example, "Exempt" for a non-taxable service.
4. Start the import. In QuickBooks, go to Settings (the gear), then Import Data, then Invoices. Browse to your file. Tick the boxes to add new customers and products if they are new to QuickBooks.
5. Map the fields. Customer comes from Payer. Invoice Date comes from Invoice Date in YYYY-MM-DD format. Item Amount comes from subtotal (before tax) or total (after tax) depending on how you track. Set tax inclusive or exclusive and map the tax code.
6. If QuickBooks throws the sales-tax error ("Import invoices isn't quite ready to support sales tax"), the documented workaround is to temporarily turn off automated sales tax under Taxes, then Sales Tax Settings, import, and handle tax separately. It is clunky, which is one more reason the summary method wins for a lot of clinics.

None of this is hard. It is just fiddly, repetitive, and unforgiving of small mistakes, which is exactly why it eats hours and why errors survive undetected for months.

The Jane Payments trap: why your deposit never matches your sales

This is the one that quietly breaks clinic books. Jane Payments runs on Stripe, and it does not deposit each sale. It batches a day's card transactions and sends one payout, net of fees, about two business days later. Monday's card sales arrive Wednesday. Weekend sales batch into Monday and land Wednesday. A holiday pushes it another day.

So a single line on your bank statement, say $2,195.87, is not a sale. It is many patients' payments, minus Jane's processing fees, from a day or two ago. If you record that deposit as income, you double-count: the revenue was already on the books at the invoice, and now the cash arriving for it gets booked as income a second time. Your revenue is overstated, you pay tax on money you did not earn, and if you pay practitioners a share of collections you are calculating comp on inflated numbers.

The fix is a Jane Payments clearing account. Book the sale to revenue and park the card cash in clearing, then clear it out to the bank and a fee expense when the payout lands. In round numbers:

When the sale happens (card money goes into clearing):

Debit   Jane Payments Clearing        1,000.00
Credit  Service Revenue               1,000.00

When the payout lands two business days later (net of the ~2.75% fee):

Debit   Bank (chequing)                 972.50
Debit   Merchant Processing Fees         27.50
Credit  Jane Payments Clearing        1,000.00

Revenue is recorded once, at the sale. The bank ties to the payout. The fee is captured as a deductible expense instead of vanishing into a netted-down revenue figure. The clearing account nets to zero once every payout has landed, and any balance sitting there at month-end is just card money still in transit. There is more to it, including how refunds net against future payouts, in the deeper walkthrough: how to reconcile Jane Payments payouts in QuickBooks or Xero.

The four other places clinics get it wrong

The Jane Payments trap is the big one. These four are close behind.

1. Prepaid packages, memberships, and gift cards booked too early

When a patient prepays for a 10-session package or loads a gift card, that is not revenue yet. It is a liability until the service is delivered. Jane says as much for gift cards: treat the balance as a liability, recognize the revenue on redemption. Book the whole prepayment as income on the day of sale and you inflate that month's revenue and throw off every margin ratio after it.

2. Practitioner splits that live outside the system

Most clinics pay practitioners a percentage, often 60/40 in the practitioner's favour. Jane's Compensation Report handles a single set rate, but it does not withhold splits from your payouts. Only the processing fee comes out. Tiered, hourly, or flat arrangements get calculated outside Jane entirely. If you cannot produce clean profit per practitioner each month, you are guessing at your most important operating number.

3. Insurance A/R timing

A big share of clinic revenue comes from insurers, not patients, and it arrives late, often as one lump deposit covering many patients' claims. If you only book revenue when the cash lands, you understate both revenue and receivables, and short pays and denials slip through. Jane tracks the claim status clinically but never pushes it to your ledger, so this stays a manual job.

4. GST/HST on a mixed-supply clinic

Most regulated health services, like physiotherapy by a registered PT, chiropractic, and RMT massage, are GST/HST-exempt, which also means you generally cannot recover input tax credits on the related costs. But product sales, some admin and no-show fees, and unregulated services are taxable. That makes you a mixed-supply business that has to separate taxable from exempt revenue, register once taxable sales cross $30k, and prorate input tax credits. The common and costly error runs both ways: charging tax on exempt services, or missing recoverable credits on the taxable side. There is a worked example in the GST/HST on a massage clinic's commission split guide.

Doing this in Xero instead?

The shape is the same, with a few Xero quirks. Xero imports CSV only, not xlsx. You download Xero's invoice template and copy your Jane columns into it without renaming the headers, add a Quantity column of 1 and a DueDate via formula, set your AccountCode and TaxType, and the invoices come in as drafts you approve. The Jane Payments clearing-account logic is identical. Xero does not save you from the payout trap.

The manual Jane close is not just the hours, though those are real, usually three to six a month, more if you are multi-location. The bigger problem is that the numbers arrive late and cannot be fully trusted, so you are running a growing business on a rear-view mirror with a crack in it. Getting the mapping right once, then running the same clean method every month, is the difference between a close that takes hours and one that takes weeks.