· Complied monthly and quarterly VAT returns for France, Spain, Germany, Portugal and Netherlands to strict deadlines. Analysed and reconciled the Output and Input Tax Report and General Ledger data from Oracle Applications and using Excel (V-Lookups and Pivot Tables), which were monitored and maintained tighter controls of VAT payments/receipts. This process cut down the process time in completing VAT returns.· Acted as VAT point of contact with regards to VAT queries on sales invoices, checking the VAT on test company customer invoices before the customer invoices are sent out;· Developed and maintained working relationships with Baker Tilly Tax Agents in France, Spain, Portugal, Netherlands and Germany whilst submitting the VAT numbers, relevant sales invoices and purchase invoices. · Prepared the EC Sales List for UK companies RELX Tax Team in Oxford. This resulted in the Tax Team submitting EC Sales in a timely manner.· Involved in processing purchase orders for invoices and requesting overseas tax certificates from HMRC for Finance Co-ordinators/Sales Manager in order to chase up the withholding revenue from overseas customers..

Key ResponsibilitiesPreparing over 100 micro business clients quarterly VAT Returns on Excel;Delivering VAT solutions to clients;Solving VAT Compliance issues;Providing guidance on correct VAT treatment;Assisted in setting up Payroll, accounts for business start-ups and final accounts.AchivementsTransferred successfully VAT registered clients from Excel to Xero Cloud Accounting software in preparation for Making Tax Digital for VAT in April 2019;Managed and excuted VAT audit from HMRC. This resulted in no penalties for the client;

• Weekly researched Amazon Resellers with regards to purchasing WD brands and components. Communicated with Brand Protection Team to identify which Amazon Resellers are pricing our WD Branded products at lower than Amazon pricing, summarised report and devised corrective action to the reseller; • Created a Monthly Dell RMA Return spreadsheet (using Excel Pivot Table and Formulas). Produced a simple month summary product rejects and price difference. Analysed and reported Dell Return Summary to the Credit Manager. This resulted in clear presentation of WD products rejected and price differences to present to Dell representatives;• Published a simple Dell Guidance Manual with easy to follow instructions for other work colleagues to use;• Reconciled Amazon Sales accounts for Germany and Spain. Exported Amazon Customer accounts to Excel spreadsheet and ensured all relevant debit notes and credit notes were accounted for. Produced an audit trail for unaccounted debit or credit notes which allowed further investigation work;• Formed a WD Exchange Rate Currency Tool for the e-Tar system project (Travel Management System), communicated ideas with the Office Manager and Finance Manager. Resulted with a simple and effective Exchange Rate Currency Tool for work colleagues to use for Exchange Rate conversions (using Excel formulas);• Helped to set up a new mailbox for Copy Invoice Requests (Oracle R12) for WD Customers. Liased with IT Team to create a mailbox on Microsoft Outlook for all copy invoice request. Communicated with Account Managers and Credit Managers of the new mailbox address. This produced a fast and effective service to WD customers in receiving their sales invoice/credit requests;• Collected data from operational source models, analysed statistics and financial data. This ensured management had the confidence that the data was correct and can accurately proceed with company’s forecasting.

• Designed and implemented a new British Council UK VAT Return and Annual Adjustment templates on Excel to produce timely and accurate quarterly VAT Returns and Annual Adjustment calculations (using V-Lookups and Pivot Tables).• Complied quarterly VAT returns (VAT 100 online) to strict deadlines. Analysed and reconciled the Output and Input Tax data from SAP accounting and using Excel (V-Lookups and Pivot Tables), which were monitored and maintained tighter controls of VAT payments/receipts. This process lowered the time in completing a British Council VAT return.• Managed and controlled indirect tax audits such as Accounts Payable and HMRC Audit. Collated Accounts Payable sample report from HMRC, requested and reviewed scan copy purchase invoices from relevant department. Uploaded and revised four financial years of British Council output and input tax data by using the new UK VAT Return template from SAP to Excel (V-Lookups and Pivot Tables), which resulted in a £2.1 million input tax reclaim to the Council.• Prepared and negotiated British Council partial agreement (PESM)with the assistance of the Tax Manager. Gathered all four output tax quarter data for the financial year on SAP (i.e. Exempt, Standard Rated, Reduced Rated tax codes) and calculated the PESM percentage to be carried forward to next financial year. This resulted in the Council reclaiming more input VAT to help fund future charitable projects.• Acted a VAT point of contact for the implementation of the British Council Trading system transfer project from Excel to SAP accounting software, which highlighted knock on impact of planned changes and assisted in the business decisions.