What This Tool Actually Does
Fba Planner Minimalist is a spreadsheet-based planning tool for Amazon FBA sellers who need to track inventory planning, shipment schedules, and cash flow without buying into expensive software suites. It strips away everything that makes tools like SellerBoard or peruvian software complicated and leaves you with a working model that won't break when your ASIN count grows. I've used versions of this for about four years across two different product lines. The initial setup takes roughly 45 minutes if you already have your supplier lead times and current Amazon fees figured out. Most people skip the fee calculation step and then get confused three months later when their numbers don't match actual payouts. Don't do that.
Fba Planner Minimalist Setup Walkthrough
Start by opening the template and filling in the tab labeled Product Inputs. This is where you list every ASIN you sell on FBA along with your cost per unit, your retail price, and your estimated Amazon referral fee percentage for that category. The template has pre-loaded fee estimates for the most common categories, but those numbers are wrong for anything outside electronics and home goods. Check your actual fees in Seller Central before you trust the defaults. Next, populate the Inventory Planning tab. Enter your average monthly sales velocity, your reorder point, and your supplier lead time in days. The planner will calculate when you need to place your next order and how many units to ship to Amazon's fulfillment centers. Here's something nobody tells you about lead time: the number in your supplier spreadsheet is not the number that matters. The real lead time includes freight transit, customs clearance, and the 1-3 day grace period Amazon requires before a shipment goes live. Add at least 14 days to whatever your supplier told you, or you'll be running stockouts and wondering why yourBuy Box dropped. The Shipment Creator tab pulls from your inputs and generates a shipment plan you can paste directly into Seller Central. It formats everything the way Amazon expects it. I spent three weeks manually creating shipments because I didn't realize the planner output was compatible until a seller on the FBA Facebook group showed me. The first time I ran it, it cut my shipment creation time from about 90 minutes to 12 minutes for a multi-ASIN shipment.
The Cash Flow tab is where this tool actually earns its keep. It projects your outflows (supplier payments, shipping costs, Amazon fees) against your expected inflows based on your sales velocity and Amazon's payout schedule. Amazon pays every 14 days for most accounts, so the planner splits your expected revenue into 14-day buckets. If your projected cash balance dips below your safety threshold, it flags the month in red. That red flag saved me from overdrafting my business account last October when a supplier raised prices mid-quarter and I hadn't adjusted my reorder quantities.
Get the Full Details
Edge Cases and Workarounds
There's one scenario the template doesn't handle well: sellers who run FBM (Fulfilled by Merchant) alongside FBA on the same ASINs. The planner assumes 100% FBA velocity for each product. When I had about 30% of my kitchen gadget sales going through FBM, my inventory numbers were consistently off by 15-20%. I fixed it by creating a manual adjustment column on the Inventory Planning tab and subtracting my estimated FBM share from the FBA velocity input. Takes five minutes each month and keeps the rest of the model honest. Another gap: the planner doesn't account for inventory placement service fees or the newer Amazon routing changes. If you're shipping to multiple fulfillment centers without the placement service, the shipping cost estimates in the template will be too low. I added a manual multiplier to my freight cost field — roughly 1.3x for three or more destinations — which tracks closer to what I actually pay.
What It Won't Do
It doesn't sync with Amazon. You have to enter your sales data manually or import it from a report download. The monthly sales input section supports CSV imports if you format the columns correctly, but you're still doing the work yourself each month. If automation is a hard requirement, you'd be better off with something like Helium10 or Jungle Scout's inventory module, though those cost between $50 and $200 per month versus the one-time cost of this template. It also doesn't handle returns well. The returns tab exists but it's thin. Amazon return rates vary wildly by category — electronics can hit 8-12%, clothing even higher. The template uses a generic 5% return assumption. If you're in a high-return category, adjust that figure manually or your profit projections will be optimistic by 3-5 percentage points on net margin. Don't use this if you're moving more than 50 SKUs. The spreadsheet starts getting sluggish and the navigation becomes tedious. At that volume, you're outgrowing a sheet-based system regardless of how minimalist it is.
Where to Get It
The template is available through the creator's Gumroad page. As of now it's listed at $29 for a single-user license with free updates. There's a community Discord attached that someone should check before buying if you run into setup issues, because the documentation is sparse and the support response time is measured in days, not hours. The file is an Excel workbook with macros enabled. Some antivirus software flags the macros as suspicious even though they're just formatting helpers. I had to add an exception for it the first time. If you're at a company with strict IT policies, you might hit a wall there.
