Guessing your margin from memory after a dozen pickups a month is how Sharetown reps leave money on the table. Build one Google Sheet that logs every pickup the moment it happens and calculates profit the second you type in a resale price — no more digging through text threads to remember what you paid for that dresser in March.
TL;DR
Most Sharetown reps start tracking profit in their head, then move to a Notes app, then give up entirely once the mattress, furniture, and fitness equipment pickups start blending together. By month three you know you're making money — you just can't say how much, or which retailer's returns are actually worth the drive.
A proper profit margin calculation depends on separating what you paid to acquire an item from what you spent cleaning, repairing, or storing it before resale. Reps who skip that split end up with a spreadsheet that shows revenue, not profit — and revenue lies. A Sheet that forces the split, one time, at entry, fixes this permanently.
=H2-(E2+F2) and drag the formula down the column.=IF(H2=0,0,J2/H2) and format that column as Percent under Format > Number.Expected result: entering a resale price instantly populates profit dollars and margin percent for that row, with zero manual math.
A desktop spreadsheet is useless standing in a retailer's loading dock. A linked Form fixes that.
Expected result: standing next to the truck, you open the bookmark, fill in four fields, and the row appears in your Tracker within seconds.
Once Form Responses start feeding rows automatically, pull them into your Tracker tab so profit and margin calculate without manual copy-paste.
=QUERY('Form Responses 1'!A:F, "select *") in a helper area to mirror new entries.=SUMIF(Tracker!B:B, A2, Tracker!J:J) to total profit per retailer.=AVERAGEIF(Tracker!C:C, A2, Tracker!K:K) to see average margin by item category.Expected result: a Summary tab that answers "which retailer's returns are actually worth my time" in one glance, updated automatically as new pickups get logged.
Reps who resell across multiple platforms — eBay one week, Facebook Marketplace the next — need a second view of the same data. Add a Pivot Table (Insert > Pivot table) with Resale Platform as rows and Profit as the summed value. This shows whether your OfferUp flips or your eBay flips are actually paying better, which matters more than gut feel once you're running 20+ pickups a month in 2026.
Reps ready to move past spreadsheets entirely and want their Sharetown earnings flowing straight into accounting software can follow the Sharetown earnings to QuickBooks workflow instead of maintaining formulas by hand.
Once the base tracker is solid, layer on what actually changes your take-home:
Start picking up returns to resell
Sharetown connects reps with retailer returns in their area — pickup, resell, profit.
What's the best way to track Sharetown pickup profit in 2026?
A Google Sheet with separate columns for acquisition cost, prep cost, and resale price is the most reliable free method in 2026. It calculates profit and margin automatically once formulas are set, and a linked Google Form lets you log pickups from your phone mid-route.
Is Google Sheets better than a bookkeeping app for tracking Sharetown profit?
Google Sheets works well under a few hundred pickups a year because it's free and fully customizable. Past that volume, a dedicated bookkeeping app saves time on tax categorization and reporting.
How do I calculate profit margin on a Sharetown flip?
Subtract acquisition cost and prep cost from your resale price to get profit dollars, then divide profit by resale price to get margin percent. Doing this in a spreadsheet formula avoids manual math errors on every single item.
Can I log Sharetown pickups from my phone?
Yes — a Google Form linked to your Sheet lets you enter pickup details from a bookmark on your phone's home screen. Responses land directly in your tracker within seconds of submission.
How much does it cost to set up a profit tracking spreadsheet?
Nothing — Google Sheets and Google Forms are both free with any Google account. The only cost is the time it takes to build the columns and formulas once.
Do I need separate columns for acquisition cost and prep cost?
Yes. Combining them into one 'cost' field makes it impossible to see whether prep work is eating your margin on specific item categories like fitness equipment or mattresses.
When should I switch from Google Sheets to accounting software?
Once your tracker passes roughly 200 rows or formulas start lagging on load, moving to QuickBooks or a dedicated bookkeeping app keeps reporting fast and tax season simpler.
How do I track profit across multiple resale platforms?
Add a Resale Platform column and build a pivot table summing profit by platform. This shows whether eBay, Facebook Marketplace, or OfferUp is actually paying better for your specific item categories.
The single column reps skip most often is Prep Cost — and it's the one that quietly erases margin on furniture flips that need sanding, reupholstering, or a deep clean before resale. Log it every time, even when it's just $5 in cleaning supplies, and your margin numbers in 2026 will actually mean something.
