Ugh...what a mess!  I resulted to going to the General Ledger Report and exporting it to Excel. I deleted all the blank lines and sorted that column for the Deposits. Luckily I'm doing work for a new company and not many transactions. This way too much work for something so simple. This comment applies to QBO 2018.