Quickbooks reconciliation vbaJobb
excel vba programming convert excel sheet function into VBA
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...
I urgently need a skilled professional to address several issues with claims in Athena Health. The primary areas in need of attention are billing, coding, and insurance verification. Key Areas Requiring Attention: - **Claim Denials:** These need to be thoroughly investigated and resolved. - **Incorrect Coding:** The claims system is generating incorrect codes, which must be corrected to ensure accurate billing. The ideal candidate will possess a strong background in medical billing and coding, and be proficient in navigating and addressing issues in the Athena Health system. The ability to work under a tight deadline is essential for this project. Please get in touch with your experience in similar projects, and your availability to start on this immediately.
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
I'm seeking an experienced accountant to help with the reconciliation of my marketplace sales with Payability reports, and to compile monthly financial statements. The ideal candidate will have prior experience in dealing with Payability reports and utilizing accounting software such as QuickBooks, Xero or Wave. Key responsibilities include: - Reconciling my marketplace sales with Payability reports - Preparing monthly balance sheets - Generating monthly income statements - Compiling monthly cash flow statements Please note that I receive daily Payability reports from my marketplace. I have access to all necessary sales data from the marketplace, so the main focus will be on reconciling these figures with the Payability reports. Accuracy and attention to detail are cr...
I'm looking for an expert who can integrate data from three platforms into my Laravel PHP ERP system. These platforms include Xero, Quickbooks, and Sage accounting. Given these specific platforms, a freelancer with experience in working with them would be ideal. Additionally, PHP Laravel framework familiarity is essential. Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating the specific data,...
I'm looking for assistance and process mapping to convert data from QuickBooks to an XML file to integrate with an accounting system. This project primarily centers on the automation and efficiency of our billing process. Key Requirements: - Expertise in QuickBooks, XML, and accounting systems - Quick books desk top program not the cloud based version - Ability to include specific invoice details in the XML file - provide process and plan - Proven experience in system integration The successful candidate will have a proven background in similar projects and demonstrate a clear understanding of the requirements. I am looking to commence the project immediately.
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom...developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar project...
I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.
At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - fo...through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank stat...
I'm looking for a bookkeeping job in QuickBooks Online. Key Responsibilities: - Recording and categorizing all my weekly transactions including invoices, payments, expenses, and receipts. - Reconciling bank and credit card accounts. - Generating financial reports on a weekly basis. - Ensuring compliance with accounting standards and tax regulations. Ideal Skills and Experience: - Proficiency in QuickBooks Online. - Strong understanding of accounting principles and practices. - Experience with bookkeeping for small businesses. - Familiarity with financial reporting and tax requirements. - Excellent attention to detail and organizational skills. Please note that this is a recurring task and will be required on a weekly basis.
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to l...
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
You are a QuickBooks Online EXPERT. You will migrate information from one account to another. My data includes customer and vendor information, account balances, transactions, and payroll data. Several companies were added under one license (as they were divisions of one company) and now are being separated onto different companies and thus, different licenses. Key responsibilities include: - Ensuring the accurate export and import of all necessary data - Handling the migration process smoothly with minimal disruption to the business operations - Ensuring that the structure and integrity of the data are maintained throughout the migration process The ideal candidate for this project would have: - Extensive experience with QuickBooks Online and a deep understanding of i...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
I'm looking for a talented video producer to create an engaging and informative YouTube video that delves into the intersection between Bible teachings and scientific concepts. The video should be more than 5 minutes long. Key Points: - The video content should be focused on themes such as Creationism, Evolution, and the Historical accuracy of the Bible amo...scriptwriting skills - Creative and innovative approach to video production - Experience in creating educational content is a plus. If you believe you can create a video that will captivate and educate viewers on these important topics, I'd love to hear from you. The video will be based on my book in which I have developed and presented a new understanding of the days of Genesis which allows a full reconciliation...
I'm in need of an accounting guru highly skilled in QuickBooks data entry. The task involves: - Compiling financial data from various invoices - Entering income and expense data efficiently into QuickBooks Ability to interpret various invoice formats and high attention to detail is required. Past experience with similar projects is highly preferred.
...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...
...advantage. 6. Payment options – the client portal should allow secure loan payment with Electronic Fund transfer (EFT), debit or credit card (VISA & MasterCard) any other secure payments methods. Transaction Verification Methods such credit card verification value ( C V ) or One Time Pin (OTP)should be used. 7. Payment identification – the client portal should have payment referencing to allow for reconciliation of customer payments. 8. Balance checking - customer should be able to display their balances on their outstanding loan amount. 9. Customer statement – the client portal should also allow customers to 9.1 view their loan balances in a dashboard summary 9.2 view their account transaction history 9.3 request their statements (statement period should b...
...performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integratio...
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project schedule is extr...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm in need of an advanced Excel VBA specialist with proficiency in data manipulation, particularly data filtering across multiple Excel sheets. The tasks required entail: - High-level manipulation of Excel data; - Expertise in filtering data across multiple sheets; - Strong understanding of data validation; - Experience in report generation. Experience in dealing with large amounts of data and creating user-friendly detailed reports from complex data sets will be crucial for this project. Excel VBA certification and verifiable previous projects in similar tasks are a plus.
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from different types of PDFs; - Understanding o...
We are looking for a Quickbooks Expert who specializes in the restaurant industry. As a Quickbooks Expert, you will be responsible for managing and reconciling financial records, tracking expenses, and generating financial reports for our restaurant business. The ideal candidate should be highly proficient in Quickbooks and have a deep understanding of restaurant accounting processes. Responsibilities: - Manage and reconcile financial records in Quickbooks - Track expenses and ensure accurate categorization - Generate financial reports, including profit and loss statements - Provide guidance and insights on financial performance Requirements: - Strong knowledge of Quickbook...
I'm in need of a junior accountant who can spend less than 10 hours per week handling account reconciliation and invoice insertion tasks. Key tasks and requirements: - Account reconciliation: You should have a good understanding of how to resolve any discrepancies in financial data. - Inserting purchase invoices: You will be responsible for recording all purchase details accurately using Excel and Exact Online. Ideal candidates must have: - Experience with Excel and Exact Online for account reconciliation and invoicing. - Good data entry skills. - Sharp attention to detail. - Ability to work independently. Please ensure you meet the above requirements before submitting a bid. Thank you.
I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped ...customization should be advanced, allowing me to set up metrics and views according to my preferences. I'm looking for a skilled Excel expert who has experience in creating similar systems, particularly in the workshop or inventory management domain. You should be proficient in creating complex formulas and functions in Excel, as well as designing user-friendly interfaces and dashboards. Experience with VBA programming would also be a huge plus. Please provide examples of previous similar ...
I'm in need of an experienced accountant who can assist with monthly bookkeeping and the preparation of financial statements. Key Requirements: - Proficiency in QuickBooks: You should have extensive experience using this software to ensure smooth operations. - Bookkeeping Skills: You'll be responsible for maintaining accurate records of financial transactions. - Financial Statement Preparation: You should be able to prepare monthly financial statements. Please note: We're seeking a professional who can commit to a monthly schedule for a long-term basis. The ideal candidate should be detail-oriented, organized, and have a proven track record in providing high-quality accounting services.
I urgently require versatile help with my bookkeeping tasks. This includes meticulously meeting demands relating to: - Data entry - Bank reconciliation - Financial statement Preparation Proficiency in using the tally software is a prerequisite as it's the accounting software I'm currently working with. As for the volume of transactions, I have less than 50 on a weekly basis so, detail-orientation is key. An ideal candidate is one who has a solid foundation in bookkeeping and a proven track record working with a similar volume of transactions. This is a recurring job set to span on a weekly basis.
I'm looking for an expert in QuickBooks Accountant to assist with setting up and troubleshooting my Dutch VAT. The current issues mainly revolve around tax reporting, so I need someone who can help iron out these problems to ensure the system is running efficiently. Key requirements: - Proficient in QuickBooks Accountant - Expertise in Dutch VAT regulations - Experience in setting up VAT systems - Strong troubleshooting skills, particularly in the field of tax reporting Ideally, the individual should also have experience in managing fixed asset registers within a QuickBooks environment. The ideal candidate should be able to communicate clearly and effectively in English.
I'm seeking an expert to help set up and manage QuickBooks for my small rental business, which operates on Turo. In addition, I need someone to assist with making business calls. Key responsibilities include: - Setting up QuickBooks and ensuring it's integrated seamlessly with Turo. - Managing QuickBooks to track expenses and income efficiently. - Handling business calls and providing customer support as needed. Ideal candidates should have: - Prior experience working with QuickBooks and Turo. - Demonstrated history of successful financial management for small businesses. - Strong communication skills for handling calls and providing customer service. Please include descriptions of your past work in your application.
...utilizing QuickBooks, I'm looking for an experienced freelancer who can provide a comprehensive setup that includes inventory tracking, detailed income and expense reporting, and custom report generation. Key requirements: - Inventory Management: I need a system in place to track my inventory, monitor stock levels, and manage reordering efficiently. - Income and Expense Tracking: I require detailed reports on all my earnings and expenditures. This should include categorizing expenses, ensuring all transactions are captured, and providing a clear breakdown of income streams. - Custom Report Generation: I am looking for a professional who can customize QuickBooks to generate specific reports tailored to my business needs. This project is classified as intermediate i...
...goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am looking to start this project as soon as possible, and timely completion is essential. Thank you for your interest, and I look forwar...
I'm in need of an experienced and reliable financial professional to handle our bookkeeping tasks. Key responsibilities will include: - Regular, ongoing bookkeeping using popular software like QuickBooks or Excel. Ideal candidates should: - Have a strong background in bookkeeping and finance. - Be proficient in using bookkeeping software (e.g., QuickBooks or Excel). - Have a track record of delivering accurate and timely financial services. This project is about maintaining our financial records with precision and efficiency. It's crucial that the freelancer is able to commit to regular, ongoing bookkeeping tasks.
I'm in need of a proficient developer with experience in both Excel VBA and Selenium to create a template that enables automated sending of bulk WhatsApp messages. The core functionality I'm seeking includes: - Automated WhatsApp messaging directly from Excel - Bulk messaging support: The capability to send out multiple messages at a time. The messaging content that will be automated is primarily related to the Products and Services information. The ideal candidate for this project should have a demonstrated history of working with Excel, VBA, and Selenium. Experience with similar projects relating to WhatsApp and bulk messaging automation would definitely be a plus. This will be a unique project with potential for ongoing work and tweaks depending on the initi...
I'm interested in having an Excel template developed which uses VBA to automate the sending of bulk SMS. Major points of focus in this project are: -- Compatibility: The template should be compatible with Excel 2010, 2013, and 2016. -- Phone Numbers Input: I'd like to manually enter phone numbers from which the SMS will be sent. -- Message Customization: Depending on the requirement, both the same message may need to be sent to all recipients and different messages to each recipient. The ideal freelancer for this task should be proficient in Excel, VBA, and have experience in automation. Strong communication skills would be appreciated to better understand and implement the specifics of message customization.
...satisfaction. Integrations: - **Amazon Seller Central**: The software should seamlessly integrate with Amazon Seller Central to facilitate order processing and inventory management. - **QuickBooks**: Integration with QuickBooks is needed for our accounting and financial purposes. - **PayPal/Invoicing**: We require integration with PayPal for invoicing purposes. Ideal Skills: - Proficiency in software development, with a focus on creating custom solutions for businesses. - Experience with Amazon FBA and understanding of its processes. - Strong knowledge of API integration, particularly with Amazon Seller Central and QuickBooks. - Ability to create intuitive and user-friendly client portals and dashboards. - Excellent communication skills and a proactive approach to...
As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal ...of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs, I'...
I'm looking for a highly experienced ChiroTouch biller who can help me manage my chiropractic practice billing. I currently have ChiroTouch billing software installed and running. However, I need someone who can take on multiple billing tasks including data entry and claims processing, payment posting and account reconciliation, custom report generation, and overseeing all billing to ensure it's done efficiently and effectively. The ideal freelancer should have: - More than 3 years of experience working with ChiroTouch billing software - Strong attention to detail - Ability to verify coding and fine-tune to maximize payments - Good communication skills to keep me updated on billing progress Your role will be crucial in ensuring that the billing process in my practice r...
I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I'm in need of a QuickBooks expert who can help me turn a .xlsx file with 96 entries into a usable QuickBooks file. Key Requirements: - Integrating the .xlsx file into QuickBooks without any data loss - Proper designation of entries into asset, liability, equity, income, and expense categories - Ensuring the chart of accounts is correctly set up, with all 96 entries accounted for The ideal freelancer will be: - Proficient in using QuickBooks Desktop application - Experienced in setting up chart of accounts and categorization in QuickBooks - Detail-oriented to spot any errors and inconsistencies - Good at communication, to understand and meet my specific requirements. Please bid if you're confident in your QuickBooks skills and can de...
I'm seeking an experienced accountant in Belek, Turkey to handle my small business's financial statement preparation and tax return preparation. Responsibilities: - Prepare and analyze financial statements - Manage tax p...preparation. Responsibilities: - Prepare and analyze financial statements - Manage tax preparation and compliance - Regularly audit financial procedures and recommend improvements Ideal Skills and Experience: - Proven experience in financial statement preparation - Sound knowledge of Turkish accounting regulations - Experience in tax return preparation - Proficiency in Excel; experience with QuickBooks or Xero a plus - Strong analytical and problem-solving skills - Attention to detail and ability to work efficiently - Excellent communication and int...
I have an Excel file which have some scripting and data to connect to Oracle Database and download some log files and parse them into Excel Sheets. Also it parse the files looking for values and interpret those values in plain English ( read from a sheet) . i need to convert that Excel VBA to create a website using Microsoft IIS on my machine and be able to add more data to parse the files for more interpretations( reading the hex codes and display a new output with the hex code highlighted and next to it the English meaning of those codes.
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel
...tasks that I need assistance with. I have started using Xero so I will need help: 1. Categorising Transactions: You will be required to create custom categories for the transactions to enhance the organisation and understanding of my business financial flow, I have made some categories but may need more 2. Bank Reconciliation: I need you to balance my bank transactions with my Xero accounts to ensure their correspondence. 3. Updating Financial Statements: With the reconciliation and categorisation of transactions, I expect an accurate update of my financial statements. I will need and expense and earning report and Profit and loss. As I urgently need these tasks completed, you should be able to complete the entire project within a week. Ideal candidate is proficient w...
I'm a wholesale clothing business owner in need of a skilled accountant to assist with my monthly bookkeeping using QuickBooks. Key Responsibilities: - Regular monthly bookkeeping tasks - Ensuring accurate and timely recording of financial transactions - Reconciliation of accounts - Financial reporting The ideal candidate will possess: - Proven experience in bookkeeping and accounting - Proficiency in QuickBooks software - Background in the clothing or wholesale industry (preferred but not essential) - Strong attention to detail - Ability to meet monthly deadlines - Excellent communication skills This is an ongoing role, and I am looking for someone reliable, efficient, and with a good understanding of the wholesale business.
