# Including all related transaction in Customer/Supplier Statements **URL:** \ **Category:** ideas\ **Created:** [July 28, 2018, 8:41am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066 "2018-07-28T08:41:33Z")\ **Posts on this page:** 13\ **Page:** 1
**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:** [July 28, 2018, 8:41am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/1 "2018-07-28T08:41:33Z")
Hello @lubos hope you are doing fine. We have recently encountered a problem with the sales tax authorities regarding the accounts statement mismatch between ours and our customers. the issue is because we are using Special Accounts to manage customer deposits which does not reflect on the Customer Transactions report. recording the deposit directly to the _Accounts receivable_ account affects the Balance due every time an invoice is generated. as per the instructions received from the sales tax authorities, a deposit is still a transaction between the company and the customer, irrespective of the purpose of the transaction, which should be shown on the customer and supplier statements. i would like to know your opinion about this and how it can be implemented in Manager. some ideas are below. 1. show a sub-account (created in the chart of accounts) along with the list of invoices both for _Accounts receivable_ and _Accounts payable_. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/8cdacb84f63c1f81949f73af341f26688cb39be2.png) 2. if using Special Accounts, ability to select a Customer / Supplier, which would reflect on the transactions report. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [July 28, 2018, 9:53am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/2 "2018-07-28T09:53:11Z")
Great idea. Something like capital subaccounts. It would be useful also for “proforma” registration ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [July 28, 2018, 4:15pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/3 "2018-07-28T16:15:26Z")
> [@sharpdrivetek](#): > > because we are using Special Accounts to manage customer deposits which does not reflect on the Customer Transactions report. One solution (work around) could be this - transfer the deposit from the Special Account to the Customer’s account as required so that it shows as an accounts receivable transaction rather then being a line adjustment within the Sales Invoice. This could be done via a Credit Note or Journal Entry, depending which ever displays best. The one issue could be timing differences - Customer shows payment to you on their June Statement and you show the “receipt” (transfer) from them on your July Statement. ---
**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:** [July 28, 2018, 4:35pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/4 "2018-07-28T16:35:16Z")
Never had a doubt as to how to transfer it to the Accounts receivable… the purpose is to exactly match our statement with that of customer or supplier without any timing differences… A deposit from a customer or to a supplier maybe held for more than a year or so… but since the tax returns are filed monthly or quarterly, the statements need to be issued accordingly with the correct total of debits, credits and number of transactions… ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [July 28, 2018, 4:41pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/5 "2018-07-28T16:41:06Z")
Another solution could be having different classes of invoices ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [July 28, 2018, 5:39pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/6 "2018-07-28T17:39:37Z")
The situation here is that the Customer / Supplier are not recording their transactions as opposites. If you are recording the payment as a Deposit (non Accounts Receivable) then perhaps the customer could do the opposite, record their payment as a Prepayment instead of an Accounts Payable transaction. If the deposits need to be stored as accounts receivable transactions then perhaps the Sales Invoices need a tick box, “Don’t apply outstanding credits” or the opposite, outstanding credits are ignored until a tick box, “Apply outstanding credits”, with a dropdown showing credits. > [@sharpdrivetek](#): > > recording the deposit directly to the Accounts Receivable account affects the Balance due every time an invoice is generated. Agreed, but this must equally apply to the Customer - recording the payment directly to the Accounts Payable account affects the Balance due every time an invoice is received. Perhaps you could approach a Customer and see if you can implement harmonised processing. ---
**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 28, 2018, 10:18pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/7 "2018-07-28T22:18:20Z")
I’ll mark it as an idea because I recognize this as a problem. There are some improvements I’m thinking about when it comes to invoice matching and they would be solving this issue. ---
**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:** [January 1, 2019, 5:14am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/8 "2019-01-01T05:14:00Z")
Hello @lubos A very happy new year to you. Just wanted to know if there has been any progress regarding this problem. Have been facing a lot of problems recently due to this. It is really difficult to manage when the number of customers and transactions increase steadily. ---
**Author:** ![maldroubi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maldroubi/32/19323_2.png) [@maldroubi](https://forum.manager.io/u/maldroubi)\ **Post date:** [September 12, 2020, 2:51pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/9 "2020-09-12T14:51:31Z")
@lubos is there is any upcoming update ? still we are facing problem with invoices marked “PAID IN FULL” we need solution for payments and receipts that not belong spot with invoices ---
**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:** [September 12, 2020, 3:39pm UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/10 "2020-09-12T15:39:07Z")
> [@maldroubi](#): > > is there is any upcoming update ? There are updates very frequently, sometimes more than one per day. What exactly are you asking about this 2-year-old thread? > [@maldroubi](#): > > still we are facing problem with invoices marked “PAID IN FULL” What problem? You have not been part of this discussion, yet you say, “still we are facing problem…” > [@maldroubi](#): > > we need solution for payments and receipts that not belong spot with invoices Can you please clarify this statement? A solution for what? ---
**Author:** ![ibadlon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibadlon/32/37479_2.png) [@ibadlon](https://forum.manager.io/u/ibadlon)\ **Post date:** [December 6, 2022, 6:15am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/11 "2022-12-06T06:15:58Z")
hi all, please allow me to revive this 2 year old IDEA with 2 Inputs. 1. _UNALLOCATED PAYMENTS/RECEIPTS_ > [@maldroubi](#): > > we need solution for payments and receipts that not belong spot with invoices @Tut I believe what was meant on this is that if we can have a solution that would show a list of _Unallocated_ Payments/receipts. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/2/12d0e31dd9acfc3657297fcdfa8f6b20117a6efe.png) In the above image related to a customer, you see that they have available credits as they have paid extra. But if you check the transactions, there will be a lot and its difficult to know which one is linked/belong to an invoice. Its time consuming to go back and see which one is linked or not. 1. _LIST AS PER TRANSACTION TYPE_ Request to show the transactions linked to a customer/supplier per its transaction. At the moment, I cannot see any Payments tagged to expense account rather than accounts payable. ---
**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:** [December 6, 2022, 6:37am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/12 "2022-12-06T06:37:02Z")
> [@ibadlon](#): > > its difficult to know which one is linked/belong to an invoice. Why does it matter? The Sales Invoices or Purchase Invoices tabs show you which invoices are paid in full or overpaid. Unallocated money is available for any future invoice. > [@ibadlon](#): > > At the moment, I cannot see any Payments tagged to expense account rather than accounts payable. That is because payments are not tagged to expense accounts. The purchase invoice does that. Subsequent payments are only tagged to _Accounts payable_. That is basic accounting. ---
**Author:** ![ibadlon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibadlon/32/37479_2.png) [@ibadlon](https://forum.manager.io/u/ibadlon)\ **Post date:** [April 10, 2023, 10:39am UTC](https://forum.manager.io/t/including-all-related-transaction-in-customer-supplier-statements/17066/13 "2023-04-10T10:39:07Z")
Hello developers. I hope you could check and re-evaluate my above request as I am not sure if this thread being marked under ideas includes my inputs in it. 1. _UNALLOCATED PAYMENTS/RECEIPTS_ ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/8/58dee0e429c7fc2cb06a0f879206a29433e807e3.png) @lubos, I see that it does show under Accounts Column in Receipts tab the invoice to which it is applied to. Is it possible that this column be added in the table when opening a Customer in Customer Tab? This will at least let us know that a certain receipt is not yet applied to any invoice. 1. _LIST AS PER TRANSACTION TYPE_ > [@Tut](#): > > The purchase invoice does that. Subsequent payments are only tagged to _Accounts payable_. That is basic accounting. I think what you have mentioned here is not entirely correct. While it is true that _Purchase Invoice_ can be against Expenses and subsequent payments are made through payments tab, it is not wrong and against _basic accounting_ if you use directly use payments tab to record this expenses. > [@Tut](#): > > That is because payments are not tagged to expense accounts. Moreover, what i meant is not only payments tagged to expenses. There are other forms of payment. The request that I have mentioned above is to be able to see transactions linked to a customer/supplier. @lubos , I hope you could consider adding a column in Suppliers/Customers Tab that lists all receipts/payments done.