Em Andamento

Excel Sales & expenses spreadsheet

Hello,

I would like the following to be done 12:00 GMT Sunday 1st December 2014, is this possible?

I would like the attached excel spreadsheet to be able to handle copy & pasted information from other excel spreadsheets that I have exported from sage accountancy software.

Firstly, this data isn’t going to be planned expenses it’s going to be actual expenses.

We would need sheets created for each category on the actual expenses column, so when the pasted information is entered on to that particular sheet, it would automatically put in the correct totals in the cell (month, category, row, column) on the actual expenses sheet.

Please note, for each category, there will be different suppliers to be up-loaded to that sheet. However, we don’t need this itemised on the actual expenses sheet, just the correct month & category.

Problems

Sometimes, a particular supplier might service 95% one category and 5% another, so would it be possible to have a column added, for example ‘Column A’ which could override the pre-determined sheet category and put it in a category of my choosing.

In the exported files from sage, it brings up purchase payment, you can see this in row details. Can you get it to ignore any amounts if ‘Purchase Payment’ is in that row?

Also

I would like another sheet which totals all of the expenses. Which will be called ‘Planned Expenses’.

Can we have a column on the internal sheet (expense categories) pages which can determine whether it’s going to be a planned expense for the coming year?

Can we also have a expense analysis sheet which would do all of the usual such as bar chart, pie chart, variances, differences between this year’s actual expenses and next years planned expenses?

Can we have an expense category to separate the office staff’s work between driving and office duties by percentage?

Sales

To have similar to above for sales, where we can import data from sage accountancy software. The categories & sub-categories for this section would be;

• Schools contracts

- Taxis

- 8 Seater’s

- PSV’s

• Private Hire

- Taxis & 8 Seater’s

- PSV’s

• Corporate account work

• Activity Transport

- Walking

- Cycling

Again, this would need a sales analysis, which would do all of the usual such as bar chart, pie chart, variances, differences between this year’s actual sales and next years planned sales?

Add another analysis page where it compares expenses against sales.

In addition

Is there a way of keeping this current and ongoing so that I can add information quarterly and it will give me the differences between planned V actual expenses and the same for sales (planned & actual)?

Analysis & categorising of Tax & VAT

In the imported data, you have a column called TC – if the code is T1 the amount includes 20% TAX (VAT), all other codes the amount has no TAX. All other codes ie, T0 T9 are exempt from TAX which I would need in the expenses analysis to be separated and the same doing for sales.

$25 bonus if completed on time

Habilidades: Excel, Arquitetura de software

Ver mais: work activity, tc page, tc data, service spreadsheet, my tc, service contracts, hire tax account, example service contracts, month spreadsheet, accountancy software, accountancy need, vat payment, separate data spreadsheet cell, sales sheet, row spreadsheet, need staff account, corporate sales, accountancy , account spreadsheet, excel categories, separate excel data sheets, ongoing spreadsheet, activity spreadsheet, excel row column, spreadsheet sales

Acerca do Empregador:
( 13 comentários ) Hexham, United Kingdom

ID do Projeto: #6797204

Premiar a:

koolsidz

I could have given you the file on Sunday but I don't want to do a shabby job. I want to discuss the entire project on skype with you. Plan a strategy and then proceed with the project. If you are ready to do this t Mais

$444 USD em 4 dias
(129 Avaliações)
6.1

13 freelancers estão ofertando em média $244 para este trabalho

Teloquence

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E Mais

$400 USD in 2 dias
(256 Comentários)
7.2
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 Mais

$189 USD in 2 dias
(86 Comentários)
6.1
customizedata

I have download the attached sheet. I have few questions 1- Actual expense column is in which sheet ? 2- Where are the categories , will they remain static or dynamic? 3- need to discuss about "95% one category an Mais

$225 USD em 1 dia
(109 Comentários)
5.9
Midlander

I have worked successfully to many short deadlines but you need to clarify yours. Sunday (today) is 30 Nov, not 1 Dec..I assume you meant midday next Sunday (8 Dec)? I designed dashboards, reports and interactive sp Mais

$233 USD in 4 dias
(8 Comentários)
4.1
mach4business

HIII I have gone through your Job.I can do that job with 100 % Accuracy. I have vast knowledge on Microsoft Excel and Data Management!!! We are familiar with : • Lookups • Counting and summing formulas(COUNT, COU Mais

$222 USD in 2 dias
(7 Comentários)
4.0
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz Mais

$155 USD in 3 dias
(14 Comentários)
3.6
ayanbishnu

Hi I can assure you that i am having the best excel experience and i can do almost everything possible with excel. Please check my review in freelancer.com IF you need see some samples of my work, then, pleas Mais

$252 USD in 15 dias
(5 Comentários)
3.4
qrtzcom

Dear hiring Executive, I am expert in, Web Design and Theme Development, Graphics Design (Adobe Photoshop, Illustrator), Logo design, classified posting, E-bay listing, Data Entry, Email Marketing, Keyword Research, Mais

$250 USD in 7 dias
(16 Comentários)
3.1
TonmoyRoy111

Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in Mais

$155 USD in 3 dias
(6 Comentários)
2.3
NaveenNishaan

Dear Sir/Madam, We are experience Java/J2EE developer with immense experience in designing and developing highly customized and business specific utility. We can offer you a customized application to meet all you Mais

$150 USD in 3 dias
(2 Comentários)
1.7
jyothi123

A proposal has not yet been provided

$244 USD in 2 dias
(0 Comentários)
0.0
florinbogdan18

florinbogdan18 at gmail.com florinbogdan18 at gmail.com florinbogdan18 at gmail.com florinbogdan18 at gmail.com

$250 USD in 3 dias
(0 Comentários)
0.0