Store Sales Invoices Report

Report Business Value: The Store Sales Invoices Report help you see all the invoices on your outlet, whether the invoice was settled or still opened you can view the value of each invoice and the items sold with their quantities as well. Below are some of the benefits of running this report.

1. Shows the number of guests/covers served on each invoice.
2. Shows the waiter/cashier who was responsible for each invoice.
3. Shows if any discounts were applied on the invoices.
4. Shows the items breakdown of each invoice, quantity and value for each item sold.

How it works?

Reports → PS → Store Sales Invoices

1. Select the date range you would like to view the invoices within.
2. Choose whether to see all the invoices by selecting All or to view Settled only invoices or opened only invoices.
3. Choose whether to view the report including the House Use Invoices or no.
4. Choose a specific outlet to view the invoices for, if left blank the report will return all invoices from all outlets.
5. Choose the level of detail to show in the report whether Detailed or Simplified.

Detailed Vs Simplified: Simplified: when running the report in a simplified format the outcome would only show the invoices total without the breakdown of items sold on each invoice. Detailed: when running the report in a detailed format the outcome would show the invoices total alongside the breakdown of items sold on each invoice with its quantities and prices. Report Column Outcome: This report is grouped per outlet, so each outlet’s invoices will be grouped together. This report is grouped by the form of payment, so all Pay To Room invoices will be grouped together same goes for normal payments i.e. Cash/Credit Cards and House Use Payments.

• Invoice ID & Invoice Number: the first 2 columns return the unique identifiers of the invoice, no 2 invoices can have the same invoice ID or invoice numbers.
• Pax: returns the number of adults/covers served on each invoice entered from the waiter on any invoice.
• Date: returns the audit date any invoice was created on.
• Cashier: returns the cashier/waiter who worked last on the invoice.
• Discount: if applicable, this column returns the discount amount applied on an invoice.
• Gross Amount: returns the total amount of the invoice including taxes.
• Net Amount: returns the total amount of the invoice excluding taxes.

Sub Columns in case of detailed export: Under each invoice there will be 3 columns representing the invoice’s item breakdown:

• Item: returns the name of the item.
• Qty: returns the quantity of the item sold on the invoice.
• Price: returns the total price of the quantities sold for each item.

Update: 28th of August, 2022 A new report filter is added to help you extract the report based on the Service Type whether it is Dine-in or Takeout in order for you to get the totals for each service type separately. N.B: The default currency for this report would follow the base currency of your system, currency conversion would happen automatically if needed.