๐Ÿ“Š Reports & Financials

Supervisor Reports

Table of Contents for Reports

  1. Track All Money Receipts

    • Overview of financial transactions and receipts
    • How to use for reconciliation and daily financial management
    • Training Video: click here
    • In-Depth KnowledgeBase Article: click here
  2. Track All Product Memos

    • Summary of product-related updates and communications
    • Usage for inventory coordination and operational alignment
    • In-Depth KnowledgeBase Article: click here
  3. View Items Sold by Salesperson

    • Breakdown of items sold per salesperson
    • Usage for performance analysis and inventory monitoring
    • In-Depth KnowledgeBase Article: click here
  4. Advertising Report - Overview Advertising Reports

    • Summary and analysis of advertising campaigns
    • Usage for performance evaluation and strategic planning
  5. View Commission-Spiff Report

    • Detailed tracking of commissions and spiff payouts
    • Usage for sales performance analysis and team motivation
    • In-Depth KnowledgeBase Article: click here
  6. Inventory Adjustment Reports - View All Inventory Adjustments

    • Comprehensive log of inventory changes
    • Usage for audits, stock management, and planning
    • In-Depth KnowledgeBase Article: click here
  7. Inventory Adjustment Report - View Shrinkage Only

    • Focused report on inventory shrinkage
    • Usage for loss analysis and operational improvement
  8. Additional Fee Report

    • Overview of supplementary transaction fees with interactive details
    • Usage for revenue tracking and customer dispute resolution
    • In-Depth KnowledgeBase Article: click here
  9. Layaway Service Charge Report

    • Tracking of service charges for layaway transactions
    • Usage for revenue insights and customer service
  10. Report of Edited Sales

    • Log of edited sales transactions
    • Usage for accountability and customer issue resolution
    • In-Depth KnowledgeBase Article: click here

Track All Money Receipts

The report, "Track All Money Receipts" focuses on managing and recording financial transactions, specifically receipts, to ensure accurate bookkeeping. Hereโ€™s an overview and usage guide:

Description:

This report tracks all money receipts for a specified time frame, providing a detailed record of all income-related transactions. It includes information such as:

  • Receipt numbers / Sale numbers
  • Transaction dates
  • Transaction Types (sale, refund, payment)
  • Payment methods (cash, credit, etc.)
  • Amounts received
  • Finance Company Direct Deposits / Checks
  • Integrated Payment Processing Transaction IDs
  • The user who recorded the transaction

How to Use It:

For Daily Close-Out:

  1. Reconciliation:

    • Match the report's totals against physical cash, checks, or electronic payment receipts.
    • Identify and resolve discrepancies promptly (e.g., missing receipts, incorrect amounts).
  2. Recordkeeping:

    • Save the report as part of the daily financial documentation.
    • Cross-reference it with other financial logs or systems for accuracy.
  3. Team Accountability:

    • Verify that all sales or transactions are accounted for by comparing this report with sales reports or invoices.
  4. Deposit Preparation:

    • Use the totals to prepare daily bank deposits or reconcile funds transferred electronically.

General Operations:

  • Audit Trails: This report can serve as a historical record for audits or financial reviews.
  • Performance Monitoring: Track patterns in daily or periodic revenue to analyze business performance.
  • Budgeting: Use the data to predict future cash flows and adjust budgets accordingly.

Pathway:

Management > Reports > Supervisor Reports > Track All Money Receipts

In-Depth KnowledgeBase Article: click here


Track All Product Memos

The "Track All Product Memos" report focuses on managing and organizing product-related memos.

Description:

This report serves as a centralized log for all product memos, offering detailed insights into product-related changes, communications, or actions. It includes:

  • Memo IDs or reference numbers
  • Dates of issuance
  • Descriptions or notes about the memo (e.g., changes in pricing, promotions, inventory updates)
  • Transaction Type (delivery, pickup, transfer, etc.)
  • The user who printed the memo / The user who confirmed the memo
  • Date the memo was confirmed
  • Sale # / Sale date

How to Use It:

For Daily Operations:

  1. Product Updates:

    • Review new or past memos to ensure all team members are aware of recent product transfers.
    • Communicate relevant updates to sales teams, inventory managers, or other stakeholders.
  2. Inventory Coordination:

    • Use the memos to adjust inventory levels, update stock information, or coordinate restocking needs.
  3. Customer Communication:

    • Reference memos to provide accurate information about product availability, pricing, or promotions to customers.
  4. End-of-Day Review:

    • Ensure all memos issued during the day are documented in the system.
    • Cross-check with product activity logs or sales data for consistency.

General Operations:

  • Audit Trail: Maintain an accessible record for product-related decisions or changes.
  • Performance Analysis: Analyze the frequency and nature of memos to identify trends (e.g., inventory issues or a breakdown in process).
  • Team Accountability: Track which team members or departments initiated changes and ensure follow-through on actions.

Pathway:

Management > Reports > Supervisor Reports > Track All Product Memos

