Accounting and Bookkeeping Checklist
What To Do and When

For The Work From Home Business Owner

Checklists are handy. I find bookkeeping checklists are really handy, especially when you are working at home on the book keeping for your business.


Use this search feature to quickly find the information you're looking for.

Custom Search

The Bookkeeper's Tip

If you use QuickBooks, use the "To Do Notes" to setup these tasks. They will show up as Reminders on your Company Snapshot. It will help you to quickly prioritize your tasks at the start of each day.

You will find the To Do List feature under the Company drop down menu. Remember to also set reminder preferences so the list shows up in Company Snapshot. "Set Preferences" has a list of other reminders you can set to help you organize your day.

Daily Bookkeeping Tasks

• Design your billing procedures so that you invoice your customers immediately upon completion of the sale or service.
• If you don't track your customers on an individual basis because you have a cash register, prepare your Daily Sales Summary. If you use QuickBooks, your customer is named "Cash Register Sales" or something like that. Enter your amounts using the Sales Receipt form. Make sure you post your bank deposit to the Undeposited Funds account.
• Make bank deposits on the same day as you receive the payments (or the next day if you are using the portable file organization system for your vehicle).
• Deposit the whole amount as it gives you an audit trail and makes doing your reconciliations easier. Do not take some cash for yourself. If you need cash, write yourself a cheque.
• If you must keep some cash back from a deposit and you use QuickBooks, use the cash back box at the bottom of the Make Deposit screen. Record the whole cash amount received through the Undeposited Funds screen, then record the cash taken at the bottom. Make sure you complete all the fields, including the memo field explaining what or who the cash was for.
  
• Make sure you include the cheque number and date of any cheques you received on the deposit slip ... or you can use a payment log where your record this information. Also check that the address on the cheque matches the address on your invoice. You'll need this information when you go to enter the payment into your bookkeeping program.
• Upon returning from the bank, match and staple the bank deposit receipts received to the customer invoices. (Or you can do this task when you sit down to do your data entry.)
• Setup your small business accounting system so you update and monitor your cash flow forecast every day. I like to do it in the morning before the day's interruptions begin.
• Backup your data. This is a very important task on your bookkeeping checklist ... so please don't skip it.

Weekly Bookkeeping Checklist

• Set aside time (actually block out the time on your calendar) once a week (once a month is the bare minimum), to do your data entry along with your filing.
• Staying organized and on top of your paperwork makes the task easy ... falling behind makes it a chore.
• If you are always behind on your paper work, this portable filing system just might work for you.
• After you have processed all your paperwork, print an aged accounts payable (AP) report and decide which bills, if any you need to pay.
• Establish a priority list for your accounts payable payments. Decide ahead of time who gets paid first ... and try to be consistent with each supplier. For example, here's one list that may suit your industry - Payroll and payroll taxes, sales and income tax installments, rent / mortgage payments, insurance premiums, utilities, and finally suppliers.
• Set AP policies like paying invoices only on the due date and not before ... and stick to them. Consider what your policy for purchase discounts is ... if you are short of cash, should you borrow to take advantage of it ... or not?
• Remember, if you can't afford to pay all your bills, consider making partial payments to make your money go farther and keep your credit rating intact.
• When you are finished entering your data, remember to backup your data. It's a good idea to do this before you start your data entry as well.
• It is a good practice to establish accounts receivable collection procedures and follow them faithfully.
• Schedule time to become friends with your Aged Accounts Receivable Report and perform the accounts receivable collection procedures to keep your cash flow running smoothly.

Monthly Bookkeeping Checklist

• Send customer statements out each month for overdue accounts.
• Book any earnings and/or interest on investments and receivables.
• Review your Other (Miscellaneous) Income and Other (Miscellaneous ) Expense accounts and reclassify entries where appropriate.
• Block out time each month to reconcile your bank statements, credit card statements, and vendor statements.

• Learn why reconciliations are important and how to do an account reconciliation here.
• Try each month to do your month-end processing following the procedures set out in the article How to do Month-End.
• Doing this task quarterly is the bare minimum.
• If you have a bookkeeper, it is very important that you perform your Monthly Financial Review to reduce the likelihood of fraud.
• An added benefit to you will be that you become comfortable and knowledgeable about the financial health of your business.
• If your computer has automatic backups, make a separate backup copy to a USB drive. This is a very important task on your bookkeeping checklist ... so please don't skip it.

Quarterly Bookkeeping Checklist

• Each quarter, file your GST/HST report on form GST34-2. If you are filing annually, you may want to consider reading about other alternatives.
• If you have provincial sales tax, payroll taxes, or workers' compensation, remember to always file these reports on time to avoid late penalties.
• Do a physical inventory count on items that have a large dollar value.
• If you are using a computer software program, restore a data backup file (be careful to name it something other than your current file in use).
• Your objective is to test and ensure it restores properly. You'd hate to find out it is not working when you really need it!
• This is a very important task on your bookkeeping checklist ... so please don't skip it.

Annual Bookkeeping Checklist

This bookkeeping checklist is NOT complete nor comprehensive. I will add to it over time. It contains a lot of housekeeping tasks.

I don't know about you but they aren't my favorite tasks ... so I tend to do them when I see the need ... which is why I will have to add to this list on an ongoing basis.

