1. Navigate to “Tax Report” #

1. Log in to your restaurant management system.
2. In the sidebar, click Reports.
3. Under Reports, select Tax Report.
4. The Tax Report page will open showing:
   • A “Tax Report” header with subtitle “Tax details for the selected date range”.
   • A ▼ Filters section with filtering options.
   • An “Overall (Input – Output – Expense)” summary with information icon.
   • A calculation display showing: “Output Tax – Input Tax – Expense Tax: 0 AED”.
   • Four tab buttons for different tax views:
     • Input Tax – Tax on purchases
     • Output Tax – Tax on sales
     • Expense Tax – Tax on expenses
     • Output Tax (Project Invoice) – Tax on project invoices
   • Export buttons for CSV, Excel, Print, Column Visibility, and PDF.
   • A PRINT button (purple) in the top right corner.
   • A data table with columns: Date, Reference No, Supplier, Tax Number, Total amount, Payment Method, Discount, VAT.

2. Understanding the Tax Report #

The Tax Report is a critical financial tool for managing tax compliance and reporting:

• Tax Compliance – Track all tax collected and paid for regulatory reporting.
• VAT Management – Monitor Value Added Tax (VAT) on all transactions.
• Input Tax Tracking – Track tax paid on purchases (tax you can claim back).
• Output Tax Tracking – Track tax collected on sales (tax you owe authorities).
• Expense Tax Monitoring – Track tax on business expenses.
• Net Tax Calculation – Calculate net tax liability or refund due.
• Audit Trail – Maintain complete records for tax audits and compliance.

3. Understanding the Overall Tax Summary #

The summary calculation at the top shows your net tax position:

• Formula Explanation:
  • Positive Result: You owe tax to authorities (Output > Input + Expense).
  • Negative Result: You are due a tax refund (Input + Expense > Output).
  • Zero Result: Tax collected equals tax paid (balanced position).

4. Configure Tax Report Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameters:
   • Business Location – Select reporting scope:
     • Choose “All locations” for consolidated tax view across all branches.
     • Select specific location for location-based tax analysis.
     • Essential for multi-location tax compliance.
   • Contact – Filter by customer or supplier:
     • Select “All” to view all contacts.
     • Choose specific contact to analyze tax for that relationship.
     • Useful for verifying tax calculations with specific parties.
   • Date Range – Set tax reporting period:
     • Format: DD/MM/YYYY – DD/MM/YYYY (e.g., 02/07/2026 – 09/07/2026).
     • Select start and end dates for tax period.
     • Align with tax filing periods (monthly, quarterly, annually).
3. Apply filters to generate customized tax report.

5. Understanding the Four Tax Tabs #

The report provides four distinct views for comprehensive tax analysis:

• Navigation:
  • Click any tab to switch between different tax views.
  • Each tab displays relevant transactions for that tax type.
  • Table columns adjust based on selected tab.

6. Input Tax Tab Analysis #

The Input Tax tab shows tax paid on purchases that you can claim back:

• What is Input Tax?
  • VAT paid to suppliers when purchasing goods or services.
  • Represents tax you can reclaim from tax authorities.
  • Reduces your overall tax liability.
• Key Columns:
  • Date – When the purchase was made.
  • Reference No – Purchase order or invoice number.
  • Supplier – Vendor who charged the tax.
  • Tax Number – Supplier’s tax registration number.
  • Total amount – Total purchase amount including tax.
  • Payment Method – How payment was made.
  • Discount – Any discounts applied.
  • VAT – Amount of tax paid.
• Analysis Tips:
  • Verify all supplier tax numbers are valid.
  • Ensure proper documentation for all input tax claims.
  • Calculate total input tax for the period.
  • Identify largest sources of input tax.

7. Output Tax Tab Analysis #

The Output Tax tab shows tax collected on sales that you must remit:

• What is Output Tax?
  • VAT collected from customers when selling goods or services.
  • Represents tax you owe to tax authorities.
  • Must be remitted according to tax filing schedule.
• Key Columns:
  • Date – When the sale was made.
  • Reference No – Sales invoice or receipt number.
  • Customer – Who paid the tax (instead of Supplier).
  • Tax Number – Customer’s tax registration (if applicable).
  • Total amount – Total sale amount including tax.
  • Payment Method – How customer paid.
  • Discount – Any discounts given.
  • VAT – Amount of tax collected.
• Analysis Tips:
  • Verify all output tax is properly recorded.
  • Ensure tax rates are correctly applied.
  • Calculate total output tax for the period.
  • Reconcile with sales reports.

8. Expense Tax Tab Analysis #

The Expense Tax tab shows tax paid on business expenses:

• What is Expense Tax?
  • VAT paid on business operating expenses.
  • Separate from purchase tax (input tax).
  • Can also be claimed back from tax authorities.
  • Examples: utilities, rent, office supplies, services.
