# Ireland **URL:** \ **Category:** Uncategorized\ **Created:** [October 31, 2021, 1:00pm UTC](https://forum.manager.io/t/ireland/37801 "2021-10-31T13:00:00Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [October 31, 2021, 1:00pm UTC](https://forum.manager.io/t/ireland/37801/1 "2021-10-31T13:00:00Z")
[https://localizations.manager.io/start?FileID=SXJlbGFuZA](https://localizations.manager.io/start?FileID=SXJlbGFuZA) ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 4, 2021, 11:16pm UTC](https://forum.manager.io/t/ireland/37801/2 "2021-11-04T23:16:31Z")
I did start looking at creating tax codes which would enable the VAT3 report and the VAT Return of Trading Details (RTD) report to be produced The issue I have is that I counted that I would need 57 tax codes to cover all possibilities. This is based on the tax codes available in the Sage Accounting software so it may not cover all aspects of the VAT report requirements here. With 57 codes it is difficult to name them in a simple fashion. It is true that most businesses using Mamager will only need a small subset as a lot of the complexity involves imports and exports which would not be a concern to many small businesses in Ireland. Except that many businesses trade with customers and suppliers in the UK which is now outside the EU so that adds another layer to VAT reporting. Also the government here tinker with the VAT rules regularly by implementing temporary reduced rates or postponing payment which all adds to the complexity of generating the required reporting. Is anyone interested in working on this with me? ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [November 5, 2021, 8:00am UTC](https://forum.manager.io/t/ireland/37801/3 "2021-11-05T08:00:40Z")
In my opinion, something is better than nothing. So a possible approach would be: 1. Add the more commonly used tax codes 2. Add a report transformation which uses them 3. Add less commonly used tax codes & report transformations support. Getting something down may also help cross fertilisation between different jurisdictions tax code & report transformation architecture. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 5, 2021, 8:21pm UTC](https://forum.manager.io/t/ireland/37801/4 "2021-11-05T20:21:23Z")
@Patch is correct. @Joe91 - do not worry about comprehensive implementation. What is minimal viable implementation? That would only include handful of tax codes. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 10, 2021, 10:11am UTC](https://forum.manager.io/t/ireland/37801/5 "2021-11-10T10:11:41Z")
OK, I have started with the new tax reporting categories and have come across a problem. I have setup tax reporting categories with two for each rate we use - one for purchases for resale and one for all the rest (sales & other purchases) My VAT3 report transformation works as expected - this is a summary of the tax liability for a period My RTD report transformation does not work at all To make sure I am using the correct categories, I have only set it up for the Standard rate This is a report with the net sales and purchases for the period. Using the Tax Reporting Category - VAT Standard Rate - Net Sales does not report the Net Sales for the period although the appear in the Tax Summary report ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/e/ee95a426f59af7bf1bf70f42add540d033799cdf.png) Result ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/7/97eaa3036aa1a4cd2f510a36155fc2f2edd62497.png) Tax Summary ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/c/7c39181ba318589cabd85402925d7f785981ae91.png) Sales invoice ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/7/b747120dfaa42d7ceb5697a4f0c108fe8383a75d.png) On the VAT3 report ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/c/1c5e4601a903fb5d9b704fabfe89890e8b85e4df.png) VAT3 edit ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/6/966808ce20b1a00dc9baff4fe3b8d5fd6d9869db.png) ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [November 10, 2021, 10:51am UTC](https://forum.manager.io/t/ireland/37801/6 "2021-11-10T10:51:19Z")
the Net Sales is not working for me either. I had reported the same in our country localization. maybe it is still a work in progress. but I did not check Net Purchases. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 10, 2021, 9:20pm UTC](https://forum.manager.io/t/ireland/37801/7 "2021-11-10T21:20:38Z")
I am not going to work on this until it stabilises a bit I need to be able to report Vat due & collected, Net Purchase and Net Sales by tax code When I use the “new” Tax Reporting fields in Report Transformations they include the Net value and the VAT value if the tax code is a reverse charge so not correct at all ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 12, 2021, 9:52am UTC](https://forum.manager.io/t/ireland/37801/8 "2021-11-12T09:52:51Z")
I can see how to use the latest implementation - you need to have inward AND outward tax codes which will lead to a proliferation of tax codes but … But how will Reverse charge tax codes work? In Ireland, I have to report Reverse charge amounts on both the inward and outward fields as well as reporting the Net Purchases inward and outward ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 12, 2021, 9:52pm UTC](https://forum.manager.io/t/ireland/37801/9 "2021-11-12T21:52:28Z")
@Joe91 I’ve noticed `Return of Trading Details` has 5-column layout. In the latest version you can create report transformation with 5 columns now so that should make the report more compact. Also, is it true that VAT on purchases is reported on accrual-basis and VAT on sales on cash-basis? ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 12, 2021, 10:04pm UTC](https://forum.manager.io/t/ireland/37801/10 "2021-11-12T22:04:01Z")
Great, I will redo my RTD report. As for cash/accrual not as far as I know, but I’m not an expert. I thought you choose accrual or cash. There is a postponement system in place since Covid but I have no either how that works. Sorry ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 12, 2021, 11:19pm UTC](https://forum.manager.io/t/ireland/37801/11 "2021-11-12T23:19:12Z")
I have reformatted the RTD report - looks good Waiting on how to deal with Reverse Charge bits next The Postponed Accounting & Imports logic will have to wait - I suspect I will need a lot more tax codes 😪 ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 14, 2021, 3:55pm UTC](https://forum.manager.io/t/ireland/37801/12 "2021-11-14T15:55:35Z")
Here’s my Reverse Charge settings and results - I am on the right track? Reporting categories ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/1/71aedfc624be7475bb7fcce1eb06b7969f8cf375.png) Two Tax codes (I have to distinguish purchases for resale v other) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/a/4ad0dfe2c642210bb07e2360571dbb6dbbc635a4.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/9/9971fbe0ab89c4ba92779cb3e2467b9bf35b1919.png) Purchase invoice with two lines ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/4/54499d22906f9803ffd840f03b0b556cb0e4a65f.png) Tax Summary Report - looks good ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/4/74b1674b4f40ef6f6aabb03911443c8827d9c37e.png) VAT3 Report - Tax paid and collected - OK apart from the sign on the Reverse Charge ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/3/53559f7630ebc291e86c046dbf9b01910bc114cb.png) RTD - OK aprt from the sign ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/d/cd8578a425fbcf5f1b7dee2e3762883e76bcce1e.png) ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 14, 2021, 9:33pm UTC](https://forum.manager.io/t/ireland/37801/13 "2021-11-14T21:33:17Z")
In the latest version (21.11.18), there is now `Script` field on report transformation. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/3/134cb3bb74139be3a916f42bb6f8a45e85860b9c.png) This can be used to reverse sign on any field for example. When viewing the report, right click on the amount you need to reverse sign ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/f/ffc15af42f0256fb201a36979d3e706e53d7cc31.png) and click `Inspect element` or `Inspect` (depends if using Firefox or Chrome). ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/3/73ac55c3d8d8a3602b13339b89ccd8eaf62d2d4a.png) This will highlight HTML code of the element ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/f/ffd79c6ed2759807315e329175fb568e30c1d604.png) Each element on the report has ID attribute which we will use. In this case, ID attribute is: > 806653c3fdad4a8b9488a333c156041e40bbccc8b2484094adea039a378abb14 Now we will pass this ID to built-in function named `reverseSign`. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/f/9f785d0073307adc292e473613ae10f6b721f1bc.png) Save the report transformation and view it. The sign will be reversed. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/a/9a45b924551ddce0f14151f4fa29502099ea3d27.png) ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [November 14, 2021, 9:45pm UTC](https://forum.manager.io/t/ireland/37801/14 "2021-11-14T21:45:36Z")
Mmm, a shortcut, but not really elegant and far from the ambition to 0-code. Not sure if this is the right way to go, sorry. Somehow, in the eagerness to get more contributions the sacrifice to disallow coding is now starting to hurt. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [November 14, 2021, 9:47pm UTC](https://forum.manager.io/t/ireland/37801/15 "2021-11-14T21:47:18Z")
@eko you see a manual shifter but all I can see is more horsepower. 🙂 ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 14, 2021, 9:49pm UTC](https://forum.manager.io/t/ireland/37801/16 "2021-11-14T21:49:05Z")
@eko I was always planning to introduce scripting into report transformations. You could write a script that could connect to tax authority and lodge the figures on the report right from Manager. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 14, 2021, 10:12pm UTC](https://forum.manager.io/t/ireland/37801/17 "2021-11-14T22:12:51Z")
That’s all very well for reversing the sign on the report but it doesn’t help with the totals ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 14, 2021, 10:49pm UTC](https://forum.manager.io/t/ireland/37801/18 "2021-11-14T22:49:55Z")
@Joe91 can you show on screenshot what you see and what you expect to see? ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 14, 2021, 11:00pm UTC](https://forum.manager.io/t/ireland/37801/19 "2021-11-14T23:00:39Z")
This is the Report Transformation for our VAT3 Report ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/b/dbb28612b2f80bdfeb33cb5bde1af4c34ea7b9e2.png) We do not need to show the two detail lines that make up the total but the Total should be the Vat Sales Total + Reverse Charge for Total (T1) and VAT Purchases Total + Reverse Charge for Total (T2) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/f/5f508bf5a27f151b8075f8844c5b2ec3dc4a4977.png) The Total T1 should be 14,139.95 + 690.00 = 14,829.95 As it is shown on the Tax Summary Report ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/d/6d695f9c01a4f3c9f73333338f3df691e9bba4db.png) ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 14, 2021, 11:02pm UTC](https://forum.manager.io/t/ireland/37801/20 "2021-11-14T23:02:16Z")
Ideally, the negative figures should be shown as positives in the VAT3 Report Transformation [Next page](https://forum.manager.io/t/ireland/37801.md?page=2)