# Tax Transactions Report - Suggestion **URL:** \ **Category:** Uncategorized\ **Created:** [May 17, 2015, 6:41am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890 "2015-05-17T06:41:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 17, 2015, 6:41am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/1 "2015-05-17T06:41:53Z")
On the Tax Transaction Report, it will be better if the following are added On the sales side: Invoice # On the purchase side: Purchase Invoice # Presently only date and the customer name is shown (image attached) ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 18, 2015, 4:37am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/2 "2015-05-18T04:37:54Z")
@lubos Hi there, Can you please incorporate this into the report? This is necessary as the Tax department considers Sales Invoice/Purchase Invoice for their computation. It will be very easy then… Currently we have to export this, then key in the Invoice numbers and then send them as excel sheets, which can be done more professionally if this is incorporated into the report. Kindly look into this… Thanks ---
**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:** [May 20, 2015, 11:01am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/4 "2015-05-20T11:01:58Z")
What country is this for and what exactly do you need to report to tax department? Do they really want you to submit list of all invoices and tax paid? ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 21, 2015, 7:04am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/5 "2015-05-21T07:04:28Z")
Hi Lubos, This is for India. Since we are registered with the State Government for VAT, we need to do monthly filing wherein we need to mention the Sales and Purchases transactions for each month. Also we need to attached the sales invoices and purchase invoices for this monthly returns filing. Tax Transaction Report is the one suited for this, provided it has details of Sales Invoice # and Purchase Invoice # (Purchase Invoice # is manually entered when we book them) besides date. Customer name is optional for this report. Please look into this and see if this can be incorporated. Thank you. ---
**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:** [May 24, 2015, 11:51am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/6 "2015-05-24T11:51:25Z")
But tax transactions report is list of all transactions subject to VAT. Not every transaction is an invoice. Some could be credit notes, debit notes, cash purchases where supplier invoice is not really entered into Manager or even journal entries. So, if your tax authority requires list of sales invoices and purchase invoices for the period, how do they reconcile it to VAT payable/refundable if you’ve received a refund from supplier or gave refund to customer? Refunds are not invoices but do affect your VAT liability. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 25, 2015, 7:35am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/7 "2015-05-25T07:35:43Z")
Hi, Yes, it is a list of all transaction subject to VAT, be it credit or debit. My suggestion was to replace the customer name with the relevant document and its reference, which will be more traceable, by us and the tax authorities. On clicking the “Tax Payable” link from Summary, we are taken to a window which shows the following details… Date - Transaction - # - Description - Contact - Amount - Balance Wouldn’t it be more appropriate if we can have “Date” (already there), “Transaction” and “#” in the Report rather than the contact details? This should solve the problem, I am referring to… On an easier note, Tax authorities are not interested in our customer details, but they take the Transaction and its reference under the lens for their records. 😄 Hope I have cleared myself here… If our wavelengths are matching, kindly do the needful and help us with changes on this report. Thank you! ---
**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:** [May 27, 2015, 2:27am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/8 "2015-05-27T02:27:59Z")
OK, it makes sense now. I’ll add transaction type and reference number (not description due to space constraints). ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 28, 2015, 4:55am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/9 "2015-05-28T04:55:23Z")
Thank you very much… ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [May 29, 2015, 6:05am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/10 "2015-05-29T06:05:15Z")
@lubos Is it possible for you to bring this change on the Tax Transaction Report before 10 June? Since this is the second report for this Financial Year 2015-16 (In India, FY is from April to March), it would be great if we can start using it from this month, as it was NIL during April for me. Last date for monthly Tax filing is 10th of every following month. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [July 20, 2015, 12:12pm UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/11 "2015-07-20T12:12:18Z")
Hello @lubos, any developments on this topic? Would be better if we can have this. With the limited options, I am still exporting this to excel and sending it for monthly filing. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [July 23, 2015, 7:07am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/12 "2015-07-23T07:07:04Z")
@lubos Can you please look into this and give us the new report? In the image, CST is Central Sales Tax payable on purchase (Purchase Invoice) and KVAT is Value Added Tax payable on sales (Sales Invoice). Below are the images of Tax Transaction Report. 1. Current Report 2. Suggested Report 1. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/5/57a43e6b56c3a78bc16bfc6653cdd3341d895158.png) 1. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d509ff17617a3a027851bf0647607b2dfcf50646.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:** [July 26, 2015, 1:04pm UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/13 "2015-07-26T13:04:01Z")
I’m discussing this with number of users and it seems like there are many variations what everyone needs. I think the best solution here is to implement custom reports functionality. This way you would select columns you are interested in rather than me implementing many similar reports one-by-one which would make whole `Reports` tab too crowded with reports you don’t care about. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [July 27, 2015, 2:48am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/14 "2015-07-27T02:48:57Z")
@Lubos, Excellent!! This could be the best solution. Thanks and appreciate for thinking differently. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [October 19, 2015, 2:03pm UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/15 "2015-10-19T14:03:21Z")
@lubos Hi, any updates for us on this topic? ---
**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 20, 2015, 12:59am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/16 "2015-10-20T00:59:59Z")
Custom reports have been implemented, documentation is still missing though. Ask again next week. ---
**Author:** ![aman0478](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@aman0478](https://forum.manager.io/u/aman0478)\ **Post date:** [October 27, 2015, 6:34am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/17 "2015-10-27T06:34:38Z")
Hi Lubos, Can you please share the documents on generating customised tax reports. Thanks Aman ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [November 16, 2015, 2:17pm UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/18 "2015-11-16T14:17:01Z")
Hi @lubos, Any development on this topic? If yes, please share. ---
**Author:** ![anoopchintu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/anoopchintu/32/1067_2.png) [@anoopchintu](https://forum.manager.io/u/anoopchintu)\ **Post date:** [January 6, 2016, 7:17am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/19 "2016-01-06T07:17:54Z")
@lubos How to use the custom reports? Tax Report as of now is of no use… We would need the document reference for audit submission… ---
**Author:** ![ProDev](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/prodev/32/1036_2.png) [@ProDev](https://forum.manager.io/u/ProDev)\ **Post date:** [May 24, 2016, 6:39am UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/20 "2016-05-24T06:39:19Z")
Hi Lubos, This info of invoice No. on the TAX report will be very useful for Zimbabwe. Also if the supplier VAT# could appear on the report. Maybe this is achievable using custom reports, if so please advise. Presently I have to pull out every supplier invoice when doing the VAT submission as the above details are required. If it all was collated on one printout it would very much simplify the exercise. Ciao Neil I’m not an accounts person, so really appreciate using Manager. ---
**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:** [January 18, 2023, 3:33pm UTC](https://forum.manager.io/t/tax-transactions-report-suggestion/2890/21 "2023-01-18T15:33:05Z")