Excel Database and Data Entry
- or -
Post a project like this3313
$$
- Posted:
- Proposals: 36
- Remote
- #695440
- Completed
Data Entry, Web Scraping, Admin, Virtual Assistant, Customer Services, UNSPSC classification
Hampshire
Lead Generation,Data Analysis,Data Visualization,Dashboard,LinkedIn Leads,Market Research,MS Excel,Google sheets,Web Research,CRM/CMS,Google Ads,PPC
Bay Minette
6160576907789751043664812571831362086902294282541212878883684474893
Description
Experience Level: Intermediate
I would like to enquire as to whether you could do the below job, approximate cost and timescale.
Hope the below is clear/makes sense! Any questions you might have please let me know.
Thanks
Caroline Porter
Require an excel database for bank account debits created with the following columns and data entry from bank statements into those columns.
Date
Debit Type
Description
Transaction Date
Amount
All of the information is to be taken from bank statements. I have attached a few statements to give you an idea.
The bank statements are all scanned pdf’s. I have them the file share website for you to access with your own login. There are 310 bank statement sheets with varying amounts of data that would need extracted. Some of these bank statements have hand writing on them. Any handwritten notes are to be ignored. Some of the entries for cheque withdrawals also have a line through them – this is to be ignored and details of cheque debits are to be included.
All information is confidential! Which I am sure you already know, but just in case.
The information for the columns is explained below.
Date: This is the corresponding date from the far left of the statement under the statement column heading Date.
Debit Type: Information found under Details column of statement. Will either be Card Transaction, Cheque, Direct Debit or Cash Withdrawal.
Description: Again information for this will be found under the Details column of statement. In the case of a Card Transaction the description to be added here will be the retailer/supplier name. In the case of a Cheque just put the cheque number. In the case of Direct Debit enter name of who direct debit going to. In the case of Cash Withdrawal please put the details of where withdrawn from location.
Transaction Date: Many of the Card Transaction’s and Cash Withdrawals have different dates noted in the Details column of the bank statements. Please enter that date here.
Amount: This is the amount in the Withdrawn column of the bank statement.
Hope the below is clear/makes sense! Any questions you might have please let me know.
Thanks
Caroline Porter
Require an excel database for bank account debits created with the following columns and data entry from bank statements into those columns.
Date
Debit Type
Description
Transaction Date
Amount
All of the information is to be taken from bank statements. I have attached a few statements to give you an idea.
The bank statements are all scanned pdf’s. I have them the file share website for you to access with your own login. There are 310 bank statement sheets with varying amounts of data that would need extracted. Some of these bank statements have hand writing on them. Any handwritten notes are to be ignored. Some of the entries for cheque withdrawals also have a line through them – this is to be ignored and details of cheque debits are to be included.
All information is confidential! Which I am sure you already know, but just in case.
The information for the columns is explained below.
Date: This is the corresponding date from the far left of the statement under the statement column heading Date.
Debit Type: Information found under Details column of statement. Will either be Card Transaction, Cheque, Direct Debit or Cash Withdrawal.
Description: Again information for this will be found under the Details column of statement. In the case of a Card Transaction the description to be added here will be the retailer/supplier name. In the case of a Cheque just put the cheque number. In the case of Direct Debit enter name of who direct debit going to. In the case of Cash Withdrawal please put the details of where withdrawn from location.
Transaction Date: Many of the Card Transaction’s and Cash Withdrawals have different dates noted in the Details column of the bank statements. Please enter that date here.
Amount: This is the amount in the Withdrawn column of the bank statement.
Lally P.
100% (16)Projects Completed
15
Freelancers worked with
13
Projects awarded
50%
Last project
7 Mar 2022
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