Perpetual inventory method vs periodic: how each posts to the ledger
Your stock count looks right and your margin still moves after you close the month. The cause usually sits in when each system posts cost, and that comes down to perpetual versus periodic.

On this page
- What is the perpetual inventory method?
- How does the periodic method post to the ledger?
- Perpetual vs periodic: what changes in the ledger?
- Which method is right for an inventory business at $1m to $100m?
- Where does the perpetual method drift in Cin7 and QBO or Xero?
- How do you run a perpetual system cleanly this week?
- When should you patch, reconfigure, or rebuild?
- Frequently asked questions
TL;DR
- The perpetual inventory method debits COGS and credits Inventory every time stock sells, while a periodic system posts one COGS entry after the period-end count (beginning inventory plus purchases minus ending inventory).
- Under perpetual, shrinkage shows up as its own variance you can see and book. Under periodic, missing stock hides inside COGS because the count becomes the ending inventory number.
- For an inventory business running Cin7 Core with QuickBooks Online (QBO) or Xero, perpetual is the right method. The risk shifts from missing entries to timing gaps between the inventory sub-ledger and the general ledger.
- A manual journal in QBO or Xero moves the balance sheet but leaves the Cin7 inventory cards untouched, so the same difference returns next month-end.
- A weekly check of receipts, invoice authorisation, lock dates, the valuation report, and cycle counts keeps both systems telling the same story.
The balance sheet closes clean, then COGS moves after lock and the inventory asset stops matching the warehouse. Someone books a manual journal to close the gap. Your physical and system processes have drifted apart, and the cost posting method is often where that starts.
This post walks through how the perpetual inventory method and the periodic method each post to the ledger, where the perpetual method drifts once Cin7 Core, the inventory platform formerly called DEAR Systems, is connected to an accounting system, and what to check this week.
What is the perpetual inventory method?
The perpetual inventory method updates inventory and cost of goods sold (COGS) after every transaction, so the ledger always carries a running balance. A perpetual system updates stock as each sale or purchase happens, while a periodic system updates records after a stock count at set intervals, such as month end.
In QuickBooks, the postings are mechanical. When you buy inventory, QuickBooks debits the Inventory Asset account and credits your bank, credit card, or Accounts Payable account. COGS is debited only when you sell inventory items on invoices or sales receipts, and the Inventory Asset account is credited at the same time.
How does the periodic method post to the ledger?
The periodic method records nothing against COGS during the period and calculates it once, after a physical count. In a periodic system the inventory balance is updated at specific intervals, and COGS is calculated as Beginning Inventory plus Purchases minus Ending Inventory.
Periodic tells you the total at close, not which lines sold. Under periodic you have little insight into your inventory balance during the period, and you are forced to estimate the cost of products sold, which can lead to a large adjustment at the end.
Perpetual vs periodic: what changes in the ledger?
Both methods reach a COGS figure, but perpetual posts it per sale and periodic derives it per period. The table sets the postings side by side for the same five events.
| Event | Perpetual posting | Periodic posting |
|---|---|---|
| Buy stock | Debit Inventory, credit Payables or bank | Debit a temporary Purchases account |
| Sell stock | Debit COGS, credit Inventory, plus the revenue entry | Revenue entry only, no COGS |
| Customer return | Reverse revenue, and restock cost back into Inventory and out of COGS | Reverse revenue only, cost corrected at the count |
| Missing or damaged stock | Visible variance, booked as an adjustment | Hidden inside COGS through the count |
| Period end | Reconcile ledger to the valuation report | Count stock, then post COGS and ending inventory |
The practical difference is when you find out. Perpetual updates as each sale or purchase happens, so a margin problem shows up in the week it starts. Periodic surfaces it at the count.
Which method is right for an inventory business at $1m to $100m?
Perpetual is the right method once you run several channels, locations, or SKUs, because periodic cannot give you a margin you trust between counts. Periodic fits only a small inventory with simple operations, where the cost of implementing perpetual outweighs the benefits.
An inventory business past roughly $1m with a 3PL, a Shopify store, and wholesale orders is no longer in that category. You also do not drop the count. Under a perpetual system you will still need occasional stocktakes to confirm the system is working properly. The count changes from the thing that produces COGS to the thing that tests it.
Where does the perpetual method drift in Cin7 and QBO or Xero?
Perpetual drifts where the two systems post the same event at different moments. Cin7 Core is the inventory sub-ledger, and QBO or Xero is the general ledger, so each sale, receipt, and cost correction can land in different periods.
Symptom, root cause, and fix
| Symptom | Root cause | Fix |
|---|---|---|
| COGS appears in a month you already closed | A landed cost or invoice was authorised after the sale shipped, which creates a second COGS journal dated when the cost was authorised | Authorise the purchase invoice and landed cost before shipment, and set lock dates in both systems |
| Balance sheet matches after a journal, Cin7 still does not | The journal posted in the general ledger but never touched the inventory cards, unit costs, or stock on hand | Trace the difference to the originating transaction in Cin7, then correct it there |
| Margin looks better than the bank account | Freight or duties coded to expenses instead of attached to inventory | Capitalise landed cost to the units it brought in |
| Unit cost edit does not change COGS | The Average Cost field is a display value, not the cost layer COGS is picked from | Fix the receipt or landed cost layer |
Two of those rows come from how Cin7 Core posts cost. When the purchase invoice is authorised after a sale, Cin7 Core generates a Cost Change transaction posting in the current period, and the original sale period keeps the prior cost entry. That is why a closed month moves with no new sale in it. The same pattern appears when a team posts a manual journal in QBO or Xero to force the balance sheet to match: the report looks closer, the Cin7 inventory cards stay untouched, and the original difference returns at the next close.
The costing method adds a second layer. QuickBooks calculates both the Inventory Asset credit and the COGS debit as number of items sold times average cost, while Cin7 Core costs each sale from the purchase cost of the stock that was picked. Two systems applying two costing rules will not agree to the cent, and nobody notices until month-end. Perpetual COGS is only as accurate as the receipts and invoices feeding it. If the numbers still look off, start with why the Cin7 unit cost is wrong.
How do you run a perpetual system cleanly this week?
Run a short weekly routine that checks each posting event and assigns an owner. Each step below stands on its own and takes a bookkeeper or operator under an hour.
- Confirm the posting method in both systems. Check that Cin7 Core and your accounting system both run perpetual, and write down the costing method each one uses so the difference is documented.
- Check open receipts. List purchase orders received but not invoiced, and invoices authorised before goods arrived, since each one will post cost at a different moment.
- Authorise landed costs before shipment. Attach freight, duties, and brokerage to the units they brought in, so the cost reaches the first sale and not a later correction.
- Align lock dates. Set the lock date in Cin7 Core and in QBO or Xero together, because a lock in the accounting system does not protect the same month in Cin7.
- Reconcile the valuation report to the ledger. Compare the inventory valuation report to the Inventory Asset balance and explain every difference by transaction, never by plug.
- Ban plug journals. Write a manual journal policy that requires a traced source before any inventory journal is posted, and review it at each month-end.
- Count to test, not to produce. Run cycle counts against the system quantity and log variances, so shrinkage appears as a line you can see.
Steps six and seven are the governance layer. A system drifts after go-live because nobody owns the discipline. Receiving and invoicing staff need to authorise before shipment, not after, and that behaviour change is part of the fix. Fiskal's inventory accounting service is built on a methodology that ties purchasing, receiving, landing, and shipping to the ledger, and you can take the Fiskal Score separately. If the same difference keeps returning, a reconciliation of Cin7 Core and QuickBooks Online traced to source is the next step.
When should you patch, reconfigure, or rebuild?
Patch when one transaction is wrong, reconfigure when the same error repeats, and rebuild when the method itself does not fit how you operate.
| Situation | Action |
|---|---|
| One-off receipt or invoice error | Patch at the source transaction |
| Same difference returns each month | Reconfigure mapping, timing, and lock dates |
| Periodic books on a multi-channel operation | Rebuild on perpetual with a clean opening balance |
Frequently asked questions
What is the perpetual inventory method?
The perpetual inventory method updates inventory and COGS after every purchase and sale. Each sale debits COGS and credits Inventory at the cost your costing method assigns, so the ledger holds a running balance without waiting for a count.
What is the main difference between perpetual and periodic inventory?
Perpetual posts COGS at each sale. Periodic posts it once after a physical count, using beginning inventory plus purchases minus ending inventory. Periodic shows no COGS entry during the period.
Do you still need a physical count with a perpetual system?
Yes. Occasional stocktakes confirm the system is working. Under perpetual the count tests the ledger, and variances become visible adjustments.
Why does my Cin7 inventory not match my books under a perpetual setup?
The usual cause is timing or a manual journal. A journal posted in QBO or Xero adjusts the general ledger without updating Cin7 inventory cards or unit costs, so the difference returns at the next close.
Is periodic or perpetual better for a growing inventory business?
Perpetual suits a business with several channels, locations, or SKUs, because it gives you cost between counts. Periodic fits only small, simple operations where the cost of a perpetual system outweighs the benefit.


