Tweet

Stressing Over QuickBooks? 10 Steps to Better Manage Your Bookkeeping Records

Guest post by: Linda Siniscal

Article Overview: 10 steps to alleviate the stress and burden of bookkeeping by organizing and simplifying the processes involved.

Stressing Over QuickBooks? 10 Steps to Better Manage Your Bookkeeping Records

Do you cringe when you open up your QuickBooks file? You have receipts in the car, crumbled receipts in your purse or briefcase, and vendor invoices buried in the papers on your desk or email inbox. Here are 10 easy steps you can put in place today to better organize your bookkeeping records so the next time you open up QuickBooks, everything will be nicely organized for you.

1. When vendor invoices are received, enter into QuickBooks as soon as you can. Try to set up time on your calendar once a week to handle this task. Don't wait until the end of the month and most likely find yourself scrambling to locate the invoices and fitting it in to your busy schedule. By handling this task frequently, you will pay less late fees and perhaps take advantage of those vendors who offer discount pricing if paid within 10 days.

2. A simple way to manage those vendor invoices, purchase an accordion file A-Z and use this to file your vendor invoices. No need to set up individual file folders that take up valuable file space. As soon as the invoice has been paid, just file the invoice in the appropriate letter slot. If you need to locate a past invoice, all you need to do is go to that letter and you'll soon find what you are looking for. If you are converting to a paperless office, set up a file folder on your computer for Vendor Invoices and store the paid invoice in this file. You can set up a file - Vendors A - L and Vendors - M - Z. At the end of the year, copy these files onto a CD and store with your business tax files.

3. Bookkeeping rule #1: do not co-mingle personal and business expenses. Sign up for a credit card exclusively for business and one for personal expenses and get in the habit of using the correct cards. This will certainly save you a lot of headaches if you are ever audited by the IRS. It will also make it easier when the credit card statements are received and you are only looking at business expenses and not both personal and business and spending more time sifting through the charges.

4. Use online banking for bill paying. With most major banks this is a free service and the beauty of online banking, you just enter the amount of the invoice and schedule the invoice for payment before the due date. Just don't forget to enter the transaction into QuickBooks. The benefits of online bill pay - saves you postage costs and also by scheduling before due dates, saves on those late fees.

5. Reconcile your bank statements monthly. Try setting up time on your calendar the week the statement is received. If you have been disciplined to enter your transactions each week, this should not be a time consuming process.

6. Credit card purchases need to be entered into QuickBooks on either a daily or weekly basis. When your credit card statement is received, you reconcile the statement similar to how you reconcile your bank statement.

7. Keep your chart of accounts simple. If you have multiple income streams you may want to set up income accounts for each product or service. This will allow you to monitor sales each month when you review your Profit & Loss report. For your expense accounts, keep it simple. Remember the more accounts you have, the more time you will spend in deciding which account to use.

8. When hiring new employees or contracting with new subcontractors, make sure they submit a W4 or W9 form. Establish a procedure to receive the forms before their first payment is made. Remember to enter their tax information into QuickBooks when the form is received. This will make preparing W2s and 1099s a less stressful task in January.

9. If you have a PayPal account, you need to create a bank account for PayPal similar to how your checking account is set up. This account will need to be reconciled each month as well. PayPal allows you to download monthly financial reports for reconciling the account.

10. If you find you just do not have the time and you are still stressed with your bookkeeping, contract with a virtual bookkeeper. This will allow you time to do the things you excel at and pass the task on to some who enjoys bookkeeping. If you do not know where to find a virtual bookkeeper, contact your accountant and ask if they can recommend a bookkeeper or ask other business owners who assist's them with their bookkeeping.

Related Articles
  Top Three Bookkeeping Basics
  The Importance of Bookkeeping
  Can I Move from QuickBooks Pro to Premier or into QuickBooks Enterprise?
  Your software is only a tool
  Understanding the Differences Between QuickBooks Upgrades and QuickBooks Updates
  Tip on Better QuickBooks Performance
  The
  Bookkeeping Work From Home
  QuickBooks 2011: Improvement to Closing Date Functionality
  3 Key Reasons A Business Needs To Keep Books
  Home Based Bookkeeping Business
  Truth in Numbers
  Budgeting Made Simple for the Small Business Entrepreneur
  QuickBooks 2010 - Download This Product Update (R5) for Less Intrusive Marketing
  QuickBooks 2010: Will I Lose My Data if I Upgrade?
  Key Differences Between QuickBooks Enterprise and QuickBooks Pro/Premier Accounting Software
  Report presentations to provide clarification of your financial position
  5 QuickBooks Myths - The Real Story
  QuickBooks Tip: Easily See the Accounting Entry Behind the Screen
  Questions You MUST Ask Before You Appoint A Bookkeeper

