FBA Inventory Report
E-Commerce Company
01 — Executive Summary
$21.8K FBA Inventory at Cost — 54 Active SKUs
Inventory @ Cost
$21,810
5,649 available units
Active SKUs
54
$3.86 avg cost/unit
Top 15 SKU Value
$16,481
75.6% of total
QBO vs Calculated Gap
$20,456
QBO: $1,355 vs $21,810
2026 POs Total
$41,951
9,119 units received
Unfulfilled Units
1
Across 54 SKUs
QBO Inventory Gap: The QBO Balance Sheet shows inventory at $1,354.55 vs. the calculated value of $21,810.36 — a $20,455.81 discrepancy. Recommend posting a monthly inventory adjustment journal entry to keep QBO aligned with actual FBA snapshot.
02 — Inventory by Category
Natracare Dominates at 78.7%
Inventory Value by Category
54 SKUs, $21,810 total value
Unit Distribution by Category
5,649 total units
| Category | SKUs | Units | Value @ Cost | % of Total | Avg Cost/Unit |
|---|---|---|---|---|---|
| Natracare — Feminine Care & Hygiene | 27 | 4,268 | $17,160 | 78.7% | $4.02 |
| Food & Snacks (Organic, Specialty) | 14 | 1,004 | $4,461 | 20.5% | $4.44 |
| Apparel — Puma | 3 | 8 | $91 | 0.4% | $11.38 |
| Other / Miscellaneous | 10 | 369 | $98 | 0.4% | $0.27 |
| TOTAL | 54 | 5,649 | $21,810 | 100% | $3.86 |
Concentration Risk: Natracare represents 78.7% of all inventory value and 75.6% of all units. A disruption in this supplier relationship would impact the vast majority of FBA stock.
03 — Top 15 SKUs by Value
Largest Inventory Positions
Top 15 SKUs — Inventory Value @ Cost
First 15 of 54 active SKUs, 75.6% of total value
| # | Product | ASIN | Units | Cost/Unit | Total Value |
|---|---|---|---|---|---|
| 1 | Natracare Slim Pads Wings Long | B0017QSVP2 | 915 | $4.23 | $3,870 |
| 2 | Natracare Non-App Tampons Regular | B00005368L | 660 | $4.90 | $3,234 |
| 3 | Natracare Organic Regular Tampons app | B00005368P | 406 | $5.74 | $2,330 |
| 4 | Natracare Safe to Flush Tissues | B07YP4FZJP | 657 | $2.67 | $1,754 |
| 5 | Natracare Pads Ultra Reg Wings | B000VI3LNE | 281 | $3.88 | $1,090 |
| 6 | Natracare Slim Ultra Pads Wings Reg | B01536MCXI | 254 | $4.23 | $1,074 |
| 7 | Natracare Ultra Extra Pads Regular | B00O7QBZN4 | 197 | $4.49 | $885 |
| 8 | Red Vines Mixed Berry 4oz | B07BBYNQTB | 360 | $1.62 | $583 |
| 9 | Mavuno Harvest Dried Jackfruit | B00JXM4EVW | 64 | $7.99 | $511 |
| 10 | Natracare Non-App Tampons Super | B004QJL83O | 194 | $2.36 | $458 |
| 11 | Natracare Non-App Tampons Regular | B003QP31XO | 194 | $2.36 | $458 |
| 12 | Natracare Organic Tampons Super 16ct | B000E3DXCA | 79 | $5.24 | $414 |
| 13 | Natracare Curved Panty Liners | B011KMGOS8 | 138 | $2.94 | $406 |
| 14 | La Colombe Mocha Latte | B01N1QGF0C | 141 | $2.80 | $395 |
| 15 | Mike's Mighty Good Tonkotsu Ramen | B07FYHVB5M | 157 | $2.20 | $345 |
04 — Amazon Account Balance
February 2026 Waterfall
Net Feb Activity
+$2,256
Sales $21,575 less fees/transfers
Closing Balance
$5,051
Feb 28, 2026
Sales Growth (Jan→Feb)
+122%
$9,724 → $21,575
Total Fees Feb
-$8,363
Fulfillment, referral, advertising
Account Activity Waterfall
Jan vs Feb 2026 line items
Weekly Sales vs Fees
February 2026 weekly breakdown
| Line Item | January 2026 | February 2026 | MoM Change |
|---|---|---|---|
| Product Sales | $9,724 | $21,575 | +$11,851 |
| Shipping Credits | $148 | $467 | +$319 |
| Adjustments / Other Credits | $50 | $146 | +$96 |
| Promotional Rebates | ($120) | ($316) | -$196 |
| Selling Fees (Referral etc.) | ($930) | ($2,325) | -$1,396 |
| FBA Fulfillment Fees | ($3,705) | ($5,452) | -$1,747 |
| Other Transaction Fees | ($157) | ($152) | +$5 |
| FBA Inventory Fees & Other | ($675) | ($1,215) | -$539 |
| Refunds Issued | ($386) | ($770) | -$385 |
| Service Fees (Advertising etc.) | ($229) | ($208) | +$21 |
| Transfers to Bank Account | ($2,791) | ($10,416) | -$7,625 |
| Net Activity | $1,473 | $2,256 | +$784 |
| Closing Balance | $2,795 | $5,051 | +$2,256 |
Methodology: Opening and closing balances calculated from the Amazon Transaction Report running total (Jan 1 — Feb 28, 2026). February opening = QBO Amazon Holding balance at Jan 1 ($1,322.43) plus January net activity ($1,472.63) = $2,795.06.
05 — Bank Transfers
$10,416 Transferred to Wells Fargo
| Transfer Date | Amount | Bank Transfer ID | To Account | Running Total |
|---|---|---|---|---|
| February 5, 2026 | $2.80 | JPA9TWYB76 | Wells Fargo x917 | $2.80 |
| February 14, 2026 | $7,383.44 | 5C9ZJOF3I1 | Wells Fargo x917 | $7,386.24 |
| February 28, 2026 | $3,029.89 | 4VBLATE3XE | Wells Fargo x917 | $10,416.13 |
| TOTAL TRANSFERRED | $10,416.13 | 3 transfers | All to Wells Fargo x917 | $10,416.13 |
06 — Inventory in Transit
Receiving Status — 24 Open Shipments
What "Receiving" Means: All 24 open shipments have physically arrived at an Amazon fulfillment center. Units are being scanned in — they are NOT still in transit from the supplier. Units will appear as Available once Amazon finishes processing (typically 3–10 business days per shipment).
| PO # | Description | PO Date | Units Ordered | Units Received | PO Cost Total | Status |
|---|---|---|---|---|---|---|
| 1098 | Red Vines (Grape Twists + Mixed Berry) | Jan 15 | 408 | 408 | $693 | At FBA Receiving |
| 1101 | Puma Apparel (Sports Bra + Boxer Briefs) | Jan 15 | 65 | 65 | $755 | At FBA Receiving |
| 1102 | Natracare Large Order (16 SKUs) | Jan 17 | 3,636 | 3,676 | $13,876 | At FBA Receiving |
| 1103 | Natracare Large Order (22 SKUs) | Feb 18 | 4,602 | 4,602 | $19,516 | At FBA Receiving |
| 1104 | DEWALT Tool Belt Organizer w/ Suspenders | Feb 17 | 108 | 108 | $5,728 | ⚠️ Confirm shipped before Feb 26 |
| 1105 | Ryo Root Scalp Essence + Red Vines | Mar 8 | 260 | 260 | $1,381 | ⚠️ Recently ordered |
| TOTAL 2026 POs | 6 POs | — | 9,079 | 9,119 | $41,951 | PO 1104 + 1105 confirm status |
184-unit counting gap across receiving batches. The largest shipment (FBA197B2XM50, 3,646 units, created Feb 3) has been receiving for over 5 weeks — unusually long. Contact Seller Support if still unfinished.
07 — Receiving Shipments Detail
$41,951 in Pipelines
| Created | Shipment Batch | FCs | Units Expected | Units Located | Status |
|---|---|---|---|---|---|
| Feb 3 | FBA197B2XM50 — LBE1 | 1 | 3,646 | 3,628 | ⚠️ 18 gap |
| Feb 20 | FBA197YQ batch (3 shipments) | 3 | 140 | 140 | ✓ Complete |
| Feb 26 | FBA1987- batch (5 shipments) | 5 | 1,144 | 1,139 | ⚠️ 5 gap |
| Feb 27 | FBA1989- batch (7 shipments) | 7 | 1,394 | 1,233 | ⚠️ 161 gap |
| Mar 2 | FBA198DDB09N — PBI3 | 1 | 20 | 20 | ✓ Complete |
| TOTAL | 24 shipments | 17 FCs | 8,324 | 8,140 | 184 units gap |