Generating Payment Reports

Chapter 1. Introduction

TouchBistro’s Payment Reports section allows you to generate reports about payments to your venue: total cash payments to your venue, payments to your venue from credit cards, and refunds paid out via cash or credit card. Unlike most reports, Payment Reports include taxes.

Chapter 2. Ensure Your iPad Email Account is Set Up

Many reports can only be viewed by emailing them to yourself as a CSV file. Before you start to generate reports, you should ensure you have an email account set up on your iPad(s). To set up an email account see this guide on the Apple site.

Chapter 3. Accessing Reports

To access a report login either as a manager profile or the admin profile. Best practices are not to use the admin login unless you need to access admin function to make permanent changes to your restaurant.

In this guide, we’ll assume you’re using a manager profile (or a profile that has Can Access Reports enabled).

1.  From your floor plan screen tap Options.

2.  Tap Reports.

3.  The Previous Business Days screen lets you quickly access individual business days (that is the block of time when you opened your venue via TouchBistro and when you closed it). Hence, a Business Day will not be 24 hours. If you opened your venue at TouchBistro at 9 am Tuesday and did your end of day and closed it Wednesday 3 am, TouchBistro will record that as a business day. In this example, we’re interested in a date range. We’ll generate a payments report for all staff for a week. Tap Cancel to set a date range.

4.  Use the date wheels at the top to set the start and end of the range. In this example, we’re setting the range from the very start of April 1 to the end of April 30. So, the whole month of April. TouchBistro treats 12:00 AM as the start of the day and 11:59 PM as the end of the day.

5.  Tap Payments to access reports associated with payments and refunds.

Chapter 4. Generating a Payments and Refund Totals Report

The Payments and Refund Totals Report will give you a breakdown of payment totals from cash and credit cards you accept. This report helps you understand how much money (sales, taxes, and tips) is coming into your venue. It will indicate how much of those card totals came from tips. Figures include taxes. Finally, if any refunds were issued, either in cash or a refund to a credit card, this report will indicate refund totals and refunded to which payment method.

1.  Add the Payments and Refund Totals Report to the Current Report column by tapping it.

2.  You can add in additional reports by tapping them. For example, tap Detailed Credit Card Payments Report.

3.  You can remove a report at any time by tapping the Delete icon next to the appropriate report and then tapping Delete.

4.  If you’ve created a report with multiple reports and you’ll need to re-generate the report at a later date, tap Save Template As. Use Load Template to access this saved report.

5.  In this example, we’ll only generate a Payments and Refund Totals Report.

6.  Tap Generate Report on the top right when you’re ready to view the report results.

7.  When you generate a report, TouchBistro gives you the following options at the top of the report:

Option	Description
	Tap CSV to email the report as a CSV (comma separated values) file. A CSV file can be opened in a spreadsheet.
	Tap Email to email the report as a formatted email.
	Tap Printer to print the report to a configured printer.

8.  If you choose to email your report, ensure you’ve setup an email account under your iPad’s Settings. TouchBistro uses your iPad’s existing email credentials for emailing.

Section 1. How is the Payments and Refund Totals Report Generated?

Payments

Any payment made via the standard TouchBistro credit card or cash payment dialog is recorded as a payment. If a card was used to pay a tip, TouchBistro will likewise record this information in the Payments report. TouchBistro does not keep track of cash tips.

1) Refunds

Refunds are issued in TouchBistro two ways:

Issuing a credit card return under the Orders menu using the Refund Sale option.

2) Integrated or Non-Integrated

If you have a mix of integrated payments and non-integrated payments, TouchBistro will highlight non-integrated payments.

Chapter 5. Adding Additional Reports

The Payments reports section provides three reports in total. In addition to the Payments and Refund Totals Report, you can add a Payment by Section, Detailed Credit Card Payment Report, and a Detailed Credit Card Refund Report.

Chapter 6. Payments by Section

The Payment by Section report breaks down sales by payment type and by section. Values are inclusive of tax. If auto grats are set to be treated like tips, they will be reported in the Tips field. If auto grats are set to be taxed or treated separately from tips, money collected via auto grats will be included in the Amount field.

Section 1. How is a Sales by Section Report Generated?

1) Sections

Sections were set under Admin | Admin Settings | Floorplan | Sections. Bills record section and floor details.

Chapter 7. Detailed Credit Card Payment Report

As we’ve seen the Payments and Refund Totals Report gives you totals of payments made via credit card and cash. The Detailed Credit Card Payment Report reports each individual credit card payment, including date/time the card was used, the order number it was used for, the authorization number, and the amount paid and any tip included on the card. Values are inclusive of tax. If auto grats are set to be treated like tips, they will be reported in the Tips field. If auto grats are set to be taxed or treated separately from tips, money collected via auto grats will be included in the Subtotal field.

Section 1. How is the Detailed Credit Card Payment Report Generated?

Similar to the Payments and Refund Totals Report, the Detailed Credit Card Payment Report comes from payments entered via a TouchBistro credit card dialog box.

Chapter 8. Detailed Credit Card Refund Report

The Detailed Credit Card Refund Report gives you a breakdown of refunds processed. Each item details the card type, the date/time the card was originally used, the order number it was used for, the authorization number, and the amount refunded on the card.

Section 1. How is the Detailed Credit Card Refund Report Generated?

1) Refunds

Refunds are issued in TouchBistro two ways:

Issuing a credit card return under the Orders menu using the Refund Sale option.

Chapter 9. Sample CSV Report Download

Click here to download a sample CSV report for the following Payments Reports:

Payment and Refund Totals
Payments by Section
Detailed Credit Card Payment Report

See Also

Cloud Reporting