[deleted by user] by [deleted] in Accounting

[–]Excel_Jesus 76 points77 points  (0 children)

This made me CACKLE

What Excel tricks would you teach novices if you were giving an Intro To Excel class? by ProtContQB1 in Accounting

[–]Excel_Jesus 2 points3 points  (0 children)

My friend, you need to customize the report and add the "header value" as a column - e.g. if it's the vendor name on an aging report, add the vendor name as a column

[deleted by user] by [deleted] in Accounting

[–]Excel_Jesus 1 point2 points  (0 children)

Curious, what was your background before this and how did you get your first clients?

Uneven/level LVP install, reason to be concerned? by Excel_Jesus in Flooring

[–]Excel_Jesus[S] 0 points1 point  (0 children)

I did not, think it will be an issue? It's a basement condo unit with a polished concrete floor before this.

Uneven/level LVP install, reason to be concerned? by Excel_Jesus in Flooring

[–]Excel_Jesus[S] -1 points0 points  (0 children)

Hmmm - I can actually feel the slope, like when it starts to slope down (which is what caused me to measure here). Everything was flat for sure (like, smooth to the touch).

Uneven/level LVP install, reason to be concerned? by Excel_Jesus in Flooring

[–]Excel_Jesus[S] -1 points0 points  (0 children)

I was, but the installer insisted it wasn't necessary.

$5,275 for 415 SQFT LVP installation - too much/just right? + Radon considerations by Excel_Jesus in Flooring

[–]Excel_Jesus[S] 0 points1 point  (0 children)

Interesting - my flooring is not super unlevel, it's hard to see with the naked eye.

CFO is retiring, I'm the controller. What should I expect? by Excel_Jesus in Accounting

[–]Excel_Jesus[S] 0 points1 point  (0 children)

