Project Details

  • Home
  • Project Details

Bookshop Data Entry Assistant for Sales Transactions and Daily Cash Logs

Posted 1 month 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

We are seeking a freelancer to help compile a vendor registration database. This includes vendor nam...
Posted 3 months ago   |   Survey Data Entry
Budget: KShs. 1,000   |   Client: Linda Bilmes
Assistance Needed: Interpreting Virtual Lab Results
Posted 2 months ago   |   Chemistry exams
Budget: KShs. 600   |   Client: Rebecca Henderson
Biology Exam Support
Posted 2 weeks ago   |   Chemistry exams
Budget: KShs. 700   |   Client: Prof. Michael Sandel