cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
jb-plan-co-uk
Level 1

How can I split a transfer to show bank charges associated with the transfer?

When we make payments between accounts in different currencies, the sending bank and the receiving bank both levy fees, so the amount received is less than the amount sent. Quickbooks imports the transaction as a credit net of these fees, and you can't split a transfer. How do we record the fees? For example, say we transfer £10,000 from Natwest to our Euro account with HSBC. The amount of Euros is €11,600. Natwest charges £25 for making the transfer, and HSBC charges EUR30 to clear the funds (€60 in total). The imported HSBC transaction shows the transfer was for €11,540 which is wrong as the accounts will not show the bank charges.
1 Comment 1
Ivan_G
Moderator

How can I split a transfer to show bank charges associated with the transfer?

Thanks for dropping your concern here in the Community, Jb. Please know that entering a split transfer and amounts with different currencies is not an option in QuickBooks Online (QBO). I'm here to share more information and alternatives regarding this.

 

Since generating a split transfer is unavailable, we can create an expense for the bank charges as a workaround. To do so, we'll need to set up an account for both Natwest and HSBC charges. Then, use it to account for and record the fees in QBO.

 

Here's how to set up the account:

 

  1. Go to the Gear icon and select Chart of accounts.
  2. Click New and enter an Account name.
  3. Select Expenses as the Account type and Bank Charges as its Detail type.
  4. Once done, hit Save.
  5. Follow Steps 1-4 to generate accounts for both Natwest and HSBC charges.

 

Following that, let's create an expense transaction for the fees. You may seek assistance from an accounting professional to initiate this accurately in the program.

 

  1. Go to the + New menu and select Expense.
  2. Select an account from the Payment account field. In your case, use the HSBC account since it's the withdrawing account for the fees.
  3. Leave the Payee field blank and proceed to the Category details section.
  4. Choose the account you've generated for the Natwest fees on the first item line and the HSBC fees account on the second line.
  5. Enter their designated charged values in the Amount column.
  6. Once done, hit Save and close.

 

Regarding the imported HSBC transaction on your bank feed, we can exclude it and manually enter the transferred amount in QuickBooks. This way, it can be documented accordingly in the system.

 

To exclude the data from your For review tab, please follow these steps:

 

  1. Go to Transactions and select Bank transactions.
  2. On the For review tab, look for and select the downloaded transfer.
  3. Hit the Exclude option.

 

After this, manually record the transfer in QBO. To help you with this, please refer to the Record a new transfer section from this link: Transfer funds between accounts.

 

Finally, once you're ready to reconcile your account, this article could guide you on its proper and seamless procedures: Learn the reconciliation workflow in QuickBooks.

 

If you require additional assistance with handling the bank fees and transfers or other QuickBooks data, you can add a comment below. I'm always here and ready to assist you.