FeedStation
Why FeedStationIntegrations
SOLUTIONS
Feed ManagerVirtual WarehouseAutomotive FitmentCustom IntegrationsConversions & Migrations
PRICINGBLOGFAQSchedule a demo
Operations

eCommerce Accounting: Lessons and Pitfalls

Feb 18, 2021
HomeBlogOperations
eCommerce Accounting: Lessons and Pitfalls
T

ax season is upon us. And with tax season comes a lot of work for eCommerce sellers as they siphon through the prior year’s finances to settle expenses, categorize sales data, and analyze profitability. While accounting is a major endeavor for all businesses, sellers leveraging marketplaces like Amazon, eBay, and Walmart are up against some very specific challenges.

Many online sellers let accounting fall through the cracks for too long. It’s important to remember that poor accounting will give you inaccurate financial data. The result? Poor decision-making and a false sense of how your business is performing.

But where to start? And why is accounting so hard for sellers leveraging marketplaces like Amazon?

After working with Amazon sellers, we want to highlight two key areas that often lead to trouble in accounting: Sales Data and Inventory/COGS control.

Gathering Accurate Sales Data

When Amazon revenue hits your bank account with a deposit every two weeks, that deposit offers no insight into the breakdown of fund sources. Especially if you are using Amazon for shipping and warehousing, there are a lot of activities going on in your seller central account. The deposit that hits your bank account does not account for when each activity took place. You will only see the net deposit on the date that you receive that deposit. Period. Further compounding the problem, deposits include all other activity in your Amazon seller accounts such as FBA fees, shipping fees, warehouse fees, sales tax, returns, and chargebacks.

To address this problem, sellers are forced to reconcile financial data themselves. This usually means going into the back end of your Amazon seller account, pulling all the data into a spreadsheet, sifting through the data, and accurately accounting for the data for each line item within your accounting software. If you are using accounting solutions such as Xero or Quickbooks, this can help. But it still doesn't scale well.

When FeedStation works with customers, we address financial reconciliation at the order level by default. Data is typically pushed into our customer's accounting solution to include information like cost (which is incredibly helpful for dropshipping), shipping fees, and marketplace fees (including FBA adjustments).

The result? An easier tax season, less bookkeeping, and most importantly, elevated decision making.

Inventory and COGS Control

Inventory and COGS errors are one of the most common (and problematic) accounting challenges for Amazon sellers. Errors typically begin occurring when inventory is purchased. Often, companies will immediately record the cost of purchasing that inventory as a cost of goods. If your cost is recorded outside of the period in which it is sold, it can lead to a lot of confusion and discrepancies, which directly impact your balance sheet.  For example, purchasing $100K in inventory may show a $30K loss in January, a $40K gain in February, and a $30K gain in March. While this is reflective of how cash is moving through your business, it does not accurately reflect the performance and profitability of the business.

The inaccurate recording of COGS and inventory becomes more detrimental as your business grows. You will get lost on how your business is truly performing, and the value of your assets will be inaccurate.

So, how do you accurately record COGS and inventory? For COGS, there is an accounting rule called the matching principle. This states that expenses are matched in the same time period as associated revenues. In other words, COGS should not be recorded until you sell an item. As an Amazon seller, this will require you to:

  1. Look up quantity sold for each SKU
  2. Multiple the quantity by SKU cost
  3. Record this amount as COGS

To use matching principles correctly, you should also have an ending inventory balance for each month. When you purchase inventory, the amount of inventory you purchased should be added to your inventory balance. Then, each month you subtract your COGS from your inventory to get a new inventory balance.

While simple in theory, it can get a little complicated as you add more SKUs to your portfolio and will inevitably require automation. At FeedStation, many of our customers choose to automatically update COGS and inventory information throughout the system. Once we can pull the cost of each SKU (from wherever that data lives) we can run profitability equations based not only on the item, but on each channel.

Don’t wait on elevating your accounting practices.

No one loves spending time with accounting, but (steps on soap box) you need to start making investments right away in organizing your financial records. Accounting is more than just filing your taxes. It's the lifeblood of eCommerce sales and will help you make critical decisions for where to invest (and not invest) in your business. Marketplaces like Amazon don’t make it easy, but we are here to help.

Schedule a demo
SCHEDULE A FREE consultation
Tagged:
Guides
About THE Author
Lauren McCullough

See All Posts
Featured Posts
Hacks
Reconciling Invoices with Suppliers
Channels
SEO Strategies for Automotive Aftermarket
Operations
Selecting Your Distribution Partners
Channels
Repricing: Your Competitors Are Doing It, Are You?
Channels
Walmart eCommerce grows 97%. Should you get onboard?
Operations
Top 5 eCommerce Trends for 2020
Channels
Shopify's Amazon Sync Problem
Hacks
The Power of Proactive Reporting
Stay in Touch

Subscribe to our newsletter to receive new posts straight to your inbox 👇

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
More Posts

You Might Also Like

Should you leverage Amazon's MCF program?
Amazon's Multi-Channel Fulfillment (MCF) gives selected sellers access to Amazon’s world-class fulfillment network, providing direct fulfillment in unbranded packaging for non-Amazon-generated orders with the same competitive shipping rates and delivery speeds. But is MCF the right next step for your company?
Nov 22, 2021
Lauren McCullough
Hacks
Reconciling Invoices with Suppliers
Are you being incorrectly charged by your suppliers? If you aren't already reconciling your invoices, you may be leaving thousands of dollars/month on the table.
Sep 14, 2021
Operations
Leveraging Kits and Bundles
What Is It kitting? How does it work? Should it be part of your busienss? This article will help you understand the benefits of adding kits and bundles to your eCommerce store.
Aug 10, 2021
Nicholas Courtney
Channels
SEO Strategies for Automotive Aftermarket
SEO is critical for the growth of online sellers in the automotive aftermarket industry. But how do consumer search patterns impact your business?
Jun 27, 2021
Lauren McCullough
Operations
Selecting Your Distribution Partners
Are you ready to expand its supply network? Check out FeedStation's scorecard for selecting the best fulfillment partner to meet your company's needs and requirements.
Apr 21, 2021
Lauren McCullough
Channels
Repricing: Your Competitors Are Doing It, Are You?
Repricing is hard, but every company needs a strategy. Not managing your pricing can have serious repercussions - set your price too low and you lose conversion, too high and you kill your profit margin. There are many tools to help optimize your specific pricing strategy. It doesn't have to feel as complicated as it is.
Mar 15, 2021
Lauren McCullough
Explore ALl Posts
FeedStation
PricingBlogFAQPRIVACYCareersContact US