@Liongrass to make sure, you mean in the Reporting/Products sold?

The problem is that the "Products Sold" report is 1 line = 1 product. As such we can't really put tip information in there, as one basket may have several product.

In which report you'd like this information?

Yeah, good question how this can be surfaced ideally without messing with the document structure, which is already a bit confusing. One idea I had was to use InvoicePrice as the amount pre-tip, and PaidCurrency as the amount post-tip, then the difference can be the tip. But we'd have to check if that messes up something else.

@Liongrass we have two choices. Either we add it to the "Payments" reports. Or we add a new report for "invoices", where we put invoice information.

Then you can export payments and invoices and "join" the two exports using the invoice id.

My idea: the tip and the payment are recorded in different rows, with the same details but a different order ID. So a $1 payment with a 20% tip shows up twice in the csv, once as the $1 payment, and once as the $0.2 tip.

Can't do this, order id is tied to an invoice, and several payments can be for same invoice.
There is no concept of orderId outside of an invoice.

Given other issues with the csv 4936, maybe this mechanism has to be rethought or overhauled? It currently seems very difficult to use BTCPay for accounting unless fully integrating external software through the API.

I wished I could find a better mechanism, but so far nobody told me how it should look like and define precisely.
What is the problem of adding the TIP % as an additional column of Payments report?

Yeah, that seems to be the minimum information required to make this useful. Maybe reporting the tip as an absolute number would make it more straight forward to sum it up using the spreadsheet alone.

How about another idea: Add it "Products sold". ie: A tip would be consider just like an item in the report. There are sum already there.

Yeah as long as that will also work for the keypad-pos. Looking at my store under "products sold" currently shows an empty list. Ideally it would also divide it by App, because I might have a separate app for each attendant/server, and they wouldn't necessarily share tips.

The scope of the csv-export of the summary of "products sold" would have to be expanded too in that case, as for example the total of sats collected matters too, not just the dollars invoiced.

cc @dennisreimann relevant feedback for us, can discuss in the next design call

I'm just adding my support to have this detail rectified. Here in Vancouver, we are onboarding a healthy amount of businesses. One of the businesses is where I host my meet ups. They sell drinks and the bartenders need to accept tips. Currently we end up having to either add x% to the cost of the drinks and then manually do the math and deduct the x% from the total to determine the tip. Or we create a secondary QR code/wallet where the customer can do a second transaction to keep tips separate from the regular sales. Both aren't a great experience. If the reporting can break out the cost of the product/service and the tip separately, this will go a LONG way in helping onboard more businesses. Thank you!

@Fustler We have that data structured in a form that we can separate them, so this is good feedback and we will change it to be separate columns.