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?
- Company car and the new dividend tax rules 78 2
- Car benefit or not? 2,426 23
- Best Auto Enrollment Provider for clients DIY 125 5
- Non reporting RTI - penalties 447 7
- RTI Basic tools save function 78 1
- Large director's pension contribution 497 6
- Charge for tax returns 416 10
- What would you do here, potential insolvency. 1,630 19
- Auto Enrolment - Help each other by sharing known problems 674 9
- Limited company built a property and the client has made this messy 597 13
- Support / ticketing software 180 8
- New (non resident) client not filed in 20 years 422 8
- Transfering bank balnces between old and new co. 428 11
- Annual Return for company for whom director/shareholder has died 293 9
- HP agreement in Directors name but payments under company 236 6
- interest in client bank account 182 3
- Childcare voucher scheme for a director earning the minimum amount 274 13
- Landlord expenses incurred looking for new properties 336 6
- Legal structure of a group of friends producing a free newspaper 611 14
- Company Number 10000000 891 11
- Self employed and HMRC Worldwide Subsistence Rates 780
- Interest paid - do new rules affect Tax Credits? 464
- Market Invoice (P2P invoice discounting) tax treatment 280
- DTA tie-breaker issue 273
- CGT for NOn UK residents 236
- Apprenticeship Levy 211
- What are the tax implications of overseas sales through a UK based company? 202
- Just checking re PSA 187
- Capital Gains personal representatives 186
- Tax Implicatins on a Directors Loan 181