Skip to main content
J
joshuashaneadkin
March 25, 2020
Question

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

  • March 25, 2020
  • 7 replies
  • 0 views
Original commenter did not share additional details

7 replies

N
Nick_M
March 25, 2020

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!

    X
    XenaXena
    July 8, 2022

    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
    Jen_D
    July 8, 2022

    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.

    vpcontroller
    vpcontroller
    March 25, 2020

    @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!

     

    D
    daveyeo
    May 21, 2020

    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!

      A
      azzarello
      November 6, 2020

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

       

        M
        Megan_B
        February 10, 2021

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

          D
          David M4
          March 15, 2021

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

            P
            Plexo
            April 14, 2021

            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

              Y
              yh-kids-org
              April 4, 2022

              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!

              J
              JamaicaA
              April 4, 2022

              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.

              K
              kmk-az
              June 16, 2022

              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.

              M
              matthewtesta
              July 7, 2023

              Hi.  I'm a bit late to the party here... however this topic is definitely something that's been an issue for me for a while.

               

              Any idea when we will have this feature launched?  It is truly is a game changer for the software value for those of us in real estate development and would validate QBO as a bonafide accounting solution for us in this space.

               

              Thank you!!

               

               

                Terms & ConditionsAccessibility statement