Field Notes | Studio Eucalipto

NO MARKET. NO ENTRY? Smiling Leafy compares a crossed-out checkout cart under Markets with a ShieldLeaf shield at a storefront doorway, showing that selling eligibility and visitor access need separate controls.

Shopify Markets vs Country Blocking: Different Jobs

Shopify Markets manages selling and localization. See how ShieldLeaf adds a separate country rule for visitors you want to block or redirect.

Read field note

THE BLOCK WORKS. CAN CUSTOMERS STILL SHOP? Smiling Leafy checks a white rounded card with separate Blocked and Allowed routes, a stopped globe, an open storefront, and a ShieldLeaf shield.

Traffic & Country Access

How to Test Shopify Country Blocking Before Going Live

Test ShieldLeaf's blocked page or redirect privately, then check blocked and allowed connections before expanding your Shopify country rules.

Read field note

Blocked. What happens next? Smiling Leafy points to a white rounded message card reading Access unavailable and Need help?, with a crossed-out globe, envelope, ShieldLeaf shield, and map stickers.

Traffic & Country Access

What Should a Country-Blocked Visitor See?

Give country-blocked Shopify visitors a clear explanation, support route, or useful redirect. Build and preview the experience with ShieldLeaf.

Read field note

Conversion halved. Did sales? A white rounded panel compares 3% with 1.5% while orders stay at 30; smiling Leafy points between a LedgerLeaf receipt and a ShieldLeaf map and shield.

Traffic & Country Access

Why Did My Shopify Conversion Rate Suddenly Drop?

Diagnose a sudden Shopify conversion-rate drop with LedgerLeaf sales records, then address unwanted country traffic with a tested ShieldLeaf rule.

Read field note

10× the visits. Where are the shoppers? Sessions rise from 500 to 5,000 while orders stay at 15; smiling Leafy investigates a map beside a ShieldLeaf shield.

Traffic & Country Access

Diagnosing a Sudden Shopify Traffic Spike

Find what caused a sudden Shopify traffic spike, isolate the country driving it, and turn unwanted regional visits into a tested ShieldLeaf rule.

Read field note

More visits. No real orders. Is it fraud? Smiling Leafy compares a bot-session spike, a $0 receipt, and a card marked with a question beside ShieldLeaf branding.

Traffic & Country Access

Bot Sessions, Fake Orders, and Fraud: How to Tell Them Apart

Separate Shopify bot sessions, fake orders, and payment risk, then use ShieldLeaf to act on recurring unwanted country traffic.

Read field note

1 COUNTRY. 0 ORDERS. KEEP LETTING IT IN? Leafy blocks a dotted route from a purple map pin beside a sessions-up, orders-zero card to a Shopify storefront.

Traffic & Country Access

How to Reduce Unwanted Regional Traffic to a Shopify Store

Diagnose unwanted regional Shopify traffic, cut avoidable visits, and use ShieldLeaf to keep selected countries outside your storefront.

Read field note

BLOCKED COUNTRY. WHY DID THE CLICK STILL COUNT? Leafy stands behind a ShieldLeaf barrier that stops a dotted visitor path after an ad click and first analytics signal but before a Shopify storefront journey.

Traffic & Country Access

How Country Blocking Interacts With Ads, Pixels, and Shopify Analytics

Learn how country blocking stops unwanted traffic from generating deeper pixel events, polluting ad audiences, and distorting Shopify analytics.

Read field note

BLOCK A COUNTRY. BLOCK YOUR RANKINGS? Leafy holds a ShieldLeaf shield and magnifying glass between a stopped country route and a search-result path that continues to a storefront.

Traffic & Country Access

Does Geo-Blocking Affect Shopify SEO?

Learn when country blocking can affect Shopify crawling and regional visibility—and how to keep a ShieldLeaf rule narrow, useful, and testable.

Read field note

WRONG STOREFRONT. WHERE SHOULD THEY GO? Leafy holds a direction sign as a dashed route sends an international visitor from the wrong storefront toward a suitable regional store under a ShieldLeaf shield.

Traffic & Country Access

How to Redirect International Visitors on Shopify

Redirect Shopify visitors by country: use Markets for localized selling, and ShieldLeaf when selected countries need a useful route away from this storefront.

Read field note

YOU DON'T SHIP THERE. SHOULD THEY STILL GET IN? Leafy weighs a stopped parcel route against an open storefront protected by a ShieldLeaf shield, showing that not shipping and blocking access are separate decisions.

Traffic & Country Access

Should You Block Countries You Do Not Ship To?

Decide when Shopify Markets is enough—and when an unserved country should get a clear ShieldLeaf block or redirect at your storefront.

Read field note

