Hire accounting analysts for calculating gross profit as per your requirements
Profile: accountants and computer engineers available all over India with Turbodata training to help CFOs with the following problem
Problem statements:
For calculating the cost fo goods sold we use the formula: opening stock value+purchase value-closing stock value.
Thereafter we calculate the gross profit.
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
