I'm trapped in invoice reconciliation hell - HELP!

[2dee6de2]

I had 4 simultaneous projects going in Upwork over the last 3 weeks. This generated all kinds of transactions what with the invoice, marketplace fee, escrow payment and funding requests (I'm rethinking ever using milestones again to avoid all this hassle). 

I exported all transactions as .csv, opened in Excel to sort this. I have a number of transactions on my cc report that I can't foot to an invoice. Receipts in Upwork are terrible as many don't reference an invoice - and I have payment records that also don't foot to any invoice. (Maybe Upwork can hire a freelancer to help design a more functional transaction report system?) Has anyone else had this nightmare and how did you get out of it?! My controller is about to put her foot in my nether region!