Design excel accounting jobs

I'm seeking an Excel expert to assist with transferring data from Excel to MS Project template

I have attached an Excel spreadsheet. There are 5 tabs. The first tab (called "Config & Matrix") needs to calculate predicted construction completion dates for plot/construction stage combinations (the current predicted construction dates (highlighted in yellow) just contain basic formulas). The formulas that you create will need to take into account the data on the "Project Setup+Management", "Contract Manager Portal" and "Site User Portal" tabs. The "Resource Data! tab can be ignored. If you look at each tab, you will see I have included cell descriptions and example entries. I have also attached a diagram to help you understand how the "Config & matrix" tab needs to calculate both the plot/stage dates and also proj...

I'm looking for a skilled Python developer who can create a script for me, which I can run on my local machine. The main aim of this script is to automate the process of generating Excel reports. Key Tasks: - The script should automate the generation of reports, saving me the time and effort of doing this manually. Ideal Skills: - Proficiency in Python is a must. - Prior experience in creating automation scripts would be highly beneficial. - Familiarity with Excel and its Python libraries (like pandas or openpyxl) is preferred. I would like to work with someone who can deliver a robust and efficient script that meets these requirements.

I'm seeking an experienced UiPath developer to help me automate complex data entry tasks. The automation will primarily involve: We will be having more than 100 Invoice formats. The system should automatically read these formats and write into excel csv file. Ideally, the freelancer should have extensive experience with UiPath, a deep understanding of data manipulation processes, and a proven track record of automating tasks across web-based applications and database systems. Proficiency in these areas will be crucial for the successful completion of this project. The estimated volume of data for automation is medium. The system should support template-based extraction for data extraction. The automation should run hourly. The system should log errors and continue with the...

I'm looking for an experienced WooCommerce developer to set up an e-commerce website for selling digital products. Key Requirements: - Build a robust WooCommerce store to handle digital products seamlessly. - Integrate reliable payment gateways for smooth transactions. - Incorporate accounting software for easy financial tracking and reporting. Ideal candidates should have: - Proven experience with WooCommerce and e-commerce development. - Demonstrable skills in integrating payment gateways and accounting software. - An understanding of the unique requirements for selling digital products online.

I am a sole proprietor in need of professional assistance for my quarterly GST return filing. - Business Type: Sole Proprietorship - Accounting System: I currently maintain manual records, so you may need to help me convert my records for GST purposes - Required Services: Primarily, I need help with GST return filing. Ideal candidates must be well-versed in GST regulations and requirements, with a strong background in working with sole proprietorships. Experience in helping businesses that maintain manual records is a plus.

...convert data in some documents. the project is divided in 2 phases. first has to be ready the first phase and then the 2nd phase. Phase 1: Document Generation Extracted data is required to generate: • Share Certificate- Contains 9 fields from the extracted data. • Share Ledger- Contains 12 fields of which 9 fields are in the same as the Share Certificate. • Data extraction from agreements • Excel formatting or a structured table. • Automatic document generation (Share Certificate & Share Ledger in PDF) • Automatic Document Filing • Automatic emailing of Specific Documents Two level logins A. Mester login B. User login • Upload folders of the documents • Download share certificate & share ledger • View ...

I need a method or script to send bulk SMS messages from a phone number located in another country. The phone can be accessed through Google Messages for Web. The phone numbers list where we have to send the message are listed in an Excel sheet. The ideal solution should be easy to use and not overly complicated. Key Requirements: - A simple method or script to send SMS in bulk. - The solution should not be overly complex or difficult to use.

I'm looking for a skilled professional who can automate the trend analysis of stock data in Excel, using Python or other suitable tools. Key Tasks: - Automate data analysis in Excel - Sheet1 data automate copy sheet 2 every minute -Sheet 1 data copy every minute to sheet 2(column F of sheet1) and sheet 4 (column O of sheet 4) as per upload sheet

