A self-hosted tax tracking app for Etsy sellers. Track income, deductions, mileage, and estimated quarterly taxes with real-time calculations, visual dashboards, and secure authentication.

• Log weekly Etsy payouts with date and description
• View totals filtered by tax year

• Categorize business expenses (supplies, shipping, software, advertising, etc.)
• Automatic deduction totals per category

• Log business trips with date, destination, and miles driven
• Automatic IRS mileage rate deduction calculation (default $0.725/mile for 2026)
• Configurable rate per entry

• Adjustable Federal Income Tax rate (0-37%) and Self-Employment Tax rate (0-20%)
• Real-time breakdown: Federal Tax vs. SE Tax
• Taxable income = Total Payouts - Deductions - Mileage Deductions

• Automatic quarterly payment estimates (annual tax / 4)
• Dynamic deadline display: Q1 (Apr 15), Q2 (Jun 15), Q3 (Sep 15), Q4 (Jan 15 next year)
• Highlights upcoming deadlines

• Track how much you've set aside for taxes
• Progress bar showing saved vs. owed

• Monthly Income vs. Deductions bar chart
• Deductions by Category doughnut chart
• Monthly Profit Trend line chart

• Download full JSON backup with timestamp
• Restore from backup file
• Year selector to view data by tax year
• Offline fallback via localStorage

• Secure login with bcrypt-hashed passwords
• First-run setup creates initial account
• Session-based auth with 7-day expiry

• Node.js v18+ (v20 recommended)
• npm
• Apache with mod_proxy and mod_proxy_http enabled (for reverse proxy)

cd /var/www/html/your-domain/public
git clone <repo-url> ashley
cd ashley
npm install

Example:

export PORT=3000
export BASE_PATH="/ashley"
export SESSION_SECRET="your-random-secret-here"

To generate a strong secret:

openssl rand -hex 32

node server.js

Or with environment variables inline:

PORT=3000 BASE_PATH="/ashley" SESSION_SECRET="$(openssl rand -hex 32)" node server.js

Enable required modules:

sudo a2enmod proxy proxy_http
sudo systemctl restart apache2

Add to your Apache virtual host config (e.g., /etc/apache2/sites-available/your-domain.conf):

<VirtualHost *:443>
    ServerName your-domain.com

    # ... your existing SSL config ...

    # Reverse proxy for Etsy Tax Trackr
    ProxyPreserveHost On
    ProxyPass /ashley http://127.0.0.1:3000/ashley
    ProxyPassReverse /ashley http://127.0.0.1:3000/ashley
</VirtualHost>

Then reload Apache:

sudo systemctl reload apache2

The app will be accessible at https://your-domain.com/ashley.

Create a service file:

sudo nano /etc/systemd/system/etsy-tax-trackr.service

Paste:

[Unit]
Description=Etsy Tax Trackr
After=network.target

[Service]
Type=simple
User=www-data
WorkingDirectory=/var/www/html/your-domain/public/ashley
Environment=PORT=3000
Environment=BASE_PATH=/ashley
Environment=SESSION_SECRET=your-secret-here
ExecStart=/usr/bin/node server.js
Restart=on-failure
RestartSec=5

[Install]
WantedBy=multi-user.target

Enable and start:

sudo systemctl daemon-reload
sudo systemctl enable etsy-tax-trackr
sudo systemctl start etsy-tax-trackr

# Start the server
node server.js

# Start with environment variables
PORT=3000 BASE_PATH="/ashley" node server.js

# Stop the server (if running in foreground)
Ctrl+C

# Kill server running on port 3000
fuser -k 3000/tcp

# Restart via systemd (if configured)
sudo systemctl restart etsy-tax-trackr

# View server logs
sudo journalctl -u etsy-tax-trackr -f

# Install all dependencies
npm install

# Update dependencies
npm update

The SQLite database (tax_data.db) is created automatically on first run.

# View database contents (requires sqlite3 CLI)
sqlite3 tax_data.db

# Inside sqlite3:
.tables                          -- list all tables
SELECT * FROM income;            -- view income entries
SELECT * FROM expenses;          -- view expenses
SELECT * FROM mileage;           -- view mileage logs
SELECT * FROM settings;          -- view settings
SELECT * FROM users;             -- view user accounts
.quit                            -- exit

Backups can be done through the web UI, or manually:

# Manual database backup
cp tax_data.db tax_data.db.bak

# Restore from manual backup
cp tax_data.db.bak tax_data.db

# Enable proxy modules
sudo a2enmod proxy proxy_http

# Test Apache config
sudo apachectl configtest

# Reload Apache
sudo systemctl reload apache2

# Check Apache status
sudo systemctl status apache2

├── server.js        # Express backend, API routes, auth, SQLite
├── app.js           # Frontend logic, data sync, rendering
├── index.html       # Main application page
├── login.html       # Login / first-run setup page
├── style.css        # Styling (Playfair Display + DM Sans)
├── package.json     # Node.js dependencies
└── tax_data.db      # SQLite database (auto-created)