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?
- not self employed since March 2011 now received a penalty for late tax return for year 2012-13 242 10
- Dress code 161 6
- Help Required 332 9
- directors control and tax problems 167 5
- Fastest Software 760 13
- FILING COMPANY ACCOUNTS 928 28
- What's in a name ? 297 5
- Straightforward email correspondence or PDF letter attached to blank email? 230 4
- What quality paper do you use for correspondence? 423 15
- Bulk Invoicing 167 6
- What would you do in this situation? 541 12
- Travel and Substinance expenses while abroad 148 3
- Self Employed Self Assessment: Capital Allowance and Car Lease/HP 242 2
- ATED Penalties 272 1
- late second payment on account 172 2
- US royalties 96 2
- Project being run jointly 137 2
- Reclaiming overpaid employer NI contributions 182 2
- Sole trader mix up 305 4
- Vat on 'pig slurry' - palatable subject I know! 753 6
- CTA study material 703
- Anyone have clients that use Pay4Later to offer customers credit? 425
- Employment related securities question 268
- AIM Stocks and IHT 246
- Tax Relief for overseas employees 200
- Trust for Employee 187
- Expat pension contributions? 186
- Raiders of the Lost Tax File 174
- Quickbooks losing VAT return data 158
- Recommendations for Ross Martin Tax consultancy 2014 139