Daily Sales Report
    • 19 Jun 2024
    • 3 Minutes to read

    Daily Sales Report


    Article summary

    You can access the Daily Sales Report for your business under the Reporting section of your Helcim account.

    Select Reporting from the tools menu to view a list of all the available reports.

    reporting icon

    Next, select Daily Sales from the Transactions and Tender section of reports. daily sales menu optionTo generate the report, you need to select either Summary or Detailed using the report drop down menu, select if you want to view transaction information for All Users or a specific user only, and the date using the Calendar. Then click on the Search Icon to generate your report.

    summary

    To generate the report, you need to select either Summary or Detailed using the report drop down menu, select if you want to view transaction information for All Users or a specific user only, and the date using the Calendar. Then click on the Search Icon to generate your report. You may also Filter the report at this time by Entry Point if you only want to see sales from a specific tool using the drop-down menu.

    The Summary Report will Include:

    • Sales Totals

    • Sales by Category

    • Invoice Totals

    The Detailed Report will Include:

    • Sales Totals

    • A Detailed List of Credit Card Transactions

    • A Detailed List of ACH/EFT Bank Payment Transactions

    • Other Tender Transactions

    • Sales by Category

    • Invoice Totals

    • Sales by Product

    • Discount Codes used if applicable

    Report Term Definitions and Calculations 

    Key Report Information: 

    • The date filter for this report refers to the  date that transactions occurred.  Invoice dates are not consulted in the report construction.   

    • Information pertaining to Products or Categories are tied through the product SKU. If these are changed, historical information and sales will no longer display on generated reports.   

    Sales Totals

    • This section is a breakdown by Tender Type of the sales and refunds that occurred during the specified report time period.  All Card, ACH/EFT, and Other Tender totals will be displayed. 

     Amount Sales 

    • Amount Sales is the sum of sales made (Includes purchases, captures, withdraws, and any other tender transaction) minus the sum of refunds for those transactions. Voided transactions are not included in this calculation. 

    Amount Refunds 

    • Amount Refunds is the sum of all transactions amounts that were refunded. Voided transaction are not included in this calculation.  

    Amount Tips

    • Amount Tips is the sum of all tips collected. 

    Credit Card Transactions 

    • Comprehensive list of all credit and debit card transactions processed through our system during the specified report time period. 

    ACH/EFT Transactions 

    • Comprehensive list of all Purchase type ACH/EFT Bank Payments processed through our system during the specified report time period. 

    Other Tender Transactions 

    • Comprehensive list of all Other Tender type transactions (cash, cheque, etc) processed through our system during the specified report time period. 

    Invoice Totals

    • The Invoice Totals sections includes the sum of all Paid amounts on invoices per the transaction dates. Discrepancies may occur between the Sales Totals and Invoice Totals where the transaction and invoice processing are not aligned. For example, when a Other Tender Transaction is initiated from the Payments Section ⟶ New Payment ⟶ Take Other Tender Payment, it will not create an associated invoice

    • Invoices are included in this section where the invoice status is set as PAID/COMPLETED,  or DUE/SHIPPED with a partial payment.  

    Base Invoice Amount

    • Sum of all Paid amounts at the subtotal level of an invoice.

    Tax Total 

    • The sum of invoice Tax amounts.

    Shipping Total

    • The sum of invoice Shipping amounts. 

    Discount Total 

    • The sum of invoice Discount amounts. 

    Deposit Total 

    • The sum of invoice Deposit amounts

    Tips Total 

    • The sum of invoice Tip amounts. 

    Fee Saver 

    • The Fee Saver amount paid by Customers via Online and In Person Fee Saver. 

    Total before Tips

    • The sum of all invoice fields prior to tip amounts.  

    Grand Total 

    • The sum of the total amounts paid on the invoices. 

    Sales By Product or Category 

    • Products are included here only when their associated Invoice has a invoice status of Paid, Completed, or Shipped

    • Order level discounts are not accounted for in the sales amounts at this level. For example, if a Paid Invoice contains two order items ($5 and $2) and an Invoice level discount of $4 the discount amount is not accounted for in the Product and Category sales amounts.

    • Categories and product sections do not account for partially paid invoices. If a Paid invoice contains a product for $5 and was partially paid for $2.50, the Category and Product sales amounts will still display $5 whereas the Sales Totals and Invoice Totals would display $2.50. 

    Sales By Category 

    • Sales by Category displays all categories that were attached to invoices (through either products, product variants, or services) for transactions processed within the given filters. The Summary report only displays the top level categories which contains the stats for all categories sold. The Detailed report displays the same data but is broken down into any sub-categories that may exist.

    ⓘ Click on Download Report  in the top right-hand corner of your screen to export the information as a PDF.



    Was this article helpful?