Vba accounting projectKazi
Project Title: Contable media jornada I am looking for a freelancer who can assist me with bookkeeping tasks on a part-time basis. Tasks: - Perform bookkeeping duties, including recording financial transactions, maintaining financial records, and reconciling accounts - Ensure accuracy and compliance with accounting procedures and regulations Ideal Skills and Experience: - Strong background in bookkeeping and accounting - Proficiency in using online accounting software - Attention to detail and excellent organizational skills Communication: - I prefer to communicate with the freelancer in Spanish. Method of Sharing Information: - I prefer to share accounting information through online software. If you have the necessary skills and experience, and ar...
...Specialist/Web Developer to optimize our Shopify store. Our goal is to streamline our website's backend, particularly organizing our inventory with SKUs and variants for our prints offered in multiple sizes and framing options. Additionally, we aim to automate and enhance our order processing and fulfillment workflows for improved operational efficiency. Project Overview: Organize Backend: Create and input SKUs for each print, accounting for different sizes and framing options. Variant Setup: Implement product variations efficiently within Shopify for a user-friendly customer experience. Automation: Set up automated workflows to replace manual email notifications for new orders, integrating systems or apps to trigger notifications automatically. Order Management Tool...
As a thriving business, I need a diligent accountant to assist with weekly bookkeeping and preparation of financial statements. You'll need in-depth knowledge of financial bookkeeping, as well as an eye for detail for the accurate maintenance of records. Our business operates pr...track all transactions and maintain an orderly book of accounts. - Financial Reporting: At the end of each week, you'll prepare a comprehensive financial statement. Having experience in preparing and managing tax documents will be advantageous, although it's not strictly necessary for this project. An understanding of international financial reporting standards would be ideal. If you are thorough, pay close attention to detail, and have a proven track record in accounting, I encour...
I am looking for someone in the Miami/Fort Lauderdale area to work on an EXCEL/VBA Project. I have a client who sends me their po in an excel format and I need it to output in different formats that are used for different tasks at my company. The application has macros that need repair. I may decide to rewrite the application, instead of repair it. I would like to work with someone located in South Florida. Thanks!
Hello, We want to move accounting from Quickbooks desktop to ODOO Online for a Spanish company. We want you to; 1) Setup the chart of accounts with PYME 2008 fiscal localization for approx. 90 accounts with year end opening balances as at 1 Jan 2024. You should be familiar with the Spanish chart of accounts. The list will be provided in Excel. 2) Set up an invoice template in Spanish where we can issue invoices, including our address, bank account details, email, website, tax id’s, etc. . 3) Set up an automated invoice to be emailed to one client for rent due every month. 4) Connect ODOO to two bank accounts and setup the rules for auto reconciliation. We will probably use SaltEdge to connect the bank accounts. 5) Book approximately 10 invoices received, with VAT and ret...
...These photos will be displayed on the service page. D. Please hide provider's email, telephone number, address from the public but replace by a verified badge/background check badge that will be set by admin upon background check successful completion and account approval. D. Add hourly pay option beside fixed rate option. Provider will submit final hours to admin/accounting for approval and processing. Thanks. For this project: - In-depth knowledge of custom WordPress theme development is a necessity - Proven experience with plugin integration - Strong understanding of e-commerce site design and functionality - Ability to work with specified designs and layouts. Your expertise in WordPress customization will be instrumental in bringing my vision to life....
Lots o very repetitve modules need error handling, refactoring
Hello, We want to move accounting from Quickbooks desktop to ODOO Online for a Spanish company. We want you to; 1) Setup the chart of accounts with PYME 2008 fiscal localization for approx. 90 accounts with year end opening balances as at 1 Jan 2024. You should be familiar with the Spanish chart of accounts. The list will be provided in Excel. 2) Set up an invoice template in Spanish where we can issue invoices, including our address, bank account details, email, website, tax id’s, etc. . 3) Set up an automated invoice to be emailed to one client for rent due every month. 4) Connect ODOO to two bank accounts and setup the rules for auto reconciliation. We will probably use SaltEdge to connect the bank accounts. 5) Book approximately 10 invoices received, with VAT and ret...
Job Title: Advanced Spreadsheet Developer for AI-Enhanced Financ...Required Skills and Qualifications: Expertise in Microsoft Excel or Google Sheets, including advanced functions, scripting, and AI tool integration. Strong understanding of personal finance management, accounting principles, and tax preparation requirements. Experience in AI and machine learning, particularly in data categorization and analysis. Excellent analytical, organizational, and problem-solving skills. Ability to create a user-friendly interface with AI-powered functionalities. Strong attention to detail and a commitment to accuracy. Preferred Qualifications: Background in finance, accounting, computer science, or a related field. Prior experience creating financial management tools or templates with...
I am in need of an Excel expert who has experience with VBA/Macros or Python. The specific tasks I require assistance with creation of interactive pivot, data analysis and visualization. The deadline for these tasks is urgent, as I need them completed within 24 hours. It is important that the freelancer is proficient in VBA/Macros or Python in order to automate repetitive tasks and create complex formulas.
I'm seeking a proficient Excel user to help me with a specific problem. I need to calculate yes/no questions on a numerical scorecard, accounting for null cells. Here's what I am looking for: * Average of yes/no responses for cell E10 located on the following 17 worksheets (they are the names of the worksheet): SBT FB - Ashley Meredith SBT FB - Bruce Tworeck SBT FB - Carissa Romero SBT FB - Chris McBratney SBT FB - Danae Bell SBT FB - Danielle Reber SBT FB - Erica Shirer SBT FB - Jenna Laporta SBT FB - Jenna Rohrs SBT FB - Kayla Drost SBT FB - Kimberlee Cooper SBT FB - Lani Harrell SBT FB - Mackenzie Wilkening SBT FB - Mercede Hutchinson SBT FB - Morgan Isham SBT FB - Nicole Foster SBT FB - Wayne Freeman * Note that "yes" is equal to one point while "n...
Bookkeeping and Taxes - Services Required: Both bookkeeping and tax preparation - Accounting Software: Yes - Frequency of Services: Weekly I am looking for a freelancer who can handle both bookkeeping and tax preparation services for my business. I currently use accounting software and require these services on a weekly basis. Ideal Skills and Experience: - Strong knowledge and experience in bookkeeping and tax preparation. - Proficiency in using accounting software QuickBooks Online and ProSeries Tax Software. - Attention to detail and accuracy in handling financial records. - Familiarity with USA tax regulations and laws. - Ability to meet weekly deadlines for bookkeeping and tax filing.
I'm looking to create a custom web application using Microsoft tech stack. This application will be designed to handle API ca...fetching and updating data. Here is what I need: - Development of a web app on Microsoft tech stack platform - Integration with a specific API (details to be provided upon project start) - Functionality for fetching data from this API - Functionality for updating data through this API As for the required skills and experience, I expect the ideal candidate to: - Have significant experience in building web applications using Microsoft tech stack - Be proficient in API integration - Have an understanding of data fetching and updating functions in an API context. Alternatively, this could also be built as a VBA Excel file or a GScri...
I'm looking for an Excel VBA expert for the automation work urgently. A successful freelancer will be eligible for all the details that I'm looking for. I want the freelancer to complete this task within 2 hours. Place your bids. All the best!
Ideally looking for...and SMSF in Australia Accounting Services for Small Business Skills and Experience: - Experienced in tax preparation for small businesses - Proficient in accounting software and systems - Knowledgeable in financial statement analysis - Detail-oriented and accurate in bookkeeping - Familiar with monthly accounting tasks and deadlines Project Description: We are a small business in need of monthly accounting services, specifically tax preparation. We are looking for an experienced accountant who can assist us in managing our financial statements and ensuring accurate bookkeeping. The ideal candidate should be proficient in accounting software and systems, and have knowledge in financial statement analysis. Attention to detail...
I am looking for a freelancer to create a custom ledger report for my financial data. The report should include all financial transactions and be presented in Excel format. I need the report to cover all time periods, not just a specific time period. Ideal Skills and Experience: - Strong knowledge of financial data and accounting principles - Proficiency in Excel to create the report - Attention to detail to ensure accuracy of the data - Ability to organize and present data in a clear and concise manner
Project Title: Italian small business accountant that speaks English I am looking for a skilled accountant who can provide ongoing bookkeeping services for my Italian small business. It is important that the accountant speaks English fluently. Skills and Experience: - Fluent in both Italian and English - Extensive experience in bookkeeping for small businesses - Familiarity with Italian accounting regulations - Strong attention to detail and accuracy in financial record-keeping - Ability to communicate effectively with non-native English speakers - Proficiency in accounting software (such as QuickBooks or Xero) - Knowledge of tax preparation and financial statement preparation for small businesses If you meet these qualifications and are available for ongoing bookke...
I am seeking a specialist to rec...Entailing the development and representation of my accounting skills, financial analysis, budget preparations, and auditing abilities in an impressive and succinct manner to garner the attention of potential employers. Freelancers bidding for this project should demonstrate: - Expertise in CV/Resume writing. - Understand the application of ATS and its parameters. - Knowledge of the Financial Services sector, particularly in accounting roles. - Strong writing abilities to convincingly showcase my abilities and accomplishments. - Familiarity with senior-level job requirements and expectations. At the end of this project, I anticipate walking away with a compelling professional CV that will offer a competitive edge for senior...
...application needs to have the following features: - Accounting Management: The software should be able to handle all the accounting processes of the flight school. - Stock Management: It should also have a feature to manage the stock of the flight school. - Student Activity Management: The software should be able to track and manage the activities of each student. The software should be able to support multiple users, as there will be multiple staff members using it. Additionally, it should be accessible on both web and mobile platforms to ensure convenience and flexibility for the users. Ideal skills and experience for this job include: - Proficiency in software development and programming languages - Experience in developing accounting and stock management sys...
...financial statements - Proficiency in accounting software and tools - Excellent communication and collaboration skills to work closely with me and understand my business requirements Responsibilities: - Review and update the existing balance sheet to ensure accuracy and completeness - Analyze financial data and prepare a comprehensive balance sheet report - Identify any errors or discrepancies and make necessary corrections - Collaborate with me to understand the specific requirements and goals of my retail business - Provide recommendations for improving the financial health and performance of my business based on the balance sheet analysis If you have the necessary skills and experience in balance sheet analysis and the retail industry, and can complete the project wit...
I have a Microsoft Access Database (.mdb) on my laptop that contains a table called InstallerReqDocumentsTbl that has 3 fields, namely InstallerRequiredDocID, InstallerRequiredDocName and InstallerRequiredDocExpiryDate. The InstallerRequiredDocID field type is AutoNumber, the InstallerRequir...automatically send an email from my IMAP/SMTP email account to another email account 120 days and 90 days and 60 days and again 30 days before the expiry date contained in the InstallerRequiredDocExpiryDate field. The email Subject Heading must contain the value entered in the InstallerRequiredDocName field with the phrase “Document is about to expire.” Can you please generate VBA code for me to do this? I need to copy and paste this VBA code in the newly Module 1 that I w...
...and preferences for the project include: Purpose of the holding structure: - Facilitate international business operations Countries involved in the holding structure: - EU countries Preference for the type of holding structure: - Holding Company Skills and experience required: - Strong knowledge of international tax laws and regulations - Expertise in structuring and establishing holding companies - Experience in working with EU countries and their tax systems - Ability to provide guidance and advice on minimizing tax liabilities within the holding structure - Familiarity with asset protection strategies within an international business context If you have the necessary skills and experience, please submit your proposal outlining your understanding of the project requ...
VBA developer to enhance our existing Excel project by integrating a robust automation feature. The primary goal of Module 3 is to automate the generation and email delivery of reports in PDF format at scheduled intervals. Skills Required: Advanced VBA programming skills Experience with Excel automation and integration Proficiency in generating and handling PDF files using VBA Knowledge of Outlook integration with VBA Responsibilities: Integrate VBA code into Module 3 of our existing Excel workbook for automating report generation. Develop a robust mechanism to schedule and send reports at specified intervals. Ensure the accurate generation and timely delivery of reports in PDF format. Collaborate with our team to address any specific requirement...
Hi everyone, This is what I need from our General Manager: Filipino based (our whole team is) Accounting degree - preferably knows how to use XERO Has been a Virtual Assistant before - speaks perfect English Is available full time and does not work in any other role You will be on a profit share with this business - you will live, sleep, and breathe this business. Do not apply if you can only work 8 hours a day, if you cant work weekends, if you have another job, if you 'enjoy spending lots of time with friends' etc etc. This role is only for someone serious about building their empire. Mention your favourite Pokémon in your initial reply to slow down the fakes lol. Cheers
Basically, our business is a micro business operates by purchasing products on a daily basis and selling them when the stock is at capacity to ship. The project is about making accounting system from scratch. Problem is we do not have solid foundation of accounting so we are looking for professionals that might help us.
I need someone to prepare an account statement for me
...formulas and functions, and implementing macros and automation. I have intermediate knowledge about Excel features but need an expert who can guide and support me on this project. The project revolves around Financial Data, hence an understanding of such data will be necessary. Key responsibilities include: *Layering PnL Data from one excel on top of another excel with yearly PnL as columns. Goal is to employ a simple formula but see the overall result in a user friendly way on excel spreadsheet. All the work is done using Excel VBA A successful candidate should have: * Proficiency in MS Excel including VBA, Pivot Table, simple formulae. * Proven experience in creating effective macros for automation * Exceptional problem-solving skills to as...
...Specialist/Web Developer to optimize our Shopify store. Our goal is to streamline our website's backend, particularly organizing our inventory with SKUs and variants for our prints offered in multiple sizes and framing options. Additionally, we aim to automate and enhance our order processing and fulfillment workflows for improved operational efficiency. Project Overview: Organize Backend: Create and input SKUs for each print, accounting for different sizes and framing options. Variant Setup: Implement product variations efficiently within Shopify for a user-friendly customer experience. Automation: Set up automated workflows to replace manual email notifications for new orders, integrating systems or apps to trigger notifications automatically. Order Management Tool...
I am looking for a skilled developer who can customize existing features and fix bugs on accounting CRM system I have purchased. The system based on CodeIgniter framework (files: JavaScript JS, CSS, PHP, SQL). The changes needed have a high priority and must be completed within 2 weeks. Ideal Skills and Experience: - Strong experience in customizing CRM systems and fixing bugs - Proficiency in coding languages such as PHP, JavaScript, and SQL - Familiarity with accounting principles and workflows - Attention to detail and ability to understand and interpret user requirements - Excellent problem-solving and troubleshooting skills
As business targeting businesses, your role will be to consistently manage our presence across Facebook, Instagram, Twitter and LinkedIn with the primary objective of generating leads. Excellent skills in these platforms and demonstrated experience in engaging these demographics are crucial. Key Responsibilities: * Regularly updating our social media platforms * Engaging our target audience to generate leads * Designing and posting content Ideal Skills and Experience: * Proven experience in managing similar age demographics on social media * Comprehensive understanding of Facebook, Instagram, Twitter, and LinkedIn * Proven track record of generating leads through social media campaigns * Excellent written and verbal communication skills. * Ability to have designs and content posts m...
...the printed document. The work order should support printing on half a page with a background format adapted to our company. The work order must be validated by an operator but predetermine a responsible person, and this responsible user will appear as the responsible doctor with their digital signature and seal in the signatures section. It must eliminate the flow of generating an invoice in accounting from the order, as the order replaces the invoice. Flow: Point of sales order with field selection for work order. Generate work order and have the operator accept it. Perform and fill out the test. Requirements: in the order and the test, the patient's data must be shown: name, age, gender, phone, identity number. At the footer of the laboratory test, the signature and sea...
Accounting Services for Ongoing Tax Preparation - I am looking for an experienced accountant to provide ongoing tax preparation services for my business. - The ideal candidate will have expertise in tax regulations and be able to accurately prepare and file my business taxes on a regular basis. - I have all of my financial information sorted and ready, so the accountant will only need to focus on preparing the tax returns. - This will be an ongoing project, as I will need the accountant's services on a regular basis. - The accountant should have strong attention to detail and be able to meet deadlines. - Experience working with small businesses or similar industries is preferred. - Please provide examples of past tax preparation work and any relevant certifications or q...
I am looking for an experienced Excel and VBA expert to help me with building custom functions and formulas for my project. Specific requirements for the project include: - Developing custom functions and formulas in Excel using VBA - Automating repetitive tasks in Excel using VBA - Analyzing and reporting data in Excel The timeline for this task is short term, within a week. Skills and experience required for this job: - Proficiency in Excel and VBA programming - Strong understanding of data analysis and reporting - Ability to create custom functions and formulas in Excel - Experience in automating repetitive tasks in Excel using VBA If you have the skills and expertise required for this project, please reach out to me with you...
...one-time bookkeeping project to set up Xero so I can manage personal finance and my construction business myself once all of the records are upto date Project tasks: Setup Xero for: - personal finance including multiple investment properties - my construction company (which for the last 3 years has only been purchasing goods and has not sold anything (approximately 1000 transactions have been made) - upload previous figures of previous lodgments from 2017 to 2020 I need to upload business records from previous years from the spreadsheet into Xero: The following financial years have not yet been lodged. 22-23 23-24 These all will need to be reconciled and ready for the submission of BAS. Once complete, Balance Sheet & Profit / Loss statements are to be up to data...
In order to en...to ensure the smooth running of my business, I am in need of an experienced and meticulous accountant who can provide regular and ongoing assistance with: - Bookkeeping - Preparation of financial statements - Tax filing This should be performed on a monthly basis, requiring you to be consistently accurate and punctual with your submissions. I currently utilize Tally Prime as my accounting software, so proficiency with this tool is a must-have skill. The ideal candidate for this role would have reliable experience in the aforementioned tasks with efficiency and precision, as well as a reliable understanding of the software. This role requires a professional who is capable of managing time effectively and maintaining strict confidentiality of all finan...
Bank Reconciliation using Zoho Books - I am looking for a freelancer who can perform monthly bank reconciliation for my existing business using Zoho Books. - The ideal candidate should have experience in using Zoho Books for accounting purposes. - The freelancer should be able to reconcile bank statements with the transactions in Zoho Books - I have due reco from 1st September 2023 till Dec 2023 . - 250 lines items in total per month .
Hi community, I am looking for an Excel VBA wizard who can help me with some projects on a longer term assignment. I work for an international organization and as such, the chosen candidate will have to undergo some background checks etc but I am sure we can work that out. My office is in Dubai so I'd prefer to work with somebody in time zones between GMT and GMT+6. Here is what I am looking for: - Experienced MS Excel VBA expert, ideally Microsoft-certified - At least 10 years of experience working with clients - At least 10 hours per week of availability, and if there is a need, ability to "boost" to more hours. - An understanding of the hospitality industry might come in handy - Experience with VBA applications - Experience with big data - Excellen...
I am looking for a skilled Excel VBA developer who can create scripts for me in Google Sheets. The specific tasks I need the VBA scripts to perform include formatting and visualization of data. I have specific guidelines for the format and style in which I want the data presented. The project needs to be completed as soon as possible. Ideal Skills and Experience: - Proficiency in Excel VBA scripting and Google Sheets - Strong background in data manipulation and analysis - Experience in formatting and visualizing data - Ability to follow specific guidelines and meet tight deadlines
I am in need of a professional with a deep understanding of bookkeeping and is proficient in using Miracle accounting software. Efficiency in executing the following tasks is essential: • Regular upkeep of the company's financial data • Maintenance of the company's financial records and postings • Detection and addressing discrepancies Although there's no pressing deadline, the ability to deliver high-quality work on a consistent basis is paramount. Previous experience in similar roles will be highly regarded, as would a history of using Miracle for bookkeeping. If this project aligns with your skills and experience, I welcome your bid.
I am looking for a freelance accountant to assist me with basic bookkeeping for my new enterprise. This project is for business use and I expect the accounting work to take less than 10 hours per week. Ideal Skills and Experience: - Strong proficiency in accounting principles and practices - Experience with basic bookkeeping tasks such as recording financial transactions, reconciling bank statements, and maintaining general ledgers - Familiarity with accounting software (e.g., QuickBooks, Xero) - Attention to detail and accuracy in data entry and financial recordkeeping - Ability to communicate effectively and provide timely updates on financial activities - Knowledge of tax regulations and compliance requirements for small businesses is a plus.
I am looking for a skilled Excel VBA programmer or someone experienced with creating Excel macros. The goal of this project is to create a program that will break a single row into multiple rows in order to organize data. The client has provided a sample Excel file to demonstrate their desired outcome. The new rows created should follow a specific format, as specified by the client. The program should be designed to be used frequently, as the client anticipates needing to use it on a regular basis. Applicants should have a strong understanding of Excel VBA and be able to efficiently organize data using macros.
I am looking for a skilled developer to create an accounting system for my existing business. Here are the details of the project: Specific Requirements: - I have a list of required features that I would like the accounting system to have. These features will be provided to the developer upon hiring. - The system should be able to handle daily market transactions and generate accurate financial reports. Preferred Software or Platform: - I would prefer the accounting system to be developed as a web application. Ideal Skills and Experience: - Experience in developing web applications for accounting purposes. - Strong understanding of accounting principles and practices. - Proficiency in web development languages such as HTML, CSS, and JavaScript. ...
Project Title: Accountant Consulting Areas of Accounting Consulting Needed: - Monthly closing process Challenges or Issues: - Not sure, need guidance Desired Frequency of Consultation: - As-needed Skills and Experience Required: - Expertise in monthly closing process - Strong knowledge of taxation, financial statements, and budgeting and forecasting - Ability to provide guidance and support in accounting challenges and issues - Flexibility to provide consultation on an as-needed basis
I am in need of a professional with a deep understanding of bookkeeping and is proficient in using Miracle accounting software. Efficiency in executing the following tasks is essential: • Regular upkeep of the company's financial data • Maintenance of the company's financial records and postings • Detection and addressing discrepancies Although there's no pressing deadline, the ability to deliver high-quality work on a consistent basis is paramount. Previous experience in similar roles will be highly regarded, as would a history of using Miracle for bookkeeping. If this project aligns with your skills and experience, I welcome your bid.
Looking for an expert with experience in data entry, specifically data input, to handle information coming in Excel files. An understanding of accounting and finance is imperative as the data falls within this realm. Ideal skills and experience for the job include: - Proficiency in Excel - Experience in data input - Sound knowledge and understanding of accounting and finance - Excellent attention to detail - High-speed typing skills - Possess great organizational skills Accuracy and efficiency are priority, handling the data with both speed and care is essential.
...Automate the process of tax calculation to minimize errors and significantly reduce the time spent on this critical task. - Seamlessly integrate with popular accounting software in the market, drastically improving workflow and data management. - Generate comprehensive and legally-compliant reports to enhance organisational record keeping and auditing. The ideal potential candidate would possess strong programming skills, previous experience in the development of tax or finance related software, and an understanding of accounting principles (particularly as they pertain to taxation) and accounting software integration. This project is suited for professionals who understand the strategies for improving tax compliance efficiency. Strong knowledge on tax con...
Project Description: I am looking for a freelancer to prepare a budget for my small business for the past 3 months. The budget should be created using Excel, then pdf. Ideal Skills and Experience: - Experience in budget preparation for businesses in Saudi Arabia system. - Strong knowledge of financial management and accounting principles Working in authorised office
I'm in need of a reliable and knowledgeable accountant who is intimately familiar with ZOHO Books and ZOHO Payroll. My requirement is two-fold: 1. Data Entry: - Input sales/revenue data, as well as expenses/cost data for the financial year 2023-24 in ZOHO. 2...2. Automation Setup: - Autonomously set up GST and Payroll automation in ZOHO while adhering to the local business-specific regulations in my area. Ideally, you should have prior experience in dealing with ZOHO systems, and an impeccable understanding of the local regulatory environment. All the entries made and all the automations set up should be fully compliant with the bookkeeping and accounting rules specific to my business location. Accuracy and attention to detail are paramount for this task. I look forwar...