System Overview The GASS System is a comprehensive data collection and analytics platform bui...supports: API uploads to connect external websites. Live database connections for seamless data transfer. File uploads (CSV, Excel, SQL, WHONET/FTP) with field mapping. Dashboard for monitoring connection status and data transmission. DASHBOARD – A visual analytics platform for managing and analyzing collected data. Features include: Sector & Subcategory Management – Organize data by category. Indicators & Custom Scripts – Define custom calculations and display results in charts or tables. Advanced Form Builder – Supports Skip Logic & Repeatable Elements for dynamic form behavior. Real-Time Alerts & Reports – Automated notificat...

As a sole proprietorship, I need someone to file my GST returns for the past 6 months. The returns that need to be filed include both GSTR-1 and GSTR-3B or any other GSTR. Also, Respond with a genuine price..if you can work with...e-invoicing under GST and its compliance requirements - Mastery of GST registration and its amendments - Expertise in reconciliation of GSTR-2A/2B with purchase registers - Strong problem-solving skills to address GST related discrepancies - Knowledge in claiming Input Tax Credit (ITC) correctly - Ability to provide advisory on the impact of GST changes and updates - Experience with cloud-based accounting systems for easier GST filing Please also assist with specific GST reconciliations or adjustments as needed. Also, assist with Input Tax Credit reconc...

I'm looking for an Excel expert to help me set up a task tracking sheet in Excel 2010. The sheet will be used to track team assignments and should include color coding based on team members. Ideal candidates will have: - Proficiency in Excel 2010 - Experience with creating task tracking systems - Ability to work with Arabic language settings - Creativity in color coding systems The final product should be a functional and visually clear task tracker.

I'm looking for a professional to convert my Microsoft Excel project schedule into MS Project. The excel schedule has 675 rows, including headers. The purpose of this conversion is to enable better tracking of the project. 500 rows are the same 4 or 5 tasks with a different identifier and schedule start/end. Not entering any resources or predecessor or successor but need the columns available for me to add later. Looking to have a 2-5 hour turn around. Details: - The current Excel schedule is moderate, repetitive task structure - This is a one-time conversion, I don't need to update the schedule in MS Project regularly. Ideal Skills: - Proficiency in Microsoft Excel and MS Project. - Attention to detail to ensure all tasks and dependencies are accur...

I have an Excel file containing 248 medical records. I need a freelancer to compute and add three new columns: BMI, BMI Category, and bp_category (blood pressure). Your Responsibilities: - Use the existing weight and height data to calculate BMI. - Research and apply the standard BMI categories. - Utilize the systolic and diastolic blood pressure data to create the bp_category. - Ensure the output file is in Excel (.xlsx) format. Ideal Skills and Experience: - Proficiency in Excel. - Understanding of health metrics and categories. - Experience with data analysis. - Ability to deliver high-quality work promptly. I am looking for a quick turnaround on this task. The successful completion of this project could lead to further opportunities.

Need a create dashboard for KPI MM

I need a Python script that can transform data from one Excel sheet with multiple rows into another Excel sheet. The output should create one individual sheet per row. There is a certain format in the output excel sheet. Key requirements: - The ideal candidate should have extensive experience with Python and Excel. - Knowledge of data manipulation and organization is crucial. - able to work immediately with tight deadline

Job Description: We are seeking an experienced web developer/designer to create a modern, professional, and fully responsive web page for our auditing and accounting firm. The website should be visually appealing, user-friendly, and optimized for all screen sizes (desktop, tablet, and mobile). Scope of Work: ✅ Responsive Design – Ensure seamless performance across all devices and screen sizes. ✅ Home Page – A compelling landing page introducing our firm and expertise. ✅ Services Section – Detailed descriptions of our auditing and accounting services. ✅ About Us – Company overview, team introduction, and credentials. ✅ Contact Page – Contact form, company address, Google Maps integration, and social links. ✅ SEO Optimization – Basic ...

I need a freelancer to create 5 reports in an MS Access Database as per pdf and implement a data entry option as per excel. database, pdf and excel sheets are attached

