Wednesday, October 28, 2009
How Can a Virtual Assistant Help Me With My Bookkeeping Virtually?
Posted on 4:11 AM by programlover
How Can a Virtual Assistant Help Me With My Bookkeeping Virtually? by Linda Siniscal
in Accounting (submitted 2009-10-27)
0
votes
vote
I get this question asked quite a bit as many small business owners just don't like bookkeeping or don't have the time. I can tell you that virtual bookkeeping can be done pretty easily but it does depend on what system you have in place and how comfortable you are with delegating to your virtual bookkeeper.
The first consideration:
1. Accounting Program. If you are using QuickBooks, Peachtree or any other accounting software, you need to make sure that your version is the same as the virtual bookkeeper. Most accounting programs will allow you to restore a file from either the same version or version below (QuickBooks Pro 2009) but then you would not be able to restore the file back down to your version (QuickBooks Pro 2008). Most QuickBooks ProAdvisors do have multiple versions of QuickBooks on their computers. I personally have clients still using much older versions and they have opted not to upgrade because the version just works fine for them.
2. Another option is QuickBooks Online. QuickBooks online allows 3 users to access the account (business owner, bookkeeper and accountant). What is nice about QuickBooks Online, is you do not need to purchase software each year and the file is backed up on the Intuit server every day. You can also access the file from anywhere you have computer access - from your home office, if you travel frequently - from the hotel, or even review the file directly from your accountant's office. The QuickBooks Online version is different than the desktop version but if you just use QuickBooks for invoicing and entering payables, this method will work fine for you. If you are thinking about using QuickBooks online, please discuss with your QuickBooks ProAdvisor and they can explain the different packages available as well as help set up your account. The monthly fee is between $9.95 - $34.95 depending on what package you select and keep in mind that most QuickBooks ProAdvisors do pass on their discounts to their clients.
3. You can also use remote access sites such as logmein, gotomypc or pcanywhere where the virtual bookkeeper can log into your computer, access your QuickBooks file and update as needed. The only problem with using this method is it will prevent you from using your computer at the same time as the bookkeeper and usually the entering transactions can take a little bit more time due to type of internet connection you have.
The second consideration: how do I get the information to the bookkeeper. There are a few ways to handle this and again it will depend on what process works best for you and the bookkeeper.
1. Set up a file folder for each month of the year - January through December. Throughout the month, insert your credit card receipts, vendor bills, and cash outlays into the appropriate file folder. When the bank statement is received, you can then send the file folder to the bookkeeper via Priority Mail, Express Mail, FedEx or UPS. Once the bookkeeper receives the file, the credit card charges are entered into the accounting program and the statement reconciled along with your business bank accounts. For this method, most clients do pay their vendor bills and send the check stubs to the bookkeeper for reconciling. Once the reconciliations have been completed, the bookkeeper will email you the monthly financial reports (Profit & Loss, Balance Sheet) and mail back to you all the receipts, which have now been attached to the appropriate statements (bank or credit card) for filing.
2. For client invoicing, you can email, fax or mail the information needed for preparing the client invoice. For monthly invoicing, a master invoice template can be set up with the client filing in the necessary information and then emailing to the bookkeeper for completion. The virtual bookkeeper can prepare and either mail or email the invoice on your behalf. The virtual bookkeeper can also help you in keeping close tabs on your accounts receivable.
3. For those of you who have online banking, it is very easy to use a virtual bookkeeper. There are a couple of ways this can be done - you can download your bank activity weekly, bi-weekly or monthly and email the information to the bookkeeper for entry along with the monthly bank statement when it is available.
For those of you who have had a long, established relationship with your bookkeeper, you can assign access to them through your bank, and they would then be able to log in and download the transactions and bank statements themselves. You can also email your bookkeeper vendor invoices with suggested payment dates and the bookkeeper can set up the vendor for payment through your online bank account.
Lastly, finding a virtual bookkeeper. You can certainly contact your accountant and ask if they can recommend a bookkeeper to help with your monthly transactions. Many bookkeepers do work closely with their client's accountants. Throughout the year I am sending QB files for quarterly or six review for tax planning discussions that my clients have with their accountant. Another idea would be to ask other business owners that you know and ask them who assist's them with their bookkeeping.
1. Intuit (makers of QuickBooks) has an online database of their Certified QuickBooks ProAdvisors you can find at http://proadvisor.intuit.com/referral/. You enter your zip code and a list will show the Certified ProAdvisors in your area. To become a QuickBooks Certified ProAdvisor you must take a test each year on the most recent edition of QuickBooks. It is an online test and can take up to 16 hours to complete.
2. Another recommendation is to find someone who is a Certified Bookkeeper. There are two organizations that offer certification programs for bookkeepers and they are the American Institute of Professional Bookkeepers (AIPB - www.aipb.org) and the National Association of Certified Professional Bookkeepers (NACPB - www.nacpb.org). With both organizations you need to obtain CE credits throughout the year in order to attain your certification. In addition, NACPB provides the nation's leading bookkeeper licenses. NACPB bookkeeper licenses assure small business and nonprofit organizations that NACPB licensed bookkeepers are trusted and competent bookkeepers.
3. The International Virtual Assistants Association (www.ivaa.org) - a non-profit organization with over 1,200 members is another association where you will be able to find well-qualified bookkeepers or certified bookkeepers. They have an RFP area where you can post your job requirements and members who match those qualifications will respond to your RFP.
These are just a few of the methods that can be used when working with a virtual bookkeeper. There are also other processes that can be used which I did not cover. It is important that when you are interviewing for your virtual bookkeeper, that you both decide on what process will work best for both yourself and the bookkeeper. Of course, when you start working together, you may find that emailing your QuickBooks file is just too cumbersome and you may then elect to use QuickBooks Online or one of the remote access programs. It will certainly be the task of the bookkeeper to find the process that will work the best for you.
The first consideration:
1. Accounting Program. If you are using QuickBooks, Peachtree or any other accounting software, you need to make sure that your version is the same as the virtual bookkeeper. Most accounting programs will allow you to restore a file from either the same version or version below (QuickBooks Pro 2009) but then you would not be able to restore the file back down to your version (QuickBooks Pro 2008). Most QuickBooks ProAdvisors do have multiple versions of QuickBooks on their computers. I personally have clients still using much older versions and they have opted not to upgrade because the version just works fine for them.
2. Another option is QuickBooks Online. QuickBooks online allows 3 users to access the account (business owner, bookkeeper and accountant). What is nice about QuickBooks Online, is you do not need to purchase software each year and the file is backed up on the Intuit server every day. You can also access the file from anywhere you have computer access - from your home office, if you travel frequently - from the hotel, or even review the file directly from your accountant's office. The QuickBooks Online version is different than the desktop version but if you just use QuickBooks for invoicing and entering payables, this method will work fine for you. If you are thinking about using QuickBooks online, please discuss with your QuickBooks ProAdvisor and they can explain the different packages available as well as help set up your account. The monthly fee is between $9.95 - $34.95 depending on what package you select and keep in mind that most QuickBooks ProAdvisors do pass on their discounts to their clients.
3. You can also use remote access sites such as logmein, gotomypc or pcanywhere where the virtual bookkeeper can log into your computer, access your QuickBooks file and update as needed. The only problem with using this method is it will prevent you from using your computer at the same time as the bookkeeper and usually the entering transactions can take a little bit more time due to type of internet connection you have.
The second consideration: how do I get the information to the bookkeeper. There are a few ways to handle this and again it will depend on what process works best for you and the bookkeeper.
1. Set up a file folder for each month of the year - January through December. Throughout the month, insert your credit card receipts, vendor bills, and cash outlays into the appropriate file folder. When the bank statement is received, you can then send the file folder to the bookkeeper via Priority Mail, Express Mail, FedEx or UPS. Once the bookkeeper receives the file, the credit card charges are entered into the accounting program and the statement reconciled along with your business bank accounts. For this method, most clients do pay their vendor bills and send the check stubs to the bookkeeper for reconciling. Once the reconciliations have been completed, the bookkeeper will email you the monthly financial reports (Profit & Loss, Balance Sheet) and mail back to you all the receipts, which have now been attached to the appropriate statements (bank or credit card) for filing.
2. For client invoicing, you can email, fax or mail the information needed for preparing the client invoice. For monthly invoicing, a master invoice template can be set up with the client filing in the necessary information and then emailing to the bookkeeper for completion. The virtual bookkeeper can prepare and either mail or email the invoice on your behalf. The virtual bookkeeper can also help you in keeping close tabs on your accounts receivable.
3. For those of you who have online banking, it is very easy to use a virtual bookkeeper. There are a couple of ways this can be done - you can download your bank activity weekly, bi-weekly or monthly and email the information to the bookkeeper for entry along with the monthly bank statement when it is available.
For those of you who have had a long, established relationship with your bookkeeper, you can assign access to them through your bank, and they would then be able to log in and download the transactions and bank statements themselves. You can also email your bookkeeper vendor invoices with suggested payment dates and the bookkeeper can set up the vendor for payment through your online bank account.
Lastly, finding a virtual bookkeeper. You can certainly contact your accountant and ask if they can recommend a bookkeeper to help with your monthly transactions. Many bookkeepers do work closely with their client's accountants. Throughout the year I am sending QB files for quarterly or six review for tax planning discussions that my clients have with their accountant. Another idea would be to ask other business owners that you know and ask them who assist's them with their bookkeeping.
1. Intuit (makers of QuickBooks) has an online database of their Certified QuickBooks ProAdvisors you can find at http://proadvisor.intuit.com/referral/. You enter your zip code and a list will show the Certified ProAdvisors in your area. To become a QuickBooks Certified ProAdvisor you must take a test each year on the most recent edition of QuickBooks. It is an online test and can take up to 16 hours to complete.
2. Another recommendation is to find someone who is a Certified Bookkeeper. There are two organizations that offer certification programs for bookkeepers and they are the American Institute of Professional Bookkeepers (AIPB - www.aipb.org) and the National Association of Certified Professional Bookkeepers (NACPB - www.nacpb.org). With both organizations you need to obtain CE credits throughout the year in order to attain your certification. In addition, NACPB provides the nation's leading bookkeeper licenses. NACPB bookkeeper licenses assure small business and nonprofit organizations that NACPB licensed bookkeepers are trusted and competent bookkeepers.
3. The International Virtual Assistants Association (www.ivaa.org) - a non-profit organization with over 1,200 members is another association where you will be able to find well-qualified bookkeepers or certified bookkeepers. They have an RFP area where you can post your job requirements and members who match those qualifications will respond to your RFP.
These are just a few of the methods that can be used when working with a virtual bookkeeper. There are also other processes that can be used which I did not cover. It is important that when you are interviewing for your virtual bookkeeper, that you both decide on what process will work best for both yourself and the bookkeeper. Of course, when you start working together, you may find that emailing your QuickBooks file is just too cumbersome and you may then elect to use QuickBooks Online or one of the remote access programs. It will certainly be the task of the bookkeeper to find the process that will work the best for you.