Find Jobs
Hire Freelancers

Excel or Google sheets Data classification into categories summary and General ledger - 3 accounts

$30-250 USD

Closed
Posted about 3 years ago

$30-250 USD

Paid on delivery
I need help classifying the data from two bank accounts (one account has little transactions) + 1 PayPal account activity. The data is for the whole year 2020. I will provide CSV and PDF bank statements, and you can work on each one at a time to have a separate report per account, then merge all 3 accounts into the general ledger and category summary. So, once completed the file will have 6 tabs as follows: SUMMARY (this uses the data from the general ledger to show the total of each category) | General Ledger (this has the data from all 3 accounts). The categories are easy to classify because all charges are repeated monthly. I'll assist with some information, but I need you to google search the name of the companies paid in order to find the category for most of the entries. The entries are pretty much the same every month for this business (rent, utilities, employee payments, owner compensation, etc). There will be a lot of online charges that are owner compensation, you can google or bing search the name of the merchant to find out what type of merchandise or services were provided for those payment. I CAN HELP WITH THE CATEGORIES FOR THIS CLIENT with transactions like checks on the bank account and giving your general information about the monthly expenses like rent, phone, power, advertisement, donations, employees payment and so forth, but I need you to try to find out with online search the category for SOME of the miscellaneous charges on these bank accounts.
Project ID: 28906912

About the project

