Spreadsheets that do the maths for you.

Google Sheets templates for online sellers and families. Fill the yellow cells; every total, price and headcount works itself out.

Instant access after purchaseWorks in Google Sheets on laptop and phoneExample data includedMade by Scalehive Studio
Google Sheets template

Product Pricing & Profit Calculator

The right price for every product, on every channel, with import costs counted.

For: Etsy, Amazon, Shopify and eBay sellers, wholesalers and importers.

Tabs
6
Products per sheet
50
Answers per product
18
Channels
6
Buy for $12 on GumroadInstant access · make your own copy in Google Drive
Product Pricing & Profit Calculator dashboard preview

What it does

  • Fee presets for every channelEtsy (with offsite ads and currency conversion), Amazon, Shopify, eBay, your own site and wholesale. Edit them to match your account.
  • Channel CompareThe right price for one product on six channels side by side, and which channel earns most at your current price.
  • Discount TestProfit at 10% to 50% off and the deepest discount before you lose money.
  • Landed cost for importersFreight, insurance, duty, import VAT/GST and clearing, shared by value, units, weight or volume.
  • Tariff scenario and duty bufferSee your cost if duty rates rise, and add a safety margin for unclear HS codes.
  • Price checkRows turn red if your current price loses money and amber if it misses your target margin.
  • Handmade costsLabour minutes, hourly rate and monthly overheads spread per unit.
  • Wholesale and retail tiersA wholesale price at your margin and a retail price from your multiplier.

Look inside

Do I need to import to use it?

No. Set "Are you importing" to No and the import rows are ignored. It works as a plain pricing calculator.

Are the fee presets up to date?

They are typical rates at the time of writing. Fees change and differ by country, so check your platform and edit the presets.

Google Sheets template

Online Seller Bookkeeping

Bookkeeping for online sellers who get paid in more than one currency.

For: Sellers on Etsy, Amazon, Shopify, eBay, their own site or wholesale, especially outside the US.

Tabs
9
Order rows
1,000
Expense rows
500
Currencies
Any
Buy for $14 on GumroadInstant access · make your own copy in Google Drive
Online Seller Bookkeeping dashboard preview

What it does

  • A real exchange rate on every lineEach sale and expense converts at that day's rate from Google Finance, your own rate table, or a one-line override.
  • Payout checkCompare each payout with the bank credit and see what conversion and transfers really cost.
  • FIRC / e-FIRA logPayouts with no remittance document are flagged, for Indian exporters.
  • Any financial yearApril to March, January to December, or any month you choose. Report by order date or payout date.
  • Profit per product and channelUnit costs per SKU give cost of goods, gross profit and margin, plus totals by channel.
  • Fee presetsLeave fees blank and the channel presets fill them in. Type exact fees when you have them.
  • Wholesale invoicesBalance, days overdue and status for every invoice you send.
  • Tax summaryOne page with net sales, costs, profit, a tax set-aside estimate and quarterly totals.

Look inside

Does it connect to Etsy or Shopify?

No. You type or paste your orders. That keeps it simple and private, and it works for any platform.

Does it work in Excel?

It is built for Google Sheets. The automatic exchange rates use Google Finance, which Excel does not have.

Google Sheets template

Indian Wedding Planner

One planner for every function of your desi wedding.

For: Couples and families planning a multi-event Hindu, Sikh, Muslim or mixed wedding, in India or abroad.

Tabs
13
Guest rows
400
Events
6
Checklist tasks
44
Buy for $15 on GumroadInstant access · make your own copy in Google Drive
Indian Wedding Planner dashboard preview

What it does

  • An RSVP for every eventOne guest list with Invited, Yes, No or Maybe for up to 6 events, from Roka to Reception.
  • Headcounts for the catererConfirmed guests per event, split into veg, non-veg and Jain.
  • Budget by familyEstimate, final price, advances, balances and due dates, with who pays: bride's family, groom's family, couple or shared.
  • Two currenciesSee every amount in INR and a second currency, for NRI families and overseas payments.
  • Shagun & GiftsRecord gifts at every event, who wrote them down and thank-you notes. Possible double entries are flagged.
  • Stay & TravelHotel, room, arrival, pickup and drop for outstation guests.
  • Checklist by tradition44 tasks counted back from your date, tagged Hindu, Sikh or Muslim.
  • Event Day sheetPick an event and see the venue, headcount, vendors to pay and family duties on one page.

Look inside

Can my family edit it too?

Yes. Share your copy with family as editors and everyone works in the same planner.

Our wedding has more than 6 events. Will it work?

Combine small functions (for example Haldi and Mehndi) or track extras under "All events / general" in the budget and duties tabs.

How buying works

Your own copy in under a minute

  1. Buy on Gumroad. You get a PDF straight away.
  2. Click the link in the PDF. Google asks to make a copy in your Drive.
  3. Fill the yellow cells. Delete the example rows when you are ready.