Ecommerce Accounting & Bookkeeping with Link My Books

In this guide
The quick answer
How do you manage ecommerce accounting and bookkeeping?
You can manage ecommerce bookkeeping manually by recording sales, refunds, marketplace fees, taxes, and bank deposits, then reconciling them in your accounting system. Or you can use Link My Books to automate much of that work. It connects supported sales channels to Xero or QuickBooks Online, prepares payout summaries, and helps match settlements to bank deposits. You still need to review account mappings and tax settings.
Ecommerce bookkeeping gets complicated when the amount customers spend is different from the money your marketplace transfers to your bank. Fees, refunds, taxes, and adjustments can all sit between those two numbers.
The manual approach can work, particularly for a smaller business. As orders and sales channels increase, though, repeating the same spreadsheet work becomes less appealing. I want to show you an alternative, explain where it helps, and give you a practical way to evaluate it before subscribing.
Affiliate disclosure
I am a Link My Books affiliate. If you subscribe through my link, I may earn a commission at no extra cost to you. It helps support the free tutorials on my channel and blog. Read my full disclosure.
What does Link My Books actually do?
Link My Books is a bridge between your selling platforms and your bookkeeping software. It collects settlement information, separates sales from refunds, fees, and relevant taxes, and prepares summarized accounting entries. Those entries can be sent to Xero or QuickBooks Online and matched against the deposits you receive.
That distinction matters: a $1,000 sales total is not automatically a $1,000 bank deposit. For example, imagine $1,000 in sales, $100 in refunds, and $120 in marketplace fees. Your payout would be $780 before considering any taxes, reserves, or other adjustments. This is an illustrative example, not a live settlement. Proper bookkeeping records the components, not just the $780 that arrives.
1. Sales channel
Amazon, Shopify, or another supported channel supplies the payout data.
2. Link My Books
The software organizes the settlement and applies your configured accounts and tax mappings.
3. Accounting records
Xero or QuickBooks Online receives the entries for review and reconciliation.
It also provides financial analytics and supports configuration for VAT, GST, and sales tax scenarios. Tax calculations still depend on your business location, product categories, marketplace treatment, and settings. They should be checked with a qualified professional.
Which ecommerce platforms connect to Xero or QuickBooks?
Link My Books lists eight sales-channel integrations: Amazon, eBay, Shopify, Etsy, Walmart, TikTok Shop, Square, and WooCommerce. On the accounting side, it supports Xero and QuickBooks Online. Its current official pricing and integration page is the best place to confirm availability for your specific setup.
| Sales channel | What to verify |
|---|---|
| Amazon, eBay, Shopify, Etsy | Connect the correct store, region, and payout source. |
| Walmart | The documented integration covers Walmart US. |
| TikTok Shop | The documented integration covers US and UK shops. |
| Square, WooCommerce | Check your payment gateways and supported transaction types. |
The software does not replace either Xero or QuickBooks. It helps those accounting platforms receive cleaner ecommerce payout information. If you use QuickBooks Desktop rather than QuickBooks Online, check compatibility before signing up.
Free trial and special discount
Try Link My Books and use code VOVA20
14-day free trial
Explore the software, with no payment card required according to the current trial page.
VOVA20 · 50% off
Promoted for the first three months of an eligible new monthly subscription.
Free one-to-one onboarding is available to help with initial setup. Enter VOVA20 during direct monthly-plan checkout, and confirm the actual discount before paying. The promotion cannot normally be combined with an annual-plan discount or another coupon.
Start your free trial and claim the offerOffer availability, billing requirements, and the renewal price should be checked on your account before subscribing.
How to set up Link My Books step by step
The short video introduces the software. Here is the practical process I recommend testing with one real settlement before automating everything.
- Start the trial. Create your account and select your ecommerce sales channel.
- Authorize the connection. Follow the secure prompts for your marketplace or store.
- Connect Xero or QuickBooks Online. Choose the correct company and accounting organization.
- Review accounts and taxes. Check where sales, fees, refunds, and tax amounts will be posted. Ask your accountant if you are unsure about a tax category.
- Inspect an imported settlement. Compare the summary with the original marketplace payout and expected bank deposit.
- Enable the appropriate automation. Once the sample looks right, set up automatic posting and repeat your reconciliation checks.
Link My Books publishes an official connection walkthrough. Complete the guided setup, including the accounts and taxes configuration, in one session where possible.
Two complete Link My Books tutorials: sellers and accountants
I recorded two longer walkthroughs with Daniel Little, co-founder of Link My Books. Choose the one that matches your role. They go further than the introductory video above, including the actual dashboard and setup process.
For ecommerce sellers
Around 30 minutes covering account connections, settlements, the dashboard, billing, and onboarding.
Read the seller tutorialFor accountants and bookkeepers
Around 41 minutes on multi-client workflows, accurate reconciliations, firm productivity, and pricing.
Read the accountant tutorialIf you prefer to browse by topic, I have collected the related reviews, pricing articles, and tutorials in my Link My Books resource hub.
Is automated ecommerce bookkeeping right for you?
If you process only a handful of orders, understand the tax treatment, and reconcile carefully each month, manual bookkeeping may be enough. A spreadsheet can be a reasonable starting point. Just make sure you record gross sales and the deductions separately, rather than treating every deposit as sales revenue.
If you sell across several channels or spend hours matching payout reports, automation becomes more valuable. It can also help an accountant or bookkeeper standardize the way ecommerce clients' transactions reach their accounting systems. The benefit is more consistent data and less repetitive entry, not a promise of error-free books.
The software is not a substitute for your accountant or tax adviser. You still need to review tax settings, unusual transactions, inventory costs, and the final reports. Before choosing a plan, consider the number of monthly orders and connected stores; these are part of Link My Books' pricing structure.
Frequently asked questions
Does Link My Books replace Xero or QuickBooks?
No. Link My Books connects ecommerce sales channels to Xero or QuickBooks Online and helps prepare and post payout entries. You still use the connected accounting software for your records and reconciliation.
Is there a free trial and free onboarding?
The official pricing page advertises a 14-day free trial without a payment card and lists bookable one-to-one onboarding. Confirm appointment availability through Link My Books when you start.
How does the VOVA20 discount work?
VOVA20 is promoted as 50% off for the first three months of an eligible new monthly subscription. Enter it at checkout, verify the applied amount, and check the regular price that follows. Annual billing and other promotions generally cannot be combined with it.
Will the software make my bookkeeping error-free?
It can reduce repetitive entry and improve consistency, but incorrect account mappings, missing costs, or unsuitable tax settings can still create errors. Review the first settlements and reconcile regularly.
Your next step
Test one settlement before automating the rest
You can keep doing your books manually, or you can test a workflow that brings sales, fees, refunds, and taxes into one accounting process. Start with a real payout, book onboarding if needed, and check whether Link My Books saves meaningful time for your business.
VOVA20: 50% off your first three eligible monthly subscription payments, subject to checkout terms.
The important result is not merely an automated dashboard. It is having books you can understand, reconcile, and use to make better business decisions.