End of Day Report

Kathryn Hamilton
Kathryn Hamilton
  • Updated

Overview: What are we talking about?

This article will cover how to use the End of Day report to extract financial information from Gingr at the end of the business day. This report can be customized depending on a users' permissions, and provides information about the charges and payments for invoices opened on that date, as well as information about tips collected, commission earned, and reservations that checked-in or out on that date. This reports' purpose is to provide an end of day summary, which can aid in reconciling a cash drawer or in closing duties.

 

This article includes:

 

Helpful Hints: Before you begin.

  • In order to get the most out of your Financial reports in Gingr, it's recommended to set up Account Codes! This will allow you to see totals for charges based on the type of revenue. You can learn more about setting this feature up here.

  • The End of Day report provides an overview of commission earned, tips, collected, and invoice charges and payments that occurred on a date. To see more information about these sections, check out the dedicated report(s) for those types of transactions. These reports include

    • Revenue by Date(s) Report
    • Commission Report
    • Tips Report

 

 

How to: Provide Access to the End of Day Report.

There are two user permissions that apply to the End of Day Report. These permissions can be managed from Left-hand Navigation: Reports and More Icon » Groups.

Setting Description Helpful Hint
Can View Financial Reports If enabled, users in this group will have the ability to view all financial related reports.

Financial Reports include all reports in the Financial section of the Reports page. Some of the reports in this section include:

  • Revenue by Date Report
  • End of Day Report
  • Commission Report
  • Tips Report
  • Customer Spend 
  • CardConnect Batch Report
Can View End of Day Report If enabled, users in this group will have the ability to view the End of Day report.

This setting only effects users that do not possess the Can View Financial Reports permission.

Note: Users that only have the "Can View End of Day Report" permission enabled will only be able to view the current day's report. To enable users to view any date's End of Day Report, both the "Can View Financial Reports" and "Can View End of Day Report permissions need to be enabled.

 

Important! Only users that possess the Can Manage Group Permissions permission can manage these permissions.

 

The End of Day report includes the following sections: 

  • Revenue Summary
  • Invoice Details
  • Commission Report
  • Tips Report
  • Check Ins
  • Check Outs

All sections of the report are able to be viewed by users that possess the Can View Financial Reports user permission. Users that do not possess this permission, and instead possess the Can View End of Day Report permission will be able to view any sections of the report that have been enabled for them under Left-hand Navigation: Admin » User Account Settings via the End of Day Report Sections setting.


Using this setting, an Admin user can limit which sections are available to users that don't have permission to view all financial reports. The End of Day Report Sections that can be limited using this field include:

  • revenue_summary
  • commission
  • tips
  • transactions
  • checkins
  • checkouts

In this field, enter the report sections that users should have the ability to view.

Screen_Shot_2020-03-25_at_2.21.23_PM.png

Important! Users that possess the Can View Financial Reports user permission will be able to view all sections of the report, regardless of the sections entered in this setting.

 
How to: Using the End of Day Report.

To access the End of Day Report, navigate to Left-hand Navigation: Reports and More Icon » Reports » End of Day Report.

Enter the Date and optionally adjust the From Time and To Time to review the report for a specific timeframe. The Location of this report will be determined based on which location your user account is currently logged into.

Indicate the report sections that you'd like to view on the report from the Options checklist.

Click Generate Report! to pull up the report for the input selections.

mceclip0.png

If all options are included on the report, you'll see the following sections.

Payment Type Summary

This section includes a breakdown of payments made on this date, broken down by Deposits, Prepayments, Payments, and Refunds.

mceclip9.png

Type Definition
Total Payments Sum of all payments made on this date.
Deposits Total deposits paid on this date.
Prepayments
Total payments made towards estimates on this date.
Payments Total payments made towards open invoices on this date.
Total Refunds Total refunds performed on this date.
Refunded Payments Total refunded payments on this date.
Deposit Refunds Total refunded deposits on this date.
Net Total Net total of payments made on this date. Calculated as Total Payments less Refunds.

 

 


Invoice Charges Summary

This section includes a breakdown of invoice charges within the date range of the report, broken down by Taxable and Exempt Charges, Tax, and Tips added to invoices, as well as line item refunds on this date.

mceclip10.png

Type Definition Helpful Hint
Subtotal Total charges of all invoices opened on this date. This value is pre-tax.
Taxable Charges Total of all taxable charges on invoices opened on this date.  
Exempt Charges
Total of all exempt (non-taxable) charges on invoices opened on this date.  
Tax Tax charged on invoices on this date. Calculated by charges of taxable items and the location's tax rate. For more information on sales tax, check out the Sales Tax Report. Click here for more info.
Tips Total tips added to invoices on this date. Tips can be added as open line items or during credit card transactions.
Refunded Items Pre-tax total of line items refunded on this date.  
Tax Refunded Tax refunded on taxable line items on this date.  
Totals Net total of charges on invoices opened on this date. This is calculated as the Subtotal plus Tax and Tips charged.  

 

 

Charges

The totals in this section are made up of Reservations, Additional Services, Retail Items, and Open Line Item charges during the date range, as well as Purchased Packages and Package Credits Used per each account code. This section also includes Store Credit Purchases and charges for items where an account code is not set. Charges per account code reflect any coupons or rate modifiers applied to the line items on the invoices. 

mceclip11.png

Important! Account codes are a great way to break down your charges by type of revenue. Visit this article to learn more about setting up Account Codes.

 

Payments and Refunds

This section provides a breakdown of all payments and refunds within the date range organized by payment method. This section can be especially helpful for staff to reconcile cash, check, and credit card payments that were received on this date.

mceclip12.png

Commission Report

This section provides details about commissionable services that were checked out on this date. It can be helpful to include this section on this report to have commissionable employees confirm their commissions on a daily basis.

mceclip13.png


Check Ins

This section includes a list of reservations that checked in on this date. This information can be helpful to include to aid staff in reservation count and managing check ins.

mceclip14.png


Check Outs

This section includes a list of reservations that checked out on this date. This information can be helpful to include to aid staff in reservation count and managing check outs.

mceclip15.png


Tips Report

This section provides details about tips received on this date. This can be helpful to include if tips are paid out on a daily basis.

mceclip16.png


Charges Full Results

This section provides detail of charges, tax, and refund events per invoice. This section combines all of the information displayed in the Invoice Charges section to provide an invoice-level breakdown of the invoices that make up the totals for this date range. 

mceclip17.png

 

Payments Full Results

This section provides payments and refunds events per invoice. This section combines all of the information displayed in the Payment Type Summary section to provide an invoice-level breakdown of the payments that make up the totals for this date range. 

mceclip18.png

 

Was this article helpful?

0 out of 2 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.