Turbofast Powerbi Reports from Tally

 

Turbofast Reports: Powerbi

Consolidate and minimize your spreadsheets

M&N Business Intelligence India LLP(www.mnnbi.com)  is a leading analytics provider providing faster, easier and more convenient reporting from various ERPs. We have worked with clients like Medanta, PVR Cinemas, Kurlon etc for helping them optimize their operations through management reports. We help clients reduce their working capital requirements by helping design processes.

In most of the firms, accountants and managers are developing a large number of Excel spreadsheets manually for the top management. This is time consuming, manual and expensive. The large number of spreadsheets are due to the following:

1.           Complexity of information required
2.           Heavy load on Tally during processing large amounts of data

At the end of the process the management has to work with large number of complex spreadsheets.

For getting immediate benefit, we have made a product for   end clients

.Please fill out the form to enable us to get in touch with yourself for deployment:

https://forms.gle/dZGZDnqADxZquJrL9

Product download details: https://drive.google.com/drive/folders/13TOzjHxvTU8mEYuELYWmYj8MyLk-5V5f?usp=sharing

The solution is integrated with Tally and the solution is secure, easy, fast and very convenient.  Please contact  us for deploying the same on your machine.

Benefits:

We can help minimize the number of spreadsheets for the top management by the following:

·         Developing complex reports from Tally machine using Microsoft technology(DAX).  This is done with minimal deployment requirements. We have made the base product with a free version of Powerbi. 

·         The complex reports run atleast 50% faster than in Tally using Powerbi.We also provide data audit features with our product.

Our product gives reports with lower refresh and reload times than Tally on your machine or on secure Azure server. This shall help the client with the following:

·         Give managers required information in lower number of pages in an automated manner.

·         Extensive graphical representation can be done with ease and convenience.

        Advanced predictive analysis modules are also possible.

S      Sample for automation of the spreadsheets by our developer: Automation of spreadsheets sample 

            Next steps:

·        

·         The cost of the module is Rs. 7000/-(seven thousand only)+taxes as applicable. We would need the Tally serial number for the permanent license.

We shall be thankful to understand your requirements in depth  for reporting and Excel automation.

 Sample reports:

    1.) ABC Ledger analysis: This gives an immediate view of the important ledgers whose outstandings are due.

Please capture the important ledgers for receivable purposes from this report.

Application: This report is for collections teams

2.) Cost center wise sales report: here we look at the complete visibility starting from sales order, to sales invoice(including delivery notes) to billing outstandings. Use this report for the following:

a.) Understanding the sales order outstandings

b.) Look at the pending receipts

This report has been developed godown wise.

Application: use this report for collections team

3.)  A critical problem for the end users is that they do not have access to batch wise and godown wise inventory. The valuations are required for calculating the gross profit and for calculating the value of work in progress inventory. This report has been developed as a consolidated statement for stock summary, closing stock report.

Application: use this report for production planning team

5.) Payable and receivable snapshot has been developed for giving a one shot look into payments are receivables basis.

6.) Monthly, yearly and quarterly gross profit views for for those managers who want to automate the profit and loss statements.

6.) Stock item batch analysis: this view gives complete visibility to the inventory planning managers for batch wise and godown wise analysis

7.) Receivable and payable turnover: it helps analyze the credit quality of various parties.

8.) Daybook view: it gives views by voucher, voucher inventory and voucher ledger. One can make most reports from these 3 views.

Other views:  

·  

 

Price: Rs. 5000/-(Five thousand only)+GST

(This includes one simple spreadsheet automation)

Payment details: 

Beneficiary Name: M&N Business Intelligence India LLP

Bank Name: Axis Bank

Branch: DLF, Gurgaon[HR], Gurgaon 122002

IFSC Code: UTIB0000131

A/c Type: CHECKING

Account Number: 910020041330740

Inputs required: Tally serial number

 

 How to install Powerbi:

Download Powerbi from the following link:

https://www.microsoft.com/en-us/download/details.aspx?id=58494

 

Contact details:

Apoorv Chaturvedi

Phone: 8802466356

email: apoorv@mnnbi.com;support@mndatasolutions.com

