Rizzitgo spreadsheet is only useful if you actually know how to use it. This tutorial removes every guesswork. We start from a blank Google Sheet and end with a fully functional order tracker that calculates profit, flags delays, and summarizes monthly performance.
Whether you are tracking five orders or five hundred, these same steps apply. By the end of this guide, you will understand not just what to click, but why each feature matters for your workflow.
Grab your laptop, open Google Sheets in a new tab, and follow along. We promise it is easier than it looks.
Need a Ready-Made Template?
Skip the setup and grab a free pre-built template with all formulas included.
Free TemplatesStep 1: Create Your Base Sheet
Open Google Sheets and create a new blank spreadsheet. Name it 'Rizzitgo Orders 2026'. The first row will become your header row. In cells A1 through G1, type exactly these column names: Item Name, SKU, Cost, Shipping, Fees, Sell Price, and Status.
These seven columns cover every essential data point for a single order. Do not add extra columns yet. Simplicity at the start prevents confusion later.
Step 2: Add the Profit Formula
In cell H1, type Profit. In H2, enter this formula: =F2-C2-D2-E2. This calculates your net profit by subtracting cost, shipping, and fees from your sell price.
Drag the fill handle (small square at the bottom-right of H2) down to row 20. Now every new row you add will automatically calculate profit. This single formula saves hours of manual math per week.
Step 3: Format for Readability
Highlight row 1, click the paint bucket, and choose a light gray. Bold the headers. Set all price columns (C, D, E, F, H) to Currency format. Select the Status column (G), go to Format > Conditional formatting, and create three rules:
Green background for text containing 'Delivered', yellow for 'Shipped', and red for 'Delayed'. Now your sheet tells a visual story at a glance.
Step 4: Create a Summary Dashboard
Add a new sheet by clicking the plus icon at the bottom. Name it Dashboard. In A1 type 'Total Orders', in B1 enter =COUNTA(Sheet1!A2:A). In A2 type 'Total Profit', in B2 enter =SUM(Sheet1!H2:H).
Add rows for Average Profit, Pending Orders, and Delivered Count. This dashboard updates automatically as your main sheet grows. It becomes your morning-check command center.
Step 5: Add a Date Log
Return to Sheet1. In I1 type 'Order Date', J1 'Ship Date', K1 'Delivery Date'. These three dates let you track how long each order takes from payment to doorstep.
After a month of data, you will see patterns. Some agents ship faster. Some items always delay. This data helps you choose better suppliers and set accurate expectations for customers.
Formula Cheat Sheet
Bookmark these essential formulas for your rizzitgo spreadsheet:
| Formula | Purpose | Difficulty |
|---|---|---|
| =F2-C2-D2-E2 | Calculate net profit per item | Easy |
| =COUNTA(A2:A) | Count total orders | Easy |
| =SUM(H2:H) | Sum all profit | Easy |
| =AVERAGE(H2:H) | Average profit per order | Easy |
| =IF(J2="","Pending","Shipped") | Auto-status based on ship date | Medium |
Continue Learning
You Are Ready to Track Like a Pro
Follow these five steps and your rizzitgo spreadsheet will handle the heavy lifting. Profit calculations, status tracking, and monthly summaries all happen automatically. The 20 minutes you spend today will save you hours every week.