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