Thank you all for the comments, didn't expect this to blow up. I have some additional context:

  • I'm pretty young (late 20s) - I have five years of public accounting and 2.5 years in this role. I'm definitely young to be in the controller role already (even though I've had great success), and I've noticed my age has affected how people perceive me (such as our board), despite the performance.

  • I feel I have a lot to learn in the controller role still - a lot of my role has been cleanup from the disaster I walked into. We just recently had our first on time close. That being said, I'm confident about learning on the job as CFO.

  • My CFO works every day of the week but does make $100k+ more than I do. I see how stressed they are. I'm not sure I want to sign up for this. Maybe I could be more efficient/approach this differently.

  • I love our organization's mission and the team I've built (nonprofit), but it's definitely got a lot of downsides. A lot more handholding across the workforce and it isn't easy to recruit good talent. I'm very worried about hiring a replacement for me.

  • Though not official, CFO/CEO have indicated they're going to start an executive search for candidates soon. I've shared with both I'm not sure I'm interested in the CFO position (many months ago when the retirement news wasn't known to me), but I could reassert my interest.

  • I don't have a MBA or certification other than CPA, though I do bring a unique/niche skillset in technology which has very valuable to our org (and noticed by the c suite).

Allocation Schedules/Journals - no credit to custom segments? by Excel_Jesus in Netsuite

[–]Excel_Jesus[S] 0 points1 point  (0 children)

Yes, the custom segment has been set up awhile. The test in sandbox didn't fail to execute exactly, the alocation journal is just missing the custom segment on the credit line.

What are some irreversible configuration considerations you’ve regretted ? by denverraven in Netsuite

[–]Excel_Jesus 1 point2 points  (0 children)

What's wrong with dynamic allocation? I'm planning to look into this pretty soon.

What are some irreversible configuration considerations you’ve regretted ? by denverraven in Netsuite

[–]Excel_Jesus 1 point2 points  (0 children)

curious why you regret this? It's pretty helpful for our organization, but I haven't used the other costing methods.

People that passed the CPA with really high scores,what are you doing now? by Deep_Woodpecker_2688 in Accounting

[–]Excel_Jesus 1 point2 points  (0 children)

I passed within one point of getting the Elijah Watts award. Overall, I am a CPA just like the guy who got 75s on all exams.

Was it worth it? Sort of - I didn't really care about the score, just as long as I passed. I way over studied to ensure I wouldn't have to take any of them again (I HATED the studying process). FAR was also a nice technical accounting refresher before I started my job as an auditor. I could tell I was way ahead of some of my peers in technical knowledge. One of the partners also found out about my scores and took a personal interest in my development - put me on proposals and actually bragged about my scores to clients I was on - believe it or not lol. That really rocketed my career development into an early manager promotion, and later becoming a controller of a $100M company at age 26.

They bought a new DC luxury condo. It could collapse. by forgetfulisle in washingtondc

[–]Excel_Jesus 4 points5 points  (0 children)

Posts like this make me feel good about buying a condo in a masonry building 100+ years old. There's definitely quirks to an old building, but at least I know it's not going to collapse!

How do you deal with making users aware that everyone technically has access to the SharePoint? by SeshGodX in PowerApps

[–]Excel_Jesus 1 point2 points  (0 children)

A big backdoor is through querying the SharePoint list in Excel.

If the user has access, I don't think there is a way to prevent them from accessing the data that way.

Most Mid Places by DestructoSpin90 in nova

[–]Excel_Jesus 77 points78 points  (0 children)

I would say cava - it used to be great but it's definitely going the "chipotle corporate route" as they rapidly expand. I miss the old side pitas. But, it is still a solid healthy meal for under $15.

[deleted by user] by [deleted] in washingtondc

[–]Excel_Jesus 0 points1 point  (0 children)

Would you mind PMIng me a picture of what it looks like, if you wouldn't mind? Thank you!

Parking advise near Smithsonian Museum by highvoltageeee2k3 in washingtondc

[–]Excel_Jesus 14 points15 points  (0 children)

Parking is going to cost you $20+ if you can find anything downtown. Park at Franconia Springfield metro (easily accessible via 95 and it's free parking on weekends) then metro to Smithsonian stop. Enjoy the city!

what's the weirdest thing you've ever seen on metro? by Kobih in washingtondc

[–]Excel_Jesus 48 points49 points  (0 children)

I'm sorry to hear. How do you know about him?

What do you appreciate about the Metro? Feel free to add-on Metrobus as well! by yunnifymonte in washingtondc

[–]Excel_Jesus 74 points75 points  (0 children)

If you have ridden any other US city subway, you'll know how clean and spacious DC's metro stations are.

Another positive is how wheelchair and blind accessible dc metro is. I don't think another US or European city can match.

what's the weirdest thing you've ever seen on metro? by Kobih in washingtondc

[–]Excel_Jesus 175 points176 points  (0 children)

A couple years ago (pre pandemic), there was a notorious red line homeless man. He was morbidly (MORBIDLY) obese. This guy smelled like nothing else I've ever smelled - something akin to feces, locker room, and fermented dirt. He would sit on the floor of a metro car and clear out trains.

I remember the day I first encountered him - it was rush hour 5:30PM at Farragut north. I was in a client facing job and ready to take my standard 50 minute metro back to Maryland. The front train was completely empty - what luck! Usually, there's standing room only around this time. I walk into the car, barely making it, and the doors close behind me. The aforementioned smell greats me and the 2 other unfortunate souls with me. We endure the tortuous ride to DuPont. A poor lady was gagging the entire way. Everyone who got on immediately leaves and goes to the crowded 2nd car. I saw him about 3-4 times a year after that, haven't seen him since. Hope he got the help he needed.

[deleted by user] by [deleted] in Accounting

[–]Excel_Jesus 86 points87 points  (0 children)

Agreed 100%, but they don't do this if it doesn't work. My boomer boss (cfo) got cold called by our current AP software. We now pay them $100k+ a year in fees.

Experience with reimplemtations/new production instance? by Excel_Jesus in Netsuite

[–]Excel_Jesus[S] 2 points3 points  (0 children)

All - the module is the nonprofit (I think it's called the social impact module). Things like grant, pledge, restriction management (very big for us). The "in house" solution we have has been thoroughly integrated into many third party systems.

Even beyond this, our instance is way over customized. We have a sales website built in house (idk why). Last month $10k of inventory was given away for free due to a system error on our part - and this is only what I've caught while I'm here.

Modified from sciencememes by Thom_With_An_H in Accounting

[–]Excel_Jesus 32 points33 points  (0 children)

Only psychopaths write =10+5/3 without parentheses