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?
- How far back can a direct debit be claimed back by client? 713 7
- Accountex speakers 159 1
- Sale of overseas investment property 19 1
- Interim dividends 272 7
- WIP valuation at year end 94 2
- Business loan not in client's name 183 3
- PAYE & NIC 416 23
- Help with small charity CT600 please!! 425 5
- Company Payroll 272 3
- How do I tackle fraudulent use of a clients SA tax return? 1,187 8
- Late leaver notification 420 8
- What does PITA mean? 927 22
- Any printer recommendations? 254 7
- Corporation Tax disallowed entertaining 358 5
- proposed dividends 722 23
- Car fuel benefit - changing basis 185 2
- VAT on Exhibition services 173 4
- Dates, more dates and cessation 156 2
- Out of date tax returns 318 2
- Filling in my self assessment 1,023 17
- Sanzar 507
- Digital marketing focus group 404
- Sage troubleshooting for employee who has previously claimed SMP 385
- Are commercial mortgage cashbacks subject to Corporation Tax ? 350
- Sainsbury's mangement 343
- Continuity Agreement 333
- Avanti Accounts 331
- Buyback 290
- Entrepreneurs' relief (ER) for EMI shares 240
- Aggresive sales from Iris 213