Introduction

This article will describe how to run the Sales Receipt report to see at-a-glance sales and payment information for a day or short date range. This report was built hand-in-hand with an industry accounting professional to ensure that the data is delivered in a concise, easy-to-reconcile way, as well as to deliver an accountant-friendly report to help record sales and payment data in your accounting system.

In Gingr, the Sales Receipt report is a great way to quickly see a summary of sales-related information for a given day or date range including sales, payments received, deposits collected, accounts receivable, and more.

This is a great report to provide to your accountant or to reference when entering daily, weekly, or monthly sales data into your accounting platform.

Helpful Hints

• This report is limited to users that belong to a user group that possesses the Can View Financial Reports permission.
  
  
• Definitions of common accounting terms found on this report:
  
  
  • Debit: An accounting entry where there is either an increase in assets or a decrease in liabilities on a company's balance sheet.
    
    
  • Credit: An accounting entry that may either decrease assets or increase liabilities and equity on the company's balance sheet, depending on the transaction. When using the double-entry accounting method (which the Sales Receipt report uses) there will be two recorded entries for every transaction: A credit and a debit.
    
    
  • Accounts Receivable (A/R): The amount of money owed by customers or clients to a business after goods or services have been delivered and/or used.
    
    
  • Asset: An asset is anything (tangible or intangible) that can be used to produce positive economic value for a business or individual.
    
    
  • Liability: This is a company's liability to deliver goods and/or services at a future date after being paid in advance. This amount will be reduced (debited) in the future with an offsetting entry once the product or service is delivered.

Video Tutorial

Access and Run the Report

1. Navigate to Left-hand Navigation: Reports & More » Reports » Sales Receipt.
   
   
2. Run the report by configuring the following report parameters to your needs:
   
   
   • Location: Select the location that you want the report to pull data for.
     
     
   • From Date: Choose a start date to see sales and payment data starting on this date.
     
     
   • To Date: Choose an end date to complete the date range.
     

     Reference:  This report may only be generated for 1 month at a time (up to 31 days).

   • View Data By: Choose whether you'd like to see the Sales Receipt for the date range day-by-day or as an aggregate of the date range.

Report Output

Revenue is reported as the gross amount of all invoiced sales of reservations, services, retail, and open line items, prior to any discounts (coupons, package discounts), package credits consumed, sales tax, or tips. The Revenue for a sale is recorded when the reservation/item is checked out through the shopping cart, even if the customer does not provide a payment for that transaction until a later date.

Revenue can be split into different categories/accounts by using Account Codes. This feature allows you to assign codes to your reservation types, services, packages, POS items, and open line items so that you can easily view a breakdown of revenue by category/code.

Reference:  At this time, account codes cannot be imported to Quickbooks Online through Gingr's integration.

Account Code totals are already included in the Gross Revenue total.

Packages

Package Credits Purchased credits the prepaid packages liability account.

Package Credits Purchased are listed separately from Revenue and are not calculated towards the gross Revenue or Account Code totals, so as to not double count revenue amounts.

The invoice generated for the package purchase will be linked in the Revenue and Account Code Invoices Detail breakdown, however the revenue dollar amount will only be included in the Package Credits Purchased line.

Package Credits Consumed are redeemed package credits. Package Credits Consumed represent a debit to the prepaid packages liability account. The pre-tax, pre-discounted price of the invoiced line item the package credit was applied to will be counted towards Revenue and the corresponding Account Code if assigned.

Discounts

Discounts reflect coupons applied at checkout and package credit discounts. Coupons factor into the Discounts section of the Sales Receipt Report on the day the coupon is applied at checkout.

Package Discounts are the difference between the Package Credits Consumed (package sale price / # of credits) and the price of the line item the package was redeemed for. For example, if a $450 package with 10 credits is sold to a customer, the value per credit is $45. If this credit is redeemed for a $50 daycare reservation, the package discount is $5.

This $5 difference is reflected in the Discounts section of the Sales Receipt Report on the day the package credit is redeemed.

To find a breakdown of the coupons and package discounts included in Discounts, use the Export to CSV option (Not QBO Export option) > Open .zip file > Open "Discounts" CSV file. Coupons are represented by the title of the coupon. Package discounts will be split out into individual "Package Credits" lines depending on how many different types of packages have been redeemed. Sum up the dollar amounts to find total Coupon discounts and Package Discounts respectively.

Deposits

Deposits Collected reflect a credit in the deposits liability account. The payment method used to collect the deposit will be represented with a debit in the corresponding payment received line. Deposits paid via Integrated Credit Card processing will be paid out within the regular daily batch cycle. Gingr does not withhold deposit payments until the reservation occurs.

Refunded Deposits will be represented as a debit to the deposits liability account, and will show in the "Refunded Deposits" line on the report on the day the deposit is refunded.

Forfeited Deposits will be represented as a credit to the Revenue account and the invoice will be linked to Invoices Opened with Payment Remaining as a debit to balance.

Consumed Deposits balance with the revenue for checkouts where a deposit was applied. Debits the deposits liability account.

Store Credit

Store Credit Purchased is added to owner profiles on the day an invoice with a Store Credit line item charge is checked out from the shopping cart and paid in full. Credits the Store Credit liability account.

Store Credit Consumed is a payment method that is applied toward invoice balances. The Store Credit Consumed line balances with revenue for checkouts where store credit was used. Debits the Store Credit liability account.

Prepayments

Prepayments Collected represents a credit to the prepayment liability account on the date the prepayment was made. Prepayments are any payments applied to invoice before checkout through the shopping cart.

Prepayments Consumed balances with the revenue for checkouts where prepayments were applied. Debits the prepayment liability account. Prepayments are consumed when the invoice is checked out through the shopping cart.

Payments

Payments are collected at the time of check-out in the shopping cart. Each payment method in your app, as set up under Left-hand Navigation: Admin » Payment Methods, has a line for the amount received in the given time period for the given payment method.

Each Payment Method Received line represents the net payments; refunds are automatically subtracted out of net payment method totals. Payment Methods cannot be removed or omitted when running the Sales Receipt report.

Payments Made to Open Invoices

Equivalent to "Post Payments" on the Revenue by Dates report. Payments made toward invoices with an open balance after checkout from the shopping cart. Offsets the money that was received for open invoices. Credits the accounts receivable account.

The Payment Method Received line will debit the accounts receivable account and balance out the Payments Made to Open Invoices on the day the payment is received.

The revenue for the initial checkout of these invoices will credit the accounts receivable Revenue account and debit the Invoices Opened with Payment Remaining accounts receivable account on the day the invoice was initially checked out.

Invoices Opened with Payment Remaining

Represents checkouts where full payment was not provided at the time of checkout. Debits the accounts receivable account.

Refunds

Refunds are reported in the "Refunds" line to show the total amount of refunds issued during the date range of the report. Includes line item refunds and payment only refunds. Calculated as the gross amount, before refunded tax. Refunded tax is subtracted from the Sales Tax net total. Refunds by Account Code are also shown on the Sales Receipt report.

Refund amounts are automatically subtracted from the respective Payment Method Received.

Example: An invoice is checked out with $100 Credit Card payment applied. The Sales Receipt Report will show $100 in Revenue credit line and $100 in Credit Card Received debit line.

$25 is refunded back to the client. The Sales Receipt report will show $25 in Refunds debit line and $75 in Credit Card Received debit line.

Related Resources

• Revenue by Date Report Report Reference
• Set Up Revenue Report Account Codes How-To