# Editing a reconciled bank transaction (suggestion) **URL:** \ **Category:** Uncategorized\ **Created:** [November 13, 2018, 1:31am UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081 "2018-11-13T01:31:38Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Tsesebe](https://avatars.discourse-cdn.com/v4/letter/t/5f9b8f/32.png) [@Tsesebe](https://forum.manager.io/u/Tsesebe)\ **Post date:** [November 13, 2018, 1:31am UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/1 "2018-11-13T01:31:38Z")
Suggestions regarding editing reconciled bank transactions. Import a bank statement - using bank rules. Do a bank reconciliation - success Subsequently discover that a receipt/payment needs to be split. (eg a fee needs to be recorded) Go into edit - change the allocation amount on the existing line and add a new line of information The total of the the two lines should be the same as the original imported entry otherwise there is no longer a bank reconciliation. 1 The original receipt or payment amount is not shown on the screen - can this be done to avoid spoiling the bank reconciliation? 2 Maybe a warning that the edited transaction does have the same balance as the original? And the difference? 3 Maybe a warning if the edited transaction will cause the successful bank reconciliation to fail? 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:** [November 13, 2018, 8:29pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/2 "2018-11-13T20:29:57Z")
I agree this is an issue. One way to solve this would be to introduce new field called transaction total or similar. Then line items total would be required to match this total. If line items don’t add up to total, difference would be posted to `Suspense` account rather than changing transaction total. ---
**Author:** ![tony](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tony/32/17755_2.png) [@tony](https://forum.manager.io/u/tony)\ **Post date:** [November 13, 2018, 11:11pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/3 "2018-11-13T23:11:08Z")
I like that idea. It would avoid copying the original transaction amount to another section for cross check to the total of the new lines. Perhaps the transaction total of imported bank account transactions can be set to read only. ---
**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:** [November 13, 2018, 11:19pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/4 "2018-11-13T23:19:50Z")
You might also consider a red difference figure like in journal entries. ---
**Author:** ![Tsesebe](https://avatars.discourse-cdn.com/v4/letter/t/5f9b8f/32.png) [@Tsesebe](https://forum.manager.io/u/Tsesebe)\ **Post date:** [November 14, 2018, 2:17am UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/5 "2018-11-14T02:17:59Z")
Thanks Lubos. A field called “transaction total” is good. Initially in BLACK? If there is no balance it should be in RED If the Edit is accepted without a balance then Manager should/could add a balance entry allocated to Suspense. Cheers ---
**Author:** ![Hennie](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/hennie/32/7312_2.png) [@Hennie](https://forum.manager.io/u/Hennie)\ **Post date:** [June 2, 2020, 6:04pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/6 "2020-06-02T18:04:22Z")
When I import bank transactions, I have to allocate these transactions. When the transaction is allocated to one G/L account, supplier or customer, it is no problem. However when the transaction has to be split into two or more transactions a problem might arise. Suppose I receive € 1000 that needs to be allocated to three different accounts. The moment I change the amount on the first line to e.g. € 300,- for the first account, I still need to allocate the remaining € 700,-. Manager doesn’t tell me the remaining balance to be allocated. Suppose I allocate another € 300,- and finally the last allocation of € 500,- I allocated € 100,- too much. Manager doesn’t warn me that I have over-allocated € 100,-. The result is that my bankbalance in Manager is wrong. It would be great if Manager would tell us the remaining balance to be allocated so that it prevents the users from making mistakes. It would be great if Manager would only accept the transaction if the remaining balance is zero. It took me a couple of hours to find the mistake made by one of my clients. Is there a change that this could be implemented because this risk affects ALL users. ---
**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:** [June 2, 2020, 6:40pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/7 "2020-06-02T18:40:54Z")
@Hennie, I’ve combined your suggestion with this existing ideas topic. This would be very much like the current feature showing imbalance on journal entries. ---
**Author:** ![Tsesebe](https://avatars.discourse-cdn.com/v4/letter/t/5f9b8f/32.png) [@Tsesebe](https://forum.manager.io/u/Tsesebe)\ **Post date:** [June 2, 2020, 10:47pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/8 "2020-06-02T22:47:37Z")
I have a work around for this problem which is not great but helps to avoid the bank rec problem. Go to Settings- Custom Field - Payment or Receipt - New Custom Field Call it “Original Value” or whatever A new field will appear on all Receipts and Payments Most of the time I ignore the field but if I need to split an allocation I firstly enter the original amount in that field and after splitting the allocation double check. Since this I have avoided mucking up the bank rec. ---
**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:** [December 17, 2021, 7:01pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/9 "2021-12-17T19:01:40Z")
Added to the latest version (21.11.77). Both receipts and payments have new `Fixed total` field. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/5/d5781c37080e5ecd2b7564866d210706a8e5489b.png) When importing bank statements, this field will be automatically checked and transaction total filled in. This will make sure receipt and payment total will be always this amount even if split total on transaction lines is different. If fixed total amount does not match split total amount, the difference will show in `Out of balance` field. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/8/d8b06cded039bd617456c6403db584c3c9ad6701.png) Out of balance amount will be posted to `Suspense` account. Similar how we handle out of balance journal entries. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [December 17, 2021, 8:40pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/10 "2021-12-17T20:40:07Z")
A nice addition. I have always minimised the chance of errors by using Managrrs feild arithmatic. - add a second line - Enter the correct amount in the second line - copy that amount - goto the first line amount cell type minus “-“ then paste the copied amount - total balances again. - the procedure can be repeated for multiple lines I assume the user can over ride this total. I sometimes combine payments into one. My bank limits the maximum transaction I can do. I Combine the part transaction into one then split that over multiple lines depending on the details of the actual purchase. ---
**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:** [December 17, 2021, 8:59pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/11 "2021-12-17T20:59:52Z")
@Patch that would work for tax inclusive amounts without using qty / unit price which I suspect would be most transactions but not all. Also, you need to think what you are doing and not lose trail while making splits. This addition requires a little less thinking while editing transactions which is a good thing. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [December 17, 2021, 9:03pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/12 "2021-12-17T21:03:59Z")
Agree Manager shows the calculation in each cell so keeping track is not that hard. It adds another level of checking similar to continuing to use reconciliation each quarter. ---
**Author:** ![Tsesebe](https://avatars.discourse-cdn.com/v4/letter/t/5f9b8f/32.png) [@Tsesebe](https://forum.manager.io/u/Tsesebe)\ **Post date:** [December 17, 2021, 10:47pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/13 "2021-12-17T22:47:15Z")
Thank you Lubos. Just tested this improvement out and it is great. I can now delete the custom field work around. Thanks again. ---
**Author:** ![Hennie](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/hennie/32/7312_2.png) [@Hennie](https://forum.manager.io/u/Hennie)\ **Post date:** [December 18, 2021, 1:26pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/14 "2021-12-18T13:26:21Z")
@lubos Thanks for this feature. It reduces a very potential risk on mistakes. ---
**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 20, 2021, 2:08am UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/15 "2021-12-20T02:08:00Z")
Split this topic on December 20, 2021, 2:08am UTC 3 posts were split to a new topic: [Help with setting up Manager](https://forum.manager.io/t/help-with-setting-up-manager/38796) ---
**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, 2:44pm UTC](https://forum.manager.io/t/editing-a-reconciled-bank-transaction-suggestion/19081/16 "2023-01-18T14:44:00Z")
Closed on January 18, 2023, 2:44pm UTC