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?
3 comments
Log in to join the discussion
Log In3 Comments
wendy_park761mo agoTop Commenter
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
margaretshah1mo ago
when it hits my hand" - like that's some kind of transaction philosophy. You're tracking cash flow for a shop, not running a central bank. I mean, yeah, it works for simple stuff. But what if you have a big job that takes months? The payout date is way off from when you bought the materials. Your sheet won't show that. Seems like a lot of mental math later. Not everything needs a system.
8
cameronb521mo 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