Need help including transfers on non profit Treasurers Report

I recently took over the treasurers position for a small non profit who had been using quicken desktop. They have since been migrated to quickbooks online. Their excel treasurers report originally had begining balance, revenue, expenses, ending balance and transfers. Quicken had a custom report for this which included transfers.

Now that they are in QBO, there's no report or custom report I can find/create that includes transfers. They do not show up on a P&L (understandably since its not actually a exp/rev) This is creating a challenge as the ending balance of individual bank accounts don't match their balance sheet at the end of each month.

For example, say the general fund opening balance is 100, revenue is 50, expenses is 25, but they transfer 200 from their reserve fund the the general fund. That $200 transfer does not get picked up in the P&L (I understand why). The opening balance of 100 + 50 revenue - 25 expenses = 125, which is what their excel treasurers report calculates. However I want it to match the account balance from the BS, which includes that $200 transfer for an ending balance of $325.

There are lots of little transfers and split transactions that happen from month to month so it is too time consuming to manually add them up. There's got to be a better way to do this and take into account the transfers so the ending balance on the report matches the balance on the BS for each bank account.

A standard treasurers report has opening balance + revenue - expenses = ending balance. Internal transfers between accounts happen- how do you guys account for those on a treasurers report?