How to plan inventory when your books can't see your operations

You thought three containers was enough. Until it wasn't. Or a customer who had been quiet for six months emailed on a Tuesday asking about availability, and you spent the next hour trying to figure out what you actually had on hand versus what was still in transit versus what was already promised to someone else. Or your supplier came back with a spot-rate price that was 60% higher than last quarter, and every margin you had quoted to your customers evaporated in a single email.

Every small business owner who touches inventory has a version of this story. The books look fine. The bookkeeper is doing their job. The financial statements close cleanly at the end of the month. And you still get surprised, again, because nothing in your accounting stack was built to help you plan.

This is a resource for that specific pain. If you have been searching for how to plan inventory for a small business, how to forecast supplier lead times, or why your accounting software cannot help you see what is coming, you are in the right place.

Why your books cannot help you plan

Accounting software is a record of what already happened. Every invoice you sent, every bill you paid, every deposit that cleared. It is designed to reconcile back to your bank feed and produce a clean P&L. That is a real job and a valuable one.

It is not the job of planning inventory. Planning inventory is about what has not happened yet. The container that has left the supplier but not arrived. The customer who has not placed the order yet but is about to. The supplier price you have not seen but need to model. None of that shows up in QuickBooks, in Xero, in Wave, or in any accounting tool. It shows up on a spreadsheet, in your head, or in the group chat where your team keeps track of what is really going on.

That gap is why founders end up running two parallel businesses. One inside QuickBooks, one inside a Google Sheet. The bookkeeper does not open the sheet. The sheet does not post to the books. You are the person holding both together, usually late at night, usually while trying to remember what a customer told you two weeks ago.

The five operational events every ledger misses

These are the events that decide whether your inventory plan works. None of them are visible to your accounting software until it is too late to act on them.

1. 01

   Inventory that is on its way but not yet here

   A container on a ship does not exist to your ledger. It will, once the shipment posts and the receiving entry is booked. Until then, your books say you have three of something when you actually have five, two of them somewhere in the Pacific. If a customer asks how much you can commit to next month, the honest answer is not in QuickBooks.

2. 02

   Dormant customers who are about to reorder

   A customer who bought steadily for a year, went quiet for six months, and just emailed asking about availability is the most important lead in your pipeline right now. Your ledger sees "no revenue from this account since April." Your operational reality is that a large order is about to land, and you need to have product ready. No accounting tool surfaces the second view. That is on you to notice.

3. 03

   Spot-rate purchase prices

   The best price you had last month is not the price you will get this month. If your supplier suddenly quotes 1.5x the historical rate, every margin you have quoted downstream is off. Your books will show the change only after the bill posts, weeks after you have already sent quotes to customers at prices that no longer work.

4. 04

   Perishable clocks

   If your product has a shelf life, every day it sits is a hidden cost. The ledger will record the write-off when you eventually take one. The moment you actually needed the signal was three weeks earlier, when there was still time to move the product or reroute it to another customer.

5. 05

   Supplier lead-time changes

   The number that decides whether you run out is the gap between what you have and how long it takes to get more. Your supplier's lead time is not in QuickBooks. It is in an email thread. When it stretches from four weeks to nine, nothing in your accounting stack notices. You notice when a customer emails asking why their order is late.

What most operators do today, and where it breaks

The pattern is universal. A founder or a small ops team owns a set of Google Sheets. Those sheets are the real forecast: incoming containers with ETAs, customer roll with reorder history, supplier prices with a note about last month's spike, a projections tab that gets updated on a weekly call. Two or three people sit down every Monday, look at the sheet, and decide what to order.

"It all comes back to sort of managing inventory and planning orders from our suppliers. That's our biggest pain point."

This works when the business is small. One person can hold the whole picture. The sheet is close to reality. The Monday meeting catches the important things.

It stops working the moment the business grows. The customer list doubles. The number of SKUs doubles. Suppliers change. Lead times get less stable. The sheet goes stale. The Monday meeting is not enough. The dormant customer reactivates and nobody catches it in time. The supplier spot-rate spike hits after you have already quoted. The container arrives a week late and your best customer is furious. Founders describe this as "always in reactive mode" or "flying blind on the parts of the business that matter most."

Why your bookkeeper cannot close this gap

A good bookkeeper is not going to fix your inventory planning. They are downstream by design. Their inputs are the bank feed and the bills you send them. They are not sitting in your customer calls, not tracking your container ETAs, not watching your supplier email threads. Even the best bookkeeping firm is producing a picture of what happened, not what is about to happen.

This is not a bookkeeper problem. The bookkeeper is doing the work they were hired to do. The problem is that nobody in the traditional accounting stack is being paid to keep the operational picture and the financial picture in sync. That job has always been the founder's, and it always breaks at the same growth stage.

What actually helps

A few things move the needle without requiring you to buy or build something exotic.

Keep a live inventory-in-transit view, even if it is a single tab in your existing sheet. The container that left the supplier three weeks ago and arrives next week is the most important piece of information you have right now. Track it in one place. Attach the ETA. Attach the customer it is promised to. Anyone who plans should be able to open that tab and see reality.

Keep a dormant-customer watchlist. Every customer who has not bought in the last 90 days but bought consistently before that. Look at it weekly. When one of them reactivates, you want to be the first to know, not the last. The signal usually shows up in an email before it shows up in an order.

Track supplier lead times explicitly. Not as a note in your inbox. As a number in a column, updated every time you place an order. When the trend stretches, you have weeks of warning instead of days.

Watch spot-rate prices against your last three orders. A single spike changes the margin math for every quote you are about to send. Catching it in the moment beats catching it in the P&L three weeks later.

Have one conversation per week where the ops team and the finance picture meet. The Monday meeting works only if the two views are actually in the room together. Do not let it become another status update.

A short word about us

Porter is an AI-native ledger that scales with the business and speaks the operator's language, not the accountant's. We keep the operational picture and the financial picture in one place: your containers, your customers, your suppliers, your open pipeline, all readable in the same tool that owns your accounting. AI agents inside Porter flag when inventory is running low against your open orders. They notice when a spot-rate purchase changes your quoted margin. They surface the dormant customer who is about to come back. Human finance leads review anything that touches your books or your bank. Nothing posts without human approval.

If you have been running two parallel businesses and holding the seam together by hand, start here.