Article Tags: accounting, Budget, finance, organization, small business



Related Forum Posts
Re: Business 2012 in London - [quote="bjsteele":wu04qnmy]I don't know Richard Branson. Could you introduce him simply? What is he speaking about?[/quote:wu04qnmy] You were asking who Richard Branson is, well after a few false starts his first successful business venture was producing a magazine called ‘student’ which he launched in 1968. He then started selling records by mail order in 1970 before opening his own record shop in Oxford Street in 1971. He then opened the Virgin recording studio in 1972 followed by his own Virgin Records label in 1973 and the rest is history. He is the founder and inspiration for all things Virgin now such as Virgin Telecoms, Virgin Atlantic Airline, Virgin Records, Virgin Racing, Virgin Bank and Building Society amongst many others here and abroad and I would like to get to London to meet him and listen to what he has to say. Sir Richard Branson as he is now has been drafted in as one of several ambassadors to bolster Britain's image abroad. The initiative will be launched across 17 key cities, including LA, Tokyo, Beijing and Sydney, with events including a show in Rio during which images of Britain will be beamed onto Sugarloaf Mountain. regards, Mal.
Managing the Paperwork - Greetings All, As we all know, when an Entrepreneur starts his/her business, there is a ton of paperwork to deal with. Who wants that? All we want to do is do our work and make money while solving people's problems with our brilliance! The purpose of this thread is to find out what everyone has done to manage their paperwork/bills. I, for one, am horrible at managing such things. I still have quite a number of receipts that have to be inputted into QuickBooks Pro from last year! I'm a techie and can fix pretty much any PC issues or develop some awesome online marketing ideas for businesses....but please, dont' ask me to figure out how QBPro calculates taxes and why the GST has to be separated in the setup and inputting in the Enter Bills area. To me, this is confusing (and you too after re-reading that paragraph....) So, in the past I tried a high-school Co-Op student. This was a brilliant way to get someone who knows QuickBooks and did not cost me any money. The downside, rules stated that I could not leave him alone. So if I went out on a call, so did he. He brought paperwork to do stuff while we were out so it wasn't too bad. The other downside, he didn't truly want to be an accountant as he was late at _least_ once a week as well as absent at least one day a week (keeping in mind he was only with me 4 days a week). A pure example of someone being forced to follow a parent's footsteps. So, that little experiment went well. I did get some great work from him when he was there. I still used a regular accountant to do my taxes and they talked back and forth easily to make sure my stuff was inline. I would consider doing this again. Currently, I am looking at hiring someone for a couple of hours a week. My schedule is not at all static. I could be in Algonquin Park one day and Sarnia the next. So, having someone work once a week is a much better solution for my scenario. Has anyone done anything different? If so, what has and has not worked for you so far?
QuickBooks vs. Microsoft Money vs....? - I have always used Microsoft Money to run my business - accounting, invoicing, etc. It came with my computer when I got it and integrated well with my online banking system so everything is a breeze. It only takes 30-60 minutes every quarter to do the bookkeeping (keep in mind that I have a very simple business - no inventory, very little invoicing, I do all my payments by credit card, etc). Is QuickBooks or Money the best accounting tool for small business owners? Or is there something even better?
Wearing different hats in Business - I have a business that produces beautiful custom rugs for home and business environments. Different hats that I'm wearing... Rug Fabrication - 10 [i:21cr28m8](partially outsourced to an outfit here in the US)[/i:21cr28m8] Customer Service / Sales - 8-10 Bookkeeping - 1 Marketing - 6 Website development - 5 [i:21cr28m8](mainly outsourced)[/i:21cr28m8] SEO, SEM - 6-8 Accounting - [i:21cr28m8](outsourced)[/i:21cr28m8]
Different Hats - CEO Sales & Marketing & Leadership Development Company Strategic Vision 10 Alliances & Growth Strategies 10 Hiring & Managing People 8 Mentoring 8-9 Strategic Planning for Clients 10 Execution of Marketing Campaigns 9-10 (i have great people who do the nitty gritty) Financial Management 9 Bookkeeping 3 (outsourced as I really hate the fine details like GST0 Administrative Follow Up 6-7 (again have great staff) Writing & Publishing 9 (getting better all the time!) Speaking 10 (so I have been told) Self Promotion 9-10 Web development & Promotion 6-7 (learning more and have brought on players who are 10+) Babysitting Employees (1 - wont do it, that's why I work so hard to hire and motivate the people I have) Great topic Kevin!! Jude


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

Expanding Your Business By Franchising

Five Ways to Show Honest Appreciation

Reverse Mentoring

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.