Suspiscious Arthmetic

mawigmore's Avatar

mawigmore

03 Aug, 2025 12:58 PM

Can anyone explain what type of arithmetic is being used here in the Bank Register of an investment account please?

  1. 1 Posted by mawigmore on 02 Oct, 2025 12:54 PM

    mawigmore's Avatar

    Bump

  2. 2 Posted by dwg on 02 Oct, 2025 12:57 PM

    dwg's Avatar

    Looking at the sort order is the first thing to do.

  3. 3 Posted by mawigmore on 02 Oct, 2025 12:58 PM

    mawigmore's Avatar

    It's sorted by date, in the order of the transactions.

  4. 4 Posted by Stuart Beesley ... on 02 Oct, 2025 01:46 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    My guess is that you are seeing the total cash balance, but only the txns that are bank type. Look in the main register.

  5. 5 Posted by mawigmore on 03 Oct, 2025 10:15 AM

    mawigmore's Avatar

    In the main Register the last column is headed "Cash Balance", but in the
    Bank Register it's just "Balance". Are these supposed to be different or
    both cash?

  6. Support Staff 6 Posted by Maddy on 03 Oct, 2025 10:33 AM

    Maddy's Avatar

    @mawigmore

    The Cash Balance is a system-generated, non-editable field reflecting the account’s cash balance post-transaction, calculated according to the register’s sort sequence.

    For more information about Investment Account Registers, please refer to this article of the Knowleddge Base.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  7. 7 Posted by dwg on 03 Oct, 2025 10:48 AM

    dwg's Avatar

    Accounts are composed of transactions as you know

    There are two different Views you can have of an Investment account

    1. Investment Register view.

    This shows all transactions that are in the register, but it does not show any bank specific type data, so all Bank type transactions are shown as Xfr transactions.

    2. Bank Register View.

    This looks the same as a Bank account register, and shows that type of data only.

    Hence in the Bank register view you will not see all transactions, there will be no Investment specific transactions. As such any balance shown will not reflect the real balance in the account.

    The aim of the Bank Register view is there to facilitate those types of Investment accounts that facilitate bank type transactions. It can also be used to facilitate cross currency transactions with investment accounts.

  8. 8 Posted by dwg on 03 Oct, 2025 09:32 PM

    dwg's Avatar

    In an ideal world I would not have the Bank register showing a balance in an Investment Account, I am thinking the program is using the standard bank register code to render the display, so that is what you get.

  9. 9 Posted by mawigmore on 04 Oct, 2025 07:51 AM

    mawigmore's Avatar

    Yes, it does seem to be an inelegant kludge to allow the entry of purely
    cash transactions.

  10. System closed this discussion on 03 Jan, 2026 08:00 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

11 May, 2026 10:31 AM
11 May, 2026 08:17 AM
11 May, 2026 03:08 AM
11 May, 2026 03:03 AM
11 May, 2026 02:31 AM