Project Details

  • Home
  • Project Details

Bookshop Data Entry Assistant for Sales Transactions and Daily Cash Logs

Posted 1 year ago   |   Spreadsheet Entry   |   Budget: KShs. 800   |   Bids: 8   |   Client: Michelle Williams

Project Overview

  • Published On: 30th Aug, 2025
  • Project Type: Data-Entry
  • Project Category: Spreadsheet Entry
  • Project Due: 1st September, 2025

Required Skills

  • Spreadsheet formulas and functions

  • Microsoft Excel and Word

  • Accurate copy-paste and data entry skills

  • Time Management

Project Description

Job Description

Main job is to accurately record and maintain daily sales transactions and cash logs for the bookshop. Work includes entering sales data, tracking payments, and ensuring financial records are organized and accurate.

Key Responsibilities

  • Enter daily sales transactions into spreadsheets or the POS/accounting system.

  • Record payment methods (cash, card, online) and amounts received.

  • Track refunds, returns, and discounts applied.

  • Verify totals against daily cash collected.

  • Flag inconsistencies, missing entries, or duplicate transactions.

  • Prepare a Word report summarizing total sales, cash collected, and flagged issues.

Data Fields Required

  1. Transaction ID / Reference Number

  2. Date of Transaction

  3. Book Title / ISBN / Product Code

  4. Quantity Sold

  5. Price per Unit

  6. Total Amount

  7. Payment Method (Cash / Card / Online)

  8. Discounts Applied

  9. Refund / Return Details (if any)

  10. Notes / Comments

Deliverables

  • Excel File with complete sales transactions and daily cash logs.

  • Word Report summarizing daily sales, cash totals, and flagged discrepancies.

Timeline

Deadline: September 1, 2025

Note

All source materials will be provided upon hire.

Related Projects

Economics Final Exam Guidance and Problem-Solving Helper
Posted 9 months ago   |   Quiz & MCQ help
Budget: KShs. 200   |   Client: Prof. Michael Sandel
The impact of technology on social relationships
Posted 11 months ago   |   Coursework
Budget: KShs. 300   |   Client: Rebecca Henderson
The Cold War and its impact on international relations
Posted 8 months ago   |   Coursework
Budget: KShs. 300   |   Client: Jeffrey _r._wilson