{"product_id":"etsy-seller-bookkeeping-profit-tracker-digital-download","title":"Etsy Seller Bookkeeping \u0026 Profit Tracker (Digital Download)","description":"\u003cp\u003eEtsy says you sold $1,000 this month. So how much did you actually keep?\u003c\/p\u003e\n\u003cp\u003eListing fees, transaction fees, payment processing, Offsite Ads, currency conversion and ads add up quickly. This tracker works out every one of them on every order, so you can see your real profit, your margin and how much to set aside for taxes, with the whole year on one dashboard.\u003c\/p\u003e\n\u003cp\u003eWe built it for our own family-run shop after one too many tax seasons spent going through statements line by line.\u003c\/p\u003e\n\u003ch3\u003eLight or dark, your choice\u003c\/h3\u003e\n\u003cp\u003eYou get two versions with the same features: the bright Daylight spreadsheet and a free Midnight dark mode. Use whichever is easier on your eyes.\u003c\/p\u003e\n\u003ch3\u003eWhat's inside\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e1 spreadsheet (.xlsx) with 9 connected tabs for Excel and Google Sheets\u003c\/li\u003e\n\u003cli\u003eFREE: Midnight dark-mode version of the spreadsheet (same features)\u003c\/li\u003e\n\u003cli\u003eQuick-Start Guide (PDF)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eThe tabs\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eDashboard: revenue YTD, net profit, margin, total Etsy fees and tax set-aside, a margin meter, a revenue goal bar, a tax countdown and 4 charts\u003c\/li\u003e\n\u003cli\u003eSettings: every Etsy fee rate is editable, plus your tax set-aside %, revenue goal, tax year and IRS mileage rate\u003c\/li\u003e\n\u003cli\u003eOrders: listing, transaction, processing, Offsite Ads (with the $100 cap) and currency fees calculated for you, along with your net\u003c\/li\u003e\n\u003cli\u003ePaste Etsy CSV: paste your Sold Orders export and a monthly summary fills in\u003c\/li\u003e\n\u003cli\u003eExpenses mapped to IRS Schedule C lines\u003c\/li\u003e\n\u003cli\u003eMileage Log with a round-trip switch\u003c\/li\u003e\n\u003cli\u003eMonthly P\u0026amp;L: 12 months side by side\u003c\/li\u003e\n\u003cli\u003eQuarterly Tax: suggested set-aside for each estimated-tax period, with due dates and paid\/unpaid status\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWhy sellers choose this one\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eWorks in both Excel and Google Sheets\u003c\/li\u003e\n\u003cli\u003eGets the fees right: transaction fees on item + shipping + gift wrap, processing on the full order total, and the Offsite Ads rate with the per-order cap\u003c\/li\u003e\n\u003cli\u003ePasting the CSV cuts down on manual entry\u003c\/li\u003e\n\u003cli\u003eLight-blue cells are for typing and gray cells calculate themselves. No password, so you can customize it\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eCheck out. Your download link appears right after checkout and in your order confirmation email, so you can download instantly.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and choose Open with \u0026gt; Google Sheets.\u003c\/li\u003e\n\u003cli\u003eEnter your shop details on Settings and clear the sample rows.\u003c\/li\u003e\n\u003cli\u003eLog orders (or paste your CSV), expenses and miles, then check your dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cdiv style=\"position:relative;padding-bottom:56.25%;height:0;overflow:hidden;max-width:100%;margin:16px 0\"\u003e\u003ciframe src=\"https:\/\/www.youtube-nocookie.com\/embed\/wICASSsQTdQ?rel=0\" title=\"How to use Etsy Seller Bookkeeping \u0026amp; Profit Tracker\" style=\"position:absolute;top:0;left:0;width:100%;height:100%;border:0\" allow=\"accelerometer; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen loading=\"lazy\"\u003e\u003c\/iframe\u003e\u003c\/div\u003e\n\u003ch3\u003eCompatibility\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or newer (Windows and Mac) and Excel 365\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets (free with a Google account)\u003c\/li\u003e\n\u003cli\u003eBest on a computer. Not built for Apple Numbers or phone-only use\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eAre the Etsy fees up to date?\u003c\/strong\u003e\u003cbr\u003eThe defaults are current US Etsy rates as of late 2026. Etsy changes fees from time to time, and every rate is a setting you can update in seconds.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eI'm not in the US. Will it work?\u003c\/strong\u003e\u003cbr\u003eYes. Change the fee rates on Settings to match your country. The tax tab follows the US IRS quarterly schedule.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCan I use it next year?\u003c\/strong\u003e\u003cbr\u003eYes. Change the tax year on Settings and all the months, quarters and due dates update.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eIs this tax advice?\u003c\/strong\u003e\u003cbr\u003eNo. It organizes your numbers and suggests a savings amount. Please talk with a tax professional about what you owe.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNot tax, legal, accounting or financial advice.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eQuestions? Email \u003ca href=\"mailto:sales@buckeyebrandingcompany.com\"\u003esales@buckeyebrandingcompany.com\u003c\/a\u003e. We're The Buckeye Branding Company, a small family-run shop in Copley, Ohio, and we answer our own email.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eDigital download only. No physical item ships. For use in your own business. Please don't share or resell the file.\u003c\/em\u003e\u003c\/p\u003e","brand":"The Buckeye Branding Company","offers":[{"title":"Default Title","offer_id":51353474629879,"sku":null,"price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0860\/8602\/5463\/files\/etsy-seller-bookkeeping-profit-tracker-photo-01.jpg?v=1792351687","url":"https:\/\/buckeyebrandingcompany.com\/products\/etsy-seller-bookkeeping-profit-tracker-digital-download","provider":"The Buckeye Branding Company","version":"1.0","type":"link"}