Vba accountingcông việc
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.
Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .
Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng
Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,
Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel
Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi
Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất
Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty
Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu
Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v
Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel
- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
I need some help with my business. Tôi đang phát hành token CGX cần thêm người giúp đỡ về kỹ thuật
bán cung cấp quần áo đồng phuc, quần áo thời trang
Viết hợp đồng file tài liệu mẫu thuê nhà nước mỹ
Tìm một kế toán Báo cáo thuế theo quý
Tìm một kế toán Báo cáo tài chính hàng quý, cong việc fulltime
Hỗ trợ cho dịch vụ của tôi Tìm việc cho kế toán mới ra trường, chưa có kinh nghiệm
Tìm một kế toán Kinh nghiệm, chịu khó, cẩn thận
Tìm một kế toán Nhập dữ liệu kế toán, lên sổ sách, lập báo cáo tài chính
Hỗ trợ cho dịch vụ của tôi Nhân viên kinh doanh về xây dựng và nội thất
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more...
I'm looking for a design professional skilled in creating memorable logos to craft a modern yet simple logo for my accounting business. This logo should be an excellent representation of the key aspects of my business. - Colors: Predominantly use blue and white. Feel free to incorporate additional colors only if they blend well and look professional. The blue from the website is hex #087E8B The while from the website is #F7F7F9 - Style: The logo should have a modern look, steering away from traditional designs. The text on our website for headings is 'Nimbus Sans Extended' & the text is 'NEUE HAAS UNICA - Optional Symbolism: You could incorporate an upwards arrow or graph as a key element in the design to depict growth and progress. This element should b...
I'm in need of a web-based multi SKU inventory software that primarily focuses on real-time inventory tracking. This software will be utilized by our warehouse staff to ensure products are correctly logged and easily retrievable. Key Fea...Tracking: The primary function of the system is to keep a close eye on the stock levels. - User-Friendly Interface: The software should be intuitive and easy to use for our warehouse staff. Integration: The system should have the capability to integrate with our accounting software. This is essential for keeping our financial records accurate and up-to-date. Ideal Skills and Experience: - Proven experience in developing inventory management software. - Familiarity with real-time inventory tracking. - Ability to integrate software with a...
I'm in need of an experienced SEO specialist who can help me improve search engine rankings for my truck parts and accounting websites. Specifically, I'm seeking someone who can assist me with backlink building. The main goal of this project is to increase the websites' visibility on search engines, so it's important that the links are relevant and of high quality. Since my target market is local, it would be ideal if the backlinks could be sourced from local websites. Key Skills/Experience required: - Proven track record in SEO and backlink building - Understanding of SEO principles for different industries - Prior experience in local SEO would be a plus. I'm looking for someone who can work independently and provide regular updates on the progress...
...set up a Cyclecloud cluster with four partitions to begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. ...
...transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording process A. The Ideal scenario is keeping all the records at the Odoo. 7. Advise and enhance better workflow in accounting with our colleagues. 8. Translation from the Chinese to English from both. “Advance Scope” (I hope you to do) 9. Recording in manner of Managerial Accounting (costing schedule by projects) 10. Comm...
...growers face challenges in accessing markets due to high air and sea freight costs. To support these farmers and producer groups, our organization provides upfront funding for freight expenses. However, the existing process lacks a robust database system with simple bookkeeping features. We need a comprehensive solution that streamlines the entire process, ensures transparency, and automates accounting and reporting tasks. 2. Solution: Commodity Transportation and Funding App Key Features: User Registration and Application: Commodity growers, shipping companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record transportation details (departure, arriv...
I'm in need of a software that can handle all my accounting needs, as well as the management of employee-related tasks. Here are the specifics: - **Expense Tracking:** - Automatically import expenses from bank statements - Generate detailed expense reports - **Payroll Management:** - Calculate salary, deductions, and taxes for each employee - **HR Functionality:** - Manage employee profiles and contact information - Store and retrieve employee-related documents The ideal candidate should have extensive experience in developing accounting software, payroll systems, and HR management tools. The software should be comprehensive, yet user-friendly, with a focus on efficiency and accuracy. Prior experience in handling Arabic language requirements is a plus.
As a tax accounting firm, we need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. I...
I'm in need of an experienced professional who can assist with financial statements preparation using Tally accounting software. Key Responsibilities: - Preparation of Balance Sheet, Profit and Loss Statement, and Cash Flow Statement Ideal Skills: - Proficient in Tally software - Experience in financial statements preparation - Attention to detail and accuracy in work - Knowledge of accounting principles and practices This role is vital to ensure the accuracy and validity of our financial data. Please only apply if you have demonstrable experience with Tally accounting software and financial statements preparation.
I'm looking for a skilled individual to handle our company's billing clerical tasks. The main responsibilities for this position will include: - Invoicing & Payments: You will be responsible for generating and sending out invoices for us. This r...these platforms is essential. - Customer Communication: You will also be communicating with our clients regarding billing and payment issues. Clear and effective communication skills are crucial for maintaining good relationships with our customers. On average, we generate between 50-100 invoices per month, so the ideal candidate will have experience managing a similar volume. Experience in the accounting field and familiarity with invoicing software are must-haves. A keen eye for detail and exceptional organizational skill...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, nor... logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...
Hello! I read your project details and want to work for you. I can easily do your job because I am Accounting and Excel expert person. I am enthusiastic and passionate about this work. If you want to hire me please accept my proposal. Thank you! Anjali dore
...set up a Cyclecloud cluster with four partitions to begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. ...
...animation videos showcasing the features of an ERP system. The animations will demonstrate the system's interaction with people and various business processes. Key Points: - The animations should focus on key areas of the ERP system including user interface and interaction, data processing, reporting, and integration with other systems. - Specific use cases to be covered include: - Ledger accounting - Reporting mechanisms - Data flow within the system The ideal candidate for this project should have a strong background in: - 3D animation - Experience in creating engaging and informative business animations - Understanding of ERP systems would be an advantage, though not mandatory - The ability to work within a quick turnaround time is highly desirable. This pro...
I need a web-based application to calculate the dues per apartment based on the expenses categorized by type. The main points are: - Expense Categorization: The app should categorize the expenses by type. F...Categorization: The app should categorize the expenses by type. For instance, maintenance, utilities, repairs, etc. - Dues Calculation: - Square Footage Basis: The apartment dues should be calculated based on the square footage of each apartment. - Platform: The application should be web-based, accessible from any browser. Ideal Freelancer: - Experience with web application development, especially in accounting or financial tracking software. - Understanding of expense categorization and calculation based on different parameters. - Familiarity with building user-friendly i...
My project involves the development of an Android mobile app, primarily as a business tool with accounting capabilities. Key Features: - Splash Screen & Login with Auth Module: The app should have a splash screen and a login page that is modern and sleek in design. Your Skills: - Strong experience in Java for Android app development. - Knowledge in creating authentication systems. - Familiarity with inventory management and accounting concepts. I'm looking for a skilled developer who can bring these elements together in a user-friendly manner. The design should be modern and clean, reflecting the professional nature of the app's purpose.
My project requires the expertise of a freelancer with in-depth knowledge of XBLR accounting. The task is to leverage this skill to generate accurate financial reports for my business, with a specific focus on income statements. Key Responsibilities: - Compile, analyze, and present precise income statements - Ensure the inclusion of gross profit, operating income, and net income in each report. Ideal Freelancer: - Proficient in XBLR accounting - Proven experience in compiling and presenting income statements - Ability to pay attention to detail to ensure accurate financial reporting - Understanding of accounting regulations is highly desired, although not mandatory.
I'm in search of accounting specialists who can oversee my bookkeeping and provide financial statement analysis. Key Project Details: - Primarily undertake bookkeeping services weekly. - Utilize the Xero accounting software for the tasks. Ideal Skills and Experience: - Proficient in Xero, with a demonstrated track record of successful bookkeeping. - Experience in financial statement analysis. - Strong communication skills to discuss the financial health of the business. - Knowledge of current accounting standards. - Ability to deliver high-quality work within agreed deadlines. I look forward to collaborating with a professional who can provide a high level of service and contribute to the overall financial management of the business.
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...
