I gang

Excel Spreadsheet Development

1/ you will see it's dated February 2011 to Jan 2012 in column B - this needs to be changed to Feb 2014 through to Jan 2015.

2/ you will see column D is a simple yes or no - this relates to VAT charged on outgoings - the spreadsheet assumes that VAT is included in all the outgoings recorded in columns N through to AH. ( see first data entry in column D fuel )

If I enter an N into this column before entering the particular expense the spreadsheet knows there is no VAT included ( see second data entry in column E transport )

All the above is good, however I need the monthly and yearly totals which the spreadsheet calculates, to take VAT or no VAT into account - so for example if you go to line 204 you will see the monthly total which includes the VAT figure - I need it to show the total excluding VAT for accurate accounting and the submission of my annual tax returns. If you got to line 2475 you will see the same monthly summary which in turn calculates the annual figure in line 2487. Maybe this can be achieved by adding another row beneath the existing row at the end of each month - then using these rows to calculate the year end figures for tax return purposes as they wish to see these figures without the vat.

3/ insert a ‘rent’column Z next to ‘insurance’

4 / Finally I need the spreadsheet to calculate total yearly expenses in 7 separate categories to match the Inland Revenue’s Tax Categories.

For example the first Tax Category of expenses is TRAVEL and this needs to be Columns N & O added together minus VAT paid = Total Yearly Expense on TRAVEL

I will provide full details of this breakdown into 7 Tax Categories once the first 3 tasks have been done.

PLEASE BEGIN YOUR REPLY WITH THE WORD 'HEY' - SO I KNOW YOU'VE READ AND FULLY UNDERSTAND THIS TASK.

Færdigheder: Regnskab, Excel, Software Testning

Se mere: travel and transport, spreadsheet accounting, simple entry in accounting, simple accounting spreadsheet, on line accounting software, expense in accounting, excel spreadsheet rent, end of year accounting, accounting data entry software, vat return, tax returns, spreadsheet excel and accounting, spreadsheet (excel) and accounting, row spreadsheet, insurance software development, AH, accounting spreadsheet, account spreadsheet, 2015, excel categories, excel breakdown spreadsheet, 204, month expense spreadsheet, fuel example, february month

Om arbejdsgiveren:
( 49 bedømmelser ) Halifax, United Kingdom

Projekt-ID: #6049632

Tildelt til:

Snap2Art

Hey Thank you for making you project available for bidding on Freelancer.com. Please see my extensive Freelancer Profile and employer feedback, which can be viewed here: [url removed, login to view] Mere

£18 GBP in 3 dage
(3 bedømmelser)
2.3

32 freelancers are bidding on average £20 for this job

javed1705

I am an ACCA(UK) professioanal , APA and Mcom finance. Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing sa Mere

£22 GBP på 1 dag
(189 bedømmelser)
6.8
priyal1997

'HEY' Dear Sir/Madam I went trough the description and the attachment and I am 100% sure that I can develop a PERFECT model for this task which can be used in future by yourself very easily. I am an expert in advance Mere

£50 GBP in 2 dage
(128 bedømmelser)
6.3
zExcel

Hey, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

£33 GBP på 1 dag
(83 bedømmelser)
6.2
koolsidz

Hey :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice that I have not di Mere

£23 GBP på 1 dag
(109 bedømmelser)
5.9
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

£22 GBP på 1 dag
(63 bedømmelser)
5.7
caabdul

Greetings! I am accountant, tax expert and excel expert. I can do the job. Thank you

£20 GBP på 1 dag
(45 bedømmelser)
5.5
dpune

HEY Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your pos Mere

£20 GBP in 2 dage
(65 bedømmelser)
5.5
jaylancer43

HEY - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche b Mere

£20 GBP in 0 dage
(59 bedømmelser)
5.5
best4best

HEY. I have read the description and gone through the spreadsheet. I am an Excel expert and ready to start this project now.

£18 GBP på 1 dag
(79 bedømmelser)
5.4
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mere

£30 GBP på 1 dag
(46 bedømmelser)
5.3
WAQAS1ACA

Hello Dear! After reviewing your project details and attached file very carefully, I can assure you with great confidence that I can handle yours project because I already handled these types of projects practically Mere

£18 GBP på 1 dag
(36 bedømmelser)
5.2
excelsolution

HEY, I have gone through your requirements and excel template you have provided. I understand the requirements you have given for the first 3 tasks and I will be able to complete this within a day. Please provide th Mere

£28 GBP på 1 dag
(61 bedømmelser)
4.8
ethicalboy

Hello ready to start asap to deliver you, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I a Mere

£20 GBP på 1 dag
(40 bedømmelser)
4.8
paris2785

HEY Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demon Mere

£20 GBP in 2 dage
(20 bedømmelser)
4.0
toxicman

HEY I'm a software engineer with good knowledge in excel macro. I can help you to do this. send me p.m for more details

£18 GBP på 1 dag
(14 bedømmelser)
4.0
darshinisk

HEY Dear Sir, I am highly interested in this project. since I am partly qualified ACCA UK student and member of AAT and served as a bookkeeper for few UK clients I am good at computing input and outgoing VAT. A Mere

£21 GBP på 1 dag
(5 bedømmelser)
3.5
teeares

Hey, I worked with Excel for a long time and have completed many projects. Your project is fairly simple and I can do it quickly and accurately. All your requirements can be met,- specifically that of changing dates, a Mere

£12 GBP på 1 dag
(10 bedømmelser)
3.4
hdlong66

HEY. Have a look at ready work for points 1-3 here please [url removed, login to view] Wait for full details of this breakdown into 7 Tax Categories. Best regards

£18 GBP in 0 dage
(10 bedømmelser)
3.2
srikumar88

Dear Sir/Maam, I take pleasure in working with you. I would like to extend my association with you in delivering your requirements. Being from a dynamic customer service and support background, i feel confiden Mere

£18 GBP på 1 dag
(6 bedømmelser)
3.0
Suri1

Hey, Excel pro here with more than 6 years experience in Finance domain. I have a vast knowledge on Excel formulas & functions hence I can handle this task very efficiently. Please revert back if you are interest Mere

£13 GBP på 1 dag
(5 bedømmelser)
3.2