This is brilliant, thank you! Makes good sense, I cant wait to try it. 

Along the same lines, I've been using temp bank accounts (or "dummy" bank accounts) to wrangle business expenses paid with a personal credit card, for example.  I have the client export their credit card transactions to a spreadsheet, we fix up the data a bit, and then upload them into the dummy bank account. Then we just journal entry the total for each month to Loan from Officer.  It's such a good hack!