2
Vent: My spreadsheet formula for tracking cash tips took a whole month to fix
Everyone says to just use a basic template, but my part time gig has weird payout cycles and cash tips that don't match my main job's paydays. I had to build a custom tracker from scratch, and it took me four weekends to get it right. Has anyone else dealt with tracking income that doesn't come in on a normal schedule?
2 comments
Log in to join the discussion
Log In2 Comments
wendy_park7612d ago
Yeah, I feel that. I ended up just making a super simple Google Sheet with a column for the date I actually got the cash, not when I earned it. That way it doesn't matter when the payout is, I just log it when it hits my hand.
4
cameronb5212d ago
Tried tracking invoices for my shop and it got messy with payment dates all over the place. Switched to logging only when the money clears in the bank account, same idea as your cash date column. Made taxes way easier last year because the numbers actually matched my deposits. What do you do for tracking materials versus labor?
2