Here’s my take on part of your question: How To Track Your Paycheck Deductions In A Google Spreadsheet - Tiller (tillerhq.com)
The links in the article are broken, but you can find the suggested template in your Tiller Community Solutions add-on, and the documentation is here: Paycheck Deduction Transaction Generator.
2 Likes