[Eril-l] How to track cancelled subscriptions?

[Moorthy, Anuradha]

1.      How do you save the information of cancelled subscriptions?  In a spreadsheet or in a different format?

a.       Excel  and Access

2.      What type of information do you keep for each cancelled subscription?  Cost? Year subscription was cancelled? Other types of information?
When I worked in a large health sciences research organization, we kept the cancellations in an excel file for each year and then downloaded to Access every year.
Excel file contained
Journal Title
Publisher
ISSN (Print and Electronic)
Cost
Use
Cost/Use
Years subscribed
Perpetual Access Period (additional column if there was a break in service)
Core Subject Association (Y/N) – track the percentage of cuts in each core subject

Anu Moorthy


From: Eril-l [mailto:eril-l-bounces at lists.eril-l.org] On Behalf Of Elizabeth Henry
Sent: Tuesday, October 27, 2015 2:27 PM
To: eril-l at lists.eril-l.org
Subject: [Eril-l] How to track cancelled subscriptions?

Hello collective wisdom,
I'm trying to figure out the best way to track all of the cancelled subscriptions outside of an ERM.  Currently, I have all of the subscriptions in Serials Solutions, both active and cancelled.  However, we've cancelled a fair number of subscriptions due to budget cutbacks and as a result, Serials Solutions is becoming cluttered with cancelled subscriptions alongside with the active subscriptions.
I'd like to extract all of the cancelled subscriptions from Serials Solutions and save them somehow, so the Library can refer back to the cancelled subscriptions and see why this particular subscription was cancelled and when (trying to avoid institutional memory, which is not so reliable).
I'm curious about the following:
1. How do you save the information of cancelled subscriptions?  In a spreadsheet or in a different format?
2. What type of information do you keep for each cancelled subscription?  Cost? Year subscription was cancelled? Other types of information?
Any additional information will be appreciated.
Thanks for your time and input.
Sincerely,
Elizabeth Henry

--
[http://www.gallaudet.edu/images/president/logo_email_icon.jpg]

Elizabeth Henry
Instruction and Reference/E-Resources Librarian
Gallaudet University Library
Merrill Learning Center, room 1302
800 Florida Ave, NE
Washington, D.C. 20002
202-250-2855
elizabeth.henry at gallaudet.edu<mailto:elizabeth.henry at gallaudet.edu>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20151027/b8e0778a/attachment-0001.html>