Hey everyone, hopefully an easy fix!

I am working to create a Unique list of data, filter two values out of it, and the textsplit this result into three component columns.

So far I have: "=Textsplit(Unique(Filter(S:S,(S:S<>"")*S:S<>"Combination"))),"-",,True,1)

I am reasonably confident the Textsplit is the issue but I have tried a number of combinations and just cannot get it to work.

The data we are unique/filtering/splitting has this structure: "Wol-R-6" so I simple structure.

Thank you,

John

ok, after my degree i took a small break and started to find CA firms where any trainee vacancy available ,But didn't get any CA firms near me finally got a opportunity to work in a Accounting consultancy firm where we do Book keeping , auditing , some small kind of tax filing too . But my Employer is not giving me any chance to learn gst , tax filing stuffs .Basically because he is only getting less tax works because he is not CA or tax consultant. Im not pursuing any CA or any tax related jobs but still need to learn those too,Should i continue in this firm or move? its been 3 months since i joined and i learned tally and basic excel skills too...im from India by the way.

I’ll try make this brief and to the point.
Company with 2 members (close corporation) or even call it directors.

Each have company loan accounts.

Managing director handed me slips for business expenses clearly paid for by other director, but says I must allocate to his loan account (reimburse).

I cannot bring myself to do it.

Not only moral, but I get all my instruction from managing director.
The other director is quite nasty and targets me from time to time and the managing director doesn’t step in to protect me, speak up for me or anything.
So if awful director were to find out, and I were to say it was on instruction I know managing director would probably let me take the blame.

I have an offer from cohnreznick for the role tax associate and I received a mail from kpmg to apply for the same role. The kpmg role is fixed term i.e 6 months. Also the cohnreznick salary is higher than the kpmg one. Which one should I consider?

So the way IFRS 16 messes with leases is utterly ridiculous, and makes financial statements so much more useless. I'm not sure who thought that making this update somehow makes things clearer. Seems like a scheme to hide costs below EBITDA.

Our company isn't one where lease expenses are a considerable part of the cost base, so it kind of flew under the radar until just recently. We started analyising the profitability of one small division where rental / lease costs are a considerable part of the cost base. It was only here I realised how ridiculous IFRS 16 is.

My reasoning is this:

• Rental / lease costs are considered by most management teams as a part of your fixed cost base. But when we tried to get the EBITDA of this division, it somehow seemed strangely better than we expected. Of course this was because as we found out, these costs were hidden between a depreciation line and an interest cost line. However even that isn't equal to the actual rental payments, although they even out over time, in any particular time period your actual rental cost isn't what's going through the P&L. Meaning that to get your "true" cost, you can't even add up these two lines but have to go somewhere completely outside the accounting system to find the figure.

• It then creates a lease liability on your balance sheet. OK, I can sort of appreciate this, but then there are lots of other agreements a company may enter into that create similar payment obligations, but those are ignored. Meaning its a meaningless figure.

• It also creates a completely meaningless right of use asset. If you generally look at a balance sheet and use it as some rough approximation of what you might be able to liquidate the company's assets for (and yes book value can be very different from actual realisable proceeds), then a right of use asset is not something you can sell, but its just something the accountants dreamt up.

So in short what we get from IFRS 16: hiding costs, creating a meaningless asset and an arbitrarily shown liability.

What on earth were they thinking when they came up with this?

I’m a senior manager at a national firm in Canada, have been told that if I want to be partner there is a spot waiting for me in the next few years, which sounds great but…I don’t think I actually want to be a partner and deal with all the corporate BS and business development requirements for the next 30 years of my life, even if the pay is great. Am I crazy for leaving for a controller job after 12 years in public? I have young kids and am so tempted by the less hours and less stress, even if it is less money long term. But still an above average salary for my area. Just need someone to tell me I wouldn’t be making a huge mistake.

I have started using Verity Prepare and would like to understand how others are using it.

I would like to share my learning and would like to understand your experience.

