Accounting system vba excel jobs
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
Partnumber Generating Hello, we have Parts which we produce self with different options: Categorie - Modell - Length in cm - Warning Moduls - Design - option 1 - option 2 - option 3 - option 4 - option 5 ........... option 15 We work with ERP System, but it is diffcult, can you help us ? What is a solution for produce in excel or what is a solution for this problem to produce easy differenz part numbers but with structure ?
I am looking for a dedicated and proficient freelance accountant, ideally someone who is German-speaking but also competent in English. As a growing jewellery startup based in Berlin, it's critical to have a systematic approach to our accounting needs. Your Role: * I require monthly accounting services. Your tasks will include Reconciliation, Financial Reporting, and Tax Preparation. * Our company is currently using Sum-up as sales software. However QuickBooks, or similar, could be used for accountancy. Ideal Candidate: * Strong accounting skills with particular understanding of tax regulations in Germany. * Excellent QuickBooks user. or similar software. * Strong communication skills in both German and English. * Experience working with startups or in the jewel...
I'm looking for an experienced machine learning expert with a focus on predictive modeling. The goal of this project is to utilize the fully cleaned and labeled image data I have to create an effective predictive model. Key Responsibilities: - Develop a predictive model using the given image data. - Implement an effective machine learning algorithm that can predict outcomes accurately. Requirements: - Proficiency in Predictive Modeling: You should have a strong background in building predictive models. - Experience With Image Data: A history of working with image data in a predictive modeling context is highly desirable. - Data Preparation Skills: While the data is already fully cleaned and labeled, being able to perform additional data preparation may be necessary for the project&#...
I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunctional Excel Macro that's compatible with Windows. - The macro should be able to generate sales reports, calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past wo...
I require assistance with entering invoice numbers and entries from my account statement, which is in PDF format, into my accounting software, Zoho. It's yet to be determined if the process will be manual or automated. The freelancer for this project should: - Have experience in data entry, ideally with accounting data. - Be familiar with Zoho accounting software. - Have expertise in processing and extracting information from PDFs. - Demonstrate problem-solving skills to identify the most efficient method for transferring the data, whether it's manual input or utilizing an automated solution. The key objective is accurate and efficient data transfer, ensuring all information in Zoho aligns with the account statements.
I'm urgently seeking an experienced accountant with solid expertise in the field of pharmaceutical exports. Your main task will be to competently work on an accounting software tailored to the needs of an export pharmaceutical business. Essential Skills and Experience: - Accounting proficiency especially within the Pharmaceuticals sector - Familiarity with an accounting software (any platform) - Ability to work promptly and efficiently meeting tight deadlines It's noteworthy to mention that there's a degree of urgency to this project so I need someone who is able to start working on it immediately. Prior experience in a similar role or industry will be a handy advantage. We can discuss more about the specifications upon commencement of the project. L...
...time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are fille...
...all over the world. which include consulting on fund advisory, repatriation of funds, legal services, and accounting. The website needs to be able to effectively present and manage these services. Key requirements: - Web development & design: The site should be aesthetically appealing, easy to navigate, with a professional and trustworthy feel. - E-commerce capabilities: It should include a system for accepting payments for services. - Service categorization: The services I offer (consulting, legal services, accounting) must be clearly displayed and categorised. - Management: The site should allow for easy management of services, possibly through a user-friendly backend system. The ideal freelancer for this project would have experience in: - ...
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
I'm looking for a detail-oriented Excel expert to help with data entry. Your main task will be to enter text and dates into an Excel spreadsheet. Key Requirements: - You'll be working on a single column in the spreadsheet. - There are 1500 entries in total. - Prior experience in Excel data entry is highly preferred. - Attention to detail and accuracy is a must. The data needs to be entered following a specific format or template. I'll provide you with this guidance. If you're a skilled Excel user who can work efficiently and accurately, I'd like to hear from you.
Assalam o alaikum, I am looking for a MATLAB expert with good expertise in the field of control system design. Freelancer should be capable of writing reports too with detailed explanation of the circuit and complete project. Final report should be well structured and properly formatted with cover page, table of contents, list of figures, references. If you use any figure, table or diagram in the report, there should be a proper caption for it. Plagiarism should be below 10% using ChatGPT or AI is highly discouraged.
Kita membutuhkan Sales Freelance untuk bisa mendapatkan Client B2B, terutama untuk Hotel sistem seperti Booking Engine, Channel Manager, Website, PMS, POS & Purchase. Kami menyediakan: Hospitality Digital Partnership Online Marketing & Digital Solution Website:
Overview We aim to replace our current Excel-based process with a robust internal order confirmation system. This system will automate and streamline the management of weekly orders and confirmations, increasing efficiency, reducing errors, and maintaining a structured approach to sales operations. Objective Develop a web-based system that allows salespeople to manage product and customer information efficiently, generate order templates, and automate the creation of confirmation documents, mimicking the structure and data from the "example weekly order " and "example order " provided. Key Features Weekly Order Template Generation: Automate the creation of weekly order templates based on the weeks, with the capability to product details, w...
I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.
...~15-20 hrs followed by small regular work projects as quarterly accounts are finalized. Hourly rate of pay is $25.00 SGD per hr. In this project, here's what I'm hoping we can accomplish: - Management of accounts payable and receivable - Bank and credit card reconciliation - Ledger maintenance - Preparation of regular (draft) financial statements I need someone who is experienced in using Xero accounting software. You should be able to use Xero effectively to conduct bookkeeping operations for a small business. Please note, tax preparation is not required for this role. Your experience and skills in bookkeeping will make a huge difference in our ability to manage our finances. I can't wait to see what we can achieve together! This assignment is ONLY AVAILABL...
I need assistance with compiling a comprehensive database based on various online directories. Key Requirements: - You will be collecting data on the names and contact information of individuals. - Each entry should include the person's name, phone number, and email address. Skills & Experience: - Proficiency in Excel and data entry is crucial for this task. - Experience with online research and data gathering from various sources is a plus. I'm looking for a reliable and detail-oriented freelancer who can help ensure the accuracy and completeness of this database.
I am currently in need of a part-time accountant who is well-versed in Tally GST and accounting principles. You must have a solid background in managing books, tallying records and preparing statements. Knowledge of additional accounting software is a plus but not required. Skills and experience required: - Proficiency in Tally GST - Basic accounting skills - Reliable and detail-oriented - Past experience in managing books and preparing statements This work agrees perfectly with someone looking for a flexible, part-time schedule to manage my accounting needs. There were no specific software requirements mentioned. If you're an expert accountant looking to pick up a part-time role, I am looking for you.
I'm in need of a hydroponic grow building expert to design, set up, and potentially maintain a system that will help increase the growth rate of fruits, such as tomatoes and strawberries. This system should be highly effective in boosting the growth of these fruit-bearing plants. Key aspects of this project include: - Maximize plant growth rate: It's crucial that the system is designed to significantly increase the growth rate of fruit plants. I'm looking for someone who has a proven record of optimizing hydroponic systems for rapid plant growth. - Fully automated: I'm keen on having a hydroponic system that's fully automated. This means it should handle tasks such as watering and nutrient dosing without the need for manual intervention...
I'm in need of someone with access to the Australian Bureau of Statistics who can assist me in gathering specific data related to aged care planning within Melbourne. Key Deliverables in Excel: - Total population of each SA3 in Eastern and Southern Melbourne - High Income per week ($2,000 and $3,000+) of each SA3 - Age distribution within the following groups: 50+, 60+, 70+, 80+, 85+ Ideal Candidate: - Previous experience working with Australian Bureau of Statistics - Proficient in data collection and analysis - Excellent research skills - Strong communication and reporting abilities - Able to complete the project promptly, within a month - Access to ABS table builders This project is crucial for understanding the aged care market in Melbourne and will serve as a foundation ...
...Arduino Nano in combination. The aim of this project is to create a calculation and display system, primarily based on timer measurements and pre-stored factors. Skills and Experience: - Strong understanding of Nextion HMI and Arduino Nano - Experience handling calculations and display systems Project Tasks: - Develop a system using Arduino Nano for accurate timing - Implement calculations based on timer measurements and stored factors - Display results on Nextion Intelligent series HMI This project does not involve processing of sensor data, business metrics. The focus is on timer measurements and stored factors to calculate, display and store results. The ultimate goal is to devise a system that is reliable, efficient, and accurate. Anyone bidding on this...
...Prisma, (Auth v.5), Supabase, and more - Migrating key features such as user authentication, database interactions, and payment processing modules. - Implementing comprehensive accounting functions such as income/expense tracking, profit/loss calculations, tax calculations, payroll, balance sheet and cash flow management functionalities. - Preparing the application to efficiently handle a large user base (more than 10,000 users) with high volume data traffic. Experience with both PHP (particularly Laravel framework) and MERN stack is crucial, with a special focus in and familiarity with accounting systems. Strong database skills and experience in designing applications to handle extensive user base and data are also important. A track record of successful porting proje...
I'm seeking a skilled developer for my current WordPress website. The roll involves coding a bespoke and secure online client triage system for our website to allow clients to self triage to the right psychologist depending on their selections/needs. Different questions will lead to different possible next questions (if/then rules).. Responsibilities include: - Implementing systems for client data input and storage. - Creating triage assessment questions presented in an intuitive congruent with our online booking software (see attached screenshot). - Building in functionalities to compile reports based on collected data. - Ensuring it is customisable in the back end, as it will need to be edited as staff skills change and new members join the team. Ideal candidate ...
I am in need of someone who can collect data on NFL Quarterbacks listed in the excel sheet I have attached. Many quarterbacks will appear multiple times because I am treating each season as its own entity. I need age (changes by season), weight (changes by season), height (stays same), wonderlic scores (stays same because its only taken one time). In summary, I need data for the quarterbacks listed in four areas: age, weight, height, and wonderlic scores.
I have an Excel file where the preventive and corrective maintenance services of some equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose functionality or copy the dat...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
...specifically Word & Excel, who can assist me in managing specific tasks. In Microsoft Word, the following tasks are needed: - Formatting Documents: Your skills should be top-notch in bringing out an excellent document format that is pleasing to the eyes and understandable. - Creating Templates: I need help in creating various templates for different types of documents. In Microsoft Excel, your tasks would include: - Data Analysis: I require someone with exceptional skills in analyzing data, to extract useful information that will guide my decisions. - Creating Formulas: You should be fluent in the use of various Excel formulas to facilitate swift and accurate calculations. The ideal candidate must have substantial experience in handling such tasks in Microso...
I'm looking for a skilled Excel professional to help create a spreadsheet that will serve as a route tracker for my delivery business. Key Requirements: - The primary purpose of the spreadsheet is to track the various routes that my delivery personnel drive. - I need the spreadsheet to detail the start and end points of each route, the distance traveled, and the time taken for each route. Skills and Experience: - Proficiency in Excel, particularly in creating complex but user-friendly spreadsheets. - Familiarity with data tracking and analysis, particularly in the context of logistics or similar fields, would be a significant advantage. - The ability to accurately incorporate the different data types and calculations required for route tracking.
I am looking to develop a comprehensive ERP with CRM system that caters to our specific business needs. Key Features: - Inventory Management: This is crucial for us to keep track of our stock levels, optimize inventory control, and minimize costs. The system should be able to handle real-time stock updates and provide alerts for reordering. - Customer Relationship Management: It is important that the system is equipped with CRM functionality to manage our interactions with customers, streamline sales processes, and improve customer service. - Sales Order Processing: The system should be able to efficiently process sales orders, manage pricing, and generate order confirmations. It should also enable seamless communication between sales, warehousing, and procure...
i need 2 menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. example: STARTERS - ONION BHAJI - 4.50 - Our own onion fritters with salad and sauce. Contains gluten. i have started the process for u to make life easier no time wasters if u do nice job i can give u more menus in the future
I am seeking an expert who can accurately and efficiently convert two PDF files with around 110 pages into an Excel document. The PDF contains data tables as low-resolution images. No data transformation is required, just a transcription. The successful freelancer should have: - Either AI software to automatize the conversion - Or transcription skills to the the labour manually - A high degree of accuracy is needed - The capability to finish the project in a timely manner Please ensure that your bid accurately reflects your ability to handle a large-scale transcription job like this. Attached you'll find an extract of the document due to size limitations. There are in total 106 pages of the same table.
I am in need of a well-crafted wedding speech. As the groom, my speech needs to capture the laughter, love, and sentiment of our relationship. The speech should include: - A humorous story from when we first met - A loving account of why I fell in love with my bride-to-be - A sentimental anecdote that captures our relationship's essence. An ideal candidate for this project would excel in creative writing, possess a strong understanding of tone and pacing, and have experience writing wedding speeches. The ability to balance humor, sentiment, and heartfelt words is crucial.
I'm looking for someone who is well-versed in Tableau, Alteryx, Excel, and Access to assist me with the visualizations needed for the two research cases provided below. All of the instructions and case files will be attached so that you can complete all of the necessary tasks. I will complete the memos independently, so you do not have to worry about doing the memos, only the technological aspects of the research cases. Please contact me as soon as possible if you want to work on these tasks. I will need them finished by May 6th.
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...
I'm seeking a proficient freelancer with an analytical mindset for my Excel project. You will be tasked with interpreting numerical data through pattern analysis. Key Responsibilities: - Data Conditioning: Your primary task will be to condition the numeric data in my Excel project. - Analysis and Interpretation: Execute pattern analysis on the conditioned data to decipher meaningful insights. Skills and Experience: - Proficiency in Excel numeric data handling - Strong experience in pattern analysis - Remarkable numerical competency - Excellent analytical skills If you have a knack for translating raw data into insightful findings, this project is for you. I look forward to your bids!
I seek a solution-oriented software developer to create a specialized software for my Windows system, which can apply multiple prediction models to an Excel sheet. Key Functions: - Incorporating various prediction models: This includes not only regression, classification, and clustering models, but also decision trees, neural networks, random forests, and support vectors. Ideal Candidate: - Expertise in developing Windows compatible software - Strong understanding of data prediction models - Knowledgeable in Excel functionalities - Ability to integrate sophisticated prediction algorithms The final outcome should be a user-friendly software that enhances my productivity by allowing me to apply versatile prediction models to my data effortlessly.
I have a massive inventory I need help with. I want to transfer the data from the website to an Excel spreadsheet. This involves both text and numeric data, which includes fields such as Vendor Name, Address, City, State, Zip, Dimensions, Country, Memo, and Remarks. Key Responsibilities: - Complete copying and pasting the required data from the website to the Excel spreadsheet - Maintaining the accuracy of the data - Ensuring the data is organized properly in the spreadsheet You should have: - Proficiency in Excel - Experience in data entry - Attention to detail - Good organizational skills - Ability to follow instructions accurately If you have a good internet connection, a reliable computer, and a decent amount of time to spare, this task is right for you. Please...
I am in need of an experienced programmer for my networked Honeywell Pro-Watch system. The main tasks include system configuration and access control customization. Key Responsibilities: - Configuring the Pro-Watch access control software to suit our organization's needs. - Customization of access control to facilitate basic user permissions. Ideal Skills and Experience: - Proficiency in programming and configuring Honeywell Pro-Watch systems. - Deep understanding of access control systems, particularly in the context of networked configurations. - Prior experience with customizing access control for basic user permissions.
I'm seeking a professional to help develop a smart irrigation system. I want it to have the following features: - Remote monitoring and control, allowing me to manage the system from afar. - Soil moisture sensing, to ensure optimum watering for my plants. The system will be used for irrigating small amounts of soil, so it should be built to accommodate that scale. As to the type of plants, the system should be versatile enough to work with any type. Ideal skills and experience required include: - IoT development and programming skills. - Experience with agricultural technology or a strong knowledge of irrigation systems. - Knowledge on soil moisture dynamics. This is a unique project that requires creativity, technical skill, and an understanding of m...
I'm in need of a seasoned accountant to handle bookkeeping and financial analysis tasks for my specific software for freight forwarder companies. • Analyzing and design: testing software capabilities and check all accounting transactions . • Bookkeeping: Tracking of cash flow, balancing the books, and managing invoices. • Financial Analysis: Interpretation of financial data to help in decision-making and forecasting. Your years of experience should have equipped you with the ability to handle the complexity of this role. The ideal candidate is highly detail-oriented and thrives in fast-paced environments.
Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at ag...
Good afternoon, I am a University Professor of Psychology and I have a project funded by FCT in the field of criminology. I would like to develop software (which I have partially programmed in Excel already). This software aims to: 1) work with dichotomous variables that are temporally distinct (for example, at 3 or 4 fixed and different times); 2) map all the sequences that appear in the sample more often than expected by chance, i.e., more than the upper CI of the multiplication of their individual probabilities (each variable at each time would generate a different sequence), and then assess each sequence's probability of predicting a dichotomous event, calculated via ORs. From the list of variables that appeared first in time, let's say, the first assessment was at a...
...original document is attached. GlobalPowerUSAspecsheetsolareye360.pdf. We would like to make the spec sheet look more modern and use a green coloring as per the Globe Power USA corporate layouts. This competition is for a 1 page document and designer should look to create a modern base template that we can use for the other products we sell. We have a very high quality solar powered security system that I want to feature in a brochure. All our products have one brochure/specification sheet that outlines the main features and dimensions. We would like to take our existing template and change it up to look more professional. I need an effective, eye-catching flyer created for my product, designed to appeal specifically to middle-aged adults. The purpose of this flyer is to p...
I'm seeking a proficient developer for implementing comprehensive changes in an existing Smart School Management System on Codecanyon. I envision the project as a long-term contractual relationship. The system is based on codeigniter. The scope primarily includes wide-ranging modifications and additions to the system. Experienced coders with a strong understanding of school management processes will be given priority. Key Tasks: -Customize the lesson plan module - Revamp Examinations module - Fully functional accounting system, - Enhance academic syllabus, lesson plans and assessment - Upgrade Examinations, School fees, Accounting, Academics, and Transport modules Examinations: - Develop functionalities for more efficient result managem...
...fully-integrated ERP and CRM system. - Ensuring that the ERP system includes robust inventory management, sales tracking, and financial management features. - Ensuring that the CRM system includes effective lead management, customer relationship tracking, and sales pipeline management. Essential Skills and Experience: - Proven experience in designing and developing ERP and CRM systems. - Proficiency in integrating inventory management, sales tracking, and financial management in an ERP system. - Proficiency in developing lead management, customer relationship tracking, and sales pipeline management for a CRM. - Adept at creating sleek, modern user interfaces. - Ability to design customizable and flexible user interface features. The ideal candidate should b...
I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Mon...
I'm in need of an expert in Power BI to create a real-time monitoring dashboard for me. Key requirements: - The dashboard should connect to multiple Excel spreadsheets. - It should be set to automatically refresh its data in real-time. I'm looking for a freelancer with: - Prior experience with Power BI, particularly in creating monitoring dashboards. - Proficiency in handling real-time data connections. - Strong understanding of Excel data sources. Please share your relevant experience in your proposal. Thank you.
