Need some help to a fairly nuanced problem in the transaction sheet / tag report.
I have rental properties that I categorize all as “rentals” (under transfer), and then use tags to identify the specific property. These transactions are paid by me on personal credit cards (and are continuously updated on the transaction sheet), then at some point in the future the credit card bill is paid reducing my bank balance, and only later down the line I will get reimbursed by check. Once they are reimbursed, the net effect is $0 since they are categorized and tagged the same way, no problem here so far.
The problem is that I need to know much cash I actually have at any point in time. If I take my bank balance and add the expenses that need to be reimbursed to me (through the tag report), that figure is wrong since certain transactions have only been charged, not but not actually paid, and have not reduced my bank balance yet. Due to this lag, I get an inflated cash position.
For example, if my bank balance is $1,000, and now a $100 tagged transaction is added as a reimbursement, I show a cash position of $1,100. But that is incorrect, because when the credit bill is due in a few weeks, I will need to pay off that $100, making my cash position $1,000. If the music stops, it is no problem and I simply need to wait until all transactions have been reimbursed. In my case, however, this is a revolving door with many properties and many transactions, so I never know how much cash I actually have.
I need to track this lag time somehow. Any ideas?