Templates / Profit & VAT Dashboard
Google Sheets and Excel · One-off downloadShopify Profit & VAT Dashboard (UK)
A spreadsheet template that syncs your Shopify orders with Apps Script and calculates UK VAT, payment fees, product costs, ad spend and real net profit.
£29 for the template, or £59 with a 6½-minute setup video. All sales are final. Not tax advice. Not affiliated with Shopify.
What the paid template calculates
The list below is the paid template. The free LITE version is profit and loss only: you paste a CSV, and it does not sync orders.
- Order sync. Shopify orders sync into the spreadsheet with Apps Script.
- Google Sheets and Excel. The template is for both.
- UK VAT. Standard rate or flat rate.
- Payment fees. The fees taken by the payment provider.
- Product costs. What the goods cost you.
- Ad spend. Counted in the result.
- Real net profit. Calculated from VAT, payment fees, product costs and ad spend.
- Monthly P&L. Profit and loss for the month.
- VAT summary by quarter. VAT totals for each quarter.
- £90,000 VAT threshold. A check against the UK VAT registration threshold.
Buy once. Download from Gumroad.
Both paid options are on the same Gumroad page. Checkout is on Gumroad. All sales are final, because this is a digital product.
Not tax advice, and not a Shopify app.
Not tax advice. The template calculates figures from your orders and the costs you enter. It does not tell you what to file, which VAT scheme to use, or whether you must register.
All sales are final. This is a digital product. Gumroad handles the payment and the download.
Not affiliated with Shopify. Shopify is a trademark of Shopify Inc. Oskivo is an independent developer. This template is not installed from the Shopify App Store.
Questions
Is this a Shopify app?
No. It is a spreadsheet template you download. It is not listed on the Shopify App Store, and it is not one of the Oskivo apps.
What does the free LITE version include?
Profit and loss only. You paste a CSV of orders. It does not sync orders with Apps Script.
Where do I buy the paid template?
On Gumroad. £29 is the template. £59 is the same template with a 6½-minute setup video. Both prices are on the same Gumroad page.
Can I get a refund?
No. All sales are final. This is a digital product.
Is this tax advice?
No. The template calculates figures from your Shopify orders and the costs you enter. It does not tell you what to file, which scheme to use, or whether you must register for VAT.
Is Oskivo part of Shopify?
No. Shopify is a trademark of Shopify Inc. Oskivo is an independent developer and is not affiliated with Shopify.
Questions about the file: email support@oskivo.com. How support works.
Get the dashboard
£29 for the template, or £59 with the setup video. The LITE version is free.