Circulation Report

I don't have a program for my church library. I'm thinking I need to set up an excel sheet to keep track of circulation information.  Any suggestions for headings or information I need to keep on a monthly basis?

You need to be a member of Church Librarians Network to add comments!

Join Church Librarians Network

Email me when people reply –

Replies

  • Please send me your address and I'll send you an example via snail mail. 

    • Audrey Carr

      c/o Huron Baptist Church, 1285 Michigan Ave, Sarnia, Ontario, Canada N7S 4M6. Thanks so much. We are planning an open house for the 29th of January and are still looking for ideas. Got any?

      Thanks again.

      Audrey

      • Thanks for the address of the church.  I'll send items to you this week.  Regarding the open house; have some cookies and juice to entice the congregation to come in.  Have colorful displays and show off your best books also with some concordances and books pertaining to your denomination.  Good luck.

        • Good ideas. Thanks. I did think that we'd probably do drinks only to keep sticky fingers off the books, or perhaps a treat for on the way out of the library.

  • Well, I looked at a variety of things and decided simplest is best.  I have three pages, one for adult books, one for juvenile books, and one for easy books.

     

    Across the top of each page I have the following headings:
    DATE (I will post each month); TOTAL; 000's through 900's; BIOGRAPHY, FICTION. 

    Now all I need to do is post the totals for each category. that way, over time, I can see what materials are checked out most often. Once we set up our AV and periodicals collections, I'll add a page for each of them.

  • I have used MICROSOFT Excel for 20+ years and the spreadsheet feature is right on your computer at no cost.  When I was setting up the system, there were not software packages available for church libraries.  I have heard wonderful things about Concourse, ResourceMate and LibraryThing.  It is just a matter of taste.  I have column headings that are appropriate to the library.  If you wish to have me send you a sample, just e-mail me.  I do not use Dewey Decimal as the professional librarian that set up our library (before my time) used subject headings.  I would be happy to send this listing of categories as well.  Unless you want to do DD for every book, that's fine, but with a small/starter library, I don't feel it is necessary.  With some of the software options you need to use DD. 

     

    I also have a selection policy that I have developed to help PROTECT your library and yourself from

    individuals that feel that their donation / book Needs to be in the library.  It is at your discretion and the Pastors opinion as well. Good luck and please rely on this Network; you are not alone in your new library setup.

    • This sounds like what I am looking for. Would you mind sending me the excel headings?

      acarr11@cogeco.ca

      Thanks ever so much.

      Audrey

    • This reply was deleted.
      • Debbie, just looking at your message from 2015.  Did I send you the information you wanted?

      • Please send me your mailing address and I'll send you a copy via snail mail.  Church address would be safest.

This reply was deleted.