I am seeking a data expert with strong experience in exploratory data analysis (EDA) and predictive modelling. The primary goal of this project is to identify key patterns in my data. Ideal Skills: - Expertise in EDA and predictive modelling - Proficiency with data analysis software (e.g., Python, R, Excel) - Strong statistical background - Excellent problem-solving skills - Ability to interpret complex data sets Please note that some details about the data types and visualization methods have not been determined yet. Flexibility and adaptability will be key in this project.

MAGENTO 2 EXPERT MAGENTO 2 ATTRIBUTES EXPERT MAGENTO 2 "ATTRIBUTE SET" EXPERT MAGENTO 2 PRICE RULE EXPERT PRODUCTS IMPORT EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the pro...

Looking for Virtual Assistants who has the following skills: - Good with excel - High attention to details - Is smart & fast in their work - Self learner & able to follow user guides - Meet deadlines - Proactive & willing to go the extra mile - Freshers can also apply Job Responsibility: - Data Entry & basic admin tasks - Do some research jobs related to products and purchase - Online search for suppliers/ whole sellers/ manufacturer who can give quality products at a very competitive price If you are interested, then Please carefully review the provided information and add the word "Rainbow" at the beginning of your cover letter. Also, share your response to the below questions. 1) What commitments do you have right now? Are you employed? Student? Freela...

I'm seeking a diligent full-time ...sales, handling taxation, performing bank reconciliations, and overseeing TDS. I primarily use Tally for all accounting tasks, so familiarity with this software is a must. The ideal candidate should also possess: - Exceptional accuracy and attention to detail - Strong skills in managing and reconciling accounts - A solid understanding of retail accounting practices - Proficiency in using Tally Please note, the role requires a deep commitment to accuracy and detail. The ability to spot discrepancies and solve problems as they arise is essential. Speed and efficiency are important, but they must not come at the cost of accuracy. If you have a proven track record in retail accounting and are looking for a full-time opportunit...

...issues before they affect users. Key Requirements: - Proficiency in Java and Selenium is mandatory - Prior experience in performing regression tests - Capability to conduct tests on Chrome browser - Understanding of data creation through API - Proficient in data writing and extraction from excel/CSV - Ability to utilize Data Provider - Familiarity with Page Object Model - Familiarity with version control systems like Git Testing Focus: - Functional tests - UI tests Data Interaction: - API responses - Excel/CSV files The ideal candidate will be detail-oriented, capable of developing comprehensive test cases, and able to communicate findings clearly and effectively. The regression testing needs to be completed within 1 week. Automated reports post-testing: Already exte...

I'm in need...designed to have the following features: - Integration with an email marketing platform to engage with potential customers and keep them updated on new products and promotions. Additionally, I require assistance with loading data from an Excel spreadsheet, which will contain product details, pricing and other relevant information. Ideal candidates for this project should have: - Extensive experience with Shopify and e-commerce website development. - Proven track record in creating platforms for digital product sales. - Proficiency in data migration from Excel to a web platform. - Knowledge and experience in integrating email marketing tools into e-commerce sites. Please bid if you are capable of delivering a high-quality, user-friendly website tailored...

...and defence organizations, industrial and manufacturing companies, and retail and wholesale businesses. Collect key company details, including business name, industry category, business size, location, business website, key contact person, phone number and email, current container supplier if known, and potential container needs such as hire, sales, or modifications. Data Format: Preferably in Excel. Data Sources: Online research using Google, LinkedIn, and business directories, as well as industry databases if accessible. Ideal Freelancer: Experience in lead generation, data scraping, or business research. Strong attention to detail and ability to verify accurate contact information. Ability to organize data clearly and logically. This will be an ongoing project, so there is...

I'm seeking a professional who can develop a database that...develop a database that automates the creation of quotations. The database will need to include product type, description, purchase cost, and selling cost. What I can provide: - My existing purchase invoices, all in Excel. This data will need to be extracted and included within the database. - The database should be set up to allow for the automated import of new product data from Excel. What the automated quotations should include: - Product details - Total cost - Client information Ideal skills for this project include: - Expertise in database creation - Proficiency in Excel - Experience with automation - Understanding of quotation systems - Ability to extract and interpret data from invoices I lo...