YOUR BOOKKEEPING SHEET HAS SALES. CAN IT CLOSE THE MONTH? Leafy reviews five labeled workbook tabs for control, LedgerLeaf sales, payouts, monthly summary, and evidence.

Templates & Checklists

Shopify Bookkeeping Spreadsheet Template: A Five-Tab Workbook

Build a five-tab Shopify bookkeeping spreadsheet, then use LedgerLeaf to refresh its sales, payout, tax, and inventory evidence each month.

Read field note

YOUR PAYOUT MATCHED. CAN YOUR SPREADSHEET PROVE WHY? Leafy compares a LedgerLeaf payout source tab with a bank-match row showing a zero difference and a green Matched status.

Templates & Checklists

Shopify Payout Reconciliation Spreadsheet Template

Build a Shopify payout reconciliation spreadsheet that matches every deposit, then use LedgerLeaf Pro to keep the source evidence repeatable.

Read field note

DAILY, WEEKLY, OR MONTHLY? YOU’RE ASKING THE WRONG QUESTION. Leafy points from payout, exception, and full-close cards to one repeatable reconciliation calendar.

Bookkeeping & Reports

How Often Should You Reconcile a Shopify Store?

Use a practical Shopify reconciliation schedule: match payouts as they arrive, review exceptions weekly, and complete a full LedgerLeaf close monthly.

Read field note

AUTOMATE THE REPEATABLE. WHO CHECKS THE EXCEPTION? Leafy guides Shopify report files through a LedgerLeaf workflow toward a human review checklist.

Bookkeeping & Reports

Manual vs Automated Shopify Bookkeeping

Compare manual and automated Shopify bookkeeping, then use LedgerLeaf to repeat the data work while keeping judgment and exceptions under review.

Read field note

Bookkeeping & Reports

How to Build a Custom Shopify Sales Spreadsheet

Build a useful Shopify sales spreadsheet, then save its source columns as a repeatable LedgerLeaf export profile instead of rebuilding it monthly.

Read field note

CSV DROPS FORMULAS, TABS & FORMATTING. WHICH FILE SHOULD YOU SEND? Leafy compares a simple CSV table with a polished spreadsheet workbook.

Bookkeeping & Reports

CSV vs Excel for Shopify Reports

Choose CSV or Excel for each Shopify report, avoid common format traps, and export the same saved LedgerLeaf profile in either file type.

Read field note

YOUR SELL-THROUGH REPORT CAN BE TWO DAYS BEHIND. WOULD YOU REORDER FROM IT? Leafy uses a magnifying glass beside a two-day calendar, inventory boxes, and a sell-through report on a green LedgerLeaf background.

Inventory & SKUs

Shopify Inventory Reports: Which One Should You Use?

Choose the right Shopify inventory report for stockouts, movement, value, or discrepancies—and keep the stock behind it aligned with LedgerLeaf.

Read field note

SHOPIFY ONLY SHOWS 180 DAYS OF INVENTORY HISTORY. WHAT HAPPENS ON DAY 181? Leafy examines a torn calendar while a trail of inventory boxes fades beyond it, illustrating Shopify's 180-day product and variant adjustment-history window.

Inventory & SKUs

Shopify Inventory Adjustments Explained: Set To, Adjust By, and Reasons

Choose the right Shopify inventory adjustment, read its history, and use LedgerLeaf rules to keep linked stock aligned after the change.

Read field note

TWO ON-HAND COLUMNS. WHICH ONE SAFELY UPDATES SHOPIFY? Leafy points to a count spreadsheet where On hand (current) 48 has a lock, On hand (new) 46 has a pencil, and a LedgerLeaf stock-pool rule connects two SKU tags.

Templates & Checklists

Shopify Inventory Count Spreadsheet for Shared Stock

Build a Shopify inventory count spreadsheet that catches stale numbers, then use LedgerLeaf SKU rules and snapshots to keep shared stock honest.

Read field note

SHOPIFY SAYS 31. YOUR SHELF SAYS 27. WHICH NUMBER DO YOU FIX? Leafy compares a 31-unit Shopify on-hand card with 27 physical mug boxes, then points to a checked LedgerLeaf SKU rule keeping linked listings aligned.

Inventory & SKUs

How to Reconcile Physical Stock With Shopify Inventory

Reconcile a physical count with Shopify by location and SKU, then use LedgerLeaf rules to keep linked products and bundles aligned.

Read field note

SHOPIFY LETS ONE VARIANT HAVE 20 BARCODES. WHY KEEP A SKU TOO? Leafy compares a readable MUG-OLV-12 SKU card with a scannable barcode label and points to a checked LedgerLeaf SKU rule.

Inventory & SKUs

SKU vs Barcode in Shopify: What Should You Use?

Learn when Shopify needs a SKU, a barcode, or both—and why clear SKUs give LedgerLeaf better building blocks for linked stock and bundle rules.

Read field note

YOUR SKU SYSTEM FITS 100 PRODUCTS. WILL IT SURVIVE 1,000? Leafy points to TEE-CREW-OLV-M as 100 product boxes grow into an orderly 1,000-product shelf.

Inventory & SKUs

How to Create a Scalable SKU Naming Convention

Build a Shopify SKU convention that can grow from 100 to 1,000 products and gives LedgerLeaf clean patterns for linked stock and bundles.

Read field note

YOUR OSS RETURN IS FILED. COULD YOU PROVE EVERY ROW 10 YEARS LATER? Leafy archives a LedgerLeaf evidence pack with country, rate, payment, and return records.

VAT & OSS

What Records Should You Keep for an OSS Return?

Build a 10-year OSS evidence pack around LedgerLeaf exports, Shopify order records, adjustments, filing, and payment proof.

Read field note

WHAT STOPS THE BOTS THAT GET THROUGH? A Cloudflare filter catches several purple bots while one reaches ShieldLeaf, where caped Leafy and the country-blocking shield protect a Shopify storefront and its tracking signals.

Traffic & Country Access

The Practical Way to Protect Shopify From Bots and Scrapers

See how ShieldLeaf stops unwanted country traffic from interfering with Shopify pixels, analytics, audiences, and advertising data.

Read field note

OSS DUE ON A WEEKEND? THE DEADLINE STAYS. Leafy points to three checked LedgerLeaf review steps beside a calendar marked 31 and Weekend.

Templates & Checklists

Quarterly OSS Checklist for Shopify Merchants

Close your Shopify OSS quarter with LedgerLeaf: review country and rate totals, resolve refunds, freeze the evidence pack, and track filing and payment.

Read field note

€120 INCLUDES 20% VAT. IS VAT €20 OR €24? Leafy points to a LedgerLeaf-style review panel that splits gross €120 into VAT €20 and net €100.

VAT & OSS

Tax-Inclusive Pricing on Shopify: What Your Reports Show

See how Shopify splits a tax-inclusive price into net and tax, then verify each country-and-rate result with LedgerLeaf.

Read field note

€20 OFF. €48 REFUNDED. WHY DID VAT MOVE TWICE? Leafy traces an order-day discount and later refund to separate taxable amount and VAT rows in a green LedgerLeaf review panel.

VAT & OSS

How Refunds and Discounts Affect Shopify VAT Reports

Trace Shopify discounts and refunds to the right VAT period, country, rate, and transaction with a repeatable LedgerLeaf review.

Read field note

ONE COUNTRY. TWO VAT RATES. WHICH ORDER EXPLAINS IT? Leafy uses a magnifying glass to compare France 20% and 5.5% rows above a green LedgerLeaf panel labeled COUNTRY, RATE, and TRANSACTION.

VAT & OSS

How to Review Shopify VAT by Country and Rate

Find the country-and-rate rows that need attention, trace them to Shopify orders, and turn the result into a repeatable LedgerLeaf VAT review.

Read field note

ONE €10,000 LIMIT. NOT 27. Leafy points from FR, DE, and ES chips into one combined threshold meter above a LedgerLeaf VAT review panel labeled COUNTRY, RATE, and PERIOD.

VAT & OSS

EU Distance-Selling Threshold for Shopify: One €10,000 Limit

The EU distance-selling threshold is €10,000 in total, not per country. See what counts and turn the result into a LedgerLeaf VAT review.

Read field note

SAME EU CUSTOMER. WHICH VAT LANE? Leafy routes an EU-stock parcel toward quarterly OSS and a non-EU parcel under €150 toward monthly IOSS, beside a green LedgerLeaf VAT review panel labelled COUNTRY, RATE, and EXPORT.

VAT & OSS

VAT OSS vs IOSS for Ecommerce: Which Scheme Fits?

Learn the shipment-origin test for OSS vs IOSS, then use LedgerLeaf to keep Shopify VAT evidence separated by country, rate, period, and scheme.

Read field note

BOTH ADD TAX. WHY CAN'T YOU REPORT THEM THE SAME WAY? Leafy separates a final-sale SALES TAX receipt from a staged VAT trail, then points to a green LedgerLeaf VAT review folder labelled COUNTRY, RATE, and OSS.

VAT & OSS

Shopify Sales Tax vs VAT: What Merchants Need to Distinguish

Separate Shopify sales tax from VAT, then use LedgerLeaf to review EU VAT by country, rate, period, and OSS scope without mixing the evidence.

Read field note

SHOPIFY TOOK THE FEE. WHICH RECORD PROVES IT? Leafy sorts a Shopify bill and LedgerLeaf Pro payout evidence into a green bookkeeping folder, with subscription and processing fees kept separate.

Bookkeeping & Reports

Are Shopify Fees a Business Expense? Records to Keep

See when Shopify fees are generally business expenses, which records support each fee, and how LedgerLeaf keeps processing-fee evidence ready.

Read field note

€10,000 GROSS. €7,600 NET. WHAT CHANGED? Leafy considers a white gross-to-net panel showing €1,500 in discounts and €900 in sales reversals on a green LedgerLeaf background.

Bookkeeping & Reports

Gross Sales vs Net Sales in Shopify: What Changed?

See how Shopify calculates gross and net sales, explain the gap, and save the supporting sales data in a repeatable LedgerLeaf export.

Read field note

SALE IN JUNE. PAYOUT IN JULY. WHICH MONTH COUNTS? Leafy stands between June sale and July payout calendar stickers beneath a white LedgerLeaf-style question panel.

Bookkeeping & Reports

Cash vs Accrual Accounting for Ecommerce: Which Date Counts?

Compare cash and accrual accounting for ecommerce, then build the Shopify evidence your chosen method needs with a repeatable LedgerLeaf workflow.

Read field note

ONE SALE. FOUR RECORDS. WHICH ONE DID YOU MISS? Leafy traces one sale into sales, payout, expenses, and stock records, with the purple expense receipt outside the LedgerLeaf workspace.

Bookkeeping & Reports

Ecommerce Bookkeeping for Beginners: Start With Four Records

Set up ecommerce bookkeeping around sales, payouts, expenses, and stock, then use LedgerLeaf to keep the Shopify-side records ready to repeat.

Read field note

CAN A VPN CROSS THE SHIELD? Leafy points from a blocked-country map pin through a purple tunnel to a VPN exit in an allowed country beside a storefront and ShieldLeaf shield.

Traffic & Country Access

Can VPN or Proxy Visitors Bypass Country Blocking?

Learn how VPN and proxy exit locations can bypass Shopify country rules, what country blocking still stops, and how ShieldLeaf sets a clear boundary.

Read field note

BLOCK A COUNTRY OR EVERY IP? Leafy compares a map with one highlighted country and ShieldLeaf shield imagery with three purple example IP address cards.

Traffic & Country Access

Country Blocking vs IP Blocking for Shopify: Which Do You Need?

Compare country blocking with exact IP rules, then choose the right boundary for unwanted Shopify traffic and set it up clearly with ShieldLeaf.

Read field note

BLOCKED VISITOR. STILL COUNTED? Leafy points from one purple visitor map pin stopped by a ShieldLeaf shield at the storefront to a separate session report that still shows one session.

Traffic & Country Access

Why Blocked Visitors Can Still Appear in Shopify Analytics

Learn why a country-blocked visit can still appear in Shopify Analytics—and how ShieldLeaf shows whether the access rule actually worked.

Read field note

BOT TRAFFIC. BLOCK IT ALL? Leafy points to two paths beside a Shopify storefront: a green search crawler is allowed in, while a purple bot from an unserved country is redirected away by a ShieldLeaf shield.

Traffic & Country Access

Good Bots vs Bad Bots on Shopify: What Should You Block?

Learn which Shopify bots help your store, which create risk, and when a focused ShieldLeaf country rule is smarter than blocking everything.

Read field note

SAME SALES. LOWER CONVERSION? Leafy points from a 250-session, 10-order card showing 4% to a 1,000-session, 10-order card showing 1%, as purple bot map pins inflate the second session count.

Traffic & Country Access

Can Fake Traffic Lower Your Shopify Conversion Rate?

See how fake traffic can lower Shopify's reported conversion rate, how to check the pattern, and when a ShieldLeaf country rule fits.

Read field note

FILTERED = BLOCKED? Leafy points to a shield between a white analytics filter card and a storefront as three purple bot map pins approach.

Traffic & Country Access

How Shopify Bot Filtering Changes Analytics Reports

See what Shopify's bot filter changes in sessions and conversion reports, what it cannot block, and when a ShieldLeaf country rule fits.

Read field note

ONE MUG SOLD. STILL FIVE BUNDLES? Leafy points from a five-mug stock card through a one-sold step and a LedgerLeaf bundle rule to the corrected four-bundle quantity.

Inventory & SKUs

How to Prevent Overselling Bundles on Shopify

Prevent Shopify bundle overselling by checking component settings, defining the stock recipe, and linking parent and component SKUs in LedgerLeaf.

Read field note

ONE SALE. WHAT LEFT THE SHELF? Leafy follows one order toward either a ready-made gift box or the candle and soap inside it, with LedgerLeaf turning the chosen stock model into a clear SKU rule.

Inventory & SKUs

Shopify Kits vs Bundles: Inventory and Reporting Differences

See whether one Shopify sale should reduce a finished box or the products inside it, then make that stock relationship explicit with LedgerLeaf.

Read field note

11 CANDLES. WHY CAN SHOPIFY SELL ONLY 5 BUNDLES? Leafy points to component cards showing 11 candles divided by 2, 18 soaps divided by 3, and 7 boxes divided by 1, with a LedgerLeaf bundle rule highlighting the limiting result of 5.

Inventory & SKUs

How Shopify Calculates Available Bundle Inventory

Use Shopify’s limiting-component formula, then turn parent and component SKUs into a repeatable LedgerLeaf bundle rule instead of manual stock math.

Read field note

ONE ENGRAVING SELLS. WHY DO ALL FOUR VARIANTS DROP TO 19? Leafy points from one 20-unit blank plaque stock pool through LedgerLeaf exact sync to four engraving variants showing 19.

Inventory & SKUs

How Shared Inventory Works for Shopify Variants and SKUs

Learn when Shopify variants should share one stock pool, why matching SKUs are not enough, and how LedgerLeaf keeps their quantities aligned.

Read field note

THREE LISTINGS SAY 48 IN STOCK. DO YOU HAVE 144 MUGS? Leafy points as one 48-unit mug stock pool branches through LedgerLeaf exact sync to three listing cards showing 48.

Inventory & SKUs

How to Sync Inventory Across Multiple Shopify Products

Link multiple Shopify products to one physical stock pool with clear SKUs, an exact-sync LedgerLeaf rule, and a safe test before launch.

Read field note

YOU PAID $4,800 FOR STOCK. WHERE DID $1,800 GO? A LedgerLeaf diagram branches 400 units bought for $4,800 into 250 sold with $3,000 cost and 150 unsold remaining as $1,800 inventory, while Leafy points to the unsold stock.

Bookkeeping & Reports

Shopify Cost of Goods Sold: Data, Timing, and Common Errors

See why Shopify purchases and COGS differ, then use LedgerLeaf sales exports and inventory snapshots to build a repeatable cost trail.

Read field note

10 UNITS ON THE SHELF. WHY DOES THE SNAPSHOT SAY 6? Leafy points to panels showing 10 on-hand units, 4 committed units, 6 incoming not yet received, and a month-end snapshot of 6 available.

Inventory & SKUs

Month-End Inventory Snapshots in Shopify: What the Number Means

Understand Shopify month-end inventory quantities, then use LedgerLeaf Pro snapshots to keep a repeatable stock trail for every close.

Read field note

USD, EUR, GBP. WHICH PAYOUT MATCHES WHICH BANK? Leafy guides three currency-labelled payout cards through separate dashed paths to matching bank accounts and a LedgerLeaf payout trail.

Bookkeeping & Reports

How to Reconcile Multi-Currency Shopify Payouts

Reconcile Shopify payouts one currency at a time, then use LedgerLeaf payout evidence to keep each bank match and conversion traceable.

Read field note

FULL REFUND. WHY IS THE CARD FEE STILL THERE? Leafy points from separate return, refund, and chargeback cards to LedgerLeaf sales export and payout report evidence.

Bookkeeping & Reports

How to Account for Shopify Refunds, Returns, and Chargebacks

Separate Shopify returns, refunds, and chargebacks, then use LedgerLeaf sales exports and payout reports to keep every movement traceable.

Read field note

ONE SALES EXPORT. WHAT WILL YOUR ACCOUNTANT STILL ASK? Leafy points from period, currency, tax, and payment cards toward a LedgerLeaf accountant handoff folder.

Bookkeeping & Reports

How to Prepare Shopify Sales Data for Your Accountant

Build a clear Shopify accountant handoff, then save the sales, tax, payment, and payout structure as a repeatable LedgerLeaf workflow.

Read field note

ONE TAX TOTAL. FOUR REPORTS. WHICH ONE ANSWERS YOUR QUESTION? Leafy sorts summary, region, order, and handoff cards into a green LedgerLeaf tax review panel.

Bookkeeping & Reports

Shopify Tax Reports Explained: Which One Do You Need?

Choose the right Shopify tax report, then turn it into a repeatable country, rate, transaction, and handoff workflow with LedgerLeaf.

Read field note

SHOPIFY HAS THE NUMBERS. DO YOUR ACCOUNTS KNOW WHERE THEY GO? Leafy guides sales, tax, payout, fees, and inventory cards into a green LedgerLeaf account map.

