Excel to maintain accounts | AccountingWEB

Excel to maintain accounts

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?




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

Done it for years

scalloway |
scalloway's picture

I would refer youto Ecclesiaties Ch1 v 9-11

Chris Smail |
Chris Smail's picture


thisistibi |
thisistibi's picture


Trevor Scott |


Hardeep23 |


mr. mischief |
mr. mischief's picture

Oh! A history question - I love history...

frustratedwithhmrc |
frustratedwithhmrc's picture

Excel and Cloud

petersaxton |
petersaxton's picture

Cheaper than Excel

Healthpay |

Why re-invent the wheel?

slarti |

I use excel for doing book keeping for £0.5m t/o companies

NewACA |

Accounting software?

petersaxton |
petersaxton's picture

Time rich, cash poor

scalloway |
scalloway's picture

An accounting system for the cost of a car.

slarti |

I prefer to use accounting software .

Ray Koshy |


petersaxton |
petersaxton's picture

Excel is a...

Kent accountant |
Kent accountant's picture


NewACA |

Double entry

petersaxton |
petersaxton's picture