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?
- What is IRIS World like? 326 8
- Pension contributions 340 10
- Offsetting CT losses against another company 90 4
- HMRC & daft penalty 2,339 18
- The stupidity continues 195 4
- qualifying for 1/9th tax credit on foreign dividend 112 1
- Do you have to declare business expenditure on a personal credit card on your P11D? 455 11
- Do you use sign up lists on your website 146 1
- CIMA at the age of 35?? 444 9
- Land Rover Discovery 3.0 SDV6 255 Comm Auto 2 seat 256 6
- Setting up PAYE scheme without UTR 246 8
- Free project management software with Gantt charts, preferably on-line 197 1
- Share transfer question 321 16
- If you've had any issues posting: Please read this 547 10
- New Employers Helpline 149 3
- Overlap relief 735 19
- Budget 2015 - take two 213 3
- CIS Contractor has not issued tax deduction certificate to client 202 4
- VAT Query 206 2
- Sacked my first client 702 14
- Has anyone been affected by the RBS payment breakdown? 433
- Straight line write off of Purchase Goodwill ??? 425
- WIP Software 291
- FRS 102 compliant illustrative accounts for an insurance company 286
- No payroll scheme in place 222
- CGT, PPR and transfer of equity to spouse. 222
- Software recommendations 207
- Do subcontractors on work for residential (student accomodation) construction 201
- Is there anything wrong with this? 194
- Small Part Disposal of Property 175