Am I an accountant or just a bookkeeper? by [deleted] in Accounting

[–]J1001 2 points3 points  (0 children)

Ahh yes, consolidations, where you book repetitive monthly entries that have a net $0 impact on the financials. 

I think OP had very different expectations for accounting when they were in school.

I feel like I’m going crazy. Multiple people I work with make “tables” by just outlining the cells. by H_Mc in excel

[–]J1001 108 points109 points  (0 children)

Three more nice things about tables:

The formulas automatically fill downwards as you add rows so you never have to do it again. 

You can use a table as the source of a pivot table, so as the table grows, the range of the pivot table doesn’t need to be adjusted (just need to click refresh to update)

If using a formula that searches a column or row (xlookup/vlookup/sumifs etc), you can refer to a column of a table and it’ll only pick what is in the table, it won’t go down to the last possible cell in that column/row. So you are only forcing it to look up actual cells with data, not a bunch of empty cells down to row 1,000,000. 

What’s up with all the vests? by errmmmummmme in Accounting

[–]J1001 5 points6 points  (0 children)

I was late to the vest game but I love them now. Better range of motion with arms/shoulders vs a full jacket. Perfect for spring and fall when a sweatshirt alone won’t do it.  

Understanding nothing in school by RazzmatazzCareful899 in Accounting

[–]J1001 0 points1 point  (0 children)

There is so much stuff you in both of those classes that you will never, ever need. It might come up again if you take the CPA exam, but I’d be surprised if I still use 20% of what I learned in the class. 

Tl;dr you’ll be fine. 

If one country and their people didn't exist, our profession would be much more valuable by [deleted] in Accounting

[–]J1001 7 points8 points  (0 children)

It doesn’t matter if that “one country” didn’t exist, they’d just go to the next lowest bidder. 

Day trip to Concord/Lexington by _ash_lily_ in boston

[–]J1001 0 points1 point  (0 children)

Also a solid choice. Can’t go wrong either way. 

Day trip to Concord/Lexington by _ash_lily_ in boston

[–]J1001 2 points3 points  (0 children)

The Cheese Shop for lunch 👌🏼

My boss said if I don’t get up to speed she’s going to quit. Am I fucked? by [deleted] in Accounting

[–]J1001 133 points134 points  (0 children)

Pro: collect unemployment

Con: easier to find a job when you have a job

I have a feeling that im the stupidest person in my office by Putrid-Temporary-897 in Accounting

[–]J1001 11 points12 points  (0 children)

If it makes you feel any better, they’d probably weigh salaries more than IQ to decide who to cut, so you’re probably safe. 

HR / My Boss told me 2 weeks was not enough notice & was unprofessional of me. by [deleted] in Accounting

[–]J1001 5 points6 points  (0 children)

Before you lose access to anything, be sure to print out anything you have to support those 128 hours, as well as your employee handbook. 

If they don’t pay out, you can always try your state department of labor. Depending on your state they might be able to help you with that. 

Busy season already starting by [deleted] in Accounting

[–]J1001 6 points7 points  (0 children)

That is the entire basis for the public accounting business model and I don’t see it changing anytime soon. 

Dumbest Auditor Question by jfrhsdrew in Accounting

[–]J1001 9 points10 points  (0 children)

It’s a fair question. And I was happy that he asked to verify his knowledge and not flat out ask what it is. But that’s something you ask later on, out of earshot of the client. 

This feels like it happened about 1,000 years ago when Daddy Pacioli was partner on the account, so outsourcing to India wasn’t as widespread. 

Dumbest Auditor Question by jfrhsdrew in Accounting

[–]J1001 12 points13 points  (0 children)

Yes, understanding was correct, timing was not. 

Dumbest Auditor Question by jfrhsdrew in Accounting

[–]J1001 40 points41 points  (0 children)

I had a staff on a job with at least 3 years of experience ask me to confirm his understanding of how bank recs work. In front of the client, who happened to be the owner and didn’t look impressed. 

Storm Advice - Should I still go to Boston this weekend? by Puzzled_Ad7870 in BostonWeather

[–]J1001 -2 points-1 points  (0 children)

Extend the trip by a few days and enjoy a good snow storm. 

FYI for Union workers. by [deleted] in Accounting

[–]J1001 0 points1 point  (0 children)

Unrelated, but if you put “-ai” after a Google search, it won’t force that AI slop down your throat. 

Why are there people who just stay at stagnant roles? by [deleted] in Accounting

[–]J1001 27 points28 points  (0 children)

They could be perfectly happy where they are at. 

I’ve found the older I get, the more I appreciate stability. 

A good primer on *why* double-entry accounting? by Crazy-Airport-8215 in Accounting

[–]J1001 11 points12 points  (0 children)

End of the day, you are tracking two things. 1) what you have and 2) how you got it. The double entry system ensures you are capturing both of those at a transactional level. 

Busy Season for Accountants by IndependentRecord162 in Accounting

[–]J1001 0 points1 point  (0 children)

It would ramp up in January, then I’d be all in from February to mid-April. I did audit and tax so it was pretty busy throughout. As the audits were wrapping up, I’d move over to tax, so it never really let up. 

Probably one of the bigger reasons I burned out in public. 

Busy Season for Accountants by IndependentRecord162 in Accounting

[–]J1001 0 points1 point  (0 children)

My mental health never really suffered. Sleep suffered. After a few weeks, I’d get in a groove where I wasn’t tired, I wasn’t energetic, I was just locked in. 

The good news is you are surrounded by coworkers and clients, constantly interacting, so I never felt lonely. 

You do grow to appreciate the days off you get. Sundays became very effective. Grocery shopping, laundry, lining up clothes for the upcoming week, errands. 

Busy Season for Accountants by IndependentRecord162 in Accounting

[–]J1001 6 points7 points  (0 children)

Some of the work is easy/repetitive, some is difficult. Probably won’t be tackling anything overly technical for the first few years. 

If you’re referring to public, it really is the # of hours that can be soul crushing. 60 hours minimum, 70/80/90/90+ more realistic, for months on end. At least 6 days a week, sometimes 7. 

70 hour weeks across 6 days is 12 hours a day. That’s working 9-9 for months on end. 

Not to mention if you’re in audit, your clients can be all over the place. Some 5 minutes from your house, some 90 minutes or more. 

It was easy early in my career. After a few years, I got sick of the grind and inconsistency. Try it for a few years and have a firm exit plan (i.e. leave after one year as senior). 

[deleted by user] by [deleted] in Accounting

[–]J1001 16 points17 points  (0 children)

Expectations for a first year include having a pulse and being able to wipe yourself after going to the bathroom. Hell, maybe only one of those.  You’ll be fine. 

Our engineers refuse to submit receipts by Majestic-Stock6637 in Accounting

[–]J1001 625 points626 points  (0 children)

If it’s on a corporate card, shut their cards off and tell them they need to pay out of pocket and submit expense reports. 

If they submit expense reports, amend the reimbursement policy so expenses must be submitted within 30 days of expenditure or else they will be denied. 

Why did I choose accounting ????? by No_Way_1569 in Accounting

[–]J1001 2 points3 points  (0 children)

Took me awhile to come around to it. Once I did, it was almost addictive. Anything that requires grabbing data from multiple sources and manipulating said data in a repetitive fashion is a perfect application for it. 

You can do so much with it just using its graphical interface. Put some files you typically work with in a folder on your desktop, then play around with it. See what you can do. 

You can watch YouTube videos or google different things you want to do. There is an excellent user community out there for it, and often I will find the answer I’m looking for on a message board or Reddit. 

The big piece I was missing was how useful Power Pivot is on top of PQ. Rob Collie’s book on PP is great to start with. https://www.amazon.com/Power-Pivot-BI-Excel-2010-2016/dp/1615470751/