Business Administration Support and Excel Spreadsheet Preparation
- or -
Post a project like this2074
$20
- Posted:
- Proposals: 3
- Remote
- #2081068
- Awarded
Description
Experience Level: Entry
OBJECTIVE : Prepare a Profit and Loss Account for year ended 31st December 2017
The work in overview consists of –
*Listing and analyzing the costs per the expense receipts per Yahoo email folder
*Analyzing bank payments ( Bank Payments Tab ) per the Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive ( combine with the Excel spreadsheet for the period 1st January 2017 to 5th April 2017.
*Compare the two analyses to identify any expenditure items which may have been double counted.
*Analyse and Summarise Sales from Excel spreadsheet ( Bank Lodgements Tab ).
Listing and analyzing the costs per the expense receipts per Yahoo email folder
NOTE : To access John’s folders of expenses receipts you will need to access the folders in his email account. I will provide log on details to the successful applicant.
List costs/details of each receipt onto Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive
Enter the following information in respect of each receipt :-
Receipt Date
Description of the Cost ( please enter the fullest description possible to help us to decide on the correct cost category to analyse each cost to )
Name of Payee
Amount ( please note : separate column required for each currency ( £ sterling, USD, Euros, Canadian $ )
I then need you to analyse the costs for each currency ( “ copy and paste “….. I need a separate tab for each currency ). Then add all columns and cross add analyses columns totals to agree to the original “ amount “ column.
Analyzing bank payments ( all in £ sterling ) per the Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive
Go to Google sheets via the link to be provided to the successful applicant to see cost descriptions entered.Please analyse all costs to the appropriate cost category. Then add all columns and cross add analyses columns totals to agree to the original “ amount “ column.
THEN, we are on to the final two steps on the work program i.e…….
*Compare the two analyses to identify any expenditure items which may have been double counted.
*Analyse and Summarise Sales from Excel spreadsheet ( Bank Lodgements Tab ).
The job is budgeted to take no more than 12 hours.
The job deadline is 30th July.
The work in overview consists of –
*Listing and analyzing the costs per the expense receipts per Yahoo email folder
*Analyzing bank payments ( Bank Payments Tab ) per the Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive ( combine with the Excel spreadsheet for the period 1st January 2017 to 5th April 2017.
*Compare the two analyses to identify any expenditure items which may have been double counted.
*Analyse and Summarise Sales from Excel spreadsheet ( Bank Lodgements Tab ).
Listing and analyzing the costs per the expense receipts per Yahoo email folder
NOTE : To access John’s folders of expenses receipts you will need to access the folders in his email account. I will provide log on details to the successful applicant.
List costs/details of each receipt onto Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive
Enter the following information in respect of each receipt :-
Receipt Date
Description of the Cost ( please enter the fullest description possible to help us to decide on the correct cost category to analyse each cost to )
Name of Payee
Amount ( please note : separate column required for each currency ( £ sterling, USD, Euros, Canadian $ )
I then need you to analyse the costs for each currency ( “ copy and paste “….. I need a separate tab for each currency ). Then add all columns and cross add analyses columns totals to agree to the original “ amount “ column.
Analyzing bank payments ( all in £ sterling ) per the Excel spreadsheet for the period 6th April 2017 to 31st December 2017 inclusive
Go to Google sheets via the link to be provided to the successful applicant to see cost descriptions entered.Please analyse all costs to the appropriate cost category. Then add all columns and cross add analyses columns totals to agree to the original “ amount “ column.
THEN, we are on to the final two steps on the work program i.e…….
*Compare the two analyses to identify any expenditure items which may have been double counted.
*Analyse and Summarise Sales from Excel spreadsheet ( Bank Lodgements Tab ).
The job is budgeted to take no more than 12 hours.
The job deadline is 30th July.
Jim M.
100% (1)Projects Completed
-
Freelancers worked with
-
Projects awarded
50%
Last project
23 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies