Project Description

Job Title:

Bookshop Data Entry Clerk for Sales Transactions and Daily Cash Logs

Objective:

Accurately record and maintain daily sales transactions and cash logs for the bookshop. Ensure all sales, payments, and refunds are entered into spreadsheets or accounting systems for financial tracking, reporting, and auditing purposes.

Scope of Work:

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

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

• Track refunds, returns, and discounts applied.

• Verify totals against daily cash collected and system reports.

• Flag inconsistencies, missing entries, or duplicate records for review.

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

Required Data Fields:

• Transaction ID / Reference Number

• Date of Transaction

• Book Title / ISBN / Product Code

• Quantity Sold

• Price per Unit

• Total Amount

• Payment Method (Cash / Card / Online)

• Discounts Applied

• Refund / Return Details (if any)

• Notes / Comments

Instructions:

• Deadline: Submit all deliverables by 5th September 2025.

• Material Source: All sales logs and receipts will be provided upon hire.

• Deliverables: Two documents must be submitted:

  1. The finalized Excel/Spreadsheet containing all recorded transactions.

  2. A Word report summarizing total sales, refunds, discounts, and any issues flagged.