I require an experienced Excel expert to develop an equipment finance calculator for me. The calculator must allow for adjustments to be made on the following parameters: - Interest rate - Brokerage fee - Loan duration - Balloon payments - Principal amount: Input field to specify the initial loan amount. - Payment frequency: Option to select how often payments are made (e.g., monthly, quarterly). - Down payment: Input field to specify any upfront payment made at the time of purchase. The calculator will be used on a Windows operating system. Therefore, it should be designed accordingly. Ideal candidates for this project should have a strong background in finance and excel, with experience in creating finance-related tools on Excel. Please ensure your bid reflects yo...

...need of a skilled professional who can assist me with an urgent task tonight involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes and bar codes generated for each entry. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge - Experience in generating and embedding QR codes within PDFs. -Experience in importing graphics - Experience generating bar codes The PDF forms should include specific fields from the Excel spreadsheet. The QR codes should link to the web...

I need an Excel expert to organize and combine two Excel sheets, approximately <2K rows each, containing contact information (Names, Emails, Phones, Addresses). Key Requirements: - Cleanup and organization of two Excel sheets - Incorporate an 'Address 2' column: Move apartment/suite numbers to 'Address 2' - Create copies of rows with a secondary email, using the text before '@' as the first name, while keeping other contact details consistent - Data deduplication across 20 existing columns - Sorting the data in an Alpha Numeric order by Company Name post-cleanup - Ensuring column titles remain consistent - Combine records with identical names, ensuring that the most complete information is retained. - Standardize the format of phone n...

I'm in search of a skilled Australian accountant who can assist my corporation in navigating business taxes. Key Responsibilities: - Tax Filing: I need help in filing my corporation's taxes. - Business Activity Statement (BAS): Assistance in preparing and submitting the BAS is essential. - Income Tax Return: Expertise in managing ...size. Ongoing support after the initial filing is required." Communications will primarily be conducted via phone. The timeframe for the completion of these tax services is 1-3 months. Ongoing support needs will include constant assistance and guidance. The accountant should ideally be based in any region within Australia. The accountant should be proficient in using QuickBooks Online for all accounting tasks. The accountant must have a...

...Examples: clients would be able to link to such information as: their contract with me, their end of the month investment returns, our recent meeting notes, investment strategy currently in place, etc, etc, etc. …modifications by me monthly. • Files would be downloadable or just content that I might paste into WordPress as a “custom post type” • Upon clicking on the hyperlink, a PDF or possibly Excel file would pop-up • I would upload these updated documents myself – as stated, regularly. 3. Enable me to upload other general (not client specific) documents, such as monthly newsletters, easily. I have never been comfortable with the WordPress facility for this. In connection with the above, I desire the developer to instruct me how to do th...

We are looking for a Virtual Assistant who can manage tasks that we have pending for some assignments to facilitate the proper functioning of our guidelines.
Requirements: - Speak Spanish -Have basic computer knowledge. -Excel Basic. -Puntuality. We offer stable work, since we have a good list of tasks to perform an. Whatapp no: ‪+1(289)535‑3721‬

I'm in need of an expert in MS Power BI who can help me create a das...me create a dashboard tailored for customer insights analysis. This dashboard will primarily connect to various Excel/CSV files, so proficiency in handling and integrating these data sources is crucial. Key Requirements: - Expertise in MS Power BI - Experience in creating customer-centric dashboards - Proficiency in connecting Excel/CSV files to Power BI - Ability to customize subsets and output data as needed Visualizations: The dashboard should predominantly feature bar charts and pie charts. Therefore, experience and skill in designing these specific types of visualizations in Power BI is important. Ideal Skills: - MS Power BI - Data Analysis - Visualization Design - Excel/CSV Dat...

