# VAT annual summary **URL:** \ **Category:** Uncategorized\ **Created:** [April 22, 2023, 5:40am UTC](https://forum.manager.io/t/vat-annual-summary/46641 "2023-04-22T05:40:23Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![ZAFMike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zafmike/32/27663_2.png) [@ZAFMike](https://forum.manager.io/u/ZAFMike)\ **Post date:** [April 22, 2023, 5:40am UTC](https://forum.manager.io/t/vat-annual-summary/46641/1 "2023-04-22T05:40:23Z")
I am looking to create a custom report to have a statement of all my VAT payment to the tax authorities for a financial year broken down per tax period. There should basically just be 2 entries per tax period… The total VAT owed and the payment to the authorities. I have tried to create a custom report but I cannot seem to get it right. Any help to point my in the right direction as to what I need to select would be appreciated. I have attached at screenshot of what my tax authority sends me, but I would like an additional one from Manager if possible. ![VAT Statement](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/9/89fe41717a3350dd29c7b291c9dff841cfe96a44.png) ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [April 22, 2023, 6:33am UTC](https://forum.manager.io/t/vat-annual-summary/46641/2 "2023-04-22T06:33:28Z")
To get that information I use a combination of - historical VAT reports from Manager - VAT report in Manager for a period of the financial year. - drill down on Managers summary page of the VAT account (which shows the running balance) - balance sheet report with multiple comparisons dates ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [April 22, 2023, 7:10am UTC](https://forum.manager.io/t/vat-annual-summary/46641/3 "2023-04-22T07:10:31Z")
> [@ZAFMike](#): > > I have tried to create a custom report but I cannot seem to get it right. See Forum rules [FAQ - Manager Forum](https://forum.manager.io/faq) it clearly states [emphasis added]: > If your question is related to custom themes or **custom reports** , **always post the** code or r **eport definition** you have developed and **the results** it produces. **Do not simply post a picture of something you want and ask other users to tell you how to achieve it.** ---
**Author:** ![ZAFMike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zafmike/32/27663_2.png) [@ZAFMike](https://forum.manager.io/u/ZAFMike)\ **Post date:** [April 22, 2023, 7:54am UTC](https://forum.manager.io/t/vat-annual-summary/46641/4 "2023-04-22T07:54:39Z")
@Patch, thank you for the info. All a bit Greek to me. Not an accountant, but I will have a look. @eko, my apologies. I will post more screenshots of what I get when I try various options. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [April 22, 2023, 1:19pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/5 "2023-04-22T13:19:32Z")
I do not believe you will be able to create the custom report you want. Custom reports deal with individual postings to the general ledger. Your example deals only with totals. Additionally, you have columns for breakdowns that do not exist in Manager’s tax scheme (Penalty and Interest), but would need to be separately accounted for. (I am not saying Manager cannot record them, only that they are unassociated with the tax scheme.) Then you want processed results (Account balance) of everything on a line, which custom reports do not offer. Sometimes, we must accept that our desires for specialized presentations of accounting data require work outside Manager. In my experience, this is always so. ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [April 22, 2023, 1:51pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/6 "2023-04-22T13:51:03Z")
I don’t think you need that report since the report will be the same as the one provided by the tax office in your taxpayer portal. ---
**Author:** ![ZAFMike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zafmike/32/27663_2.png) [@ZAFMike](https://forum.manager.io/u/ZAFMike)\ **Post date:** [April 22, 2023, 7:58pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/7 "2023-04-22T19:58:20Z")
Many thanks for the reply. I completely understand what you mean. Manager is a fantastic program with an abundance of features. This report is something I can live without. ---
**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:** [April 23, 2023, 1:13pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/8 "2023-04-23T13:13:12Z")
@ZAFMike, why not use the built-in `Tax Reconciliation` report? It details the movements in the tax account. There’s a total for `New tax liability` which correspond to “Return” in your tax statement, there’s also a separate line for `Payments` and another for `Other movements` which includes any penalties. ![Screenshot_20230423-161051~2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/5/c5344057e88d36e6d7cbf1300bb99379528c70ee.png) The layout may be a bit different from the statements you get from your tax authorities but the content is more or less the same. Please give it a try and tell me if it solves your problem. ---
**Author:** ![ZAFMike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zafmike/32/27663_2.png) [@ZAFMike](https://forum.manager.io/u/ZAFMike)\ **Post date:** [April 23, 2023, 6:31pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/9 "2023-04-23T18:31:21Z")
@Ealfardan, this is exactly what I was looking for. Thank you very much for this!! It just shows you that sometimes you have to RTFS (Read The Freaking Screen). The comparative columns is what was missing. Again, thank you very much. ---
**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:** [April 23, 2023, 11:11pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/10 "2023-04-23T23:11:21Z")
You’re welcome. ---
**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:** [April 23, 2023, 11:11pm UTC](https://forum.manager.io/t/vat-annual-summary/46641/11 "2023-04-23T23:11:26Z")
Closed on April 23, 2023, 11:11pm UTC