SIRGOVIRAL RESELLER GUIDE

How to Track SMM Reseller Orders With a Spreadsheet

Copy a spreadsheet layout for client references, panel statuses, follow-ups and order margins in naira.

An SMM reseller order tracker links each service you sell to its panel order ID, client update deadline and actual costs. Use one row per service sold to a client. If a client buys TikTok views and Instagram likes together, give each service its own line, such as RES-024-A and RES-024-B, and split the payment between those lines using the quoted amounts.

Copy this order tracker into Google Sheets or Excel

Copy both lines below and paste them into cell A1 of a blank sheet. If everything lands in one column, split the pasted text using Tab as the separator. The second line contains fictitious order details and working formulas. Format columns G through N as naira and column O as a percentage. Replace the sample values in A through K, then copy the formulas in L through O down as you add orders.

Client order ref	Panel order ID(s)	Service ID	Quantity	Panel status	Client update due	Amount received	Client refunds paid	Panel charges	Panel credits received	Other direct fees	Net client revenue	Direct order cost	Contribution	Margin
RES-024	481250	756	1000	Completed		3000	0	1800	0	150	=G2-H2	=I2-J2+K2	=L2-M2	=IF(L2>0,N2/L2,"")
Worked example · RES-024, one completed order
  • ₦3,000 net client revenue · ₦3,000 received minus ₦0 in refunds
  • ₦1,950 direct order cost · ₦1,800 panel charge plus ₦150 in fees
  • ₦1,050 contribution · 35% margin · ₦1,050 divided by ₦3,000

Contribution covers the revenue left after the costs entered for that order. Use it to compare similar orders before general overhead. The margin formula stays blank when net client revenue is zero or below. For more on what to include in your quote, see Sirgoviral’s reseller pricing and markup guide.

Update the tracker at each handoff

  1. Before submitting. Add the client reference, quoted service ID and quantity. Record only the amount actually received in the payment column. Keep your quote and payment record separately if you need to track outstanding balances.
  2. After submitting. Paste the panel order ID and record the actual charge. Add the date and time when you owe the client an update. Use the panel’s exact status label so it is easy to reconcile later.
  3. While delivery is open. Sort by client update due. Give the client the latest verified status and move the update deadline forward if the order remains open.
  4. When closing. Reconcile the actual panel charges and credits, direct fees and any refund paid to the client. Clear the update deadline once the client has received the final update.

Handle partial delivery, refunds and reorders on the original line

If the panel marks an order partial, check the panel order details and wallet history. Record a credit only after it appears in the wallet, and enter a client refund only when you actually send it. They are separate movements. For example, a ₦500 panel credit and a ₦700 client refund reduce the order’s contribution by ₦200 if everything else stays the same. See the partial order guide for what to check before deciding on a replacement.

If a replacement is required after you’ve checked the original order, add the new panel ID beside the old one and include its charge on the same client line. Keep the amount received once. For several attempts, use a second sheet with one row per panel ID and reconcile the charges and credits back to the client reference.

Make the tracker easy to review

  • Freeze the header and filter for open statuses and overdue updates at the start of each workday.
  • Protect the formula columns before sharing editing access with a team member.
  • Use client references and keep contact details, payment receipts and credentials out of shared copies.

Start by entering your current open orders using the IDs and service descriptions in your Sirgoviral dashboard. To compare services before quoting the next client, open the Sirgoviral services catalogue. Find related pricing and order help in Social Media Guides.