Simple inventory entry & tracking in Wave

When you spend time and money to build up a stock of items that you can sell, you have converted cash into an asset known as "inventory." To properly assess the state of your business, it is important your accounts show the value of this asset.

Accounting for inventory, and similar assets such as Raw Materials and Work in Progress/Unfinished Goods is a fairly advanced accounting topic. This article will take you through the basics.

NOTE: Wave does not calculate or track the unit value of inventory for your business - this workaround only works after you've calculated the monetary value of your units.

Create additional accounts

To handle basic inventory accounting in Wave, you need two additional accounts: an Inventory asset account, and a Cost of Goods Sold expense account. Here's how you can create your additional accounts:

  1. On the left hand menu bar, head to Accounting > Chart of Accounts 
  2. Under the Asset account type, click on the Inventory account to add it. On the next line enter the name of this new account. Click Save to create the new account.
  3. Under the Expense account type, click on the Cost of Goods account. On the next line enter the name of this new account. Click Save to create the new account.

Now you have two accounts!

Recording the purchase of inventory

To help explain what to do when you buy and sell inventory, let's go through an example:

Let's say you made a purchase for $100 of Inventory, which in this example, is 'Muskoka Chair'.

If you have imported your bank or credit card transactions, categorize this into an asset inventory account. Each type of inventory should have its own asset inventory account. If you made a bulk purchase for multiple inventory types, you will need to split the transaction.

If you did not connect your bank to Wave, then you can enter it manually on the Transactions page. Click the Add Expense button and enter the amount and details. When you get to the Category section, you want to categorize this into your Inventory asset account.This completes recording the purchase of your inventory.

Recording the sale of inventory

To continue with the example, let's say you made a sale to a customer for $20 worth of Muskoka Chair inventory.

  1. Are you going to make an invoice for this customer and then wait for the payment to appear on your Transactions screen? If so, ensure that you create an invoice payment and match the payment to the invoice.
  2. Or, are you going to wait until that customer's check/cash is deposited into your bank account and imported into Wave? If so, you will need to categorize the deposit as an income (could be sales, or whichever income account you normally use.)

Each time you make an inventory sale and either match to an invoice or categorize this into income, you will also have to record a journal transaction to decrease your asset inventory account and account for Cost of Goods Sold. You will need to use the Journal Transactions tool in the Transactions page - located by clicking the More button. 

From here, you can check your Balance Sheet to verify the balance of your accounts:

Note: These reports are using the 'create invoice payment' option in section A.

Finally, the Account Transactions Report for the inventory asset you created will be the most useful since you will be able to see all purchases and sales.

Was this article helpful?
162 out of 322 found this helpful