Forum Discussion

TimAtOscarPOS's avatar
TimAtOscarPOS
Contributing Cover User
6 years ago

Bank Feeds - Using CARD for Tax Rate and Multiple VOID Lines

I use "non accounting savvy staff" to do our Bank Feeds. So I have set up a number of CARDS they can use to get the right G/L account selected when doing a Spend / Receive Money. The CARD name includes the text that appears in the Bank Feed and the Income / Expense Account is preset. ( eg EXP GIT HUB is set to 6-1230 R&D ).

 

Worked great until I realised "Use Suppliers Tax Code" is ignored :|

 

So now my CARDS all include the TAX to use ( eg EXP GIT HUB (N-T) ).

 

Works great, provided htey make sure the Tax Rate in the CARD Name matches the Spend Money Tax Rate

 

BUT ...

 

If they change the Tax to match, MYOB will automatically add a second transaction line which then gets turned into a VOID in the G/L

 

How do I prevent getting a VOID for every single bank feed transaction across the multiple bank feeds i use ?

 

Did I mention I am slightly OCD and all those VOIDS will be worse than the volume control being set to an odd number ?

  • TimAtOscarPOS 

     

    Welcome to the MYOB Community Forum, I hope you find plenty of useful information.

     

    If you are creating Spend Money transaction from the Bank Feeds why arn't you using the Transaction Rules?

    When a transaction shows in the bank feeds with the memo EXP GIT HUB (N-T) create a new Transaction Rule like this:

     

    The Bank Feed will now create the Spend Money transaction allocated to the correct account with the account Tax Codes as listed in the Chart of Accounts.

    On the subject of Tax Codes - why are you using N-T (Not Reportable)?

     

     

  • GDay53's avatar
    GDay53
    Ultimate Cover User

    TimAtOscarPOS 

     

    Welcome to the MYOB Community Forum, I hope you find plenty of useful information.

     

    If you are creating Spend Money transaction from the Bank Feeds why arn't you using the Transaction Rules?

    When a transaction shows in the bank feeds with the memo EXP GIT HUB (N-T) create a new Transaction Rule like this:

     

    The Bank Feed will now create the Spend Money transaction allocated to the correct account with the account Tax Codes as listed in the Chart of Accounts.

    On the subject of Tax Codes - why are you using N-T (Not Reportable)?

     

     

    • TimAtOscarPOS's avatar
      TimAtOscarPOS
      Contributing Cover User

       

      Transaction Rules might work too - will have a look at them :)

       

      N-T .. coz that's what my bookkeeper said to use - is overseas payment