Automation of Accounts Receivable Processes

I designed my project to be used by the accounting department where I work. I work at Progress Mfg., a manufacturing company that produces trailer hitches. I deal with invoicing customers and any other issues related to billing customers. I currently use many spreadsheets as part of my job. I decided to add VBA to two spreadsheets to automate the process and make it much quicker. The first spreadsheet imports customer credit card transactions and prints a statement. I wrote code that did all my previous steps with one click. The other spreadsheet is used to classify no charge invoices to their correct accounts. My program references data in another reference spreadsheet. My code analyzes that data and automatically classifies a many invoices as possible to the correct account. For those invoices that cannot be classified automatically, I use a user form to display relevant information from the reference spreadsheet. The user can then easily look at the data and classify it with their own intuition. 


http://files.gove.net/shares/files/15f/dillyboy/CC_Auto_Close--Project.xlsm
http://files.gove.net/shares/files/15f/dillyboy/COGS_-_Pivot_Tables_project_Final.xlsm
http://files.gove.net/shares/files/15f/dillyboy/1c.csv
http://files.gove.net/shares/files/15f/dillyboy/vba_write_up.pdf