In this post, we’ll discuss how to create a Cost of Goods Sold journal entry in QuickBooks Online. This is a simple, effective way to stay on top of your numbers and maintain predictable, sustainable profit margins throughout each quarter.
The good news here is that this is much easier than you might expect. We’ll also explore an optional method that can automate most of this process for you! Read on to level up your eCommerce accounting.
A Brief Background to Cost of Goods Sold (COGS)
Before we dive into that Cost of Goods Sold journal entry, it’s worth briefly touching on the nature of COGS to make sure you’re on the right page. Let’s explore the way inventory moves through a business financially.
Good bookkeeping practice dictates that goods shouldn’t be expensed upon purchase. This is a common mistake that can skew your profits and losses statements wildly up or down in a given month.
Instead, your goods should be recorded as assets on your balance sheet and expensed incrementally as and when each unit is sold.
Surprise surprise – this is where the name ‘cost of goods sold’ comes from!
Expensing your inventory this way helps keep your profits and losses statement far more consistent and easy to use. Instead of seeing wild losses in the month that you buy new inventory and inflated gains during the following months, you’ll see a balanced statement that can be used to sustainably predict each coming quarter.
Create a Cost of Goods Sold Journal Entry in QuickBooks Online
There are actually three main ways to achieve this goal:
- The ‘Bucket to Bucket’ method (this blog post’s chosen method)
- Tracking item by item (see this video for more details)
- Using the inventory tool
In this blog post, we’ll be discussing the ‘Bucket to Bucket’ method.
Pros and Cons of the ‘Bucket to Bucket’ Method in QuickBooks Online
- Pro – it keeps your QuickBooks Online file nice and clean without unnecessary entries or distractions.
- Pro – it makes it much easier to validate your data. You’ll be using a spreadsheet and will be able to quickly understand what you’re actually looking at.
- Con – it requires some experience with spreadsheets. Don’t worry, though; it’s fairly straightforward.
- Con – the quantities of your inventory won’t be tracked automatically.
The Method in a ‘Nutshell’
This process of adding a Cost of Goods Sold journal entry looks like this:
- Calculate your Cost of Goods Sold figure
- Use this figure to make a journal entry in QuickBooks Online that moves this lump sum from your balance sheet to your profit and loss sheet.
Confused? Don’t be; it’s actually really simple. This method just needs two data points to work effectively:
- Your inventory figures
- Your Cost of Goods Sold figure
Follow these basic steps to make your journal entry.
Step 1 – Create Your Product Costs Catalog
Check out this oversimplified example of a product catalog below:
|Item||Cost||Quantity Sold||Total COGS|
You’ll want to use your spreadsheet software of choice to create a catalog like the one above for your own inventory. Take the data from whichever channels you’re selling on to input information about how many units you’ve sold over a given time period and how much each unit costs you.
Step Two – Multiply the Cost by SKU X Quantity Sold
To find the right COGS figure for each of your products, you’ll need to multiply the number units sold by the cost of each unit. With just a tiny bit of Excel-fu, this can be set up to calculate automatically.
Follow these steps:
- Type an ‘=’ equals sign in your ‘Total COGS’ column
- Type an ‘*’ asterix symbol
- Click the correct ‘Quantity Sold’ cell for the given product
- Hit your enter key
This will tell Excel, ‘hey, multiply the figure in this cell by the value of the figure in this other cell.’
Next, you can tell Excel to automatically sum up a total for your COGS column. Follow these steps to do this:
- Type an ‘=’ equals sign in the cell directly underneath your COGS column
- Type ‘sum’
- Click and drag to select all of your COGS cells
- Hit your enter key
Excel will now automatically calculate your COGS total!
Step Three – Add a Cost of Goods Journal Entry in QuickBooks Online
To add a new journal in QuickBooks, click ‘New’ and then ‘Journal Entry.’ You’ll now be using the data you’ve just collected to create your COGS entry.
Take your total COGS amount and:
- Add it as a credit in your inventory assets
- Add it as a debit in your Cost of Goods Sold account
That’s it! You’ve successfully updated your profits and losses statement in a way that makes predictions much more sustainable.
A quick note on the method described above – you’ll also want to do semi-regular – let’s say once a quarter – inventory checks and manually adjust any inconsistencies you may find.
A2X – The Optional Extra
Remember when we said you could automate this process? We rave about A2X in several of our videos; it makes a whole lot of accounting processes much simpler.
It’s possible to sync your A2X account with your various eCommerce channels. This means A2X will pull in data about your SKUs that are currently being sold. You’ll see figures for the number of units you have in stock and how many have been sold in a given time period.
All you have to do is enter the cost for each SKU manually and then click the ‘Review’ button. This shows you all the relevant COGS data you’ll need. The blue ‘Resend to QuickBooks’ button will push this information over to your account.
This lets you skip the spreadsheet-making portion of the method we described above. The only manual part of this process is entering your SKU costs!
Some Useful Resources
You may find the following links helpful here:
We hope you’ve found the tips on this page useful. Want to further master your inventory and COGS numbers? Our purpose-built template may prove useful.
And here’s the video to show you how to use it!