• Consignment Studio for Google Sheets, showing the actual decision dashboard with fictional example data. 112 calculated owed, 60 received, and a statement difference to review.
  • May include: A digital interface for Planzo Consignment Studio displayed on a screen. The dashboard features a purple header, data tables for calculated sales and payouts, and a bar chart titled Sold and received by shop. Text includes Know your next move.
  • May include: A digital interface for Planzo Docs made for Google Sheets. The screen displays the text Follow the source records, a spreadsheet view of a stocktake tab with columns for units, and a calculation box stating 20 inbound – 2 returned – 8 sold = 10 expected units. Counted: 10. Reconciled.
  • May include: A light purple digital interface titled Three decisions, made clearer. It lists three numbered points for reconciling units, tracking payouts, and flagging report discrepancies, designed for use with Google Sheets software.
  • May include: A digital dashboard interface titled A small example. A useful answer. featuring Planzo Docs branding and Google Sheets integration. It displays metrics for a fictional candle business including 20 delivered, 8 reported sold, 2 returned, and 10 units remaining in the shop.
  • May include: A light purple digital dashboard titled See what needs your attention with three numbered rows. Row 01 shows 160 in reported sales minus 48 commission equals 112 owed. Row 02 shows 60 received leaves a balance of 52. Row 03 shows a payout of 110.
  • May include: A light purple digital workspace interface for Google Sheets titled Your complete workspace. It features a Planzo logo, 10 worksheets, blank copy, fictional example, PDF guide, and a list of tabs: Overview, Settings, Stores, Products, Reports, Sales, Movements, Payments, Stocktake, and Read me.
  • May include: A digital instructional graphic for Planzo Docs with the text Download. Copy. Start with one record. It lists three steps for using Google Sheets, noting amber cells are inputs and to review warnings. It mentions Google account required.
  • May include: A digital download for Google Sheets titled Planzo. The interface features the text Choose it for the right job, listing specifications for 20 stores, 30 products, 60 reports, 150 sales, 100 payments, and manual records.
  • Consignment Studio for Google Sheets, showing the actual decision dashboard with fictional example data. 112 calculated owed, 60 received, and a statement difference to review.
  • Product video
  • May include: A digital interface for Planzo Consignment Studio displayed on a screen. The dashboard features a purple header, data tables for calculated sales and payouts, and a bar chart titled Sold and received by shop. Text includes Know your next move.
  • May include: A digital interface for Planzo Docs made for Google Sheets. The screen displays the text Follow the source records, a spreadsheet view of a stocktake tab with columns for units, and a calculation box stating 20 inbound – 2 returned – 8 sold = 10 expected units. Counted: 10. Reconciled.
  • May include: A light purple digital interface titled Three decisions, made clearer. It lists three numbered points for reconciling units, tracking payouts, and flagging report discrepancies, designed for use with Google Sheets software.
  • May include: A digital dashboard interface titled A small example. A useful answer. featuring Planzo Docs branding and Google Sheets integration. It displays metrics for a fictional candle business including 20 delivered, 8 reported sold, 2 returned, and 10 units remaining in the shop.
  • May include: A light purple digital dashboard titled See what needs your attention with three numbered rows. Row 01 shows 160 in reported sales minus 48 commission equals 112 owed. Row 02 shows 60 received leaves a balance of 52. Row 03 shows a payout of 110.
  • May include: A light purple digital workspace interface for Google Sheets titled Your complete workspace. It features a Planzo logo, 10 worksheets, blank copy, fictional example, PDF guide, and a list of tabs: Overview, Settings, Stores, Products, Reports, Sales, Movements, Payments, Stocktake, and Read me.
  • May include: A digital instructional graphic for Planzo Docs with the text Download. Copy. Start with one record. It lists three steps for using Google Sheets, noting amber cells are inputs and to review warnings. It mentions Google account required.
  • May include: A digital download for Google Sheets titled Planzo. The interface features the text Choose it for the right job, listing specifications for 20 stores, 30 products, 60 reports, 150 sales, 100 payments, and manual records.
  • Product video
Report this item to Etsy

Consignment Sales Tracker for Google Sheets: Store Inventory, Commissions and Payouts

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF
View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$19.90

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

Consignment Studio for Google Sheets, showing the actual decision dashboard with fictional example data. 112 calculated owed, 60 received, and a statement difference to review.

Know where your products are and what each shop owes you. This consignment sales tracker for Google Sheets keeps store stock, reported sales, commissions and actual payouts separate, so you can reconcile a shop's report against your records.

WHO IT IS FOR
Makers selling their own products through boutiques, galleries and other retail partners.

WHAT YOU CAN DO
• Reconcile delivered, sold, returned and transferred units.
• Keep calculated payout, shop-stated payout and received cash separate.
• Flag duplicate references, statement differences and overdue reports.

A WORKED EXAMPLE
The fictional example starts with 20 items delivered, 8 sold and 2 returned: 10 remain in the shop. Sales of 160 at a 30% commission leave 112 owed. A payment of 60 leaves a report balance of 52. These are sample values, not promised business results.

WHAT YOU RECEIVE
One PDF guide with links to a blank Google Sheets template and a separate fictional example. 10 connected worksheets, built-in guidance and formula-linked results. This is a digital download; no physical item is shipped.

HOW TO START
1. Add stores and products. OWNER is the location for your own stock.
2. Record deliveries, returns and transfers once in Movements.
3. Schedule Reports with period start/end and expected receipt date. Add actual receipt date when the report arrives.
4. Enter Sales using the agreed commission on each line; record Payments separately with a unique receipt reference.
5. Set As-of date and summary period in Settings. Review Overview, report balances and Stocktake.

QUESTIONS BEFORE YOU BUY
Does reported sales income mean I have been paid?
No. Payments are separate dated records. Reports shows each report's open balance. Period sales follow report period end; period cash follows receipt date, so their difference is not necessarily an outstanding balance.

How are discrepancies flagged?
The template checks report periods, receipt references, overdue scheduled reports and counted stock. An optional shop-stated payout is compared with the calculated amount. Review the source records before treating a difference as an error.

SCOPE AND LIMITS
20 stores, 30 products, 60 reports, 150 sales lines, 150 movements, 100 payments and 100 store-product stocktakes. One currency. Schedule expected reports to detect missing ones. Sales follow report period end; partial periods are not prorated. No POS, bank or Etsy sync, customer refund engine or tax accounting.

Google Sheets only. A Google account and internet connection are required. A desktop browser is recommended for setup and editing. Excel compatibility is not included. Amber cells are inputs. Formula cells have edit warnings, which you can override in your own copy. No automatic synchronization with other Planzo products.

Download the PDF from your Etsy purchase in a browser, then follow its Make a copy links. Keep the blank working copy and fictional example separate.

This original spreadsheet was created with AI assistance and tested using fictional sample data. It does not include an AI assistant.

  • Designed by
    PlanzoDocs
  • Item type
    Digital download
  • Digital file type(s)
    1 PDF
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

PlanzoDocs
Eyal Haimovich
PlanzoDocs ·

United States

No reviews yet
·
0 sales
·
New on Etsy

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Facebook Marketplace Template

Ebay.com

New Accounts

Ebay.com Login

Customer

Consignment Spreadsheet

Marketplace List

Listed on Oct 22, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates