Hi everyone,
I am setting up Ledger accounting software for Cyprus VAT reporting and I would like to create a custom Cyprus VAT Return report based on the Cyprus VAT Return boxes.
I have already created the required tax codes, but I am not sure how to correctly configure the VAT Report / Report Extension so that each tax code automatically appears in the correct VAT Return box.
My intended tax codes are:
| Tax Code | Description | Rate | Reverse Charge |
|---|---|---|---|
CY-S-19% |
Cyprus Sales | 19% | No |
CY-S-9% |
Cyprus Sales | 9% | No |
CY-S-5% |
Cyprus Sales | 5% | No |
CY-S-3% |
Cyprus Sales | 3% | No |
CY-P-19% |
Cyprus Purchases | 19% | No |
CY-P-9% |
Cyprus Purchases | 9% | No |
CY-P-5% |
Cyprus Purchases | 5% | No |
CY-0% |
Cyprus Zero Rated Sales | 0% | No |
EU-GS-0% |
EU Goods Sales | 0% | No |
EU-SS-0% |
EU Services Sales | 0% | No |
EU-GP-RC 19% |
EU Goods Purchases | 19% | Yes |
EU-SP-RC 19% |
EU Services Purchases | 19% | Yes |
OOS-0% |
Outside Scope Sales | 0% | No |
The Cyprus VAT Return boxes I need to reproduce are:
- Box 1 – VAT due on outputs + applicable reverse charge
- Box 2 – VAT due on acquisitions of goods from EU Member States
- Box 3 – Box 1 + Box 2
- Box 4 – Deductible input VAT
- Box 5 – Box 3 − Box 4
- Box 6 – Total outputs excluding VAT
- Box 7 – Total inputs excluding VAT
- Box 8A – EU goods sales
- Box 8B – EU services sales
- Box 9 – Zero-rated outputs
- Box 10 – Outside-scope sales with right to input VAT deduction
- Box 11A – EU goods acquisitions
- Box 11B – EU services received from EU suppliers
For example, I want:
EU Services Sale €20,000
EU-SS-0%
→ Box 6 = €20,000
→ Box 8B = €20,000
And:
EU Goods Purchase €10,000
EU-GP-RC 19%
→ Box 2 = €1,900 VAT
→ Box 4 = €1,900 input VAT
→ Box 7 = €10,000
→ Box 11A = €10,000
Similarly:
EU Services Purchase €10,000
EU-SP-RC 19%
→ Box 1 = €1,900
→ Box 4 = €1,900
→ Box 7 = €10,000
→ Box 11B = €10,000
My questions
- How can I create a custom VAT Return report with these 11 boxes?
- Is this done through Report Extensions, a custom report, or another module?
- How do I reference the Tax Codes inside the report?
- How can I make one transaction appear in multiple boxes?
For example:EU-GP-RC 19%→ Box 2 and Box 11AEU-SS-0%→ Box 6 and Box 8B
- How should I calculate the total boxes:
- Box 3 = Box 1 + Box 2
- Box 5 = Box 3 − Box 4
- Is there an existing Cyprus VAT report extension/example that someone could share?
- If possible, could someone provide a sample report definition/code and explain where each part should be entered?
I am specifically looking for a guide/example for Ledger/Manager-style Report Extensions, ideally with the actual syntax and a step-by-step explanation.
Thanks in advance.