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 l…

Added to the latest version (21.11.77). Both receipts and payments have new Fixed total field. [image] 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 t…

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 tota…

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.

You might also consider a red difference figure like in journal entries.

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

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 need…

@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.

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…

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 r…

@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…

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.

Editing a reconciled bank transaction (suggestion)

Uncategorized

Topic		Replies	Views
Check on banktransactions Uncategorized	1	573	June 5, 2020
Split transaction -> keep total Uncategorized	5	1266	November 25, 2020
Bank transactions Uncategorized	4	656	October 18, 2017
Can change bank download amount! Uncategorized	6	758	December 21, 2021
Split transactions for Bank Rules Uncategorized	19	3112	March 28, 2022

Editing a reconciled bank transaction (suggestion)

Related topics