Daily Report

Overview

The Daily Report is the most comprehensive business snapshot available in GSK POS. It provides a complete overview of your business performance for any selected date range, displaying all critical metrics in one professional, printable dashboard.

This report is ideal for:

• Daily business reviews - Track today's performance
• Period analysis - Compare week-over-week or month-over-month
• Management reporting - Share business KPIs with stakeholders
• Financial planning - Monitor profitability and cash flow

Accessing the Daily Report

**From the Dashboard:**

1. Click "Reports" in the main navigation menu
2. Select "Daily Report" from the reports menu
1. The report loads with today's date by default

**From the Sidebar:**

Navigate to: Reports → Daily Report

Report Interface

**Filter Controls**

At the top of the report, you'll find the filter area:

Date From: Select the start date for your report

Date To: Select the end date for your report

Load Button: Apply the selected date range

Print Button: Print the report (hides filters, shows clean printable version)

Default Behavior:

• On first load, the report shows today's data (From: today, To: today)
• You can select any custom date range

Understanding the Report Sections

The Daily Report contains 10 major sections that provide a complete business overview:

1. Key Performance Indicators (KPIs)

This section displays 9 essential metrics in card format:

**Stock Value Metrics**

📦 Opening Stock Value

• The total value of inventory at the start of the selected period
• Calculated using: `Closing Stock Value + (Cost of Sales + Downward Adjustments) - Purchases`

📦 Closing Stock Value

• The total value of inventory at the end of the selected period
• Reflects your current stock worth based on buying prices

**Sales Metrics**

💰 Total Sales (Revenue)

• Total revenue from all sales (cash + credit) during the period
• This is the selling price total, not profit

💵 Cash Sales

• Revenue from sales paid immediately in cash
• Includes all instant payment methods (cash, mobile money, cards, bank)

💳 Credit Sales

• Revenue from sales made on credit
• Customer will pay later (tracked in customer accounts)

**Purchase Metrics**

🛒 Total Purchases (Cost)

• Total cost of all stock purchased during the period
• Represents money spent to acquire inventory

**Expense & Profit Metrics**

💸 Expenditures

• Total business expenses recorded during the period
• Includes utilities, salaries, rent, transport, etc.

📊 Profit (Markup)

• Gross profit from sales before expenses
• Calculated as: `(Selling Price - Buying Price) × Quantity Sold`
• Green if positive, Red if negative

🏦 Net Profit

• Final profit after deducting all expenses
• Calculated as: `Profit (Markup) - Expenditures`
• Green if positive, Red if negative
• This is your actual take-home profit

2. Deposits

This section tracks money received and paid:

👥 Customer Deposits

• Total payments received from customers on their credit sales
• Money coming INTO your business

🚚 Deposits to Suppliers

• Total payments made to suppliers on credit purchases
• Money going OUT of your business

3. Transactions Removed (Undone)

❌ Total Removed

• Total value of sales transactions that were removed/undone during the period
• Helps track reversed sales (e.g., returns, errors, cancellations)

4. Outstanding Balances

This section shows your credit position at the start and end of the period:

**Credit Sales (Customer Balances)**

Opening Balance

• Total amount customers owed you at the start of the period
• Customers who bought on credit and haven't fully paid

Closing Balance

• Total amount customers owe you at the end of the period
• If higher than opening: More credit sales or fewer payments received
• If lower than opening: More customer payments received

**Credit Purchases (Supplier Balances)**

Opening Balance

• Total amount you owed suppliers at the start of the period

Closing Balance

• Total amount you owe suppliers at the end of the period
• If higher than opening: More credit purchases or fewer payments made
• If lower than opening: More supplier payments made

5. Business Performance

This section provides growth and trend analysis:

**🚀 Business Growth Rate**

• Compares current period sales to the previous month
• Shows percentage growth or decline
• Green for positive growth
• Red for negative growth
• N/A if no previous data available

Example:

• This month sales: 5,000,000 UGX
• Last month sales: 4,000,000 UGX
• Growth Rate: +25% ✅

**Sales Drop Detection**

• Compares current period to the same period last year
• Alerts you to significant drops (e.g., over 20% decline)
• Red flag 🚩 if sales dropped significantly
• Green checkmark ✅ if no significant drop

6. Top 10 Products Sold

🔥 Top 10 Products Sold

A table showing your best-selling products during the period:

How to Use:

• Identify your star products
• Plan stock reorders for fast movers
• Focus marketing on top sellers
• Ensure stock availability for these items

Column	Description
Product	Product name
Total Qty Sold	Total quantity sold in multi-unit format (e.g., "2 Boxes / 5 Pcs")

7. Weekly Product Sales Trends

📌 Weekly Product Sales Trends

Compares last week vs this week for your top 10 products:

Trend Indicators:

• ▲ +15.5% (Green) - Sales increasing
• ▼ -10.2% (Red) - Sales declining
• — 0% (Gray) - No change

How to Use:

• Spot declining trends early
• Investigate why sales are dropping
• Capitalize on increasing trends
• Adjust inventory levels accordingly

Column	Description
#	Ranking
Product	Product name
Last Week Qty	Quantity sold last week
This Week Qty	Quantity sold this week
Trend	Percentage change with visual indicator

Common Use Cases

