Excel VBA / Access on Accounting report

Budget N/A
Bids 31
Average Bid $2465

Job Description

Our client, an accounting firm, is looking for an Microsoft Excel and Access developer with accounting background to provide semi-automation for their clients' reports. This involves trial balance, leadschedule and supplementary.


- 2 types of categories
a) account categories – sheet1 and sheet2 (page 3 and 14)
b) asset/liability categories – sheet 2 (page 1 and 2)
- Automate trial balance report (sheet1), extracting data into leadschedule (sheet2).
- Extract data from supplementary (sheet3) based on exact keyword match with sheet2. Data will be auto-filled in sheet2.
- Every client has its own unique accounts # and categories.
- Grouping can be done locally on computer, before uploaded to database.

- Grouping of account # into different account categories.
- Grouping of account categories into different asset/liability categories.
This allows the grouping to be done automatically instead of having to manually key in the process all over again, when next accounting needs to be done. It needs to have the abilility to group new account # and save to the central database.

- Ability to set template for different account categories

Eg. Sheet 2
Row 68 – 75
Row 119 – 133
Row 171 – 182
Row 195 – 199
Row 230 – 236
Row 282 – 291

- Ability to extract grouping from central database within local network.
- Key validation – there should be a key validation that is valid for x month. The key file would be located locally in the staff computers/laptops. This key file would communicate daily at a certain timing or upon login of Windows. Should the key file not updated for more than x month, the staff would not be able to open up the excel files.