Some of the tasks must be done as part of your year end procedures.

• Perform a physical inventory count on the last day (or as close as possible to the last day) of your fiscal year. You will need this information for your year-end.
• Reconcile every balance sheet account to a third party source document.
• If you have been doing your monthly financial review, you will have been accomplishing this task on an ongoing basis throughout the year ... so you can be proactive in identifying and correcting any problems early on. :0)
• If you haven't been doing your monthly financial review, roll up your sleeves ... because you have a lot of work ahead of you. :0(
• Prior to the end of your fiscal year, record all your petty cash disbursements and replenish your petty cash if you haven't been doing it on an ongoing basis throughout the year.
• Record any year-end adjusting entries while you are reconciling all of your balance sheet accounts.
• It's especially important to ensure the bank and credit card statements accounts have been formally reconciled to the end of your fiscal year - December 31 for sole proprietors.
• Most small business owners complete their books for daily transactions up to the last day of the fiscal year. They also reconcile all their accounts at year-end ...
• ... then their bookkeeper or accountant determines the year end adjusting entries required. As your small business accounting records are going to be used to file your tax return, it's important to have your work reviewed by a professional. Here's a list of what your accountant will need.
• Look at your Undeposited Funds account. The only deposits showing here at the end of your fiscal year should be money received from customers that did not get deposited in the bank until the new year.
• Run your Accounts Receivable report. Apply any outstanding credits on customers' accounts to open invoices.
• In QuickBooks, you do this through Receive Payments ... where you Apply Credits through the Discounts & Credits button.
• Clean up your miscellaneous over and under payments by journalling them to your miscellaneous income account OR directly to your sales revenue account ... and make a note to the accountant who does your year-end.
• Before you hand over your information to your tax preparer, run a comparative set of financial statements. Check that last year's numbers match what was reported on the financial statements attached to your tax return filed with CRA.

• If something is different, track it down. If you don't, the person preparing your tax return will have to charge you to figure out the problem. (If your books are prepared on a GAAP or GPE basis, there will be some timing differences on tax return information so make sure you are comparing to your financial statements not the actual tax return.)
• If you closed your books properly, then last year's information should match.
• Most payroll service companies put out year-end payroll checklists and guides. Adapt the information from these specialists for your own business ... to make sure you have crossed all your t's and dotted all your i's.
• Ceridian's website has a Canadian Year-End Customer Guide for Small Business and a Year-end Payroll Checklist. Sometimes they change their link, so I won't give you live links. The last time I looked, the guide was located under resources and tools at www.ceridian.ca/en/resources-tools/yearend/2009/small_business_yearend_guide_2009.pdf while the year-end checklist was located at www.ceridian.ca/guide/hr-payroll/year-end-checklist.html. Sometimes they move it around ... so you may have to hunt a bit. :o)
• ADP has a U.S. Year-end Payroll Checklist. You should be able to find it at www.adp.com/tools-and-resources/compliance-connection/payroll-resources/year-end-checklist.aspx.
• Take some time before you begin your new fiscal year to review your chart of accounts and clean it up.
• If you are no longer using a particular account because you sold the asset or paid off the loan, in QuickBooks you can make the account "inactive". The balance should be zero before you do this.
• If you find two accounts set up to track the same expense, in QuickBooks you can merge duplicate accounts ... but make sure you know what you are doing so you don't overwrite and lose valuable data.
• If an account was setup and never used, in QuickBooks you can delete it. Once the account has been used, this option is no longer available. You also can't delete an account that has a sub-account attached to it or an item assigned to it. You must reassign the sub-account or item first.
• If you use QuickBooks, take some time before you begin your new fiscal year to review your customer and vendor lists.
• Clean the lists up by inactivating dormant vendors or lost customers ... or merging duplicates. Again, be careful when you use the merge command. It is irreversible, so double check before you hit ok.
• Review your system needs to determine if your accounting system needs upgrading ... if you've had a great year, you may have outgrown your system ... or perhaps your current system is too large for the volume of transactions you have.

Make An Appointment With Yourself To Complete Your Bookkeeping Checklist - Yes ... Actually Schedule It

If you work through these bookkeeping checklists and actually do these small business accounting tasks faithfully, preparing for year-end will not be an onerous task.

You can make it easier on yourself by actually scheduling time to perform these small business accounting tasks just as you would any other task in your business.

Making the appointment with yourself will make it more difficult to put aside the task. If you are consistent with the timing, it will become a habit very quickly. Each time you complete one of the bookkeeping checklists, they become easier to do ... especially if you stay on top of it.

Okay, now I have to come clean. Do I always get all these tasks done on the bookkeeping checklists when I say they should be done?

Ah, that would be a big, fat no. :0(

Sometimes I just don't have time ... but I do chip away at each bookkeeping checklist ... so that come year-end, I've got everything done that needs to be done.

Do you want your year-ends to be a breeze? Then you need to get around to doing these accounting and bookkeeping tasks throughout the year too.

Didn't find what you were looking for? Use this search feature to find it.

Custom Search

Go To Small Business Reconciliations

Return to "The Practice" Section

Go To Home Page From Bookkeeping Checklists