Daily Sales Register & Payment

Daily Sales Register & Payment Reconciliation Report in Microsoft Excel | July 2026

I created a professional Daily Sales Register and Payment Reconciliation Report for July 2026 using Microsoft Excel. The project organizes daily sales, bank receipts, cash receipts, and total payments received into a structured accounting report.

Key tasks completed:

Prepared a daily sales register for 31 days.

Organized sales, bank, cash, and payment received records.

Calculated daily outstanding balances using Sales Amount minus Payment Received.

Reconciled monthly totals and identified discrepancies.

Created a monthly financial summary for easier review.

Used Excel formulas to improve calculation accuracy and reporting efficiency.

Skills demonstrated: Microsoft Excel, Data Entry, Bookkeeping, Sales Reporting, Payment Reconciliation, Financial Reporting, and Accounting.

This project demonstrates my ability to maintain organized financial records, verify transaction totals, and prepare clear accounting reports for businesses.**