Bookkeeping & Reports

A Chart of Accounts for Shopify Bookkeeping

Use a worked Shopify chart of accounts example to separate revenue, tax, fees, and bank deposits with repeatable LedgerLeaf exports.

Read field note

BLOCK THEM—OR SEND THEM SOMEWHERE BETTER? Leafy stands at a fork between a ShieldLeaf blocked-access page and a redirect to a regional storefront.

Traffic & Country Access

Block or Redirect? Choosing a Country Rule for Shopify

Choose a blocked page or redirect in ShieldLeaf so visitors get a clear answer or reach the right regional seller, without editing Shopify theme code.

Read field note

SAME SKU. SAME STOCK? A cap and T-shirt with duplicate codes need unique SKUs; two listings for the same physical caps connect through a LedgerLeaf Pro linked-SKU rule, guided by smiling Leafy.

Inventory & SKUs

Duplicate SKUs in Shopify and How to Fix Them

Find accidental duplicate Shopify SKUs, fix catalog collisions, and use LedgerLeaf linked-SKU rules when listings intentionally share stock.

Read field note

SALES: €12,000. PAYOUT: €10,842. WHERE DID €1,158 GO? Leafy maps timing, other payment methods, refunds, fees, and holds between a sales card and a LedgerLeaf Pro payout card.

Bookkeeping & Reports

Why Shopify Sales and Payouts Do Not Match

See why Shopify sales and payouts differ, then use LedgerLeaf sales exports and payout reports to explain the gap without guessing.

Read field note

REMOVED FROM MARKETS. WHY CAN THEY STILL BROWSE? Leafy points between a Shopify Markets no-checkout panel and a ShieldLeaf no-storefront-access panel.

Traffic & Country Access

Can Shopify Natively Block a Country? Options and Limitations

Shopify Markets restricts purchases but leaves browsing open. See how ShieldLeaf blocks unwanted country visits with a free rule and a preview.

Read field note

Bookkeeping & Reports

Shopify Order CSV Columns Explained

Understand Shopify order CSV columns, avoid double-counting multi-item orders, and use LedgerLeaf to save a cleaner export profile for each job.

Read field note

THE BANK GOT €97. DID YOU SELL €97? Leafy points from a €100 customer charge through a €3 processing fee to a €97 bank deposit beside a LedgerLeaf-style payout panel.

Bookkeeping & Reports

How to Record Shopify Payments Fees in Your Books

Use LedgerLeaf to prepare Shopify Payments fee entries, explain a €97 deposit from a €100 payment, and send your accountant the supporting records.

Read field note

READY FOR OSS OR JUST A TOTAL? Smiling Leafy holds a quarterly OSS checklist beside Germany and France VAT cards by rate and a separate €19 refund note for an earlier quarter.

VAT & OSS

Shopify OSS VAT Reporting for Your Quarterly Return

Prepare Shopify OSS reports with LedgerLeaf. Review country and rate totals, trace refunds to the right quarter, and export a clear accountant handoff.

Read field note

WHICH SALES NUMBER? Leafy compares gross, net, and total sales cards beside a clean LedgerLeaf-style report panel on a green background.

Bookkeeping & Reports

Shopify Sales Reports and the Numbers That Matter

Understand Shopify gross, net, and total sales with a worked example, then use LedgerLeaf to turn the supporting records into a reusable accountant export.

Read field note

WHY THERE? Leafy traces an unexpected map pin to a traffic chart beside bot, link, and VPN clues in a green ShieldLeaf-style illustration.

Traffic & Country Access

Why Is My Shopify Store Getting Traffic From Unexpected Countries?

Unexpected country traffic can hide healthy Shopify sales. Learn how to trace the cause and use ShieldLeaf to handle unwanted storefront visits.

Read field note

12 TEAS. 5 MUGS. HOW MANY GIFT SETS CAN YOU SELL? Leafy points to two component cards connected to a LedgerLeaf BUNDLE RULE panel.

Inventory & SKUs

How to Keep Shopify Bundle Inventory in Sync

Keep Shopify gift-set stock aligned with tea and mug inventory. Set a LedgerLeaf bundle rule and check sales, restocks, and the limiting component.

Read field note

YOUR SKUS LOOK ORGANIZED. WILL YOUR BUNDLE STOCK STAY IN SYNC? Leafy points from a bundle SKU and two component SKU cards to a checked BUNDLE RULE panel.

Inventory & SKUs

Shopify SKU Guide for Clear Codes and Synced Stock

Give each Shopify variant a clear SKU, avoid duplicate codes, and use LedgerLeaf to keep bundle stock aligned with the items you can actually ship.

Read field note

