Shopify report for preparing an Australian BAS

Sonya153 · ‎04-06-2023

I'm hoping someone can help me with what I thought was a really simple problem - which report do I run to assist with preparing my BAS?

I'm looking for a report that shows:

- Total Sales

- GST included in sales

- Merchant/Shopify Fees

The payout summary would be ideal, however it doesn't show the GST amount. As I sell products overseas, I can't assume that all transactions have 10% GST on them.

I have run the Total Sales report, but this doesn't show the Shopify Fees deducted from the transactions prior to depositing it in my bank (also, it's near impossible to run the report so that it matches the transactions on my payout summary).

Ideally, I'd like to record the transaction in my bookkeeping software once, when the settlement is received in my bank, rather than messing around with journals. (i.e. one transaction of: gross sales including GST(Aust Sales); gross sales where GST not applicable (overseas sales); less merchant fees)

CloudlabSam · ‎04-06-2023

Hello,

Unfortunately, there isn't a Shopify report that can provide this information all in one place.

Our Report Toaster app can help. You could start with our Financial Summary report template and customize as you need. We also have reports specifically for taxes that can be used as well. If you decide to install the app, feel free to reach out to support for any help you need. Thanks!

Report-Pundit · ‎04-24-2023

Hello @Sonya153 ,

With Report Pundit you can generate premade and customized payout reports for your store.

With data fields Including Total sales, Tax rates, Shopify fees, and for your information you can add multiple tax rates to the same report.

Hope this will resolve your query.

Thanks!

Report Pundit - Instant reports and custom dashboards