I have a client who wants to use excel for book keeping but having never used this package before for book keeping I'm only vaguely sure on where to start.
Would anybody be able to give me any pointers? I have been looking on the internet for any free templates to get me started but have been unsuccessful so far.
The client is VAT registered and also has an accountant who does his year end etc. With Sage I know we just send a file to the accountant via e-mail but what would happen if excel was used?
Hi, I use to have one on excel but hes now on Quickbooks. All you need to do at the end of the year is either print it all out or take a back up of it on a memory stick or disc and give that to the accountant. Have a Sales sheet and a separate P-sheet. You will need to have separate colums fo the net/VAT/Total amount, and CIS amount if they belong to the CIS scheme. Also a colum for details/date/supplier. Can't think of anymore of the top of my head but hope that helps for a starter. Bill is good at excel hopefully he will be on here for later. cheers
-- Edited by Amanda on Monday 29th of November 2010 12:20:26 PM
I also have had some clients who would like me to use excel for their accounts. I am familiar with DIY Accounting which is excel based, so when using standard excel for accounts i have been basing my information on this. Ie: Nett, Gross, Vat Columns. As long as it is catergorised clearly for the accountant to see and the totals and vat (if applicable) is correct then i personally think it is an easy option. I could see it being a problem for a larger company though.