THE VAT TOTAL MATCHED. CAN YOU EXPLAIN EVERY RATE? Leafy uses a magnifying glass to trace a VAT total into country, rate, and refund review cards.

VAT & OSS

Shopify VAT Reports: What to Export and Check

Use LedgerLeaf to check Shopify VAT by country and rate, trace a refund difference, and send your accountant a clear summary with transaction detail.

Read field note

IS THAT TRAFFIC HUMAN? Leafy examines a sharp sessions spike beside source and country clues in a green ShieldLeaf-style analytics illustration.

Traffic & Country Access

How to Identify Bot Traffic in Shopify

Identify Shopify bot traffic without mistaking it for lost sales. Follow a worked example to turn unwanted country traffic into a ShieldLeaf access rule.

Read field note

THE REPORTS ARE DOWNLOADED. IS THE MONTH CLOSED? Leafy reviews a seven-step checklist for period, sales, payments, payouts, tax, inventory, and handoff.

Templates & Checklists

Shopify Month-End Close Checklist for Merchants

Use this Shopify month-end close checklist to prepare sales, payouts, VAT, and stock records with LedgerLeaf and resolve gaps before accountant handoff.

Read field note

STOP PAYING $150/MONTH FOR ZOHO BOOKS JUST TO CONNECT SHOPIFY. Leafy compares a towering stack of business modules with one clean Shopify workbook.

Bookkeeping & Reports

LedgerLeaf vs Zoho Books: Is Zoho Books Overkill for a Small Shopify Store?

Compare LedgerLeaf and Zoho Books for Shopify integration, exports, inventory, accounting features, and the regular price of direct store connection.

Read field note

STOP PAYING $276/YEAR FOR FRESHBOOKS FEATURES YOUR STORE DOESN'T NEED. Leafy separates Shopify product-sales data from a service-business toolkit.

Bookkeeping & Reports

LedgerLeaf vs FreshBooks: Is FreshBooks Overkill for a Small Shopify Store?

Compare LedgerLeaf and FreshBooks for Shopify data, invoicing, reports, integrations, and regular pricing before adding a general accounting platform.

Read field note

STOP PAYING $300/YEAR FOR XERO JUST TO EXPORT TO EXCEL. Leafy points from a large accounting dashboard to a clean Shopify spreadsheet.

Bookkeeping & Reports

LedgerLeaf vs Xero: Is Xero Overkill for a Small Shopify Store?

Compare LedgerLeaf and Xero for Shopify exports, payouts, reports, complexity, and regular pricing—and decide whether a full ledger is necessary.

Read field note

STOP PAYING $456/YEAR FOR QUICKBOOKS JUST TO EXPORT A SPREADSHEET. Leafy balances a complicated accounting suite against a clean Shopify workbook.

Bookkeeping & Reports

LedgerLeaf vs QuickBooks: Is QuickBooks Overkill for a Small Shopify Store?

Compare LedgerLeaf and QuickBooks for Shopify data, reports, spreadsheets, complexity, and regular pricing before paying for a full accounting suite.

Read field note

THE PAYOUT MATCHED. WHAT’S STILL MISSING? Leafy traces charges, refunds, disputes, fees, and adjustments through a €2,881 payout to the matching bank deposit.

Bookkeeping & Reports

How to Reconcile Shopify Payments Payouts

Reconcile Shopify Payments payouts with LedgerLeaf Pro. Follow a €2,881 example, spot missing fees, and prepare clear records for your accountant.

Read field note

Why can they still visit if they can’t check out? Smiling Leafy holds a ShieldLeaf shield between a crossed-out checkout cart and an open storefront, showing that purchase restrictions do not block storefront access.

Traffic & Country Access

How to Block Countries on a Shopify Store

Block unwanted country traffic on Shopify with ShieldLeaf. Follow a practical setup, choose a blocked page or redirect, and preview before going live.

Read field note

Why did 1 Shopify order become 3 spreadsheet rows? Leafy compares one Shopify order with three exported line-item rows.

Bookkeeping & Reports

How to Export Shopify Orders to Excel or CSV

Use LedgerLeaf to export Shopify orders to Excel or CSV. Choose your accountant’s columns, understand extra rows, and save the selection for next month.

Read field note

Why doesn’t your Shopify payout match your sales? Sales of €10,000 compared with a payout of €8,742 while Leafy investigates the difference.

Bookkeeping & Reports

A Practical Guide to Shopify Bookkeeping

LedgerLeaf makes Shopify bookkeeping easier with reusable sales exports, payout reports, VAT/OSS views, and inventory records.

Read field note

Practical Shopify notes from the studio.

Shopify Store Traffic Protection Checklist

More from the studio.

