Vba accountingงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

Write a contract แปลสัญญาต่างทางธุรกรรมกฏหมาย เช่น สัญญากู้ สัญญาซื้อขาย ค้ำประกัน จำนอง จำนำ ครับ

Write a contract ต้องการอย่า

ต้องการด่วน คนที่เข้ามาปิดบัญชีและเรื่องการเงินของบริษัท ด่วนที่สุด สามารถปิดจ้อบงานได้ภายใน 7 วัน ติดต่อ ด่วน URGENT !!!! NEED data entry support for journal entry to close month End accounting statements within 7 days.

I would like the assistant to do research about accounting services provided by the accounting offices in Thailand. I would like only Thai person since you have to search information in Thai. From the attached file, I would like you to search website of these accounting offices and provide me the information about their services e.g. the list of services provided by these offices, service rates. I would like you to prepare in in structure manner that I will provide template later. Freelancer who has an accounting background would be advantage.

ต้องการคนที่เข้าใจและสามารถแนะนำวิธีการใช้ โปรแกรม xero accounting softwar และมีความรู้เกี่ยวกับระบบบัญชีในประเทศไทย

Need an accountant who can use Xero accounting program and can help reconcile and tax. Monthly pay between 600-900USD for the right person. ใช้ xero program ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

...obligations on time to avoid penalties and unnecessary stress. Key responsibilities: - Handling monthly VAT filings: You will be responsible for ensuring my VAT returns are accurate and submitted in a timely manner - Managing yearly tax filings: As a sole proprietor, I have a specific set of tax obligations that need to be managed effectively Ideal skills and experience: - Proficient in Polish accounting and tax laws: Having a deep understanding of the local regulations and requirements is crucial - Experience working with sole proprietorships: Being familiar with the specific needs and challenges of sole proprietor businesses can be a significant advantage Please note that while this project is primarily focused on VAT and tax filings, there may be opportunities for addition...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

I'm looking for a ready-made ERP cloud accounting system like that offers these key features: - Inventory Management - Sales and Purchase Tracking - Financial Reporting I'm specifically seeking a system that has a: - Modern and sleek design I plan to integrate this ERP system with other software via API. Ideal Skills and Experience: - Experience with ERP cloud accounting system development - Proficiency in UI/UX designing - Proven ability in API integration with other tools - Familiarity with inventory management, sales tracking, and financial reporting systems. I want similar to

...I've been manually tracking these transactions in spreadsheets, but I now need a more robust and automated system. - **Improved Organization**: The primary goal of this project is to enhance my overall financial organization. - **Investment Tracking**: A secondary but important aspect is to have a system in place for monitoring and evaluating my investment performance. Ideal Freelancer: - **Accounting and Bookkeeping Expertise**: Strong background in personal finance and investment bookkeeping is essential. - **Software Proficiency**: Experience in working with personal finance software is highly preferred. - **Organization Skills**: Ability to set up an intuitive and efficient system for tracking and managing my finances. The successful candidate will be able to streamlin...

I need an expert to comprehensively review the quarterly financials of 18 differe...asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex financial data This job will require thorough analysis and a keen eye for detail, hence relevant experience is highly sought after. If you are an analytical individual with a background in finance, then this proj...

...specialist to establish and manage my accounting and auditing company's presence on LinkedIn from the ground up. The absence of a presence on this platform has been a significant missing piece in our marketing strategy. Key Tasks: - Developing and launching our LinkedIn business page - Consistent management and updates to the company profile Our target audience is predominantly local small business owners. consequently, the page should be optimized to attract this demographic. Ideal Skills and Experience: - Proven expertise and experience in setting up successful LinkedIn business pages - A mastery of LinkedIn's algorithms and features - Exceptional marketing skills specifically tailored towards reaching small businesses - A solid understanding of the accounting...

...Relationship Management (CRM): Proficiency in the management of all aspects of customer relationships, with the aim of improving business relationships, assisting in customer retention, and driving sales growth. - Project Management: Capabilities in managing projects, tracking progress, and ensuring smooth workflow in our small team set-up. - Billing and Accounting: Knowledge on maintaining a clean ledger, managing bills, conducting proper accounting, pushing follow-ups, and ensuring no dues remain pending. - Payment Tracking: Expert in tracking incoming and outgoing payments without missing any transactions. Time frame for project completion is within a month. Ideal candidate should have a solid background in business management, specifically for small businesses, and...

I'm seeking a Zoho expert to set up and configure Zoho One for my organization. We currently do not use any specific software or tools that need to be integrated with ...to be integrated with Zoho One. The main objective is to implement Zoho One for less than 10 users. Key Responsibilities: - Customize Zoho One to meet our business needs - Implement CRM, Sales Management, Email and Communication, and Finance and Accounting modules of Zoho One. - Provide necessary training to less than 10 team members on the use of Zoho One. Ideal Skills and Experience: - Extensive experience with Zoho One implementation and customization. - Proficiency in CRM, Sales Management, Email and Communication, and Finance and Accounting modules of Zoho One. - Ability to train small groups ef...

I'm searching for a skilled professional to automate key aspects of my business's accounting procedures. Here's a quick rundown of what I require: - Automation of onboarding and tracking Ideal candidates for this job should possess: - Profound experience with automating business processes - Previous working experience in accounting procedures - Knowledge about onboarding and tracking automation Understanding the requirements of the project and having proficiency in Gohighlevel will be vital. Efficiency, accuracy, and attention to detail are crucial for the successful completion of this project.

Saya mencari web programer yang berpengalaman dana Laravel dan Vuejs. Saat ini saya ada program pernjualan yang ingin saya upgrade agar program tersebut sekarang terintegrasi ...yang ingin saya upgrade agar program tersebut sekarang terintegrasi dengan akuntansi (akun perkiraan) seperti pada Accurate Online atau Key requirements include: - Integrating the current sales program with an accounting system. - The accounting system should be at a medium complexity level, including financial reports. - The primary focus for the integration should be on user-friendliness. Ideal Skills: - Proficiency in Laravel and Vuejs. - Experience in integrating systems, particularly sales programs with accounting software. - An understanding of accounting, especially in generat...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I am looking for a professional accountant, preferably based in Switzerland, to help me streamline and organize my ERP system, particularly ...would be highly beneficial Customizations: - While I do not have any specific requirements at the moment, I am open to suggestions and ideas from the selected candidate on how to further customize and improve the system Preferred Qualifications: - Prior experience with Odoo, particularly in setting up chart of accounts and tax configurations - Strong accounting background, potentially with a CPA qualification - Experience in Swiss accounting standards and practices would be a big plus - Proven track record of delivering similar projects with successful outcomes If you have the skills and experience to help me with this project, ple...

...developer to create a complex ecommerce website based on Odoo ERP. This project involves extensive customization and integration of various features primarily tailored for a multi-branch business model. The system must be able to handle multiple branch warehouses, with each customer being assigned to a specific branch based on their location. Key Requirements: - Integration of Point of Sale (POS), Accounting, Customer Relationship Management (CRM), Inventory Management and Purchases features from Odoo ERP. - Implementation of a system that assigns customers to a branch based on their location. This should be done automatically based on IP, and also allow customers to manually select their preferred branch. - Seamless user interface that enables easy navigation for customers acro...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

I need immediate assistance with TallyPrime for accounting entries and reconciliation. - Tasks include Sales and Purchase entries and Bank reconciliation specifically. - The completion time is critical as I need the project ready ASAP. Ideal applicants should have: - Proficiency using TallyPrime. - Strong experience with accounting and reconciliation. - Ability to work fast and efficiently. Please provide a brief overview of your relevant experience when applying.

I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.

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 t...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 ...

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 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...

...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 how to use the spreadsheet would be appreciated. Feel free to share any relevant work samples or ...

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.

...summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly 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 cu...

...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

Logo and visit card for an accounting company "FIDUCIA"

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...

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.

Building a comprehensive school management software with features like online exams, results management, fee management, and more would require integrating various modules. Here's an outline of how you could structure such a software: User Authentication and Access Control: Allow administrators, teachers, students, and pa...protect sensitive data. Regularly update and maintain the software to patch security vulnerabilities. Mobile App Integration: Develop mobile apps for iOS and Android platforms to allow access to features on mobile devices. Enable push notifications for important updates and reminders. Integration with External Systems: Integrate with other systems such as learning management systems (LMS), accounting software, and student information systems for seamless...

I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...

I'm in need of an experienced US accountant to handle bookkeeping and help with obtaining a Colorado Sales Tax License for my Shopify business. Here are the specifics of the project: - Bookkeeping: as my accountant, you'll be responsible for accurately maintaining records of financial transactions on a regular basis. This includes recording sales, purchases, recei...Sales Tax License: I need help in applying for a Colorado Sales Tax License. This involves understanding the specific requirements and regulations for sales tax in Colorado and ensuring that my business is compliant. Your experience as a US accountant with a strong background in bookkeeping and a good understanding of the Shopify platform will be crucial for this role. Familiarity with Xero accounting softwar...

I invested few lakhs to acquire a 1.02% stake in an SPV. Despite the overall...audit investigations and the ability to observe irregularities (which will enable me to engage in a more informed dialogue with the SPV team). Key responsibilities: - Focus is primarily on the review of financial statements - Identify any signs of financial fraud - Deliver a comprehensive report of your findings Ideal candidates for this project should have: - Proven experience in forensic accounting - Comprehensive understanding of financial statements - Ability to detect signs of financial fraud - Excellent report-writing skills - High attention to detail If you have a track record of conducting successful forensic audits and are confident in your ability to identify financial fraud, I'd like to...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

Setup of accounting software, import and clear data to have it ready to work.

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

I'm in need of an individual with a strong academic background in accounting. The project will involve outsourcing analysis and interpretation. This is specifically for a graduate level academic project. Key requirements include: - Strong understanding of accounting principles - Experience and knowledge in outsourcing analysis - Previous experience in academic writing, specifically in accounting - Ability to deliver high-quality, graduate-level analysis Please include any relevant experience and samples of your previous work in your proposal.

...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...

Detail financial analysis of different companies

I'm looking for an experienced accountant who can help me manage my business's accounting and tax preparation for French company SAS LEOPRIX (948 375 274) Key Tasks: - Tax Preparation: Ensuring that my business is tax-compliant and helping me file my business taxes accurately and on time. Experience Required: - Solid understanding of business accounting principles and practices. - Proficiency in tax laws and regulations. - Previous experience with tax preparation for small businesses. Please note: This role does not require assistance with payroll processing.

For my company, I require a proficient accountant with an expertise in bookkeeping and tax preparation. The candidate must be adept at maintaining and recording financial transactions, as well as preparing financial statements. Ideally, the freelancer should be experienced with: - Monthly,...preparation. The candidate must be adept at maintaining and recording financial transactions, as well as preparing financial statements. Ideally, the freelancer should be experienced with: - Monthly, quarterly, and annual bookkeeping - Preparing tax returns and financial analysis reports Since we don't use any specific accounting software, the professional should either be well-versed with manually maintaining records or capable of suggesting and operating an effective accounting ...

I'm in urgent need of an expert in revenue summary analysis for my accounts assignment, to be completed ASAP. Areas of focus include: - Deciphering and analyzing an Excel file, which contains base financial data. - Providing a thorough understanding of the balance sheets, income statements, and cash flow statements in relation to the given data. Ideal qualifications: - Strong accounting background. - Proficiency in financial analysis and interpretation. - Familiarity with balance sheets, income statements, and cash flow statements. - Proficient in Excel data manipulation and interpretation. - Must be able to work fast as this task has a high-priority deadline.