[?] Subscribe To The Bookkeeping Blog

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Home
The Support
The Site Map

The Tea Break
The Tea Shoppe
The Virtual eGuide
The Online Exams
The Excel Lessons
The Free Ezine
The Forum
The Blog

The Receipts Organization
The Filing eBook
The Scanning
The Vehicle System
The Suggestions

The Tax - Canada
The CRA Compliance
The CRA News
The Small Biz News
The GST HST
The CRA Tax
The T2125 Form

The Tax - U.S.
The IRS News
The Payroll Taxes
The Rates & Dates

The Bookkeeping
The Basics
The Practice
The Training
The System
The Plan
The Tips
The Help

The Back Office
Contact/Meet Me
Hire Me
Site Policies

QuickBooks® Back Work

by Susan
(Canada)

Hi - I love your website!

I have been taking different Accounting Courses over the past 3 years and recently started working again (home with kids). I love bookkeeping but I am still learning.

Currently I have taken over books for a very organized small business (easy transition) and was asked by a friend to do his books. He was already using QuickBooks® (updated to 2009 version) so I bought that new version (I had previously used older versions in other employment). Anyway, his books are a real mess!

Negative A/R, A/P, never reconciled his bank account in 5 years so it is overstated, never tracked inventory properly, has two COGS accounts (one appears to not be used). Can't imagine that GST is correct, opening balance equity are inventory asset adjustments ... the list goes on.

To fix this current company in QB (QuickBooks®) would take many hours and I doubt he has all the receipts anyway. Also, he mixes personal with business (ug!), has no OE or OW set up. I don't feel that I have the skill or the necessary information to fix this, so I was thinking that it is better to open a new QB company and start fresh - what are your thoughts?

Also, he needs to remit GST for last year but with this mess of records he is most likely overpaying! HELP PLEASE!



image of fancy scroll lines



Hi Susan,

I'm with you.

Sometimes it is faster and more cost effective for the client to just start their books fresh ...

... as reconciling and correcting the prior bookkeeping work done by someone who did not understand basic bookkeeping or follow good bookkeeping practices takes time ...

... and we all know time = money.


The good news is ... that's why you have a home business as a bookkeeper!

I am delighted that you are enjoying my website! I hope you visit often. :0)




QuickBooks® is a registered trademark of Intuit, Inc.

Comments for
QuickBooks® Back Work

Average Rating starstarstarstarstar

Click here to add your own comments

Apr 18, 2010
Rating
starstarstarstarstar
Exporting QuickBooks lists
by: Susan

Thank you Lake!

I forgot to also ask ? is there a way to export the vendors and customer lists to import into the new QB company I set up?

Apr 18, 2010
Rating
starstarstarstarstar
Transferring lists between QuickBooks companies
by: Lake

Hi Susan,

There sure is ... using the list features of QuickBooks!

QuickBooks lets you export/import most lists by simply marking the list you want ... but you must be signed in on the administrator account.


Backup both your "old" company and "new" company files before you begin. Importing any kind of data cannot be undone. If something doesn't work, you will be able to try again using the restore feature ... no problem ... rather than trying to fix the import.

To backup select File >Save Copy or Backup. Then make sure Backup Copy is selected. Select your backup file options so you know where you are saving it to ... change the location if you don't like the default by clicking on the browse button.

If prompted during the backup procedures, select Use This Location ... then Save It Now ... then Next ... then Save.



You begin by exporting the lists you want from the "old" company file ... under File >Import/Export >Export.

Once you make your selections and click okay, QuickBooks will prompt you to save the export file it created. I would save it to your desktop for easy retrieval.

Close out of the "old" company and open the "new" company using the administrator account.

Begin importing your lists by selecting File >Import/Export >Import.

Follow the directions to import the lists as they occur, selecting the export file you saved to your desktop.

Click on the import button when you are ready. QuickBooks will upload the lists to your "new" company.

You should now be good to go.



I listed the following instructions from memory so I may have missed some windows or got them in the wrong order. I am fairly certain if you need more information, you look under exporting data in the QuickBooks help index or transferring lists between company files.

Good luck Susan!

Click here to add your own comments

Join in and write your own page! It's easy to do. How?
Simply click here to return to Learning QuickBooks


SIMPLE EASY
Office Filing System


