A client, one who likes to help out on things, decided to give us an excel file of everything. There’s a lot of entries, several hundred, and apparently he used quickbooks to make the files and then exported them to Excel. This is only a tiny bit better than making us just enter everything by hand.
1. Why import them to Excel at all? There’s no formulas, and it’s all direct formatting from Quickbooks, so if a number is wrong, it’s wrong. No formulas to make sure things are correct.
2. Why does Quickbooks put the total up at the top of each entry instead of the bottom like in normal-world? It looks like this:
See that? It’s like that all the way through. I’m used to finding the end of a column to get the totals. And then there’s this:
Rent for lots of something 5400
Something 1 1300
Something 2 4100
It’s like that… all the way through. Sometimes, there’s a total of 6 or 7 different things, and I have to hunt down which of the bolded amounts are in that total, because some are subtotals and sub sub totals. All 100 or so pages of transactions are like this. Guess what I get to go through and add formulas, just to check if Quickbooks did it right?
Right now, I have a burning hatred for Quickbooks. This drives me to cutting.