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?
- HP agreement in Directors name but payments under company 678 18
- Personal Pension Relief in the Tax Code 293 4
- Sage Instant Accounts Complete De-install problem 276 10
- Love is in the air 602 7
- Auto enrolment confusion 2,058 47
- CGT on lost shares/scam 378 4
- Setting up a practice 538 5
- Very large share capital by mistake 546 7
- VAT refund if only output tax on first claim 501 4
- 24 month rule and expenses 410 1
- Stamp Duty 302 4
- Physiotherapist and vat and agency work ( one for Les Howard???) 240 4
- I am 34 years old, am I too old to start a career in Accounting ? which is the best way to pursue it 1,826 21
- Another Sneaky Tax Hike! 722 5
- Incorporation of gp practise 398 1
- Client Paperwork Retention? 588 13
- Paid staff their normal salary instead of SMP 592 7
- Tax Overlap Reporting 418 4
- Pay rise - how to enter in Moneysoft 404 9
- Reimbursing director travel costs 465 6
- DTA tie-breaker issue 306
- Tax Implicatins on a Directors Loan 296
- CGT for NOn UK residents 282
- Employer's pension contribution - need to be PAYE registered? 281
- Foreign domicile status 266
- What are the tax implications of overseas sales through a UK based company? 258
- Apprenticeship Levy 243
- profit or loss on furnishings and deed of trust 242
- Tenants in Common - Actual % split not written down 226
- Discretionary payment to sick employee 225