Data reconciliation macroงาน
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
...and the ability to work under tight deadlines. Responsibilities: • Prepare accurate monthly, quarterly, and annual financial statements. • Manage general ledger, accounts receivable, accounts payable, and payroll processing. • Ensure compliance with all federal, state, and local corporate, payroll, and other applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. • Provide detailed analyses and explanations of all transactions. • Prepare documentation for external auditors. • Implement and maintain internal financial controls and procedures. Requirements: • Bachelor’s degree in Accountin...
...with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. ...
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
I am seeking a versatile full stack developer to create a service appli...search functionality that provides users with relevant results connecting users with service providers depending upon geolocation. - Payment Processing: The application should include a seamless, secure payment processing system. - Service oriented architecture for plug and play type of services. Completely configurable. - Admin login to monitor for successful ,failed orders and transaction , reconciliation and generate reports. - Complete e-commerce site for processing to order. The successful freelancer will possess extensive experience in full stack development, user experience design and payment portal integration. Proficiency in modern design practices is a must. Experience with service applications is ...
...consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summar...
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
...accuracy of financial data - Conduct account analysis and reconciliation to identify discrepancies or errors - Assist with financial audits and provide necessary documentation and support - Utilize accounting software (such as Sage, Xero, QuickBooks) to record and track financial transactions - Assist in the preparation of budgets and forecasts Qualifications: - Bachelor's degree in Accounting or related field mandatory - Chartered Professional Accountant designation an asset - Proven experience as a Canadian Staff Accountant or similar role - Experience in public practice an asset - Strong knowledge of Canadian tax principles and practices - Proficiency in using accounting software (TaxCycle, Netfile, QuickBooks, Xero) - Excellent attention to detail and accuracy i...
I'm new to MYOB and currently need assistance in understanding and fixing journal entries, specifically after pay run. The project deadline is immediately, hence I'm looking for a trainer who can guide me on this immediately. Ideally, the freelancer should: My books are basic. I just want to do bank reconciliation. I expect explaining this will take a maximum of 1 hour with screen share.
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...
I'm in need of a skilled bookkeeper who's proficient in Xero. The ideal candidate will have experience handling a variety of tasks, including: - Invoicing and payments - Expense tracking - Payroll processing I have 2 bank accounts that require reconciliation. The perfect freelancer for this job will have a comprehensive understanding of accounting principles and be able to manage bookkeeping tasks with precision and attention to detail. Please highlight your experience with Xero in your proposal.
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
Looking for a very sharp and proficient Netsuite AP/AR administrator to assist with specific tasks including: - Invoice processing - Vendor management - Payment reconciliation The ideal freelancer would also assist with OneWorld and Chart of Accounts (CoA) configuration such as: - Participate in finance meetings and support - Setting up subsidiaries - Defining accounting rules - Managing intercompany transactions Additionally, I need you to under the Netsuite Order to Cash process and Month End Close. Other prime areas will be administration for: - Customer order management - Billing and invoicing - Cash application and banking - Financial statement preparation - Understand how to create custom fields, forms and workflows Daily support up to 30h weekly. Expertise with Ne...
...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, ef...
...Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Exce...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
Are you seeking a professional to streamline your bank reconciliation process and provide insightful financial analysis? Look no further! I offer comprehensive bank reconciliation services tailored to your business needs. Services Offered: Bank Statement Conversion: Convert PDF bank statements to Excel format for easy analysis and reconciliation. Expense and Income Categorization: Thoroughly categorize expenses and incomes to provide a clear overview of your financial transactions. Bank Reconciliation: Reconcile your bank accounts with your financial records to ensure accuracy and identify discrepancies. Profit and Loss Statement Creation: Develop Excel-based profit and loss statements or create them using accounting software to assess your business's...
...me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fiel...
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training...
...record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I'm in need of an experienced freel...knowledge in QuickBooks Online (QBO) to handle a large volume of financial transactions. Specifically, the task is to reconcile bank, credit card, and PayPal transactions amounting to approximately 3000 transactions for the past 3 years. These transactional data are all available in Excel CSV format. The successful freelancer should be skilled at: - Extracting data from Excel CSVs into QBO - Performing reconciliation processes in QBO - Categorizing transactions accurately into Income and Expenses - Handling a large volume of financial data Your attention to detail and accuracy will be critical to the successful completion of this project. I look forward to working with a trustworthy professional who can ensure th...
...software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool should be established to compare timesheet entries against leave entries in our organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advan...
...software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool should be established to compare timesheet entries against leave entries in our organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advan...
I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.
...freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way that it's easy...
Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:
Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks
...should be able to generate invoices for my clients and help them keep track of payments. - Bank Reconciliation: The system should be able to reconcile bank statements and help in comparing the transactions with the actual bank statement. - Expense Tracking: It's essential that the system can track expenses and provide insightful reports that my clients can use. User Interface Design: The user interface should be designed with a step-by-step guidance in mind. I want the software to be user-friendly and easy to navigate for clients with varying tech-savviness. Ideal Freelancer: - Experience in developing cloud-based accounting software - Proficient in Invoicing and Billing, Bank Reconciliation, and Expense Tracking systems - Adept at creating software with step-by-st...
I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions
I'm in need of a skilled freelancer bookkeeper adept in QuickFile accounting software for my bank reconciliation tasks. This task needs to be performed on a weekly basis. Initially there is a task to reconcile last year full transactions (12 months), tagging and classifying transactions. Matching bank receipt against and Airbnb invoices. The volume of transactions processed each week is less than 100. It's vital for the candidate to process these transactions accurately, ensuring that my financial records are correct. Ideal Skills and Experience: - Proficiency in QuickFile accounting software. - Experience in bank reconciliation. - Strong attention to detail. Doing the work in Excel is OK.
I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files
I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...
We are looking for a bookeeper to assist with ongoing functions for 2 businesses including: - Pay roll management in Xero - Cash reconciliation - Accounts receiveable and payable - Running of monthly reports such as P and L and cashflow - Managing debtors Ideally someone CPA qualified that is an EXPERT in xero and able to work in Australian time zones. Must be able to attend all staff meetings, and be online to answer questions inside Australian working hours.
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 established. Looki...
...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 related to macros - Good pr...
...schools and reconciliation : Canada confronts its history. Toronto: University of Toronto Press, 2017. Milloy, John S. A National Crime. Winnipeg: Univ. of Manitoba Press, 2017. Redhage, K. R. “A Genocide the World Has Ignored: Holding Governments and the Catholic Church Accountable for Residential and Boarding Schools through the Icc.” Brooklyn Journal of International Law 48, 2 (2023): 801–34. Smith, Mark. “Beyond a Single Story: Peripheral Histories of Boys Brought Up in a Residential School.” Ethics & Social Welfare 16, (3 2022): 290–305. doi:10.1080/17496535.2022.2036789. Truth and Reconciliation Commission of Canada. The survivors speak : a report of the Truth and Reconciliation Commission
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 exp...
I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find
Quick Book Reconciliation and finalization of accounts
