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 11, 2014

Washington Sales Tax Calculator/Reporter

Executive Summary

This project focuses on calculating ever-changing Washington state sales tax for differing types of transactions. Recently, BYU and the LDS Church had to begin collecting tax for any items/services sold to anyone living in the state of Washington. This has been a big headache for lots of departments on campus because Washington State sales tax often changes every quarter and every city has a different rates. I currently work on in the Harold B. Lee Library and the individuals who do perform the sales don’t understand how to look the tax up nor have the time. This spreadsheet allows then to do a quick calculation of the amount of tax that they should be charging on the transaction and allows the transactions to be recorded in the format that my office has to later convert it into to submit to the tax office. It is a made to be user friendly and so that anyone could use it and adapt it to the needs of their department quickly.

No comments:

Post a Comment

Blog Archive