As all good business owners know, the key to accurate financials is accurate data. What goes into those numbers determines what your financial reports are going to tell you. You want to ensure that you’re getting an accurate picture of your business’ current health.
One thing I talk about quite often is cash on hand. While on paper, it may seem that your cash on hand is plentiful, your bank balances may reflect something different. There’s a disconnect going on here. But where? And how can you avoid it?
Why the disconnect between cash on hand and your financials?
Many ecommerce sellers have this very concern. According to the Amazon accounting software they are using, they are making money, but somehow, they never seem to have enough available cash. They ask themselves, “How can this be right?” My answer? It’s not. There may be several reasons for this disconnect, but the three most common seem to be:
- You may not fully understand the various Amazon fees and deductions that are taken out before the payout is sent to you.
- You may not completely grasp how the bookkeeping software for Amazon Sellers tracks your product costs.
- Perhaps your software isn’t being maintained adequately enough to ensure the most current product costs.
Let’s break it down and find some answers!
You need to understand what happens with your money before Amazon sends your payout to you. Amazon bookkeeping or Amazon FBA bookkeeping should provide you with the information you need to do this. Simply recording the deposits on the books as income isn’t enough. You need to read your settlement report carefully, paying close attention to the activity that ends with the amount of the payout. All that activity should be recorded as you enter the deposit into your books. Systems like Inventory Lab obtain the information directly from Amazon, so you can easily see it.
As Amazon accountants, we also want to see this info in your financial reports. When working on our clients’ books, our team at bookskeep creates a recurring deposit template in both QuickBooks Online and Xero that is pre-populated with the accounts typically found on the settlement report. Whenever we record a deposit, we simply open the template, add the appropriate numbers and record the deposit. When we review the monthly Profit and Loss Statement, we can compare it to previous months and see how each of these activities is tracking. These activities or costs include such items as promotional rebates, shipping, refunds, and even gift wrap credits. If there are any significant changes between months, we know we need to dig in and find out why.
Know your product costs.
Tracking your product costs is a big challenge for Amazon sellers. The first real challenge is knowing exactly what’s included in those costs. Typically, product costs include the direct purchase cost of the product, along with any additional labor required to get your end product to market. Activities such as bagging, labeling, and other preparation, including the costs of the labels and bags would all be considered part of your product costs. These should be calculated on a per-unit basis, and when all the costs are added together, this will be your product cost that you then add into your Amazon accounting or inventory management system. Just a note here that because shipping costs vary so much between shipping methods and fuel surcharges, we don’t recommend that they be included in your product cost. Our blog on Freight and Shipping Costs can provide you with more details on this. Instead of adding the shipping costs into your product costs, it’s better to use that as part of your Cost of Goods Sold and to true up your inventory account, which we suggest you do at least on a quarterly basis.
Update, update, update!
Finally, it’s really important that you make certain your costs are being updated in your software anytime there is a change. If you simply set it up once and forget it, you’ll find yourself in that place of not knowing where your money has gone. It’s also important to keep your software updated, too. It’s easy to forget this critical step, so work to make it a habit to review your inventory by cost on a monthly basis to see if you have any zero-cost products. If you do, update it so you’ll have numbers that accurately represent your inventory and the Cost of Goods Sold. Completing this one important step will help keep you from thinking you are more profitable than you actually are.
Amazon accounting software systems can play an important role in helping you manage your day-to-day business, but they cannot replace a true accounting system such as QuickBooks Online and Xero. The main benefit of true accounting systems is the Balance Sheet capability. The Balance Sheet allows you to monitor the overall health of your business across time, not just the Profit and Loss for the current year. With the Balance Sheet, you can track your long-term value of Cash, Inventory Assets and Liabilities, and Equity accounts. These systems are reconciled back to statements provided by outside financial institutions, which is a must to ensure you are receiving accurate information from your financial data.
Interested in Profit First?
You can also sign up for the Profit First for Ecommerce Sellers Online Course. As a Mastery Level, Certified Profit First Professional, I will teach you why Profit First works so well for ecommerce businesses and the particular challenges for businesses that have physical products requiring inventory management. You will learn how your behavior drives your money management habits for your business and how you can set up your business bank accounts to work with your habits.
Check out all our ecommerce accounting and profit advising services here!
Leave a Comment