How to Update for New Mercari Fees (4.17.2023)
ICYMI – Mercari is updating their fee structure. Historically, Mercari did not charge it’s fees on the shipping cost of the item. Starting on April 17, 2023, Mercari will begin charging it’s payment processing fee on the sales price + shipping costs. For more details, check out Mercari’s notice here!
Below I have step by step guides on updating your spreadsheet! I have also included video tutorials below.
Step 1: Add column & reformat
Based on the previous fee structure, the spreadsheet did not require shipping costs to be input. Unfortunately with this change, you will need to input shipping costs for Mercari. To be able to do that, we need to add in a column.

Step 2: Update Formula
The formula needs to be updated to read the date the item was sold. The below formulas will read the date sold and calculate the fee based on that! This way, anything sold after April 17, will include the shipping cost in the fee calculation.
Master Sheet Formula (Posh/Mercari/eBay):
=IF(J11=”Mercari”,IF(U11<DATEVALUE(“4/17/2023″),(K11*0.1)+(K11*0.029)+0.5,(K11*0.1)+((K11+L11)*0.029)+0.5),IF(J11=”Poshmark”,IF(K11>=15,K11*0.2,2.95),0))
Posh/Mercari ONLY Formula:
=IF(J11=”Mercari”,IF(Q11<DATEVALUE(“4/17/2023″),(K11*0.1)+(K11*0.029)+0.5,(K11*0.1)+((K11+L11)*0.029)+0.5),IF(J11=”Poshmark”,IF(K11>=15,K11*0.2,2.95),0))
Update Offer Calculator Tab
Master Sheet Formula (Posh/Mercari/eBay):
First, update the name for “Shipping Buyer will Pay (eBay)” to “Shipping Buyer will Pay (eBay + Mercari)”. Next, update Total Fee formula to include the shipping costs as shown below.


Posh/Mercari Offer Tab Only:
First, add row for “Shipping Buyer will Pay (Mercari)”. Then update the Fee Formula to include the shipping cost as shown below.


