Refunds made in shopify does not come in QBO I have to do it manually. Can this be automated?

Yes. It can be automated, abdqbo1.

We can connect the bank account that has your Shopify transactions. Once connected, the transactions will automatically be downloaded on your QuickBooks Online account.

I've added these references that have detailed information in connecting your bank account: 

• Connect bank and credit card accounts to QuickBooks Online
• Categorise and match online bank transactions in QuickBooks Online

As always, I've got your back if ever you need help in connecting your bank. Have a great day!