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?
- Wear & Tear Allowances 302 7
- Letter from HMRC telling me client passed away 1,396 19
- That old chestnut 337 7
- Supply to Irish State Body 215 2
- Free Agent - Payments on Account 326 6
- PAYE Refund Farce At HMRC 272 3
- Non controlling shares - how to set up 246 9
- Donaldson v HMRC - result?? 213 3
- Investment property where tenant lives rent free 200 4
- Loss on cessation of sole trade 110 1
- Helping clients with bookkeeping but not a bookkeeper 723 18
- MAAT vs ACCA 1,954 35
- IR35 - relationship of WIP 661 6
- How to tell HMRC Limited Co. is active 209 3
- Tax relief for Director incurring business expenses on his credit card 201 2
- Repair or improvement? 428 7
- National Insurance. 150 1
- Trust tax return 171 1
- VAT on land sale 163 6
- Property Development 321 7
- DTR : TIOPA 2010 Section 42 406
- CTA study material 359
- Sect 102 TMA 1970 268
- Sage Forecasting - Print filename 250
- new capital structure ltd with investors 201
- Relief on French Tax Deposit? 199
- Pre incorp expenses 197
- Anyone have clients that use Pay4Later to offer customers credit? 180
- Slight twist on employment related securities 169
- Accommodation provided to employees for short term contract away from home 153