I dug a little deeper, @branadonshutter, and I think I understand the problem. The issue is that the payments that register in columns “March Actuals” (
L) and “Paid in Period” (
U) are payments RECEIVED against the loan account.
Essentially, a typical loan payment is expected to come in a pair:
- An outflow against a different (payment) account (e.g. -$200 from your Checking account)
- A (matching) inflow against the loan account (e.g. +$200 to “Student Loan”)
There is a fussy
U8:U that finds and sums transactions in the period MATCHING THE SECOND PART OF THOSE PAIRS. Only transactions in your
Transactions sheet in the current month meeting the following criteria will be added:
Transactions/Account column matches the loan name (e.g. “Student Loan” in this example)
Transactions/Amount is positive— MUST BE A CREDIT TO THE ACCOUNT
When I took a peek at your sheet, I could see that you had transactions against the loan accounts, but they were (negative) outflow payments (i.e. the first part of the pair).
For loans where the outflow and inflow accounts are linked with Tiller Money Feeds, this process should be automatic.
For manual accounts, you will need to create one or both sides of these transactions with the the Manual Transaction workflow in the Tiller Money Labs add-on. For most users, the outflow (e.g. checking) account will be linked but the loan account may be a manual account. In this case, follow the Adding Manual Transactions steps to create a payment received against the loan account. Note that there is a cool hack in this workflow for manual accounts that allows you update the balance of the manually-tracked account in the same operation.
I hope this gets you up and running, @branadonshutter.