📂
Drop your ATL Monthly Sales Export here
Accepts .xlsx or .xls — all till figures populate automatically
✅
—
AUTO-FILLED
📊
Drop your Xero "Transactions by VAT Box" Export here
Auto-fills Other Revenue, NHSBSA income & Input VAT (Box 4)
✅
—
XERO AUTO-FILLED
Practice & Accountant Details
Section 1 — ATL Till Sales
⚡ AUTO-FILLED FROM ATL
| Category |
Gross Incl. VAT (£) |
Net Excl. VAT (£) |
Rate |
VAT Due (£) |
20%Standard Rate Sales OTC medicines, cosmetics, general retail |
£ |
£0.00 | 20% | £0.00 |
5%Reduced Rate Sales e.g. incontinence products, mobility aids |
£ |
£0.00 | 5% | £0.00 |
0%Zero Rated Sales Dispensed prescriptions, food items |
£ |
£0.00 | 0% | £0.00 |
NHSNHS Prescription Charges Patient co-payments at counter (exempt) |
£ |
£0.00 | Exempt | £0.00 |
PrivPrivate Prescriptions Private dispensing income (exempt) |
£ |
£0.00 | Exempt | £0.00 |
NHSBANHSBA Income Payment Monthly BSA dispensing payment — auto-filled from Xero |
£ |
£0.00 | Out of Scope | £0.00 |
CashCash Sales Reduction Counter cash — deducted from standard rate (auto-filled from ATL) |
£ |
£0.00 |
20% ÷ 6 |
–£0.00 |
Section 2 — Other Revenue (from Xero)
⚡ AUTO-FILLED FROM XERO
Auto-filled from your Xero export as gross (inc VAT) figures. Add or edit lines as needed.
Other Revenue VAT Total
£0.00
Revenue Summary
ATL Till Revenue (Gross inc VAT)
Standard + Reduced + Zero + NHS Charges + Private Rx + Other Revenue
NHSBSA Revenue (from Xero)
Monthly BSA dispensing payment (exempt)
Counter Sales (Till Revenue − NHS Charges − Private Rx)
Summary Totals
ATL Till Gross (excl. NHSBSA)
£0.00
Total Output VAT Due (Box 1)
£0.00
ATL File Reconciliation Check
From ATL File
Standard (20%)—
Reduced (5%)—
Zero Rated—
Exempt—
ATL Total VAT—
This Form (Till only)
Standard (20%)—
Reduced (5%)—
Zero Rated—
Exempt / OOS—
Form Till VAT—
Section 3 — Input VAT Claimed (Box 4)
⚡ AUTO-FILLED FROM XERO
Auto-filled from your Xero "Transactions by VAT Box" export (Box 4 total).
Notes
Ready — drop your ATL Monthly Sales Export above to auto-fill.
Email Preview
To: —
📎 Clicking "Open in Outlook" will also download the Excel summary — attach it to the email before sending.
Dashboard
SB Pharma Ltd · Analytics
Total Revenue (Latest Month)
£0.00
Card Sales
£0.00
0%
of till sales
Cash Sales
£0.00
0%
of till sales
Monthly VAT — Output vs Input
Till Sales — Cash vs Card (Monthly)