• Common Expense Categories:
  • Rent and property expenses.
  • Utilities (electricity, water, gas).
  • Professional services (accounting, legal).
  • Marketing and advertising.
  • Equipment and maintenance.
  • Insurance and licenses.
• Analysis Tips:
  • Ensure all business expenses are properly categorized.
  • Verify expense tax is claimable (some expenses may be exempt).
  • Maintain proper documentation for expense claims.
  • Calculate total expense tax for the period.

9. Output Tax (Project Invoice) Tab #

This specialized tab tracks tax on project-based invoicing:

• What are Project Invoices?
  • Invoices for specific projects or contracts.
  • Often used for catering, events, or special services.
  • May have different tax treatment than regular sales.
  • Separate tracking for project-based revenue.
• When to Use:
  • Catering services for events.
  • Corporate contracts and agreements.
  • Special event management.
  • Long-term service contracts.
• Analysis Benefits:
  • Separate project tax from regular sales tax.
  • Track tax on large contracts separately.
  • Ensure proper tax treatment for project work.
  • Simplify project-based tax reporting.

10. Calculating Net Tax Liability #

Use the report to calculate your tax obligation or refund:

1. Step 1: Calculate Total Output Tax:
   • Go to Output Tax tab.
   • Sum all VAT amounts for the period.
   • Add Output Tax (Project Invoice) if applicable.
   • This is total tax collected from customers.
2. Step 2: Calculate Total Input Tax:
   • Go to Input Tax tab.
   • Sum all VAT amounts for the period.
   • This is total tax paid to suppliers.
3. Step 3: Calculate Total Expense Tax:
   • Go to Expense Tax tab.
   • Sum all VAT amounts for the period.
   • This is total tax paid on expenses.
4. Step 4: Calculate Net Tax:
   • Formula: Output Tax – Input Tax – Expense Tax = Net Tax.
   • Positive result: You owe this amount to tax authorities.
   • Negative result: You are due this amount as refund.
   • The system displays this automatically in the summary.

11. Export and Documentation for Tax Filing #

Proper documentation is essential for tax compliance:

• Tax Filing Best Practices:
  • Export reports for each tax period (monthly, quarterly).
  • Maintain organized records by tax period.
  • Keep both digital and physical copies.
  • Archive reports for required retention period (typically 5-7 years).
  • Include supporting documentation (invoices, receipts).
• PRINT Button:
  • Purple PRINT button in top right generates comprehensive report.
  • Includes all tabs and summary information.
  • Suitable for official tax filing submissions.

12. Tax Compliance and Audit Preparation #

Use the Tax Report to maintain compliance and prepare for audits:

• Regular Reconciliation:
  • Reconcile tax report with accounting records monthly.
  • Verify all transactions are properly recorded.
  • Ensure tax rates are correctly applied.
  • Check for missing or duplicate entries.
• Audit Trail Maintenance:
  • Maintain complete records of all taxable transactions.
  • Keep supporting documentation (invoices, receipts, contracts).
  • Document any adjustments or corrections.
  • Ensure tax numbers are valid and current.
• Compliance Checks:
  • Verify all suppliers have valid tax registration numbers.
  • Ensure tax is charged on all applicable sales.
  • Confirm tax rates match current regulations.
  • Check for exempt or zero-rated transactions.
• Audit Preparation:
  • Export comprehensive reports for audit period.
  • Organize supporting documentation by transaction.
  • Prepare explanations for unusual transactions.
  • Review and correct any discrepancies before audit.

13. Best Practices for Tax Management #

• Regular Monitoring – Review tax report weekly to catch errors early.
• Timely Recording – Enter all transactions promptly to ensure accurate tax tracking.
• Proper Classification – Correctly categorize transactions as purchases, sales, or expenses.
• Tax Rate Accuracy – Ensure correct tax rates are applied to all transactions.
• Documentation – Maintain complete supporting documentation for all tax transactions.
• Supplier Verification – Verify supplier tax registration numbers before claiming input tax.
• Periodic Reconciliation – Reconcile tax report with accounting records regularly.
• Filing Deadlines – Track and meet all tax filing deadlines to avoid penalties.
• Professional Advice – Consult tax professionals for complex situations.
• System Updates – Keep tax rates updated when regulations change.
• Staff Training – Train staff on proper tax recording procedures.
• Backup Records – Maintain secure backups of all tax records.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

Congratulations! You now have a comprehensive understanding of the Tax Report feature. This critical compliance tool enables you to:

• Track all tax collected and paid across your business
• Calculate net tax liability or refund due accurately
• Maintain separate records for input, output, and expense tax
• Prepare accurate tax returns and filings
• Ensure compliance with tax regulations
• Maintain complete audit trail for tax authorities
• Export comprehensive documentation for tax filing

Use this report regularly to maintain tax compliance and avoid penalties! 💰✅