Transaction Register

Executive Summary

For this project, we worked with a small retailer that records several credit card transactions daily. The retailer downloaded a record of these transactions from the internet in an unorganized Excel file each day.

The first step of our project was to automate the downloading of this file from the web, and then to organize the data into columns including date, transaction number, amount, and type of card used. The retailer periodically received a bank statement listing all of the transactions during the period. The major challenge facing the retailer was that they had no way to verify that each credit card transaction appearing on the daily transaction list appeared on the bank statement. The retailer had to go through the bank statement and cross reference the daily transaction lists to ensure that each credit card had actually been charged. The second step of our project was to automate this process. All transactions appearing on the bank statement are highlighted.

The last step of our project was to create a user form for the retailer to compare data from month to month. The user form asks the user to select a chart and choose which months to display on the graph.

http://files.gove.net/shares/files/11w/tupac/Project_Write_up.pdf

http://files.gove.net/shares/files/11w/tupac/VBA_Project.xlsm