Learn How to Organize Files
In Under 30 Minutes

$47

Bookkeeping In A Box eBook- choose the Canadian or US Version

Download eBook Canadian

Download eBook U.S.



You can delegate responsibility but you can't abdicate it!




2 Bookkeeping Tests
Prescreening Tool or Study Aid
350 Questions

includes answer key,
Bookkeeping Basics Webcast
and more

Bookkeeping Test Questions and Answers Bookkeeping Test Online Basic Bookkeeping Training

$49 USD
LIFETIME ACCESS

Click on exam booklet to order
Click here for more information

How to Use This Exam:

(1) As part of your interview process when hiring a bookkeeper.

(2) To self assess your bookkeeping skills.

(3) As a practise test before writing your bookkeeping certification exam.




Learn How to Turn
Your Piles of Paper
Into an Organized
Electronic System

Paperless Document Organization Guide

Click on the picture above
for easy to understand tips and strategies on how to go paperless.




Free eReport When You
Subscribe To My Newsletter
The Bookkeeper's Notes

eBook cover




Subscribe To
The Bookkeeper's Notes
A Free Newsletter

For The Work From Home Business Owner

Email

Name

Then

Don't worry -- your e-mail address is totally secure. I promise to use it only to send you The Bookkeeper's Notes.




Brian Tracy's

Click here to receive Brian Tracy's Free Goal Setting Success Guide!





(Listed Under Websites NOT Under Local Business. This website is not associated with any business operating in Bonnyville Alberta.)




From the Mail Bag
Visitor Comments



Thanks for the information. It is nice to see there is an online site where I can go get answers to my bookkeeping questions. It was really a stroke of luck I came across this site. I googled my bookkeeping question to see if I could get an answer, a shot in the dark, and bookkeeping-essentials was one of the results listed. I looked over some other sites but none were as flexible as this site. I got a quick response and I will be using this site in the future. Thanks again.

Bayside, NY, United States




I love your site...its very homey!!! It's like reading/talking to a friend!! Thanks!!

Kim, Jackson, MS United States