Increase your prospects by using our inactive customers report

 

There is a need in the current times to increase the number of prospects for the sales resources. Getting new prospects is a very tedious and time consuming job.

However a company is likelier to get business from its past customers than prospecting for new customers.

It is in this regards we have added ‘Inactive customers’ reports to our mobile app.

Why use our solution:

·         The data is stored on the Azure cloud. So it is extremely secure

·         The Tally data has been converted to DAX for extremely fast analysis. One can get mobile apps and dashboards with high complexity with very low refresh and reload times

·         The solution gives the ability to edit the dashboards on the cloud itself

What is the purpose of this report?

·         Identify those customers whose last transaction dates have been more than 90 days from the current fiscal date.

·         Identify the important and the less important customers based on the closing ledger balances. These customers have been segregated into the following categories:

o   ‘A’ category customers are those customers that form the top 25% of the ledger balances. We assumed the ledger balances as a criteria since we wanted to include all the historical transactions.

o   ‘B’ category customers are those that are between 10% and 75% of the total cumulative ledger balances

o   ‘C’ category customers are those that are in the bottom 10%.

The report also gives the rank of the given ledger by the historical balances.

A quick word regarding ABC classification:

·         The ABC classification has been done based on the historical voucher inventory analysis. Any partyledgername associated with the parent vouchertypename ‘sales’ in the historical analysis has been included in the list. This we could include both sundry debtors and sundry creditors in the list.

·         Once the ABC classification was done we identified the entire inventory movement by sales for the given set of items f the given partyledgername as under:

This report run by a slicer would straight away give the important items sold to the given partyledgername on a historical basis.

The same action has been replicated for B and C category partyledgernames.

 

Top A_category partyledgername: this customized report gives the top 10 partyledgernames  for the ‘A’ category(partyledgernames) and the values of the associated stock items as given under:

How to use the given report?

a.)    Identify all the A and B category party ledgernames by using the Turbodata-Powerbi module

b.)    Within each partyledgername identify the top items sold to the given party. Identify the items to be prospected for with each given party.

c.)     A customized mailing solution from Turbodata is also available for the end clients.

 

How to access this report:

a.)    One can access the given report using the following login features:

https://app.powerbi.com/Redirect?action=OpenApp&appId=5aaa9abf-91b5-461b-9cb6-4252dbee6c6b&ctid=c036e821-d169-45e7-89a2-40b42dccb9cf

 

Username: frenchtrendz@mndatasolutions.onmicrosoft.com

 

Password: Bhaiya80$

 

Deployment process: https://mndatasolutionsindia.blogspot.com/2021/04/step-by-step-guide-for-powerbi-mobile.html

 

 

How to go live for your company:

·         Contact Turbodata team for a customized tcp. Turbodata team needs the Tally serial number for the given firm

·         After the tcp has been loaded then the syncing between the client Tally machine and the Azure cloud shall take place through the secure Microsoft gateway for each individual account(details to be given by the M&N BI team)

 

Other features of the product:

a.)    The solution uses $$Loopcollobj functionality from Tally. That implies that all the loaded companies shall be extracted from Tally ERP 9.0 for the purposes of analysis

b.)    The analysis has also been done across all companies

c.)     One can edit the apps and the dashboards using the Azure edit functionalities

Cost of the solution per year : The entire mobile app for the end client costs Rs. 15000/-(fifteen thousand)+GST for the end clients

Price validity: 15^th June 2021.

 

Contact details:

Apoorv Chaturvedi

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

Phone: +91-8802466356

website:https://mn-business-intelligence-india.business.site/

Step by step guide for Powerbi Mobile app deployment

 

App Link: https://app.powerbi.com/Redirect?action=OpenApp&appId=5aaa9abf-91b5-461b-9cb6-4252dbee6c6b&ctid=c036e821-d169-45e7-89a2-40b42dccb9cf

Username: frenchtrendz@mndatasolutions.onmicrosoft.com

Password: Bhaiya80$

 

Download Powerbi app from Google store

Choose your company: in this case ‘MNNBI’

Step 3: choose your report

Contact for  your own mobile app(integrated with Tally):

Apoorv chaturvedi

