Useful excel macros accountingdela
Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server
Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent
Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..
Помочь мне с бизнесом Biznes partnyor .investitor po tovarom avto aksesuari
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.
I am looking for an experienced accountant to assist with our monthly bill amount. We want experience accountant to help with calculating and dividing up our yearly invoice into 12 months. The yearly amount is there but we want a skilled accountant who can divide the amount up to 12 months w...dividing up our yearly invoice into 12 months. The yearly amount is there but we want a skilled accountant who can divide the amount up to 12 months with each month amount figure being different from the other. For example, dividing $100,000 by 12 months but each month has a different amount but the the total of 100k is still the same. Ideal Skills: - Proven experience in accounting - Knowledge of relevant accounting software - Strong attention to detail - Effective communication and...
I'm in need of someone who can breathe new life into my supply chain material position excel sheets. Here are the specifics of what I'm after: - Improved Formatting: The overall layout and design of the sheets need a complete overhaul to enhance readability and aesthetics. - Clear Headings and Labels: Make vital information instantly noticeable by introducing clear and concise headings and labels. - Consistent Color Coding: Utilize color coding to clearly distinguish varying points and sections, ensuring coherence and ease in navigation. - Sheet Layout Redesign: I seek a thoughtful redesign that couples functionality and design effectiveness, making the excel sheets intuitive and user-friendly. - Conditional Formatting for Color Coding: I'd appreciate an...
...Investments (especially individual stocks) - Debt - Savings - Income - Expenses - Other category for miscellaneous expenses or income - I require a simple, user-friendly design that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment tracking, and basic accounting principles is a plus. Delivery: - I expect the freelancer to deliver a comprehensive, error-free spreadsheet that meets the specified requirements. - The spreadsheet should be easily updatable and not reliant on external sources for data input. - A brief tutorial or guide on ...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
I need a skilled Wordpress expert to address a migration i...the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a smooth, seamless t...
I'm in need...tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer Relationship Management software will be a huge advantage. I'm looking for someone who can be available on an on-call basis for this role, as tasks may come up sporadically. Your punctuality, attention to detail and excellent communication skill...
I'm in need of a skilled Unity developer who can bring to life a 3D visuali...visualization of moving points. The purpose of this visualization is educational, aimed at explaining the concept of trajectory. Key requirements: - The visualization will involve moving points in 3D, following a trajectory that's dictated by data in an Excel file. - The movement of these points should be adjustable by the user in terms of speed. The ideal freelancer for this job would have: - Proficiency in Unity, with a strong background in 3D animations. - Experience in creating educational visualizations. - The ability to integrate data from an Excel file into the Unity project. Please note that while the visualization is primarily educational, it should also be visually engaging ...
...breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context and importance of the data being presented. Please note that I don't need any interactive elements such as clickable links or formulas. The main focus here is on turning the raw billing data into a clear, professional invoice. You're going to take a simple excel file with customer data and account numbers and create an easy to understand, simple annual billing invoice/income statement with my company logo on it. Account numbers will be re...
...understand how to make the most out of the tool's capabilities. Ideal Skills and Experience: - Proficiency in : It's essential that you have a good understanding of the capabilities of and can effectively configure it to meet my requirements. - Strong Networking Skills: You should have experience in reaching out and establishing connections with professionals in the accounting, finance, and banking sectors. - Experience in Business Acquisition: Previous experience in business acquisition or similar endeavors will be highly beneficial for this task. - Data Management Skills: You will be dealing with a significant amount of contact information, so experience in managing and organizing large datasets is a definite plus. -Cold email marketing experience: You should
...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. ...
...skills. Pay is according to working for a dev team, and not according to end client budgets, we know it, so bid only if you are okay working on below terms as it is same for all of us, all team members. Use our projects to monetise your extra 4 hours a day, which were otherwise not making you anything. Work includes : 1. rebranding projects 2. upgrading dependecies to latest (which will again be useful in future projects done on same script) 3. smoothen flow and bug fixes to ensure all functions work perfectly (usually required in first project done on a particular script, which will again be used in future projects done on same script. We usually assign work on few particular scripts to each dev, so that this needs to be done minimum number of times). 4. Recurring projects b...
Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, hence accuracy and precision are paramo...
Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...
I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main compo...manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It should be easily configurable for clients and capable of pulling data from databases, Excel, or Google Sheets. Ideal candidates for this project should have a strong background in software development, particularly in AI and chatbot technology. The ability to create a user-friendly interface is crucial, as the goal is to make the system accessible to a wide range...
...looking to add a partners portal enhancement, scheduling options for cron jobs, and a mail campaign scheduling feature. - **Partners Portal Enhancement:** The focus of this project is on enhancing the partners' portal, such as: - Improving the user interface to make it more user-friendly. - Adding additional features for partner management that will make the portal more functional and useful for our partners. - Integrating with third-party systems to enhance the capability and reach of our portal. Your previous experience in core PHP projects and adding new features will be a big plus for this project. The ideal candidate should have a solid understanding of PHP, databases, and web systems. Experience with UI/UX design, partner management systems, and third-par...
I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...
I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.
I'm in a rush and need a skilled designe...detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver high-quality work quickly, I...
...payment through Stripe. This will allow patients to pay for their appointments in advance. - Swedish Payment Provider: Integration with the Swedish payment provider Swish is important, as many of our customers prefer to pay using this method. - Video Conferencing: The system should enable the setup of online meetings. These meetings should be conducted via video conferencing. This feature will be useful for remote consultations and follow-ups. - Calendar Booking: The system should have a calendar booking feature, which allows patients to select their preferred date and time for an appointment. Information Collection: - Patient Information: The booking process should collect the patient's name and contact information. - Reason for Appointment: Patients should be prompted to ...
...expected to cost?” Inaccuracies in project estimates will have detrimental effects on all parties involved. because industrial projects require a relatively long time to implement, financial commitment must be obtained before the industrial process, usually the price is obtained before the construction of the project is carried out. This project cost estimate (Project Cost Estimation) is very useful for planners, implementers, owners, as well as investors to determine whether the project will be carried out or not. project cost estimation (Project Cost Estimation) will also help in cost benefit analysis of a project. Project Cost Estimation Methods Training Materials Preliminary and Detailed Estimate Accuracy of Cost Estimates bill of...
Prosimo, vpišite se ali se prijavite za več podrobnosti.
...expected to cost?” Inaccuracies in project estimates will have detrimental effects on all parties involved. because industrial projects require a relatively long time to implement, financial commitment must be obtained before the industrial process, usually the price is obtained before the construction of the project is carried out. This project cost estimate (Project Cost Estimation) is very useful for planners, implementers, owners, as well as investors to determine whether the project will be carried out or not. project cost estimation (Project Cost Estimation) will also help in cost benefit analysis of a project. Project Cost Estimation Methods Training Materials Preliminary and Detailed Estimate Accuracy of Cost Estimates bill of...
I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used...professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward...
I'm looking for an experienced financial analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financ...
I need an experienced marketing professional to facilitate the promotion of a new school in our area. Tasks: - Distributing informative pamphlets - Explaining the unique features and benefits of our school - Collecting useful contact information - Gathering details about prospective students' previous schooling Scope: - Visit an estimated 2000 houses, aiming to reach as many local community members and parents of school-aged children as possible. Ideal Candidate: - Must have previous door-to-door marketing experience, preferably related to educational institutes - Should possess strong interpersonal and communication skills - Must be Very Fluent in URDU or HINDI language. - Must be organized, detail-oriented, and confident in representing the school positively - A clear ...
نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي
As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.
...problems. Experienced in the creative design and delivery of social media campaigns Strong attention to detail and accuracy in managing event logistics, budgets, and administrative tasks. Exceptional written and verbal communication skills, including drafting professional emails and event materials. Excellent IT skills and ability to confidently use PowerPoint, Canva, Word and Excel to quickly pick up new programmes....
Logo and visit card for an accounting company "FIDUCIA"
I need help with data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data management and basic analysi...
I require the expertise of a proficient Odoo ER...old system to a new one. Key Requirements: - Expertise with Odoo version 15. Familiarity with the ins and outs of this system version is crucial to successfully migrate the data without loss or corruption. - Extensive experience is paramount. I'm eager to hear about the similar data migration projects you've handled in the past and the results you've achieved. - A deep understanding of the Accounting module which the data is primarily focused on. Ensure you are adept at dealing with figures, financial data, balance sheets and other financial reports. Best suited freelancers would be detail-oriented, meticulous, and possess a proven track record of handling similar tasks successfully. Let’s set the ball rolli...
I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate technical skills.
We are currently seeking an accountant to handle our financial needs in US. The ideal candidate will have more than 5 years of experience in the field of accounting, and have a particular understanding of technology finance. The primary responsibilities of the accountant will be to: - Manage bookkeeping: This entails recording transactions, producing financial statements, and maintaining general ledgers. - Handle tax and VAT preparation: The accountant will be responsible for filing tax and vat return and ensuring to be up-to-date with any tax obligations. - Assist with financial planning: This will include helping to analyze the financial situation and make informed decisions about the future. The ideal candidate will have a keen understanding of technology finance, and be able t...
I'm looking for a specialist to develop an auto repair shop management software. The software's primary goal is to track and bill for services rendered. I'm looking for a system with two user roles: - Administrator - Mechanic The software also needs to integrate with: - An accounting system - An inventory management system - A billing system Ideal candidates for this job will have experience in developing similar software. They will need to understand the unique requirements and workflows of an auto repair shop. Understanding the importance of accurate tracking, invoicing, and integration with other key systems is vital. Strong skills in the chosen development platform, attention to detail, and superb communication skills are a must.
