CASE STUDY

A department within a firm wanted to be able to track subscribed services to the users and group this data by the cost codes in their department.  As they received invoices for the various subscriptions, they would send this summary to accounting so they could spread the invoice costs to all of the correct cost codes instead of absorbing all of the costs themselves.

CHALLENGES

  • Multiple data subscriptions across multiple cost codes

  • Multiple contracts for subscriptions

  • Current invoices paid in full by one cost code

  • Specific requirements from the Accounting Department

SOLUTION

  • Built a database with all the department cost codes and users in each cost code.

  • Included vendors and all vendor subscriptions in the database.

  • Assigned user to their subscriptions

  • Generated required report for Accounting.

FOLLOW UP

Once we created the required report for accounting, we were then asked to add features to the database so the department could track contract terms and know when to begin renewal negotiations.  We were then asked to expand the database so it included all of the department users globally.  We were then asked to work with each of the department locations to consolidate the contracts into one global contract.  The company merged and we were then asked to create cash-flow reports for the VP of Finance.

Related posts:

Paperless Office Environment Data Entry CRM Customization Trade Show Visitors Workflow Support Website Design E-mail Management Trade Show Support Search Engine Optimization Branding Kit