Buy on investment accounts not debiting the bank register

tigs99's Avatar

tigs99

13 Oct, 2018 03:53 PM

I am using 2017.8 but had the issue in 2017.2 as well. When I enter a buy on an investment account it does not debit the funds from the bank register, which then means that the account is overvalued in the portfolio view as it show the value of the shares purchased and the the value of the cash used to purchase them. Funds transferred to the investment account from my bank account to the will credit the bank register and also show in the main register. The buy transaction will debit the main register but not the bank register.

I hope this makes sense.

  1. 1 Posted by mhoggie on 13 Oct, 2018 05:41 PM

    mhoggie's Avatar

    just a user,

    You need to select BuyXfr as the action and your bank account in the "Transfer" field.
    Of course date, description, security as bought

  2. 2 Posted by tigs99 on 14 Oct, 2018 06:16 AM

    tigs99's Avatar

    Hi,

    Sorry, I don’t think I wrote this clearly enough. I am am tank about the bank register view in the Investment Account not in my Bank Account. the money stays in the Investment account.

    I also need to correct myself slightly. The amounts are being debited forth bank account view, bu the transactions themselves are not showing.

    Tigs

  3. 3 Posted by dwg on 14 Oct, 2018 10:04 AM

    dwg's Avatar

    I'm a fellow user.

    The Bank register shows transactions that are valid in that type of register. The Investment register shows transactions that are valid in that sort of register, some types of transactions like standard transfers should be valid in both.

    Transactions like Buys and sells are only valid in the Investment register view, you will not see them when you look at the Bank register view.

  4. 4 Posted by tigs99 on 14 Oct, 2018 10:34 AM

    tigs99's Avatar

    A Buy transaction (differently from a BuyXfr transaction) reduces that cash balance on the account. This should be visible in the Bank register.

  5. 5 Posted by dwg on 14 Oct, 2018 10:42 AM

    dwg's Avatar

    It certainly changes the balance shown at the bottom of the register but there is no transaction when you look at it from the Bank register point of view

  6. 6 Posted by tigs99 on 14 Oct, 2018 10:59 AM

    tigs99's Avatar

    That’s my point. The sum of the increases and decreases does not add up to the balance. It should. this is because any buy or sell transactions that would impact the balance are missing from the view although taken into account in the balance at the bottom.

    They will also be taken into account when any other transaction impacts the balance, so a service charge of £10 can look like it causes a change the balance of £1000's

  7. 7 Posted by dwg on 14 Oct, 2018 08:06 PM

    dwg's Avatar

    The Bank and Investment registers are fundamentally not compatible so it is not possible to format the Investment data in such a way as to make it work in a bank register, each register just shows a partial view of the data. The ability to have the two register types was bought in to allow for those situations where people could do things like write out cheques from a type of investment account.

    If you want to show in a bank register the monies coming out to buy securities then I believe you will have the previous approach that was used when Investment accounts dd not have bank registers and that is to have a separate bank account and to use transfers between it and the Investment account to allow for buys/sells/Dividends etc.

  8. 8 Posted by mhoggie on 14 Oct, 2018 08:54 PM

    mhoggie's Avatar

    just a user,

    I've never found a use for the "bank register" in the investment account. It just seems to be a view of any transactions that move funds to and from your other accounts to the investment account. But that is a bit redundant because the normal investment register will also show that activity along with the security info. I've been happy to ignore the investment bank register for years. Just nothing of value there that I find.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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