Excel survey
villapb
Registered Posts: 357
Hi all just being nosey.
The practise i work for, only uses Excel, the last six months i have really got to grips with it but you do need good double entry and accountancy skills too.
What do you guys use, i have seen vt and sage, but i think i will always use excel and then tax calc etc for returns. I even did the accounts for companies house on Excel spreadsheets.
Just wondered what you guys and gals use............
The practise i work for, only uses Excel, the last six months i have really got to grips with it but you do need good double entry and accountancy skills too.
What do you guys use, i have seen vt and sage, but i think i will always use excel and then tax calc etc for returns. I even did the accounts for companies house on Excel spreadsheets.
Just wondered what you guys and gals use............
0
Comments
-
When I first started as a MiP I just used excel but now I use VT. With a software package you get a good paper trail.
I've also used Sage Accounts Production, Sage Accounts Production Advanced and CaseWare (Credence).0 -
Cheers Gem, im going to try VT...............all helps.0
-
IRIS and Sage.0
-
The practice where I work uses Excel for rental accounts, sole traders, ETB's, Sage for bookeeping and Vat returns, and IRIS for Ltd company accounts and tax returns.0
-
I use Excel for all my subbies at the end of the year - only sensible way to sort their 'carrier bag' out really.0
-
VT and FTax.
I use excel a lot but only as an 'assistant,' rarely as a primary bookkeeping/accounts tool.0 -
thanks all, interesting to see the different opinions................0
-
Haha
"I've already keyed it all onto excel for you [so can I have a massive discount]" Is one of my nightmare sayings.
Some potential clients insist you use their spreadsheets in the way they've done it, one didn't like my using the standard SATR expense categories because he had his own system.... another decided his spreadsheet would work out VAT regardless of actual VAT categories etc! I just decline their work and point them to DIY accounts instead.
Using your own spreadsheets, Excel can work fine upto a certain number of users/transactions but then it can go pear shaped. I suppose a really well thought out template for each client type could work well, if you have the technical knowledge to make it idiot proof! I'm used to using SAGE so tend to use that but would also look at the packages mentioned above and on-line packages which can be promoted as a value added service to clients.0 -
Haha
"I've already keyed it all onto excel for you [so can I have a massive discount]" Is one of my nightmare sayings.
Some potential clients insist you use their spreadsheets in the way they've done it, one didn't like my using the standard SATR expense categories because he had his own system.... another decided his spreadsheet would work out VAT regardless of actual VAT categories etc! I just decline their work and point them to DIY accounts instead.
Using your own spreadsheets, Excel can work fine upto a certain number of users/transactions but then it can go pear shaped. I suppose a really well thought out template for each client type could work well, if you have the technical knowledge to make it idiot proof! I'm used to using SAGE so tend to use that but would also look at the packages mentioned above and on-line packages which can be promoted as a value added service to clients.
+1 to this.0 -
Does Excel have a link to get hmrc to answer the phone............sorry but fed up with it lol.0
-
Can I be cheeky and ask if any of you has a excel template, where you just fill in all data and it turns it into the statements automatically for Excel 2010?
I've got a friend whose accountant retired, but left her accounts with accountants that are way more expensive, so she is considering doing it on her own. She knows what she is doing, but just need some kind of template to start.
As I'm not a MIP, I didn't want to do it for her, but said I'd see if I can find her a nice template.0 -
Can I be cheeky and ask if any of you has a excel template, where you just fill in all data and it turns it into the statements automatically for Excel 2010?
I've got a friend whose accountant retired, but left her accounts with accountants that are way more expensive, so she is considering doing it on her own. She knows what she is doing, but just need some kind of template to start.
As I'm not a MIP, I didn't want to do it for her, but said I'd see if I can find her a nice template.
That's a good idea. I suppose with a lot of good intention you'd get all sorts of spreadsheets sent to you, and what you save in data entry you can lose in data checking and re-checking formulas.
It'd be well worth putting all the formulas in protected cells if you're sending it to a client to fill in.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership