Data Entry / Book Keeping

Here is one of the hundreds of service requests from my previous client
Scope of work:
- 1. Engagement (Handing the email communications and coordination to the client, passenger, and driver.)
- 2. Lead Engager (Will gather nearest landmarks about the Pickup and drop point of the passenger and relay it to the drivers.)
- 3. Data Entry / Bookkeeping (Converting, arranging, Reviewing data for errors, correcting any incompatibilities, Compiling to prepare the raw data for data entry, Account Payables, Account Receivables, and Updating the balance sheet.)
Below are the processes that I made:
- I am receiving the request thru email with the corresponding details such as Passenger name, Address, Contact number, Date of servicing, Pick up point, Drop point and etc. You may refer to the image below.
- After reviewing the email, I will assign the driver and I will be going to transfer the data to an excel file and arrange it based on chronological order (Date and Time). See the image below.
- After the servicing was made, I am going to collect the trip data, the receipt for reimbursements, and other expenses.
- When the arrangement of all the collected data is finished, it will now be transferred into a Billing form (Another excel file) to be submitted to the client for payments and update the balance sheet for other expenses and reimbursements.
*Below are the sample works for Bookkeeping.