Hi everyone, I hope you all survived Seller Central being down last night. My Yahoo email account was also down and between the two not working, I was unable to respond to Amazon’s request for more documentation as part of the Health and Beauty approval process. I’m happy that everything was up and running this morning and that I was able to send in my receipts. I hope that they let me know later today if I’m approved or not.
In today’s post, I am going to show you my Balance Sheet that I generated in QuickBooks Online. The Balance Sheet shows your assets, liabilities and equity at a specific point in time. Granted with FBA, there aren’t a lot of accounts to worry about, but it’s good to know information such as:
- how much money do you have in your checking account?
- how much money do you have invested in unsold inventory?
- how much did you borrow to finance your inventory and supplies?
- how much sales tax did you collect and still need to pay to the states?
Unfortunately, a Profit and Loss Statement isn’t going to answer those questions. That is why a Balance Sheet is important so you know how much you have and how much you owe at a given time.
Before I show you my Balance Sheet, I will put in my disclaimer that I’m not a professional bookkeeper or accountant. However, I did do my books for my former business in a similar fashion and never had any complaints from my accountant.
Finally, here is my Balance Sheet:
I know that my Balance Sheet shows a date of September 24, 2014. But unfortunately, not all of my accounts are up to date. My Inventory, Amazon FBA and Net Income accounts do not reflect any sales or inventory adjustments since my last Amazon payday on Sept 17. For the purpose of this post, my actual numbers aren’t important. My reason for writing this post is to share with you what a Balance Sheet looks like and to show you the accounts that I’m tracking. My end of the month numbers will always be accurate after I enter my monthly accrual entries. With that said, here are my accounts:
Checking Account: This is a free business checking account that I opened in June at my credit union. Amazon deposits my payouts into this account and I have my monthly subscriptions deducted from here. The plan is to keep a minimum of $100.00 in this account at all times.
Inventory: I am using this account to track the dollar value of my unsold inventory. So, if I buy $100.00 of inventory, the value will go up by $100.00. When I sell something, the cost that I paid for the product sold gets transferred out of inventory and listed as a COGS expense. However, that doesn’t happen automatically as this version of QuickBooks doesn’t have an inventory tracking system. I track my inventory and COGS amounts in Excel and then make manual adjustments in QuickBooks.
Barclay Credit Card: This is a new credit card that I opened earlier this month. It is to be used for Amazon FBA inventory and supply purchases only. It has a 0% interest rate for the first year and gives me cash back on my purchases. I will pay off my balance every month so that I don’t go into credit card debt.
Loan – Poisson: When I started FBA, I bought supplies, inventory, training materials, etc. using money from my personal accounts. I treat these amounts as a loan from myself that needs to be paid back. I owe myself $1135.94 as that is what I have used so far to get my FBA business going. I am not charging myself interest and will start to pay myself back in monthly payments beginning in January 2015.
Sales Tax Payable: This is sales tax that I collected but have not yet paid to the states. This is because some of my returns are due quarterly and annually. It’s important to know how much you owe so that you don’t spend that money and not have it when it’s time make your tax payment.
Amazon FBA: This is where I track the money that I owe to Amazon. This is for all of those fees that Amazon charges, such as the monthly professional fee and the inbound shipping fees. For example, if I were to ship inventory to Amazon today and my shipping fees were $10.00, I would put the $10.00 into this account. That $10.00 will get paid to Amazon in October when they deduct it from my next payout.
Equity – Net Income
This is my running profit or loss total since starting FBA on April 30, 2014. This is the same number that shows on the bottom line of my Profit and Loss Statement for the same end date.
A Few Final Thoughts…
I hope that this post helps demonstrate that a Profit and Loss Statement doesn’t give the whole story. If you look at my income report that I posted here, you wouldn’t know how much I have to spend in my checking account or how much inventory that I still have sitting around waiting to sell. It doesn’t show you much money I borrowed to finance my expenses or how much I owe in sales tax.
Some may wonder why I’m posting my numbers especially when they aren’t the most motivating numbers. Well, I just want to share how I’m doing with FBA and I hope that my experiences may help others. I know that I’m not moving ahead at the fastest pace, but I am moving forward each day.
If you are undecided on which bookkeeping system to use, keep in mind that GoDaddy Bookkeeping does not have the Balance Sheet Report (at least it didn’t when I tested it last month). That is one of the main reasons why I chose QuickBooks over GoDaddy. However, if you prefer not to use QuickBooks, you can still keep track of your balances with an Excel spreadsheet.
I hope you enjoyed this post and if you have any questions, please feel free to ask me in the comment section below.
Featured Image: © alexskopje – Fotolia.com
Picture of Balance Sheet: Diana Poisson