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 _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
