Basics of Creating Accounts
Before you begin with keeping track of your transactions, it is important to first decide what accounts you wish to keep track of. There must be enough accounts
to record each transaction you make. By virtue of making these accounts, you can see how the balance in these accounts change due to the logging in of journal
transactions.
As mentioned in Introduction, there are six types of accounts: assets, liabilities, revenues, expenses, owner's equity (DR), and owner's equity (CR).
Again, assets are what you own and liabilties are what you owe. Revenue is when you profit and money enters your business. Expenses are bills you have to pay,
causing money to leave your business. Finally, owner's equity (DR) represents accounts of both drawings and dividends, which is when the owner or shareholder
takes money out of the business for personal reasons. Of course, by virtue owner's equity (CR) represents the net worth of the business.
In GridTracks, all accounts must have both an account ID and an account name, as well as an account type as listed above. It is optional to assign a starting value
to an account. Typically, your accounts will have a starting balanace before any transactions are applied,and this would be the place to input them. Please ensure
that the debit balances and credit balances of the starting values must be balanced as well. As all journal transactions must also be balanced, unbalanced starting
values cannot be corrected, which is why balancing is so important.
Note that GridTracks will only accept account IDs between 1 and 9999 inclusive. Because GridTracks sorts accounts by their account ID, it is important to pick your
IDs accordingly. Below are the typically ranges per account type, but you can obviously pick to your discretion.
Account Type |
Suggested Account ID Range |
Asset |
1000-1999 |
Liability |
2000-2999 |
Owner's Equity (CR) |
3000-3999 |
Revenue |
4000-4999 |
Expense |
5000-5999 |
Owner's Equity (DR) |
6000-6999 |
When you are making your accounts, please space out your account IDs by at least 10 unit incrememts. What I mean is do not create account IDs 1000, 1001, 1002, etc., and
instead, try 1000, 1010, 1020, 1030, etc. This is because GridTracks orders accounts by their ID, so if you want to squeeze a new account between two existing (like ID 1005,
which is between 1000 and 1010), you won't have to renumber all subsequent accounts after.
Adding/Editing Accounts in GridTracks
When you start GridTracks, you are greeted with this Welcome page. Note that here I have a file opened titled July2021.gdt.
Click on the area highlighted to go to the Accounts page, where you can begin adding/editing accounts. You will be taken to the page below:
Notice highighted in red the "Add Account..." and "Edit Account...". Either will open the respective dialog boxes below:
The only difference between the two is the title of the dialog, as well as the fact that GridTracks will fill in the boxes depending on saved account data.
On the left side of the Accounts page, notice the pane. Here, there is a list of all accounts in your document. Clicking one will make it the active account, and the
pane on the right will show all account entries of that account (account entries, which come from journal transactions, will be discussed later). Hitting the Edit Accounts
button will only edit the active account.
Furthermore, the Filter Box will allow you to text-filter what accounts you wish to see in the list of accounts. Finally, clicking the "Modify Accounts…"
button will take you to the page below:
Here, you can also add/edit accounts as well, with more of a bird eye's view. I recommend this mode for when you need to multiple accounts at a time, as it shows
the account ID, name, starting value, type, and current value of all accounts at once.
What Accounts Should I Add?
Note that the table below discusses the various types of accounts you can create for your GridTracks document. Please feel free to pick and choose whichever accounts are best
for your own business.
Note that most of the accounts are their descriptions were inspired by the book "Bookeeping for Canadians for Dummies" by Lita Epstein and Cécile Laurin.
(Epstein, L., & Laurin, C. (2019). Bookkeeping For Canadians For Dummies. Hoboken, New Jersey: John Wiley & Sons, Inc.)
Account Type |
Possible Accounts to Add |
Assets |
Assets can be broken down into Current Assets, as well as Long Term Assets. Current assets are those that you will use
within 12 months, while Long Term Assets are those that are there fort longer than 12 months.
Current Assets
-
Cash in Chequing
This represents the amount of cash in your bank chequing account.
-
Cash in Savings
This is the amount of cash in your bank savings account.
-
Cash on Hand
This is any cash in your business that you have on hand and not in a bank account. For example, cash in registers at a retail store would fall under this
category.
-
Accounts Receivable
This is to keep track of payments from customers that have paid using credit. Note that credit cards do not fall under this category
because you are paid immediately from the bank. These can be labeled as "AR — [Customer Name]".
-
Inventory
Here you can keep track of the dollar amount of the inventory you currently have on hand.
-
Prepaid Insurance
This is money set aside to pay for insurance. Money is taken out of this balance when paying for insurance.
Long Term Assets
-
Land
This asset is reserved for the price of the land purchased. Note that this does not include the building itself, because
land does not depreciate, but the building on it does.
-
Buildings
Use this asset to keep track of the value of the buildings on your land for your business. Note that this asset undergoes asset depreciation.
-
Leasehold Improvements
This asset represents upgrades to a leased property. For example, when running a business in a shopping mall, it normally comes as an empty
room, and you must spend capital to furnish it. This asset also undergoes asset depreciation.
-
Vehicles
This asset represents any vehicles (e.g. cars, trucks, etc.) that are bought by the business. If the vehicles have any improvements to them,
include that in the value applied to this asset. The Vehicles asset undergoes asset depreciation as well.
-
Furniture and Fixtures
This asset represents all furniture and fixtures, including chairs, desks, shelves, and such. This asset also undergoes asset depreciation.
-
Equipment
This asset represents all equipment that is kept for over a year. This can include computers, copy machines, and other equipment required
for your business to run smoothly. This asset also undergoes asset depreciation.
-
Accumulated Depreciation
This family of assets is used to keep track of the depreciation value of assets that undergo asset depreciation. It is ideal to have multiple
"Accumulated Depreciation" accounts, each titled "A. Depreciation — [Asset Account]". Asset depreciation will be discussed in more
detail later on.
-
Patents
This represents the amount of money the business has spent on gaining specific patents. Note that because patents are only valid for a certain period of time,
they undergo amortization (which is depreciation for intangible assets).
-
Copyrights
This represents the amount of money required to establish copyrights. As copyrights expire after a certain period of time, they also undergo
amortizaton.
-
Accumulated Amortization — Patents/Copyrights
This is where you record the depreciation of your patents/copyrights.
-
Goodwill
Only use this asset if you have purchased another business for over the market value of all that business' net assets. This account
is used to keep track of intangible assets owned by that business, such as store locations, business reputation, customer loyalty, and such.
If your asset does not fall into one of these categories, you can put in under a generic umbrella account such as "Other Assets", and move the asset to a
different asset account at a later date.
|
Liabilities |
Note that liabilities can also be broken down into Current Liabilities and Long Term Liabilities, where again, current
liablities are those that are paid in the next 12 months, with long term liabilties going beyond that.
Current Liabilities
-
Accounts Payable
This liability represents money owed to vendors, contractors, and suppliers that are to paid within a year. Of course, the terms of this
liabilities depends on the terms of agreement made with the outside party. These set of accounts can be labeled as "AP — [Company Name]".
-
GST/Retail Taxes Payable
When you charge the Goods and Service Tax or other Retail Taxes, the amount that you charge is initially put into your bank account.
In order to show that this money is meant to go to paying taxes and is thus no owned by you per say, this account is needed (more on it when we look at journal
transactions).
-
Payroll Taxes
Same concept with GST/Retail Taxes, but with payroll taxes from employees.
-
Credit Cards Payable
You can keep multiple liability accounts for each credit card that you have. Note that credit cards should only be used for short term loans
due to their high interest rates, and thus long term loans should be transferred to lower interest bank loan.
Long Term Liabilities
-
Loans Payable
These set of liability accounts keeps track of all long term loans that will exist for longer than a year. This includes mortgages and vehicle loans.
-
Notes Payable
This is used when you borrow money from other businesses using promissory notes — this note contains terms for repayment as well as interest.
This type of loan does not require asset as collateral.
|
Owner's Equity (CR) |
As mentioned early, Owner's Equity (CR) represents the equity of all shareholders/partners in the business. Accounts of this type include:
-
Common Shares
This account is only needed for corporations. It is used to keep track of the investors contributions to the business.
-
Retained Earnings
This equity account is also only needed for corporations. This account keeps track of all profits and losses accumulated since the business first opened, updated yearly.
-
Capital
This set of equity accounts is for unincorporated businesses — you need one account for each owner within the business. This set of
accounts allows you to keep track of who invested what into the business, whether it be cash, a vehicle, land, and any other such assets. Any profits or losses are
accumulated into the various Capital accounts after certain periods of time.
|
Revenue/Income |
Revenue/Income represents a portion of your income statement. These are accounts that allow you to keep track of your profits over a certain
duration of time. Once that period has ended, net income/loss is consolidated into Retained Earnings/Capital equity accounts as mentioned above.
-
Sales and Service Revenue
This account keeps track of all profit from sales and services run by the business.
-
Other Income
This account keeps track of secondary profits for the business (income that would not fall under Sales and Service Revenue).
-
Interest Income
This account is for money earned from interest on a savings account, accounts receivable, a long-term loan, and such.
-
Rent Revenue
When your business rents out property to other businesses/persons, you would want to keep track of those profits here.
-
Gain on Disposal of Fixed Assets
If you sell a fixed asset, and you made a profit from the sale, it would go into this account. Note that the profit made must take the depreciation amount
into consideration.
-
Purchase Discount
Sometimes vendors will give you a discount on the purchase if you are able to pay them within a certain period of time. Any discounts of this manner go into
the purchase discount.
-
Purchase Returns and Allowances
When you are unhappy with a product purchased, the vendor may provide you with a reduction in purchase price to make up for it, or will allow you to return it.
In either case, be sure to log either the return price or the discount price in this account.
|
Expenses |
Expenses are accounts that take money out of your assets to pay these accounts. Note that it is the combination of the amounts in both revenue adding
expenses that determines whether your business had a net income or loss. Note that Cost of Goods Sold falls under Expense accounts.
Cost of Sales Expenses
-
Sales Discounts
When you provide discounts for earlier payments, this account will hold that value as a cost to you.
-
Volume Discounts
This account holds discounts for large volume purchases or for fostering better relationships with customers. This account holds this value as cost to you.
-
Sales Returns and Allowances
When the customer returns an item or is given a discount for a defective item (of which they would in turn keep), the cost of this goes into this expense
account.
-
Purchases
This expense account is used to store the total cost of goods you wish to sell.
-
Freight-In Charges
This expense account is used to store the amount of money spent on shipping costs when purchasing products.
Other Expenses
-
Loss on Disposal of Fixed Assets
If you sell a fixed asset at a loss, then that amount would go into this account. Note that loss is dependent on the depreciated amount of the asset, much like with
Gain on Disposal of Fixed Assets mentioned above.
-
Advertising and Promotion
Any money spent on advertising and promotion, such as TV ads, Google ads, printing/distribution of flyers, and such, is kept track of in this account.
-
Automotive Expense
This expense account tracks money spent on the maintenance of vehicles.
-
Bank Service Charges
This account tracks the amount of money spent on bank fees (e.g. chequing account fees, E-transfer, etc.).
-
Depreciation and Amortization
A consolidated expense account that keeps tracks of all depreciation/amortization.
-
Dues and Subscriptions
An expense account for keeping track of all subscription services that your business uses.
-
Equipment Rental
The fees for any equipment that is rented for business purposes would fall under this expense account. For example, truck rental for the purpose of moving
business goods would fall under this category.
-
Interest
Any interest that arises from borrowed money would go under this expense account.
-
Insurance
Fees for insurance would fall under this set of expense accounts. Note that you should most likely make different insurance expense accounts for different things
(i.e. car insurance and home insurance would be different accounts).
-
Legal and Accounting
When the business pays for any legal or accounting services, those expensese fit in here.
-
Maintenance and Repairs
Anything used to maintain fixed assets or improvements to rental property would fall under this expense.
-
Miscellaneous Expenses
Use this expense account for when you have expenses that do not fall into any other category (use this account at your discretion).
-
Office Expense
Any supplies needed for the office to run smoothly, such as paper and pens, which do not fall under Fixed Assets would fall into this expense account.
If you wish to keep track of a specific office expense, such as pens, you can make a separate Office Expense account just for pens.
-
Payroll Benefits
Things like retirement benefits and employment insurance for workers would fall under this category.
-
Postage and Delivery
This set of accounts keeps track of the amount of money the business spends on delivery goods. You may wish to keep track of different delivery companies
to see where exactly you are spending your money. Note that this is different from Freight-In Charges, which only applies to the cost of shipping
in the process of purchasing goods to sell.
-
Rent Expense
Any expenses coming from the rental of property, such as rented office space or rented desks, fall into this category.
-
Salaries and Wages
Use this expense account to keep track of the wages you have paid your employees (it may be helpful to keep vacation pay in a different account).
-
Supplies Expense
Use this expense account for business specific supplies that do not fall under Office Expense.
-
Travel and Entertainment
Expenses that arise from employees needing to travel and for entertainment purposes (e.g. box seats at a basketball game) would be kept track of here.
-
Telephone and Internet
Use this expense account to keep track of money used to pay for telephone and internet.
-
Utilities
This expense account is used to keeping track of utilities such as water, heating, and electricty.
|
Owner's Equity (DR) |
These accounts exist for when the owner or shareholder of the business takes money out (note that this money is not considered a salary).
-
Drawings
This set of accounts is only for unincorporated businesses, where each owner of the business needs their own account, to record
how much money is taken out of the business for personal reasons.
-
Dividends
This set of accounts is for incorporated businesses. It is the same as Drawings, but considering shareholders instead.
|
Please be advised that if the above table is overwhelming to you, do not stress as you can choose to add new accounts (or delete them) any time you choose.
Next Steps
Credits
Please note that most of the information from this site is taken from the book "Bookkeeping for Canadians for dummies" by Lita Epstein and Cécile Laurin.
(Epstein, L., & Laurin, C. (2019). Bookkeeping For Canadians For Dummies. Hoboken, New Jersey: John Wiley & Sons, Inc.)