Contents x
    Tip Distribution Export
    • 12 Aug 2024
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Tip Distribution Export

    • Updated on 12 Aug 2024
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Downloading the Tip Distribution Export

    For payroll purposes, it is recommended to only use tip distribution exports for approved tip distributions. For review purposes, tip distribution exports for unapproved distributions can also be downloaded.

    On both the Tip Automation page and on the Tip Distribution Details page, clicking the 'Export' icon for the desired tip distribution will download the associated Tip Distribution Export. Learn more about exporting tip distributions here.

    A screenshot of a computer  Description automatically generated

    Tip Distribution Export

    The tip distribution export contains two tabs with tip distribution totals by employee. These two tabs can be exported as a single file from the Tip Automation page or from the Tip Distribution Details page.

    Contributors

    Column

    Column Title

    Description

    A

    Name

    Contributing employee's name

    B

    Job

    Contributing employee's job associated with the contributed tips

    C

    Net Sales

    Net sales associated with the employee during the hours associated with the tip automation rule

    D

    Declared Tips

    Cash tips not associated with a sales ticket and declared by the employee during the hours associated with the tip automation rule.

    E

    POS Cash Tips

    Tips received by the employee on sales tickets tendered to cash during the hours associated with the tip automation rule.

    F

    POS Card Tips

    Tips received by the employee on sales tickets tendered to credit or debit card during the hours associated with the tip automation rule.

    G

    Merchant Discount

    Tips withheld to cover credit card processing fees. Learn more about Withheld CC% calculations here.

    H

    Total Tips

    Total tips used for the distribution.

    The tip automation rule 'Declared tips paid with payroll' setting has the following impacts on 'Total Owed':

    If the 'Declared tips paid with payroll' setting is enabled, this amount will be: POS Cash Tips + POS Card Tips+ Declared Tips

    If the 'Declared tips paid with payroll' setting is not enabled, this amount will be: POS Cash Tips + POS Card Tips

    I

    Tips Out

    Tip contribution amount of 'Total Tips' or 'Net Sales', as calculated by the tip automation rule.

    J

    Balance Applied

    Tips Out shortfall from previous days.

    K

    Tips Owed

    Amount of tips still owed to the employee after the 'Tips Out' and 'Balance Applied' amounts have been contributed.

    Total Tips - Tips Out - Balance Applied

    The minimum amount for tips owed is $0.00. A negative tips owed amount will result in a contribution shortfall that will be carried over to future distributions in the 'Balance Applied' column. This does not impact the total amount distributed to receiving employees.

    L

    Last Calculated

    Date the tip distribution was calculated.

    Receivers

    Column

    Column Title

    Description

    A

    Name

    Receiving employee's name

    B

    Job

    Receiving employee's job associated with the received tips

    C

    Worked Hours

    Number of hours worked in the receiving job during the hours associated with the tip automation rule

    D

    Tips Owed

    Additional amount of tips owed to the employee from the tip distribution

    E

    Last Calculated

    Date the tip distribution was calculated.

    Was this article helpful?
    What's Next