I hate spreadsheets with a passion.
My business has an outside accountant, who for the most part we just use for verifying our records before submission and the occasional tax questions.
I do most of the accounting myself, I do a full reconciliation report etc.
Anyway, initially they asked me to use Excel to submit it all to them, and after cursing at it getting slow, and having my hair turn gray, getting confused trying to put it all in a spreadsheet, I decided enough was enough.
I found an open source locally run application that was built for accounting and works on any platform, it does everything I need perfectly, I love it.
The biggest complications with the excel format is trying to calculate sales from online, instore and whether that money is cash (most fun is when someone paid a bit cash, and a bit card for the same transaction) , that money is card etc and having it all play nicely and tally up.
Ofc, when cash is deposited, it is usually different to the total sales figure, due to change given and what-not. That's a PITA to calculate in excel, because you cannot do double entry accounting.
So, the new app, can calculate that automatically and it all works great, and even fixed a few common errors in previous submissions, due to confusion in excel.
It can even generate reports that are identical to what the account gives us after reviewing.
After telling all of this to the accountant, guess what they said?
Please submit your records in excel.
They would not even look at it.
At this point my head exploded and splattered all over the room, with bits of brain matter stuck to the walls. So, I just copied and pasted the generated reports into excel.
The only good of excel is that I can use Libreoffice to make the excel files for them.