71 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
71 freelancers are bidding on average $140 USD for this job
User Avatar
hello sir, i have placed bid on ur project, we are very interested working with you, plz msg me so we can more talk and start work right now,thanx..
$120 USD in 1 day
4.9 (619 reviews)
7.7
7.7
User Avatar
Hi, I have checked the complete project details, every thing is clear, i will do the general ledger of 3 accounts and categorizing of the transactions. I have worked on similar projects for a CPA in US on ongoing Basis. I am very much interested in working with you on this project. Please award the project to get started. Thanks
$120 USD in 5 days
5.0 (199 reviews)
7.4
7.4
User Avatar
Hello, I've understood your project details and readdy to classify your bank transaction (2 checking account + 1 PayPal account) in google sheets. so lets discuss more about the project. you can also go through my profile for rearding my experience and past work. Best Regards Nitesh
$150 USD in 10 days
4.9 (76 reviews)
6.9
6.9
User Avatar
I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD in 1 day
4.7 (246 reviews)
6.8
6.8
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
$200 USD in 1 day
4.9 (164 reviews)
6.4
6.4
User Avatar
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
$140 USD in 7 days
4.7 (102 reviews)
6.5
6.5
User Avatar
Hello, Top of the day. Trust you are doing great. I will like to work with you on your project. I am a Professional Accountant, Researcher and Writer with wealth of experience in report writing, academic writing, finance, accounting, financial reporting, management accounting, financial management, corporate finance, budgeting, financial planning and analysis, auditing and diverse other fields. I have extensive experience in doing feasibility study, preparing business plans, designing marketing plans and strategy. I have magnitude of experience in preparing financial statements, investment appraisal, financial modelling - making financial projections/planning, business plans and linking the models together, ensuring consistency, simplicity, understandability and ultimately achieving its objective. I am highly proficient in the use of excel for solving business problems. I am happy to work on your data and account classification. I have strong flair for business analysis, finance and accounting and the use of excel in providing solutions. I look forward to your task as this would afford me the opportunity to diversify my experience and contribute to the success of your endeavour. I am also open to other opportunities of work you may have. My ultimate objective is to keep my customers & clients satisfied and delight them beyond expectation. I await your positive response & positive consideration. A trial will make the difference. Thank you.
$250 USD in 7 days
5.0 (43 reviews)
5.2
5.2
User Avatar
Dear Sir/Madam, I can categorise the transaction from the bank statement and pool them into common trial balance. I am ACCA (Chartered Accountant). I am expert in EXCEL, QB, XERO and WAVE. You can see my profile. I do have the ability to complete the assigned task within an agreed period of time. Thanks and Regards Muhammad Ilyas Saeed
$150 USD in 7 days
4.9 (59 reviews)
5.3
5.3
User Avatar
Hi , I can assist you, I have relevant expertise of accounting, categorizing, and generalization of accounts, I am professional accounts and finance manager with a professional team of CA, ACCA (UK), ACMA, CAT-Certified Accounting Technician (UK) and MBA-Finance, more than 14 years’ experience: Financial reporting/analysis, Ratios, periodically analyzing, Taxation, management accounting, Budgeting/Forecasting/projections. Capital Budgeting (NPV, IRR, Payback Period, WACC (Weighted Average Cost of Capital), Accounts Managements, Corporate Finance, Accounts/Bank reconciliations, Receivable/Payables, ERP, Oracle, Quick Book Xero and sage 50, Writing Business plan, critical essays, all management subjects Excel, Word, and presentation of PowerPoints, Waiting for your positive response Kind Regards, Habib
$140 USD in 7 days
4.9 (23 reviews)
5.1
5.1
User Avatar
Hi, I will categorise all the transaction from Bank and PayPal accounts and prepare you a Dashboard either in Google Sheet or Excel with the required Tab for GL and Summary.I will pick all the category based on the information provided by you and nature of transaction. I am a bookkeeper and I often do similar kind of task. I will try my best to search on Google for transaction category as much as possible and send you queries in case I don't get any transaction info on search engine. Please initiate chat for discussing in detail. Thank You Gopal
$200 USD in 5 days
4.6 (34 reviews)
5.5
5.5
User Avatar
Hello, Please review my profile as i have relevant skills and experience for this job, I can help you to classify your account and credit card statement into excel sheet. I have completed similar job before Kindly message me to discuss further Thanks Faiza Bilal
$120 USD in 5 days
5.0 (39 reviews)
4.1
4.1
User Avatar
hi I will provide you the required summary as I have already done the same job for 2 client where I provided with the pdf / CSV file for bank or PayPal statements..I extract the transaction and prepare the complete financial transactions..by using the description I Google it for finding the information about parties..I will do this work perfectly..let's have a deal
$278 USD in 5 days
5.0 (10 reviews)
4.1
4.1
User Avatar
Hey there, My name is Daniela, nice to e-meet you! I have experience as an accountant and I can help you with the excel reports needed for the 3 accounts. I'm okay with searching for the categories on which the expenses should go based on the company/ bank. we can discuss more over chat. Kind regards!
$250 USD in 1 day
5.0 (4 reviews)
4.0
4.0
User Avatar
Hi, I am an Excel Expert with Professional experince working with Excel. I believe I can do a great work for you and ensure your quality. I have more than 5 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client.
$30 USD in 1 day
4.9 (25 reviews)
3.9
3.9
User Avatar
Hi there! I am a certified business accountant, After carefully reading your project description, I think that I am the perfect candidate! With over 13 years of experience. I have good working experience in Quickbooks online + MS Excel/Google Sheets and I have successfully completed similar kind of projects for my past clients. I can do you work "Data classification into categories summary and General ledger" accuretly. I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Franz
$55 USD in 3 days
5.0 (18 reviews)
3.9
3.9
User Avatar
Hi, Thank you for reading my response. I am A qualified CA & CPA. I hold more than 7 yrs of experience in field of Accounting, Finance , Payroll and Taxation. After reading your project keenly I can assure you that I can provide the best quality of work within timeframe at an affordable price. I believe in working smoothly and provide peace of mind to my clients. Highly looking for your consideration. I am a Certified Quickbooks ProAdvisor. Kindly text me in here for a quick discussion on your project. It would be my pleasure to avail best of my services to you. Thank You Regards, Neeraj Bansal
$200 USD in 2 days
4.9 (25 reviews)
3.9
3.9
User Avatar
Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun
$150 USD in 2 days
5.0 (10 reviews)
3.5
3.5
User Avatar
Dear Employer, I am an accountant by profession with an eye for details. I have reviewed the ledger attached (on another listing) and I would like to help you in analyzing the credit cards and bank statements. I look forward to reading from you. Regards, Moses
$250 USD in 7 days
5.0 (3 reviews)
2.7
2.7
User Avatar
Respected Hirer! I will provide a summary and general ledgers to you within short time and very accurately. I am expert in these tasks. You can see my portfolio. You can get your results in effectively and quickly. waiting for your favorable response. thanks & best regards salman naseer
$70 USD in 1 day
4.8 (2 reviews)
2.5
2.5
User Avatar
Hi there I work daily in excel, categorizing and handling data at the company i work for. I've done work similar to this multiple times before. Please message me and we'll go over the details, like what categories you'd like. Looking forward hearing from you, Thanks
$40 USD in 1 day
5.0 (4 reviews)
1.6
1.6

About the client

Flag of UNITED STATES
Selma, United States
5.0
9
Payment method verified
Member since Feb 15, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.