Excel accounting spreadsheet jobs

I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you help me d...

...can help me with a range of accounting services including tax preparation, bookkeeping, financial reporting, legal, and post incorporation. Key Responsibilities: - Tax preparation: Assist with the preparation and filing of taxes for my business, ensuring compliance with all relevant regulations. - Bookkeeping: Maintain accurate records of all financial transactions, ensuring that all expenses and income are correctly recorded and categorized. - Financial Reporting: Generate regular reports that provide insight into the financial health of my business, making recommendations for improvement where necessary. - Legal: Ensure that all financial practices and procedures are compliant with relevant laws and regulations. - Post Incorporation: Assist with various accounting tasks...

As the client, I'm seeking a freelancer to build a robust list of leads for various small businesses in Australia. These businesses include: - Hair salons and beauty clinics - Dental practices - Cafes and takeaway food shops - Gyms - Accounting practices - Law firms The information required for each lead consists of: - Business name - Email address - Contact number - Business address - State - Postcode - Category of business I want the address state and postcode to be presented distinctly in different columns. The data must be accurate, as it is essential for our marketing campaigns. Ideal freelancers for this project would be those with experience in data mining and lead generation, proven research skills, and knowledge of Australian small businesses.

I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.

...require an accounting professional to create a concise and informative presentation of approximately 5 minutes in duration. The material to be covered in the presentation will include details on financial statements, taxation, budgeting, and forecasting. I will provide any additional information required and am open to any suggestions and ideas you may have to improve the impact and engagement of the presentation. The ideal candidate should have: - Extensive experience in accounting and financial presentation - Strong understanding of financial reporting, taxation, and budgeting - Ability to condense complex information into an engaging and clear 5-minute presentation - Great communication skills and attention to detail I am looking for a compelling and accessible a...

...In order to be considered for this project the freelancer shall submit, in detail their proposed solution, including how they would deliver it, what they would require in order to get it done, data safety protocol, secure development, timeline, budget, ongoing/maintenance cost, training on system, rework/bug fixes. -Modules: I require the following modules to be incorporated: Sales and CRM, Accounting and Finance, Inventory and Warehouse Management, Project, Timesheets, Social Marketing, Customer portal, Documents, and Contracts -Design: I envision a clean and modern UI design for the community. The interface should be user-friendly, intuitive, and visually pleasing. -Customer Portal Integration: The customer portal must be smoothly integrated with the main website. This sea...

I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from...

Please Sign Up or Login to see details.

I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.

I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...

Description: I need an app (iOS) to automate data entry into a Google Spreadsheet used for my car rental business. Each tab in the spreadsheet represents a specific car. The app should allow employees to: Select a car category (corresponding to a tab in the spreadsheet). Select a rental date. Input various amounts (e.g., rental income, expenses). Automatically update the corresponding tab in the Google Sheet with the provided data. Requirements: Experience with Python and Google Sheets API. Ability to create a user-friendly interface. Strong understanding of gspread and oauth2client libraries. Good communication skills and responsiveness. Deliverables: A functional app that performs the required operations. Documentation on how to set up and use the app. Support for...

I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.

I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please ...

I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored

excel assignment for an event study. template and example below

I am seeking a skilled programmer who can create an intelligent BOT that's able to traverse my google spreadsheet and scrutinize incoming leads based on their EPC status. The main functionalities required are: - Retrieving Contact Details and EPC Status: The BOT should be able to fetch the contact details of leads and simultaneously check their EPC statuses. - Highlighting Matches: In case a lead matches the EPC status I am in search for, the BOT should distinctly highlight the respective row in the spreadsheet. - Segregating Non-Matches: The BOT should be capable of moving the leads that do not match the desired EPC status to a separate section in the spreadsheet. Ideal skills for this job would be advanced Python or Java programming capabilities, extensive...

I'm in need of a professional accountant to handle my quarterly bookkeeping and financial statements. The ideal candidate should be well-versed in accounting principles and practices, have experience in bookkeeping and financial statement preparation. Familiarity with QuickBooks and Excel is crucial. Key responsibilities: - Perform quarterly bookkeeping tasks - Prepare accurate and timely financial statements - Maintain clear and organized financial records The successful freelancer will be consistent, detail-oriented, and able to meet deadlines. Experience with similar projects is a plus. Please provide your relevant experience along with your bid.

