Keeping track of the finances in your small business is the key to its success, but where do you begin? Here are six steps to setting your bookkeeping up for your business.
STEP 1: Collect all your paperwork
Before you start your bookkeeping process you need to have all your paperwork together. Then you will need to divide the paperwork into the following categories:
- Accounts payable is the money you owe to other people for business expenses.
- Accounts receivable is money that is owed to you by your customers.
- Petty Cash is the cash you have on hand to pay small day-to-day expenses
STEP 2: Create an accounts payable folder
In this folder you will put the following information:
- bills
- receipts
- bank statements
- credit card statements
- proof of payments
STEP 3: Create an accounts receivable folder
In this folder you will put the following information:
- Invoices
- Proof of payment (credit card slips, internet bank transfers, cash receipts)
STEP 4: Setup an Excel document
There are different ways to keep records but we will look at how to create an Excel document for your business.
In this document you will setup two sheets:
- Accounts payable
- Accounts receivable
On the accounts payable sheet, you will need to label the following columns:
- Date you received the invoice
- Supplier’s name
- Account number
- Type of expense (e.g., office supplies, professional services, etc.)
- Amount you owe
On the accounts receivable sheet, you will need the following columns:
- Customer’s name
- Invoice date
- Invoice number
- Amount owed
- Due date
- Amount past due
- Date payment was received
You can get an example of the Excel document here.
STEP 5: Capture the information
Now you need to fill in the information for each sheet. Depending on how many sales and supplier invoices you receive per month will determine how often you need to do your bookkeeping. It is advised to do your bookkeeping once a week if you have a few invoices. The key to keeping accurate records is to be consistent and habitual. Ensure that you schedule time in your week or day to do your bookkeeping.
STEP 6: Create an invoice template
There are many examples of invoices for Excel but you must ensure the following information is on your invoice to get quick and accurate payments:
- Your business name
- Your business contact information
- Your business logo (if applicable)
- Clear payment terms, such as “payment is due in 30 days of invoice date”
- Details about the product or service you delivered
- Hours worked or the amount of products sold
- Banking details with the name of the recipient if it is different to the business name.
- Business Tax number (if applicable)
- Invoice number
STEP 7: Review your accounts
By reviewing your accounts payable weekly, you will be able to see which supplier invoices are outstanding and be able to pay them timeously. To build good rapport with your suppliers it is important to pay them a few days before the due date of the invoice.
When you review your accounts receivable, you will be able to note which clients have not paid you yet and follow up on outstanding payments. It is important to send them a kindly-worded letter that their account is outstanding.
STEP 8: Reconcile your bank statements
Check your bank account against your monthly recordings of expenses and income. This is important to do to make sure no fraud has been committed on your accounts. You will also be able to check if you or the bank has made mistakes on your accounts.
By following these eight steps you will be well on your way to understanding the basics of bookkeeping.
Proudly brought to the NSBC.