cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Dong X
Level 1

Bank transaction split to a Transfer and an Expense?

Scenario:

Bank Acc G (in GBP) transferred amount X of EURO into Bank Acc E (in EUR). Bank G only keeps GBP here thus the EURO was changed from GBP on a certain exchange rate and charged a fee, total one GBP transaction showing on the Bank Acc G feed.

 

What we hope:

When matching, we could split this single transaction into: a transfer part + an Expense for the fee.

 

But QBO does not allow this. We have searched the community here multiple times, seeing similar questions but didn't find a good answer to it.

 

Question:

How would you handle this? We could split into two expenses, but a transfer really isn't an expense. We could match to a journal record, but it seems equivalent to a split on expenses. I understand "transfer" is only a syntax sugar in that it's just a debit and a credit involves two accounts. But if possible in the QBO marked clearly as Transfer is still better for the eye and preferred. Any suggestions?

 

Thanks in advance for any helps, sorry if this has been answered in other threads, tried to read lots and still not clear.

 

Best,

Dong 

Solved
Best answer July 31, 2020

Accepted Solutions
Ryan_M
Moderator

Bank transaction split to a Transfer and an Expense?

Hi @Dong X,

 

Allow me to share insight on your query about matching bank transactions. 

 

What you mentioned about creating a journal entry is correct. I suggest taking this step to account for the difference. 

 

You can refer to this article as well: Record commonly-used transactions. Click the Split transactions link to show the steps on how you can record a split transaction, which is another option for you in this situation. 

 

In case you encounter issues downloading your bank transactions, you can import these transactions by hand. Take a look at this article for additional details: Manually upload transactions into QuickBooks Online. It's a step by step guide on how you can import either a CSV or a QBO file from your bank to your QBO company. 

 

I'll be around in case you need further assistance. Post a comment below, and I'll get back to you. 

View solution in original post

2 REPLIES 2
Ryan_M
Moderator

Bank transaction split to a Transfer and an Expense?

Hi @Dong X,

 

Allow me to share insight on your query about matching bank transactions. 

 

What you mentioned about creating a journal entry is correct. I suggest taking this step to account for the difference. 

 

You can refer to this article as well: Record commonly-used transactions. Click the Split transactions link to show the steps on how you can record a split transaction, which is another option for you in this situation. 

 

In case you encounter issues downloading your bank transactions, you can import these transactions by hand. Take a look at this article for additional details: Manually upload transactions into QuickBooks Online. It's a step by step guide on how you can import either a CSV or a QBO file from your bank to your QBO company. 

 

I'll be around in case you need further assistance. Post a comment below, and I'll get back to you. 

Dong X
Level 1

Bank transaction split to a Transfer and an Expense?

Hi Ryan,

 

Thanks a lot for the quick reply. To summarise what I learned:

 

Option 1: Simply use Split on Expenses

Pros: easy

Cons: A transfer was mis-marked as expenses

 

Option 2: Create a journal record, debit "Exchange Fee" expense, debit EUR, credit GBP. Then match this to the bank feed transaction on GBP.

Pros: ?

Cons: It still shows the transfer as an expense, seems just like option 1.

 

From what you suggest, 

Option 3: we do not import this single transaction from the bank feed, and create two separate transactions instead, use one to match the transfer, use another to match the fee.

Is this allowed in accounting practise? Do people normally do this?

 

Thanks once again,

 

Best,

Dong

Need to get in touch?

Contact us