These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 9, 2010

Bookkeeping in Excel

Executive Summary

Many accounting students try to practice their accounting skills by working as contract bookkeepers throughout school. Many times, clients that hire these student-bookkeepers do have not purchased bookkeeping software because they don’t feel like they can justify the expense. In these cases, the student is forced to cover the costs of a bookkeeping program, such as QuickBooks. My completed project is a simple Excel-based bookkeeping program that performs many of the same bookkeeping functions that QuickBooks does.

File: http://files.gove.net/shares/files/10f/dma198/Awesome_Inc..xlsm

Report: http://files.gove.net/shares/files/10f/dma198/final_project_writeup.pdf

3 comments:

  1. Thanks for this great work done. For me, it solves my present challenge. Please, my quest is this: I want to login as documented in the pdf that both admin and password should be "admin". I have tried this severa times but it keeps giving this error-"runtime error '1004' Method 'Range' of object'_worksheet failed'"

    what should i do ? thanks

    ReplyDelete
  2. Kudos! This should definitely be of help to those who are struggling to get their finances into proper shape. It should also provide additional support to those who are learned in bookkeeping, enough to impart lessons and advice to others who do.

    Venita @ A Reliable Bookkeeping Services

    ReplyDelete
  3. Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks! Freshbooks

    ReplyDelete

Blog Archive