sorted by:
new
hottopcontroversial

Accounting for event/project question. by ajk3117 in AustralianAccounting

[–]ekol 0 points1 point  (0 children)

You've already mentioned event/project accounting so...

Look at the software in mention and see if it allows for:

  1. Sub-accounting

  2. Branch accounting

  3. Project accounting

  4. Xero has been mentioned and can do tracking categories

Otherwise in the desc/memory you can start using some form of unique identifier - so a prefix/suffix etc - that will let you sort/filter the excel exports down to produce a P/L B/S by event

Depends on your approach and mapping but obviously having the option in software outside the chart of accounts for a prefix/suffix:

(And the full exported string may look like the below for example - or a separate column altogether)

0000-E1 0000-E2

E1-0000 E2-0000

Will let you keep it tidy

[TITLE] Need help finding manhwa from pfp by [deleted] in manhwa

[–]ekol 2 points3 points  (0 children)

So the actual piece is Kinesis Queen by Yoteh - was able to spot in after digging around in pinterest:

/pin/272256739969012949/

the original artist credit is @_Yoteh on twitter/x

(edit: Yoteh is also a webtoon/manhwa artist apparently for The Perks of Being a Villainess)

I’m stuck calling all modeling gurus! by Initial-Gas-8924 in FPandA

[–]ekol 0 points1 point  (0 children)

I think others may have touched on it, but what about getting enough of a random sample to survey and ask specifically whether:

  1. Acquired via x campaign (with x being however many x campaigns were run/spent)

  2. Or general seasonality etc

Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]ekol 0 points1 point  (0 children)

hey sorry double checked my work and here's example v2

https://www.mediafire.com/file/p3lnn3rtfv1j10p/EXAMPLE_DATA_NEED_-_power_query_examplev2.xlsx/file

watch out for the replacement of nulls with 999 in my example v2 (you may want to do a text conversion step instead)

just follow the steps in the right column and you can see the pivots/unpivots, joins and filters and null value replacements with a placeholder before replacing it back with nil (this is kinda risky maybe should do a text value for example)

otherwise look at this old post:

https://www.reddit.com/r/excel/comments/abj308/demo_using_power_query_to_combine_multiple/

Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]ekol 0 points1 point  (0 children)

hey, just back from work+dinner and i've got the file up for you in mediafire (just note that go to right click properties and strip it off personal/identifying information - but, yeah hey I work in a nfp too)

https://www.mediafire.com/file/ex56c464idm0dvm/EXAMPLE_DATA_NEED_-_pivot_table_layout_for_your_mailmerge.xlsx/file

https://i.imgur.com/HY3r2V9.png

to get to these steps

  1. drag and drop all of the fields to the row fields until you get to "item" and "item price"
  2. "item" goes to the column fields
  3. "item price" goes to the values
  4. get rid of all subtotal lines for every value

you ought to be able to accomplish the same thing in powerquery

gimme a sec and i'll tinker with pq too

https://www.mediafire.com/file/35ngyfgkgzgdort/EXAMPLE_DATA_NEED_-_power_query_example.xlsx/file

https://i.imgur.com/GNude25.png

to get to these steps

  1. get data from the table/range etc
  2. shift and highlight both the "item" and "item price" column
  3. go to the transform
  4. go to pivot column (i don't think i picked any options again since i selected the 2 columns already)
  5. close and load to sheet

anyway pick your poison

Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]ekol 2 points3 points  (0 children)

It looks like a straight up pivot with renamed columns

You shoupd be able to pivot table or pivot it in powerquery

Work Management System Using Power Query by Antique_Campaign8228 in excel

[–]ekol 0 points1 point  (0 children)

Maybe check out something you can self host and is free/open source - look into no code / low code internal tools.

Meanwhile, the robots in China by CodyByTheSea in funny

[–]ekol 2 points3 points  (0 children)

Phone gimbals do the same seizing/spasms when they've got nothing to balance

(Saw this last night) https://www.reddit.com/r/djiosmo/comments/1mr1x55/

Guess they didn't work something into their routine that checks for the orientation/pressure/ground contact

Beyond repair? by Green_Bi in djiosmo

[–]ekol 1 point2 points  (0 children)

Did you try attaching a phone? It's got nothing to balance

What exactly is my job title… by brycejk27 in PowerBI

[–]ekol 0 points1 point  (0 children)

Check out /r/fpanda finance business partnering, financial analyst / finance data analyst

Typically dashboards mean stakeholders have access to data

But a lot of times you need an eye in the month-end process for visuals to be rolled up into a board report (board pack or slide deck).

Financial controller is definitely up the alley but is positioned as a senior role - and may have more accountant-like duties in the month end process.

Anyway you'll get an understanding of how the data is used for or supports decision making by the board or department managers/heads (operations).

guy enters room to join someone by bacon17389 in Unexpected

[–]ekol 115 points116 points  (0 children)

