Ned
Blogger
Share this content
0
14
1339

Quickbooks question

I have a client who uses QBs pro 2005. I use QBs Pro 2012. He has given me his disc so I can use QBs 2005 on another computer to do his accounts as he doesn't want to upgrade. Problem  being that the disc will not load properly and he is now on holiday and I really want to get on with the accounts. The disc has a slight crack on it which I assume is causing the problems. Unless I can get QBs Pro 2005 I think I will have to upgrade it to my version to do the accounts and then redo all my entries onto his version on his computer when he gets back. Has anyone got any better ideas that I haven't thought about to avoid the duplication of processing any adjustments?

Thanks

Replies

Please login or register to join the discussion.

02nd Jun 2012 10:42

Excel

What I do is take a trial balance from QuickBooks - export it and copy it as an extended trial balance into Excel. I make sure I get rid of the fancy formatting. My ETB starts with the trial balance and has another column for adjustments and then add them together to produce a final trial balance and a P & L and balance sheet. I prepare a sheet with the journals showing the Drs and Crs and the explanations. I have another sheet that shows the trial balance descriptions and summarises and totals the journals. I then link the ETB sheet adjustments column with the totals from the summary sheet. Everything is linked so they automatically update when you make changes. It's quicker than doing the journals in your version of QuickBooks and it's easier to understand for when you have to enter it in your clients version later.

Thanks (0)
avatar
By Ned
02nd Jun 2012 11:59

QBs 2005

Good idea - much easier, thanks

Thanks (0)
02nd Jun 2012 13:00

You are welcome

Happy to help

Thanks (0)
avatar
02nd Jun 2012 19:32

A side question.

Ned,

 

The last time I used QB was about 6 years ago, I think it was version Pro 2006.

In your opinion, what has changed since Pro 2006. I am thinking going back to QB, but heard some bad things, like VAT issue has not resolved yet.

Has QB added some functionality to earlier versions, or just tinkering around the corner?

I have also read in this forum that there are issues Debtors control account may be equal to indidual ledgers.

Multi currency is now back again after QB withdrew it from previous versions.

What is good about 2012?

Your comment would be much appreciated

Thanks (0)
02nd Jun 2012 19:42

Problems and 2012

 

"In your opinion, what has changed since Pro 2006. I am thinking going back to QB, but heard some bad things, like VAT issue has not resolved yet."

I still don't trust the VAT. I always review the detailed report and don't accept the VAT 100.

"Has QB added some functionality to earlier versions, or just tinkering around the corner?"

Most packages only get tinkered with.

"I have also read in this forum that there are issues Debtors control account may be equal to indidual ledgers."

I've not had a problem with the debtors. Did you miss out a "not"?

"What is good about 2012?"

I'm a professional advisor so I always get the latest version. I don't expect anything earth shattering.

Thanks (0)
avatar
By Ned
03rd Jun 2012 10:37

In answer to Cantona1 I am also just going back to Quickbooks after using VT for several years and would also always recommend using the latest version. No big changes in from what I can see but I do not want to force the hand of my client to upgrade as I know what its like when you get used to using a particular system and to be honest 2005 does what he needs.

Thanks (0)
03rd Jun 2012 11:42

Ned

I think accountants should use the latest version but clients think differently and only care about if it works for them.

Thanks (0)
avatar
By Ned
03rd Jun 2012 15:09

I know and it causes us a lot of hassle by them not wanting to keep up to date. If they would keep up to date then these problems wouldn't crop up !

Thanks (0)
03rd Jun 2012 15:15

Prices

If everybody upgraded then Intuits upgrade prices would be even higher!

Thanks (0)
avatar
03rd Jun 2012 16:24

I do not know if companies should file thier VAT on-line as per HMRC demand. If QB VAT is not up to scrach, how will you rely on it then?

I also understand the full verion is now priced at £499. I think it is still a reasonable price- well comparing to Sage. I do not how much is the annula support fee.

I also read on this forum that QBs reports are now linked to excel. I do not know how good is this in practical terms, though QB reports are great- You can drill down.

Has any one used QB's payroll? Is it integrated with the Accounting system or not? I mean is it a stand alone?I use Money Soft which is really good package.

Thanks (0)
03rd Jun 2012 18:23

VAT, Payroll and AccountingWeb

"If QB VAT is not up to scrach, how will you rely on it then?"

If it's not good enough you wouldn't rely on it. You could check to see if it the data looks sensible. Admittedly, you shouldn't have to!

"I also read on this forum that QBs reports are now linked to excel. I do not know how good is this in practical terms, though QB reports are great- You can drill down."

I've not used it. I'm not sure what it means. Does it update reports for the next months data?

"Has any one used QB's payroll? Is it integrated with the Accounting system or not? I mean is it a stand alone?I use Money Soft which is really good package."

I used it a long time ago. They seemed to have used the accounts data entry screens and fudged them to look a little like payslips. It was appalling.

Not quite as appalling as AccountingWeb's Comment box! They seem to be unable or uncaring about sorting out the shambles.

 

Thanks (0)
avatar
03rd Jun 2012 20:17

Peter,

I've not used it. I'm not sure what it means. Does it update reports for the next months data?

Once you export a report to excel, you need to format the sheet, ie deleting the empty columns and rows and so on. You  have to do these formats when ever you export reports to excel. In 2012, you do not have. It is diffcult for me to comment and see how it works. May be the formats are saved as templates. there may be a connection between the report and the template.

It seems the VAT issue has been around for over a decade now, and QB is acting like Sage- Buy the upgrade and the problem would go away.

 

Thanks (0)
04th Jun 2012 09:27

Formatting

When I export to Excel I then copy using the values only option. This gets me the text and data and I can format it how I want without a lot of "unformatting".

What I do know is that many accounting packages trumpet the introduction of a new feature and it looks a great idea. But when you try to use the feature it doesn't work how you would expect it to work and it is practically unusable.

 

Thanks (0)
avatar
05th Jun 2012 17:29

I might not a big deal, but the addition of batch invoicing is really good improvement, particularly if you do lots of data entry on invoicing

Thanks (0)