**Daily Morning Review**

Goal: Check yesterday's performance

Steps:

1. Open Daily Report
2. Set From: Yesterday, To: Yesterday
1. Click Load
2. Review:
• Total sales vs target
• Cash collected (cash sales + deposits)
• Net profit after expenses
• Top products sold

**Weekly Business Meeting**

Goal: Review the past week's performance

Steps:

1. Open Daily Report
2. Set date range for the past 7 days
1. Click Load
2. Print the report
1. Discuss:
• Sales growth rate
• Product trends
• Outstanding balances
• Net profitability

**Monthly Financial Review**

Goal: Analyze the entire month

Steps:

1. Open Daily Report
2. Set From: 1st of the month, To: Last day of the month
1. Click Load
2. Focus on:
• Total revenue (cash + credit)
• Total expenses
• Net profit margin
• Change in outstanding balances
• Business growth rate vs last month

Printing the Report

**How to Print:**

1. Set your desired date range
2. Click Load to generate the report
1. Click the Print button
2. The filter area automatically hides
1. Your browser's print dialog opens
2. Adjust print settings as needed
1. Print or save as PDF

**Print Optimization:**

The report is optimized for printing:

• ✅ Clean, professional layout
• ✅ No unnecessary colors (prints well in black & white)
• ✅ Proper page breaks
• ✅ Business name and period displayed at top
• ✅ All data clearly formatted

Reading the Numbers

**Understanding Colors**

Green Values:

• Positive profit
• Sales growth
• Favorable trends

Red Values:

• Losses or negative profit
• Sales decline
• Unfavorable trends

Black/Gray Values:

• Neutral metrics (neither good nor bad)
• Factual data (stock values, sales amounts)

Best Practices

**Daily Habits**

• ✅ Review every morning
• Check yesterday's sales and profit
• Monitor cash position (cash sales + deposits)
• Track outstanding balances
• ✅ Compare periods
• Don't just look at one day in isolation
• Compare week-over-week
• Compare month-over-month
• ✅ Act on trends
• If sales are dropping, investigate why
• If a product trend is down, check stock levels
• If expenses are high, identify areas to cut

**Weekly Habits**

• ✅ Run a 7-day report
• Assess weekly performance
• Share with managers/partners
• Review product trends
• ✅ Monitor outstanding balances
• Are customers paying on time?
• Do you need to chase payments?
• Are supplier balances manageable?

**Monthly Habits**

• ✅ Generate full month report
• Calculate net profit margin: `(Net Profit / Total Sales) × 100`
• Compare to previous months
• Plan next month's targets
• ✅ Review top products
• Ensure adequate stock for best sellers
• Consider discounting slow movers

Troubleshooting

**Issue: Report shows zero values**

Possible Causes:

• No transactions recorded for the selected period
• Date range is incorrect

Solution:

• Verify the date range is correct
• Check if sales were recorded on those dates
• Try expanding the date range

**Issue: Stock values seem incorrect**

Possible Causes:

• Stock adjustments not recorded
• Buying prices not updated

Solution:

• Run a Stock Adjustment Report to verify
• Check product buying prices in Stock Management
• Contact support if values still don't match

**Issue: Profit is negative**

Meaning:

• Your selling prices were lower than buying prices, OR
• Your expenses exceeded your profit margin

Solution:

• Review product pricing
• Check if expenses are too high for the period
• Analyze which products are selling at a loss

**Issue: Growth rate shows N/A**

Meaning:

• No sales data from the comparison period (previous month)

Solution:

• This is normal if you just started using the system
• Growth rate will appear once you have historical data

Tips for Success

💡 Set Sales Targets

• Use the Daily Report to track progress toward daily/weekly/monthly sales goals

💡 Monitor Cash Flow

• Focus on: Cash Sales + Customer Deposits - Supplier Deposits - Expenditures
• This shows your actual cash position

💡 Track Net Profit Margin

• Calculate: `(Net Profit / Total Sales) × 100`
• Healthy businesses maintain 15-30% net profit margins

💡 Use Trends to Forecast

• Weekly trends help predict future sales
• Plan stock purchases based on trends
• Adjust staffing based on busy periods

💡 Print and File Reports

• Keep monthly reports for tax purposes
• Share with accountants or business advisors
• Use for loan applications or investor reports

Summary

The Daily Report is your business command center. It combines:

• Financial metrics (sales, profit, expenses)
• Stock management (opening/closing values)
• Cash flow (deposits, payments)
• Performance trends (growth, product sales)
• Actionable insights (top products, trends)

Make it a habit to review this report regularly. The businesses that monitor their numbers daily are the ones that grow fastest and stay profitable.

What's Next?

Now that you understand the Daily Report, explore:

• Sales & Purchase Reports - Detailed transaction-by-transaction records
• Stock Reports - Inventory movement and adjustments
• Staff Reports - User performance tracking

Continue to: [Section 3.2: Sales & Purchase Reports →](2-sales-purchase-reports.html)

Next: Sales & Purchase Reports

Learn how to generate detailed and summary reports for all your sales and purchase transactions.

Next: Sales & Purchase Reports →

Next: Purchases & Stock In

Learn how to record purchases from suppliers and increase your stock levels.

Next: Purchases & Stock In →