cancel
Showing results for 
Search instead for 
Did you mean: 
joshuashaneadkin
Level 1

How to split a bank transaction (expense) to multiple locations?

 
34 Comments 34
Nick_M
QuickBooks Team

How to split a bank transaction (expense) to multiple locations?

Good evening, joshuashaneadkin,

 

In order to split your bank transaction into several locations you'll need to enter the expenses into the register. 

 

Here's how:

 

1. Go to Accounting and select Chart of Accounts.
2. Find the account for the transaction.
3. Under the Action column, select View register.
4. Select the transaction, then select Edit. The entry screen for that particular transaction opens.
5. Enter the other accounts to add with the amount. Note: The amounts for each account should add up to the total amount of the transaction.
6. Select Save. The transaction now displays Split in account column.

 

And that's it. If you need more help entering these in, feel free to reach out here. Have a great night!

vpcontroller
Level 11

How to split a bank transaction (expense) to multiple locations?

@joshuashaneadkin 

@Nick_M 

 

"How to split a bank transaction (expense) to multiple locations?"

 

Currently, in QBO, there's no option to divide the Expense transaction into multiple locations. Only the Class you split to multiple locations.

 

The only other option is to write a Journal Entry later to allocate expense transactions to multiple locations.
(To write Journal Entry: Left Dashboard > Create "+ New" > Other > Journal Entry). You should see the Location column if it's ON with Plus or Advanced.

 

Hope this helps!

 

allocation-of-rent-by-locations.PNG

daveyeo
Level 1

How to split a bank transaction (expense) to multiple locations?

Why this feature hasn't been added is beyond me. We should be able to split deposits and expenses by location instead of having to create a separate JE!

azzarello
Level 2

How to split a bank transaction (expense) to multiple locations?

Has anything been done with this yet?  I can't believe we can't split expenses by location.

 

AileneA
Moderator

How to split a bank transaction (expense) to multiple locations?

Hi there, azzarello. 

 

I can see how important and beneficial it's to you and our other valued customers. As of this time, our developer team is working hard to add this feature to our future updates.  

 

Rest assured, we value all the ideas of our customers and share it with our developers. 

 

In the meantime, you may want to consider visiting our QuickBooks Blog. From there, you can see the future developments and the latest news about QuickBooks and what our Product Care Team is working on.    

 

I've added this Community resource in case you've got other QuickBooks-related concerns. You may refer to this article for more details: Community help articles.  

 

Let me know if there's anything else that I can help you with. You got me covered! Stay safe!

AMD5
Level 1

How to split a bank transaction (expense) to multiple locations?

Do you have an ETA for this update?

JamesDuanT
Moderator

How to split a bank transaction (expense) to multiple locations?

Thanks for joining in on this thread, AMD5.

 

We don't have an estimate time on when the feature will be available in QuickBooks Online. For now, we can only assign one location on a bank transaction.

 

As a workaround, you can follow vpcontroller's suggestion which is to create a journal entry to allocate the locations. You can ask your accountant for additional guidance about it.

 

You can also see updates through the following links once we have added new features or functions within the program:

Your feedback would help us improve the program to suit your business needs.

 

We'll be right here if you need anything else.

TJenkins
Level 1

How to split a bank transaction (expense) to multiple locations?

Is there any way to follow this specific development? This would be very helpful in our business.

Rea_M
Moderator

How to split a bank transaction (expense) to multiple locations?

Hello there, @TJenkins.

 

I can see how beneficial it is for you and your business to split a bank transaction to multiple locations in QuickBooks Online (QBO). While this feature isn't yet available, I'd recommend visiting our QuickBooks blog page from time to time. This will keep you updated with the latest features, news, and product developments in QuickBooks.

 

In the meantime, I'm also adding this article to further guide you in managing the growth of your business using QBO: QuickBooks Help Articles. It includes topics about data security, banking, and expenses, to name a few. You can click the + More topics button to view other selections.

 

You're always welcome to comment below if you have other concerns about managing bank transactions in QBO. I'm just around to help. Take care.

Michelle O
Level 1

How to split a bank transaction (expense) to multiple locations?

Someone else posted this very helpful tip, I'm just posting again since it probably got lost.  Add the full deposit to the register and save it.  Then go back and "edit", a separate window pops up and allows you to split the transaction there.  Defaults to two splits but has an option to add lines, memos, etc.

Megan_B
Level 1

How to split a bank transaction (expense) to multiple locations?

Is there an ETA on this feature being released? Like many others, this would be very beneficial for our organization. 

David M4
Level 1

How to split a bank transaction (expense) to multiple locations?

ETA when this feature will be added?  Very frustrating that QBO doesn’t support something this basic. 

Plexo
Level 1

How to split a bank transaction (expense) to multiple locations?

I'm a small landlord and new to QBO. I came up with a different work around. In my situation all the expenses I want to split locations for are evenly allocated to the locations they apply to, so I feel that makes this workaround, work. For example water bills, tax bills, mortgage payments.  Please let me know the pros/cons to this work around. What am I not seeing. 

Example: A four plex apartment. I have a location for each door/address (4PlexA,4PlexB,4PlexC,4PlexD), but need to split the water bill by location. I made a new location called "4PlexAll". I put any items that I would like to split by location into this new location. For taxes I would know all the "All" locations are split evenly among the apartments. 

What do you think?

Thanks from Boise, ID

cfvm
Level 1

How to split a bank transaction (expense) to multiple locations?

Has this feature been added to quickbooks yet?

JonpriL
Moderator

