Bank feed for Share Trading Account - match to existing transactions incl both Receive Money & Spend Money

Hi Karen_K,

 

Thanks for explaining that. What you’re seeing makes sense. Because bank feed matching works by transaction direction, a deposit/credit can only match to money-in transactions and a withdrawal/debit can only match to money-out transactions. So if your broker settles a mix of share sales and share purchases as one net lump sum a couple of days later, MYOB won’t be able to offset the Receive Money and Spend Money entries against each other directly in Bank feeds. In this situation, the cleaner option is usually to record the net settlement as the actual bank transaction, or use a clearing account for the individual buy/sell entries, then transfer the net amount through to the bank account when the lump sum hits. That way, the bank feed is matching the real net bank movement, rather than trying to match gross buys and sells separately. If you’ve already recorded the individual Receive Money and Spend Money transactions straight to the bank account, Bank feeds may not be able to match them the way you expect, because it doesn’t combine opposite-direction transactions into one match.

 

These help pages should be useful:

• Matching bank transactions
• Matching a bank feed to multiple transactions
• Allocating bank transactions

 

Regards,

Sai