Hi, I need the accounts doing for a company I have recently starting working with.
I have exported all relevant shopify and paypal transaction into excel.
I have also exported all relevant expenses into excel too. The raw data is there. It simply needs to be analysed.
There are a couple of points to be mindful off: Paypal income is double counted (as its counted as income in shopify report and also as income in paypal report - so this needs to be adjusted for).
expenses are double counted in paypal: As some withdrawals to bank and payments to supplier are made from the paypal account - these need to be adjusted for.
I have attached the files required for analysis.