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?
- When to top-up pensions? 35 1
- Entrepreneur - want to submit accounts by myself 1,812 22
- Withdrawal of a quote 191 5
- Company Number 10000000 946 13
- Online accounting provider for multicompany with turnover £10m 337 5
- CGT on lost shares/scam 156 3
- Anyone else getting these HMRC letters? 408 3
- What would you do here, potential insolvency. 1,811 29
- Divorcing husband, both 50% owners of a Ltd business 543 10
- HP agreement in Directors name but payments under company 416 9
- Support / ticketing software 288 9
- Where to follow court cases/rulings 201 3
- HMRC Funding for Employee PAYE refund 329 5
- Are Tax Agents designed out of online systems? 261 2
- Stamp Duty 112 2
- Annual Return for company for whom director/shareholder has died 400 13
- Best software for small practice? 824 24
- Large director's pension contribution 636 10
- Credit for price reduction - Inventory write down effect 141 2
- Car benefit or not? 2,559 26
- Self employed and HMRC Worldwide Subsistence Rates 793
- Interest paid - do new rules affect Tax Credits? 464
- Market Invoice (P2P invoice discounting) tax treatment 282
- DTA tie-breaker issue 279
- CGT for NOn UK residents 240
- Apprenticeship Levy 214
- Tax Implicatins on a Directors Loan 206
- What are the tax implications of overseas sales through a UK based company? 206
- Just checking re PSA 194
- Capital Gains personal representatives 187