Our startup accounting sucks, I have no idea where money is going to and coming from (and don't let me start about time...). Accounting is just an example, this can be applied to many problems.

So today I was playing with Excel trying to understand something in my business... but boy was it a mess, took me 10 minutes to understand I wasn't going to have something that made sense on it.

Yes Excel/OpenOffice calc etc can be used as multidimensional with pages but seeing data spread accross pages really becomes a mess.

I have four main dimensions:

1) The date in which a passage of money happened

2) Which client or provider the income/expense is relative to

3) Where will the money go/be taken (paypal, bank account, credit card...)

4) How much taxes (VAT or work related ones for example) applies to that amount (optionally this one can go with the third dimension)

Those are "full" dimensions as I call them because I will need to do calculations on all of them.

I was hoping in not having to use a database and a programming language for this but if there was some piece of software similar to a multidimensional spreadsheet that did the trick. What are business analysts using these days?

I have no formal math training so I'm not looking for an enterprise solution that I think will come in handy for really a lot of things for us "metric visualization" nerds

I also know there might but since i'm a metric visualization nerd I want to learn to use a multidimensional spreadsheet (and you should too) since it will be often useful for startups and gaining insight into how a business works.