Quickbooks reconciliation vbaproiecte

Suntem o companie multinationala care presteaza servicii in industria automotive si cautam ingineri pe teritoriul Romaniei pentru testarea soft-ului auto. Se va lucra remote dupa perioada de training. Cunoasterea limbii germane este obligatorie, iar engleza reprezinta un plus. De preferat sa aiba cunostinte de Matlab / Simulink, VBA or Python.

Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)

Am nevoie sa modific / imbunatatesc cateva fise Excel pe care le folosim zi de zi in munca noastra. Am nevoie de cineva cu cunaostinte foarte bune de programare in Excel sau VBA

Dezvoltare Aplicatie Excel/VBA prin dezvoltarea unor module noi conectabile la aplicatia deja existenta. Aplicatia in cauza gestioneaza activitatea de comenzi, pregatire, expediere si facturare marfa, intr-o companie mica.

I am Shubheem here given to you work Dezvoltare aplixatie -Excel- VBA pentru optimizarea, activitatii ,depozitare,gestiune see transport here work is Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care of folosim pentru optimizarea activitatii in firma

Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care o folosim pentru optimizarea activitatii in firma. Avem de nevoie de o persoana cu cunostinte de programare VBA . Aplicatia pe care o folosim lucreaza in tandem cu aplicatia WinMentor asa ca sunt necesare si anumite cunostinte despre acesta din urma.

Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie sa arate pentru fiecare (example 1 si 2).

Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85%, puteti sa ma contactati.

Salut Sergiu, Am gasit profilul tau pe Freelancer si am vazut la sectiunea Skills ca stii VBA si Excel. Am un proiect despre care as vrea sa discut cu tine. Ma poti contacta la adresa de email @

Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85% ca si caractere, puteti sa ma contactati.

cod vba excel , sa copii valoare din pagina 2 in pagina 1 cu indeplinirea 3 criteri , vezi imaginele atasate

Am nevoie de cineva care sa ma ajute sa transcriu o problema de mecanica in VBA. Multumesc.

Am un proiect neterminat, am nevoie de cineva care stie VBA Excel sa il poata incheia. Liciteaza doar daca ai experienta in VBA, proiectul nu este chiar usor de inteles si realizat, pentru cine are experienta insa dureaza f putin de incheiat.

te rog sa ma anunti daca esti disponibil in a ma ajuta intr-un project excel vba. e un singur elgoritm de corectat. chstie de cateva minute. mersi

Am nevoie de ajutorul tau pentru o eroare.

Am un proiect aproape terminat si abandonat. Nu este foarte amplu, Am nevoie de cineva care il poate incheia. Este in Excel VBA si voi trimite specificatii pe mail celui interesat. Multumesc!

Locatia de realizare a proiectului: Brasov la sediu firmei Consultanta si suport pentru: Migrare aplicatie realizata din VBA in C# Migrare de la lucru cu tabele excel la tabele Access si SQL Realizare Interfata Profesionala in C# Realizare legatura intre Interfata relaizata in C# si tabele realizate in Access sau SQL Realizare strucura logica de organizare interna a datelelor din tabelele in Cccess sau SQL Relizarea "Relationships" intre tabele in access Teste

...applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. • Provide detailed analyses and explanations of all transactions. • Prepare documentation for external auditors. • Implement and maintain internal financial controls and procedures. Requirements: • Bachelor’s degree in Accounting, Finance, or related field. • Certified Public Accountant (CPA) or similar certification preferred. • Minimum of 5 years of accounting experience, particularly in a corporate setting. • Strong understanding of GAAP and financial reporting. • Proficient in accounting software (e.g., Xero, QuickBooks...

I am seeking a versatile full stack developer to create a service appli...search functionality that provides users with relevant results connecting users with service providers depending upon geolocation. - Payment Processing: The application should include a seamless, secure payment processing system. - Service oriented architecture for plug and play type of services. Completely configurable. - Admin login to monitor for successful ,failed orders and transaction , reconciliation and generate reports. - Complete e-commerce site for processing to order. The successful freelancer will possess extensive experience in full stack development, user experience design and payment portal integration. Proficiency in modern design practices is a must. Experience with service applications is ...

...monitoring and reporting of cash flow changes. User Data Input: - Integrating with Accounting Software: The tool should allow users to input their financial data by directly integrating with their existing accounting software like quickbooks. Ideal Skills: - Proficiency in SaaS tool development using a no code tool flutterflow - Experience with real-time data processing - Previous work on financial reporting tools - Familiarity with integrating systems with accounting software User journey - Register with Google account - link with accounting platform like Quickbooks (1 click integration) - Extract data and save the data in AWS securely - Do some calculations on the data (we will provide it) - Display the information in widget formats in the platform - Client pays ...

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in ...Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero wo...

As a growing business, I need a finance and accounting expert to assist me in streaml...understand, helping me make informed decisions for the business. Ideal Skills and Experience: - Proven experience in accounting and finance, particularly in streamlining financial processes and creating accurate financial reports - Strong analytical skills, with the ability to interpret complex financial data and make recommendations based on your analysis - Experience working with tools like QuickBooks or SAP would be a big plus, but not a strict requirement. This project will be a great opportunity for someone who is a numbers whiz and has a keen eye for detail. If you're confident in your finance and accounting skills and have a track record of improving financial processes, I'd lo...

I'm seeking an experienced web developer with extensive knowledge in WIX and payment gateway integration to build the checkout system of our bulk ice selling business' website. Key tasks include: 1. **Payment Gateway Integration**- The checkout system should incorporate a payment gateway to facilitate secure transac...successful purchase, an order confirmation email should be sent to customers for their records. 4. **Design** - Implement a simple and clean design that aligns with the website's current aesthetic. 5. **Delivery Tracking** - Incorporate real-time tracking of deliveries into our system to enhance customer experience. Ideal candidates should have a solid background in WIX, the know-how in integrating Quickbooks Online for invoicing, and a knack for f...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I'm in need of an efficie...members as well as handling some tasks yourself. - **Timeframe:** This will be a daily commitment, so someone with flexible availability or who can assure daily support is preferred. Ideal Candidate: - **Accounting Expertise:** Prior experience in Indian accounting and taxation is crucial. - **Software Proficiency:** Proficiency in Tally is non-negotiable. Experience with other software like QuickBooks India or Zoho Books is a bonus. - **Organizational Skills:** Strong organizational skills are key to managing the daily tasks efficiently. - **Communication:** You'll need to be confident in asking clients for information and delegating tasks to staff members. If you are an admin assistant who fits this description and can provide daily suppor...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need a dependable, detail-oriented accountant with an intermediate level of experience specializing in bookkeeping and financial statement preparation. Key responsibilities: - Reliable bookkeeping. - Comprehensive preparation of financial statements. Ideal candidate should have: - Proficiency in QuickBooks accounting software. - Demonstrated ability to handle bookkeeping and state financial statements efficiently.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I'm looking for a Quickbooks professional to assist me with weekly bookkeeping tasks. This includes tracking sales, managing expenses, and accurately categorizing transactions. Key Responsibilities: - Perform weekly bookkeeping using Quickbooks Online - Categorize over 100 transactions accurately - Monitor and report on sales and expenses Skills and Experience: - Proven experience with Quickbooks Online - Strong understanding of bookkeeping principles - Ability to efficiently handle a high volume of transactions - Excellent attention to detail - Good communication skills for Quickbooks File Sharing I'm looking for a freelancer who can commit to ongoing weekly work.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

One excel file with macro as per the customer requirement

I'm currently looking for a professional accountant with in-depth experience in using Quickbooks and managing financial tasks for businesses in the USA. Key Tasks: - Managing the Quickbooks accounts for my 10-20 clients, ensuring their financial data is accurately recorded and up-to-date. - Perform bookkeeping and financial reporting tasks for the clients, maintaining a clear and detailed record of their financial transactions. - Prepare and plan taxes for the clients, keeping in line with all relevant U.S. tax laws and regulations. - Process payrolls for the clients, ensuring timely and accurate payments to their employees. Skills and Experience Required: - Extensive experience using Quickbooks, particularly in a professional accounting capacity. - Proficient ...

...and ensure accuracy of financial data - Conduct account analysis and reconciliation to identify discrepancies or errors - Assist with financial audits and provide necessary documentation and support - Utilize accounting software (such as Sage, Xero, QuickBooks) to record and track financial transactions - Assist in the preparation of budgets and forecasts Qualifications: - Bachelor's degree in Accounting or related field mandatory - Chartered Professional Accountant designation an asset - Proven experience as a Canadian Staff Accountant or similar role - Experience in public practice an asset - Strong knowledge of Canadian tax principles and practices - Proficiency in using accounting software (TaxCycle, Netfile, QuickBooks, Xero) - Excellent attention to det...

I'm new to MYOB and currently need assistance in understanding and fixing journal entries, specifically after pay run. The project deadline is immediately, hence I'm looking for a trainer who can guide me on this immediately. Ideally, the freelancer should: My books are basic. I just want to do bank reconciliation. I expect explaining this will take a maximum of 1 hour with screen share.

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...

I'm in need of a skilled bookkeeper who's proficient in Xero. The ideal candidate will have experience handling a variety of tasks, including: - Invoicing and payments - Expense tracking - Payroll processing I have 2 bank accounts that require reconciliation. The perfect freelancer for this job will have a comprehensive understanding of accounting principles and be able to manage bookkeeping tasks with precision and attention to detail. Please highlight your experience with Xero in your proposal.

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

As the client for this project, I urgently require an expert in VBA.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

Looking for a very sharp and proficient Netsuite AP/AR administrator to assist with specific tasks including: - Invoice processing - Vendor management - Payment reconciliation The ideal freelancer would also assist with OneWorld and Chart of Accounts (CoA) configuration such as: - Participate in finance meetings and support - Setting up subsidiaries - Defining accounting rules - Managing intercompany transactions Additionally, I need you to under the Netsuite Order to Cash process and Month End Close. Other prime areas will be administration for: - Customer order management - Billing and invoicing - Cash application and banking - Financial statement preparation - Understand how to create custom fields, forms and workflows Daily support up to 30h weekly. Expertise with Ne...