Your website is positively BRILLIANT! I don't care at all for the numbers side of my business, but you've made it interesting, fun, comfortable--downright enjoyable! Bite-sized WELL WRITTEN bits walking me through fundamentals, encouraging me, explaining.(Note: "well written" covers everything from "interesting" to "intelligent." The reader doesn't stumble over elementary grammar errors, lots of typos, etc.) I've only just discovered this lovely gold mine!

Cherie, U.S.




I have just come across your site and it's great...thank you so much for the time it must take you to compile the data and information. I have no accountancy or book keeping knowledge and am currently trying to learn QuickBooks via YouTube. (lol) There must be an easier way as I don't have the time or finances, what with starting a new business, to attend a course at college or similar.

Debbie, Vancouver, BC Canada




As a novice at the bookkeeping game, this site has become my go to site for research. Thank you for the great resource. I do my data entry one or twice a year (very low volume) and I find I need retraining on Quickbooks for things like depreciation/CCA.

Den, St. Albert, AB Canada




A More Than FANTASTIC site! So often I've thought about putting something together like your site, but didn't have the time. Googling information about Supplies or Tools over under $500.00 was the most useful Google search I've ever done because of discovering your site. Way to go and THANKS VERY MUCH. PS.... Also loved it that you put the Tax chart for GST HST back to 1997; I spent hours trying to get this information from the CRA website. I've not had time to look at your whole site, but I will be refering to it often I'm sure and will mention anything I think is missing, should I not discover information as I might be looking for it. Thanks, Again

Leona, Sicamous, BC Canada




Thank you for your comprehensive reply to my question. I really appreciate the time you took to explain it to me.

Connie, Canada




This is an absolutely awesome site! I am not lying. I went to Chapters to try to find something just like this and they did not have what I was looking for - which your site does ... which is good definitions and explanations. I am going to book mark this page if that's okay. ... Great job and thank you. I will definitely use this resource.

PK Lethbridge, Alberta




My biggest problem in doing my books is keeping debits & credits straight in liability and equity accounts. I really liked the cheat sheet. (I think that will help me keep the debits and credits straight.)

Lisa, Williston, USA




Lake you're awesome in every way. I have had some insight about how to properly classify some accounts.

Karim, Calgary, Alberta




Thank you so much for this website. I am interviewing for my first bookkeeping position in over 10 years--and my first in Canada. I have AAS degrees in Accounting and Business Admin from the US but have never worked in "my field" since immigrating in 2000. Your website makes me feel more confident I can actually do the job I am interviewing for. So far, I have been refreshing my knowledge and preparing for a job interview. I've bookmarked the site for WHEN I get the job!

Robin, Toronto, ON




I love your website. Just love it.

Carolann
CPB Bookkeeping, Inc.
"The Organizer"
Lake Worth, FL




I posted a question on Accumulated Surplus and you asked me to comment on your comments. I really appreciated reading what you posted and it did help. Especially the part of talking to the accountant. That really makes sense. I find more and more that I interact with the accountants to keep on learning. Love Love Love your website. Just discovered it about 3 weeks ago and have been on it lots since then.

Jan
Red Deer, Alberta




Wow. I'm so thankful to have stumbled across your site, with the assistance of Google. :) I love your style of writing, your approach, and your message. Thank you for your time and efforts. In a nutshell, your light humor and simple approach is refreshing and uplifting.

Kathy, Hillsdale, United States




Your site is great by the way. I just came across it.

Trish, Canada




Thanks for responding so quickly ... I really appreciate all the forum help ... I do Love the forum and have looked through other questions on it and feel it will greatly help in the future. Your site is fantastic and I will recommend it to anyone asking about bookkeeping help.

Cindy, Calgary, Canada




It (your site) is very helpful and thank you for your tips and advice. I am so glad I found your site.

Lee, Calgary, Alberta




Thank you so much for your hard work on your site ... I find I learn quicker and easier with you than I did with courses. Your site has helped my knowledge, learning new things and with the explanation of terms/items. Keep up the good "BookWORK"!

Naomi, Balance Your Books, Squamish, B.C.




This website has been very helpful. It's been too many years since school and I'm a bit rusty.

Sue, Medicine Hat, Alberta




I just found this site tonight. It's going to help me a lot as I learn how to use my Quickbooks more fully (I've only used it for payroll). Don't ask me how I've managed to keep the books this long -5 years- without knowing much more than how to balance a checkbook. I'm getting some help from a professional now, but your site will keep my pro costs down. Thank you. I will definitely donate once I begin to use it with my QuickBooks. It's [your site] easier to understand than Help in QuickBooks. QuickBooks assumes I know bookkeeping concepts. It [your site] appears to be very thorough, though I've only scratched the surface of what I can learn. I took an online bookkeeping class a couple of years ago, but this site has direct application to quickbooks and it's a searchable site!

Ruth, Dos Palos, CA USA




Thank you for providing valuable information regarding home business taxes on this website.

U.C., Toronto, Canada




I started my own bookkeeping business two years ago and enjoy your site. I literally grab my cup of coffee and look around for hours. :D It's a wonderful site with loads of information and I'm all about learning from my peers who might have the answers to some of the questions I may have. Keep up the good work. :)

Tania, TaniasBookkeeping.org
Taking the worry away
Belledune, New Brunswick




BTW, did you say Bookkeeping? Cuz I fell asleep... just kidding!

Dr. Julia
www.advice-with-dr-julia.com

(I love her humour!)




Absolutely a great site! I have often dreamed of having a similar site but figured I might have to wait until I retire to get the time. I have bookmarked this site and will return again.

C.H.
Alwyn Enterprises
Scarborough , Ontario




You have a wonderful website. Thank you so much for letting me know you have one now. [It] is really well done and very, very informative. Also really charming.

R.P.
Reliable Recordkeeping
Toronto, Ontario




I'm enjoying reading your blog! Thought I'd drop you a quick note of encouragement.

Loralee, Red2Black.ca
QuickBooks "one
on one" coaching
Edmonton, Alberta




This is a marvelous site and one that I would like to use as the basis for training bookkeepers. I am a CPA here in the states and am in the process of building a what will hopefully become a substantial bookkeeping business (not a dark wood & gold lettered CPA firm). I want to serve the small business owner with the day to day service they need. You have obviously put in an enormous amount of time and effort here (there is no doubt there) and provide a wealth of fantastic information.

R. Keith Pierce, CPA, P.A.
I'll Sweat The Small Stuff For You - JaxTaxPro.com
Jacksonville, Florida