Thoughtful templates. Instant downloads.
RizqtekStudio.
Launch gift: 4 of 5 free template claims remainUse STUDIOFIRST5 →

Etsy, Shopify & Amazon Seller Profit Bookkeeping

EXCEL + GOOGLE SHEETS · BUSINESS

Etsy, Shopify & Amazon Seller Profit Bookkeeping — Excel & Google Sheets Template

Reconcile marketplace payouts after listing fees, offsite ads, shipping labels, COGS and shop overhead.

Marketplace payouts never match your gross sales. Reconcile Etsy, Shopify, Amazon, TikTok Shop, and Faire settlement batches by deducting listing/transaction fees, offsite/PPC ads, shipping labels, and batch COGS, then subtract packaging and SaaS overhead to uncover your real take-home margin.

$19.99 USD · ONE-TIME PURCHASE

Digital download · No physical item

Refunds & download support · Template licence

Software requirementsWorks in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

Try the free budget starter · Read practical guides

  • 400-batch multi-channel payout ledger calculating true Net Seller Profit & Margin %
  • Side-by-side comparison across Etsy, Shopify, Amazon, TikTok Shop & Faire
  • 250-row shared shop overhead register for mailers, apps & studio gear

From the people who use it.

No published customer reviews yet.

Purchased this product? Sign in to review it. Link guest orders from your private receipt first.

Consider the details.

What’s inside

6 worksheets, thoughtfully organized.

  • 400-batch multi-channel payout ledger calculating true Net Seller Profit & Margin %
  • Side-by-side comparison across Etsy, Shopify, Amazon, TikTok Shop & Faire
  • 250-row shared shop overhead register for mailers, apps & studio gear
  • Marketplace Fee Audit revealing fee drag and tax reserve set-aside
  • Includes Excel master, Google Sheets edition, sample copy & PDF guide

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

Software & capacity

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

  • Enter settlement totals from monthly/bi-weekly marketplace CSV statements; no direct API connection.
  • Sales tax / VAT collected and remitted by marketplaces (Marketplace Facilitator) should be excluded from Gross Merch.
Download & getting started
After captured payment is verified, the order page provides your download links. Save your private order access link. Extract the ZIP, read Quick_Start.txt, and save a working copy of the clean workbook. Read the download guide
Licence & product support
One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved. Read the licence

Questions about this template

What is included with Etsy, Shopify & Amazon Seller Profit Bookkeeping?

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

What software is required to use Etsy, Shopify & Amazon Seller Profit Bookkeeping?

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

How do I receive Etsy, Shopify & Amazon Seller Profit Bookkeeping after purchasing?

After captured payment is verified, your private order page provides download links and a receipt is emailed. A valid complimentary claim also provides access without payment.

What licence applies to this template?

One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved.

A little more possibility.

All templates