I am...be thoroughly accurate and easy to comprehend. - Record Management: Ensuring all records are properly organized and maintained. - Daily Reports: Providing a daily summary of the business transactions. - Accountability: Ensuring all financial transactions are transparent and trackable. Ideal Skills and Experience: - Proven experience as an accountant undertaking similar tasks. - Proficiency in accounting software - while I am open to different options, a background in QuickBooks, Xero, or FreshBooks is beneficial. - Strong organizational skills - managing records and reports effectively is crucial. - Excellent analytical and problem-solving skills. Please only apply if you can commit to monthly financial statement preparation and possess the necessary skills and experience. ...

Develop macro-enabled Excel workbook

Data Entry from Scanned Business Cards to Excel We are looking for a highly meticulous data entry specialist to transfer information from approximately 2400 scanned business cards into an Excel spreadsheet. === Data Points to Include for Each Card: 1. Name, Position, Company, Phone (include all numbers, Fax (if available) and correct country code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * T...

...pickup, integration to other delivery platforms - [ ] Staff Management, time sheets - [ ] Digital Menu Management, View the menu on mobile and make order and payment - [ ] Reporting & Analytics - [ ] Kitchen Management - [ ] Inventory Control - [ ] BOM creation - [ ] BOM’s in progress and duration - [ ] multiple printers and printing order - [ ] integration with QuickBooks or other custom accounting platforms (open API) To be more clear about what we require you should check the following platforms: Interface should be modern and easy to use platform should be multi-lingual, starting with English and Arabic 
 prior to any development UI/UX should be confirmed 


Before any development is taken place

I require a proficient and diligent professional with experience in Excel-based accounting services. The crux of the project revolves around preparing and analyzing cash flow statements on a monthly basis. Your tasks will include: - Thorough preparation of Cash Flow Statements. - Detailed monthly Cash Flow Analysis. - Application of Ratio Analysis for statement analysis. The ideal candidate will have a strong grasp of Cash Flow statements, monthly breakdowns, and Ratio Analysis. They will excel in attention to detail and accuracy, grounded in solid financial and accounting experience.

As an AI Engineer, I'm looking for a specialist to develop an AI system that is proficient in machine learning and computer vision. In particular, I need the system to excel in image recognition and data analysis. Ideal Skills: - Proficiency in machine learning and computer vision - Extensive experience with image recognition and data analysis - Skilled in Python, TensorFlow, and PyTorch The AI Engineer must also have a solid understanding of the Python programming language, as well as experience working with TensorFlow and PyTorch frameworks. The ideal candidate will be able to demonstrate a strong track record in developing and implementing AI systems that can successfully perform image recognition and data analysis tasks.

I require an extensive and careful research task to be undertaken for a list of 8,000 businesses across a region of the UK. I am looking for specific data points, such as: - Names of Managing Directors - Their respecti...accurate data collation and verification and be well-versed with up-to-date UK business registries or databases which must include the businesses website and LinkedIn. A keen attention to detail is necessary, as I require accurate, reliable data. Prior knowledge of UK businesses, particularly management hierarchy, would be advantageous. All information is to be delivered in an easy-to-read Excel spreadsheet format. Note: For the task at hand, focus needs to be put on only current Managing Directors and/or Business Owners. I do not require information on any...

I need a comprehensive angel investor list for North America in an Excel spreadsheet. The list should cover all the necessary details for each investor, including but not limited to: - Name and contact information - Investment preferences - Industry expertise - Geographic preferences - Industry preferences - Investment stage - Average Investment Amount - Membership model - Membership fees There are additional questions we would like answered. PLEASE READ THE ATTACHED DOCUMENT FOR ALL INFORMATION SOUGHT. The ideal freelancer should have experience in compiling such lists and should be able to deliver a well-structured and detailed Excel spreadsheet. The list should be easily navigable and professional, making it easier for me to reach out to potential investo...

I am in need of a skilled professional who can provide the following accounting services using Excel: - Preparation of Financial statements - Cash flow analysis - Financial statements analysis You will be ideally proficient in Excel-based financial modeling and analysis, understanding how to manipulate and interpret data to present clear, concise, and informative reports. A solid background in accounting will ensure accuracy in financial statement preparation and analysis. Your ability to meet deadlines with minimal supervision will be a crucial factor for success. Existing familiarity with my current accounting software, Excel, is mandatory. A background in business finance or related fields and demonstrated experience in similar roles will ...

I need an iOS app developed that allows for data entry, spreadsheet viewing, and data manipulation. The design should be colorful and vibrant to make it visually appealing, yet simple to use. Authentication will not be required as all data should stay on the device, ensuring privacy. I need to get a finance tracker for all my personal accounts. I need a place to input values from banks, fund houses, sips etc, which would be stored in the file and give me nice dashboard of my funds, current and previous month comparison and growth calculations. I already have a sheet that I use, which can be a starting point. Ideal Skills: - Swift or Objective-C programming - UI/UX design with an eye for vibrant color schemes - Experience with data manipulation and presentation on mobile devices...

I'm in need of a skilled ERPNext Frappe developer who can effectively manage and customize modules such as Sales and CRM, Inventory Management, and Accounting and Finance. The ideal candidate should have extensive experience in modifying the functionality and interfaces of these modules to meet specific business requirements. Key Requirements: - Proficient in ERPNext and Frappe Framework - Prior experience in customizing ERPNext Sales and CRM, Inventory Management, and Accounting and Finance modules - Ability to perform functional modifications and user interface changes to fit the unique business processes The freelancer's primary task will be to make the necessary adjustments to optimize the system for my business, ensuring a seamless integration of the modu...

I need a skilled web developer to duplicate 785 WordPress pages within 1 hour. The project involves customization of the URL and page title to align with specific city names provided in an Excel sheet. Key Requirements: - Duplicate 785 WordPress pages quickly and accurately - Customize the URL and title of each page according to its respective city - Ensure that the formatting and layout of the duplicated pages remain consistent with the original - Provide a high level of detail and accuracy to maintain the integrity of the multi-location business promotion strategy Ideal Skills and Experience: - Proficiency in WordPress and web development - Ability to work quickly and accurately under time constraints - Strong attention to detail to ensure correct customization of each page - Ex...

I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Encompasses a...

I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Enco...

As an organization, we are seeking an experienced Data Analytics & MIS Executive to handle critical tasks in the realm of data analysis and MIS. Key Responsibilities: - Conduct in-depth data analysis - Generate regular and ad-hoc reports - Optimize our data systems Skills & Experience Required: - Proficiency in Excel - Proficiency in Power BI - Experience in working with sales data - Experience in working with customer data - Experience in working with EV Car booking data Your role will involve using your analytical skills to interpret complex data and generate insightful reports. You'll also be responsible for ensuring that our systems are optimized for maximum efficiency. The ideal candidate for this role should be a highly skilled professional with a proven track...

You will be required to Copy technical part number from PDFs to excel file. Most of the files have copy paste enabled. I have around 400 PDFs. The brief provided will be very precise and easy to follow. Its a long term project. Will have projects on monthly basis If you understand what we are looking for. A fairly simple project with easy guide to follow through

Monthly, we populate a spreadsheet with the over time of the technical team, and the weekend / night shifts of the tehnicians working outside the business hours. We have a template that we want to improve. 2 categories: 1. Managers doing overtime (regular / night / weekend) and being oncall. 2. 24h shifts: complement to the salary based on night / weekend hours we should be able to calculate monthly the amount to be added to the fixed salary attached template (with complicated formulas and errors)

I have a pressing need to transfer a large quantity of image files. Key Requirements: - Data Transfer: You will be tasked with swiftly transferring a substantial number of image files. - Organization in Excel: Following the transfer, you should organize these images in an Excel document. While this is not a conventional method for handling images, it is a specific requirement for my project. Ideal Skills: - Proficient in Data Transfer: You need to be skilled in transferring data swiftly and accurately. - Excel Expertise: You should have experience in using Excel to organize and manage files. Timeframe: - I would prefer this project to be completed as soon as possible. Please only apply if you have the necessary skills and capacity to deliver on this urg...

I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item

...with a runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models into Ex...

I'm in need of a skilled mobile app developer to create a cross-platform accounting application for me. The application should be primarily focused on accounting functionalities. Key Requirements: - Development for both iOS and Android platforms - The main functionality of the app should be around accounting - The app should specifically include features such as: - Expense tracking - Invoicing and billing Ideal Skills and Experience: - Proven experience in developing and deploying cross-platform mobile applications - Strong background in accounting software and functionality - Familiarity with incorporating and customizing features like expense tracking and invoicing in mobile apps - High proficiency in coding for iOS and Android Please include examp...

... I am in search of a committed, long-term virtual assistant with fluency in speaking in both English and Spanish. This position requires a 15-hour per week commitment (3 hours per day, 5 days a week) with flexible scheduling. Here's an overview of the job responsibilities: First 30 minutes: -Daily posting in various Facebook groups -Responding to Facebook messages -Inputting data into a spreadsheet from Facebook messages Next 1 hour and 30 minutes: -Comparative analysis of local home prices to determine probable selling prices (Training provided) -Providing offers to sellers (Scripts provided) Final 1 hour: -Calling Spanish and English-speaking sellers in Texas (Phone numbers and scripts provided) Incentive Bonuses Based on Performance Your dedication and hard work wi...

Create a public dashboard from Looker Studio reading data from excel / google sheets.

ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.

I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A stro...

I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.

Looking for an efficient, detail-oriented freelancer to recreate an existing one-page design on an Excel sheet, intended solely for data entry. You must be swift but precise, ensuring all data entered is accurate and comprehensive. I will provide the design for recreating, so your task will be purely focused on data entry. Skills & Experience: - Proficiency in Excel - High attention to detail - Speed in data entry without jeopardizing quality - Familiarity with handling and organizing large data sets.

I'm in need of a proficient data entry professional who will enter customer data into Excel spreadsheets. Key Responsibilities: - Transfer customer data accurately into Excel - Double-check data for mistakes or inconsistencies - Maintain confidentiality of customer data Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience with data entry tasks - Strong understanding of handling sensitive customer data.

I am seeking a proficient freelancer who can effectively extract data from six graphs (line and area) and reproduce the graph in Excel. Please review the attached Excel file for grahps (3 of them are already processed as an example). Ideal Skills & Experience: - Demonstrated ability in data extraction - Excel competence - A keen eye for detail Freelancers should include examples of their past work for consideration. Your bid should be reflective of your skills and experience. I am looking forward to viewing your proposals. Please make them as detailed as possible.

I urgently require a professional to help me with an operations job. The specific tasks and software knowledge required are undefined as I am currently uncertain of my specific needs. Ideal Skills and Experience: - Experience in diverse operations tasks like data entry, order tracking, and document organization - Proficiency in using a range of software like Microsoft Excel, inventory management systems, and quality control software. A willingness to adapt and the ability to quickly pick up new tasks would be extremely beneficial for this role.

I have a significant amount of physical documents that need to be transferred accurately into an Excel spreadsheet. I plan to mail these documents to you on a regular basis for entry. Your responsibilities will include: - Accurately entering the data from the physical documents into an Excel spreadsheet - Ensuring that the data is error-free - Organizing the data in a clear and logical manner - Maintaining confidentiality and security of the documents The ideal candidate will have: - Proven experience in data entry, preferably from physical documents - Excellent attention to detail - Proficiency in Excel - Good organizational skills - Ability to maintain confidentiality Looking for a reliable and meticulous person for this ongoing project.

I need help managing the bookkeeping, financial statement preparation, and tax planning and preparation for my manufacturing business. The following skills and experiences are ideal for this job: - Experience in providing detailed bookkeeping services for a company in the manufacturing sector - Expert skill in financial statement preparation, ensuring accuracy and compliance with regulatory requirements - Proven knowledge in tax planning and preparation for businesses, ideally within the manufacturing industry Please include in your application your past experience in offering the above services in the manufacturing context. Demonstrated experience will be highly valued.

We are small startup. We're looking to map out our sales process through, add automation (mainly reminders) and integration with Zoho accounting module. Key Deliverables: - **Customization of Forms**: add custom fields, design the layout, and implement conditional logic for form fields. This will streamline our data collection and make the sales process more efficient. - **Automation of the Sales Process**: automate few steps in our sales process (lead > client proposal > active client > lost client > ongoing engagements. - **Reminder System**: The reminders are crucial in ensuring that our sales team stays on track. The reminders should be sent via both email and push notifications, to cater to varying preferences of our team members. Ideal Skills and Experi...