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?
- Benefit in kind calc, s.106 ITEPA 114 2
- error on companies house accounts 154 5
- ACCA Accountants Report 122 1
- Sole trader startup losses and PAYE income in same year 195 5
- Newly Started Practice 227 6
- Commission on holiday accrual 78 1
- Practice Company Secretarial Software recommendations please 163 2
- HMRC computer behind the times 205 3
- problems getting through to the ACCA technical helpline 121 2
- Who's going to the next Tick & Bash? 352 6
- Is a property owner charging a peppercorn rent to a limited company acceptable 245 6
- Overtime etc for PT employees 174 2
- Generic Notification Notices 133 1
- ACCA, ACPA, IFA, ICPA 453 5
- Anti- Money Laundering - CIMA Practising Certification Application 120 1
- How do you get HMRC to refund overpaid PAYE and NIC 440 5
- RTI lost some data on laptop packing up!! 99 1
- Bank Requesting clients' tax residence 248 4
- Does This Company Need To File A Tax Return 150 1
- fraud 420 1
- QROP pension input amounts 477
- HMRC BENCHMARK EXPENSES 442
- write off loan or loan to equity swap or both 421
- Sole trade business in UK, but the owner works from EU 269
- EPS and CIS deductions 261
- Construction CIS LLP Company 248
- Stamp duty on house transfer between spouses 215
- SAGE winforecast 181
- LIVE: Budget aftermath webinar 173
- Managing deliberate defaulters hmrc 166