Shopify Markets vs Country Blocking: Different Jobs

How to Test Shopify Country Blocking Before Going Live

What Should a Country-Blocked Visitor See?

Why Did My Shopify Conversion Rate Suddenly Drop?

Diagnosing a Sudden Shopify Traffic Spike

Bot Sessions, Fake Orders, and Fraud: How to Tell Them Apart

How to Reduce Unwanted Regional Traffic to a Shopify Store

How Country Blocking Interacts With Ads, Pixels, and Shopify Analytics

Does Geo-Blocking Affect Shopify SEO?

How to Redirect International Visitors on Shopify

Should You Block Countries You Do Not Ship To?

Shopify Bookkeeping Spreadsheet Template: A Five-Tab Workbook

Shopify Payout Reconciliation Spreadsheet Template

How Often Should You Reconcile a Shopify Store?

Manual vs Automated Shopify Bookkeeping

How to Build a Custom Shopify Sales Spreadsheet

CSV vs Excel for Shopify Reports

Shopify Inventory Reports: Which One Should You Use?

Shopify Inventory Adjustments Explained: Set To, Adjust By, and Reasons

Shopify Inventory Count Spreadsheet for Shared Stock

How to Reconcile Physical Stock With Shopify Inventory

SKU vs Barcode in Shopify: What Should You Use?

How to Create a Scalable SKU Naming Convention

What Records Should You Keep for an OSS Return?

The Practical Way to Protect Shopify From Bots and Scrapers

Quarterly OSS Checklist for Shopify Merchants

Tax-Inclusive Pricing on Shopify: What Your Reports Show

How Refunds and Discounts Affect Shopify VAT Reports

How to Review Shopify VAT by Country and Rate

EU Distance-Selling Threshold for Shopify: One €10,000 Limit

VAT OSS vs IOSS for Ecommerce: Which Scheme Fits?

Shopify Sales Tax vs VAT: What Merchants Need to Distinguish

Are Shopify Fees a Business Expense? Records to Keep

Gross Sales vs Net Sales in Shopify: What Changed?

Cash vs Accrual Accounting for Ecommerce: Which Date Counts?

Ecommerce Bookkeeping for Beginners: Start With Four Records

Can VPN or Proxy Visitors Bypass Country Blocking?

Country Blocking vs IP Blocking for Shopify: Which Do You Need?

Why Blocked Visitors Can Still Appear in Shopify Analytics

Good Bots vs Bad Bots on Shopify: What Should You Block?

Can Fake Traffic Lower Your Shopify Conversion Rate?

How Shopify Bot Filtering Changes Analytics Reports

How to Prevent Overselling Bundles on Shopify

Shopify Kits vs Bundles: Inventory and Reporting Differences

How Shopify Calculates Available Bundle Inventory

How Shared Inventory Works for Shopify Variants and SKUs

How to Sync Inventory Across Multiple Shopify Products

Shopify Cost of Goods Sold: Data, Timing, and Common Errors

Month-End Inventory Snapshots in Shopify: What the Number Means

How to Reconcile Multi-Currency Shopify Payouts

How to Account for Shopify Refunds, Returns, and Chargebacks

How to Prepare Shopify Sales Data for Your Accountant

Shopify Tax Reports Explained: Which One Do You Need?

A Chart of Accounts for Shopify Bookkeeping

Block or Redirect? Choosing a Country Rule for Shopify

Duplicate SKUs in Shopify and How to Fix Them

Why Shopify Sales and Payouts Do Not Match

Can Shopify Natively Block a Country? Options and Limitations

Shopify Order CSV Columns Explained

How to Record Shopify Payments Fees in Your Books

Shopify OSS VAT Reporting for Your Quarterly Return

Shopify Sales Reports and the Numbers That Matter

Why Is My Shopify Store Getting Traffic From Unexpected Countries?

How to Keep Shopify Bundle Inventory in Sync

Shopify SKU Guide for Clear Codes and Synced Stock

Shopify VAT Reports: What to Export and Check

How to Identify Bot Traffic in Shopify

Shopify Month-End Close Checklist for Merchants

LedgerLeaf vs Zoho Books: Is Zoho Books Overkill for a Small Shopify Store?

LedgerLeaf vs FreshBooks: Is FreshBooks Overkill for a Small Shopify Store?

LedgerLeaf vs Xero: Is Xero Overkill for a Small Shopify Store?

LedgerLeaf vs QuickBooks: Is QuickBooks Overkill for a Small Shopify Store?

How to Reconcile Shopify Payments Payouts

How to Block Countries on a Shopify Store

How to Export Shopify Orders to Excel or CSV

A Practical Guide to Shopify Bookkeeping

Nothing under that leaf.