Email: apoorv@mnnbi.com;support@mndatasolutions.com

Phone: 8802466356

Pre requisite for Mobile app:

·         Tally serial number

·         Odbc should be enabled

GST2A Reconciliation

 

Documentation for GSTR2A reconciliation for India’s leading Retail Chain

Reason for the development of the module:

 

The module has been developed for chartered accountants and end clients to help resolve the GSTR2A reconciliation issues.

Why is this module required?

·         The data been handled for GSTR2A reconciliation can be very large. With excel handling of the data could be very cumbersome

·         There are a large number of conditions by which GSTR2 might not make a match between the client purchase invoices and the client buyer sales invoices. The reasons for the variations could be with regards to document number, document date, Recepient GSTIN, buyer GSTIN and even the transaction amounts. In order to handle the mismatches between these types of invoices there are a large number of join conditions involved.

·         The developed solution can be a standalone module for Chartered accountants not involving the complete GST extraction and services from various data providers

·         Benefits with regards to ERPs:

o   The solution is based on Azure cloud. It uses the high processing power of Azure cloud for faster data processing

o   The solution offers web and mobile access for GSTR2A reconciliation

o   The client can also share with the vendors using whatsapp and email any discrepancy details

o   The development team is bringing with itself automated extractors from Tally and other ERPs.

o   The development team is bringing with itself specialized Chartered  accountants with experience is GST 2A reconciliation(https://www.linkedin.com/in/sharad-maheshwari-688b733/)

o   The data should be secure(on Microsoft Azure cloud) and there should be facility for each company to see its own data(row level security)

o   The business logic should be auditable.

 

The following are the steps followed for the GST2A Audit process:

 For the GSTR2 A reconciliation the sample client is using the following composite keys

·         Document number

·         Document date

·         Supplier GSTIN

·         Company GSTIN

·         Taxable Amount

·         Total GST amount

 

There can be some variations in the Taxable amount and the total GST amount. That logic has to be incorporated into the final audit report.

Supplier GSTIN and Company GSTIN have to match. However there can be discrepancies in Document Number and document date because of different ERP systems.

The client’s logic entailed that match shall include all 6 criteria. Alternatively, if 4(supplier GSTIN, Company GSTIN, taxable amount and Total GST amount) criteria match but there is discrepancy in the remaining 2 criteria (document number an document date) then it should still be considered matched.

Methodology of the development of the solution:

·         The solution was developed in Powerbi for the following reasons:

o   Consolidate the data from different data sources

o   Incorporate the client logic

o   Easy and secure viewing through the Azure portal

o   Standardization of the formulae.

o   Reduce the handling times for GSTR2A reconciliation with large and varied data.

o   No row limitations as far as the processing of the data is concerned

Attached is the methodology for the same:

1.       Find the exact match for the entries:

1.       Find those entries where the client has filed the returns but the returns are not in GST audit-sample code

3.       Find those entries where the client’s customer has filed the data but client has not filed the data

3.       Find those entries where the client’s customer has filed the data but client has not filed the data

 3.) Find those entries where the document number is not matching:

4.) Document date mismatch data

Once  the above analysis has been done then specific matching criteria can also be done by GST number, document number and document date

Other reports: Based on the analysis after steps 1 ,2 and 3 it is possible to divide the data to find the exact mismatch

Custom variations based on Total tax amount and total amount are also possible. A sample case study is attached herewith:

4.       Match  the ERP and the GST data . The ERP data shall come from any ERP(including Tally). The GST data shall come from the GST portal as part of the GSTR2 reconciliation).

1.       Exclude the entries not in the exact match

5.       Extract those entries that have matching Taxable amount, Total amount, recipient GSTIN, Supplier GSTIN but not matching document number and document date

5.       Extract those entries that have matching Taxable amount, Total amount, recipient GSTIN, Supplier GSTIN but not matching document number and document date

Please contact the following for automating your GST 2A audit process

 

Apoorv Chaturvedi(Phone: +91-8802466356, email: support@turbodatatool.com, support@mndatasolutions.com)

Website: https://mn-business-intelligence-india.business.site/

