[GNC] Invoices processing with Shopify payments?

[Etienne]

Hello,

I am trying to use GNUCash to deal with Shopify orders and payments. How do you process payments to an invoice when there is a Shopify payment fee? I have been scratching my head over this.
A customer buys something of USD 40, with taxes included. So I create an invoice in GNUCash with a Tax table to calculate the VAT I have to pay.

The customer pays the USD 40 to Shopify, Shopify charges a payment fee based on what payment method the customer uses, e.g. a USD 1 credit card fee.
So my Shopify balance is then 40 - 1 = 39 dollars
Then after a week or so, Shopify pays me, in this case USD 39 dollars.

I can’t seem to process that deposit from Shopify as a payment to that invoice as it is USD 1 off as my Invoice is USD 40 and so it my Shopify A/Receivables in GNUCash.

In the invoice I can’t add the credit card fee, as GNUCash does not allow Expenses to be added to an Invoice.

Sure I can add the payment to my back account when Shopify pays me:
bank: 39
Shopify A/Receivables: -40
expenses: shopify payments: 1

When you have multiple orders and 1 payment from Shopify you have multiple payment fees, so I would need to add them up.
However, I would like to see the payment expenses for each order, to allocate them to the correct expense account (different product categories, so multiple shopify payments expense accounts).


Alternatively, I could skip using Invoices and just enter the Shopify orders as normal transactions in my A/Receivables:
Shopify A/R: 39
income:Net Sales: 30
liabilities: taxes VAT: 10
expenses: shopify payment: -1


Any thoughts of how I can use Invoices or should i just use transactions? Invoices create the benefit that I can import them from a CSV file and have the same invoice numbers of Shopify in my GNUCash too.

Thanks!
Etienne