Excel VBA and SQL Server Specialist Needed for Multi-User Accounting System Setup

Posted last week

Worldwide

Summary

We are looking for an experienced Excel VBA and SQL Server specialist to help us configure, troubleshoot, and fully implement an existing Excel-based accounting system across multiple computers. The system is already developed and documented. We are not looking for someone to build it from scratch. We need a hands-on technical specialist who can review the current setup, resolve connectivity and synchronization issues, and ensure that the entire system works properly in a multi-user environment. System Technologies The accounting system currently uses: - Microsoft Excel - VBA Macros - SQL Server Express - SQL Server Management Studio (SSMS) - Power Query - Data Scripts - ODBC Driver - Multi-User Client-Server Architecture Project Goal The goal is to establish a reliable setup where: -One Server Computer hosts the SQL database. - Multiple Client Computers connect securely to the Server Computer. - Each department can access and use its assigned Excel forms. - Transactions entered from different computers are properly saved and synchronized. - Posted transactions are correctly reflected in the General Ledger. - Excel forms, macros, Power Query connections, and database workflows function consistently across all computers.

  • $5.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Financial Report
Microsoft Excel
Activity on this job
  • Proposals:5 to 10
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Apr 13, 2020
  • Philippines
    Cavite12:14 PM
  • $1.1K total spent
    53 hires, 14 active

Explore similar jobs on Upwork

Short Film Budget EstimationFixed-price‐ Posted 2 months ago
Video Production
Budget
Film Budget
Film & Video
Google Ads Account OptimizationHourly‐ Posted 3 weeks ago
Google AdSense
Google Ads
Pay Per Click Advertising
Google Analytics
Google Tag Manager
PPC Campaign Setup & Management

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo