Orqubit Business Intelligence :: A Reporting Tool For Tally.ERP 9

Introduction

Orqubit Business Intelligence is a reporting tool which helps users to slice and dice data to generate meaningful analyses and reports without much manual labour. Dashboards provide a one screen view of related information to managers and C-suite executives to help them track their business on a real time basis.

From Data to Information

Orqubit can convert data into actionable insight with an integrated view of all your information through dashboards, reports and analyses.

Ready Reports

Information cubes such as Sales, Purchase, Inventory and Finance provide you with ready information for consumption based on predefined or ad-hoc analyses. Dashboards and charts enhance the readability of the information for executives who need a bird's eye view of business operations and performance .

Export and Distribute Information

Information is readily exportable and can be distributed via email to allow managers on the move to easily access data
.

Integrated with Tally.ERP9

Orqubit provides seamless connectivity with the popular business solutions software - Tally .ERP9.

No Expensive Hardware or Software pre-requisites

There are no other requirements to run Orqubit except certain commodity utilities provided by Microsoft free of charge. Orqubit can also run on your desktop PC and thus there is no need to invest in complex and expensive hardware and software platforms.

Reports

Accounts Payable

Transaction analysis across financial years with options to get transactions by group, state, alias, etc.
Weekly, Monthly, Quarterly Balances
Purchase Growth by Supplier or Supplier Group – MoM, QoQ, YoY
Purchase vs Payments
Supplier Balances by Region, Group, Company
Top N Suppliers by Purchase, Balances
Billwise Outstanding Reports – by bill date and by due date
Ageing Analysis – by bill date and by due date

Accounts Receivable

Transaction analysis across financial years with options to get transactions by group, state, alias, etc.
Weekly, Monthly, Quarterly Balances
Sales Growth by Supplier or Supplier Group – MoM, QoQ, YoY
Customer Sales by Region, Group, etc.
Customer Receipts by Region, Group, etc.
Sales vs Receipts
Customer Balances by Region, Group, Company
Top N Customers by Sales, Balances
Billwise Outstanding Reports – by bill date and by due date
Ageing Analysis – by bill date and by due date
All reports can be consolidated across companies, financial years and groups

General Ledger

Grouped and ledger wise trial balances
Consolidated trial balances across companies
GL - Cost Centre wise trial balances
Columnar balances by Week, Month, Quarter, etc.
Columnar balances across Financial Years
Balance comparison across time periods
Voucher Type wise trial balance
GL Transactions grouped by Ledger, Date, Week, Day of Week, Ledger Group, etc.
Daily Columnar Trial Balances
Narration wise Balances
Annual, Quarterly, Monthly, Weekly Sales and Expense Summary
Annual, Quarterly, Monthly, Weekly Growth
Annual, Quarterly, Monthly, Weekly Comparisons

Cost Centre Reports

Category wise Balances across companies and financial years
Supplier Balances by Region, Group, Company
Cost Centre Balances across companies and financial years

Purchase

Purchase Analysis by

Stock Group
Stock Category
Stock Item
Supplier Group
Supplier
State

Purchase Register
Top N Items, Item Groups, Godowns for Purchases
Item purchases by Supplier
Supplier purchases by item
Annual, Quarterly, Monthly, Weekly Purchase Comparison
Annual, Quarterly, Monthly, Weekly Purchase Growth
Landed Cost Analysis
Purchase Rate Analysis by Item, Supplier, Godown
Voucher Type and Classwise Purchases

Sales

Sales Analysis by

Stock Group
Stock Category
Stock Item
Customer Group
Customer
State

Sales Register
Top N Items, Item Groups, Godowns for Sales
Item Sales by Customer
Customer Sales by item
Annual, Quarterly, Monthly, Weekly Sales Comparison
Annual, Quarterly, Monthly, Weekly Sales Growth
Landed Cost Analysis
Sales Rate Analysis by Item, Customer, Godown
Voucher Type and Classwise Sales

Inventory

Godownwise and Summary Daily Closing Stock
Maximum and Minimum Stock levels
Stock Comparison Charts across timeperiods
Detailed Stock Ledger and Summary Reports
Itemwise, Groupwise and Category wise reports

Orqubit empowers the end-user with a wide array of analytical tools and data management facilities to enable them to prepare reports in quick time. Some of the key end-user features available are:

Report Features

Unlimited in-screen dropdown filters
Unlimited pre-report data filters
Data grouping and sorting
Absolute and Percentage comparison of data across time periods and entities
Generate reports based on Sum, Average, Minimum, Maximum and other variation options
Define top and bottom n values for any column
Analyze any date based chronological information by Week, Month, Year, Day of Week, etc.
Create mathematical formulas and custom fields
Show and hide totals
Create exception rules for reports and highlight qualifying data
Save report definitions as layouts for future use
Export reports to Excel, PDF
Email reports directly from within the application

Dashboard Features

Customize and save dashboard layouts
Use charts, graphs and reports within the same layout
Define drilldown characteristics for charts and graphs
Define top n characteristics for any value within charts and graphs
Use gauges with filters and rounding criteria
Define red, yellow and green ranges for gauges
Create simple and advanced filters for data
Refresh dashboards to get real-time information