...business with a mission centered around healing and resilience. As we continue to grow, we seek a meticulous financial professional to help us organize and streamline our financial records. What We Need: - Organize receipts and invoices from emails. - Set up a cloud-based financial archive using Google Drive, Dropbox, or OneDrive. - Establish a bookkeeping system with QuickBooks, our preferred accounting software. - Provide ongoing monthly bookkeeping support. - Implement an expense tracking tool to categorize and monitor business expenses. - Set up a payroll system to manage employee payments, including taxes and benefits. - Establish an inventory management system to track stock levels, orders, and sales. - Assist in creating and managing an annual budget to forecast income an...

...involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes. This is a very easy task and if done well much more work will follow. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge The PDF forms should include specific fields from the Excel spreadsheet. Please, bid only if you can deliver step 1 tonight. Thank you. The QR codes should link to the website. The PDFs should follow custom branding guidelines provided by the client. The PDF forms should include t...

I have a large Excel spreadsheet that needs some reformatting to get it ready for a regression analysis. The data is currently in a single sheet, and the task involves a significant amount of copy-pasting. This project involves: - Merging and aggregating various data points - Ensuring the data is correctly formatted for analysis Ideal candidates for this project will have: - Strong proficiency in Excel - Experience with data preparation for statistical analysis - Attention to detail to ensure accuracy during manual data handling. Stat knowledge is not necessary but helpful. It's about 800 rows of company data that need to be manipulated from wide to long for regression tools.

I'm seeking a PowerShell expert who can create a script to read data from an Excel file, update variables in a sample plain text template, and save the text file with the variable name and date as the filename in a different folder. Key Requirements: - The saved text files should be named using the variable name from the specified Excel column. - The specific Excel columns containing the variable names and the data to be updated will be provided later. - The script needs to work with a provided plain text file template. Ideal Skills and Experience: - Proficient in PowerShell scripting. - Experienced with Excel data manipulation. - Familiar with working with plain text file templates. - Able to deliver a flexible script that can accommodate custom specific...

I need a seamless integration between Fortnox and Excel to manage 80k products. The integration should allow me to update product info, stock and price information from the same Excel file to Fortnox on request. Additionally, I need to export orders and purchase orders from Fortnox in CSV format, containing only product info, number of products, and stock availability. Ideal skills and experience for the job include: - Proficiency in Excel and Fortnox - Experience with data integration - Ability to create custom solutions for specific needs - Familiarity with CSV format - Strong attention to detail to ensure accurate data management. You need access to Fortnox Rest API.

I'm looking for an Excel expert who can help me create a formula that calculates payment using the FIFO (First In, First Out) method for my invoices. The data is spread across multiple sheets, so the freelancer will need to be comfortable with cross-sheet referencing. Key Requirements: - Expertise in Excel, particularly with complex formulas and cross-sheet referencing. - Previous experience dealing with invoice data - Understanding of FIFO payment calculation The invoice data includes: - Multiple sheets with different invoice amounts and dates - Payment records - A column that indicates how much credit can be taken (PBC) if the credit value is sufficient The ultimate goal is to use this formula to reduce the net credit to be paid. Please note that attention to detail...

...designed Excel worksheet tailored for managing estimates and invoicing. Key Features: - Creating Invoices: The primary function of this worksheet will be to facilitate the creation of invoices. - Customizable Templates: I require invoice templates that can be tailored to meet specific client needs or preferences. - Automatic Calculations: The worksheet should incorporate automatic calculations to minimize errors and streamline the invoicing process. - Client Database Integration: It should also have a feature for integrating a client database for easy access and management of client information. Ideal Skills: - Proficiency in Excel is a must. - Experience in designing templates for estimates and invoicing will be highly advantageous. - Knowledge in creating client databa...

... and discounts. 5. Automatically create and organize categories for products. 6. Manage synchronization, monitor performance, and handle errors. 7. Compare prices across different stores to select the cheapest option. 8. Enable manual control over product addition or approval before import. --- ? Methods for Inputting Product Sources Method 1: Manually enter the store link in an Excel file or Google Sheets. The scenario will fetch products from the specified store only. Method 2: Enter the country name and desired product category. The system will use AI to identify online stores in that country and retrieve store links selling products in the selected category. --- ? Steps for Importing Products & Adding Them to WooCommerce Step 1: Create a Brand in ...