In-Depth KnowledgeBase Article: click here


View Items Sold by Salesperson

The "View Items Sold by Salesperson" report focuses on tracking sales performance and providing insights into which items have been sold by individual sales representatives. Hereโ€™s a detailed description and usage guide:

Description:

This report offers a breakdown of items sold by each salesperson over a specific period. It includes:

  • Salesperson name
  • Items sold (SKUs)
  • Quantity of items sold
  • Sales totals (revenue generated)
  • Transaction dates
  • Customer details
  • Price of Items
  • Sale #

How to Use It:

  1. Performance Review:

    • Summarize daily sales for each salesperson to track performance and identify high-performing individuals or areas needing improvement.
  2. Inventory Adjustment:

    • Cross-reference items sold with inventory records to ensure accurate stock levels.
  3. Reconciliation:

    • Match the data with receipts or transaction logs to confirm all sales are recorded.
  4. End-of-Day Reporting:

    • Share the report with team leaders or management to provide an overview of daily sales activities.

For General Operations:

  • Incentive Programs:

    • Use the report to calculate commissions or bonuses based on individual sales performance.
  • Trend Analysis:

    • Identify which items are most popular and which salespeople are most effective at promoting specific products.
  • Training and Feedback:

    • Provide constructive feedback to sales staff by analyzing their sales patterns and suggesting areas for improvement.
  • Customer Insights:

    • Combine this report with customer data to understand purchasing trends and preferences.

Pathway:

Management > Reports > Supervisor Reports > View Items Sold by Salesperson

In-Depth KnowledgeBase Article: click here


Advertising Report - Overview Advertising Reports

The "Advertising Report - Overview Advertising Reports" focuses on summarizing and analyzing advertising activities. Hereโ€™s an overview and usage guidance:

Description:

This report provides a comprehensive view of advertising efforts, potentially detailing metrics such as:

  • Campaign names or IDs
  • Platforms used (e.g., Google Ads, Facebook Ads)
  • Budget allocation and spending
  • ROI or revenue generated from campaigns

How to Use It:

  • Campaign Performance Analysis:

    • Evaluate the effectiveness of each advertising campaign by comparing key metrics like click-through rates (CTR) or cost-per-click (CPC).
    • Identify high-performing campaigns to allocate more resources effectively.
  • Budget Management:

    • Monitor spending against the budget to ensure campaigns remain within financial limits.
    • Adjust budget allocations for underperforming or over-performing campaigns as needed.
  • Strategic Planning:

    • Use insights from past performance to refine strategies for future campaigns, such as targeting adjustments or creative redesigns.
  • Team Collaboration:

    • Share the report with marketing teams to align efforts and brainstorm improvements for ongoing or upcoming campaigns.

Pathway:

Management > Reports > Supervisor Reports > Advertising Report > Overview Advertising Reports



View Commissions/Spiff Reports

The "View Commission-Spiff Report" focuses on detailing commission and spiff (sales performance incentive funds) payouts. Hereโ€™s a description and usage guidance:

Description:

This report outlines commission and spiff earnings for salespeople, tracking their performance and associated payouts. It includes:

  • Salesperson names
  • Sale #
  • Total sales amounts
  • Commission rates and totals earned
  • Spiff bonuses for specific sales goals or products
  • Transaction or payout dates
  • Gross Margin

How to Use It:

  • Commission Calculation:

    • Verify accurate commission payouts by cross-referencing sales data and commission structures.
    • Ensure all qualifying transactions are accounted for in the report.
  • Sales Performance Analysis:

    • Identify top-performing salespeople based on earnings and sales contributions.
    • Evaluate which products or sales categories drive the highest spiff incentives.
  • Team Motivation:

    • Use the report to transparently communicate earnings and reward efforts, boosting morale and healthy competition.
  • Budget Planning:

    • Monitor total payouts for commissions and spiffs to manage overall labor costs and incentive budgets effectively.

Pathway:

Management > Reports > Supervisor Reports > View Commissions/Spiff Reports

In-Depth KnowledgeBase Article: click here


Inventory Adjustment Reports - View All Inventory Adjustments

The "Inventory Adjustment Reports - View All Inventory Adjustments" provides insights into changes made to inventory levels. Hereโ€™s an overview and usage guidance:

Description:

This report logs all inventory adjustments, tracking changes in stock levels due to reasons such as restocking, shrinkage, returns, or corrections. Key data points include:

  • Adjustment dates and times
  • Product names and SKUs
  • Quantity changes (additions or reductions)
  • Location
  • Responsible personnel
  • Asset Amount

How to Use It:

  • Stock Management:

    • Monitor real-time adjustments to maintain accurate inventory counts.
    • Identify trends in inventory discrepancies (e.g., frequent shrinkage or miscounts).
  • Operational Audits:

    • Use the report to investigate irregularities or large adjustments, ensuring accountability and accuracy.
  • Inventory Planning:

    • Review adjustment trends to refine restocking processes and forecast inventory needs.
  • Compliance and Reporting:

    • Maintain a clear record of adjustments for regulatory compliance or financial audits.

