Moving from Ledgers to Excel

**liirge** · 12-13-2011, 07:36 AM

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

**arlu1201** · 12-13-2011, 07:49 AM

Ideally for accounting purposes Tally is the best known software. However, since you mentioned that MS Office is the only software you have, in that case, Access might be a better option. Excel will be extremely complicated since it doesnt have any in-built relationships which Access has.

**liirge** · 12-13-2011, 07:55 AM

Thank you for your response, I thought this might be the case.

I need to brush up on my access then!! haha

**royUK** · 12-13-2011, 10:32 AM

I have built a complete accounts system using Excel - Purchase Ledger, Sales ledger, Supplier & Customer Databases, INcome & Expenditure reports, P & L etc.