Anna Arts CouncilArtist Business
Academy
โ† All Courses Course 08 ยท Business
Business Track ยท Course 08 of 30

Tracking Progress & Sales

You cannot manage what you don't measure. Build the dashboards, spreadsheets, and habits that give you a clear, real-time picture of your art business โ€” so you can make better decisions and grow with confidence.

6 Chapters Intermediate 10-Question Quiz Tracking Templates
6
Chapters
12
Key Metrics
๐Ÿ“Š
Live Dashboard
Course Progress0 of 6 chapters
1

Why Tracking Transforms Art Businesses

The difference between guessing and knowing

Most artists operate their businesses by feel. They have a general sense of whether things are going well or poorly โ€” but they couldn't tell you exactly how much they earned last month, which product generates the most revenue, which channel brings the most buyers, or whether their income is growing or shrinking. This isn't laziness โ€” it's a lack of system.

Artists who track their numbers make better decisions. They know which art markets are worth attending. They know which products to make more of. They know when to raise prices. They know exactly what it will take to reach their income goals. Tracking doesn't remove creativity from your practice โ€” it protects it by ensuring the business side stays healthy.

What Tracking Makes Possible
Specific decisions that become possible only when you know your numbers
๐ŸŽช
Market Selection
Track revenue and time invested per market. You may discover one local market generates 3ร— another with the same time investment. That data changes where you go.
๐ŸŽจ
Product Decisions
Which product category โ€” originals, prints, workshops โ€” generates the most revenue per hour invested? Tracking reveals this. Gut feel never accurately answers it.
๐Ÿ’ฐ
Pricing Confidence
When you track your cost per piece and margin per sale, you price with confidence instead of anxiety. You know your floor and your market rate.
๐Ÿ“…
Seasonal Planning
Track monthly revenue for 12 months and patterns emerge: Q4 holiday surge, slow January, summer pick-up. Plan inventory, workshops, and marketing around these patterns.
๐ŸŽฏ
Goal Progress
Your SMART goals from Course 07 have no teeth without tracking. "Earn $800/month by June" requires knowing your current monthly revenue and tracking week-by-week progress.
๐Ÿฆ
Tax Preparation
Artists with tracked numbers spend 2โ€“4 hours preparing taxes. Artists without spend 20โ€“40 hours reconstructing the year from receipts and memory โ€” often missing deductions.
2

The 12 Key Metrics Every Artist Needs

Your essential business health indicators

You don't need to track everything โ€” just the right things. These 12 metrics give you a complete picture of your art business health. Review them weekly during your SMART goal check-in from Course 07.

๐Ÿ’ต
Monthly Revenue
Total income from all art sources. Your north star metric.
๐Ÿ“ฆ
Units Sold
Number of pieces sold this month, by category.
๐Ÿ’น
Avg Sale Price
Total revenue รท units sold. Track this over time.
๐ŸŽฏ
Revenue by Channel
Which sales channel (Etsy, markets, Instagram) is performing best?
๐Ÿ’ธ
Cost of Goods Sold
Materials + production costs for what you sold.
๐Ÿ“ˆ
Gross Margin %
(Revenue โˆ’ COGS) รท Revenue ร— 100. Healthy: 60%+
๐Ÿ—‚๏ธ
Inventory Value
Total retail value of unsold work in your studio.
๐Ÿ“ฑ
Social Followers
Track growth weekly across your top 2 platforms.
๐Ÿ“ง
Email Subscribers
List size and weekly growth rate.
๐ŸŒ
Website Traffic
Monthly unique visitors and top traffic sources.
โญ
Repeat Buyer Rate
% of sales from returning customers. Healthy: 20%+
๐Ÿ†
Goal Progress %
How far toward your 90-day revenue goal are you?
Sample Artist Revenue Dashboard โ€” 12-Month Trend
What consistent tracking reveals: seasonal patterns, growth, and areas to improve
3

Your Inventory Tracking System

Know exactly what you have, where it is, and what it's worth

Inventory tracking is foundational. Without it, you cannot accurately calculate your cost of goods sold, cannot prevent selling the same piece twice, cannot manage gallery consignments, and cannot determine whether your studio is a healthy business asset or a storage room of stagnant work.

The Minimum Inventory Record โ€” Every Piece

๐Ÿ“‹ Artist Inventory Spreadsheet โ€” Sample
IDTitleMediumSizeDateCostPriceStatusLocation
001Texas Prairie at DuskOil on canvas16ร—20Jan 2025$42$285AvailableStudio
002Collin County MorningWatercolor11ร—14Feb 2025$18$145Sold โ€” EtsyShipped
003Bluebonnet Field StudyAcrylic8ร—10Feb 2025$22$175ConsignmentMcKinney Gallery
004Anna FarmlandOil on linen24ร—30Mar 2025$68$550AvailableStudio
005Pet Portrait โ€” CharlieAcrylic11ร—14Mar 2025$25$320Sold โ€” CommissionDelivered

Step-by-Step: Set Up Your Inventory System

  1. Assign every piece a unique ID number
    Use a simple system: 2025-001, 2025-002. This ID goes on the back of every piece, in your records, and on any invoice or shipping label. It is your audit trail.
  2. Photograph every piece immediately upon completion
    File photos by ID number. Minimum: one straight-on shot. Ideal: straight-on, slight angle, detail shot, and scale reference. Store in a dedicated Google Drive or Dropbox folder.
  3. Record cost of materials for every piece
    Before you even clean your brushes: note what you used and approximately what it cost. Tracking materials retroactively is extremely inaccurate โ€” do it while it's fresh.
  4. Update status immediately when a piece sells or moves
    Status changes โ€” Sold, Consignment, Returned, Reserved โ€” must be updated in real time. Stale inventory data leads to embarrassing double-sells and consignment disputes.
  5. Conduct a full inventory audit quarterly
    Once per quarter, physically locate and verify every piece in your records. Compare to your spreadsheet. Investigate any discrepancy. This takes 1โ€“2 hours and prevents costly mistakes.
4

Sales Tracking & Revenue Dashboard

Turn every sale into business intelligence

Every sale is data. Date, amount, product type, sales channel, buyer location, repeat or first-time buyer โ€” each data point, accumulated over time, tells the story of your art business and reveals your most important growth opportunities.

What to Record for Every Sale

๐Ÿ’ฐ Sales Log โ€” Sample
DateItemChannelSale PriceFeesNetBuyer Type
Mar 3Bluebonnet Print 11ร—14Etsy$65$6.23$58.77New
Mar 8Pet Portrait CommissionInstagram DM$320$9.28$310.72Repeat
Mar 15Original โ€” TX PrairieMcKinney Market$285$0$285.00New
Mar 22Watercolor Workshop (ร—8)Anna Comm. Ctr.$480$50$430.00Mixed
Mar 28Digital Download SetEtsy$18$1.67$16.33New

Monthly Revenue Snapshot Template

CategoryGoalActualVarianceAction
Original Sales$400$285โˆ’$115Add 1 more market day
Print Sales$150$83โˆ’$67Add 5 new Etsy listings
Workshops$400$430+$30Add March session
Commissions$200$311+$111Promote commission slots
TOTAL$1,150$1,109โˆ’$41Within 4% of goal โœ“
5

Tools & Software for Artist Tracking

