Hello all,

This is a bit of a general question, I'm trying to move over our small business to excel from a series of 4 ledgers, I'am struggling somewhat in trying to automate a lot of it,

I was wondering what I should consider when designing and building this system, one of my main aims is to try and reduce the amount of entries, at the moment it seems to be double and triple entry system. Is the double entry something that is going to have to remain?

I'am basing the system at the moment (early stages) on the individual ledgers, but keep running into trouble, I was thinking to myself that maybe basing the new system on the old system isn't a good idea and maybe something more radical is required in order to digitalise it.

I also wondered if excel is even the right program, as a lot of this is double entry that I'm trying to stop to reduce time inputting I was wondering if actually Access would be a better choice using the ledgers as tables and then using queries to automate the data.

I as you can tell am rather confused, Microsoft Office is the only software we have.

Alastair