Facebook Marketplace Sales Tracking Spreadsheet

Like probably most Americans have in 2020, I’ve been trying to stay safe and stay home as much as possible. Instead of going on a summer vacation, we’ve been spending our time and money on decluttering and improving our house. Since we’ve been working from home much more often and soon our kids will begin remote schooling, we decided to turn our guest bedroom into an office/school room. But we’ve been using that spare room as storage space, so first we needed to get rid of all the crap that’s in there. Seriously, you couldn’t even walk around there were so many boxes of stuff we had accumulated over the past eight years.

I decided to start selling the stuff we no longer needed on Facebook Marketplace. After my first few sales, I thought I should really be tracking all this in order to learn from it and improve my sales. So naturally I made an Excel spreadsheet! I’ve turned my sheet into a blank template for you to use as well if you want to get into selling on FB MP and tracking your sales. Many Americans have lost their jobs or have reduced hours/wages. Selling goods on FB marketplace is a simple way to make a little additional income.

As always, even if you have no plan to sell anything on FB MP, you can still dissect this Excel template to learn some valuable lessons:

• How to make drop down lists using name manager and data validation
• How to filter a data table
• How to use ROUNDUP, IF, TEXT, COUNTIF, MAX, MIN, and AVERAGE functions
• How to count the number of days between two dates in Excel