Library Data Entry Assistant for Late Returns and Fine Payment Records
Posted 1 month ago | Spreadsheet Entry | Budget: KShs. 800 | Bids: 5 | Client: Nancy Koehn
Objective:
Accurately input and update records of overdue library books, late return dates, and fine payments. Maintain a clear log to support accountability, financial tracking, and borrower management.
Scope of Work:
Collect overdue book logs and fine receipts from provided material.
Enter details of book titles, borrower information, and due dates into the spreadsheet or database.
Record late return dates and calculate applicable fines (if provided).
Track fine payments, pending dues, and cleared balances.
Flag missing, duplicate, or inconsistent records for review.
Prepare a Word report summarizing late returns, fines collected, and outstanding balances.
Required Data Fields:
Borrower Name / ID Number
Book Title / Accession Number
Date Borrowed
Due Date
Date Returned
Days Overdue
Fine Amount Incurred
Fine Payment Status (Paid / Pending / Waived)
Payment Date (if applicable)
Notes / Comments
Deliverables:
Completed Excel spreadsheet with updated late return and fine payment records.
Word report summarizing overdue items, fines collected, and flagged issues.
Additional Note:
Material source will be shared upon hire.
Deadline: August 31st, 2025