Can't figure out how to enter investment payments and remove funds from classes

Hi everyone-

I've never posted in here before, but I need your help. Context: I work for a nonprofit who started a fundraising initiative last year where there are to "buckets". In the first bucket, half of the donations raised go to the current year, and the other half are sent to a foundation to be invested. Donors are able to designate where they'd like to support within this initiative, for example different staff positions. So if a donor gives to the executive director position, half of that donation would go to support the exec director this year, and the other half would go to the investment account. The second bucket is all of the donations given go into the investment account for the future. I'm at my wits end trying to figure out how to keep track of things in QBO. I have a giant google sheet tracking individual donations and where they go and the payments that have been made to the investment account, but I don't know enough about QBO to make it work. 

 

In QBO, I already use classes to separate the different designations and projects, and I have the two general buckets setup -one is for the donations that are split between this year and the investment account and the other where the full donation goes into the investment account. So, both buckets end up in the same investment account, the difference is that the first one gets split in half before going to the investment account and the 2nd goes to the investment account in full.

 

I'm able to track and split the incoming donations without any issue. I import everything from our bank account and classify it when it shows up in my feed. I also can make the journal entries to put this year's funds from the initiative into the proper staff accounts, but the issue I have is when I send the funds to the investment account. I can't figure out how to get the funds out of the two classes on the P&L and over into the investment account on the BS. When the actual checks that are sent to the investment account clear, I mark those bank transactions as a transfer to the investment account in QBO, but I can't add classes to that transfer transaction to get it off the P&L. I can't figure out how to get the funds from those classes to decrease when the check clears. 

 

Do I need to enter additional JEs to move things around or do something else? I've tried using Projects and have projects setup for these two buckets in the investment account, but the donation deposits from the bank don't show up unless I create a sales receipt and match the donation to it, and when I split a large deposit to match a donation to a sales receipt, the rest of the donations that made up that deposit won't go to the accounts I need them to. I also can't make a transfer transaction from my bank feed tied to a project.

 

I can't finalize our 2025 financial statements until I know the investment funds have been moved from the P&L properly so our income isn't inflated. Unfortunately this initiative is running for the next couple of years so I have to find a process to make it work and can't just do a quick fix to get it off my plate. 

 

Does anyone have any thoughts on how to do this? Thanks in advance for your help!