Guide to Your Ecommerce Chart of Accounts - Your Balance Sheet

May 30, 2022

Your how-to guide to get the best chart of accounts for your ecommerce balance sheet.

Your how-to guide to get the best chart of accounts for your ecommerce balance sheet.

Every DTC brand is justifiably concerned with their profit & loss statement (P&L). At the end of the day, you need to know if your ecommerce business can turn a profit. But, don't underestimate the powerhouse of knowledge the balance sheet can be if you know how to use it.

The balance sheet shows you (and your lenders / investors) if your company has sufficient resources (like cash) to operate the business and pay off of its debt.

For example, let's say you have 2 businesses with identical net income. You self-funded Company A by investing your savings of $70k and didn't borrow a penny. To fund Company B, you borrowed $70k from friends & family and you have to pay them back with interest. 

Looking only at the P&L tells you they are equally financially healthy. The balance sheet is the report that can help give you the full picture.

We previously covered how to create the best chart of accounts for your P&L. In this post, we'll walk you through the best chart of accounts (CoA) for your balance sheet so you can squeeze out the most value.

 

What Chart of Accounts should I use for my ecommerce company?

Our CoA is based on best practices after years of working with various DTC brands like yours + extensive experience in accounting and tax. It's been through rounds of due diligences and reviews.....so it's tried and tested :)

Our CoA has more than 300 accounts to give you real data insights into your business. We won't include all 300 accounts here (you're welcome) but we will show you the key accounts and breakdowns we use for our customers.

 

Current Assets

1. Bank accounts

Your bank account section should include all bank accounts and digital banks used for the business. Examples of digital banks include Paypal, Payoneer, and BlueVine.

A note about Paypal: Paypal can function as a payment service provider (PSP) for your online store and can also act as bank. Cash is often transferred from your bank account or credit card to Paypal or from Paypal to your bank account. Make sure your Paypal transactions are not double-counted by treating these transactions as transfers and not as expenses. 

With Finaloop, we'll automate this process for you so you can be sure your transactions are not double-counted.

2. Undeposited funds

Undeposited funds are funds you already earned from sales but haven't yet been deposited into your account from your PSP. Tracking this amount is important for understanding your expected cash flow and for making sure your income is correct for tax purposes.

Finaloop integrates with your various apps and PSPs and syncs this data real-time. If you are doing your own bookkeeping or using a bookkeeper, make sure this information gets added each month.

3. Accounts receivable

This should include any wholesale invoices you send to your wholesale customers or other income sources you expect to receive in the future.

 

4. Inventory 

If you are a manufacturer, like many CPG brands, you may prefer to track your inventory in 2 separate accounts - one for supplies & materials and the other one for finished products. As a reseller, you may prefer to track everything in one inventory account.  

There is A LOT to consider about the best ways to track your inventory and COGS. You can read more about accounting for ecommerce inventory here.

5. Loan receivables

For loans from related parties, the IRS has pretty specific conditions you need to meet to treat them as loans and not investments. One important condition is charging interest.

If you have related party loans (for example, from you to the company) that are over $10k, we recommend speaking to a professional, like Finaloop, to make sure it gets treated correctly.

6. Other current assets

 

Long Term Assets

1. Net fixed assets and intangible assets

Fixed assets and intangible assets are long-term assets used in your business with a useful like of more than 1 year. If you own these types of assets, make sure you are depreciating or amortizing them correctly to avoid issues from the IRS.

Fun fact: If you purchase a fixed asset for $2,500 or less, you can take the full expense this year rather than treating it as an asset and depreciating it over a few years.

2. Other long-term assets

 

Current Liabilities

1. Credit cards

Your balance sheet should include all credit cards used for your business. 

Note that if the credit card is used for the business but is actually a personal card in your name or another person's name, the treatment can be a bit different.

2. Accounts payable

We recommend to only include net term bills as accounts payable (e.g, amounts owed to your vendor). No need to add an accounts payable for each upcoming payment.

3. Deferred revenue

This section covers income you received but have not yet earned, such as an upfront payment from a wholesale customer or a gift card purchase in Shopify.

4. Loans

Many ecommerce loans or financing arrangements, like merchant cash advances, have different accounting or tax treatment than traditional loans.

Here are the links to learn more about Shopify Capital, Amazon Lending, and Clearco. In the accounts below, we included some common examples our customers use so you get an idea of what the loan section may look like for ecommerce.

5. Other current liabilities

 

Long-term Liabilities

Long-term liabilities are debts you owe that you don't need to pay for at least 12 months.

 

Equity

Equity can be quite confusing and is treated differently for different entity types.

You should consider both the type of legal entity you are - a sole proprietor, LLC, partnership, or corporation - and the type of tax entity you are - Schedule C filer, partnership, S corporation, or C corporation - to make sure your CoA can track all the details you need for your business and for your taxes. 

Below are examples of different equity sections for different type of entities. 

*Assumes S corp is an INC and not an LLC.

The bottom line

Setting up the right chart of accounts for your ecommerce business creates an opportunity to get real value from your financials.

If your looking to get your financials custom tailored to your ecommerce business, see if Finaloop can help. 

 

About Finaloop

We are a technology company providing automated end-to-end accounting service to ecommerce businesses. Our system connects to your apps, syncs all your data and reconciles your books in real-time, replacing your bookkeeper. We offer reconciled books available 24/7, tax-saving insights, and a single place for all your financial data.

*The information provided on this website does not, and is not intended to, constitute legal advice. All information, content, and materials available on this site are for general informational purposes only. Readers are advised to consult with their attorney or accountant with any questions or concerns.*
Finaloop logo
Excited to do your bookkeeping? Didn't think so.

That’s what we’re here for.
Accurate ecommerce books, done for you.

100% accurate ecommerce books, available 24/7.

Finally, you can focus on everything else.

Get started
14-Day Free Trial
No Credit Card Required