Now I am going to say this from the start. I am not an accountant I just happen to be very good at finding solutions to problems and relatively good at Excel.
I say relatively good because I know people who are far better than me.
I help a small family run business optimise their VAT process. Previously everything was written down on a bit of paper and then all the receipts put into a file with invoices and finally the analysis on top.
Continue reading Optimising your time when doing VAT Quarterly Returns
One of my readers asked a question whether it was possible to do a VAT quarter. For those that are reading this abroad VAT is essentially a sales tax of 20% that is applied to most products and services in the UK. Continue reading Creating VAT Quarter Returns Using Excel – Version One
Microsoft Excel is the world’s most used spreadsheet tool. But what do people use it for really? I would admit that I began using it at school for creating lists and slight calculations. However, now with what I have learnt in terms of automation, KPI creation, VBA and analysis. Continue reading Microsoft Excel – Weekday Function and VLookups