---
title: Doudlah Farms Popcorn Sales Data — Amazon Seller Central Exports
type: article
created: '2026-04-05'
updated: '2026-04-05'
source_docs:
- raw/2026-04-03-meeting-schedule-page-135352362.md
tags:
- amazon
- popcorn
- sales-data
- grant
- compliance
- doudlah-farms
layer: 2
client_source: null
industry_context: null
transferable: true
---

# Doudlah Farms Popcorn Sales Data — Amazon Seller Central Exports

## Overview

Grant compliance for Doudlah Farms requires monthly substantiation of Amazon popcorn sales figures. The grant administrator (Robert, via [[wiki/clients/stewards-unlimited/_index|Stewards Unlimited]]) requires transaction-level detail, not just high-level summary spreadsheets. This article documents the correct export process, the data cleaning step required to isolate popcorn products, and how the raw export reconciles with the polished P&L summary submitted for reimbursement.

See also: [[wiki/knowledge/amazon-strategy/grant-invoice-structure|Grant Invoice Structure — Retainer + Commission Format]]

---

## Export Process

### Source

Amazon Seller Central → Reports → Business Reports → **"Summary by Day"** export.

This is the preferred export format. Amazon does not offer a true per-transaction export; "summary by day" provides daily sales broken out by SKU, which is detailed enough to satisfy the grant administrator's substantiation requirement.

### Steps

1. Set the date range to the full calendar month (e.g., January 1–31).
2. Select **popcorn SKUs only** before exporting:
   - Yellow Popcorn
   - White Popcorn
   - Old World Popcorn
3. Export as CSV/spreadsheet.
4. **Remove any non-popcorn rows** — kidney beans and other non-popcorn products have appeared in exports and must be deleted before submission.
5. Leave all remaining columns intact. The extra columns (fees, referral fees, promo fees, refunds, etc.) are acceptable to include; a verbose raw export signals authenticity to the grant administrator.

### Why the Raw Export Is Submitted Unpolished

Daniella Lewis (Stewards Unlimited) specifically requested that the raw export be left in its original form — extra columns and all — to demonstrate that it is a direct system export rather than a manually constructed spreadsheet. Do not summarize or reformat this file before sending.

---

## Data Correction: Removing Kidney Beans

Kidney beans share the same Amazon seller account and appear in unfiltered exports. Failing to remove them inflates the popcorn sales total.

**Observed impact (January):**

| Version | Sales Total |
|---|---|
| Original figure (beans included) | ~$64,394 |
| Corrected figure (popcorn only) | $62,130 |
| Difference | ~$2,264 |

The corrected $62,130 figure was confirmed by cross-referencing the "summary by day" export (with beans removed) against the P&L summary filtered to popcorn SKUs only. Both sources reconciled to $62,130.

Always verify the cleaned export total matches the P&L summary total before finalizing the invoice commission calculation.

---

## Reconciliation with P&L Summary

Two documents are submitted each month:

1. **Raw "summary by day" export** — unedited except for removal of non-popcorn SKUs.
2. **Polished P&L summary** — an Amazon profit and loss report filtered to popcorn, showing total sales and total fees. This is the document Daniella uses to calculate the net reimbursement amount (sales minus fees).

The **product sales total must match** between these two documents. If there is a discrepancy, re-check for non-popcorn SKUs in the raw export or mismatched date ranges.

---

## Monthly Figures (Running Log)

| Month | Popcorn Sales (Corrected) | Notes |
|---|---|---|
| December 2025 | ~$60,331 | Invoice not revised; grant started mid-November, proration too complex |
| January 2026 | $62,130 | Corrected from ~$64k after removing kidney beans |
| February 2026 | TBD | Invoice revision pending |
| March 2026 | TBD | Invoice revision pending |

---

## Related

- [[wiki/knowledge/amazon-strategy/grant-invoice-structure|Grant Invoice Structure — Retainer + Commission Format]]
- [[wiki/clients/stewards-unlimited/_index|Stewards Unlimited]]
- [[wiki/meetings/2026-04-03-grant-compliance-invoice-restructure|Meeting: Grant Compliance Invoice Restructure (2026-04-03)]]