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?

 

 

 

Comments
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

@Chris

thisistibi |
thisistibi's picture

Yes

Trevor Scott |

Vt

Hardeep23 |

VT

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 |

Transactions

petersaxton |
petersaxton's picture

Excel is a...

Kent accountant |
Kent accountant's picture

a

NewACA |

Double entry

petersaxton |
petersaxton's picture