Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel to QuickBooks Accountant Premier 2005
I've been using QuickBooks Pro for several years now and just upgraded to QB
Accountant Premier 2005. The documentation tries to cover 8 versions (7 industry specific, including Accountant, plus the Enterprise 10 user version). That brakes down to about 70 pages per. It is poorly organized. I bought it because it has some features that the Pro version doesn't. One of the added features in both the Pro and Premier was supposedly implemented in 2004. That was easier exporting of lists and data from Excel to the pricey versions of QuickBooks. Well, if it there, damned if I can find it. In the past I have done it, by trial and error, but that was at the startup of the client's business. It was a kludge at best, almost 6 years ago, and I don't want to attempt it t&e on mature files. I have found ONE book that covers the Premier editions only. It is better organized that Intuit's book and is about the same length, meaning about 80 pages per version. The book is "Running QuickBooks' 2005 Premier Editions" by Kathy Ivens. After a quick scan at Books-A-Million, I determined that the importing of Excel data isn't detailed very well there either. Does anyone here have any working knowledge of the process? QuickBooks exports many of its reports and lists to Excel in fine fashion. Some of the formulas are a little on the weird side and I haven't seen one yet that took advantage of the subtotal function. And it does a fine set of pivot reports for payroll. I'm using an HP with a moderately fast 32-bit Athlon chip, plenty of memory and harddrive space. The OS is XP Home SP2 and the Excel if from Office XP Standard. -- Kent Finnell From the Music City USA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
excel calendar year resetting 2005 2006 | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel |