1. Navigate to “Sell Payment Report” #

1. Log in to your restaurant management system.
2. In the sidebar, expand the Reports section.
3. Locate and click on Sell Payment Report.
4. The Sell Payment Report page will open showing:
   • A ▼ Filters section with multiple filter options.
   • Filter fields for:
     • Customer – Select specific customer (dropdown with person icon showing “All”).
     • Business Location – Select location (dropdown with location icon showing “All”).
     • Payment Method – Select payment type (dropdown with card icon showing “All”).
     • Customer Group – Select customer segment (dropdown with group icon showing “All”).
     • Date Range – Set date range (e.g., 02/07/2026 – 02/07/2026).
   • Export buttons: Export to CSV, Export to Excel, Print, Column Visibility, and Export to PDF.
   • A comprehensive data table with columns:
     • Reference No – Payment reference (e.g., SP2026/0808, SP2026/0700).
     • Paid on – Payment date and time (e.g., 01/29/2026 17:51).
     • Amount – Payment amount (e.g., AED 10.00, AED -2.00).
     • Customer – Customer name (e.g., walkin).
     • Customer Group – Customer category.
     • Payment Method – How payment was made (e.g., Cash, Cash (Change Return)).
     • Sales – Associated sales reference (e.g., 1222, 1215).
     • Action – View button for details.
   • A Total row showing sum (e.g., Total: AED 1,643.86).
   • Search functionality and pagination controls (Show 25 entries, page numbers 1-31, Previous/Next).
   • Status indicator: “Showing 1 to 25 of 765 entries”.

2. Understanding Sell Payment Report #

Sell Payment Report is a comprehensive payment tracking tool for monitoring all sales payment transactions:

• Payment Transaction Tracking – Monitor every payment received from customers.
• Cash Flow Management – Track actual cash and payment collection in real-time.
• Payment Method Analysis – Analyze distribution of payment methods (cash, card, online, etc.).
• Customer Payment Behavior – Understand how different customers and segments prefer to pay.
• Reconciliation Tool – Reconcile payments with sales and bank deposits.
• Change Tracking – Monitor change given to customers for accuracy.
• Audit Trail – Maintain complete records of all payment transactions for compliance.
• Revenue Verification – Verify that all sales are properly paid and recorded.

3. Configure Sell Payment Report Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameters:
   • Customer – Select specific customer:
     • Choose “All” to view payments from all customers.
     • Select specific customer name to view their payment history.
     • Useful for:
       • Tracking payments from specific customers.
       • Verifying customer payment patterns.
       • Investigating payment issues for individual customers.
   • Business Location – Select reporting scope:
     • Choose “All” to view payments across all locations.
     • Select specific location to analyze location-specific payments.
     • Useful for multi-location payment reconciliation and comparison.
   • Payment Method – Select payment type:
     • Choose “All” to view all payment methods.
     • Select specific method to analyze:
       • Cash – Cash payments.
       • Cash (Change Return) – Change given back to customers.
       • Card – Credit/debit card payments.
       • Online Payment – Digital payment gateway transactions.
       • Bank Transfer – Direct bank transfers.
       • Other custom methods – Gift cards, vouchers, etc.
   • Customer Group – Select customer segment:
     • Choose “All” to view all customer groups.
     • Select specific group (VIP, Regular, Corporate, etc.).
     • Analyze payment behavior by customer segment.
   • Date Range – Set the reporting period:
     • Enter start date in format: DD/MM/YYYY (e.g., 02/07/2026).
     • Enter end date in format: DD/MM/YYYY (e.g., 02/07/2026).
     • Common date ranges:
       • Today – Current day payments for daily reconciliation.
       • Yesterday – Previous day for daily closing.
       • This Week – Weekly payment analysis.
       • This Month – Monthly payment tracking.
       • Custom Range – Any specific period for analysis.
3. Apply filters to refresh the report data.
4. The table will update to show payments matching your selected criteria.

4. Understanding the Payment Report Table #

The Sell Payment Report table provides detailed information about each payment transaction:

5. Understanding Negative Amounts (Change Return) #

• Negative Payment Amounts:
  • Negative amounts (e.g., AED -2.00) represent change given back to customers.
  • Shown as “Cash (Change Return)” in Payment Method column.
  • Reduces net cash collected for the period.
• Change Calculation Example:
  • Customer order total: AED 8.00
  • Customer pays with: AED 10.00 cash
  • Change returned: AED 2.00
  • System records:
    • Payment received: +AED 10.00 (Cash)
    • Change given: -AED 2.00 (Cash – Change Return)
    • Net cash collected: AED 8.00
• Change Tracking Benefits:
  • Accurate cash reconciliation.
  • Verify correct change was given.
  • Identify potential cash handling errors.
  • Calculate actual cash in register.

6. Payment Reconciliation Process #

1. Daily Cash Reconciliation:
   • Filter by Payment Method = “Cash” for the day.
   • Note the Total at bottom of report.
   • This represents net cash collected (receipts minus change).
   • Compare with physical cash count in register.
   • Investigate any discrepancies.
2. Card Payment Reconciliation:
   • Filter by Payment Method = “Card” (or specific card types).
   • Note the Total card payments.
   • Compare with card terminal batch report.
   • Verify all card transactions are accounted for.
   • Ensure card payments match bank deposits.
3. Online Payment Verification:
   • Filter by Payment Method = “Online Payment”.
   • Compare with payment gateway reports.
   • Verify all online payments are captured.
   • Check for failed or pending transactions.
4. Total Revenue Verification:
   • Run report with “All” payment methods.
   • Note the Total at bottom (e.g., AED 1,643.86).
   • Compare with total sales for the same period.
   • Investigate any differences (unpaid orders, partial payments).

7. Payment Method Analysis #

• Payment Method Distribution:
  • Run separate reports for each payment method.
  • Calculate percentage of each method:
    • Cash %: (Cash Total ÷ All Payments Total) × 100
    • Card %: (Card Total ÷ All Payments Total) × 100
    • Online %: (Online Total ÷ All Payments Total) × 100
  • Track trends over time (monthly, quarterly).
• Cash vs. Cashless Trends:
  • Monitor shift from cash to digital payments.
  • Declining cash usage indicates digital adoption.
  • Adjust cash handling procedures based on trends.
  • Optimize payment method offerings.
• Payment Method Costs:
  • Calculate cost of each payment method:
    • Cash: Handling time, security, deposit fees.
    • Card: Processing fees (typically 2-3%).
    • Online: Gateway fees and transaction charges.
  • Balance convenience with cost efficiency.

8. Customer Payment Behavior Analysis #

• Individual Customer Analysis:
  • Filter by specific customer to view their payment history.
  • Identify preferred payment methods.
  • Track payment timing and patterns.
  • Verify payment reliability for credit decisions.
• Customer Group Analysis:
  • Filter by Customer Group to analyze segment behavior.
  • Compare payment preferences across groups:
    • VIP customers may prefer cards or accounts.
    • Walk-in customers typically use cash.
    • Corporate customers may use invoicing.
  • Tailor payment options to customer preferences.
• Walk-in vs. Regular Customers:
  • Compare payment patterns between customer types.
  • Walk-in customers (shown as “walkin”) typically pay immediately.
  • Regular customers may have credit terms or loyalty programs.

9. View Payment Details #

1. Click the View button (purple button) in the Action column for any payment.
2. The payment details page will show:
   • Payment Information:
     • Reference number and date/time.
     • Payment amount and method.
     • Customer details.
   • Associated Sale:
     • Sales order reference number.
     • Order details and items.
     • Total order amount.
   • Payment Breakdown:
     • If multiple payment methods used.
     • Split payment details.
     • Change calculation if applicable.
   • Additional Information:
     • User who processed payment.
     • Location where payment was made.
     • Any notes or comments.
3. Use payment details for:
   • Investigating discrepancies.
   • Verifying payment accuracy.
   • Customer service inquiries.
   • Audit and compliance documentation.

10. Export and Print Payment Report #

1. Export Options – Use the export buttons above the table:
   • Export to CSV – Comma-separated values format:
     • Opens in Excel, Google Sheets, or any spreadsheet application.
     • Ideal for detailed analysis and reconciliation.
     • Easy to create custom reports and calculations.
   • Export to Excel – Microsoft Excel format:
     • Preserves formatting and includes formulas.
     • Professional format for financial reporting.
     • Enables advanced Excel analysis (pivot tables, charts).
   • Export to PDF – Portable Document Format:
     • Professional format for audit documentation.
     • Suitable for archiving and compliance records.
     • Maintains consistent formatting for sharing.
   • Print – Direct browser printing:
     • Quick physical copy for daily reconciliation.
     • Use for manager review and approval.
     • Handy for filing and record keeping.
2. Column Visibility:
   • Click the Column Visibility button to customize displayed columns.
   • Show or hide specific columns based on your needs.
   • Simplify report for specific purposes (cash reconciliation vs. customer analysis).

11. Search and Pagination #

1. Search Functionality:
   • Use the Search box on the right side above the table.
   • Search by:
     • Reference number (e.g., “SP2026/0808”).
     • Customer name (e.g., “walkin”, “faisal”).
     • Sales reference (e.g., “1222”).
     • Amount values.
     • Payment method.
   • Search is real-time and filters results as you type.
   • Clear search to return to full list.
2. Pagination Controls:
   • Show entries – Select number of rows per page:
     • 25 entries (default) – Good for quick review.
     • 50 or 100 entries – Better for comprehensive analysis.
     • Adjust based on data volume (765 entries in example).
   • Page Numbers – Click specific page numbers (1-31 in example) to jump to that page.
   • Previous/Next – Navigate between pages using buttons.
   • View status: “Showing 1 to 25 of 765 entries” (updates based on data).
3. Column Sorting:
   • Click column headers to sort data.
   • Useful sorting options:
     • Sort by Paid on to view chronological order.
     • Sort by Amount to identify largest payments.
     • Sort by Customer to group by customer.
     • Sort by Payment Method to group by payment type.
   • Toggle between ascending and descending order.

12. Sell Payment Report Best Practices #

• Daily Reconciliation – Review and reconcile payments daily to identify discrepancies promptly.
• Multiple Payment Methods – Offer diverse payment options to meet customer preferences.
• Accurate Recording – Ensure all payments are recorded immediately and accurately in the system.
• Change Verification – Verify change amounts to prevent cash handling errors.
• Bank Reconciliation – Regularly reconcile payment report with bank statements and deposits.
• Fraud Prevention – Monitor for unusual payment patterns or suspicious transactions.
• Customer Service – Use payment history to resolve customer inquiries quickly.
• Audit Trail – Maintain complete payment records for compliance and auditing.
• Performance Tracking – Monitor payment method trends to optimize offerings.
• Staff Training – Train staff on proper payment processing and recording procedures.

13. Advanced Analysis Techniques #

• Time-Based Analysis:
  • Compare payment patterns across different times:
    • Peak hours vs. slow periods.
    • Weekday vs. weekend.
    • Month-over-month trends.
  • Optimize staffing and cash management based on patterns.
• Location Comparison:
  • Compare payment methods across different locations.
  • Identify location-specific payment preferences.
  • Optimize payment infrastructure by location.
• Customer Segmentation:
  • Analyze payment behavior by customer group.
  • Tailor payment options to segment preferences.
  • Develop targeted promotions based on payment patterns.
• Fraud Detection:
  • Monitor for unusual payment patterns.
  • Identify excessive refunds or voids.
  • Track payments from suspicious sources.
  • Implement alerts for high-risk transactions.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

You can now effectively track all payment transactions, reconcile cash and card payments, analyze payment method distribution, monitor customer payment behavior, prevent fraud, and maintain accurate financial records for your restaurant operations!