Monday, 11 October 2021

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

Initial and Incremental data Load Template by M&N Business Intelligence-SAP Data Services

  INCREMENTAL LOAD/CREATION OF DIMENSION TABLE LOGIC AT SAP DATA SERVICES END CLIENT In this particular document we shall be looking at the ...