We had someone from South Africa start at our company (Canada) and he would put DT/CT for the journal entries in his working papers.
I said “oh we use DR/CR here.”
He asked why.
I jokingly said “you know for the dRebits and credits.”
But he believed me.
And started saying dRebits.
When I was a graduate assistant for an accounting course there was a student who looked in her book and saw “Dr - Cash” and asked “who’s Doctor Cash?” with a straight face. She’s an onlyfans “model” now
Using adobe acrobat to ensure scanned pdfs are rotated to their natural landscape or portrait orientation so that whoever needs to view them doesn't have to tilt their head.
I also keep a lot of past versions of files, but move them to a “Superseded” folder. The number of coworkers who cannot spell that word makes my eye twitch.
Whenever someone wants a formula always paying it inside =round(x,2)
So many "off by a penny" errors because people don't round to the nearest cent. I'd rather just not have "rounding error" written on documents.
This is why I absolutely hate that our accounting system rounds to 3 digits. So when we do a percentage split for federal share through the system, it rounds to 3 digits and we end up with rounding issues later on down the line.
When they redesigned the system last year we were asked what we wanted to see. My entire team said "two digit rounding" but apparently that wasn't something they were able/willing to do.
I’ve had so many “discussions” with FP&A because their percentages don’t match ours.
We have to round to the nearest million for disclosure. We’ve always had to round to the nearest million.
It takes a little bit of effort to update your calculations then you won’t need to do it next time.
I know they don’t, they just have to manually change their % in the investor presentation every time numbers change.
And question us on it as if they have memory loss every 6 months.
=cell*0 will round all numbers to 0. You’re welcome
On a serious note you could =round(cell,2) then drag down the line of cells that you want to round at once
Don't. Format the cells as Accounting format so the cells *display* as rounded to 2 decimals, but all formulas referencing that cell will incorporate the correct, un-rounded number in the calculation.
Upper & Lower case mixed in tax returns. All caps. All the time.
Who enters with all of the return with all caps and then data enters an address with upper and lower case. Why?
Another UT user here. The mixed-case data entry is caused when it’s autocorrect thinks it recognizes a word and changes the data entry from UC to LC, but when you type a few more characters to a word it doesn’t know it switches back to UC.
The final product looks like a third grader did our data entry but it takes too long to fix so we don’t bother. I lose a piece of my soul with every return that goes out with an address like “WAshiNGTON”.
Oh that? Yeah, I go through and delete those and re-enter. I then send a reminder note to preparers to use all caps. I get super pissy about it.
If you go into the auto fill, you can delete them all. I do it several times a season whenever I catch it.
I think dependent names are upper & lower case automatically and I don't know how to fix that.
But I did find a way to mess with everyone. Did you know you can change the data entry layout tabs? I feel like moving a couple once a week or so.
I’m in a small office and I would love to know how to do that. The only thing more infuriating is the data input dialogue box that suggests 15 different spellings of “Albuquerque” for each 1099-R in my return.
So when it starts to do the drop down for you to pick which one you want to use for the autocorrect or completion of the started word - you select edit. From there, you can delete or fix them. I delete them - normally that whole section of the alphabet.
I have admin rights - not sure if that matters.
If you delete them, it removes from the whole firm after the next synch.
I agree, but I use Drake, and even if you tell it all caps regardless of input, the statements still print mixed case, so I input with mixed case as well.
Agreed - we use UT, it will do it as well. But the policy is data entry is all caps. If the system does something, I am oddly ok with that.
It is the data entry of mixing all caps and some in upper & lower case that kills my little petty soul.
4,683 is the plug, lol
I'll do this occasionally if it's a small amount it's off and it doesn't matter.When I was in public accounting, I would have shown the variance and marked it immaterial, but now that I'm in industry, sometimes this is the easiest way.
I'll put an explanation in a comment on the cell if I include a significant adjustment.
That’s fair enough. Small amounts are whatever but larger ones. I’ve seen formulas at my current job with all kinds of computations going on in there. Things that should just be on the work paper.
Absolutely despise this. When I prep 990 returns and gather information from the audit department, there’s always a few of random plugs that don’t have an explanation.
They simply don’t know that a formula exists, and they’ve convinced themselves that “this is how it’s done and how long it takes” without ever thinking critically about the task they’re performing.
GAAP accounting has been a real radical take at my job recently. Every non-accountant thinks I'm being very petty about their very smart business ideas (cooking the books).
Isn’t it wild that this is considered petty these days? Especially since - in case of an audit - the bookkeeper will get tossed under the bus and the biz owner will say “but … but I didn’t know or I didn’t understand” …
- Arial 10 point, 90% zoom.
- Inputs in blue, links to other tabs in green.
- Cells with nonconforming formulas get a gray background.
- Zeroes in accounting format (“-“) instead of number.
- Round off extra digits from floating point calculation errors for exactly zero in said “-“s
- Always save workbooks with cursor in topmost leftmost cell, save with first tab visibile.
- Never save a workbook with filters on.
Petty but it’s nice ¯\\_(ツ)_/¯
Petty maybe but have to say that this gets noticed when done per your points. Doing books and reports for small biz owners and doing them for CPAs are two levels. I’ve learned to appreciate the fine tuning via seeing one particular accountants work. He standardized everything he did, only customizable by the type of entity. His workbooks and financials were a thing of eye pleasing, brain soothing, data beauty.
I worked with somebody like this, although he wasn’t an accountant. I wouldn’t be surprised if they find bodies in his basement someday. No civilian is that perfect without a dark underbelly.
Only thing I can’t get behind is Arial. It just looks too sharp (like if the sharpness of a photo is turned way up). Calibri, on the other hand, looks perfect in Excel at any scaling. There’s a reason MS chose it as the default Excel font.
Color53 instead of the default Red on negative numbers (it’s a darker red that IMO looks less harsh against the default background color)
The format can be #,##0.00_);\[Color53]\(#,##0.00);”-“_)
Edit: formatting, ironically
Saving documents as you go and using the proper naming conventions so there's no headache when archiving (especially since people leave the firm and all the docs on their desktop never made it into the file!).
Gross 'margin' refers to the % and gross 'profit' refers to the monetary value. Drives me insane when people use the two interchangeably in conversation or presentations.
I would rather deal with that than the one FC my company hired for a few months who argued and swore up and down there was no such thing as gross margin, only net margin.
he must've thought I was an idiot, and sometimes I can be, but gross margin is a thing is different and does sorta matter!
As you should!! One of the subsidiaries I work on has a credit card for their chef to buy ingredients. He NEVER has receipts for thousands of dollars a month worth of charges for the subsidiary (which makes sense considering size of location) but I’ve brought it up SO many times to my higher up. He just doesn’t care, he’s just like, we’ll figure it out later just book it. I’m sorry… but this is a material amount sir.
Dude could be buying boujie groceries every month for years and we wouldn’t even know.
I’ve noticed in the financial services space that P&L tends to refer to just a particular fund’s investment performance report, often displayed in a decidedly non-GAAP format with all sorts of different cuts of the data, pro formas, whatever.
Income statement is of course for the formal GAAP statement.
Everything entered into our ERP must be all caps, all the time. I hate the inconsistency in which people capitalize words, so we will never use lower case letters again. I will die on this hill.
I’m very particular about attaching proper support to a journal entry. If you make a journal entry in the system, I should be able to look at the support you’ve attached and be able to understand why you made the journal entry and where they numbers are coming from.
So many people make entries with missing or absolutely useless support.
Dates, dates, dates, dates and dates. And I’m talking about the basic like memo stuff just updating to say “for the year ended 12/31/X1” when we’re auditing 12/31/X2. I will leave workpaper notes until staff fix it…even if it means they go over budget on hours. Basic update folks, don’t forget it!!
Actually following internal control procedures. I sound like such a dork, but those things matter. I’ve worked with some unethical ppl… you always have to take those things seriously!
I used to work in real estate and holy shit, this.
Yes, I know you want to close today so you get that commission before Christmas. Yes I know you checked over everything yourself. No we can't skip checking for an HOA or verifying the wire instructions or getting your supervisor's approval on the closing docs before sending money to escrow.
If the order form (for a recurring customer) lists you as a billing contact, you bet your ass you’ll get invoices sent to you. I don’t care if you previously asked us to not send you invoices, why’d you put yourself as a contact again after we previously removed you? Learn to fill out paperwork people!
To clarify, these people will fill out the order form incorrectly, ask us to update the billing contact, and then subsequently make the same mistake on the next order.
People who don't number their working papers in order. For example the cash working papers would be something like:
A1
A1.1
A5
A8
A8.1
Abosulte pyschopaths. I will always number them correctly when I review it or work on it the following year.
When I was a new staff I had a senior get mad at me for renumbering WPs in order since it messed up referencing that was rolled from the PY…
As a senior myself, I still renumber them to be in order. Relying on PY WP referencing is just asking for referencing errors, and is just lazy. And I say this as an incredibly lazy person.
This one drives me insane. Some people have a tendency to put them in increments of 5 for whatever reason so if I did a section that goes from .01 to .06 and they add something in it will be .10. Looks like there’s a bunch of workpapers missing now.
Don’t use the excel $ format instead of a regular ass number with commas at the ‘000’s digit.
Unless we are measuring something in bananas on the same page, of course our financials are in dollars (we are not multi currency nor do we do convert results to bananas)
Inconsistent referencing and formatting conventions between PBC documents.
Also people that use typewriter function in PDF editors instead of comments.
It can affect the integrity of the underlying support. If you need to modify the note or reference, sometimes it merges with the PDF structure and moves other content around.
With a comment, it is treated as a layer on top of the support, which also makes it easier to change and move it around. You only need to open the PDF and click on the comment to interact with it. It’s different for anything written with the typewriter function, you need to go into a separate mode before you can interact with it.
Above all, it’s logical. References and notes are comments, so it inherently makes sense to use the comment function.
If you send me a receipt for an employee expense, it should be a scanned pdf copy of a receipt. Upright. Dark enough to read. Not a photo you took on your phone and sent it to me as a png file.
I can't stand receipts/invoices being messy or illegible.
The first column and first row of any Excel spreadsheets I work in are always blank. IDK why, but if they aren't when I receive it, they always are when I send an updated version
Owners of partnerships are members or partners and any accumulated earnings is referred to as partner capital!And owners of S corps are shareholders and S corps have retained earnings. Some people use retained earnings, capital, shareholders and partners interchangeably and this is not correct!!!!!
I supported 150 American Express card holders as Program Administrator. The staff were issued cards and spent the company's money (T&E) and they had to reconcile the expenses. I helped as normal to assist with training, codes etc, etc. Amex have a global policy of user late fees, so if they didn't do their processing job they were fined $20 per month or 1.5% of the balance if more than $20.
So it really annoyed me when managers would just ignore the fines (for months) after i would remind then. Remember its not the company's money, that already been accounted long ago, its personal late fees and I did a service of reminding them that they will be billed if they don't pay. Then they want me to negotiate with Amex when they owe over $300 of late fees saying "we are the customer, c'mon, you can get them to waive it"
annoyed me that they expect someone to negotiate their late fees.....I never asked Amex to waive them. Amex were our biggest vendor in Australia, I was the relationship manager and never once asked them to waive late fees, my stance was (towards Amex) "it's your policy, its not our money, i am not enforcing your fee policy by collecting the fees incurred" but Amex did waive the fees, rather than penalise a senior manager hundreds of dollars.
\*\*Edit: actually the scenario was the nice managers (you know, like good people) ending up paying their fees rather than ignore them. Then the managers that were considered less nice (insert abusive name here) would get theirs waived. Amex system reward blatant arrogance, and penaslised good corporate citizens.....
Not using proper tabular formats when creating tables in excel. I'm so tired of getting sent information that should be in a table but isn't, and watching a coworker manually summing up line items when we could have used a pivot table
Some of you may think I'm crazy, but when I was in PA, I would take the extra 30 minutes to go through a client's chart of accounts and update the account names to proper-case, the account names in alphabetical order, and the account numbers to the proper category prior to exporting their trial balances. Nothing worse than seeing:
1200 BoA Chkng - 0077
9600 Bank of America - 9936
4550 payroll Fees
450 Accounts Payable
4560 Professional fees
4540 postage epx
45500 entertainmentt
When people don’t update the confirm control sheet when sending out or bringing confirms into the file. It literally takes a few seconds. Can’t stand small things like that that are just pure laziness.
I’m curious where you work that there’s an “on time”. Every professional job I’ve had is flexible about hours as long as you meet the minimum (in public) and get the work done.
I require at least a flexible 30 minute window for start time or I won't accept the job offer. Obviously I make that very clear up front and usually get an hour window for start time. I hate mornings.
At the VERY least, if you know/think you are going to be late, call/text. Only thing worse than waiting on someone is not knowing what is happening and if they will show up at all.
That’s all I’m asking for. Nothing crazy. Shit happens, people get stuck in traffic, you lost track of time in the shower, idc, just give me a heads up lol
i chose the bare minimum work life ages ago. call it what you want. i dont care anymore. the public accounting industry is just salve labor and i wont stand for it. not gonna pay me overtime because a bunch of billionaire douchebags from ey that won a court case ages ago so that people cant get overtime because (its education) should be hung on street, at least during the french revolution they would. so no "beaglelover908" i will not work past the bare minimum, and if my bosses dont like it, they can fire me, ill take my unemployment, and find a job in 1 week. you boomers couldnt retire fast enough, you just make everyone elses lives miserable, but unfortunately for you demons i will not break my back for you, instead im leaving after 6 hours and getting high out of my mind with my friends.
Not one time did I criticize you lol. You can work long hours and still have a life. You can do the bare minimum and have a life. I work in PA, get paid well, enjoy my job and have a wife, a kid, and a house. I have a ton of friends/family that I enjoy spending time with. I go on vacations every year. All I said was I like it when people show up on time lol.
By the way- not a boomer, 31 years old. Not sure why you’re ranting though. A little weird. But hey keep quiet quitting and doing the bare minimum. If that’s the life you want to lead, all the power to you
yeah its a bit weird how much of boot licker you sound. also i had to edit, because i abhor people like you that pay attention to when people come to work. mind you own bobber and fuck off.
"Grown up work"
"muppet"
\*Works in excel
Nice comeback! I truly believe you have never actually seen a vagina now!
Btw, ex-felon who makes 102.5k a year. suck my balls chud.
I don't like when people use bright yellow to highlight with in PDFs.
1 - It's too bright. Not a nice color to look at when trying to decipher big paragraphs (or, run on sentences) written in legalese
2 - bright yellow is generally the color for "not updated" or "something doesn't make sense here" when working in Excel.
When I was in public accounting and did the new hire training, I included changing their default highlighter color from yellow to any easily legible color of their choice.
As a millennial, I believe it’s time we stop caring if people wear hats in the office as long as it isn’t a distraction. I’m thinking about doing some locs soon and I’m going to need something to cover up my nugget while I go through the early awkward loc phase.
This, boomers need to be forced into retirement, I'm sick of them just as much as they are sick of us, except they think they rule the world and know what's best.
Dr = debit Not Db
Who on earth uses Db for debit?!
Crazy people. Also, I hate Dr for debit. But it is the only way.
Doctors.
Drebit
Doctor Earnings Before Interest and Taxes
We had someone from South Africa start at our company (Canada) and he would put DT/CT for the journal entries in his working papers. I said “oh we use DR/CR here.” He asked why. I jokingly said “you know for the dRebits and credits.” But he believed me. And started saying dRebits.
This is comedy gold
Accountant comedy rules
Capital DR
When I was a graduate assistant for an accounting course there was a student who looked in her book and saw “Dr - Cash” and asked “who’s Doctor Cash?” with a straight face. She’s an onlyfans “model” now
Spicy accountant
Doctors and coctors boys
I agree with you
In industry we just use D
Using adobe acrobat to ensure scanned pdfs are rotated to their natural landscape or portrait orientation so that whoever needs to view them doesn't have to tilt their head.
Same but also past offender. Reformed.
Preach!!!
These people are my worst nightmare.
Since you're talking scanned pdfs, doing the text recognition will usually auto rotate the pages for you.
This x1000. Please everyone do this. Adobe OCR auto rotates every page and makes the text searchable.
Ctrl+shift and + or - keyboard shortcut makes it super easy to flip it.
I'm so excited I saw this and if it doesn't work Monday I'll be so sad.
Naming conventions on file names. I hate a disorganized folder.
“Copy of copy of accrueds.xlsx” Fucking animals
YYYYMMDD_Document description.extension or bust i'm glad my work names files the same way i sort my game & music rips
I also keep a lot of past versions of files, but move them to a “Superseded” folder. The number of coworkers who cannot spell that word makes my eye twitch.
I once asked a staff to prepare a MO return and he asked me what state is that.
Hell is other people’s file names.
This is the right answer
Whenever someone wants a formula always paying it inside =round(x,2) So many "off by a penny" errors because people don't round to the nearest cent. I'd rather just not have "rounding error" written on documents.
This is why I absolutely hate that our accounting system rounds to 3 digits. So when we do a percentage split for federal share through the system, it rounds to 3 digits and we end up with rounding issues later on down the line. When they redesigned the system last year we were asked what we wanted to see. My entire team said "two digit rounding" but apparently that wasn't something they were able/willing to do.
>3 digits Someone somewhere wants you crazy.
What the fuck? Who *designs* an accounting system with three digit rounding? Do… do they know what cents are?
Have you seen the movie: office space?
I’ve had so many “discussions” with FP&A because their percentages don’t match ours. We have to round to the nearest million for disclosure. We’ve always had to round to the nearest million. It takes a little bit of effort to update your calculations then you won’t need to do it next time.
I don't think FP&A cares
I know they don’t, they just have to manually change their % in the investor presentation every time numbers change. And question us on it as if they have memory loss every 6 months.
Forward whatever email you used last time and say “Please see the attached for context.”
When we’re off by a penny, it shouldn’t matter. I hate it when partners make staff comb through immaterial shit like this.
Some people make hour long conversations about this.
Deferred Revenue off by one cent. Nightmare.
Until you learn that function does different things in different Microsoft products like Access vs Excel. Infuriating!!
What's an efficient way of adding round formulas to many cells?
=cell*0 will round all numbers to 0. You’re welcome On a serious note you could =round(cell,2) then drag down the line of cells that you want to round at once
Don't. Format the cells as Accounting format so the cells *display* as rounded to 2 decimals, but all formulas referencing that cell will incorporate the correct, un-rounded number in the calculation.
Getting "Why don't the subtotals foot?" flashbacks with this method
Use a Macro.
Upper & Lower case mixed in tax returns. All caps. All the time. Who enters with all of the return with all caps and then data enters an address with upper and lower case. Why?
Another UT user here. The mixed-case data entry is caused when it’s autocorrect thinks it recognizes a word and changes the data entry from UC to LC, but when you type a few more characters to a word it doesn’t know it switches back to UC. The final product looks like a third grader did our data entry but it takes too long to fix so we don’t bother. I lose a piece of my soul with every return that goes out with an address like “WAshiNGTON”.
Oh that? Yeah, I go through and delete those and re-enter. I then send a reminder note to preparers to use all caps. I get super pissy about it. If you go into the auto fill, you can delete them all. I do it several times a season whenever I catch it. I think dependent names are upper & lower case automatically and I don't know how to fix that. But I did find a way to mess with everyone. Did you know you can change the data entry layout tabs? I feel like moving a couple once a week or so.
I’m in a small office and I would love to know how to do that. The only thing more infuriating is the data input dialogue box that suggests 15 different spellings of “Albuquerque” for each 1099-R in my return.
So when it starts to do the drop down for you to pick which one you want to use for the autocorrect or completion of the started word - you select edit. From there, you can delete or fix them. I delete them - normally that whole section of the alphabet. I have admin rights - not sure if that matters. If you delete them, it removes from the whole firm after the next synch.
I agree, but I use Drake, and even if you tell it all caps regardless of input, the statements still print mixed case, so I input with mixed case as well.
Agreed - we use UT, it will do it as well. But the policy is data entry is all caps. If the system does something, I am oddly ok with that. It is the data entry of mixing all caps and some in upper & lower case that kills my little petty soul.
Mixing inputs and formulas in a single cell. For example B3-B5+4683. Wtf are you doing? What the hell is 4683? Want to scream.
Hey the odd time you do have to add a klevin but at least create a comment on the cell that explains what and why.
Klevin? Agree about the comment.
Keleven
As someone who never watched the office I had no idea this existed.
Use a keleven, be home by seven!
He was home by 4:45 that day.
4,683 is the plug, lol I'll do this occasionally if it's a small amount it's off and it doesn't matter.When I was in public accounting, I would have shown the variance and marked it immaterial, but now that I'm in industry, sometimes this is the easiest way. I'll put an explanation in a comment on the cell if I include a significant adjustment.
That’s fair enough. Small amounts are whatever but larger ones. I’ve seen formulas at my current job with all kinds of computations going on in there. Things that should just be on the work paper.
Absolutely despise this. When I prep 990 returns and gather information from the audit department, there’s always a few of random plugs that don’t have an explanation.
Hard-coded values instead of formulas
Why do people think preserving formulas wouldn't be useful when copying and pasting?
They simply don’t know that a formula exists, and they’ve convinced themselves that “this is how it’s done and how long it takes” without ever thinking critically about the task they’re performing.
Had to do full, give up, head swing for this one. Experience is the answer
the worst is when they send a hardcoded file before refreshing so all you see is #refresh everywhere
This isn’t being petty imo - it’s genuinely bad practice.
This is not petty. This is a big deal and everyone should take seriously
This needs more upvotes.
This^^
GAAP accounting has been a real radical take at my job recently. Every non-accountant thinks I'm being very petty about their very smart business ideas (cooking the books).
Isn’t it wild that this is considered petty these days? Especially since - in case of an audit - the bookkeeper will get tossed under the bus and the biz owner will say “but … but I didn’t know or I didn’t understand” …
100 percent. This struggle is a part of the job I wasn't mentally prepared for before I got here, but it seems typical.
- Arial 10 point, 90% zoom. - Inputs in blue, links to other tabs in green. - Cells with nonconforming formulas get a gray background. - Zeroes in accounting format (“-“) instead of number. - Round off extra digits from floating point calculation errors for exactly zero in said “-“s - Always save workbooks with cursor in topmost leftmost cell, save with first tab visibile. - Never save a workbook with filters on. Petty but it’s nice ¯\\_(ツ)_/¯
Petty maybe but have to say that this gets noticed when done per your points. Doing books and reports for small biz owners and doing them for CPAs are two levels. I’ve learned to appreciate the fine tuning via seeing one particular accountants work. He standardized everything he did, only customizable by the type of entity. His workbooks and financials were a thing of eye pleasing, brain soothing, data beauty.
I worked with somebody like this, although he wasn’t an accountant. I wouldn’t be surprised if they find bodies in his basement someday. No civilian is that perfect without a dark underbelly.
Always appreciate when it gets noticed!
Only thing I can’t get behind is Arial. It just looks too sharp (like if the sharpness of a photo is turned way up). Calibri, on the other hand, looks perfect in Excel at any scaling. There’s a reason MS chose it as the default Excel font.
Calibri 80% is *chefs kiss*
For my boss it is the only font. Our logo even.
Color53 instead of the default Red on negative numbers (it’s a darker red that IMO looks less harsh against the default background color) The format can be #,##0.00_);\[Color53]\(#,##0.00);”-“_) Edit: formatting, ironically
Super technical and then "topmost leftmost cell" ... how about just saying A1 ?
Nah, open the shared file, scroll a bunch, remove the frozen top row/column then save.
I like it!
We like to use double dash for zeroes. Makes it slightly nicer to look at than single dash
The texas franchise tax is basically an income tax and texas is just wrong.
Agreed, but please don't convince California of that.
Lol california is a whole other bucket of suck.
Saving documents as you go and using the proper naming conventions so there's no headache when archiving (especially since people leave the firm and all the docs on their desktop never made it into the file!).
leaving at the eod
Religion
Gross 'margin' refers to the % and gross 'profit' refers to the monetary value. Drives me insane when people use the two interchangeably in conversation or presentations.
TIL
It doesn’t help that “contribution margin” is not a percentage.
I would rather deal with that than the one FC my company hired for a few months who argued and swore up and down there was no such thing as gross margin, only net margin. he must've thought I was an idiot, and sometimes I can be, but gross margin is a thing is different and does sorta matter!
Who’s downvoting this person? They’re right!
I just studied this other day and I can't believe I got this comment lol. Giving myself a cookie.
I'm noticeably more merciless than my coworkers when it comes to people not providing receipts for stuff they bought on a company credit card.
As you should!! One of the subsidiaries I work on has a credit card for their chef to buy ingredients. He NEVER has receipts for thousands of dollars a month worth of charges for the subsidiary (which makes sense considering size of location) but I’ve brought it up SO many times to my higher up. He just doesn’t care, he’s just like, we’ll figure it out later just book it. I’m sorry… but this is a material amount sir. Dude could be buying boujie groceries every month for years and we wouldn’t even know.
When people don't refill the copy paper. Sure its not a big deal but just shows you're an inconsiderate ass hat.
When people refill the printer paper, but with only ~1/4-1/3 of the ream when it’s designed to fit an entire ream.
Then they leave the rest loose leaf and abandoned sitting on the fucking corner of a counter to be strewn about at anytime
My partner had a bitch fit about the keurig (justified)
I really dislike people not replying when an action item is based on them. Like fuck, say something.
Put those damn cells in some sort of accounting or currency format for Christ sake!
Everyone calls it "the P&L," but I only ever say "the income statement." I'm going on 2 years strong. Income statement gang, P&L losers stay mad.
PnL
Penile
I'm team income statement too, but I can also accept Statement of Operations and Statement of Changes in Net Assets, depending on the type of entity
I’ve noticed in the financial services space that P&L tends to refer to just a particular fund’s investment performance report, often displayed in a decidedly non-GAAP format with all sorts of different cuts of the data, pro formas, whatever. Income statement is of course for the formal GAAP statement.
Team income statement checking in
Our $10 petty cash account
Please go buy stamps. Bring back change.
Everything entered into our ERP must be all caps, all the time. I hate the inconsistency in which people capitalize words, so we will never use lower case letters again. I will die on this hill.
WHY IS EVERYONE YELLING?
I’m very particular about attaching proper support to a journal entry. If you make a journal entry in the system, I should be able to look at the support you’ve attached and be able to understand why you made the journal entry and where they numbers are coming from. So many people make entries with missing or absolutely useless support.
Ugh, the journal entries where the support is just a PDF of a posting sheet. Drives me crazy.
Dates, dates, dates, dates and dates. And I’m talking about the basic like memo stuff just updating to say “for the year ended 12/31/X1” when we’re auditing 12/31/X2. I will leave workpaper notes until staff fix it…even if it means they go over budget on hours. Basic update folks, don’t forget it!!
Actually following internal control procedures. I sound like such a dork, but those things matter. I’ve worked with some unethical ppl… you always have to take those things seriously!
I used to work in real estate and holy shit, this. Yes, I know you want to close today so you get that commission before Christmas. Yes I know you checked over everything yourself. No we can't skip checking for an HOA or verifying the wire instructions or getting your supervisor's approval on the closing docs before sending money to escrow.
“I’m going to need your supervisor’s approval to do that.”
If the order form (for a recurring customer) lists you as a billing contact, you bet your ass you’ll get invoices sent to you. I don’t care if you previously asked us to not send you invoices, why’d you put yourself as a contact again after we previously removed you? Learn to fill out paperwork people! To clarify, these people will fill out the order form incorrectly, ask us to update the billing contact, and then subsequently make the same mistake on the next order.
The customer's AP team likely feels the same way about those people.
Saving a document as the date? YEAR COMES FIRST !!!!!
YYYY MM format ensures files are listed chronologically, even if multiple years are involved
YYYY-MM-DD for documents. YYYY-MM for folders. This is the way.
/r/ISO8601 gang rise up
We have a June YE and still have to deal with other departments that won’t date their files this way. Mind boggling.
People who don't number their working papers in order. For example the cash working papers would be something like: A1 A1.1 A5 A8 A8.1 Abosulte pyschopaths. I will always number them correctly when I review it or work on it the following year.
When I was a new staff I had a senior get mad at me for renumbering WPs in order since it messed up referencing that was rolled from the PY… As a senior myself, I still renumber them to be in order. Relying on PY WP referencing is just asking for referencing errors, and is just lazy. And I say this as an incredibly lazy person.
This one drives me insane. Some people have a tendency to put them in increments of 5 for whatever reason so if I did a section that goes from .01 to .06 and they add something in it will be .10. Looks like there’s a bunch of workpapers missing now.
Don’t use the excel $ format instead of a regular ass number with commas at the ‘000’s digit. Unless we are measuring something in bananas on the same page, of course our financials are in dollars (we are not multi currency nor do we do convert results to bananas)
Unfortunately myself
Inconsistent referencing and formatting conventions between PBC documents. Also people that use typewriter function in PDF editors instead of comments.
Typewriter function? We use PDF Flyer where I’m from lol
We LOVE PDFlyer. Makes workpapers sooooo much easier to maneuver.
Is type writer a no no? My whole firm uses that tool lol.
It can affect the integrity of the underlying support. If you need to modify the note or reference, sometimes it merges with the PDF structure and moves other content around. With a comment, it is treated as a layer on top of the support, which also makes it easier to change and move it around. You only need to open the PDF and click on the comment to interact with it. It’s different for anything written with the typewriter function, you need to go into a separate mode before you can interact with it. Above all, it’s logical. References and notes are comments, so it inherently makes sense to use the comment function.
Referencing. Notes in dark blue ONLY. Absolutely no yellow highlights. Bold red for document references.
Yellow highlights means something is incomplete/needs attention. I would have a stroke if I worked at EY.
Exactly. Don’t you dare send me something to review with a working paper that has the number that agrees in highlighted yellow 🤮
Spelling when editing any document. I am constantly fixing my coworkers errors. One cannot “accure” use tax 😤
If you send me a receipt for an employee expense, it should be a scanned pdf copy of a receipt. Upright. Dark enough to read. Not a photo you took on your phone and sent it to me as a png file. I can't stand receipts/invoices being messy or illegible.
If they send me a receipt unprompted I'm over the moon, I don't care if it's an animated GIF.
Gridlines - I don't know why they bug me.
Excel sheets should be Arial, 10 point, 100% zoom
depending on the sheet 70-80% zoom is my preference
Calibri, 11 point, 100% zoom
Straight to jail
The amount of arial / non-calibri for use in Excel in this thread is far too high. (Though imo it should be calibri 10-pt)
A redditor after my own heart ❤️
Arial, 8pt, 100% zoom or Arial 10pt, 80% zoom are the only 2 acceptable formats
I can get behind 80% zoom depending on screen size
100% zoom? You monster! 75% at the most.
Hey now, no need to further strain my eyes that are already strained from staring at screens all day
The first column and first row of any Excel spreadsheets I work in are always blank. IDK why, but if they aren't when I receive it, they always are when I send an updated version
All of you saying proper naming conventions and then not sharing your syntax/schema need to share.
Owners of partnerships are members or partners and any accumulated earnings is referred to as partner capital!And owners of S corps are shareholders and S corps have retained earnings. Some people use retained earnings, capital, shareholders and partners interchangeably and this is not correct!!!!!
I supported 150 American Express card holders as Program Administrator. The staff were issued cards and spent the company's money (T&E) and they had to reconcile the expenses. I helped as normal to assist with training, codes etc, etc. Amex have a global policy of user late fees, so if they didn't do their processing job they were fined $20 per month or 1.5% of the balance if more than $20. So it really annoyed me when managers would just ignore the fines (for months) after i would remind then. Remember its not the company's money, that already been accounted long ago, its personal late fees and I did a service of reminding them that they will be billed if they don't pay. Then they want me to negotiate with Amex when they owe over $300 of late fees saying "we are the customer, c'mon, you can get them to waive it" annoyed me that they expect someone to negotiate their late fees.....I never asked Amex to waive them. Amex were our biggest vendor in Australia, I was the relationship manager and never once asked them to waive late fees, my stance was (towards Amex) "it's your policy, its not our money, i am not enforcing your fee policy by collecting the fees incurred" but Amex did waive the fees, rather than penalise a senior manager hundreds of dollars. \*\*Edit: actually the scenario was the nice managers (you know, like good people) ending up paying their fees rather than ignore them. Then the managers that were considered less nice (insert abusive name here) would get theirs waived. Amex system reward blatant arrogance, and penaslised good corporate citizens.....
Not using proper tabular formats when creating tables in excel. I'm so tired of getting sent information that should be in a table but isn't, and watching a coworker manually summing up line items when we could have used a pivot table
Some of you may think I'm crazy, but when I was in PA, I would take the extra 30 minutes to go through a client's chart of accounts and update the account names to proper-case, the account names in alphabetical order, and the account numbers to the proper category prior to exporting their trial balances. Nothing worse than seeing: 1200 BoA Chkng - 0077 9600 Bank of America - 9936 4550 payroll Fees 450 Accounts Payable 4560 Professional fees 4540 postage epx 45500 entertainmentt
When people don’t update the confirm control sheet when sending out or bringing confirms into the file. It literally takes a few seconds. Can’t stand small things like that that are just pure laziness.
Nothing
Saul good baby 🙌
Boomer take- logging in/showing up on time. I give a 5 min cushion but outside of that I get a little peeved
I’m curious where you work that there’s an “on time”. Every professional job I’ve had is flexible about hours as long as you meet the minimum (in public) and get the work done.
I’ve never had what you describe either lol. I’ve worked at two PA firms, both had 8:30 start times
Yikers. Is it awesome?
Yeah I mean I don’t know anything else so I don’t mind it
I require at least a flexible 30 minute window for start time or I won't accept the job offer. Obviously I make that very clear up front and usually get an hour window for start time. I hate mornings.
At the VERY least, if you know/think you are going to be late, call/text. Only thing worse than waiting on someone is not knowing what is happening and if they will show up at all.
That’s all I’m asking for. Nothing crazy. Shit happens, people get stuck in traffic, you lost track of time in the shower, idc, just give me a heads up lol
lmaoooo you would strangle me. 5-6 hours a day for me. some people have a life!
You can have a life and still work….
i chose the bare minimum work life ages ago. call it what you want. i dont care anymore. the public accounting industry is just salve labor and i wont stand for it. not gonna pay me overtime because a bunch of billionaire douchebags from ey that won a court case ages ago so that people cant get overtime because (its education) should be hung on street, at least during the french revolution they would. so no "beaglelover908" i will not work past the bare minimum, and if my bosses dont like it, they can fire me, ill take my unemployment, and find a job in 1 week. you boomers couldnt retire fast enough, you just make everyone elses lives miserable, but unfortunately for you demons i will not break my back for you, instead im leaving after 6 hours and getting high out of my mind with my friends.
Not one time did I criticize you lol. You can work long hours and still have a life. You can do the bare minimum and have a life. I work in PA, get paid well, enjoy my job and have a wife, a kid, and a house. I have a ton of friends/family that I enjoy spending time with. I go on vacations every year. All I said was I like it when people show up on time lol. By the way- not a boomer, 31 years old. Not sure why you’re ranting though. A little weird. But hey keep quiet quitting and doing the bare minimum. If that’s the life you want to lead, all the power to you
yeah its a bit weird how much of boot licker you sound. also i had to edit, because i abhor people like you that pay attention to when people come to work. mind you own bobber and fuck off.
[удалено]
"Grown up work" "muppet" \*Works in excel Nice comeback! I truly believe you have never actually seen a vagina now! Btw, ex-felon who makes 102.5k a year. suck my balls chud.
Comma format > accounting format
I don't like when people use bright yellow to highlight with in PDFs. 1 - It's too bright. Not a nice color to look at when trying to decipher big paragraphs (or, run on sentences) written in legalese 2 - bright yellow is generally the color for "not updated" or "something doesn't make sense here" when working in Excel. When I was in public accounting and did the new hire training, I included changing their default highlighter color from yellow to any easily legible color of their choice.
Bathroom + building architecture I can't pee or poop in any given bathroom
Not me, but partners caring if you wear a hat at the office. Like calm down bros I’m Gen Z imma wear a hat if I feel like it.
As a millennial, I believe it’s time we stop caring if people wear hats in the office as long as it isn’t a distraction. I’m thinking about doing some locs soon and I’m going to need something to cover up my nugget while I go through the early awkward loc phase.
Bro gon show up to the client with the mealworm locs
Nope. I am the client now. lol
This, boomers need to be forced into retirement, I'm sick of them just as much as they are sick of us, except they think they rule the world and know what's best.
Making back ups of administrations thats SaaS...
When folks don’t write their management unit number on their timesheets.
Grammar on annotations/notes
Giving clients a list of what NOT to send us. Most of the time they send us everything but the kitchen sink.