Skip to content
English - United States
  • There are no suggestions because the search field is empty.

How to Find Transactions by Time (Hour by Hour)

You will learn how to find transactions in Bravo by specific times or hourly breakdowns using reporting filters and the Register Journal.

If you need an hour by hour count of your transactions, this process will help you.

First, download the Hour by Hour spreadsheet template here.  Save this spreadsheet to your computer for future use.  Open the sheet and enable editing.

Next navigate to Void/View Transactions from the Bravo Dashboard.

Click on Ad Hoc Reporting.

In the Ad Hoc Report Generator Window, select Transaction Type = Customer Transactions and Transaction Header = Date.

Next, click on the blue = to change the operator.

You can choose from the following:

  • = - One specific date only
  • Range - transactions between two specific dates
  • Last Days - All transactions from today back x number of days.

Click OK.

On the Customer Transaction Results Window, click Print List.

On the Report Preview window, click the export icon to select a file type to export. 

 

Choose CSV.

You will see a CSV Export Options pop-up. If you do not want a file to open when you save uncheck the Open file after exportiong button. Click the 3 dots (aka ellipsis) so you can choose a file location and name that will make sense for you.  This way you can access the report again if necessary.

Click Save.

The file will open in Excel.

Highlight column C - Time.  Copy this column.

Now paste this column into the Hour by Hour spreadsheet that you downloaded in step one. (It should already be open on your desktop.  

Make sure to paste the column into column A on the tab labeled Hour by Hour.  Paste over the existing column A.  Do not move or shift columns or rows.

The spreadsheet is already built to provide an hourly breakdown by day of the week for transactions.