Hire an accounting analyst for gross profit calculations

 Use the accounting analysts to help and calculate the cogs at perpetual  level across unlimited companies, 

unlimited branches and across the complete historical time frame.

Issues with the ERP valuations:

a.) The purchase value is normally calculated with ledger parent 'purchase accounts', excluding order entries. However in the schedule 3 balance 

sheet entries the CFOs and CEOs like to exclude the following entries also:

i.) Delivery notes and receipt notes

ii.) Stock journal entries(this calculation shall also include for dales entries)

iii.) Branch transfer details(a firm could have multiple companies or multiple branches. Stock transfer between them needs to be excluded)

iv.) Purchase of capital goods.

v.) Rate differences(this is included in ledger masters)

vi.) If the company is using cost centers with branches then the solution needs to be configured accordingly.

Similar calculations are to be done for closing stock value with the sales accounts.

Why use our accounting analysts:

a.) The accounting analysts shall come prepared with the software module(with and without database) on site

b.) The reports shall be automated and tamper proof(a critical requirement for many CFOs)

c.) The product will have features row level and filter level contexts and ledger and item heirarchy flattening

d.) The CFO and CEO can dictate how the solution is to be configured.

what else would the analyst do?

a.) Based on the custom calculations the analyst shall help adjust the MRP entries in Tally/other ERP.

b.) Help automate the distribution of MRP details to various internal and external stakeholders in the ERP

Why can't a normal accountant do this job?

a.) Normal accountants are trained only in Excel

b.) Large data limitations

c.) Routine tasks for the accountant

d.) Reliance of the accountants only on the numebrs given in the ERP

e.) Profitability is not a priority for the accountant

Number of companies that have implemented the solution: more than 15

Automation of profit and loss statements: https://www.youtube.com/watch?v=O8_3PMVBUv8

Usage of vlookup and sumproduct in Excel: https://www.youtube.com/watch?v=hpNs1uUYbTg

Sumif(Excel to DAX): https://www.youtube.com/watch?v=_pndahQvpvk

Row level and filter level contexts: https://www.youtube.com/watch?v=_3XlMxB_R0U

Lookup(DAX): https://www.youtube.com/watch?v=eIT4YAITIIg

Time intelligence: https://www.youtube.com/watch?v=6bowkQ4dcxk

Blogspot link: 

Turbodata: https://mndatasolutionsindia.blogspot.com/2021/10/turbofast-powerbi-reports-from-tally.html

Running  sum problem for inventory valuations: https://mndatasolutionsindia.blogspot.com/2021/01/resolving-running-sum-problem-using-dax.html

Weighted average valuation: https://mndatasolutionsindia.blogspot.com/2020/08/weighted-average-valuation-from-tally.html

Batch wise analysis: https://mndatasolutionsindia.blogspot.com/2020/01/turbo-analytics-batch-wise-bill-wise.html

Name: Apoorv chaturvedi

Phone:+91-8802466356

email: support@turbodatatool.com;support@mndatasolutions.com