As a small business owner, the thought of setting up a bookkeeping or accounting system can seem daunting. However, good financial data is vital to your business success, and setting up a bookkeeping system can actually be quite simple.
There are many online accounting programs available today. QuickBooks is my favorite. QuickBooks is perfect for the very small businesses all the way up to the very large and sophisticated businesses. It’s easy to use, but it can grow with you as your business expands. Let me show you how easy it is to get started with QuickBooks. (This post does contain affiliate links for products I use and highly recommend.)
Get Started with QuickBooks
I recommend beginning with the Simple Start version of QuickBooks online. It has all of the main features you will need to easily keep your small business bookkeeping records. If your business grows, and you need additional features, you can always upgrade to a higher level QuickBooks program. When you upgrade, all of your old data comes with you, you don’t lose a thing. Unfortunately, you can’t downgrade with QuickBooks. So don’t rope yourself into a higher monthly payment when you are just starting out. I do not recommend using QuickBooks Self-Employed. It’s missing some important features and saves you very little in monthly fees.
You will have a much simpler time completing your small business bookkeeping if you have followed my advice to keep your business financial transactions separate from your personal. You can find information on that topic here.
#1 Connect your Financial Accounts
Once you have signed up for QuickBooks Simple Start the first thing to do is to connect your business bank accounts and credit cards. Once connected, all transactions going forward will immediately be imported, saving you lots of time manually inputting information. You can also import past transactions from up to 90 days ago.
On the right-hand side, click the button, Connect Account, shown below with the big pink arrow!
Once you click the button, it will bring up this screen for linking to your financial account. Simply type in the name of your bank or credit card company. You will follow prompts to enter your login information. If given the chance to import data from the past, go as far back as you need.
Do this same process for all of your business bank accounts; including checking accounts, credit cards, or PayPal accounts.
QuickBooks will begin to import transactions from these accounts.
Once the data is imported, on the home page, click on one of your financial accounts. It will bring up that accounts bank feed and should look something like this.
In accounting, each transaction has two sides, this is called Double Entry Accounting. We already know the one side, it’s the bank or credit card account that the transaction occurred in. Now we have to assign the account to the other side, in most cases a revenue or an expense account. In accounting speak, we call this coding.
#2 Create Custom Account Names
QuickBooks comes with pre-created revenue and expense accounts you can use, or you can create your own. All of these accounts comprise your Chart of Accounts and will be the line items on your financial statements. Each account has a type, for example, Expense or Revenue. It may be tempting to always use the account names that QuickBooks gives you, but I would encourage you to use your own where appropriate. The point of bookkeeping is to have financial data that helps you make decisions for your company. The financial data should make sense to you, and be presented in a way that helps you in your decision-making process.
If you have several distinct areas of your business, you will want to see that broken out in your financial statements. For example, you could create expense accounts called Etsy – graphic design and Blog – graphic design for graphic design expenses, rather than lumping all such expenses under a general category QuickBooks provides such as Office Expenses. Don’t go too crazy, but create accounts that make sense to you. In the same way, instead of lumping all revenue in one account, you could separate your revenue by type Etsy Sales, Blog Affiliate, Blog Advertising, etc. Structure and name your accounts in a way that makes sense to you.
You can create your own name for accounts in one of two ways. Later in this post, I will show you how to add your own account names as you go along. If you want to set up a bunch of your own account names from the beginning you do that in your Chart of Accounts. You can find your Chart of Accounts by clicking on the gear icon in the top right corner. This post on chart of accounts shows you exactly what to do.
Need help setting up your chart of accounts in QuickBooks? I’ve created video tutorials and a customized Chart of Accounts you can upload for Etsy, Shopify, and Amazon.
#3 Coding your Transactions
The great thing about QuickBooks is that it can learn from your coding, and remember where to code future transactions for you based upon the vendor. In the list of transactions pictured two screenshots above, you will notice some accounts in green. These are accounts that QuickBooks has remembered from the last time I coded a vendor expense there. If that account still makes sense, I can click the Add button on the right, and that transaction will be done. It has been properly coded and you will see it disappear from this screen. This screen is basically the holding area for transactions that still need to be coded.
Some of the accounts show a gray account name. This is the QuickBooks suggested account, but it is not a remembered transaction. This may be the first occurrence of this vendor, and QuickBooks makes a guess as to where it should go. If you like their account, you can click add and be done.
Chances are, at least at first, you won’t like their account. So click on the transaction to edit the account it is coded to. In our example, the purchase from Online Labels is being coded by QuickBooks to Commissions and Fees. This is not what we want.
Our first option is to use the drop-down menu to give us all the choice in our chart of accounts. In our example, Shipping Supplies is the appropriate account to code this transaction to. Shipping Supplies is an account already created, so we simply find it in the list, select it, and hit the Add button.
If you don’t like any of your account choices in the drop-down list, you can name your own account. Start typing what you want the account to be. Remember, account names should help you. Just start typing the account name you would like to use in the box. This is how we can add account names as we go along. I typed Etsy-Shipping Supplies.
And then hit the plus sign to create that account. After you hit the plus sign, you will be brought to a screen like this.
QuickBooks already knows we are trying to add an expense account. The only field it makes you select is the detail type. Don’t waste a lot of time wondering about this one, just select the type that seems to make the most sense to you. Once you’re done, hit Save and Close. You have just created a new account!
Once you have the right account selected, either from the list or naming your own, simply click ADD. Now that transaction has been coded and is done.
You’ll notice when you are editing a transaction, there is a little sentence underneath the account that says “We’ll set VENDOR to NAME OF ACCOUNT from now on.” This is QuickBooks telling you that they are going to memorize that account coding. If you are not happy with that, click the Edit Setting button to make an adjustment. Most of the time, having QuickBooks remember your transaction is exactly what you want!
Go through all of your transactions until everything has been coded. When everything in this account has been coded. Head back to your home screen, and go through the same process for the next financial account until you are all done.
In our example, we coded an expense. Coding revenue accounts is exactly the same. Notice that there are two columns of dollar values in each register. The left is for the expense, the right is for the revenue. Code your revenue in the right-hand column just as you would your expenses, but choose revenue accounts from your chart of accounts.
As you code each transaction you are creating financial reports of your records. Who knew creating a Balance Sheet and an Income Statement could be so easy!
The sooner you set up your small business bookkeeping system the better! Cross this item off your list now! Get started with QuickBooks, it will make your business life much easier!
Need a little more bookkeeping help? Check out my tutorial videos on YouTube. I also offer monthly bookkeeping services for Etsy sellers.