Excel Help Needed!
- or -
Post a project like this£30(approx. $38)
- Posted:
- Proposals: 45
- Remote
- #2380313
- Expired
|BPR|Research|Marketing|Translations|Design|Technical Support|Assistance|more... much more...
Quilmes
Excel Expert | Data Analysis | Business Plan | Research | Presentations Specialist
Jaipur
I will do anything in excel, Data Entry, Data analysis, macro, pivot, Dashboard Design, PDF to Excel, PDF to word, SEO Link building.
Dhaka
MS Excel, MS Word, Data Entry, Transcriptions, Excel Data Analysis, PDF Conversion, Web Research/Internet Reasearch, Project Mamagement, Other Admin Work
Greater Noida
Excel | Google Sheet | User Interface | Web App | Data Scraping | Internet Research | Photoshop Service
Jakarta
24544411750041271132827061101984435271584831556126286252738585242805419485371228050
Description
Experience Level: Entry
Excel wizard needed for small and simple project. Knowledge of VLookUp/table arrays/conditional formulas will be needed.
My situation:
I export my bank statements as XLS spreadsheets. I want to create a rough calculation of the amount of tax I need to pay. This will be calculated by:
1. Using the "Transaction Description" text to identify whether the transaction is a taxable income or not (this means I will require a table perhaps on another sheet of distinct values from the Transactions Description column). I need to be able to manually check a list of (distinct) transaction description text values and mark whether these are Income Taxable or not.
2. Once a transaction has been identified as a taxable income, I want to simply apply a flat rate of tax (20%) to return the taxable value in another column. This will result in two columns: one of the taxable value of that single transaction, and one column showing cumulative tax up to that period. This would help me, as throughout the year as I export and add my XLS bank statement records, I can have a rough idea of how much tax I need to put away to pay at the end of the financial year.
It's as simple as that. Quick and simple job for the right person. I'm essentially paying for the formulas and excel template which is suited to my needs, as I want to use the same template for different XLS sheets from different bank accounts. I can provide you with the sample bank statement sheet so you know the data we'll be working with. Let me know how you would approach the problem. Looking for a quick timeframe and fixed cost.
I am open to alternative solutions and suggestions for enhanced functionality, for the right price.
Thank you in advance.
My situation:
I export my bank statements as XLS spreadsheets. I want to create a rough calculation of the amount of tax I need to pay. This will be calculated by:
1. Using the "Transaction Description" text to identify whether the transaction is a taxable income or not (this means I will require a table perhaps on another sheet of distinct values from the Transactions Description column). I need to be able to manually check a list of (distinct) transaction description text values and mark whether these are Income Taxable or not.
2. Once a transaction has been identified as a taxable income, I want to simply apply a flat rate of tax (20%) to return the taxable value in another column. This will result in two columns: one of the taxable value of that single transaction, and one column showing cumulative tax up to that period. This would help me, as throughout the year as I export and add my XLS bank statement records, I can have a rough idea of how much tax I need to put away to pay at the end of the financial year.
It's as simple as that. Quick and simple job for the right person. I'm essentially paying for the formulas and excel template which is suited to my needs, as I want to use the same template for different XLS sheets from different bank accounts. I can provide you with the sample bank statement sheet so you know the data we'll be working with. Let me know how you would approach the problem. Looking for a quick timeframe and fixed cost.
I am open to alternative solutions and suggestions for enhanced functionality, for the right price.
Thank you in advance.
Sean G.
100% (46)Projects Completed
51
Freelancers worked with
26
Projects awarded
37%
Last project
30 Aug 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please send me a sample of your bank statement. Kind regards
-
can you send me the criteria or rule of tax in your country?
-
Could you forward the sample statement please
799986798578798383
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