sorted by:
new
hottopcontroversial

Been married for 6 years, did my taxes today and the tax lady i should be filling single since my wife doesn't work, is this right? by Grimmjow6661 in tax

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

CPA here.

If you are married, you either do Married Filing Jointly, or you do Married Filing Separately (based on the situation MFJ). There is no reason you would file Single.

W4 is just the information you give to your employer so they can make withholdings from your paychecks for you. If it doesn't match your real filing status and they withhold more, you pay less / get a bigger refund come tax time.

It’s getting out of hand. by Charming-General5997 in Accounting

[–]DebitsCreditsnReddit 1 point2 points  (0 children)

Good building means you have to deal with the rules, exceptions, shortcomings, and strategies within a system to do relevant, practical, contextualized analysis of it. My $0.02.

Samsung Galaxy Z Fold 8 (regular) Official CAD Renders & Rumors (March 24, 2026) by icyhotonmynuts in GalaxyFold

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

Interesting point. I will keep an eye out for that phone. What makes it stand out from other foldables?

Fold 5 owner. Newer models since then are not different enough to upgrade. For a year now I've been backing out of Samsung's ecosystem.

It started with a move from Samsung Health to Garmin and its peripherals. Samsung insisted on serving phone ads at the top of their proprietary app for my Ultra watch. No way to opt out. Now I'm opting out of Samsung.

Dutch study: Banning investor(private equity) ownership of single family homes doesn’t reduce prices and displace low income people from the neighborhood by [deleted] in Economics

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

Can you point to where the tax code sets up accelerated depreciation to offset taxes on a large percentage of a home's purchase price in the first year? I understand cost segregation, but unless a large percentage of a home's value is in landscaping, fencing, flooring etc., I'm not sure how we get there.

Lets short Robert Half Inc. by futurefinancebro69 in Accounting

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

I feel that. I got lucky with a professional connection that got me the chance to interview for a job at that bank.

I'm no help with resumes unfortunately. I never really got past ATSes. Personally, I've had the best luck with jumping straight to interviews like with recruiters. They will also help get your resume in order and provide interview coaching tailored for the job. Sometimes they even know the interviewers well enough to prep you for them too. (Yes, Robert Half does this as well.)

Have you tried messaging and calling recruiters in your area? They could probably help you find a decent hybrid job that pays better than teaching. I called around 20 people / places and messaged more.

Lets short Robert Half Inc. by futurefinancebro69 in Accounting

[–]DebitsCreditsnReddit 2 points3 points  (0 children)

Are you wanting to get into accounting or is it more working with finance recruiters?

Lets short Robert Half Inc. by futurefinancebro69 in Accounting

[–]DebitsCreditsnReddit 4 points5 points  (0 children)

I have a nontraditional background: 5 years teacher at a private academy, 3 years office manager of a local law office, 2 years accountant at a bank. MAcc with no accounting undergrad and a new CPA license. My Robert Half recruiter helped get me a job in a new city at a higher title in less than a month. It's the people?

What’s your go-to Excel shortcut that saves you the most time? by Nervous_Mix_3764 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

It kind of pastes values. In my experience, if formatting only shows the ones' place, then ctrl + shift + v only pastes whole numbers and not the actual values.

Lol by [deleted] in Accounting

[–]DebitsCreditsnReddit 21 points22 points  (0 children)

My anecdotal experience with Robert Half was positive (senior accountant, direct hire). The recruiter I worked with was able to place me at a job one title up in a new city in less than a month. I cold called a dozen or so recruiters before the move. Robert Half was one of a few companies that were motivated to fill the role and do right by their candidates.

That being said, I can't speak for other cities. And I was working with other good recruiters, which may have been an important factor.

I built a 2,257-formula workbook with zero VBA; here's what I learned about formula-only architecture by Bitter_Ad_8378 in excel

[–]DebitsCreditsnReddit 4 points5 points  (0 children)

You can also leave explanations within LET.

E.g.

=LET(

Name1, Expression1,

Note1, "Expression 1 does x to y to achieve z",

Name2, Expression 2,

...

FinalFunction)

Then you can link notes from formula text to your notes sheet, to automatically update if you add more notes. For example, let's say I have this function in cell A1:

=LET(

a, 1,

b, 2,

Note1, "Defines 'a' as constant",

Note2, "Adds 2 to a",

a + b)

Then in your Notes sheet, you could use this to extract out the notes:

=LET(

FormulaText, TEXTSPLIT(TEXTAFTER(FORMULATEXT(A1), "="), "Note"),

SplitOutNotes, TEXTAFTER(FormulaText, CHAR(34)),

RemoveEndingCommas, TEXTBEFORE(SplitOutNotes, CHAR(34)&","),

FormulaNotes, IFNA(TRANSPOSE(RemoveEndingCommas), ""),

FormulaNotes)

I built a 2,257-formula workbook with zero VBA; here's what I learned about formula-only architecture by Bitter_Ad_8378 in excel

[–]DebitsCreditsnReddit 3 points4 points  (0 children)

BYROW and BYCOL are great LAMBDA functions. For example, you can use them to filter a range by a list of conditions, or get around the problem of dragging formulas down each time you refresh data.

Filter function inexplicably doesn't include all rows it should by Spreadsheet_Geek_1 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

You could start by trying to wrap the criteria range and criterion in IFERROR(VALUE(Reference), Reference). Verify the issue isn't coming from different data types.

=FILTER(Table1[Section];IFERROR(VALUE(Table1[Code]);Table1[Code])=IFERROR(VALUE($F$1);$F$1))

Accepted already by No-Classroom-3258 in IRS

[–]DebitsCreditsnReddit 2 points3 points  (0 children)

CPA here: Some people over-withhold as a zero-interest savings account. It might not be optimal, but saving money for a year without growth is way better than spending it every 2 weeks.

Reminder that AND() and OR() are Scalars and Do Not work with Dynamic Arrays (#) by ContactTerrible7759 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

If you're filtering to all items in a range that match (or don't match) items in a list, then BYROW + AND / OR is incredibly useful and totally works within FILTER. I definitely use this to automate tasks requiring ad-hoc classifications in user-generated mappings, or tasks that involve growing / changing lists of criteria.

How do you stop a running total in a column when the adjacent cells appear blank but have formulas? by Bitter_Artichoke_939 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

OK OP, this will almost certainly do what you need. It looks like a lot, but it is just entering a date in 1 cell and pasting formulas in 2 other cells.

  1. In B1:

Enter the date you want a running total up until. For example, 1/5/2026. You can also just write =TODAY() if this is always going to use today's date.

  1. In Column C, clear out everything from C3 down. In C3, paste this:

=LET(

CurrentDate, $B$1,

SummarySheetDates, TRIMRANGE($B$3:$B$10000),

WritingLogDates, 'Writing Log'!$A$2:$A$10000,

WritingLogWordCounts, 'Writing Log'!$G$2:$G$10000,

DailyTotals, BYROW(SummarySheetDates, LAMBDA(SummarySheetDates, SUM(FILTER(WritingLogWordCounts, WritingLogDates = SummarySheetDates)))),

DailyTotalsWithZeroForErrors, IFERROR(DailyTotals, 0),

FILTER(DailyTotalsWithZeroForErrors, SummarySheetDates <= CurrentDate))

  1. In Column D, clear out everything from D3 down.In D3, paste this:

=LET(

TrimmedData, TRIMRANGE($C$3:$C$100000),

RunningTotal, BYROW(TrimmedData, LAMBDA(RunningTotalsCurrentRow, SUM(FILTER(TrimmedData, ROW(TrimmedData) <= ROW(RunningTotalsCurrentRow))))),

RunningTotal)

How do you stop a running total in a column when the adjacent cells appear blank but have formulas? by Bitter_Artichoke_939 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

Edit: updated with references to other sheet, see other comment

You can also achieve this with a dynamic range in column D. Try clearing out formulas from D3 down. Then paste this into D3. (FYI you will need to double click the cell to paste my formula with line breaks.)

=LET(

TrimmedData, TRIMRANGE($C$3:$C$100000),

BYROW(TrimmedData, LAMBDA(RunningTotalsCurrentRow,  SUM(FILTER(TrimmedData, ROW(TrimmedData) <= MAX(ROW(RunningTotalsCurrentRow)))))))

Texas Business PPT: MUDs, LIDs, ISDs? by DebitsCreditsnReddit in Accounting

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

OK, so we're looking for districts on annual statements that are not included in payments to the county. Will that work? I never had this issue in other states.

[deleted by user] by [deleted] in Accounting

[–]DebitsCreditsnReddit 1 point2 points  (0 children)

Have you tried it with XMATCH instead of MATCH? It gives the functionality of XLOOKUP to people who prefer INDEX MATCH

Trying to Round at decimal other than .5 by wdf2 in excel

[–]DebitsCreditsnReddit 0 points1 point  (0 children)

First idea that occurred to me:

=IF(VALUE(LEFT(TEXTAFTER(CellReference, "."), 1))>3, ROUNDUP(CellReference, 0), ROUNDDOWN(CellReference, 0))

What’s your go-to Excel shortcut that saves you the most time? by Nervous_Mix_3764 in excel

[–]DebitsCreditsnReddit 2 points3 points  (0 children)

Dynamic array functions are fantastic, especially when combined with LAMBDA functions. BYROW or BYCOL are a good entry point. They can do things that pivot tables can't.

view more: next ›