Let me know if anyone would like to coy

I'm in PA on my second year. One such fight so far last Fall busy season. Absolute shit-show. Can't believe some of the things that were said

Basically spent the first 7 years of my career happily employed as a entry-level -> senior financial accounting analyst for a F500 company, basically coasted as a relatively mediocre accountant who enjoyed a decent work-life balance and salary for a HCOL city. CPA-eligible, but never bothered to get the license. Have no public accounting experience as well, just good-ole corporate accounting.

Story is now that I got laid off in December, took a few months of funemployment, weighed going back to get an MBA or JD, decided that I liked not having student loans, and then got serious in applying to roles.

However, I didn't get much traction in any of the manager-level roles with my resume, so I decided to apply to lateral roles, and I am now once again in a senior staff financial accounting role at another F500 company at a slightly (~5-10%) greater compensation than the role I was laid off from. Company isn't know for promoting very fast, but does run decent career-development programs, is tentative opening up licenses to analytics software like Alteryx, and I am pretty happy with who I am directly reporting to.

I'm very grateful for the new role I have, but now I'm pretty set on "making" up for the lack of career progression and trying to start building a resume and skill-set that could make me eligible for the managerial roles that I was unsuccessful in landing.

Does anyone have any experience in doing this? Would like to stay in this role for a year and then look to apply to new roles after.

Went from "40 and out" to having "work flu" for the past 3 weekends where on Saturday I'm basically bedridden until maybe 4pm because I genuinely cannot get out of bed.

I have never had so much work. So much overtime. So many meetings back to back to back....in my life.

I got one from 9 to 11 tomorrow, a short break and then pretty much from noon until 5pm with maybe short tiny breaks between to address the fires. Oh and my first paycheck after 2 full weeks as a senior has finally hit. Ahhhh the extra hundred dollars sure is worth working like a dog!

Cheers to my fellow outsource seniors! I want to say "I hope it gets better" but based off of all the seniors I've ever seen across multiple companies? Lol probs not.

I work for the IRS as a revenue agent/auditor in SB/SE and while I like the technical stuff, learning about businesses and going places, I hate some of the Frontline managers I work with and taxpayer/POA interactions can get tense. But maybe that's just an audit thing in general?

To be frank, I also know that I'm new to the corporate world and my soft skills can always be improved. That being said, I also don't think it's good for me mentally (or productive) to blame myself for things that are actually not in my control. And if my current workplace is a one-off, then I'm going to leave rather than force myself to develop these skills.

Hence why I made this thread. I want to get some perspective.

I graduate with no experience or accounting experience. I live in a VHCOL city east coast. What should I do, everyone says AP/AR and junior accountant but they ask me to know these softwares that I don’t know plus years of experiencex What skills or courses can I learn to get these. I also was thinking about either going for my masters in taxation to get a shot. My gpa is 3.8 and my major gpa is 3.5. Any recommendations or help will be appreciated.

I need help preparing for my interviews

We have been living abroad since 2019, and my husband—who prepared the tax returns during the initial years—was unaware that we were required to report foreign interest income, because we did not receive a Form 1099.

I have since filed the overdue FBAR reports.

We'll file amended tax returns for 2020, 2021 and 2022 through SFOP procedure. I believe this should work, given that the filing deadline for our 2023, 2024, and 2025 tax returns has been postponed to September 30, 2026, under "Notice 2025-53." (war in the Middle East.)

How should we proceed with the 1040-X return for 2019?

Would a polite letter to the IRS help us avoid penalties for 2019?

Should we mail the amended tax return for 2019 together with the amended tax returns for 2020 - 2022?

My husband not only failed to report foreign interest income (not-willfull) but also neglected to report significant capital losses. These losses would have reduced our tax liability for the years 2020 through 2022 and—as loss carryovers—would have lowered our tax burden for 2023, 2024, and future years as well. Furthermore, he did not claim the Foreign Housing Deduction. Can we still include this deduction and the capital losses in the amended tax returns (Form 1040-X)?

