# Am I able to get a report of all the GST transactions **URL:** \ **Category:** Uncategorized\ **Created:** [April 26, 2018, 10:11pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639 "2018-04-26T22:11:15Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 26, 2018, 10:11pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/1 "2018-04-26T22:11:15Z")
Am I able to get a report of all the GST transactions not just the dates but what the entries were for example Date Bank entry Total Purchases Tax Paid 01/01/2018 Micheal motors 177.64 23.17 would this be a custom report? if so How do I do it ---
**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:** [April 26, 2018, 11:23pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/2 "2018-04-26T23:23:43Z")
there is the Tax Transactions report - will that do? What are you trying to accomplish? ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 26, 2018, 11:37pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/3 "2018-04-26T23:37:24Z")
The Tax transaction report does not give you the bank description entry. One of my clients wants a report that shows hime the date the bank payee/payer the amount the gst the total amount ---
**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 27, 2018, 1:06am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/4 "2018-04-27T01:06:49Z")
It is hard to understand the format you want because your example has no formatting. But what you posted seems to imply the “Michael motors” is the entry under “Bank entry.” If so, that is exactly what the Tax Transactions report provides. In your second post, you say the Tax Transactions report does not give the “bank description entry.” What do you mean by that phrase? You go on to say your client wants “bank payee/payer”, which again suggests the Tax Transactions report gives you want your client wants. But you also tacked on the total amount, which you did not mention in your first post. The report does not give a total. You would have to export and manipulate data in a spreadsheet. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 27, 2018, 3:23am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/5 "2018-04-27T03:23:45Z")
I would be quite happy if it did not have a total I want something like a bank transaction report but showing the Tax on each entry ---
**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 27, 2018, 3:39am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/6 "2018-04-27T03:39:21Z")
How does the Tax Transactions report not provide what you ask? ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 10:18pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/7 "2018-04-29T22:18:55Z")
It does not have the payee/description it just has the Date, Total Sales, Tax Collected, Total Purchases,Tax Paid ---
**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 29, 2018, 10:39pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/8 "2018-04-29T22:39:22Z")
I think you are looking at the Tax Summary, which has these columns: ![21%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/1/16c31634c15292895508931008fedfeb3ae6bc4c.png) The Tax Transactions report has these: ![27%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/8608d0bd3807de768f1e00294374f9812fb634df.png) So for every transaction you have the Date, Payer or Payee, reference number if there is one, Total Sales, Tax Collected, Total Purchases and Tax Paid, all as appropriate. If you have more than one tax code, you will see each tax code separately. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 10:45pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/9 "2018-04-29T22:45:12Z")
Thats Odd Tut I dont have the text part have I done something wrong. Where would I start to look to find why? All entries were down loaded with the bank statement. ---
**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 29, 2018, 10:57pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/10 "2018-04-29T22:57:11Z")
Look at some of the transactions. Are there customers/suppliers/payers/payees listed? Or did you import a bank statement that did not include that information and neglect to edit the entries? ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 10:59pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/11 "2018-04-29T22:59:21Z")
This is a screen shot of the Bank Transactions after down load ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/cea08d27c8aa07dfe55940b3663ef4dc89ab2275.png) it works on the north wind one but not on mine ---
**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 29, 2018, 11:04pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/12 "2018-04-29T23:04:39Z")
As I suspected. The `Contact` column corresponds to the supplier/customer/payer/payee. Your bank’s `Description` looks to be the equivalent. So if you edit those transactions to complete the forms, the information will show up. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 11:10pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/13 "2018-04-29T23:10:58Z")
I am not sure what you mean the contact column. The headings in the csv file have to be Date description amount so you can import it. The tax transaction report looks like this ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/4/42b0c9d170c9d3689945f9f61a893ac76c75884a.jpg) ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 11:16pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/14 "2018-04-29T23:16:44Z")
screen shot of bank tranactions ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/3/35637d23fd7a36e5ef60046f7dffd911b1a3cfd1.png) ---
**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 29, 2018, 11:18pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/15 "2018-04-29T23:18:20Z")
> [@Wornout](#): > > I am not sure what you mean the contact column. I am referring to the column labelled `Contact` on the screen shot you posted of the uncategorized transactions from an imported bank statement. It is just to the left of the `Amount` column and is blank in your first screen shot. Since you have no contact information for your transactions, the column does not appear in the listing of your Bank Transactions tab either. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 11:20pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/16 "2018-04-29T23:20:02Z")
Sorry Tut That was my mistake I did a screen shot of the north wind one and not my real one . The real one is above ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 29, 2018, 11:28pm UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/17 "2018-04-29T23:28:02Z")
So I just added another column called contact in my csv file and filled it out and imported it and it still did not fill in the contact column ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 30, 2018, 12:07am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/18 "2018-04-30T00:07:16Z")
Could this be a bug??? I have 20 business and they are all the same and I am using the latest version of manager ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [April 30, 2018, 3:01am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/19 "2018-04-30T03:01:09Z")
So does anyone have an answer ---
**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 30, 2018, 3:02am UTC](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639/20 "2018-04-30T03:02:26Z")
You can’t add the column to the CSV file. As I already said, you need to edit the transactions themselves so the records have names. No, it isn’t a bug. [Next page](https://forum.manager.io/t/am-i-able-to-get-a-report-of-all-the-gst-transactions/15639.md?page=2)