Skip to main content

Advanced FBA Inventory Tracking with Amazon’s Daily Ledger

Moishe avatar
Written by Moishe
Updated over a week ago

Until now, ConnectBooks tracked FBA inventory based only on Amazon financial events. That meant inventory updates only happened when money moved—often long after the physical inventory changed.

The Problem with Financial-Based Inventory

  • Lost/damaged items were only removed after Amazon reimbursed you, even if they went missing months earlier.

  • Refunds added items back immediately, even if the return hadn’t arrived.

  • Disposals and removals weren’t tracked at all because they had no financial transaction.

As a result, your inventory reports didn’t reflect the true state of your FBA stock.


What’s New: Advanced FBA Inventory Tracking

ConnectBooks now uses Amazon’s FBA Ledger Report to track inventory based on actual movements—not just financial events.

How It Works

Daily Inventory Accuracy

  • Orders still reduce inventory immediately.

  • Other changes (like returns, losses, damages) are pulled daily from Amazon’s ledger.

  • Changes are recorded using the actual date the inventory movement occurred.

Example:
If Amazon receives 10 returned units on January 1, ConnectBooks records the return for January 1, even if we get the FBA ledger report on January 2.

Better Tracking of FBA Adjustments

When Amazon adjusts inventory (due to loss, damage, etc.), ConnectBooks now logs it as an FBA System Adjustment—based on actual quantities.
​Reimbursements no longer affect inventory counts.

Clear Separation from Financial Events

  • Inventory is now updated based on physical movements from the FBA ledger.

  • Financial transactions (like reimbursements) do not change inventory counts anymore.

This makes inventory tracking much more accurate.

To enable the new system:

  • Contact ConnectBooks Support.

  • Choose a start date (we recommend January 1, 2026).

  • All data on the reports from that date forward will use the new system.

  • Reports before that date will continue using the old method.

Note: The system cannot apply to any data before you joined ConnectBooks.


New Support: Disposals & Removals

These were previously untracked. Now:

  • Disposals (items Amazon destroys) are removed from inventory.

  • Removals (items returned to you) can be handled in flexible ways.

If You Use ConnectStock

You can choose how to handle removals:

Sellable Removals:

  • Remove(dispose) from inventory by creating an adjustment, or

  • Move to a separate “Sellable Removals” warehouse

Unsellable Removals:

  • Remove(dispose) from inventory by creating an adjustment, or

  • Move to an “Unsellable” warehouse

If You Don’t Use ConnectStock

You can still choose how to handle removals by setting whether each item is Sellable or Unsellable.

For both types, you can then decide to:

  • Remove the item from inventory entirely, or

  • Leave it in inventory


Set Up FBA Warehouses in ConnectStock

If you're using ConnectStock, you can create separate warehouses to accurately track your FBA Sellable and Unsellable inventory.

  1. Create Beginning Adjustments
    Use the Bulk Adjustment feature on the ConnectStock Adjustments page to enter your starting inventory from your chosen start date.

  2. Assign Inventory by Type

    • Set FBA Sellable inventory to the default FBA Warehouse

    • Set FBA Unsellable inventory to a newly created FBA Unsellable Warehouse

  3. On the Inventory Files settings page, assign each inventory type to the correct warehouse .

These settings apply moving forward only. For backdating, contact ConnectBooks support.


Quick Comparison Chart

Event

Old System

New System

Orders

Inventory reduced immediately

Inventory reduced immediately

Refunds

Units added back right away

Units are added back when FBA receives it

Lost/Damaged/events

Adjusted only if reimbursed

Adjusted based on actual FBA ledger data

Disposals

Not tracked

Removed from inventory

Removals

Not tracked

Sent to FBA Removal warehouse or adjusted as a loss

Financial Events

Affected inventory counts

No impact on inventory counts

Note: This applies only to FBA inventory. All other inventory behavior remains unchanged.

Did this answer your question?