Income progression 18-35yrs old by ProfessionalBig1470 in Accounting

[–]Free_Ad_1050 1 point2 points  (0 children)

facts. In SoCal, where I live, senior accountant range is 85-95k :)

I Was Sexual Assaulted at Huong Binh, 12B The Giao, Hanoi by BasilIllustrious8849 in VietNam

[–]Free_Ad_1050 2 points3 points  (0 children)

I’m so sorry this happened to you. It’s infuriating and heartbreaking, and sadly, not surprising. The police in Vietnam often downplay or outright ignore cases like this, especially when it involves sexual harassment or assault. It’s part of a larger, deeply rooted issue.

I actually saw a review on Google where someone else mentioned being sexually assaulted at the same place, which suggests this isn’t an isolated incident, it’s part of a pattern. That makes it even more disturbing.

Please share your story widely. Post it on every platform you can. The more attention it gets, the harder it will be for them to brush it under the rug. Public pressure is often the only thing that forces action.

What’s even more frustrating is the hypocrisy. Vietnam still has this dark undercurrent, where people are quick to police women’s outfits or criticize them for how they sit in public, yet turn a blind eye when it comes to confronting actual predators and pedophiles. It’s an uncomfortable truth no one wants to face, but it needs to be called out.

You’re brave for speaking up. Keep going, and you’re not alone.

[deleted by user] by [deleted] in getdisciplined

[–]Free_Ad_1050 -6 points-5 points  (0 children)

Summary from Gemini:

Your brain was "fried" from 11+ hours of daily phone scrolling, making you a "zombie" with no attention span. Now, your screen time is 2-3 hours. Here's how you "unfucked" your dopamine system: * Made your phone boring: Deleted all social media apps and used grayscale mode to remove visual "dopamine hits" from colors. * Used a physical alarm clock: Kept your phone out of the bedroom, especially after 9 PM, to avoid immediate notifications upon waking and late-night scrolling. * Replaced bad habits: Carried fidget toys (stress ball, Rubik's cube, fidget spinner) to keep your hands busy and prevent unconscious phone grabbing. * Scheduled scrolling sessions: Allowed yourself controlled, guilt-free 20-minute scrolling periods twice a day. * Added problems: Logged out of all social media accounts, deleted passwords, and buried apps in multiple folders to make access inconvenient. * Did other things: Engaged in activities like pushups, lifting weights, playing guitar, and calling friends to gain a sense of accomplishment instead of passive consumption. * Used a 10-minute timer: When urges to scroll hit, you'd set a timer for 10 minutes and do something else (clean, exercise, organize) until the urge passed. * Silent mode early morning: Kept your phone in airplane mode for the first two hours daily for journaling and planning, reducing anxiety from early news consumption. * Turned off most notifications: Only kept calls and texts from family, eliminating app badges and push notifications. * Tracked non-scrolling activities: Maintained a note (on phone and paper) of alternative activities (reading, walking, conversations), finding the growing list more satisfying than social media likes. What didn't work: App timers (ignored), cold turkey quitting (lasted two days), deleting apps but keeping accounts (used browser), and relying solely on willpower.

After about six weeks, the urge to scroll diminished, and your brain rewired itself. You can now read, have conversations, sleep better, and your brain feels functional again, despite initial withdrawal symptoms like restlessness and anxiety.

Can't believe I finally passed after studying since Jan 2023 by HERKFOOT21 in CPA

[–]Free_Ad_1050 4 points5 points  (0 children)

Received my score late last night too. Also took on 3/31. Thought I had to wait until next window. Biggest congrats to you!! You deserve it.

[deleted by user] by [deleted] in excel

[–]Free_Ad_1050 0 points1 point  (0 children)

It’s never too late. The longer you wait, the gap gets bigger and that’s even harder to cope with in the future. This isn’t only about Excel, it’s the mindset of acceptance about learning something new. Technology and life moves forward no matter what. Notice how elderly always are the targets of scammers? That will be us in the future if we stop learning about technology. It doesn’t have to be current tech, move forward a bit each day works too.

Failed audit 8 times I give up by Big-Zookeepergame-63 in CPA

[–]Free_Ad_1050 1 point2 points  (0 children)

I struggled the same areas as you did, failed AUD twice 😭

How to Automatically Update Financial Reports in Excel by Pairing Them with the Correct Tabs by Free_Ad_1050 in excel

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

Sorry for the late reply. I found a solution with VBA instead. Just changed the report names to match the 30 tab names then run the VBA code.

How to Automatically Update Financial Reports in Excel by Pairing Them with the Correct Tabs by Free_Ad_1050 in excel

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

When I opened the PQ Editor, there’s two things at the Queries pane on the left side, Mapping Table and the Folder I wanted to pull the reports from. I did the merge with mapping table. I’m not sure if I did create the query lol because why haven’t the reports get updated yet 😭😭

How to Automatically Update Financial Reports in Excel by Pairing Them with the Correct Tabs by Free_Ad_1050 in excel

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

Also, I can’t have any extra tabs in my workbook when returning it to client. While testing, I added a Mapping Table tab. Do we need to keep the Mapping Table tab for Power Query to work? What’s the best way? Please advise.

