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?
- capital gains on PPR 229 13
- Treatment of goodwill in Consolidation 346 13
- Claiming depreciation on a company vehicle 147 7
- Any Scottish members out there? 11,780 441
- WHAT IS THE BEST WAY TAX EFFICIENT WAY TO SELL 40% SHARES IN YOUR START UP BUSINESS FOR APPROXIMATELY 1 MILLION POUNDS 123 2
- Now Scotland has voted "No", when does England get to vote? 1,284 62
- Company expansion 76 1
- Do I need a 13digit tax ref for a ct600 367 6
- What code do you put expenses under such as tea & coffee? 167 3
- Pension Contributions Relief 488 15
- Is there an expert in Excel out there? 514 8
- 100% Xero practice 2,471 46
- Fees for Property Tax Return 238 6
- Can I calculate a total amount on my freelance tax relief? 163 1
- Separating business for VAT purposes 151 2
- Underpaid Tax Options on SE 293 9
- PRR 365 13
- 40% rule for travel expenses 405 11
- Cash injection by shareholder 317 7
- Private portion of costs and expenses in Accounts 441 20
- Raiders of the Lost Tax File 1,314
- Chartered Accountant in County Down N.Ireland 480
- National Insurance 369
- Non Resident 296
- Franchise income and costs 260
- Hands on experience of Digita 214
- Best way to take money from a business if you have unlimited EIS allowances? 192
- Employer's Helpline 165
- employment capital allowances 161
- CIS paid under reg 9 157