How to split a bank transaction (expense) to multiple locations?

Let me help share information about the multiple location feature in QuickBooks Online, @cfvm.

 

As of the moment, there isn't yet an integrated way to split a bank transaction into multiple locations. And we're also unable to determine the exact turnaround time as to when will this feature be added. It's best to let our developers know about your request by sending feedback. Let me show you how.

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter a few words describing how you want to assign multiple locations to a downloaded bank transaction.
  4. Click Next.

 

I'm adding this article for you to keep track of the feedback request you've sent: Customer Feedback for QuickBooks Online.

 

If you have any other related concerns with bank transactions, please let me know in the comments below. I'll be here to answer all of them. Take care and stay safe!

lauren be
Level 1

How to split a bank transaction (expense) to multiple locations?

And this is why, my friends, we accountants stick with QB desktop and shy away from converting to QBO.

Austin Lage
Level 1

How to split a bank transaction (expense) to multiple locations?

Please get this feature added. I just converted and I am about to cancel my membership. This is a must have. 

Nelli2119
Level 1

How to split a bank transaction (expense) to multiple locations?

From there you can split it into separate accounts and class, but not location.

yh-kids-org
Level 1

How to split a bank transaction (expense) to multiple locations?

Any updates on this being added? As a new QBO user that just converted from QBD, I'm amazed this isn't in place, and apparently is not being considered a high priority given it's been over 2 years that this thread, and others, have been discussing it!  Very disappointing!

JamaicaA
QuickBooks Team

How to split a bank transaction (expense) to multiple locations?

Thanks for following-up this thread, @yh-kids-org.

 

I can see how the option to split a transaction into multiple locations would benefit you and others. However, this is currently unavailable in QuickBooks Online.

 

I want you to know that your opinion is important to us and we value it. With this, I’d suggest sending feedback request to our product development team. The more feedback about a certain feature they receive, the greater the chance it'll be added.

 

As what my colleague mentioned above, we’re unable to provide a time of when will this feature made available. Rest assured that our developers will evaluate these and pick some of them to include in future updates. This way, we can help you with your business needs.

 

Here’s how:

 

  1. Go to the Gear icon.
  2. Under the Profile column, select Feedback.
  3. Share your suggestions, then click Next.

 

You'll want to track your suggestion through this website. You can also visit our blog to keep up with all of our recent events and developments.

 

I’m just a comment away if you have other banking concerns. Wishing you and your business continued success in all that you do.

kmk-az
Level 1

How to split a bank transaction (expense) to multiple locations?

Any update on the development of this feature?  I'm not able to locate any information on the website or blog.  This feature is important for my business.

MichelleBh
Moderator

How to split a bank transaction (expense) to multiple locations?

Thanks for the follow-up on this matter, 

 

We're always looking for ways to make your experience with QuickBooks more convenient and enjoyable. I'll put my best hoof forward on this and help get the most from QuickBooks Online. 

 

As of now, we don't have an update on when splitting a bank transaction to multiple locations will be available. I'd recommend sending feedback again to notify our engineers about this matter. Your suggestions help us build features that benefit you and other users.

 

You can follow the steps provided by my colleague JamaicaA above. The company listens to its customer base, which is why many of the program's current features were suggestions from QuickBooks' users. The company also wants to hear from you, so check out its website to vote on future ideas. To access the page, visit this link: Customer Feedback for QuickBooks.

 

As an alternative, I suggest following my co-worker's Nick_M or vpcontroller's suggestions.

 

Additionally, you can bookmark these articles below on how to record multiple accounts in a transaction and categorize them in QuickBooks: 

 

 

If you have any questions or concerns about QuickBooks, don't hesitate to contact me. I'd be pleased to help you understand whatever software side confuses you.

XenaXena
Level 1

How to split a bank transaction (expense) to multiple locations?

When I follow these instructions EXACTLY, there is no place in the window to add the other amounts. I'm trying to do a monthly mortgage payment and break it down into principal, interest and escrow and enter as a transfer every month. Otherwise I would have make 3 entries for each mortgage payment in order to keep track of these 3 items each month. Maybe you have to have the advanced more expensive version of QBO to do this?? Any help would be appreciated.

Jen_D
Moderator

How to split a bank transaction (expense) to multiple locations?

I appreciate your time joining this discussion about splitting bank entries, @XenaXena.

 

Before anything else, may I know which instructions in this thread did you follow? There are several topics in this thread and I need to be sure I'm on the same page with you. Any additional details will help me provide an accurate resolution to your concern.

 

Also, I'd like to know which version of QuickBooks are you using. You can find it using the steps below:
 

  1. Go to the Gear icon and select Account and Settings.
  2. Select the Billing & Subscription tab.
  3. Your subscription is shown below your company ID. See this sample screenshot:

If you're trying to split a bank entry, you can use the split option in the banking page. Here's how:

 

  1. Go to the Banking menu.
  2. Click the bank transaction you want to split.
  3. Press the Split option.
  4. Make sure to fill the Amount column.

 

If you can't find the Amount field, try opening your account in a private window. This will not save any history, so it's a great place to identify issues in the browser. Use these keyboard shortcuts to launch a new private window:

 

  • Google Chrome: press Ctrl + Shift + N  
  • Mozilla Firefox: press Ctrl + Shift + P
  • Safari: press Command + Shift + N

 

You may try a different browser too, and see if the problem persists there. If you can use the feature in QuickBooks without any issues using the workarounds, clear the cache to start with a clean slate. 

 

Please add the additional details and result below. I want to make sure this bank entry is resolved for you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us