Ive had a discussion with an accountant who suggests that when I do his clients books I use my windows office excel spreadsheets as I only have SAGE instant accounts at the moment
A daft question I know but can any tell me if I would lay the spread sheet out as with manual bookeeping, i.e double line down the middle of the page or as pettycash style format.
I am assuming that the Accountant wants you to do some analysis work relating to his or her clients for there year end. Take each Job independently some clients will be Vat Registered others will not. You will be analysing expenses such as Rent & Rates, Postage, Stationery, Motor Expenses, Remember though that if the client is registered for Vat and using the Invoice date relating to Vat and not the cash accounting scheme. Post your payments to a creditors column in Excel so as not to analyse twice. Your Purchases and Expense invoices can be summaried seperately Create a day book. The same with Sales you can then create a debtors and creditors control Account. Remember to make use of the Excel formulas to add up your balances and cross cast. Hope i havent confused the issue.
We have a Cash Book System, an Excel template that does all of this - Debtor/Creditor Ledgers, VAT, and Bank Reconcilations.
You can download a trial too which will give you a good idea of what it does, or what you might do yourself (though you mightn't want to waste a lot of time setting it all up).
