Skip to content
The title slide and first slides of the Online Seller Income and Expense Tracker template

Online Seller Income and Expense Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Resellers who sell through several marketplaces, an auction site and their own store use this online seller income and expense tracker to see the whole business in one workbook. The Payouts tab records each statement with sales, fees and refunds and compares the expected deposit with the bank. The Stock tab records what was bought for resale and how much is still unsold, which gives cost of goods sold. The Dashboard shows net by channel and stock by product group.

Enter a payout the day the statement arrives, then check the Gap column before you forget which order it relates to. Count your shelves at least once a quarter so cost of sold stays honest. When the year closes, send the Dashboard totals and your statements to a tax professional, who can advise on inventory, sales tax and any forms the marketplaces issue.

Useful for

  • Find payouts that do not match the bank deposit
  • Compare fees and refunds across selling channels
  • Work out cost of goods sold from a shelf count

What's included

  • 4 tabs: Dashboard, Payouts, Stock, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Payouts: a table
  • Stock: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Payouts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track income from several selling platforms?

Give each platform a row for every payout statement and pick it from the channel list. The Dashboard then totals sales, fees and refunds per channel so each channel is easy to weigh against the others.

What is cost of goods sold for an online seller?

It is what you paid for the items you actually sold. This sheet multiplies the units sold, which is units bought minus units still unsold, by the cost of each. A tax professional can explain how inventory counts on your return.

Why does my payout not match my bank deposit?

Common reasons are holds, reserves, adjustments or a payout that spans two statements. Enter the deposit you received and use the Gap column to find the row to investigate in the platform report.

  • #tax-tracker
  • #online-seller-income-and-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…