Free and low-cost tools that do the heavy lifting
Best Tracking Tools for North Texas Artists โ€” 2025
Recommended tools by category, with pricing and use case
๐Ÿ“Š
Google Sheets (Inventory + Sales Log)
Cost: FREE
Best for: Custom inventory tracking, sales logs, monthly dashboards
Why: Flexible, shareable, works on any device, integrates with Google Forms for quick data entry. Download the Anna Arts Council free Artist Tracking Template (linked in your member portal).
Recommended for: All artists โ€” start here.
๐Ÿ’ผ
Wave Accounting (Financial Tracking)
Cost: FREE
Best for: Revenue tracking, expense categorization, tax preparation
Why: Connects directly to your business bank account. Auto-categorizes transactions. Generates P&L statements with one click. Free forever.
Recommended for: All artists โ€” essential for tax time.
๐Ÿ–ผ๏ธ
Artwork Archive (Art-Specific Tracking)
Cost: Free plan / $12/month Pro
Best for: Inventory management, consignment tracking, collector records, certificates of authenticity
Why: Built specifically for visual artists. Tracks where every piece is at all times. Essential for artists with gallery relationships.
Recommended for: Artists with 20+ active works or gallery consignments.
๐Ÿ“ฑ
Square / Shopify POS (Point of Sale)
Cost: Free reader (2.6% per swipe)
Best for: Art market sales tracking, inventory sync, customer records
Why: Records every sale with buyer info, item sold, payment method. Automatically updates inventory. Essential for art fair selling.
Recommended for: Artists attending 2+ markets per month.
ToolCostPrimary UseDifficultyPriority
Google SheetsFreeInventory + custom dashboardEasyStart First
Wave AccountingFreeFinancial tracking + taxesEasyStart First
Square POSFree + 2.6%Art market sales + inventoryEasyIf selling at markets
Artwork ArchiveFree / $12/moArt-specific inventory + galleriesEasyIf gallery/consignment
QuickBooks Simple Start$17/monthFull accounting + invoicingMediumWhen revenue exceeds $3K/mo
Google AnalyticsFreeWebsite traffic trackingMediumWhen you have a website
6

Building Your Tracking Habit

Simple routines that keep your numbers current without consuming your creative time

The best tracking system is the one you actually use. Elaborate systems that take 2 hours per week will be abandoned within a month. These simple daily, weekly, and monthly habits take under 30 minutes total per week โ€” and keep your numbers completely current.

The Artist's Tracking Rhythm โ€” Daily, Weekly, Monthly
Minimal time investment for maximum business clarity
๐Ÿ“…
Daily (5 minutes)
โ€ข Log any sales that occurred (Square does this automatically at markets)
โ€ข Note any materials purchased
โ€ข Record any new piece started or completed

Tool: Google Sheets on mobile or Square POS
๐Ÿ“†
Weekly (15 minutes)
โ€ข Tally week's total revenue by channel
โ€ข Update inventory status for any pieces sold, returned, or moved
โ€ข Check progress toward 90-day goal
โ€ข Post one week's metrics in your tracking log

Do this during your SMART goal review
๐Ÿ—“๏ธ
Monthly (30 minutes)
โ€ข Generate monthly P&L from Wave
โ€ข Compare actual vs. goal by revenue category
โ€ข Review best-selling product and channel
โ€ข Update 12-month trend chart
โ€ข Plan adjustments for next month

First Monday of every month
๐Ÿ†
Congratulations โ€” Course 08 Complete!
You now have the metrics framework, tracking templates, tool recommendations, and daily habits needed to run a data-driven art business. Set up your Google Sheets inventory tracker and Wave account today โ€” before these habits feel optional. Take the quiz, then continue to Course 09: Building Business Credit.
๐Ÿ“

Course 08 Knowledge Quiz

Test your tracking and metrics knowledge. 10 questions.

Question 1 of 10
What is the primary benefit of tracking your art business numbers consistently?
Question 2 of 10
What is a healthy Gross Margin percentage for an artist's product sales?
Question 3 of 10
What free tool is specifically recommended for financial tracking and tax preparation for artists?
Question 4 of 10
What information should be recorded for every piece in your inventory?
Question 5 of 10
Which tracking tool is specifically designed for visual artists and tracks consignments, collector records, and certificates of authenticity?
Question 6 of 10
How often should a full physical inventory audit be conducted?
Question 7 of 10
How is Average Sale Price calculated?
Question 8 of 10
What is the recommended Repeat Buyer Rate benchmark for a healthy art business?
Question 9 of 10
What is the approximate weekly time investment for the full artist tracking routine described in this course?
Question 10 of 10
When is QuickBooks recommended over Wave for artist bookkeeping?