Difference between revisions of "Reports"
From TrueERP wiki
(→R) |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<menu name=myMenu align=center> | <menu name=myMenu align=center> | ||
| − | + | More Details= | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
[[Drill Down Reports|Drill Down Reports]] | [[Drill Down Reports|Drill Down Reports]] | ||
[[Exporting Reports|Exporting Reports]] | [[Exporting Reports|Exporting Reports]] | ||
| Line 12: | Line 6: | ||
[[Report Printing Options|Report Printing Options]] | [[Report Printing Options|Report Printing Options]] | ||
</menu> | </menu> | ||
| − | |||
| − | |||
== Overview == | == Overview == | ||
Each tab on the left of the main menu has its own list of specialised reports. Select the link below for help on | Each tab on the left of the main menu has its own list of specialised reports. Select the link below for help on | ||
the relative reports or see the full list of reports. | the relative reports or see the full list of reports. | ||
| − | |||
*[[Accounts Reports]] | *[[Accounts Reports]] | ||
*[[Appointments Reports]] | *[[Appointments Reports]] | ||
| Line 210: | Line 201: | ||
===S=== | ===S=== | ||
| − | Sales Commission - List of individual transactions resulting in commissions for employees | + | *[[Sales Commission]] - List of individual transactions resulting in commissions for employees |
| − | Sales List - List of all sales transactions (Sales Order, Invoice, POS and Cash Sale) | + | *[[Sales List]] - List of all sales transactions (Sales Order, Invoice, POS and Cash Sale) |
| − | Sales Order Backorders - List of all backordered Sales Orders | + | *[[Sales Order Backorders]] - List of all backordered Sales Orders |
| − | + | *[[Sales Order List]] - List of all Sales Orders | |
| − | + | *[[Sales Pipeline Report]] - summary activity by the [[Quote/Lead Status]] of each Lead or Quote. | |
| − | Sales Ratios Report | + | *[[Sales Ratios Report]]- Report of sales ratios by employee |
| − | Sales Report - List of all completed Sales Transactions (ie. excluding Sales Orders) | + | *[[Sales Report]] - List of all completed Sales Transactions (ie. excluding Sales Orders) |
| − | Sales Reward Points - List of customers with reward points accrued | + | *[[Sales Reward Points]] - List of customers with reward points accrued |
| − | Sales Summary Report - Summary of Sales by various periods (day, weekday, week, month,etc | + | *[[Sales Summary Report]] - Summary of Sales by various periods (day, weekday, week, month,etc |
| − | Serial Numbers | + | *[[Serial Numbers]] - All Serial Number transactions within ERP |
| − | Service Log List | + | *[[Service Log List]] - List of service history for each Fixed asset |
| − | Shipping Agent List - List of Shipping Agents | + | *[[Shipping Agent List]] - List of Shipping Agents |
| − | Shipping List | + | *[[Shipping List]] - List of available shipping methods |
| − | Smart Order List | + | *[[Smart Order List]] - List of all smart orders |
| − | SourceList | + | *[[SourceList]] - List of contact sources available |
| − | Statements | + | *[[Statements]] - Listing of Invoices and Payments that appear on statements for the selected date range. |
| − | See Print Statements | + | *[[See Print Statements]] |
| − | Stock Adjustment List | + | *[[Stock Adjustment List]] - List of all stock adjustment and stocktake transactions |
| − | Stock Movement Status - Report showing current stock and stock movement for each product | + | *[[Stock Movement Status]] - Report showing current stock and stock movement for each product |
| − | Stock Quantities & Location Report - Product list showing stock by bins, batches and serial numbers | + | *[[Stock Quantities & Location Report]] - Product list showing stock by bins, batches and serial numbers |
| − | Stock Status Report - Stock movement by transaction type and filtered by periods (day, week, month etc) | + | *[[Stock Status Report]] - Stock movement by transaction type and filtered by periods (day, week, month etc) |
| − | Stock Transfer List | + | *[[Stock Transfer List]] - List of all stock transfer transactions |
| − | Stock Turnover Report - Summary of turnover by product for a date range | + | *[[Stock Turnover Report]] - Summary of turnover by product for a date range |
| − | Summary Sheet | + | *[[Summary Sheet]] - Summary of financial information including current Balance sheet total, aged payable and receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last 12 Months |
| − | receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last | + | *[[Super by Fund Report]] - Superannuation Liabilities by fund/Emplyee/account |
| − | + | *[[Supplier List]] - List of all suppliers | |
| − | Super by Fund Report - Superannuation Liabilities by fund/Emplyee/account | + | *[[Supplier Payment List]] - List of all Supplier Payments |
| − | Supplier List | + | *[[Supplier Prepayment List]] - List of all Supplier Prepayments |
| − | Supplier Payment List | + | *[[Supplier Product Report]] - List of purchases by supplier |
| − | Supplier Prepayment List | + | *[[Supplier Report]] - Summary of amounts spent with each supplier |
| − | Supplier Product Report - List of purchases by supplier | + | *[[Supplier Statement]] - List of transactions by suplier |
| − | Supplier Report - Summary of amounts spent with each supplier | + | *[[Support Log List]] - List of support calls showing issue and resolution |
| − | Supplier Statement - List of transactions by suplier | + | |
| − | Support Log List - List of support calls showing issue and resolution | + | |
===T=== | ===T=== | ||
| − | Tax Code List | + | *[[Tax Code List]] - List of tax codes for GST/VAT |
| − | Tax Scales | + | *[[Tax Scales]] - Current PAYG Tax Scales |
| − | Tax Summary - Listing of tax codes and corresponding amounts for a selected date range | + | *[[Tax Summary]] - Listing of tax codes and corresponding amounts for a selected date range |
| − | To Be Reconciled - List of unreconciled items | + | *[[To Be Reconciled]] - List of unreconciled items |
| − | + | *[[Telemarketing List]] - List of all telemarketing calls made | |
| − | Terms List | + | *[[Terms List]] - List of payment terms available |
| − | Till Summary Report - Summary of transactions and payment types by Till | + | *[[Till Summary Report]] - Summary of transactions and payment types by Till |
| − | Timesheet Pays - List of timesheets filtered by Current or Converted to Pay | + | *[[Timesheet Pays]] - List of timesheets filtered by Current or Converted to Pay |
| − | To Do List | + | *[[To Do List]] - List of items on an employees To Do List |
| − | Traffic List - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP) | + | *[[Traffic List]] - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP) |
| − | Traffic Summary - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc) | + | *[[Traffic Summary]] - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc) |
| − | Transaction Journal | + | *[[Transaction Journal]] - Listing of all transactions for a selected period of time with detail of all associated account postings |
| − | + | *[[Transactions with 0 Quantity]] - Report showing any saved transactions with a zero quantity in a line | |
| − | Transactions with 0 Quantity - Report showing any saved transactions with a zero quantity in a line | + | *[[Trial Balance]] - Listing of accounts and their balances as well as a total of debits and credits for a period of time. This is a snapshop of balances to demonstrate that all all account postings balance. |
| − | Trial Balance | + | |
| − | + | ||
===U=== | ===U=== | ||
| − | UnAllocated Bins Report - | + | *[[UnAllocated Bins Report]] - |
| − | Unassigned Tax Codes - Listing of any transactions that have been created without a tax code. A tax code is | + | *[[Unassigned Tax Codes]] - Listing of any transactions that have been created without a tax code. A tax code is essential on all transactions to ensure BAS or VAT returns can include all necessary transactions. |
| − | + | *[[Unbalanced Bin Quantities]] - List of products where the stock doesn't match the bin allocations | |
| − | Unbalanced Bin Quantities - List of products where the stock doesn't match the bin allocations | + | *[[Units of Measure List]] - List of Units Of Measure created |
| − | Units of Measure List - List of Units Of Measure created | + | *[[Un-Invoiced Customer Purchased Items]] - List of purchase order lines with no invoice recorded |
| − | Un-Invoiced Customer Purchased Items - List of purchase order lines with no invoice recorded | + | *[[Un-Invoiced Purchase Orders]] - List of purchse orders with no invoice recorded |
| − | Un-Invoiced Purchase Orders - List of purchse orders with no invoice recorded | + | *[[Unpaid Bills]] - This is a simplified creditors report that has the advantage of being faster to produce than a full [[Accounts Payable Report]] |
| − | Unpaid Bills - This is a simplified creditors report that has the advantage of being faster to produce than a full | + | |
| − | Accounts Payable Report | + | |
===V=== | ===V=== | ||
| − | Vouchers List - List of vouchers issued with details | + | *[[Vouchers List]] - List of vouchers issued with details |
===W=== | ===W=== | ||
| − | Wages Journal - List of Journals posts created by Pays | + | *[[Wages Journal]] - List of Journals posts created by Pays |
| − | Warranty/Insurance Policy Report | + | *[[Warranty/Insurance Policy Report]] - List of Fixed assets with standard filters for No Insurance and No Warranty |
Latest revision as of 11:28, 19 January 2011
Contents
Overview
Each tab on the left of the main menu has its own list of specialised reports. Select the link below for help on the relative reports or see the full list of reports.
- Accounts Reports
- Appointments Reports
- Banking Reports
- Budget Reports
- CRM Reports
- Employee Reports
- Fixed Assets Reports
- General Reports
- Inventory Reports
- Manufacturing Reports
- Marketing Reports
- Payments Reports
- Payroll Reports
- Price Scheme Reports
- Purchases Reports
- Sales Reports
- Utilities Reports
Alphabetical List of Reports
A
- Account List for Budget - Chart of Accounts with filter for accounts with Budget attached
- Account Types List- Lists the account types available to you when creating accounts. For more information on Types of accounts available see New Account
- Accounts Payable Notes Report - List of notes made in the Accounts Payable report
- Accounts Payable Report - Detailed report of accounts payable (or creditors) with aged detail for each of the Suppliers
- Accounts Receivable Notes Report - List of notes made in the Accounts Receivable report
- Accounts Receivable Report - Detailed report of accounts receivable or debtors with aged detail for each of the Customers
- Action Authorisations - List of actions performed that require an authorised employee eg. Process Pays
- Allowances - List of available allowances
- Allowances Report - Allowances paid to employees in pays for a given date range
- Appointments List - List of all appointments in a date range with filters for Non-Converted, Converted and Deleted
- Appointments Report - List of appointments showing service, rates and totals
- Approval Reminder List - Listing of Puchase Orders awaiting payment approval from approved person
- Asset Register Report - List of Fixed Assets and depreciation details
- Audit Trail List - Full list of transactions and history of changes to those transactions. This is useful to track when a change was made to a transaction (eg. Change of value on an Invoice) and which user made the change
- Awards - List of available awards
B
- Balance Sheet - Full Balance Sheet as described above
- Bank Account Report> - Full listing of postings to each bank account for a selected period including whether the transaction has been reconciled
- Bank Codes - List of available Tax Codes
- Barcode Picking List - The Barcode Picking List displays the picking status of orders
- Barcode Picking Manifest - Manifest showing items picked
- Bar Tab List - List of Bar Tab entries by customer and showing Balance (Bar Tabs are created using a keypad key assigned to the
- Bar Tab function. See Customising POS)
- Batches - A list of all stock with batches turned on
- Bill Details - List of Bills showing line items
- Bill List<LinkId=208> - List of Bills
- Bin Location List - List of all Bin locations created
- Bin Usage Report - List of Bins showing % usage by volume
- Blind Balance Report - A Blind Balance hides any variation in the balance from the Till using the Till and is useful for ensuring employees cannot cover up a shortfall. The report lists each Till, sales details and any balance variation.
- Budget Definition List - List of Budget Definitions
- Budget List - A list of all budgets created with filter for Active or Inactive
- Budget Profit and Loss Report - Profit and Loss with budgeted amounts
- Budget Vs Actual - List of Accounts showing actual and budgeted figures
- Budget Vs Actual(Job) - List of Accounts showing actual and budgeted figures filtered by job
C
- Canvasser List- List of Employees created as Canvassers
- Cash Flow Forecast - Projection of future cash flow based on current creditor and debtor balances. eg What monies are due to be received/paid in the next week/month/quarter/year
- Cheque Details - List of all cheques issued
- Cheque List - List of all cheques
- Combined Analysis Report - Comparison of chargable and non chargeable hours per employee by product
- Commission List - Commissions generated by employee
- Customer Balance Detail - Detailed list of outstanding balances for each customer
- Customer Details List - List of customers showing discounts and special discounts
- Customer Equipment List - List of equipment owned by customers
- Customer Express List - Customer list showing AR & AP balances as well as Sales Order balances
- Customer List - Standard Customer List
- Customer Summary Report - Report showing sales and Gross Profit per customer for a date range
- Customer Type List - List of Customer Types created for purpose of Extra Sell pricing
- Customer Type Price List - List of Extra Sell prices and discounts by product and Customer Type
- Customers on Support List - List of customers on the support list.
- Customer Payment List - List of all customer payments received
- Customer Prepayment List - List of all customer prepayments received
D
- Deduction Report - Report of deductions paid to employees in pays for a given date range
- Deductions - List of available deductions
- Departments List - List of all departments
- Deposited List - List of Bank Deposits
E
- Employee Analysis - Summary of chargable and non chargeable hours per employee by job
- Employee Fixed Assets - List of Fixed Assets in the possesion of an employee
- Employee List - List of all employees
- Employee Summary - Summary of invoiced amounts by employee
- Employee Summary by Period - Comparison of invoiced amounts by employee on a period by period
- End of Period Summary - End of Period is run at the end of a shift or more often and summarises all transactions by employee
- Equipment List - List of "Generic" Equipment ie. General details of equipment without specific item or ownership details.
- ETP Report - Terminated Employees ETP details
- Expense Claims - List of payments linked to an employee expense
F
- Feedback Report - List of customers on Support List with Feedback notes
- Fixed Asset Types - List of the Assert Types as defined by you
- Fixed Asset Details Report - List of Fixed Assets with details of each depreciation transaction
- Fixed Assets List - List of Fixed Assets with details of warranties and insurances
- Foreign Exchange Rates List - List of Foreign Exchange Rates showing Active or Not Active
- Foreign Purchase Report - List of purchases in foreign currency
- Foreign Sales Report - List of sales transacted in a Foreign Currency
G
- General Ledger - Listing of all transactions by account for a selected period with options for:
- Summary - Totals Only
- Details - Subtotals by transaction type
- Extra Details - Full transaction listing
- Global List - List of all entities in ERP from Employees to customers and suppliers and marketing
H
- Hourly Sales Report - Summarises sales for defined time blocks (hours by default) without the need for running an End Of Period. Report is not limited to POS sales.
I
- Invoice Backorders - List of backordered Invoices
J
- Job Time Sheets - List of job time sheet entries
L
- Leads - List of Leads
- Leave Accruals by Department - Leave accrued summarised by department
- Leave Accrued - Leave accrued summarised by employee and leave type
- Leave Accrued Details - List of transactions that make up current leave accruals
- Leave Taken - Leave taken by pay
- Location List - List of Cities and postcodes
- Loyalty Program List
M
- Marketing Action List - The Marketing Action List is a list of all actions recorded against any Lead
- Marketing Contact List - Use this list to view all marketing contacts
- Manufacture Product List - List of Manufactured Products with Bills of Material
- Marketing Ratio Report - List of calls with ratios of different resulting actions
- Memorised Transaction List - List of unposted memorised transactions
O
- Orders From Stock - List of orders for Manufactured products that can be taken from stock
P
- Pay History - List of past pays
- Pay Rates - List of Pay Rates available
- PAYG Payment Summary - PAYG details by employee and financial year.
- Payroll Jobs - Employee pay details by job
- Payroll Reconciliation Report - Summary of Pays by month
- Phone Contact/Follow Up List
- POS End Of Period Report - Report summarising when End Of Period has been run for each Till
- Price Scheme Best Price - This report lists all products in price schemes and displays the price and savings information
- Product Commission List - List of products on which commission is paid including commission rate
- Product Formula List - List of formula available for products
- Product List - List of all Products. Can be viewed as Product Express List or full Product List
- Product Movement Report - Shows all movements (buy sell etc) for a selected product
- Product Report - Product Sales Projection based on past sales
- Product Reward Points List - List showing details of products with reward points attached
- Product Sales Projection - Forward projection of sales based on past sales
- Product Sales Summary - List of sales by product with summary and detail filters
- Product Sales Summary (By Column) - Summary of sales by product showing margins
- Product Express List - List of all products
- Production Job List - List of all Production Jobs
- Production Job Status - List of Production Jobs by Status
- Production Parts List - List of all parts required for production jobs
- Production Parts Status - List of parts required for production jobs with availability and Purchase Order details
- Products List (Reorder) - List of all products showing reorder points
- Prospect List
- Profit & Loss - Full Profit & Loss report as described above
- Profit & Loss (By Period) - Full Profit & Loss report with comparison periods (Month, Quarter or Year). eg. you can compare income in the Profit and Loss for the current month, with revenue from the previous month.
- Profit & loss Summary - Profit & Loss Totals only with comparison by various period selections from daily up to a full year.
- Purchase Order Backorders - List of back ordered purchase order line items
- Purchase Order List - List of all purchase orders
Q
- Quote Details Report - List of quote line items
- Quote_List - List of Quotes with filters for Converted and Completed
- Quote Status Report - List of Quotes with filters for Converted and Completed
R
- Raw Marketing Contact List - List of unfiltered Marketing Contacts
- Reconciliation List - List of completed and Held reconciliations
- Reconciliation List (Details) - List of reconciliations with transaction details
- Repairs List - List of all repairs with multiple filter options and date range
- Repairs List (Invoice) - List of repairs with drillable details of invoices issued
- Resource List - List of Production Resources with capacity details
- Resource Unavailability - List of scheduled unavailability of resources
- Return Authority List - List of return authorities
- Rep Ability List - List of relative skill or ability levels for reps. These are defined by you.
- Rep List - List of all Reps
- Roster List - List of Clocked On and Clocked Off employees
S
- Sales Commission - List of individual transactions resulting in commissions for employees
- Sales List - List of all sales transactions (Sales Order, Invoice, POS and Cash Sale)
- Sales Order Backorders - List of all backordered Sales Orders
- Sales Order List - List of all Sales Orders
- Sales Pipeline Report - summary activity by the Quote/Lead Status of each Lead or Quote.
- Sales Ratios Report- Report of sales ratios by employee
- Sales Report - List of all completed Sales Transactions (ie. excluding Sales Orders)
- Sales Reward Points - List of customers with reward points accrued
- Sales Summary Report - Summary of Sales by various periods (day, weekday, week, month,etc
- Serial Numbers - All Serial Number transactions within ERP
- Service Log List - List of service history for each Fixed asset
- Shipping Agent List - List of Shipping Agents
- Shipping List - List of available shipping methods
- Smart Order List - List of all smart orders
- SourceList - List of contact sources available
- Statements - Listing of Invoices and Payments that appear on statements for the selected date range.
- See Print Statements
- Stock Adjustment List - List of all stock adjustment and stocktake transactions
- Stock Movement Status - Report showing current stock and stock movement for each product
- Stock Quantities & Location Report - Product list showing stock by bins, batches and serial numbers
- Stock Status Report - Stock movement by transaction type and filtered by periods (day, week, month etc)
- Stock Transfer List - List of all stock transfer transactions
- Stock Turnover Report - Summary of turnover by product for a date range
- Summary Sheet - Summary of financial information including current Balance sheet total, aged payable and receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last 12 Months
- Super by Fund Report - Superannuation Liabilities by fund/Emplyee/account
- Supplier List - List of all suppliers
- Supplier Payment List - List of all Supplier Payments
- Supplier Prepayment List - List of all Supplier Prepayments
- Supplier Product Report - List of purchases by supplier
- Supplier Report - Summary of amounts spent with each supplier
- Supplier Statement - List of transactions by suplier
- Support Log List - List of support calls showing issue and resolution
T
- Tax Code List - List of tax codes for GST/VAT
- Tax Scales - Current PAYG Tax Scales
- Tax Summary - Listing of tax codes and corresponding amounts for a selected date range
- To Be Reconciled - List of unreconciled items
- Telemarketing List - List of all telemarketing calls made
- Terms List - List of payment terms available
- Till Summary Report - Summary of transactions and payment types by Till
- Timesheet Pays - List of timesheets filtered by Current or Converted to Pay
- To Do List - List of items on an employees To Do List
- Traffic List - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP)
- Traffic Summary - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc)
- Transaction Journal - Listing of all transactions for a selected period of time with detail of all associated account postings
- Transactions with 0 Quantity - Report showing any saved transactions with a zero quantity in a line
- Trial Balance - Listing of accounts and their balances as well as a total of debits and credits for a period of time. This is a snapshop of balances to demonstrate that all all account postings balance.
U
- UnAllocated Bins Report -
- Unassigned Tax Codes - Listing of any transactions that have been created without a tax code. A tax code is essential on all transactions to ensure BAS or VAT returns can include all necessary transactions.
- Unbalanced Bin Quantities - List of products where the stock doesn't match the bin allocations
- Units of Measure List - List of Units Of Measure created
- Un-Invoiced Customer Purchased Items - List of purchase order lines with no invoice recorded
- Un-Invoiced Purchase Orders - List of purchse orders with no invoice recorded
- Unpaid Bills - This is a simplified creditors report that has the advantage of being faster to produce than a full Accounts Payable Report
V
- Vouchers List - List of vouchers issued with details
W
- Wages Journal - List of Journals posts created by Pays
- Warranty/Insurance Policy Report - List of Fixed assets with standard filters for No Insurance and No Warranty
