New to Quickbooks, and i need to enter data from my bookkeeper. He lumped many items into one.?

Question

New to Quickbooks, and i need to enter data from my current bookkeeper who uses his own spread sheets and no QBs. He lumped all utilites in one catergory instead of gas,water,etc instead of breaking them out so i can see what i paid for gas itself over the year and things like supplies and other items he did similar things to. When setting up my QB i will be seperating each utility, and i am setting this up this week. 7/20 so how do i enter this so at the end of the year it comes out correctly?

Thank you kindly,

Ken

Answer 1

In all reality, your bookkeeper (if he was doing his job correctly) would have copies of each payment and expense, so even if the information was entered into a 'lump' category on his spread sheet, you should still be able to get the individual amounts from him. I would call and request paper copies of everything he has -- at least from the first quarter of this year.

If you don't mind the extra work (and can't get the info from your bookkeeper), call each utility company (or go online if you have that option with them) and ask for a print out of what you paid each month for the first quarter of this year. That would give you exact amounts.

If you don't want to do the work... just start with 2nd quarter and at the end of the year average out 2nd, 3rd and 4th quarters for each utility and use that number for the first quarter amount.

For things other than utilities, if you can't get the exact numbers from your bookkeeper, I don't really know how you would get those numbers except maybe to guess what percentage of each category would go towards each individual expense.

I hope that helped at least a little, and good luck!