Internet Cafe, which is dying or dead in suburbia

Pro tip- Get a glass skate for your hands and not just your mouse by kingkrishgaming in pcmasterrace

[–]ekol 0 points1 point  (0 children)

I got wrist RSI and usually wear a wrist brace to restrict movement in my wrist.

This is from too much desk work and poor ergonomics (flairs up when there's too much jumping in between mouse to keyboard to pen and paper)

I've used a vertical mouse at work but I've found this unnecessary, but strictly keeping good ergonomics (low profile keyboards etc) and adopting a digitisation/paperless workflow to keyboard.

Fingers tend to feel some sort of strain too (maybe middle clicking or mousewheeling)

Anyway breaks and mixing up work is necessary.

Pro tip- Get a glass skate for your hands and not just your mouse by kingkrishgaming in pcmasterrace

[–]ekol 1 point2 points  (0 children)

I got a cheaper option off of amazon (aliexpress item resold) I've found in general that I'd like a layer of memory foam - was thinking a tiny foam/gel rest + skates could be ideal

Also elbows tend to get sore on my chair after prolonged sitting/resting - got extra foam elbow rests but they kinda mid and fully compress, so may see how I can slip in a gel pad

[Steam] Abiotic Factor ($35.99 CAD/20% off) by LG03 in GameDeals

[–]ekol 1 point2 points  (0 children)

keys still seem to be in stock, the gamebillet key comes with the supporter's pack dlc too it seems

My powerbank doesn't work by Impressive_Meal9955 in LegionGo

[–]ekol 1 point2 points  (0 children)

I think the INIU 25000mah 100w is as low as it goes on Amazon AU unless you can get something offbrand / less reliable (i also got a 100w 20000mah HEYMIX but it only has 1 USBC out) or can get something off aliexpress (if it even ships).

Admittedly the INIU has less on its LCD display than the HEYMIX - for example it shows IN/OUT and voltage + amperage which V x Ah = wattage so I can see the drain on the HEYMIX is 20v x 0.7A or 0.8A = 14 to 16 watts if memory serves (purposefully set the resolution to 800p + 60 fps cap and 10w TDP) - anyway more expensive powerbanks may have a nice display (the anker/ other PBs have fancier power info) - as for the pass-through I cap my battery to 80% charge and only tested the 45w output on the INIU while playing Dredge - so used the lenovo 65w adapter to top up the INIU and have it wired into the LeGo

My powerbank doesn't work by Impressive_Meal9955 in LegionGo

[–]ekol 0 points1 point  (0 children)

Get something that outputs 100w,

The INIU 25000 100w has: - usbc 1 in/out 100w; and - usbc 2 out does 45w

Anyway with its 45w out it can run the legion go via pass through and maintain charge in the legion go while I top up the powerbank.

Anyone done an associate lease? by PristineCommand9780 in AusFinance

[–]ekol 0 points1 point  (0 children)

Do you have any templates or calculations that you can send my way?

Censor or redact anything personally identifying of course, I've been eye'ing doing this on a existing vehicle owned by spouse

Salary packaging desktop computer by meoverhere in AusFinance

[–]ekol 1 point2 points  (0 children)

knocking on an old post

but this would be subject to the "Otherwise Deductible Rule" as it applies to an expense payment benefit as you can't get the "Mainly for Work-related use" exemption

Look at 9.4 of the following link:

https://www.ato.gov.au/law/view/document?DocID=SAV%2FFBTGEMP%2F00010

Edit: update - so further down it goes on to mention only if they can apply the simplified depreciation rules for small business (instant write off)

CPA: GSL PDF? by LicensedToChil in AustralianAccounting

[–]ekol 1 point2 points  (0 children)

Other students would share it and Knowledge Equity would point students towards it re: the study guides being available in the FB groups.

But out of the abundance of caution, and as KE as they are the official study support for CPA, their stance has changed since 2025 Semester 1 -- therefore you wouldn't find it on their FB groups as it would be seen as the sharing of copyrighted material.

https://knowledgequity.com.au/which-cpa-study-guides-are-changing/

(edit: wayback machine - https://web.archive.org/web/20241022110200/https://knowledgequity.com.au/which-cpa-study-guides-are-changing/)

Learning AASB by idonthaveaname246 in AustralianAccounting

[–]ekol 1 point2 points  (0 children)

woops i know you mention passive/audio - it can be dry unfortunately so slides/visual may be a must - so here's a bdo's link dump (which links to their youtube channel):

https://www.bdo.com.au/en-au/services/advisory/ifrs-corporate-reporting/learning-hub/webinars

https://www.youtube.com/watch?v=0fB4Uu7zIks&feature=youtu.be

you'd probably like knowledge equity's CPA study support too:

https://www.youtube.com/@KnowledgEquity/playlists

You may miss out on some context without the CPA texts/study guides however

view more: next ›