I have 35 pages of handwritten documents that need to be typed into a standard Excel spreadsheet. - Formatting: The Excel document should be a standard spreadsheet without any complicated formulas or functions. - Font Style: The typed content should be in Times New Roman. - Data Arrangement: The data needs to be organized in the same order as in the handwritten documents. My budget for this project is $10. Please only bid if this is acceptable to you. Also, kindly let me know your favorite name.

Payroll Consultation - Payroll and Non Payroll Laibilities

I need a Power Report Builder that connects to SQL databases and Excel Sheets. The report should focus on various key metrics related to admin tasks. Key Requirements: - Connect to SQL databases and Excel Sheets - Build reports focused on admin tasks Ideal Skills and Experience: - Proficient in Power BI or similar tools - Strong understanding of SQL and Excel - Experience in building business-focused reports

I'm looking for a professional to convert my Microsoft Excel project schedule into MS Project. The excel schedule has 675 rows, including headers. The purpose of this conversion is to enable better tracking of the project. 500 rows are the same 4 or 5 tasks with a different identifier and schedule start/end. Not entering any resources or predecessor or sucessor, but need the columns available for me to add later. Looking to have a 24-36 hour turn around. Details: - The current Excel schedule is moderate, repetitive task structure - This is a one-time conversion, I don't need to update the schedule in MS Project regularly. Ideal Skills: - Proficiency in Microsoft Excel and MS Project. - Attention to detail to ensure all tasks and dependencies are acc...

I'm seeking a skilled data scraper who can extract information from LinkedIn. My specific needs include: - Identifying all directors of cybersecurity companies based in France. - Col...Identifying all directors of cybersecurity companies based in France. - Collecting their names and email addresses. - Providing the corresponding company names and LinkedIn profile URLs. - Scraping their email addresses from LinkedIn. The ultimate goal of this project is for research purposes, and the data needs to be delivered in an Excel spreadsheet. Ideal candidates for this project should have: - Extensive experience with LinkedIn data scraping. - Proficiency in Excel. - A strong understanding of cybersecurity companies. Please note, I do not require phone numbers, only the above ...

I need to design a betting website similar to [](). The categories such as **Live Casino, Sports, Card Games, Slots, Fish Shooting, Cockfighting, and Esports** will use third-party APIs (I will provide the documentation, and a single API can integrate all these games). For the **Lottery category**, I need you to develop **mini lottery games** with different draw intervals: **45 seconds, 1 minute, 2 minutes, and 5 minutes** (all lottery games follow the same mechanics, but the result times vary). These lottery games should include configurable settings: - **Random Mode**: The system will generate results randomly. - **Close Mode**: The system will generate results favoring the platform, ensuring profitability. - **Setup User Win**: Allows

I'm looking for an Excel expert to assist me in analyzing the total agent count on a yearly basis. Key Requirements: - Comprehensive analysis of total agents per year - Delivery of raw data without the need for visual representation (charts or graphs) Ideal Skills: - Proficient in Excel with experience in data analysis - Attention to detail to ensure accurate calculation and reporting - Ability to present data in a clear and understandable manner

...digital files. Ideal skills and experience: - Proficient in Excel and data entry - Attention to detail to ensure accurate data input - Ability to handle mixed data types (text and numbers) - Previous experience with data entry from digital files is preferred. The expected volume of data is medium, ranging from 100 to 500 entries. Moderate accuracy is required for data entry. The desired completion timeline for this project is 1 week. The digital files are sourced from emails. The data should be sorted and categorized in a basic manner. The final sorted data should be delivered in an Excel spreadsheet. The data should be sorted and categorized by type. Data should be categorized by date. Please use standard formatting for the final Excel spreadsheet. The data shoul...