JenP's avatar
JenP
Experienced Partner
11 years ago
Status:
Open

Bank Feeds: Automatically apply to oldest payment first (if rule picks up exact amount)

I have just found that in bank feeds if a customer has several outstanding accounts and they pay an exact amount of a more recent account, the invoice rule will pay off that account BEFORE the oldest first.  This is terrible as it has not really upset one of my clients receivables!  I have spoken to myob and they trialed it and found the same thing.  The gentleman suggested I post it here.

 

Can there be a check box or something where the applying to oldest invoice first rule works for the bank feed section to?

 

Thanks

 

"Bank Feed posting"

 

Jen

4 Comments

  • Status changed:
    New
    to
    Open
    Hi Jen, thanks for the feedback, this certainly is the best place to post changes that you'd like to see added into the program. This sort of change is something we're happy to look into so that Bank Feeds are as user friendly as possible, it would be great to see what the rest of the community thinks of this being added.
  • GDK's avatar
    GDK
    Super Partner

    Hi JenP and Matthew_W 

     

    In Purchases Preferences, there is an existing checkbox ""Apply supplier payments automatically to oldest bill first". MYOB development team need to make sure that the settings is applied in bank feeds. This settings is already used in Pay Bills and Pay bill options.

  • ELVS's avatar
    ELVS
    Contributing Cover User

    It would also be useful if a single bank feed transaction (eg customer payment) could be matched to several MYOB entries.

    Here is my example: we supply a company that has several branches (>15), we have set up each branch as a separate customer (so we can issue invoices, statements etc per branch), but the head office pays the monthly statements together as one lump sum. I don't use an undeposited funds account as the funds are depositied from the customer directly to our bank account.

    My work around is to hide the transaction on the bank feeds screen and manual reconcile the transactions in the reconcile accounts screen.

    It seems such a shame to have the great bank feeds function but then have to do it manually.