1. Navigate to “Purchase & Sale Report” #

1. Log in to your restaurant management system.
2. In the sidebar, click Reports.
3. Under Reports, select Purchase & Sale.
4. The Purchase & Sale Report page will open showing:
   • A “Purchase & Sale Report” header with subtitle “Purchase & sale details for the selected date range”.
   • A location filter dropdown showing “All locations” with blue icon.
   • A “Filter by date” button (purple) in the top right corner.
   • Two main sections side by side:
     • Purchases section (left) with metrics:
       • Total Purchase: AED 0.00
       • Purchase Including tax: AED 0.00
       • Total Purchase Return Including Tax: AED 0.00
       • Purchase Due: AED 0.00 (with info icon)
     • Sales section (right) with metrics:
       • Total Sale: AED 0.00
       • Sale Including tax: AED 0.00
       • Total Sell Return Including Tax: AED 0.00
       • Sale Due: AED 0.00 (with info icon)
   • An “Overall” calculation section showing:
     • “Overall ((Sale – Sell Return) – (Purchase – Purchase Return))” with info icon
     • “Sale – Purchase: AED 0.00”
     • “Due amount: AED 0.00”
   • A PRINT button (purple) in the bottom right corner.

2. Understanding Purchase & Sale Report #

The Purchase & Sale Report is a comprehensive business performance dashboard that provides a complete overview of your operations:

• Complete Business Overview – See both purchases and sales in one unified view.
• Profitability Analysis – Calculate gross profit by comparing sales to purchases.
• Tax Tracking – Monitor tax-inclusive amounts for both purchases and sales.
• Returns Management – Track returns on both purchase and sales sides.
• Outstanding Balances – Monitor amounts due from customers and to suppliers.
• Net Position Calculation – Understand overall business performance.
• Cash Flow Insights – Use due amounts for cash flow planning.

3. Understanding the Purchases Section #

The left section displays comprehensive purchase metrics:

• Net Purchase Calculation:
  • Net Purchase = Purchase Including tax – Total Purchase Return Including Tax.
  • This represents actual cost of goods after returns.
  • Used for accurate profitability calculations.

4. Understanding the Sales Section #

The right section displays comprehensive sales metrics:

• Net Sales Calculation:
  • Net Sales = Sale Including tax – Total Sell Return Including Tax.
  • This represents actual revenue after returns.
  • Used for accurate profitability and performance analysis.

5. Understanding the Overall Calculation #

The bottom section provides critical business performance metrics:

• Overall Formula Explanation:
  • Formula: (Sale – Sell Return) – (Purchase – Purchase Return).
  • This calculates gross profit for the period.
  • Positive result indicates profit.
  • Negative result indicates loss.
• Sale – Purchase Metric:
  • Shows: “Sale – Purchase: AED 0.00”.
  • Simplified gross profit calculation.
  • Quick indicator of business performance.
  • Does not account for returns in this simplified view.
• Due Amount:
  • Shows: “Due amount: AED 0.00”.
  • Net of Sale Due minus Purchase Due.
  • Positive: More money owed to you than you owe.
  • Negative: You owe more than is owed to you.
  • Important for cash flow management.

6. Configure Report Filters #

1. Location Filter:
   • Click the location dropdown (shows “All locations” by default).
   • Blue icon indicates filter is active.
   • Select specific location to view that branch’s performance.
   • Choose “All locations” for consolidated company-wide view.
2. Date Filter:
   • Click the “Filter by date” button (purple) in top right.
   • Date picker will open for selection.
   • Choose start and end dates for analysis period.
   • Common periods: daily, weekly, monthly, quarterly, yearly.
3. Filter Strategy:
   • Use daily filters for operational monitoring.
   • Use weekly filters for regular management reviews.
   • Use monthly filters for financial reporting.
   • Use quarterly/yearly filters for strategic planning.

7. Calculating Gross Profit #

Use the report to calculate and analyze gross profit:

1. Basic Gross Profit Calculation:
   • Formula: Total Sale – Total Purchase = Gross Profit.
   • This is the simplified calculation shown in “Sale – Purchase”.
   • Represents profit before operating expenses.
   • Does not account for returns.
2. Accurate Gross Profit (Including Returns):
   • Formula: (Sale – Sell Return) – (Purchase – Purchase Return).
   • This is shown in the “Overall” calculation.
   • More accurate as it accounts for returns.
   • Better indicator of true profitability.
3. Gross Profit Margin:
   • Formula: (Gross Profit ÷ Net Sales) × 100.
   • Calculate: (Sale – Purchase) ÷ Sale × 100.
   • Expressed as percentage.
   • Industry benchmark for restaurants: 60-70%.
4. Profitability Analysis:
   • Compare gross profit across different periods.
   • Track gross profit margin trends.
   • Identify periods of high or low profitability.
   • Investigate causes of margin changes.

8. Analyzing Returns Impact #

Monitor how returns affect your business performance:

• Purchase Returns Analysis:
  • Calculate return rate: (Purchase Return ÷ Total Purchase) × 100.
  • High return rates indicate supplier quality issues.
  • Returns reduce net purchase costs.
  • Track return trends to identify problematic suppliers.
• Sales Returns Analysis:
  • Calculate return rate: (Sell Return ÷ Total Sale) × 100.
  • High return rates indicate customer satisfaction issues.
  • Returns reduce net revenue.
  • Track return trends to identify quality problems.
• Financial Impact:
  • Returns directly reduce profitability.
  • High return rates increase operational costs.
  • Returns affect cash flow and working capital.
  • Target: Keep return rates below 2-3% of total transactions.
• Improvement Actions:
  • Address supplier quality issues causing purchase returns.
  • Improve product quality to reduce sales returns.
  • Enhance order accuracy to minimize returns.
  • Train staff on proper handling and preparation.

9. Managing Due Amounts and Cash Flow #

Use due amounts for effective cash flow management:

1. Purchase Due (Accounts Payable):
   • Represents money you owe to suppliers.
   • Monitor to ensure timely payments.
   • High purchase due may indicate cash flow issues.
   • Balance payment timing with cash availability.
2. Sale Due (Accounts Receivable):
   • Represents money customers owe you.
   • Monitor to ensure timely collections.
   • High sale due ties up working capital.
   • Implement collection strategies for overdue accounts.
3. Net Due Position:
   • Calculate: Sale Due – Purchase Due = Net Due.
   • Positive: You’re owed more than you owe (good for cash).
   • Negative: You owe more than you’re owed (cash pressure).
   • Monitor trends to anticipate cash flow needs.
4. Cash Flow Optimization:
   • Accelerate collections from customers.
   • Negotiate favorable payment terms with suppliers.
   • Balance payment timing to optimize cash position.
   • Use due amounts for accurate cash flow forecasting.

10. Multi-Location Performance Comparison #

For restaurant chains, compare performance across locations:

• All Locations View:
  • Select “All locations” for company-wide performance.
  • See consolidated purchases and sales.
  • Calculate overall company profitability.
  • Understand total business performance.
• Individual Location Analysis:
  • Select specific location to see branch performance.
  • Compare purchases and sales for that location.
  • Calculate location-specific profitability.
  • Identify high and low performing locations.
• Comparative Analysis:
  • Run report for each location separately.
  • Compare gross profit margins across locations.
  • Identify best practices from top performers.
  • Address issues at underperforming locations.
• Strategic Applications:
  • Allocate resources to high-performing locations.
  • Provide support to struggling locations.
  • Share successful strategies across locations.
  • Make informed decisions about expansion or closure.

11. Tax Analysis and Compliance #

Use tax-inclusive amounts for tax analysis:

• Purchase Tax Analysis:
  • Calculate tax: Purchase Including tax – Total Purchase.
  • This is input tax you can claim back.
  • Monitor to ensure proper tax recording.
  • Use for tax return preparation.
• Sales Tax Analysis:
  • Calculate tax: Sale Including tax – Total Sale.
  • This is output tax you must remit.
  • Monitor to ensure proper tax collection.
  • Use for tax filing and compliance.
• Net Tax Position:
  • Calculate: Sales Tax – Purchase Tax = Net Tax.
  • Positive: You owe tax to authorities.
  • Negative: You’re due a tax refund.
  • Cross-reference with Tax Report for accuracy.

12. Print and Documentation #

Use the PRINT function for documentation and reporting:

• Print Function:
  • Click the PRINT button (purple) in bottom right.
  • Generates comprehensive report with all metrics.
  • Suitable for management meetings and presentations.
  • Create physical copies for filing and records.
• Documentation Uses:
  • Monthly management reports.
  • Board presentations and investor updates.
  • Financial planning and budgeting.
  • Performance tracking and trend analysis.
  • Loan applications and financial statements.
• Best Practices:
  • Print reports at regular intervals (weekly, monthly).
  • Maintain organized files by period.
  • Compare current reports with historical data.
  • Archive reports for long-term reference.

13. Best Practices for Purchase & Sale Analysis #

• Regular Monitoring – Review report daily or weekly to stay informed about business performance.
• Trend Analysis – Compare current period with previous periods to identify trends.
• Profitability Focus – Monitor gross profit margin and take action if it declines.
• Returns Management – Keep return rates low through quality control and accuracy.
• Cash Flow Planning – Use due amounts for accurate cash flow forecasting.
• Location Comparison – Compare performance across locations to identify best practices.
• Tax Compliance – Verify tax amounts match tax reports for accuracy.
• Supplier Management – Monitor purchase patterns and optimize supplier relationships.
• Customer Credit – Manage sale due amounts to optimize working capital.
• Data Accuracy – Ensure all transactions are recorded promptly and correctly.
• Strategic Planning – Use insights for budgeting, forecasting, and strategic decisions.
• Performance Benchmarking – Compare metrics with industry standards and competitors.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

Congratulations! You now have a comprehensive understanding of the Purchase & Sale Report feature. This powerful business overview tool enables you to:

• Monitor complete business performance with purchases and sales in one view
• Calculate gross profit and profitability margins accurately
• Track returns and their impact on business performance
• Manage cash flow through due amount monitoring
• Analyze tax implications of business operations
• Compare performance across multiple locations
• Make informed strategic decisions based on comprehensive data

Use this report regularly to maintain business health and drive profitability! 📊💰