Just-in-Time and Your Amazon Business

If you’re a new InventoryLab user or just wondering whether it can help you manage your business more successfully, you may be wondering what the benefits are of integrating with Amazon and how to use IL with inventory listed outside of Amazon. Today we’re answering those questions!

We have the ability to use Amazon’s MWS (Marketplace Web Service) API to pull a lot of data from our user’s Seller Central account to fill in their inventory and accounting details automatically. This is displayed in a user interface that is easy to navigate, and all data in our applications can be exported to give you further options for separation or sorting of data.

Some examples of the data we automatically sync from the Amazon API are:

-Refunds and associated fees

-Reimbursements and the associated income and expenses generated with them

-Removals and Disposals

-Sales Data and associated fees and credits

The MWS also allows our users to use our program to easily scout and list items in a streamlined and efficient application. You can find much more information in our “What Does Just-in-Time Track?” article.

Using IL With Inventory Outside of Amazon

Unlisted Inventory

Did you know that you can even use InventoryLab to input and track inventory that’s not listed on Amazon? You can use our Unlisted Inventory feature to do this. By using tags in Unlisted Inventory, you can not only indicate which marketplace inventory is being listed on, you can also track storage locations or seasonality to avoid having to pay Amazon’s long-term storage fees. This will help you determine when you want to ship the items to Amazon’s Fulfillment Centers to maximize storage savings.

There is also a ledger feature to add or subtract inventory with a note describing what happened to it (for example: the item sold on eBay, order #12039891).

Tracking Income

You can use the ‘Other Income’ accounting page to add in income from other marketplaces manually or by .CSV import if the other marketplace offers a statement in .CSV format such as eBay.

Tracking Expenses

Just like tracking income, our ‘Other Expenses’ accounting page can be used to add in expenses from other marketplaces manually or by .CSV import if the other marketplace offers a statement in .CSV format.

Both the income and expenses tracked in the above pages go to your Profit & Loss report. You can create categories specific to each marketplace for your income and expenses, and the Profit and Loss will show them as a line item on the Profit and Loss for easy comparison or separation.

The Financial Perspective – Keeping Buy Costs Up to Date

At InventoryLab, we allow you to add multiple buy costs to your MSKUs. We apply these buy costs in FIFO order by purchased date to your sales and any other transactions in which you need to account for your buy cost.

You want to make sure you’re keeping these costs up to date to make sure you have the most accurate data in your reports and Profit & Loss. By having these costs entered for your inventory, it also allows us to make the proper adjustments to your Cost of Goods Sold in the case of Returns, Reimbursements, and Removals & Disposals.

Your profitability reports will be the most accurate when you have buy costs entered into inventory, as that data will then be used to calculate the true profitability of your products after refunds are taken into account.

The Inventory Valuation report uses cost data so that you can see the value of your in-stock and in-transit inventory, along with your Unlisted Inventory, for any given day as long as you were a subscriber as of that date.

Happy Selling!

Share this post

Leave a Reply

Your email address will not be published.