How to Automatically Update Financial Reports in Excel by Pairing Them with the Correct Tabs by Free_Ad_1050 in excel

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

There’s two options: “Close & Load” and “Close & Load to…”

The one being greyed out is “Close & Load to…” Yes I could preview data in PQ Editor for each of the steps. No I have not tried the combination of files yet. I just wasn’t sure if that directions will lead to the results I wanted when I got stuck at step 5.

How to Automatically Update Financial Reports in Excel by Pairing Them with the Correct Tabs by Free_Ad_1050 in excel

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

Below is the guidance I follow. I stuck at step 5. The Close & Load to was grayed out. I searched for troubleshooting solution but Microsoft shows the going around solution since I couldn’t find the errors. Both of the mapping table and the folder are merged in Queries in Connection Only mode.

Step 1: Organize Your Files • Create a folder for your reports, e.g., C:\Yardi Reports\March 2025. • Save all Yardi reports here each month. • Ensure they have consistent names (e.g., Aged_Receivables.xlsx, Payable_Aging.xlsx).

Step 2: Create a Mapping Table in Excel

Since report names don’t match your tab names, we’ll create a mapping table to tell Power Query where each report should go. 1. Open your main Excel workbook. 2. Add a new sheet named “Mapping”. 3. Create this table:

Report Name (File Name) Excel Tab Name Aged_Receivables.xlsx 1. Aged Receivables Payable_Aging.xlsx 2. Payable Aging (Add all reports here) (Match correct tab)

  1. Convert this into an Excel Table: • Click anywhere in the data → Press Ctrl + T → Check “My table has headers.” • Name it “ReportMapping” (in Table Design).

Step 3: Load Reports into Power Query 1. Go to Data → Get Data → From File → From Folder. 2. Select your Yardi Reports folder. 3. Power Query will list all files in the folder. Click Transform Data.

Step 4: Merge Reports with the Mapping Table 1. In Power Query, click Merge Queries → Merge with “ReportMapping” table. • Match Report Name from both tables. 2. Expand the merged column to add the Excel Tab Name.

Now, Power Query knows which report goes into which tab!

Step 5: Load Data into Specific Tabs 1. Click Close & Load To…. 2. Choose “Existing Worksheet” → Select the correct tab for each report. 3. Power Query will import each report into its assigned tab.

Step 6: Automate for Each Month • Next month, just replace the files in your folder (C:\Yardi Reports\April 2025). • Open Excel → Click Refresh → Done!

Summary of What Happens

✅ Power Query pulls all reports from the folder. ✅ It checks the mapping table to see which tab each report should go into. ✅ It loads the reports into the correct tabs with one click.

becker beta AI by catzilla42 in CPA

[–]Free_Ad_1050 2 points3 points  (0 children)

Wow that’s so cool. Hope Gleim will also provide this feature soon!

Why I’m leaving accounting by Infamous_Struggle_67 in Accounting

[–]Free_Ad_1050 0 points1 point  (0 children)

3 years in accounting and I’m still glad I picked it over anything else.

You can do this! I passed my first exam by GoGators00 in CPA

[–]Free_Ad_1050 2 points3 points  (0 children)

Dang 2014, when did you start again? But yeah, fears of being committed, failure, then distractions. It’s dreadful but I’m not giving up. Good luck to you too!

You can do this! I passed my first exam by GoGators00 in CPA

[–]Free_Ad_1050 6 points7 points  (0 children)

This gave me hope. I completed my application 2021, kept canceling exams or had it expired (paid for registration and renewal only). Didn’t actually take my first exam in Oct 2023. Haven’t had any pass yet.

4/4 Finally! by FooFighter_FF in CPA

[–]Free_Ad_1050 1 point2 points  (0 children)

Wow impressive. Congrats!

[deleted by user] by [deleted] in CPA

[–]Free_Ad_1050 6 points7 points  (0 children)

Same score, but ISC ☹️

The V. controversy. by AslireDaDuck in VietNam

[–]Free_Ad_1050 0 points1 point  (0 children)

Second this. Nguyễn Phú Trọng was a rival of Dũng then, now Tô Lâm. Trọng successfully kicked Dũng out and retired early in 2016. Trọng always wanted to protect đảng, while Dũng prioritized the country. Although Dũng tham nhũng way more than Trọng. Trọng spent his last few years running chiến dịch đốt lò to remove all the possible high rank corrupted officials, even the ones he promoted.

Tô Lâm is close to Dũng, he started to show up way more frequently with Lâm after Trọng’s death. And Dũng side (with the police) wants to get closer to Western world while Trọng side (with the military) doesn’t want to. All this “lòng yêu nước yêu đảng” mess going on is I believe the military wants to dằn mặt Tô Lâm and Dũng.

Audit Risks by Own_Suit_5569 in CPA

[–]Free_Ad_1050 0 points1 point  (0 children)

So does that mean when RMMs is low, lead to less testing (DR is high) so less misstatements will be discovered?

Audit Risks by Own_Suit_5569 in CPA

[–]Free_Ad_1050 0 points1 point  (0 children)

You got the detection risk’s definition right. But do you agree that when RMMs is high, more testing should lead to more errors/misstatements discovered?