From RollMaster To Excel—The Reports You Can Export!
The following is a listof RollMaster reports that can currently be exported to Exceldirectly from your RollMaster System as of 7/13/2015. If you have any questions or need any assistance with this RollMaster functionality, please email your questions or interest to us at .
Sales Processing
Order Entry – Print Job Report
Lead Processing – Print Lead Report
Property Management / Builders Templates – Export Template Detail to Excel
Property Management / Builders Templates – Print Template Report
Salesperson Payable System – Print Commissions Report
Invoice Register – HISTORY
Open Quotation Listing
Quotation Listing
Salesperson Job Listing
Open Job Listing
Open Order Report
Credit/Return Report
Sales Tax Reporting Details
Sales Tax History
Inventory Control
Product Code Maintenance – Print Product Code Report
Catalog (A-F) Pricing Maintenance/Print – Print Price List
Catalog (A-F) Pricing Maintenance/Print – Print File Contents
Special Price Mtc. (Date Range Pricing) – Print Existing
Customer Price Lists
Catalog Listing
Inventory Listing
Inventory Valuation
Inventory Valuation (freight split)
Inventory Audit
Inventory Transit Report
Inventory Reserved Report (by Vendor)
Safety Stock Evaluation Report
Inventory Usage Report
Bar-Code Management And Printing
Inventory Not Scanned Report (By Prod)
Job Cost
Job Cost Margin
Work In Process - Costs from JC
Billed vs Unbilled – Costs from A/P
Billed vs Unbilled – A/P w/Paid Invent.
Work in Progress – Labor
Outstanding Costs vs Customer Invoices
Budget Vs Actual
Master Lead Report (if subscribed)
Purchase Orders
Open P.O. Report
Receiving Reports (all three combined in one graphical program)
Installation System
Installer Payable Report
Installer Listing Report
Installer Payables History
Accounts Receivable
Customer Payment History – exports open items on screen
Customer Payment History – Print A/R Invoice and Payment Report
Sales Tax Code Maintenance – Print (exports existing tax codes)
Customer Master Listing
Customer Reference Listing
Customer Mailing Labels
Open Items Adjustment Register
Customer Profitability Report
Past Due Report
Over Credit Limit Report
A/R Detail List
A/R Aging Report (Standard)
A/R Aging Report (by Salesperson)
A/R Aging Report (Customer Deposits)
A/R Aging Report (Deposits As Of)
A/R Aging Report (Retainage)
A/R Aging Report (As Of) – includes Retainage data
Accounts Payable
Vendor Status Inquiry – Open Items for a Vendor
In the Bank Reconciliation (Graphical): Outstanding List and Cleared List
Vendor Listing
Open Invoice Listing
Open Invoice Listing (As Of)
Open Item Aging Report
Inventory Cost Change Report
Check Register History - export as summary, 1 line per check
Print Cash Requirements Report
General Ledger
Report Format Maintenance – Verify G/L Accounts
Report Format Maintenance – Print Report Records
Print Chart of Accounts
Print Account Detail Report
Print Trial Balance
Graphical Print Annual Trial Balance
Graphical Change In Financial Position
Graphical Chart of Account Change In Position
Income/Expense Statement
Balance Sheet
Report Format Listing
Print Invoice Detail Report
Compare GL Inv. Value to PO Receipts
Payroll
Payroll Check Register
Sales Analysis
Sales Analysis – all report options
Owner Functions
Overbill / Overhead Job Cost Margin Rpt.
Billed vs Unbilled from JC (Owner’s)
Sales Analysis (Owner’s Version) – all report options
Master Lead Report (if subscribed)
Special Functions
Vendor Invoice Report
System maintenance
System Control Maintenance – User Control Detail Report
1 | Page