# Account Amount inclusive Tax in Reports **URL:** \ **Category:** Uncategorized\ **Created:** [May 25, 2021, 6:16am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163 "2021-05-25T06:16:35Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 25, 2021, 6:16am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/1 "2021-05-25T06:16:35Z")
I´ve tried to create a custom report which should show the total amount of an account (including tax) and the amount without tax. But something doesn´t work as you can see on this picture. ![ScreenShot 005](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/5/45160abe8176e07991d7d0a1887c1b162ca3ca63.jpeg) The report never shows the total amount including tax. Is that even possible in Manager? Thanks for your help! ---
**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:** [May 25, 2021, 12:46pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/2 "2021-05-25T12:46:59Z")
You need to post a screen shot of the definition screen for your custom report. No one can tell anything by looking at the result of a report you say is failing. You should also post the Edit screen of a representative transaction you believe is not showing up correctly. ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 25, 2021, 2:17pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/3 "2021-05-25T14:17:16Z")
Hello Tut, thanks for the hint 😇 So here is one transaction. There is nothing wrong with it. It contains the gross price (total) as well as the net price and the tax amount: ![ScreenShot 005](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/c/6c0bdb84907e8c447bce986d3ef63e13f328a274.jpeg) The sticking point is in custom report where I want to show the gross price as well as either the tax amount or the net price. I hoped “account amount” would be the right field for the gross price, but this seems to be the net price. And tax amount isn´t shown anyway: ![ScreenShot 006](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/b/1b3d0fd983799862ac9710a24f86655098cb3a3f.jpeg) ![ScreenShot 007 Freier Journalist Sascha Valentin — Einnahmen-Überschuss-Rechnung](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/8/387b9dc7f117eb141e5fcbabebadbd2360a201a9.jpeg) Hope this makes it a bit clearer. ---
**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:** [May 25, 2021, 5:52pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/4 "2021-05-25T17:52:14Z")
Your basic problem is that you cannot get the information you want directly in a custom report, all on one line for a payment. Custom reports are based on general ledger transactions, so you get amounts posted to individual accounts. The numbers you see on the entry screen are, in some cases, calculated from other inputs. What you call the gross price is not `AccountAmount`. `AccountAmount` is the positive or negative amount posted to a specific account in the chart of accounts. On a taxable line item, that is never the gross price. `Tax Amount` will be the amount posted to a tax liability account. I wonder why you do not use the Tax Transactions report. ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 26, 2021, 7:56am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/5 "2021-05-26T07:56:47Z")
Ah, okay, I see. This doesn´t work as I hoped. And I took a look an the tax transaction report - which is really quite something in the way I´m looking for. Only one thing doesn´t fit: This report only shows the kind of transaction but no description of the account or what was sold/bought. This would be very nice. Sorry, if I bother you that much 😟 ---
**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:** [May 26, 2021, 1:21pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/6 "2021-05-26T13:21:26Z")
I am curious what use you have for gross prices in such a report. Gross prices are not your income. If you describe what you want to use the information for, there may be another way to get it. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [May 27, 2021, 1:02am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/7 "2021-05-27T01:02:39Z")
To experiment I created a test business with a single receipt from a customer and single payment to a supplier. Both have two line item, the payment has a negative line item Receipt from a customer ![21 Receipt from customer](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/d/ad66b435c67f38ab980da55beb8252a078e45676.jpeg) Payment to a supplier ![22 Payment to supplier](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/e/de3987aa45be6b22d8d8b6c6fef7032599bed304.jpeg) Creating a custom report with all the amounts I could find - I suspect differences between AccountAmount, BaseAmount, TransactionAmount become apparent when multiple currencies are used. - General ledges entries at the bank show tax inclusive amounts but not separation of line items - There is “TaxExclusive” options but no “TaxInclusive” options I could find ![23 Amount options](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/0/505ebfa621adf8b04808053f60476cc5b1cdd13d.jpeg) For reference the custom report definition was ![24 Custom report definintion](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/b/fbf9c6e947fad9e61fa690dbf767aabac1448be8.jpeg) ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 27, 2021, 6:18am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/8 "2021-05-27T06:18:16Z")
Hello Tut, I´m using a german tax control software that requires the sales and purchases entered as gross price because it calculates the tax amount and net price itself. That´s the reason why i tried to find out to show the gross price in Manager. Another workaround could be to export a table with net price and tax rate to a spreadsheet and to calculate the gross price there. I also thought about import Managers database (guess it´s SQLlite?) into an ETL software to transform the things I need. ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 27, 2021, 6:26am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/9 "2021-05-27T06:26:47Z")
Hello Patch, thanks for your efforts. Yes, something like `TaxInclusive` as report column would solve my problem the easiest way. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [May 27, 2021, 6:34am UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/10 "2021-05-27T06:34:02Z")
The report you want can be easily created with a report transformation see > [@How to implement country-specific report in Manager](https://forum.manager.io/t/how-to-implement-country-specific-report-in-manager/30543/1): > > - tax\_inclusive\_sales > - tax\_inclusive\_purchases The user interface has been updated since the above thread was created but the cited functions are the same. Unfortunately the current user interface makes it difficult to write program flow control ---
**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:** [May 27, 2021, 12:05pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/11 "2021-05-27T12:05:51Z")
> [@saschavalentin](#): > > Another workaround could be to export a table with net price and tax rate to a spreadsheet and to calculate the gross price there. I believe that is what you will have to do. It is unrealistic to expect Manager to match the needs of some other software. ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 27, 2021, 3:56pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/12 "2021-05-27T15:56:11Z")
I didn’t expect that. Truly spoken, I have used Manager before the other software. I just wondered/hoped if it is possible to save me some time. I really like Manager a lot. Tried some other accounting software, but this is far the easiest and most flexible one. ---
**Author:** ![saschavalentin](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/saschavalentin/32/18506_2.png) [@saschavalentin](https://forum.manager.io/u/saschavalentin)\ **Post date:** [May 27, 2021, 3:59pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/13 "2021-05-27T15:59:17Z")
@Patch Thanks a lot for this advice. Didn’t tried it yet, but I think this should work. Hopefully. 😇 ---
**Author:** ![AJD](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@AJD](https://forum.manager.io/u/AJD)\ **Post date:** [May 27, 2021, 11:33pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/14 "2021-05-27T23:33:42Z")
This is a Custom Report definition that I came up with that might be helpful, but probably not exactly what you want. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/3/431a08dbcabf148348b5ea4c371147b4bcd380dd.png) This is a sample of the output ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/f/bf835a37f7024724788f9486f8b2befae9d7ea76.png) ---
**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:** [July 5, 2026, 8:20pm UTC](https://forum.manager.io/t/account-amount-inclusive-tax-in-reports/35163/15 "2026-07-05T20:20:54Z")
Uncategorized topics older than 3 years with no recent activity