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 ^[1]) 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: ^[2]

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):

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)

Related

• ^[2]
• ^[1]
• ^[3]