Best TikTok Shop Payment Reconciliation Software | Link My Books
In this guide
The quick answer
What is the best TikTok Shop payment reconciliation software?
Link My Books is a strong option for TikTok Shop sellers who use Xero or QuickBooks Online. It converts TikTok Shop settlement data into organized accounting entries covering sales, refunds, fees and taxes, helping you match recorded payouts to bank deposits. Its TikTok Shop connection currently supports US and UK shops. You still need to review mappings, exceptions and tax treatment.
A busy TikTok Shop can produce dozens or hundreds of orders while the amount reaching your bank account looks surprisingly different from your sales dashboard. That gap is not necessarily a missing payment. It can be a mixture of refunds, seller fees, shipping adjustments, taxes and payout timing.
The problem begins when you record the deposit as if it were your total sales revenue. Your bookkeeping loses the detail needed to explain what you earned and what the platform deducted.
In my video, I recommend Link My Books as a way to connect TikTok Shop to your accounting software without rebuilding every settlement in a spreadsheet. This guide explains the workflow, its limitations, how to set it up and how to test whether it fits your business.
Affiliate disclosure
Some links in this article are affiliate links. If you subscribe through them, I may earn a commission at no additional cost to you. This supports the free tutorials I have been sharing since 2018. Read the full disclosure.
Why TikTok Shop payouts are difficult to reconcile manually
A payout is the money TikTok Shop transfers after applying the transactions and adjustments relevant to that settlement. It is not the same as gross orders, taxable sales or net profit. A single deposit can contain activity from different days, including a refund for an order placed in an earlier period.
Imagine this simplified settlement. The figures are illustrative, not data from a real shop, and exclude any separately handled tax amounts.
| Settlement component | Example amount |
|---|---|
| Gross sales | $2,400 |
| Customer refunds | -$160 |
| Platform and fulfillment fees | -$215 |
| Other adjustments | -$25 |
| Net payout to reconcile | $2,000 |
If you enter only the $2,000 deposit as sales, you hide $400 worth of refunds, fees and adjustments. You also make comparisons between your TikTok Shop reports and accounting records more difficult. A proper settlement breakdown preserves those categories while accounting for the actual deposit.
Sales
What shoppers purchased before the relevant deductions.
Payout
The amount transferred to the bank for a settlement.
Profit
What remains after all relevant business costs, not only platform fees.
How Link My Books connects TikTok Shop to Xero or QuickBooks
Link My Books sits between your sales channel and your accounting platform. After authorization, it imports settlement information, groups transaction types, applies your approved account and tax mappings, and prepares summarized entries for Xero or QuickBooks Online.
Instead of manually entering each order, your accounting file receives structured settlement data. When the corresponding deposit appears in your bank feed, you can review the suggested match and reconcile it. You can also enable automatic posting once you have checked that the initial entries are correct.
01 · Import TikTok Shop settlements
Bring payout details into one accounting workflow.
02 · Categorize transactions
Organize sales, refunds, fees and tax lines.
03 · Match the deposit
Review the corresponding bank transaction.
That is the appeal of ecommerce accounting on autopilot: repetitive entry can be automated while financial review stays in your hands. It is worth remembering that an automated entry can still be wrong if the source data or account mappings are wrong.
The official connection guide covers the authorization process for supported sales channels and bookkeeping systems.
Link My Books offer
Try Link My Books and check code VOVA20
14-day free trial
Link My Books advertises a no-card trial with access to test the workflow.
VOVA20
My advertised offer is 50% off the first three months of an eligible monthly plan.
Check whether the code applies in your account before subscribing. Free one-to-one onboarding is not available to every order-volume tier under the provider's current policy; details appear below.
Get the trial and check my discountHow to set up TikTok Shop payment reconciliation
Before beginning, confirm that you have a TikTok Shop UK or US account, access to Xero or QuickBooks Online, and permission to authorize both connections. The current TikTok setup guide explicitly limits TikTok integrations to the UK and US; it does not list TikTok Shop EU countries as supported.
- Start your account. Register through the trial and choose whether you are an ecommerce seller or an accounting professional.
- Select TikTok Shop. Name the store, choose its supported country, and authorize Link My Books in TikTok's connection screens.
- Connect your bookkeeping platform. Sign in to Xero or QuickBooks Online, review the permissions, and complete authorization.
- Complete the setup wizard. Check your chart of accounts and tax configuration, including how sales, refunds and fees are classified. Finish the wizard in one session, as the current help guide recommends.
- Inspect your first settlements. Compare the imported information with TikTok Shop's finance statements. Link My Books says initial TikTok data may take up to 48 hours to import.
- Reconcile and then automate. Send a test entry, check the resulting deposit match and only enable ongoing auto-posting once the mapping is approved.
Already keeping books manually? Agree on a clear start date before importing or posting historical settlements. Otherwise, a payout recorded by hand could be posted again through the integration.
How are fees, refunds, VAT and sales tax handled?
TikTok Shop transactions are not all the same accounting category. Link My Books organizes different settlement items into groups, including sales, refunds, shipping, fulfillment fees, seller fees, reserved balances and sales tax. This gives you more useful reporting than one undifferentiated deposit.
For a UK VAT-registered seller, accurate account and tax-rate mapping matters, especially if products have different VAT treatments. For a US seller, the records need to distinguish sales tax that TikTok collects or remits from amounts the business is responsible for. Link My Books also offers GST support across its broader ecommerce integrations, although that does not imply TikTok Shop Australia is currently supported.
The official TikTok Shop mapping reference shows how transaction categories feed the chart of accounts. It is a useful checklist to review with your accountant.
Software can automate a mapping you approve; it cannot determine every tax obligation for your business. Verify registrations, product classifications, marketplace-facilitator arrangements and reporting periods with a qualified adviser. Also keep supplier costs and other expenses in your accounts if you want a meaningful profit figure.
Can Link My Books reconcile other ecommerce channels?
Yes. My video mentions Link My Books as a multi-channel accounting connector, not a TikTok-only app. Its current integrations include Amazon, Shopify, eBay, Etsy, Walmart, WooCommerce and Square in addition to TikTok Shop. This can be helpful when you want consistent bookkeeping across several places where customers buy your products.
| Sales channel | Useful accounting outcome |
|---|---|
| TikTok Shop | Reconcile UK or US shop settlements. |
| Amazon, eBay and Etsy | Organize marketplace payouts and deductions. |
| Shopify, WooCommerce and Square | Bring supported store and payment data into your books. |
| Walmart | Connect supported US Walmart settlements. |
Do not assume identical country support or pricing for every channel. Check the official pricing and integration details, especially if you manage several stores.
Link My Books for sellers, accountants and bookkeepers
For a seller, the benefit is spending less time preparing settlement entries and more time understanding sales and margins. I would still review payout exceptions regularly, particularly after promotions, returns or changes in TikTok Shop fees.
For accountants and bookkeepers, repeatable categorization can reduce the amount of client-specific spreadsheet cleanup. It may help a practice handle more ecommerce clients, but each client's tax mapping and records still need professional review. Link My Books is a tool for that process, not a replacement for accounting judgment.
I recorded two longer walkthroughs with Daniel Little, co-founder of Link My Books. Choose the one that matches your role.
30-minute tutorial for ecommerce sellers
Learn the main setup and settlement workflow. You can also follow my written Link My Books tutorial.
41-minute tutorial for accountants and bookkeepers
Explore client-focused workflows, then read my accountant and bookkeeper FAQ.
Free trial, onboarding and VOVA20: what should you check?
Link My Books currently advertises a 14-day free trial without requiring a payment card. Its pricing guidance says trial users can access 90 days of historical settlement data. That is enough to test a few real deposits and see whether the resulting entries make sense before committing to a subscription.
My advertised code VOVA20 has been presented as 50% off the first three months of an eligible monthly subscription. It is a limited promotional period, not a permanent price reduction. Check the discount field, billing cadence, taxes and renewal amount in your own account; an older video cannot establish that every current plan qualifies.
Important onboarding update: Although my original video describes free one-to-one onboarding, the provider's newer onboarding policy says calls are free at 5,000 or more orders per month and cost £49 plus VAT for smaller accounts. Ask support whether your affiliate signup has different eligibility before booking.
Pricing depends on your order volume and connected sales channels, so avoid choosing a plan solely because the initial discount looks attractive. Your best test is a real settlement that can be traced all the way from TikTok Shop to your bank feed.
Try the reconciliation workflow
Link My Books free trial and discount code
Free trial
Test your actual TikTok Shop payouts before deciding.
50% for 3 months
Advertised code VOVA20, subject to eligibility and checkout confirmation.
The trial, discounts and onboarding terms are subject to the terms shown by Link My Books at signup.
A practical reconciliation check before you rely on automation
For the first few payouts, I would compare the TikTok Shop settlement statement, Link My Books summary, accounting entry and bank deposit side by side. Make sure the dates, currency, refunds, fee categories and actual paid amount tell the same story.
- Check that the correct shop and bank account are connected.
- Review tax and fee mappings with the person responsible for the books.
- Check outstanding or reserved balances instead of forcing a mismatch to zero.
- Confirm that historical settlements have not already been posted manually.
- Investigate failed settlements before enabling unattended posting.
A TikTok-specific discrepancy can originate in the payout data supplied by TikTok rather than your connection. Link My Books documents settlement statuses and discrepancy handling, including the option to request a diagnostic for TikTok support. A mismatch deserves investigation, not an assumption that every transaction will always reconcile perfectly.
Frequently asked questions
Does Link My Books work with TikTok Shop and QuickBooks Online?
Yes. Link My Books supports connections between eligible TikTok Shop UK or US accounts and QuickBooks Online. It also connects to Xero. Confirm the specific region and company file before you subscribe.
Will Link My Books automatically match every payout?
It prepares accounting entries designed to match deposits, but exceptions can occur. Missing data, incorrect mappings, delayed payouts and platform discrepancies can require manual investigation or support.
Does it calculate TikTok Shop profit?
It helps organize revenue and fees and offers wider financial reporting features. True profit also requires product costs, advertising, labor and other expenses to be complete. A matched deposit alone is not a profit calculation.
How long is the free trial, and what does VOVA20 provide?
The standard trial is advertised as 14 days. VOVA20 has been promoted as 50% off an eligible monthly subscription for the first three months. Confirm current availability and the post-discount renewal amount at checkout.
Can accountants and bookkeepers use Link My Books for clients?
Yes. It is designed for ecommerce sellers and accounting professionals. Client connections, consistent mappings and summarized settlements can reduce repetitive work, although every client still needs appropriate oversight.
The best TikTok Shop reconciliation setup is the one you can explain, verify and repeat. Link My Books can remove much of the mechanical bookkeeping between TikTok Shop and Xero or QuickBooks, but the real benefit comes from pairing automation with reliable financial checks. Try it on a real payout, review the numbers with your accountant, and keep your records clear as your shop grows.