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.




  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

  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


Blog Archive