Accounting for sales event with multi sellers

Ολοκληρωμένο Αναρτήθηκε Πριν 7 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

We have run a Sales event that had multiple sellers (about 30) from multiple countries (6 countries).

The event received a grant and also the sales were cashed in by the common entity (cooperative) on behalf of the sellers

Part of the sales were cashed through an electronic point of sales, with the CSV/Excel file available. The other part of the sales were cashed in cash, and transactions are documented in an excel sheet too.

All sales have been spitted per sellers and countries on an excel file

What we need is:

- A proper template of accounting in excel to record and display the transactions and reporting in the norms of UK accounting (P&L etc...)

- A reporting of sales per seller, per day, per country that also deducts from the seller's income some common fees or advance payments they received. The idea is that the seller can sign against this report to confirm he received all dues.

- Organize and populate a google drive (or other) folder with all related documents, invoices for expenses etc..

- All data should be in one excel file so that the totals and different parameters are automatically updated if we add new transactions or correct/change some figures

- Generate some graphs in bar charts (evolution of daily sales) and pie charts (sales per country) etc.

Please provide a sample excel file that can do something similar as what we have asked

thank you in advance

Λογιστικά Εισαγωγή Δεδομένων

Ταυτότητα Εργασίας: #11114575

Σχετικά με την εργασία

25 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 7 χρόνια

Ανατέθηκε στον:

rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Περισσότερα

$155 USD σε 3 μέρες
(66 Αξιολογήσεις)
6.3

25 freelancers κάνουν προσφορές κατά μέσο όρο $211 για αυτή τη δουλειά

caabdul

Hi, I have excellent excel and finance skills and this job is perfect match for me. Let me complete it. Thanks

$250 USD σε 4 μέρες
(119 Αξιολογήσεις)
6.9
someka

I have prepared some sales dashboards, tracking templates etc. I can provide samples. If you want we can discuss in details. Regards.

$315 USD σε 3 μέρες
(79 Αξιολογήσεις)
6.8
kamrananjum1

Hi, I am a qualified and experienced Chartered accountant with excellent command over Excel. I can do what you have required. I am providing book keeping services using Quick Books, Xero, Myob and other most commonl Περισσότερα

$210 USD σε 6 μέρες
(55 Αξιολογήσεις)
6.3
kohencpa

Hi, I am a licensed CPA with many years of experience. I provide bookeeping, payroll, accounting and tax services to small businesses. Please contact me to get started.

$555 USD σε 7 μέρες
(14 Αξιολογήσεις)
5.0
webprog4hire

hi i m master in rent manager/quick books n erply and excel and give you complete solution lets discuss here

$277 USD σε 5 μέρες
(5 Αξιολογήσεις)
4.0
malikamjadhussai

Hello.. I'm interested in the project you are offering. I am doing free lancing. I want to build my reputation here so I do the work to my best to get wonderful feedback and rating and that's what you are gonna ge Περισσότερα

$222 USD σε 7 μέρες
(7 Αξιολογήσεις)
3.1
bashir786wmc

You pay me after checking the work. Hi I have read out all the details given in your project and I am fully capable to deliver you this project with 100% accuracy. I have completed many projects related to this in t Περισσότερα

$138 USD σε 2 μέρες
(4 Αξιολογήσεις)
2.2
fathy2015

A proposal has not yet been provided

$222 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
sukrijohn

My goal is to achieve professional excellence and contribute my wholehearted efforts for the benefit of an organization that provides me a platform to utilize my knowledge and experience while learning the latest advan Περισσότερα

$155 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0
ruchimehta1

During my professional career as an equity research analyst, I have been involved in significant amount of data mining on various companies, analyzing them and presenting them in the form of reports, excel models and p Περισσότερα

$111 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
pkpsarun

I believe my self My strength is documentation Give work i will do my level best You will be happy after my work

$155 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Salabin

A proposal has not yet been provided

$222 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
DataEntryAdept

Dear employer, I had taken a overview on this project. This is definitely something i can help you with. If you want then we can discuss further. Looking forward to hear from you. Warm regards by MD FERDOUS ALAM

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
sheerin16

A proposal has not yet been provided

$277 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
Maheshkumarakv

Hi I'm Maheshkumara KV from India, I did Masters of Finance and accounts(Post Graduation). I have an experience of more than 2 years In Accounting and Internal Audit under Audit firm. I Can provide service to Client w Περισσότερα

$111 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
georgetowngrad

Excellent excel skills. Extremely smart, very diligent, work is done 100%, and I respond within minutes to any adjutments you need. Worked on excel every day of my working career at Bank of America and General Elect Περισσότερα

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
hrrecruiter130

Experience

$333 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
diyadee30

I need a job. Please hire me and i will do what you need to your job. I know very must about excel, data entry and accounting.

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
Akriti05

A proposal has not yet been provided

$277 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0