Hi, I think I found your solution the best out of everything being said here. 

However, I tried something similar to this and it wasn't matching what was showing in our bank account when doing a reconciliation. We have benefits that shows as deductions but we pay for them ourselves, and vacation accrual which ADP keeps track of, but isn't deducted from our account until someone accesses their vacation pay. I think both of those items are throwing everything off, because what shows as the total balance is not what is being deducted from our account. I also work for a non-profit, so all of our deductions have to be detailed. For example, we have to show how much vacation we have accrued in our books as well as how much was paid out on each quarterly report.

Would you happen to know how to record all of this so that it matches what is being taken out of our accounts?