Sell more of your inventory to existing customers-Consulting service from M&N BI Analytics

 

Downloading of Powerapps Mobile app on your mobile from google store:

Username: mnnbiapps@mndatasolutions.onmicrosoft.com

Password: Bhaiya80$

 Video of the  usage of the Powerapps app: https://www.youtube.com/watch?v=oO9Dzasavwo&feature=youtu.be

Why there is a need for the service?

Many clients have large stocks of inventory and there is a need to sell the inventory to various prospects. These prospects could be current customers or additional new customers. The given consulting solution proposes to increase the product sales to the existing customers:

·         The existing customers could have ready access to the inventory of the Tally client.

·         The ready customer can ask for a quotation from the Tally client.

·         The Tally client administrator(owner, senior manager or the sales resource) can access the accounts receivable status of the client.

·         The customer of the Tally client can also intimate of the payments that could be done. This process shall help the Tally client devise an effective payment follow strategy.

·         The system shall help the Tally client devise a dynamic pricing strategy based on the order requirements and payment history of the customer.

What do we offer?

·         Best in class inventory analysts with knowledge of business intelligence modules and inventory optimization techniques.

·         Best in class receivable analysts with knowledge of business intelligence modules from Microsoft

·         Built in extractor with data consolidation modules with Tally ERP 9.0.

·         Readymade apps for the solution.

What is unique about the M&N BI Powerapps solution?

·         Per user limitation has been taken away in this solution: Most of the other mobile apps have per user costs associated with them on a per month/per year basis. In this mobile app the per user limitation has been taken away. That is it is possible for the end client to give the required mobile app to its customers. The applicability  for the Tally partners and other software vendors is as follows:

o   Ability to develop one’s own market place based on the client requirements. Say a company has 500 customers for steel tubes. Then all the customers inventory  data  can be uploaded onto the cloud and possibilities for the secondary sales be done.

o   Usage of workflows: The workflows are important for capturing the quality of the client prospect. Since the solution is extracting the data to the datawarehouse, extensive control systems can be defined for the end clients. Also due to the massive data compression and sql reduction on the datawarehouse cloud the refresh times for the complex reports can be significantly reduced.

 

Workflow for the sales problem

Attached is the suggested workflow for additional sales of items

Sample Mobility apps to be given to the Tally client’s customers:

 

Inventory visibility:

Workflow system

User view:

Administrator View:

Admin Sign Up [Company Account Creation]

User name: Email

Password: 123456

Option to the end client for giving forecasted requirement

Receivable snapshots for the client

Option for client to give the payment dates

  Admin view

Admin view sign up

Mnnbianalytics-adminsignup is used for the sign up of the client (Company creation for the MNNBI Analtics) that is used for the Admin Login in the MNNBI Analytics App by the client

User Name: Client User Name used for the Admin Login for the company (User Name should be Unique)

Email: Client Company Email

Company Name: Company Name present in Tally ERP which data is extracted

Company Name is used for the Validation purpose that check the admin info exist in the database or not

Password: Password used by the client for the security & Authenticate the login

MNNBI Analytics Admin Login Page:

User Name & Password: Created by client in Mnnbianalytics-adminsignup

For login: Company Name is used for the Validation purpose that checks the admin info exist in the database or not  

Admin view of inventory

The sample username for admin is "samplecompany" and password is "123456"

The administrator gets the stock and forecasted requirements on his mobile

Admin view of accounts receivable

Client commitments to payments

How to get the mobile app working for your firm?

Points to note: The given mobile app shall work for only one company per Tally serial number.

Pre requisites for starting the package:

Download the automated Tally extractor

 Video of the  usage of the Powerapps app: https://www.youtube.com/watch?v=oO9Dzasavwo&feature=youtu.be

Drop box link:

https://www.dropbox.com/sh/8oauya52463n1eg/AAD6oViLTmafzQX1rAt5_GPca?dl=0

Follow the scheduling steps as given in the video above: https://youtu.be/2MKXknOqwlA

Contact: Apoorv Chaturvedi

Email: support@turbodatatool.com, support@mndatasolutions.com

Phone: 8802466356, 7982891666

website:https://mn-business-intelligence-india.business.site/