Credit card tips by payment type

[markjw]

I’ve implemented credit card tips as mentioned in this other topic

Credit Card Tip

Hi, I have Configured a %tip and Fixed tip configured in my payment screen, which works perfect. It shows the Tip amount on the Day end Report as well. However I want to split the Tip e.g. If payd by cash then the it shows as tip on the Day end and if pyd by Credit Card it shows as CC Tip on the day end. Is this possible? Kind regards Michael

I have credit card payment types setup as individual card types (Visa, MasterCard, Amex, etc) but at the moment, tips from any card just get associated with CC Tips. I want to be able to know the amount of tips for each payment card type. I know I can do this by just duplicating the functionality for CC Tips for each card type (i.e. CC Tips Visa, CC Tips MC, etc.) but I was wondering if I can just do this via a report.

So for example, on the work period report, I could add a section that shows CC Tips by card type.

Is this possible? I was a bit confused with combining payment types and calculation types in the report when I tried this out.

Thanks!

[pauln]

Hey Markjw do you have underlying Account Transactions for this process? If you do you could separate the payments into separate Accounts at the point of Payment. Sorry we do not use Tips so cannot do a demo for you.

[markjw]

I have the payment types going into separate accounts but using the same account transaction type, here are the accounts:

and the account transaction types:

UPDATE: Just noticed I highlighted the wrong account transaction type in the above screenshot for the credit card transactions. They are using Payment Transaction and not Customer Credit Card Payment.

[pauln]

Sorry was busy making phone calls…
The key (I think) is you will need to split your Tips Accounts based on this syntax:

{ACCOUNT TRANSACTION DETAILS:Customer Account Transaction:Customer Accounts}

The syntax will produce a 3 column table based on your Account Transaction i.e. “CC Tip Transaction” and then you specify an Account “CC Tips”. So above you may run into my issue is based on the Syntax if you need to split your tips into Account Type you will need separate Accounts.

That’s my interpretation and check this link:

ACCOUNTING REPORT Tags Expressions

Hello @emre I need some here as I have made a glaring stuff thinking I could departmentalize Accounting but these Tags below do not support Expressions: [NEW!] How to use Custom Reports Module 1.0: Emre I was expecting to be able to do something like this: {ACCOUNT TRANSACTION DETAILS:Customer Account Transaction:Customer Accounts:(DE=Bar)} The mere fact we had departments I assume we could separate the Accounting? We would assume most venues would not wish to have other departments looki…

[michaelb]

Hi guys,

referring to the guide Credit Card Tip

I noticed then when I reopen the ticket the Tax charged e.g 15% is also charged on the Tip amount. Is that normal?