Please provide us your experience working in a similar capacity.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • svuletic Profile Picture



    20+ years in IT consulting and BEng in computer systems engineering

    Website Design, SQL, Software Architecture, and Microsoft Access

  • qualifiedcoders Profile Picture


    NEW DELHI,  India

    Qualifiedcoders is a company having 67 professionals working in various domains. Our company follows complete software development life-cycle and has been developing huge web based and desktop based applications. Established in Year :2007 Number of Employees : 67(as of january'2011). Business Domain: Banking,Manufacturing and Production,Wholesalers,Telecom,IT Offshore Outsourcing. Few of the websites developed in different domains are listed below: Note: To avoid search engines to crawl this page, we are placing '*' and '&' symbols in the urls so please remove tehm from the URL before you navigate to any of the link. Social Networking 1)www.i*a*m*an*art*ist.com 2)www.t*h*ed*i*s*k.com/index.aspx 3)www.t*e*c&h*n&o*u&s*a.com/phpdone/facebooklearn/ 4)www.c*a*b*o*d*e*n*t.org 5)www.s*p*a*r*t*a*c*u*s*p*2*p.com 6)www.a*c*tiv*chal*le*n*ge.com 7)www.t*e*c*h*n*o*u*s*a.com/ajhub/ 8)www.5*m*i*n*u*t*e*s*a*w*a*y.co.uk 9)www.t*e*c*h*n*o*u*s*a*.com/socialnetworking/ And many more: Auction websites Pay per click website such as Swoopo 1)www.r*unlive*au*cti*ons.com 2)www.j*or*gi*t.com 3)www.i*ama*na*rt*is*t.com/l*ive*auc*tions/index.aspx Lowest unique Bid Auction 1)www.t*e*c*h*n*o*u*s*a*.com/phpdone/lowestbidauction/ Matrimonial Websites : 1)Clone of www.s*h*a*adi.com www.t*e*c*h*n*o*u*s*a*.com/shaadi/ 2)Clone of www.j*ee*va*ns*a*a*t*hi.com www.t*e*c*h*n*o*u*s*a*.com/demo/jeevansathi/ Real Estate Websites 1)Clone of www.r*e*d*f*i*n.com with google maps www.t*e*c*h*n*o*u*s*a*.com/realestate/home.aspx 2)Clone of www.i*n*d*i*a*p*r*o*p*e*r*t*y.com www.t*e*c*h*n*o*u*s*a*.com/property/index.aspx 3)Clone of www.m*a*g*i*c*b*r*i*c*k*s.com www.t*e*c*h*n*o*u*s*a*.com/phpdone/magicbricks/

    PHP, Perl, ASP, and C Programming

  • ddraganvw Profile Picture


    sremska mitrovica,  Serbia

    ## BIO **DRAGAN DRAGOVIC** Master of Science in Electrical and Computer Engineering I am advanced user of Microsoft development tools (Visual Studio 2005, 2008,2012, Business Intelligence Development Studio, SQL Server Management Studio) with excellent knowledge of T-SQL data manipulation language and working knowledge of Microsoft SQL Server (2005, 2008, 2008 R2, 2012). I have experience in ETL and CRUD processes and data warehousing. I am familiar with programming/scripting/markup languages: Fortran, Pascal, C, C++, XHTML, XML, HTML/ SS, JavaScript and I have excellent command of Microsoft Office tools (Word, Excel, PowerPoint, Access, Outlook). Always online and prepared to intervene. Developing web applications (like SPA) for large companies with very complex business requirements (standalone system applications in small and big shops, clinical laboratory, pharmaceutical industry, agricultural production etc and well some web applications.)

    Javascript, Visual Basic, .NET, and Data Processing

  • Meganopoullus Profile Picture


    DF,  Mexico

    Financial analyst, native spanish speaker, advanced english speaker. Dependable.

    Translation, Data Entry, Excel, and Customer Support

  • Leparfait13 Profile Picture


    Antananarivo,  Madagascar

    Vous pouvez nous confier l\'externalisation offshore de l\'ensemble de vos besoins en saisie des textes : livres, documents et données diverses, traitement statistiques de vos données. Nous traitons également votre donnée pour : optimisation et enrichissement d\'un résultat suivant votre commande, conversion OCR de votre document PDF ou à partir d\'une numérisation scan (texte, image, photo) en document modifiable et interrogeable, montage de diapositives pour présentation des thèmes et sujets divers. Notre prestation de recherches et d\'investigations d\'informations vous offre aussi tous les renseignements disponibles à votre requête dont vous avez besoin. En étant freelance indépendant à Madagascar, avec notre structure et charge très réduites, nous vous promettons des services outsourcing offshore de qualités à prix moindre, à une durée respectée, avec sécurité et confidentialité de vos données pour fidéliser votre confiance à notre prestation.

    PHP, XML, Website Design, and Powerpoint

  • gabi19 Profile Picture


    Bucuresti,  Romania

    ms office & finance *************************** ************************* *************************

    PHP, Visual Basic, Data Processing, and Project Management

  • illuminesoft Profile Picture


    Solapur,  India

    Successfully finished over 430 Microsoft Access Database projects and 50+ .net/other projects. IllumineSoft is established in 1999. Illuminesoft is Intellisoft in India. The company has developed a number of database applications for Hospitals, Doctors, Trading Businessmen, Service Industry, Marketing Companies, Farm Houses, Pharmaceutical Drugs Trading, Chartered Accountants, Canvassing Agents, Libraries, Medical Service Company, Wood Logs Cutting Industry, Municipal Corporation, Web Searching Engine/Yellow Pages, CAD/AutoCAD, Day Care/School , strongly believe in quality engineering work. We train our staff to adopt all Software Engineering methodologies to develop Quality software. We have access to consultations of experts in software, medical science, Engineering science & technology, and textiles from India and abroad. We worked on more than 495 outsourced projects, with a team of more than 5-12 developers. We have more than 150 satisfied customers in about 23 countries.

    Javascript, XML, Adobe Flash, and Visual Basic

  • nehaarora11 Profile Picture


    Delhi,  India

    Editing,fiction writing,academic writing

    Excel, Testing / QA, Facebook Marketing, and Education & Tutoring

  • BIQed Profile Picture


    White,  United States

    15 years of IT 8 years of BI Always on time and under budget with high quality BIQed.com

    Project Management, Excel, SQL, and Powerpoint

  • sudewa Profile Picture


    Deakin,  Australia

    Career Objective To become a technical consultant in providing sustainable solutions to local and global organizations by using the multidisciplinary skills I have obtained, ranging from electronics engineering, IT, finance and management.

    Perl, C Programming, Visual Basic, and Data Entry