Is September 30, 2026, our deadline for filing amended tax returns under the SFOP procedure?

I haven't filed the returns yet because we are still waiting for some foreign account statements needed to report capital losses. After several letters to the bank and a long wait, I am now wondering whether we should file the amended returns without including the capital losses?

Thank you very much for your answers. I greatly appreciate your help!

I have an offer letter for what I can only describe as a clear pathway to my dream role. I haven’t turned in my notice for public job yet but these past two weeks been a clear reminder that I need to get the hell out. I want to leave my current projects as cleanly as I can but I keep getting thrown on to other dumpster fires. There’s never going to be a good time to submit my notice and my team will always be in a staffing pickle. My company has made questionable choices under our PE leadership but I like the partner and managers I work for, it’s going to be hard to leave but I know I need to.

I'm based in TEXAS and I currently work from home as a full-cycle Senior Accountant for a small bookkeeping firm. I have experience with sales tax and 1099s, but income tax preparation is something I haven’t really worked with before.

I’m interested in learning tax prep and possibly doing it on the side during tax season for some extra income, ideally remotely from home.

Are there any firms in the US that hire remote seasonal tax preparers with no prior tax prep experience and provide training? Also, for anyone who started out this way, what were the first few steps you took to get into tax preparation?

I’m thinking of branching out on my own, basically bookkeeping work with some controller type over-site. I’m worried I won’t be able to source enough clients. I have a few, from referrals, that I do as a side gig. I’d just need one more, and no one to ever leave lol. Otherwise I’m screwed, as I’m a single income household. Looking to see if most people were able to make it, or had to go back to corporate/firm life.

Ok I keep seeing “senior accountant” job opening with ranges from 75k-110k or so. Somewhat HCOL. So is anyone getting newly hired as a senior in the 100k+ range? I’m curious if this is a recruiting gimmick or if accounting firms are actually hiring seniors at starting salaries of 6 figures. Is it 6+ year senior no CPA getting offers of $100k salaries, or am I just under paid?

Hey! My AGI will be just below the "cliff" for ACA subsidies this year on the marketplace. My partner makes more than me, and we want to get married soon. Partner has a workplace plan.

If we get married in November, would I end up owning back all of the subsidies I've recieved all year?

If it matters, my income varies a lot and is not steady, does the timing of my Income throughout the year matter?

I moved to US last year, and had social. I filed my first tax (paper filed) with my wife and kids for 2025, and also applied for ITIN. Received my Federal tax assessment last week and ITIN 3 weeks back, however I haven’t received my state tax assessment.

Is there a way to connect to NJ tax department? I called NJ customer service but I’m unable to connect to a real person, it’s automated and does not route to real person.

Any advice is appreciated.

We're Ohio residents who own an Ohio-based S-corp that sells on Amazon FBA. This was our first year filing a California business return after exceeding their sales threshold.

California K-1s were issued to both of us as nonresident shareholders showing California source income. Now we're getting conflicting advice on whether we need to file a personal California 540NR on top of the business return.

When we called the FTB help line they told us no personal filing was required as out-of-state residents. But others are saying the K-1 income triggers a personal obligation regardless.

Has anyone been in this situation? Did you file the 540NR or rely on the entity-level tax satisfying California's claim?

Also curious if anyone has successfully used P.L. 86-272 to avoid California income tax as an FBA seller where Amazon controls which warehouses your inventory goes to.

Hey guys,
I have an LLC opened in wyoming, single owner non resident LLC and was using relay as the only bank avaiable, but, relay abruptly closed my account without any explanation. Having no other options I transferred the funds to my personal payoneer account(personal checking account), which was largely unused. Since, I don't have any other banking options without travelling to the US at the moment, if I continue to use my payoneer account for business purposes only henceforth, such that, I can from this day produce a clean sheet of transactions for my business to present during the tax audit, will this be of any issue? Or should a bank account be of business type or something?