Excel to maintain accounts

Posted by John Cotter PM | on Fri, 27/04/2012 - 17:11 4077 19 comments | report

I am finding it easier and quicker to maintain accounts in Excel database.

Bank statement cut and pastes straight in.

Cash books likewise.

Using sumifs to produce great Management accounts. Pivot tables can also be used very well for reporting.

Balance sheet - again sumifs.for monthly analysis.

Coding analysis allows flexibility by having two columns Primary Code and secondary code.

Anyone else work like this?

Comments

There are 19 comments. Login or register to view them.

scalloway | Fri, 27/04/2012 - 17:51

Chris Smail | Fri, 27/04/2012 - 18:30

thisistibi | Fri, 27/04/2012 - 20:50

Trevor Scott | Fri, 27/04/2012 - 21:24

Hardeep23 | Sat, 28/04/2012 - 00:43

mr. mischief | Sat, 28/04/2012 - 09:06

frustratedwithhmrc | Sat, 28/04/2012 - 09:12

petersaxton | Sat, 28/04/2012 - 09:38

Healthpay | Thu, 03/05/2012 - 11:00

slarti | Thu, 03/05/2012 - 12:19

NewACA | Thu, 03/05/2012 - 19:03

petersaxton | Thu, 03/05/2012 - 19:10

scalloway | Thu, 03/05/2012 - 19:23

slarti | Fri, 04/05/2012 - 10:06

Ray Koshy | Fri, 11/05/2012 - 15:58

petersaxton | Fri, 11/05/2012 - 16:36

Kent accountant | Fri, 11/05/2012 - 16:30

NewACA | Sat, 14/07/2012 - 10:12

petersaxton | Sun, 15/07/2012 - 12:11