A closer look at your template Etsy, Shopify & Amazon Seller Profit Bookkeeping
Reconcile marketplace payouts after listing fees, offsite ads, shipping labels, COGS and shop overhead.

CommerceTrue — E-Commerce Profit Reconciler — cover & overview · Sample data is fictional
EXCEL TEMPLATE · BUSINESS & WORK
Reconcile multi-channel orders, marketplace fees, COGS, refunds & ad spend into net profit.
Sales, platform fees, advertising and product costs are spread across channel exports. Import/paste channel exports; no built-in Shopify/Amazon/Noon or ad-account credentials. Operating contribution includes listed costs; it is not full cash flow or accrual accounting.
Digital download · No physical item
Refunds & download support · Template licence
Try the free budget starter · Read practical guides
No published customer reviews yet.
Purchased this product? Sign in to review it. Link guest orders from your private receipt first.
Google-Sheets/Code.gs, Google-Sheets/README.md, Excel-VBA/Blank-Template.xlsx, Excel-VBA/Sample-Data.xlsx, Excel-VBA/RizqtekProduct.bas, Excel-VBA/ThisWorkbook.txt, examples/*.csv (2 sample CSVs), README.md, ACCEPTANCE-CHECKS.md, and VALIDATION.md.
Includes both a Google Sheets edition (Google Apps Script Code.gs) and a Desktop Microsoft Excel edition (Blank-Template.xlsx, Sample-Data.xlsx, and importable VBA module RizqtekProduct.bas for Windows/Mac Excel).
Google-Sheets/Code.gs, Google-Sheets/README.md, Excel-VBA/Blank-Template.xlsx, Excel-VBA/Sample-Data.xlsx, Excel-VBA/RizqtekProduct.bas, Excel-VBA/ThisWorkbook.txt, examples/*.csv (2 sample CSVs), README.md, ACCEPTANCE-CHECKS.md, and VALIDATION.md.
Includes both a Google Sheets edition (Google Apps Script Code.gs) and a Desktop Microsoft Excel edition (Blank-Template.xlsx, Sample-Data.xlsx, and importable VBA module RizqtekProduct.bas for Windows/Mac Excel).
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.
One purchaser may use this digital automation package 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 source files or scripts is prohibited. Copyright 2026 RizqtekStudio. All rights reserved.
A closer look at your template Reconcile marketplace payouts after listing fees, offsite ads, shipping labels, COGS and shop overhead.
A closer look at your template Model SKU promo margins, landed COGS, breakeven ROAS and true net profit across paid channels.
A closer look at your template Import raw bank CSV exports, standardize dates/signs, auto-categorize by keyword & reconcile with Books.