📊 OSS / Domestic VAT

🇪🇺 OSS VAT Report

How to use:

  1. Upload the VTR CSV file from Amazon
  2. Select the month/year to process
  3. Click "Run OSS Process"
  4. Reports will be saved to F: drive automatically
Upload the Amazon VTR file (CSV format)

📄 Amalgamate OSS PDFs

Combines all individual OSS result PDFs for last month into a single PDF, grouped by country (A–Z) with FBA before MFN. Ready to download and print.

How it works:

  1. Auto-detects last month's OSS result folder on F: drive
  2. Groups PDFs alphabetically by country, FBA before MFN
  3. Merges all files into one combined PDF
  4. Downloads directly to your browser

🇪🇺 OSS VAT Report - Mid-Month

How this differs from the original "OSS VAT" tab:

  1. Amazon now lets you download the VTR at any point in the month, so you can invoice several times a month.
  2. Upload the latest VTR (a running total from the 1st). Orders already invoiced in Orderwise are not picked up again.
  3. Each run gets a run number (R1, R2, ...) in the Orderwise tag, e.g. OSS-T11-FBA-09-2026-R2, and in the PDF names.
  4. Invoice date is always the last day of the month.
  5. Orders not yet on the VTR show as "NOT YET ON VTR" and are picked up by a later run.
  6. Preview shows what would happen without tagging anything or saving PDFs. Run for real tags orders in Orderwise and saves the PDFs to F:.
Latest Amazon VTR (CSV). Saved to the month folder with a date/time stamp, so earlier files are kept.
 to 
After upload, every transaction in the VTR is checked against this range. The run stops if any fall outside it. The range is shown on every PDF and in the Run folder name.

🇪🇺 Domestic VAT Report

How to use:

  1. Upload the Avask Excel file
  2. Select country, month, and year
  3. Click "Run Domestic VAT Process"
  4. Reports will be saved to F: drive automatically and details listed below along with a download report option.
Upload the Avask VAT report (Excel format)

🔍 OSS Reconciliation (Avask vs OrderWise)

Purpose: This process allows us to reconcile the amount Avask says we owe to each country via OSS against what OrderWise says. You need to get the Avask spreadsheet that states what they will be paying each country, enter here then you will see the difference between the two. Normally the difference in the totals is a single digit percentage.

How to use:

  1. Select the date range that matches your Avask report
  2. Click "Fetch OrderWise Data" to load the OSS totals
  3. Enter the Avask figures for each country (Net Sales and VAT)
  4. Review the variance column (red = mismatch, green = match)
  5. Check the total variance at the bottom

📋 OSS Data NON Amazon (For Avask)

Purpose:

Generate OSS VAT data for non-Amazon sales to send to Avask. This excludes all Amazon marketplace transactions.

How to use:

  1. Select the date range (From and To dates)
  2. Click "Generate Report"
  3. Review the data by country/tax code
  4. Download the PDF to send to Avask

🇬🇧➡️🇪🇺 EC Sales Report

How to use:

  1. Upload the Amazon VTR CSV file
  2. Select the month/year to process
  3. Click "Upload VTR File"
  4. Follow the instructions to complete via Slack

Note: Currently requires manual processing step via Slack. Full automation coming soon!

Upload the Amazon VTR file (CSV format)

📋 EC Sales POD Reference Report

How to use:

  1. Complete the EC Sales process and confirm all T4/T1 orders
  2. Select the month/year
  3. Click Generate — report is saved to F: drive

Note: Run this after the EC Sales process is complete and all T4 orders are confirmed.

📋 EC Sales Report – Detailed

🔄 Acquisitions Monthly Report

Monthly Process:

  1. Select the month and year to process
  2. Upload Avask acquisition files (Germany, Poland, and Ireland)
  3. Run Part 1: Cost Comparison (Avask vs OrderWise)
  4. Run Part 2: Invoice Report (T4/T9 totals)
  5. Download PDF reports using the download buttons

Note: Files are automatically saved to F:\Accounts\VAT\Acquisitions\[Country]\[Month] [Year]\

📋 How the Invoice Report Calculates Totals:

  • Uses Avask Excel files (Germany, Poland, Ireland)
  • Filters INBOUND transactions only (excludes FC_TRANSFER)
  • Uses Column J (NET) in original currency from Avask
  • If already GBP → uses amount directly
  • If EUR → divides by 1.14 to convert to GBP
  • PDF totals = GBP amounts from Column J, not Column U (Converted NET)

Example: Ireland May 2026 showed £531.40 from 10 INBOUND transactions in original GBP (Column J), not €612.80 from Column U.

📁 Upload Avask Files

germany_acquisitions_[month][year].xlsx
poland_acquisitions_[month][year].xlsx
ireland_acquisitions_[month][year].xlsx

Processing... This may take up to 2 minutes.

OrderWise Tax Code Bulk Editor

Update tax codes for multiple orders at once.

VAT Journals Monthly

Calculate Domestic VAT and OSS VAT amounts for monthly ledger closing.

📊 UK VAT Return Summary Report

Generate the quarterly UK VAT summary report (combines sales, purchases, OSS data)

📁 Before You Start - Required Files

You must complete these steps in OrderWise first:

Step 1: Export Sales Data

  1. Open OrderWise VAT Return
  2. Click on the magnifying glass against Box 6 and export to Excel
  3. Save as: Q1 2026 Sales.xlsx

Step 2: Export Purchases Data

  1. In OrderWise VAT Return, click on the magnifying glass against Box 7 and export to Excel
  2. Save as: Q1 2026 Purchases.xlsx

Step 3: Save Files to Correct Location

Save BOTH files to this folder on the F: drive:

F:\Accounts\Gary VAT Folders\UK VAT Returns\Q1 2026\

Note: Replace "Q1 2026" with your actual quarter (e.g., "Q2 2026" for Apr-Jun)

⚠️ Important: Make sure the Excel files are CLOSED before generating the report. If files are open, the report will fail.

From VAT OSS Quarterly Records spreadsheet

From OrderWise VAT Return (Box 5)

From Journal Credits — Box 6 fuel scale charge

📋 PVA (Postponed VAT Accounting) Entries (Optional)

Add PVA entries from your PVA statements. These will appear in a separate section on the report.

📊 Reconcile VAT Turnover to P/L Turnover

Quarterly VAT turnover reconciliation report

📝 How This Works

This tool reconciles your VAT turnover (from Box 6) to your P/L turnover by accounting for:

  • Box 6 total from VAT return
  • OSS sales (EU-EU, not XI to EU)
  • Domestic EU sales (T71-T78, T81-T88)
  • Fuel scale charge deduction
  • FC transfer credits (nominal 4999)
  • T9 exchange rate variance

✏️ Manual Entries Required

From OrderWise VAT Return

Obtain from Avask OSS submission summary

Obtain from Inv Report Per Tax Code, search all T codes between T71 and T88 - take the NET value

Obtain from nominal code 7350

Obtain from total of sales credits made in the QTR to nominal 4999

Total in invoice report per tax code for T9 foreign gross minus the total gross for the QTR

From OrderWise VAT Return

From your P/L for this quarter

OrderWise Knowledge Base

Search documentation and guides for OrderWise functionality.

Categories

Loading articles...