Pathway:

Management > Reports > Supervisor Reports > Inventory Adjustment Reports > View All Inventory Adjustments

In-Depth KnowledgeBase Article: click here


Inventory Adjustment Reports - View Shrinkage Only

The "Inventory Adjustment Report - View Shrinkage Only," focuses specifically on inventory shrinkage, detailing instances of lost or unaccounted-for stock. Hereโ€™s an overview and usage guidance:

Description:

This report isolates inventory adjustments related to shrinkage, providing a focused view of stock loss. Key elements include:

  • Product details (manufacturer, names, SKUs)
  • Shrinkage quantities
  • Dates and times of recorded shrinkage
  • Departments or personnel reporting the shrinkage

How to Use It:

  • Loss Analysis:

    • Review the report regularly to identify patterns or frequent shrinkage issues.
    • Pinpoint specific products, times, or areas with higher loss rates.
  • Operational Improvement:

    • Use insights to strengthen inventory control processes, such as improved tracking, enhanced security, or staff training.
  • Accountability:

    • Track shrinkage reports back to responsible departments or individuals to ensure accuracy and accountability.
  • Financial Reporting:

    • Integrate shrinkage data into overall financial reporting to account for inventory loss in profit margins or cost analyses.

Pathway:

Management > Reports > Supervisor Reports > Inventory Adjustment Reports > View Shrinkage Only



Additional Fee Report

The "Additional Fee Report" provides a breakdown of supplementary charges applied to transactions, with drill-down functionality to view detailed data when interacting with totals on the right-hand side. Here's an updated overview and usage guidance based on this additional detail:

Description:

This report not only summarizes additional fees but also offers interactive features to explore detailed transaction-level data. Clicking on totals in the right-hand column reveals specific insights such as:

  • Transaction details (dates, sale #, or customer names)
  • Types of additional fees (e.g., service fees, delivery charges)
  • Breakdown of fees by transactions

How to Use It:

  • Drill-Down Analysis:

    • Click on totals to access granular transaction data for deeper insights into fee applications.
    • Use this data to identify trends or anomalies, such as inconsistencies in fee amounts or overcharges.
  • Operational Audits:

    • Review detailed fee data to ensure compliance with company policies and accuracy in charges.
    • Address potential customer disputes with a clear breakdown of fee-related information.
  • Revenue Breakdown:

    • Assess the contribution of different fee categories to the overall revenue.
    • Adjust pricing or service strategies based on the performance of specific fee types.
  • Customer Service:

    • Utilize detailed fee reports to provide transparent responses to customer queries or complaints.

Pathway:

Management > Reports > Supervisor Reports > Additional Fee Report

In-Depth KnowledgeBase Article: click here


Layaway Service Charge Report

The "Layaway Service Charge Report" focuses on tracking service charges associated with layaway transactions. Here's a description and guidance on its use:

Description:

This report documents service charges applied specifically to layaway transactions. It provides:

  • Sale #s
  • Customer names
  • Layaway service charge amounts
  • Dates of charges
  • Status of layaway transactions (e.g., total paid, balance due, service charge applied)

How to Use It:

  • Revenue Analysis:

    • Assess how much revenue is generated from layaway service charges.
    • Identify patterns, such as peak periods for layaway usage or common charge amounts.
  • Policy Compliance:

    • Ensure service charges align with stated company policies and customer agreements.
  • Customer Service:

    • Use the report to address customer queries or disputes regarding layaway service charges.
  • Operational Insights:

    • Track layaway transaction trends to evaluate the effectiveness and popularity of the layaway program.

Pathway:

Management > Reports > Supervisor Reports > Layaway Service Charge Report



Report of Edited Sales

The "Report of Edited Sales" focuses on documenting changes made to sales transactions, providing transparency and accountability for adjustments. Hereโ€™s a detailed overview and usage guidance:

Description:

This report tracks sales transactions that have been edited after their initial completion. It includes:

  • Date and time of edits made
  • Login Location
  • The user who made the changes
  • Edits that were made (e.g., Location, Payment Type, Deposit Amount, Previously Paid Amount, Adjustment, Additional Charges, Items, Finance Company, and Salesperson)
  • Sale # and Customer Name

How to Use It:

  • Audit and Accountability:

    • Review the report regularly to monitor changes and ensure they are justified and documented appropriately.
    • Hold staff accountable for frequent or unexplained edits.
  • Customer Issue Resolution:

    • Reference the report to address customer inquiries or disputes regarding changes to transactions.
  • Policy Enforcement:

    • Ensure that all edits align with company policies and approval workflows.
  • Operational Insights:

    • Identify patterns in edited sales to spot potential training gaps, systemic issues, or fraud risks.

Pathway:

Management > Reports > Supervisor Reports > Report of Edited Sales

In-Depth KnowledgeBase Article: click here