I figured out what the issue was. I left the first row blank and somehow that messed up the entire formula. I added just a date to the top row and the formula works now. I originally left the top row empty so I could group and minimize past jobs by time frame, and I canât minimize for better organization if there is info on the top row. In case anyone runs into any issues in the future.
2 Likes
I just finished setting up my deductions. Thank you so much for this! This must have been a herculean effort 
1 Like
Which numbers do you use for budgeting? A little confused on that.
Iâm not doing much budgeting these days, but when I did I primarily did the net pay. Depending on the types of deductions you have, there could be reasons to want to budget others I would imagine.
Thank you for your response. If you budget netpay and budget the deductions, then the cash flow reflected is offâŚanyone have any thoughts on how to set it up? for example all of these deductions would be against a budget that shows net pay as income and cash flow would be understated:
I budget off of gross pay, and I use this sheet to track any paycheck deductions from that gross pay. Not sure if that answers your question, but Iâve become a fan of budgeting off of gross pay. Gives me a greater appreciation of just how much of our income goes to various benefits and taxes.
Thank you for your responseâŚcan you please provide guidance on how you have it setup for gross payâŚfor exampleâŚ
Gross Pay Budget - 100/week
Pay Actual Deposit - $75/week
You will always have a shortage against the budgeted amount??
The copied entry for gross pay from the generator does not add to the actual column for some reason?
How do you have that setup?
Not sure that I completely understand the issue that youâre raising. Maybe itâs because I use the Savings Budget sheet to do my budgeting? But my goal every month is to have my Actual Income equal my Budgeted Expenses. Where Actual Income equals my Gross Income and where Budgeted Expenses includes any paycheck deductions, incurred expenses and money that I allocate to savings. So:
Gross Income: $100 (Actual Income)
Budgeted Expenses ($100):
Payroll Deductions: $20
Actual Expenses: $70
Savings: $10
Hope that makes sense.
1 Like
Yes, thank youâŚthat helpedâŚalso figured out that there was an issue with the copy paste from the generator date format so the gross income entry was not coming through.
1 Like
OK I gave in and tried this after looking at it last year.
I think I like having total Paycheck values, and I also like tracking taxes and other deductions. So now I am sold.
Nice work!
I wanted to automate/dummy-proof inserting the values into the Transactions sheet, so I wrote a script for it.
Donât want to hijack your thread, so it is here.