So many users of Sage products ask us what options are available to them for Consolidated Financial Reporting. Whether you have an existing set of reports that you would like to convert and improve, like FRX for MAS90/200/500 or Financial Reporter for Accpac, etc. or if you just want to have a set of reports matching your wild imagination, this video should give you an idea of what is possible using Sage Business Intelligence.
Intelligence
APPLICATION
This solution is used to rapidly calculate the commission due with a breakdown of commission amounts by Line Item Detail to each member of your sales force. Commissions are calculated when customers are invoiced.
All of these variants contain common dynamic features:
· Swiftly filtering by Sales Person and Customer Numbers.
· Options for a summary and detailed view of fields
SOLUTION FEATURES
This solution has two performance variants:
1) Full report with Invoices dates up to 15 day prior to the current system date.
2) Full report with a Beginning/Ending Invoice date entered at run time.
Solution Free variant available here.
Excel Version: 2007+
APPLICATION
This solution provides business information for the profiling of Customers. Use the dimensions in this report to profile customers by Sales and ‘Days to Pay’ for any period.
SOLUTION FEATURES
Depending on the report variant selected, this report provides rapid access to sales-side information and filtering by ‘Customer’, ‘Invoice Number’, ‘Payment’, ‘Paid/Unpaid Invoices’, aging of AR into ‘Current’, ’30 Days’, ’60 Days’, ’90 Days’, ’90 Days Plus’, with the option to isolate aging that is Project related or Non-Project related. This report displays all AR transactions up to the aging ‘cut-off’ date selected at run-time.
This solution has two performance variants:
V1.0 Customer Profiling including Invoice value, Maximum days to pay, Minimum days to pay and Average days to pay. This Free variant is limited to invoices created over the past 60 days.
V1.1 Customer Profiling including Invoice value, Maximum days to pay, Minimum days to pay and Average days to pay.
All of these variants contain common dynamic features:
- Swiftly and easily filter by available reporting dimensions
- User selection of the date range for reporting and a second level filter by document date
- Two views available – Customer and Invoice view
- Drill-Down from Customer to Invoice level
Note: This solution focuses only on fully paid invoices
All Free Variants available here.
Versions: Excel 2007 +
APPLICATION
This solution is used to rapidly view and filter Accounts Payable by Contract, Project and Category for the purpose Controlling cash flow for projects.
SOLUTION FEATURES
This solution displays the Invoice value and amount due against each Invoice, with the ability to drill down to or add the Purchase Order number and amount to the report.
This solution has two performance variants:
V1.0 Contract, Project and Category with Invoice Date, Invoice Amount and Amount Due. This Free variant is limited to Invoices created over the past 30 days.
V1.1 Contract, Project and Category with Invoice Date, Invoice Amount and Amount Due.
All of these variants contain common dynamic features:
- Swiftly and easily filter by available reporting dimensions
- User selection of the date range for reporting and a second level filter by document date
- Access to Purchase Order Number and Amount – Drill-Down to or add to the report
All Free Variants available here.
Versions: Excel 2007 +
Inventory of Solutions found in the Intelligence Store are as per groups below:
(Click to download copy)
………….find these solutions @
SOLUTION FEATURES
This solution has three performance variants:
V1.0 Amount due with values against each Invoice, Customer and Salesperson, Total Amount for Paid and Unpaid Invoices and Days to Pay (limited to invoices paid for the past 15 days)
V1.1 A total amount due to each SalesPerson
V1.2 Amount due with values against each Invoice, Customer and Salesperson, Total Amount for Paid and Unpaid Invoices and Days to Pay
All of these variants contain common dynamic features
All free variants available here.
APPLICATION
This solution is used to rapidly view and filter invoices for the purpose of credit control and general efficiency in the office management of the sales cycle.
SOLUTION FEATURES
Depending on the report variant selected, this report provides rapid access to sales-side information and filtering by ‘Customer No & Name’, ‘Invoice Number’, ‘Salesperson No’, ‘Invoice/Transaction Date’, ‘Check No’, ‘Transaction Type’, and ‘Invoice Date & Invoice Due Date’ Less than/Greater than 30 days.
This solution has four performance variants:
1) Complete report (Limited to 30 days prior to current system date).
2) Fields included: Customer Name, Invoice No, Invoice/Transaction Date, & Invoice Balance.
3) Fields included: Customer ID & Name, Invoice No, Invoice/Transaction Date, Transaction Type & Invoice Balance.
4) Fields included: Customer ID & Name, Invoice No, Invoice/Transaction Date, Transaction Type & Invoice Balance. Filtering by Invoice Date and/or Invoice Due Date- Less than/Greater than 30 days.
All of these variants contain common dynamic features:
· Swiftly adding and removing report dimensions such as Invoice Date & Invoice Due Date aging.
· Invoice Cut Off date to filter Transactions.
Free variant available here.
Platform: Mas90/200
Excel versions: 2007+
