EtsyTrackr

⚠️ WORK IN PROGRESS: This application is actively being developed. Features and functionality may change without notice. Use at your own risk.

A desktop application to help Etsy sellers track their business finances, including sales, expenses, and profits.

Platform Support

EtsyTrackr is available for multiple platforms with the following support:

Platform	Status	Download Type	Notes
Windows	✅ Working	.exe (portable) .exe (installer)	Full support with both portable and installer versions
macOS	✅ Working	.dmg	Requires right-click to open on first launch
Linux	✅ Working	.AppImage	Self-contained executable that works on most distributions

All platform builds are automatically generated and tested with each release. Download the appropriate version for your platform from the Releases page.

Screenshots

Dashboard

Real-time overview of your business performance with sales trends and expense breakdowns.

Sales Tracking

Import and manage your Etsy sales statements with detailed breakdowns.

Expense Management

Track your business expenses and manage receipts.

Settings

Customize your application settings.

About

This project was created to provide Etsy sellers with a simple, offline way to track their business performance without relying on the Etsy API. Instead of requiring API access or constant internet connectivity, it works directly with the monthly CSV statements that any seller can download from their Etsy Shop Manager.

Why This Approach?

• No API keys or authentication needed
• Works offline once statements are downloaded
• No dependency on Etsy's API availability or rate limits
• Complete privacy - all data stays on your local machine
• Simple to use - just download your statements and import

Features

Dashboard

• Real-time overview of your business performance
• Daily sales chart with trend visualization
• Expenses breakdown showing Etsy fees vs. other business expenses
• Key metrics including:
  • Total sales and orders
  • Average order value
  • Net income
  • Total profit after expenses
  • Profit margin

Sales Tracking

• Import Etsy CSV statements automatically
• Smart duplicate handling - keeps only the latest statement for each month
• View sales data with detailed breakdowns
• Filter by year and month
• Track shipping fees, taxes, and Etsy fees

Inventory Management

• Track inventory levels for all your products

Expense Management

• Track business expenses with descriptions and dates
• Attach and view receipt images/PDFs
• Organize receipts with descriptive filenames (date_description_id)
• Filter expenses by:
  • Year
  • Month
  • Description search
• View expense statistics:
  • Total expenses in current view
  • Number of expenses

Data Management

• Local data storage for privacy
• Automatic backup of sales and expense data
• Receipt file organization

Installation

Windows Installer (Recommended)

1. Download the latest installer (EtsyTrackr_Setup.exe) from the Releases page
2. Run the installer and follow the setup wizard
3. Launch EtsyTrackr from your Start Menu or desktop shortcut

The installer will:

• Create a Start Menu shortcut
• Add a desktop shortcut (optional)
• Handle automatic updates
• Install all required dependencies

Portable Version

If you prefer not to use the installer, you can also download the portable version:

1. Download EtsyTrackr.exe from the Releases page
2. Run the executable from any location
3. Note: The portable version will still check for updates but won't install them automatically

macOS Installation

When running EtsyTrackr on macOS for the first time, you might see a security warning because the app is not signed with an Apple Developer Certificate. To run the app:

1. Mount the DMG file by double-clicking it
2. Drag EtsyTrackr to your Applications folder
3. In the Applications folder, right-click (or Control-click) on EtsyTrackr
4. Select "Open" from the context menu
5. Click "Open" in the security dialog that appears
6. The app will now open and remember your choice for future launches

Note: This warning only appears the first time you run the app. Future launches can be done normally by clicking the app icon.

Getting Started

1. Ensure you have Python 3.8 or higher installed
2. Clone this repository
3. Install required packages:

pip install -r requirements.txt

Building from Source

Manual Build

To build the executable manually:

1. Install the required packages:

pip install -r requirements.txt

2. Run the build script:

python build.py

The executable will be created in the dist directory.

Usage

1. Run the application:

python main.py

2. Import your Etsy statements:

   • Go to the Sales tab
   • Click "Import Statement"
   • Select your Etsy CSV file(s)

3. Add your business expenses:

   • Go to the Expenses tab
   • Fill in the expense details
   • Optionally attach a receipt
   • Click "Add Expense"

4. View your business performance:

   • Go to the Dashboard tab
   • Use the year/month filters to view different time periods
   • Monitor your sales trends and expenses

Data Storage

• Sales data: Stored in CSV format
• Expenses: Stored in JSON format
• Receipts: Stored as original files with descriptive names
• All data is stored locally in the application directory

Contributing

This is a work in progress. If you find bugs or have suggestions for improvements, please:

1. Open an issue
2. Describe the problem or enhancement
3. Include steps to reproduce if reporting a bug