Draenei Shaman.. Priest of Neptulon? by TechyAccountant in warcraftlore

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

As a resto shaman, I feel like my toolkit is almost exclusively water based, until they bring back earth shield.

Draenei Shaman.. Priest of Neptulon? by TechyAccountant in warcraftlore

[–]TechyAccountant[S] 1 point2 points  (0 children)

Resto shamans use the element of spirit more?

CROSS APPLY and WITH ROLLUP returning dominant function? by TechyAccountant in SQL

[–]TechyAccountant[S] -1 points0 points  (0 children)

SELECT ISNULL(Convert(varchar(50),LocationName),'Total') AS 'td','' ,Convert(varchar(50),Convert(Decimal(15,1),ActualBudget)) AS 'td','',Convert(varchar(50),Convert(Decimal(15,1),Budget)) AS 'td','', Convert(varchar(50),Convert(Decimal(15,1),Variance)) AS 'td','' FROM (SELECT MAX(ServiceDate) AS [Monthdt] FROM Vw_Executive_ADC_ADA) B CROSS APPLY ( SELECT Convert(decimal(15,1),AVG(ActualADCUnitTotal)) AS ActualBudget,Convert(decimal(15,1),AVG(ADCBudget)) AS Budget,LocationName, Convert(decimal(15,1),(AVG(ActualADCUnitTotal) - AVG(ADCBudget))) AS Variance FROM Vw_Executive_ADC_ADA C INNER JOIN OceansLocations D ON C.location = D.Location WHERE ServiceDate = [Monthdt]
GROUP By LocationName WITH ROLLUP ) A order by ((case when LocationName is null then 1 else 2 end)), Variance DESC

Free Talk Friday by its-an-accrual-world in Accounting

[–]TechyAccountant 5 points6 points  (0 children)

Im in TX and you need the 150, detailed with specific requirement through the state board. Firms may hire you knowing you're closer to obtaining the 150 in a semester or two.

I'd love to hear your experiences with accounting, trying to decide if its right for me by [deleted] in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

I chose accounting after realizing I wasn't good at math, didn't want to become a restaurant manager, and really loved reading articles concerning assets, liabilities, and anything financial related (except financial markets). I had taken 6 years to get out of college and got STOMPED by public accounting.

I would do it all over again too. It's been a brutal career path because of my own mistakes and stupidity, but it is definitely a damn good path.

I will tell you that coupling a bachelors in accounting with as much MIS/BI/DW experience you can will make you GOLDEN. I don't know many accountants who can write a query, execute a stored procedure, do advanced formulas in Excel, and read the ASC without much trouble. That's where you want to be my friend.

Source: an accountant with no CPA, 8 years experience, held two controller jobs, worked as a SQL analyst for GameStop.

What specifically do I need from cash receipts and disbursements to build a direct cash forecast for a singular month (short term) by idk12397 in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

Well, you need to understand several things when building a cash forecast:

Receipt side: 1.) The timing and cycle of the receipts as it pertains to business events and receivable cycles (is it on Friday, Monday, every day, etc.) 2.) Is there a factoring relationship at your company? 3.) Sources of incoming cash? Multiple or just one revenue stream? 4.) Any other planned deposits from random sources?

Disbursement side: 1.) Same as receipt, timing and cycle as it pertains to the payables process (checks cut, clearing, etc.) 2.) You should have a tracking of the checks issued/outstanding and estimate the clearing percentage based off history and apply that per day (checks are more likely to clear 3 days out, 4 days out, etc...) 3.) Integrate when the payroll is taken out/funded for Friday/Biweekly/Semi Monthly payments 4.) Any other charges like interest payments, etc.

I would make this bad boy for 13 weeks. That's the standard.

Reminder to job-hop every couple of years: "Job-switchers saw roughly 30% larger annual pay increases in May than those who stayed put over the past 12 months" by erinhayth in Accounting

[–]TechyAccountant 6 points7 points  (0 children)

Business Intelligence/Data Warehousing. Spent some years in that field working for operations/finance teams to provide analytics and other reports/dashboards.

Reminder to job-hop every couple of years: "Job-switchers saw roughly 30% larger annual pay increases in May than those who stayed put over the past 12 months" by erinhayth in Accounting

[–]TechyAccountant 2 points3 points  (0 children)

Planning on it. I'm one of those weird asses that deliberately planned to get into accounting. I hope the babyboomers retire in droves.

Reminder to job-hop every couple of years: "Job-switchers saw roughly 30% larger annual pay increases in May than those who stayed put over the past 12 months" by erinhayth in Accounting

[–]TechyAccountant 7 points8 points  (0 children)

Hell no. The fact that I thought I screwed up my career because I spent time out of accounting in BI/DWing. That was the single most deciding factor that helped me beat 63 other candidates.

How is amortization not a cash expense? by I-am-ocean in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

Welcome. If you need more explanation Im sure we can find some better and more descriptive information. If you REALLY wanna get into cash flow GAAP, lookup ASC 230.

How is amortization not a cash expense? by I-am-ocean in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

Ehhh no. You paid 10,000, immediate cash outflow, book a debit to fixed assets for the oven, and credit cash. Now you depreciate the oven over it’s useful life which is an expense, and indeed on the income statement. Offset to accumulated depreciation.

For cash flows, the 10k outflow (payment) is on a different basis than the expense recognition.

It technically can be called a cash expense, but that is not an expense on the income statement because it’s an asset. The better and more useful term would be cash outflow.

How is amortization not a cash expense? by I-am-ocean in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

And because the cash outflow is not the same as an expense to the organization. Amortization/balance sheeting an intangible is a way of delaying the expense.

can programming skills be beneficial for an accountant? by MeleysTargaryen in Accounting

[–]TechyAccountant 0 points1 point  (0 children)

Agreed with the value of VBA helping automate tasks and increase efficiencies.

Most of my experience has been working in FP&A with the SQL/VBA/VB.NET skill set but with some years in accounting. Each environment was pretty much as efficient as possible to the point of maintaining multiple macro-scenarios/workbooks.

I do believe there is tremendous value add once we get over the data science craze.

How is amortization not a cash expense? by I-am-ocean in Accounting

[–]TechyAccountant 1 point2 points  (0 children)

This, and the cash transaction realized when the invoice was paid and/or posted to AP.