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?
- Cash injection by shareholder 93 3
- Treatment of goodwill in Consolidation 264 8
- PRR 226 12
- Do I need a 13digit tax ref for a ct600 195 4
- Now Scotland has voted "No", when does England get to vote? 1,095 55
- Is it more beneficial to be a Ltd company? 155 3
- Any Scottish members out there? 11,464 424
- How to pursue fraudulent trading 288 4
- corp tax software 346 7
- Pension Contributions Relief 439 14
- Is there an expert in Excel out there? 464 7
- Which tax box 185 2
- How to change reconciliation status of bank account in Sage 50 114 3
- how to start a career in accounting at 34? 234 3
- Underpaid Tax Options on SE 207 6
- References for clients 201 2
- Sole Trader - Working from home claims 147 2
- incorrect PAYE statements 120 2
- What accounting software packages are best for restaurants? 316 7
- Capital Gains Tax on title transfer 145 5
- Raiders of the Lost Tax File 1,297
- Chartered Accountant in County Down N.Ireland 462
- National Insurance 360
- Non Resident 278
- Franchise income and costs 255
- Hands on experience of Digita 209
- Best way to take money from a business if you have unlimited EIS allowances? 168
- Employer's Helpline 158
- employment capital allowances 150
- CIS paid under reg 9 140