AFTERNOON AND WELCOME

1. AFTERNOON AND WELCOME

2. Rosemary - Boost your memory with this nutritional powerhouse • Loading client templates onto Sage • Payroll Journals – different types of reports • Charging for extras • Data checks before sent to Acct • VAT SAGE 2013 • Bank transactions

3. Setting up New clients on Sage Uploading client templates into Sage Using the new how to do sheet

5. Setting up New clients on Sage • Remember when you back up Sage files you only need to back up the Data Files, unless you are producing Sales Invoices for your client. • With your own accounts and clients where you produce their sales invoices you should always back up the data, report files and layouts. This way if anything should happen you won’t lose the various Rosemary templates or your sales invoice set up or your client’s templates

6. Payroll Iris Moneysoft Sage BrightPayUK Payroll Express Payroo Ceridien Accentra Payroll Lite RTI Lite

7. Payroll Continued • Whatever the software the information that you need each month to process the payroll is: • Gross Pay (may be called other things eg Basic Payment) • Employee NIC • Employer NIC • Netpay • All these packages must provide this information

8. Payroll Continued The payroll should be posted using the Memorised Journal in Sage, either the No Director or with Director:

9. Payroll Continued PAYROLL NO DIRECTOR – RBPAYND

10. Payroll Continued PAYROLL WITH DIRECTOR - RBPAYD

11. Payroll • Remember – if your client has payroll with RTI now operating it must be run monthly so you need the payroll information every month

12. Charging For Extras NEW TRANSACTION RECORD SHEET – TRS 3 ROWS WITH DROPDOWN BOX TO IDENTIFY EXTRA CHARGES YEAR END OPENING/CLOSING BALANCES SUPPLIER/CUSTOMER(S) RECONCILIATIONS GENERATING CLIENT’S SALES INVOICES PAYROLL FOR LARGER CLIENTS

14. Data checks before sent to Acct • Always do your reviewing (Order of Processing Section 3). • Remember if you have payroll the only balance on Nominal 2210 PAYE should always only be the last month processed and on Nominal 2202 Netpay should be zero unless your client pays wages mid month etc • Nominals 9998 and 9999 should not have balances, if they do you must provide an explanation and ask the accountant to deal with • Have a look at the Sundries nominal – N/C 8206, if this has a high balance on it this could trigger an HMRC Inspection. Theoretically you should only have to use this nominal for the odd transaction, everything else should fit within a different nominal. You should look at the total compared to the turnover if the ratio is high you need to move items. If you are not sure contact Support. • Once you have checked down the TB and are happy ie there don’t appear to be amounts on odd nominals for the client in question you should email the data file to Support and ask for it to be checked prior to being sent to the client’s accountant.

15. When you email the data file for checkingplease provide the following • Client Information Sheet – this should be completed as fully as possible • Details of any oddities for the client, anything strange that HO should be aware of • Anything that you are not sure about or need help with • Starting Audit Trail number from where you want checked

16. Data checks • You will be sent in return a list of any changes that you will need to make • A list of points to raise with the accountant

17. VAT on SAGE 2013 • On Sage 2013 when you click to reconcile VAT you will get a new window pop up – VAT TASKS

18. VAT on SAGE 2013

19. VAT on Sage 2013 VAT Transfer Date Sales Tax Amount Run VAT Transfer Purchase Tax Amount ------------------------------------------------------------------------------------------------------ Adjustment Manual Adjustment -----------------------------------------------------------------------------------------------------Payment Bank Date Ref Details Amount Record Payment ------------------------------------------------------------------------------------------------------ e submission to HMRC Submit this VAT Return electronically to HMRC Submit Return

20. Bank Transactions

22. EC Sales and Purchases • Generally your client’s cannot claim VAT on goods and services purchased in the EC • Goods and Services bought within the EC region between businesses are known as Reverse Charge transactions ie your client has to act as the supplier and the customer – to show this on their VAT Return • You will have to set the Supplier up with details of the EC Country they are based in and with their VAT Number in order to process as an EC Vat transaction. • When posting the Supplier invoice use the relevant Sage tax code depending on whether the transaction is Zero Rated or Standard rated, a good or a service • SAGE TAX CODES for EC Transactions • T7 – Zero rated purchases of goods from Suppliers in EC • T8 – Standard rated purchase of goods from Suppliers in EC • T4 – Sale of goods to VAT registered Customers in EC • T22 – Sale of services to Vat registered Customers in EC • T23 – Zero rated purchases of services from Suppliers in EC • T24 – Standard rated purchases of services from suppliers in EC

23. EC Sales and Purchases • The figure you post will appear as follwos on the VAT Return • the amount of output tax in box 1 VAT due on sales • the amount of input tax in box 4 VAT reclaimed on purchases • the full value of the supply in box 6 total value of sales, and • the full value of the supply in box 7 total value of purchases. • No VAT to account or at all if the service from the EC is exempt or zero rated