Facebook Marketplace spreadsheet

Track each SKU from listing through payment and handoff without relying on an outdated universal fee or shipping assumption.

Get the spreadsheet
Reviewed by Jose Lopez, site publisher How we review guides

Fields to keep in the spreadsheet

Field Use it for Example
Sale method Record the method actually used for this buyer. Local pickup / Seller delivery / Available checkout
Payment status Track pending, paid, refunded, or cancelled separately from listing status. Paid at pickup
Transaction fee Copy a marketplace or payment fee only when the transaction shows one. Use the actual receipt
Cross-post Track other active platforms so the same SKU does not sell twice. Active on eBay + FB

Separate the listing from the transaction

A Marketplace listing may lead to an in-person handoff, a seller-arranged delivery, or an account-specific checkout flow. Keep listing status, sale method, and payment status in separate fields so a message from an interested buyer is not treated as a completed sale.

Meta’s help center explains that many Marketplace transactions are arranged between buyer and seller. Because available payment and shipping features differ, the completed transaction—not an old universal fee formula—should drive the spreadsheet values.

  • Use pending only after a clear hold policy or pickup plan is agreed.
  • Record paid and delivered as separate milestones.
  • Keep any platform, payment, or delivery charge in its own field.

Use one SKU across local and cross-posted listings

Assign the SKU before publishing and use it in every cross-posted record. For local inventory, the location may be a garage zone, shelf, or staging area rather than a shipping bin, but it still needs one consistent label.

When the buyer completes pickup, mark the item sold and end the other listings immediately. If the buyer does not arrive, keep the row and change the transaction status to no-show; the listing can return to active without losing the inquiry history.

Keep a small safety and handoff record

Meta publishes separate guidance for buying and selling responsibly. The spreadsheet should not store sensitive conversation details, but it can record the agreed date, broad handoff method, payment status, and whether the transaction was completed.

Use Marketplace and Messenger for the listing workflow and follow Meta’s current safety guidance. Avoid putting buyer phone numbers, home-access details, or other unnecessary personal data into a long-lived inventory sheet.

FAQ

What columns should a Facebook Marketplace spreadsheet include?

Track SKU, item title, location, purchase cost, list price, accepted price, sale method, payment status, any marketplace or payment fee shown, delivery cost, sold date, and net profit.

Does Facebook Marketplace charge a universal selling fee?

Do not assume one universal percentage. Marketplace transactions can be arranged directly between buyer and seller, while checkout, shipping, and payment features vary by account and location. Record only the fee shown for the actual transaction and recheck Meta’s current help pages.

How do I track no-shows?

Use a No Show status instead of deleting the row. Reset the listing to active and confirm the bin is still right before the next buyer.

Official sources

Primary marketplace documentation checked on August 20, 2026. Links open on the marketplace's own site.