How to Use Eastmallbuy Spreadsheet

Learning how to use eastmallbuy spreadsheet is simpler than you might expect. This tutorial walks through every feature from basic data entry to advanced automation, ensuring you get maximum value whether you are tracking ten orders or ten thousand.

The Dashboard: Your Command Center

The Dashboard tab is where high-level insights live. It automatically pulls data from the Orders tab and displays summary statistics: total orders placed, total spending, pending orders count, delivered percentage, average order value, and top vendors by volume. You never need to manually update this sheet. Every number refreshes as you work in other tabs.

Entering Orders Correctly

The Orders tab is your primary workspace. Follow this exact sequence for every entry to ensure calculations remain accurate:

1Select the first empty row beneath existing entries.

2Type the Order ID using a consistent format (e.g., ORD-2026-001).

3Enter the order date in MM/DD/YYYY format.

4Paste the product URL into the URL column.

5Write the full product name including size and color.

6Select the vendor from the dropdown (or add a new one).

7Input unit price without currency symbols.

8Input quantity as a plain number.

9Select order status from the dropdown.

Using the Status Dropdown

The Status column is more than a label. It drives conditional formatting and dashboard calculations. Here is what each status means:

Status	Meaning	Dashboard Impact
Pending	Order placed but not paid	Counts toward total spending
Paid	Payment confirmed	Added to committed budget
Processing	Vendor preparing shipment	Tracked in active orders
Shipped	Tracking number received	Moves to in-transit count
Delivered	Item received	Updates delivered percentage
Cancelled	Order voided	Excluded from all calculations

Calculating True Costs

The Total Cost column is a formula cell. It multiplies Unit Price by Quantity, then adds shipping from the Settings tab and applies your configured tax rate. This means the number you see represents the real money leaving your account, not just the sticker price. For resellers, this accuracy is critical because profit margins depend on knowing true landed costs.

Filtering and Sorting

Both Google Sheets and Excel support filtering the Orders tab. Click the filter icon on the header row, then select criteria such as Vendor = "Nike" or Status = "Shipped" to instantly narrow your view. This is incredibly useful when you want to see only pending payments or only orders from a specific supplier.

Sharing and Collaboration

To share your eastmallbuy spreadsheet, use the Share button in Google Sheets or the Review > Share Workbook option in Excel. We recommend setting team members to Commenter access if they only need to flag issues, and Editor access for partners who help manage orders. Never grant Owner access to anyone outside your core team.

FAQ

Can I add custom columns?

Yes. Insert columns anywhere to the right of the core fields. Avoid inserting within formula ranges in gray cells.

How do I handle returns?

Change the order status to Cancelled and add a note in the Notes column explaining the return reason.

What if a vendor is not in the dropdown?

Go to the Vendors tab, add the new name in the next empty row, and it will appear in the dropdown automatically.

Can I print the sheet?

Yes. Use File > Print and select the Orders tab. The formatting is optimized for standard A4 and letter sizes.

How do I backup my data?

Google Sheets auto-saves. For Excel, save to OneDrive or export a CSV copy weekly to an external drive.

Does it work with multiple currencies?

The template supports one base currency. For multi-currency operations, create separate sheets per currency or note conversions in the Notes column.

Master Your Orders Today

Download the complete eastmallbuy spreadsheet and take control of your workflow.

Access Full Spreadsheet