Excel Sales & expenses spreadsheet

Completato Pubblicato Nov 28, 2014 Pagato alla consegna
Completato Pagato alla consegna

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

Excel Architettura Software

Rif. progetto: #6797204

Info sul progetto

13 proposte Progetto a distanza Attivo Dec 2, 2014

Assegnato 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 Altro

$444 USD in 4 giorni
(129 valutazioni)
6.1

13 freelance hanno fatto un'offerta media di $244 per questo lavoro

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 Altro

$400 USD in 2 giorni
(256 valutazioni)
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 Altro

$189 USD in 2 giorni
(86 valutazioni)
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 Altro

$225 USD in 1 giorno
(109 valutazioni)
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 Altro

$233 USD in 4 giorni
(8 valutazioni)
4.1
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 Altro

$155 USD in 3 giorni
(14 valutazioni)
3.6
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, Altro

$250 USD in 7 giorni
(16 valutazioni)
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 Altro

$155 USD in 3 giorni
(6 valutazioni)
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 Altro

$150 USD in 3 giorni
(2 valutazioni)
1.7
jyothi123

A proposal has not yet been provided

$244 USD in 2 giorni
(0 valutazioni)
0.0