Skip to main content
Question

Credit card transaction processing


Forum|alt.badge.img

Hi,

 

If we set up an NZD credit card in the system and configure a bank feed in MYOB Advanced, how can we ensure that all AUD purchases are accurately recorded as cash transactions processed through the bank feed transactions?

 

Thanks 

 

 

7 replies

WillH
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 48 replies
  • July 2, 2024

Hi @pankaj65  - 

Is your company a MYOB NZ or MYOB Australia customer?  It has some impact on the licensing of the system, and in turn bank feeds.

Regards,

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 15 replies
  • July 2, 2024

Hi @WillHowardOpenUni 

It’s MYOB NZ Customer.  Could you please advise if there’s something can be done in the system to handle the scenario and correctly capture transaction as a cash transaction in AUD currency with AU tax ?

Thanks.


WillH
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 48 replies
  • July 2, 2024
pankaj65 wrote:

Hi @WillHowardOpenUni 

It’s MYOB NZ Customer.  Could you please advise if there’s something can be done in the system to handle the scenario and correctly capture transaction as a cash transaction in AUD currency with AU tax ?

Thanks.

You should be able to record this at Process Bank Transactions (CA306000 )

Just select the transaction from your bank statement/feed, then choose Create Payment on the right and select the create payment option.

You can either immediately assign the value to an invoice (You can use the Cross Rate field to change the exchange rate to reflect the exchange rate you got on the day) or you can leave the payment as paid in NZD and then apply the payment to the invoice later, depending on what best suits your process.
 

Note: It’s been awhile since I tried to record a transaction that way.  Your exact settings around currency management might have an impact here.  If you’re unsure I’ll hope either another user has a comment for you, or if you get in touch with your implementer/support team they should be able to help get processes set up with you.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 15 replies
  • July 2, 2024

Hi @WillHowardOpenUni,

 

Thank you for addressing my query. We are currently partners with MYOB. In reference to the scenario above, I understand that we can process the transaction by using "Process Bank Transaction," create a payment, and apply it to an AP bill.

However, we aim to streamline this process by recording these transactions as cash transactions, given that they are credit card purchases. The challenge arises because we cannot edit the currency in the cash transaction and record it in AUD, whereas the credit card is set up in NZD.

 

Thanks.


WillH
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 48 replies
  • July 2, 2024

Hi @pankaj65 ,

I’m not personally sure of the purpose of recording foreign currency amounts against these transactions if you’re intending to use them as direct cash transactions rather than AP transactions.  
My understanding of reporting is that in that situation, what matters is the local currency effect for the account it’s sent from.

Otherwise, I’m outside my area of expertise and I’d recommend checking with your consultant. (Or hopefully someone else with more experience creating cash transactions directly from CA306000 and potential multicurrency options might be able to help)


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2752 replies
  • August 15, 2024

Hi @pankaj65 were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 15 replies
  • August 15, 2024

Hi Chris,

Although no suitable solutions were found, the client has decided to continue with their original process, which involves creating an AP bill for credit card transactions and processing it.

Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings