Quickbooks import excel macrocông việc

Estudiante avanzado o recibido Para realizar las tareas será indispensable contar con: Excel avanzado Disponibilidad horaria para conectarse Conocimientos en plan de cuentas, de gastos, uso se software contable, etc.) Algunas tareas: Tareas fiscales para DGI Contabilidad interna Pasado de comprobantes de compras y gastos Análisis financieros

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

...experience and proficiency in QuickBooks. Key requirements include: - Bookkeeping: You'll be responsible for recording and maintaining financial transactions, ensuring all entries are accurate and up-to-date. - Financial statements: I require regular preparation of key financial statements, comprising the balance sheet, income statement, and cash flow statement. - Taxation Services: I also need a professional who can handle taxation matters, from tax planning to returns preparation and submission. - Payroll Processing: Even though this isn't the main focus of the project, having the ability to assist with payroll processing will be highly advantageous. Your application should demonstrate your profound understanding of these tasks, alongside your proficiency in Q...

Looking for someone well-versed in Excel for efficient and accurate data entry of quantitative data. Skilled data entry specialists who can handle basic computations will be preferred. Knowledge in Excel formulas or functions might be necessary, but I'm not entirely certain at the moment. - Proficient in Excel - Demonstrable experience in data entry - Ability to perform computations - Knowledge of Excel formulas/functions a plus

Job Offer: Experienced React Developer for Web3 App Development About Us: Uncharted Fox is a private hedge fund specializing in managing investors' funds. Our core team comprises expert traders, and we're embarking on launching a new app. This app aims...deployment. - Ability to integrate both reading and executing transactions in app via Ethereum. Roles & Responsibilities: - Feature and functional design based on the specifics we’ve identified. - Leveraging Ethereum as a chosen open-source solution. - Ensuring high-level interaction with Ethereum for both reading and executing transactions. This creative project offers the opportunity to excel in a blockchain-driven environment, broadening your skills and experience. We look forward to witnessing your Reac...

Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, Director's Report. Preparation & Filing of Extract of Annual Returns & Financial Statements (0-100 transactions) if provided in Excel sheet. Preparation & Filing of Annual Returns Form AOC 04 (Financials Related Annual Return). Preparation & Filing of Annual Returns Form MGT 07 (Management Related Annual Return). Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. Preparation & Filing of Income Tax Returns (Company). FY 24-25 Preparation of Share Certificates (For All Shareholders). Preparation & ...

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

I need a fluent Arabic speaker who is proficient in Power BI to help convert an existing Excel file into a dashboard for performance tracking purposes. - KEY RESPONSIBILITIES: The practitioner will be proficient enough in Power BI to translate raw data into accessible and meaningful dashboard visualizations. Highlighting and tracking key performance indicators for strategic planning follow-up is a must for this role. - REQUIRED SKILLS: Understanding of Microsoft Power BI, an eye for design to ensure the visualization is as seamless as possible, and fluency in Arabic. Experience with Excel to Power BI conversions and strategic planning will be considered favorably. - IDEAL CANDIDATE: The freelancer should have a strong background in data analysis and a portfolio or examp...

I need to import data from multiple files that have roughly the same products in them, but it needs to show me in alphabetical order the product name in the first column and the best prices from each client in the next columns (from largest to smallest). Probably i need macros and i can`t figure them out

We need to create an Excel Spreadsheet to track Cash income and expenses. We will begin with a specified amount of cash. First priority is to be able to know at any given time how much cash should be in the petty cash account. Would like to have a space for a weekly balance in order to identify losses or un recorded income/expense in a timely manner. At the end of each week, the keeper of the account will enter the actual amount of cash on hand. This should be subtracted from the recorded expenses and income and a + or - sum generated. (This allows us to catch and correct possible typo's and/or unrecorded income/expense in a timely manner) We want it to generate monthly totals to include Total Cash income Total Cash expenses. The cash expenses should be subdivided...

I'm in need of a freelance bookkeeper fluent in German for approximately 20 hours per week. Key responsibilities will include document research and debtor/creditor management. - Software Proficiency: You should have experience in Excel and a solid grasp of basic accounting principles. - Responsibilities: Duties will involve expense tracking, invoicing, and bank reconciliations. A keen, meticulous eye for detail is a requisite as well as outstanding organizational skills. A flexible, freelancer approach is ideal for this project. This role will suit someone who enjoys piecing together information and has excellent problem-solving abilities. Experience in a similar role would be a great advantage.

I am looking for an experienced Photoshop specialist to accomplish a small task that will take less than two minutes. Your main task will be to modify the content of the text within an image. The modification will involve replacing the existing text with a specific phrase provided upon project initiation. To excel in this job, you need to have a keen eye for detail to ensure precision in text modification and a good command of Photoshop. Fast turn-around would be much appreciated.

I'm seeking a skilled freelancer experienced in data entry and Excel to enter and transform a medium-sized set of customer records and product details. Key Responsibilities: - Accurately enter data, including customer records and product details into Excel templates - Transform raw data into more useful formats and ensure data integrity - Double-check entries for accuracy and fix any discrepancies Skills and Experience: - Expertise in data entry and Excel - Proficiency in transforming and structuring data - Previous experience handling equivalent tasks related to customer records and product details. Your expertise and attention to detail will be critical to ensure the accuracy and usefulness of the resulting data.

Looking for a ...efficient professional to perform data entry into Excel. The type of data is not specific at this point and could include text, numbers, dates, or a combination. You must have good typing speed, strong attention to detail, and basic knowledge in Excel. Ideal Skills & Experience: 1. Expertise in Microsoft Excel 2. Strong attention to detail 3. High accuracy in typing 4. Experience in data entry Although not necessary, to improve your chances of being considered, you can include in your application: 1. Any examples of similar work you have done before. 2. Demonstrate your level of experience. 3. Provide a detailed project proposal. Currently, it's unclear how many sheets are there in the Excel file. Regardless, you must be willing and...

I need a proficient developer to write a script for WP All Import. It should successfully import size and color variations in my Woocommerce store. Key tasks: - The script must focus on Size and Color Variations - The exact method for determining stock quantity isn't specified, leaving it open to your expertise and suggestions - Please also be prepared to discuss potential solutions for keeping stock quantities updated in the future Ideal skills: - Strong knowledge of Woocommerce and its variation options - Experience writing scripts for WP All Import - Proficiency in PHP, HTML, and CSS - Open communication and good problem-solving abilities Please note that the timeline for completion hasn't been specified, but your estimated delivery date should be in...

...from a proficient Excel user who can create two essential templates for me: An invoice template and an expense tracker. For the invoice template, I require the following fields and calculations to be included: - Item description and quantity - Unit price and subtotal - Tax calculations - Grand total I'd appreciate it if macros could be incorporated where needed for automation purposes. For the expense tracker, it needs to categorize various business expenses including, but not limited to: - Food and drinks - Transportation - Office Supplies - Site local purchase expenses The ideal freelancer for this project would have significant experience in Excel, specifically in creating detailed, user-friendly templates for professional purposes. Proficiency in the use...

I'm in search of a skilled data entry operator with an in-depth understanding of Excel's formulas and functions. The project includes both text and number entries which are reasonably simple in terms of their structure. The project details: - Data entry includes less than 500 entries - The structured use of Excel formulas and functions is critical - Both text and numerical data need to be accurately input Ideal candidates will have experience with data entry, Excel, numerical data, and text data processing. Reliability, accuracy, and attention to detail are key for this project.

I am urgently seeking a skilled Shopify developer to assist with a variety of tasks on my store. The ideal candidate will be able to start working within a week and will have experience with theme customization, payment gateway integration, and product import and setup. Key tasks include: - Customizing a Shopify theme to improve the overall aesthetic and usability of the store - Integrating a payment gateway to ensure smooth and secure transactions for customers - Importing and setting up products to populate the store effectively I am open to suggestions for themes, so I am looking for a developer with a good eye for design and a strong understanding of e-commerce best practices. The ability to work quickly and efficiently is a must, as I have a tight timeline for this project. ...

Hi Umer S., Can you please convert the attached Quote to Excel as you have done for others. Require as soon as possible please.

I'm seeking a skilled freelance Data Clerk to enter and cross check the Korean Fields on a business card, including the key details such as Name, Job title, and Company name, and more. Your responsibilities: - Type all the fields on the business card on a Excel - Ensure the data being filled in the business card is accurate - There are 363 business cards need to type. - Estimated HR needed: 10 hr Sample of the Card:

I'm in need of an Excel expert who can help me with a range of tasks. The project involves a large Excel file with over 10 sheets. The tasks include: - Data Analysis: I need someone who can help me analyze the data in the file, looking for trends, patterns, and key insights. - Chart and Graph Creation: I also need charts and graphs to be created based on the data. These should be visually appealing and easy to interpret. - Formulas and Functions: The data file includes a lot of mathematical calculations. I need an expert in Excel formulas and functions to help me with this. Specifically, the type of data analysis needed includes statistical analysis, trend analysis, and comparative analysis. The ideal freelancer for this project would have: - Proficiency in ...

More details: What type of data are you looking to have entered? Text How will the data be provided for entry? Digital files What is the preferred format for the final data? Excel

More details: We already have a excel workbook but need to improvise it and make it automated for calculations of XIRR, Investment Holdings, etc with monthly update of transactions User-friendly interface Intermediate to Advanced Skills required

More details: What specific data or information do you want to analyze in Excel? Financial data How do you prefer to receive the analysis results? Formulas What specific calculations or formulas do you need to perform in Excel? advanced & basic

More details: What specific tasks do you want to automate in Excel? Data entry, Data cleaning and formatting, Data analysis How many Excel files do you need to automate? 1-5 What is the approximate size of each Excel file? Less than 1MB

I am seeking the help of a back office staff to assist with a variety of tasks, including data entry, file management, and document organization. The ideal candidate will be able to work less than 10 hours per week. Requirements: - Proficiency in Excel, Google Sheets, and QuickBooks - Previous experience in data entry and file management - Strong organizational skills - Ability to work autonomously and efficiently - Excellent time management skills You will be responsible for maintaining and organizing essential documentation and assisting with other administrative tasks as necessary. This role requires excellent attention to detail, time management skills, and the ability to work independently.

I'm in need of an Excel-savvy individual who can competently create a detailed data entry listing. The purpose of this project is to list email addresses, data input should be as provided without necessarily having to be in any specific order. Along with each email address, you should also input the associated full name. This job requires attention to detail and proficiency in Excel. Previous experience in data entry would be advantageous.

I am in search of an Electronic Engineer to assist me in the development of a prototype. are you able to calculate the wire diameter number of turns to achieve !.8T electromagnetic field on a given material? I am trying to b...stronger, even with double the voltage. Here are the specifications of the core laminations: 0.3mm thickness, 70mm x 150mm, and the core is 70mm x 70mm (radius of 3.949 or diameter of 7.898mm = area of 49cm2). The bobbin is 75mm x 75mm inside for wire radius 6.77cm or diameter 8.4628cm. The sides are radius 6.77cm diameter 13.540, and the length is 150mm. I need your job electronically in Word or Excel Please provide a summary of your relevant experience in your proposal. I look forward to working with a skilled professional who can help bring my projec...

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

...positive feedback and timely payment. ************************************************************************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. Please do not waste your valuable time trying to do either. The task: There are 10 Excel workbooks, with approximately 1 million rows each. These contain the data for text messages sent via SMS to customers in the last 1 year. Your task is to sort and separate the messages into different sheets in each workbook. Yo...

I need help with a research project focused on the US. The main objective is to gather a list of law schools in the US, along with the emails of their deans and assistant deans. This research should be done on a state by state basis to ensure comprehensive coverage. The main deliverable would be an excel table with all the below information: - Basic information for each law school (name, state, city) - Contact information (general email and phone number) - Emails of deans and assistant deans The timeframe for completing this research project is less than a month, ideally within a week Ideal skills and experience for this job: - Proficiency in using research tools and databases -Attention to details - Strong organizational skills to ensure systematic approach by state - Ability ...

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already...

I have a CSV file containing 1 lakh records, with each record having a full address. I am looking for someone with advanced Excel skills who can convert these addresses into latitude and longitude. Ideal Skills and Experience: - Advanced Excel skills, particularly in data manipulation - Understanding of geolocation data and coordinate systems - Experience with data analysis and visualization, particularly with large datasets - Proficiency in working with CSV files The latitude and longitude data will be used primarily for data analysis. The final output should be in CSV format, which I will then use for further analysis. Given the large number of records, efficiency and accuracy are essential.

We are looking to hire individuals to assist us with product data management on our bigcommerce site. The job is as follows: Receive product data sheets from manufacturers Match up product data from manufacturers to our product data sheet using an existing template Adjust product data for SEO optimization Locate, and do light editing on product ima...Locate, and do light editing on product images To confirm you have read this job posting please put the word pineapple in your response. Experience with automotive ecommerce sites is preferred but not required. You must have excellent attention to detail, and be able to work quickly. We have tens of thousands of products to onboard so it is imperative that you are familiar with best practices in Excel and can do multiple lines of data p...

I am seeking a freelance Excel expert to assist me with a project that involves intermediate-level use of Excel formulas and functions. The ideal candidate would be able to automate the process fully.

I require competent services for data transcription. This project involves the transcription of data from a total of 265 JPEG images into an excel spreadsheet. Example Jpeg attached. The Details: - The JPEG images contain a combination of both text and numbers. - An integral part of this project is that the data from each image should be transcribed into a separate tab on the Excel spreadsheet. Key Qualities: - Proficiency in data transcription from images (JPEG) is essential. - Advanced skill level in Excel data management. - A keen eye for detail to ensure text and numbers are accurately transcribed. Thus, if you possess a high attention to detail and proven proficiency in this kind of work, I invite you to make your bid.

I am looking for an experienced freelancer to create a comprehensive hiring tracker on Excel. The tracker should be linked with PowerPoint and automatically update the slides. Additionally, I need a detailed dashboard that displays the following data points about the hiring status: - Number of applicants - Stages of the hiring process - Open vs filled positions Furthermore, I would like the dashboard to include some extra information, specifically: - Source of applicants - Diversity statistics The ideal candidate for this job should have a strong background in Excel, PowerPoint, and data visualization. Experience in creating automated systems and dashboards for recruitment or HR purposes will be highly appreciated.

This text file is too large for my pc to handle. You will open this text file, and then save it into 10 excel files and send the excel files to me. The data needs to all be in the correct format. Find the file here: (this is public data) Click 'Real Property Data' Then open the real_acct file. This is the file I need divided up and sent to me at 10 excel files. So each file will contain about 10% of the big file. All data needs to be captured. You will send me a test file with 100 rows of data to see if it is correct. Your bid is your bid. Do not bid and then ask me 'what my budget is?' Read the requirements and follow them. type 'sunshine' in your bid.

I need a designer who can format documentation for my company. It's crucial that the documentation is in line with our corporate standards. Requirements: - The documentation will be supplied in Word or Excel and will need to be formatted in Canva to corporate standards (see examples) - The final files will be provided as both the original Canva working file and a print ready PDF. - The primary audience for this documentation is our employees, so it needs to be clear and easily understandable for them. The ideal candidate will have: - Proficient document layout skills. - A high level of written English. - The ability to proofread supplied documents for any errors, and check their own work before submission. - Experience in creating process documentation. - Understanding of co...

...their content, images and video files, from AliExpress to my Shopify store. These will need to be edited to meet business needs, ensuring only products and videos in English are listed on the Shopify site. Your expertise in AliExpress, Shopify, and dropshipping platforms will be key to the successful and hasty completion of the project. Scope of Work: - Design custom cover/landing page design - import/migrate and edit 1500 products from AliExpress - Editing product data as per Shopify requirements - Ensuring neat presentation of product images and videos on Shopify -Migrate reviews Ideal Skills: - Proven experience with AliExpress and Shopify - Knowledge of dropshipping platforms - Understanding of product migration - Proficiency in handling bulk data - Strong attention to de...

I am currently encountering an issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues relate...

excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. There are 2 parts. I have already completed. Now, I need to complete another. I need it within 2 hours. It's not too big work.

Mi ...academia de Microsoft Excel online dirigida a profesionistas en el área contable / financiera / administrativa alrededor de distintos países de habla hispana. Actualmente estoy buscando probadores o "testers" los cuales tendrán acceso completo a los diferentes cursos de la academia y luego de consumir los mismos, a través de una revisión multipuntos, brinden no solo una reseña y calificación sincera del mismo, sino que también brinden un reporte de mejoras y acciones a efectuar para que pueda mejorar el nivel del mismo. La persona(s) interesadas en ser probadores no necesitan un nivel alto de conocimiento de la herramienta, ni tampoco deben tener alto conocimiento financiero y contable ya que los cursos dispo...

I have a set of .rdf files that contain data which I need to have extracted and organized into an Excel spreadsheet. - Extract data from .rdf files. - Ensure the data is accurately transposed into the Excel spreadsheet. No further data manipulation is required, just a neat and efficient organization of the data in the Excel file. Prior experience working with .rdf files would be an advantage.

I'm on the hunt for a diligent and adaptative Junior Admin for remote work based in the UK. This is a females-only position. Responsibilities: - Handling incoming phone calls and emails. - Performing data entry tasks and keeping all information organized. - Scheduling appointments as required. Requirements: - High proficiency in Microsoft Office (Word, Excel, PowerPoint) and Google Suite (Gmail, Google Docs, Google Sheets). - Exceptional verbal and written communication skills. - High degree of organization and attention to detail. - Willingness and ability to work under a flexible schedule that varies each day. The successful candidate must have a proactive approach, able to learn quickly, and cope well under the flexibility of working hours. Previous admin experience is a...

I'm looking for a talented developer who can create a script that can extract diverse data from multiple web pages and compile it into an Excel spreadsheet. Requirements: - Extraction of text content, images, and tables from various web pages - Script should be able to handle multiple web pages efficiently Ideal Skills and Experience: - Proficient in web scraping and data extraction - Strong experience with scripting and automation - Prior experience with extracting images and tables from web pages - Proficiency in Excel for data compilation - Ability to create a script that can run automatically on a weekly basis.

All in German!! I require an experienced data collector who can provide me a comprehensive Excel spreadsheet with 200 targets for cold calls. The subjects of interest are all freelance and independent salespersons based in Germany. The information about the targets should include: - Name - Contact Information (Phone number, Email) - Location - Website - Social Media account (LinkedIn) - Company Address - Company Name These professionals should represent the following types of companies: - Marketing Agencies - E-Commerce Companies - Recruiting There are no specific requirements regarding the years of professional experience. Any level of experience is acceptable as long as they fall under the freelance and independent salesperson category, based in Germany, and are associated wi...

I need a talented freelancer to design an Excel-based Tambola ticket generator with my specific requirements. This will enable me to generate a variety of tickets efficiently and effectively. Feature Requirements: • The ability to generate tickets with random numbers. • Numbers must be evenly distributed across each ticket. Skills & Experience: Ideal candidates will have: • Proven experience in Excel and VBA (Visual Basic for Applications). • Knowledge of number generation and distribution algorithms. • Attention to detail. • Ability to work within specified requirements. • Problem-solving skills, as unforeseen computing problems may arise. • Advanced knowledge in spreadsheet software to ensure the generator functions smoothly. ...

I'm looking for a skilled expert in excel Pivot tables. To help me create an excel master sales file where i can get my stores to fill a template and email it over to me and i could put that template in a folder and that would auto feed my master sales dashboard. - Analyzing product sales by category, and store sales from the EPOS data. - Identifying the sales trends per week/month/qtr - Focusing on the product sales data, specifically looking at the highest revenue-generating items. Ideal skills and experience for this job would include: - Proficiency in Excel and pivot tables, as the analysis will involve working with a large dataset. - Previous experience with EPOS data analysis would be highly beneficial. - Strong analytical skills and the ability to draw m...

I am looking for a QuickBooks Desktop 2023 specialist to assist me with data entry and reconciliation tasks for entries exceeding 100 in number. SKILLS AND EXPERIENCE: - Proficiency in QuickBooks Desktop 2023 is non-negotiable. - Prior experience with large scale data entry and reconciliation tasks. - Familiarity with handling electronic records and financial institution statements is a must. TASKS: - An accurate data entry of electronic records and financial institution statements into QuickBooks. - Ensuring proper reconciliation of these entries. Please highlight your relevant experience in your proposal. Proven track record in similar tasks will put you in a privileged position. I am aiming for a smooth, error-free process and your expertise can make that ...