Replies

Well, my accountant is tapping his foot trying to get our corporate done... I may just print out what I've got and then manually enter it in the Microsoft spreadsheet.

And tell me about Photoshop! We also have a photography business (www.fiveoclockimages.com) and my husband was asking me to fix artifacting in a picture we were looking at today and I think I'm going to have to go back to college to get a degree just to understand everything photoshop does. sigh...

Thanks for responding, anyway.

That’s probably your best bet.

However, there are probably people who are conversant with all the whistles and bells in Quickbooks who might actually be able to tell you how to do what you need to do.

Your Excel idea has merit.

My wife, even with years of expertise with the big accouting packages, regularly creates massive Excel spreadsheet templates to do things that even the report writers associated with those packages cannot do.

She has even gotten Excel “Formula too long” errors once or twice, as I recall, and getting one of those means you’re doing some *serious* crunching...

Good luck.

I may just print out what I've got and then manually enter it in the Microsoft spreadsheet.

Good idea: Doing it in Excel.

Bad idea: Printing it out and rekeying it.

See if Quickbooks has an export function in its menus that would allow you output the relevant numbers to a file in .csv or tab-separated text format (or maybe even in native Excel format!). Once you have the data in that form, it is easy to import it into Excel and turn your Excel skills loose on it.

You may also be able to simply copy numbers out of a screen display in Quickbooks and paste them into an empty Excel worksheet. Excel will then show a dialog asking how to split the data into columns.

Example: Every election here the Boston Globe puts out a list showing the vote tallies in each of the 300-odd cities and towns in Massachusetts. It's in the form of an HTML table on their boston.com website. If you select and copy the table in the browser and paste it into Excel, it turns out Excel understands the HTML well enough to get all the data into the right columns. After that, it's easy to add columns showing Republican / Democrat percentages and sort to see which areas are the most moon-batty (Cambridge, Provincetown, Boston, etc.).