|
Management Reports |
  
|
|
Management Reports |
|
Managers access varied information depending upon what they use for touchstone numbers. This list certainly is not all-inclusive nor are all these reports necessarily important to all managers.
LISTED REPORTS
Sales Tax - Sales Tax Report
Lists sales taxes collected for a given date range. The summary report includes sales tax group name, sales, returns, total sales, amount of tax collected, and total collected per tax group with a grand total section of sales, returns, total sales without tax, total tax collected and grand total collected. Two additional fields are total taxable and total non-taxable to distinguish between inventory items sold which never charge tax. The detailed report also groups by tax group and includess invoice number, date and time of sale, amount taxed and not taxed, total invoice amount, tax collected based on applied to value per tax category. The tax group is summarized and a grand total at the end of the report.
Daily Balance History -
Upon balancing the cash drawer a detailed report of transactions are grouped into sections such as AR Payments, Invoices, Deposits, etc. Included in the report is the date of the transaction, the reference or invoice number, amount in cash, checks, charge cards, coupons, gift certificates, store credits used, on account charges, and food stamp values. These are all totaled per section and grand totaled at the end. Each transaction also shows the sales clerk ID and transaction type.
Daily Balance Summary - Register Balance Summary Report
Using a date range, all workstation totals are combined into one report, however, there is no grand totals for the report. The report includes, date register was balanced, register number, sales ID of employee balancing the register, actual counts of cash, checks, charge cards, coupons, gift certificates, and food stamps, compared with computer counts of the same. Over and short calculations are reported for each tender type, and cash left in drawer is reported. This is repeated for each workstation balanced during the specified time period.
Tender History Summary - Summary Of Tender Report
Lists one or more tender types for any date range. Available tender types are cash, check, credit card(s), debit card, finance company, store account, store credits used, and gift certificates redeemed. A summary report includes each selected tender type, total amount and percentage of grand total collected. The detailed report shows transaction date, invoice or reference number, customer name, amount, transaction type.
Employee Time Cards
This report is printed one page per employee and includes the employee name, date, time in and time out, and hours worked with a grand total for the date range selected.
Layaway Statements -
One can choose to mail reminders to customers with products on Layaway by printing out statements. The statement includes customer name and address, customer account number, Layaway number and expected delivery date. Total due on the Layaway and a listing of payments already made with date, amount, and tender type. A grand total collected and the remaining balance are printed at the bottom of the statement.
Layaway Reports -
Lists all Layaways pending. Includes Layaway number, customer name, customer account number, total of the Layaway, amount paid as deposit, balance still due, and last paid date, and date when the Layaway is to be delivered.
PO Tax (Pending) -
Prints a tax report for pending purchase orders
PO Tax (Paid) -
Prints a tax report for paid purchase order transactions
RELATED REPORTS
Accounts Receivable Aging Report: Link
Accounting: Accounts: AR Aging Reports: : : Options Query
Prints all customers on accounts receivable with open charges. The list is sorted alphabetically by customer name. Charges are totaled by periods of 30 Days, 60 days, 90 days, and Over 90 and a line Total for the customer. The report can be filtered to show only past-due accounts. Optionally, one can choose to see invoices. A Query can be applied to filter the results of the report to target specific customers.
AP Not Paid - Taxes Not Yet Paid Report:
(see Purchase Order Tax Report (Pending):)
Accounting: Reports: PO Tax Report (Pending): : : Sum/Det Query
The summary report shows total of purchase orders, with and without tax, the amount of freight, and freight tax and tax on the order. The detailed report includes the vendor name, purchase order number, vendor invoice number, and invoice date The report is date range specific.
Cash Forecast Report: Link
Accounting: Accounts: AR Cash Forecast: : : Sum/Det
Lists totals of monies due on Accounts Receivable on a per week basis. The detailed report identifies the customers by name.
Consignment Agreement Link
Inventory: Consignments By Name: Print Agreement
As inventory is accepted from a consignor for resale, terms of the sale are defined and an agreement is drawn up for signature. The Consignment Agreement can be reprinted. Paragraphs of the agreement can be edited.
Credit Card Detail: Link
Accounting: Reports: Register Balance/Tender History: Daily Balance History: Credit Card Report:
Grouped by credit card type, the report includes the invoice number, date of invoice, charged amount, refunded amount, credit card identifiers and approval number with totals per card type and grand totals.
Deposits On File: Link
Accounting: Reports: Deposits On File:
Lists active orders, layaways, service orders, and internet orders with full or partial payment applied as a deposit towards the purchase of the items. The report is sorted by transaction (order) number. It includes the date of creation, customer name, type of transaction, total amount of the order, and total deposit amount. As detail, a history of each deposit amount, method of payment, and date of a deposit applied to the pending transaction is reported.
Dollar Profit Link
Report Center: Sales Reports: Items Sorted: Run Report [F7] Options
Accounting: Reports: Sales Reports: Items Sorted: : Options
(see Items Sorted By)
Lists inventory sold per date range period with SKU, description, quantity, cost, price, profit, and markup. Totals are at the bottom of the report. The report can be sorted by Percent Profit, Dollar Profit, Quantity Sold, Gross Revenue, and Zip Code.
Employee File Link
Management: Employees: Print: Print Highlighted
Prints specific information about an employee including employee name, address, phone number and notes created about the employee. The employee's current Sales ID and password and social security number are included.
Employee List Link
Management: Employees: Print: Print List
A name, phone, and address list for all store employees.
Employee Sales Report: Link
Accounting: Reports: Sales Reports: Employee: : Options
Based on a date range and selection of employees to be included, this report displays invoice number, date and time, cashier, selling price (tax excluded), cost, profit, margin and freight per invoice. Sorted by employee name, subtotals per employee and grand totals are printed.
Employee Service Time Report Link
Management: Service Time Cards: Print Tagged
Service orders can track time spent by technicians on that service order. This report is printed one page per employee and includes the employee name, date of service, service order number, time in and time out and hours worked per service order and totals for the date range selected.
Employee Time Report Link
Management: Employee Time Cards: Print Tagged
This report is printed one page per employee and includes the employee name, date, time in and time out, and hours worked with a grand total for the date range selected.
Frequent Buyer History Report Link
Management: Frequent Buyer Program: Print History
Customer Center: Frequent Buyer tab: Print
A summary report listing rewards earned per the highlighted customer. The report shows the customer name, account number and lookup code, date and time of purchase of qualifying products, the value of the qualifying products, and the amount of the award. A grand total of awards and balance towards next award are at the end of the report.
Frequent Buyer Report Link
Management: Frequent Buyer Program: Print [F7]
Lists all customers assigned to a specific frequent buyer program. The report includes the customer name, account number and lookup code as well as total to be awarded and balance being applied towards next award.
Gift Certificates Outstanding: Link
Management: Gift Certificate Manager: Print [F7]
Accounting: Reports: Gift Certificates Outstanding: :
All gift certificates not fully redeemed are listed by date sold. The report includes the gift certificate number, date sold, sales person, invoice number, customer name, and amount of the gift certificate. If a gift certificate has been redeemed in full, it is removed from the list. If it has only been partially redeemed, the amount spent is displayed and a balance calculated. All balances outstanding are totaled.:
Gross Revenue Link
Report Center: Sales Reports: Items Sorted: Run Report [F7] Options
Accounting: Reports: Sales Reports: Items Sorted: : Options
(see Items Sorted By)
Lists inventory sold per date range period with SKU, description, quantity, cost, price, profit, and markup. Totals are at the bottom of the report. The report can be sorted by Percent Profit, Dollar Profit, Quantity Sold, Gross Revenue, and Zip Code.
List of Voids Link
Management: List of Voids: Voided Invoices
Lists the invoice number, date of creation, time of creation, sales ID and name of employee who voided the invoice and a reason for the void. The list can be purged from time to time.
Monthly Sales Summary w/Graph:
Management: Sales Summary: 13 Months: Print:
A 13 month tally of sales and returns per month. Shows totals of taxed items and non-taxed items and a calculated total for the month. A graph is included for easier interpretation.
Paid Commissions Report Link
Management: Commission Processing: Sales Commissions History: Print
Lists amount of commission to each employee. The report includes employee sales ID, invoice number, customer name, date of invoice, inventory SKU and description, quantity sold, amount of sale, commission percentage, fixed commission, and total amount to pay per line item and grand total paid.
Percent Profit Link
Report Center: Sales Reports: Items Sorted: Run Report [F7] Options
Accounting: Reports: Sales Reports: Items Sorted: : Options
(see Items Sorted By)
Lists inventory sold per date range period with SKU, description, quantity, cost, price, profit, and markup. Totals are at the bottom of the report. The report can be sorted by Percent Profit, Dollar Profit, Quantity Sold, Gross Revenue, and Zip Code.
Register Activity Log Report: Link
Management: Daily Transaction Log: Print:
The report includes the register number, date and time of transaction, name of the employee and a description of the transaction. The data can be purged from time to time to keep the list short.
RMA Aging Report:
Inventory: RMA Reports: RMA Aging Report
Inventory items sent back to vendors on RMA (Return Merchandise Authorization) are reported showing date of return, quantity returned, number of days since being sent back showing dollar values under Current, Over 30, Over 60, and Over 90 Days. Quantities and dollar values are subtotaled per inventory item and grand totaled at the end of the report. The report is grouped by vendor name and includes SKU and item description.
Sales By Employee w/Graph:
Management: Sales Summary: Sales By Employee: Print: :
Sales totals by each employee for the specified time period are listed and displayed in a graph.
Sales Report By Department: Link
Accounting: Reports: Sales Reports: Department: : Options
NOTE: While running this report you may be notified that an inventory item's category could not be found. You should make note of the Item's SKU number, go to the inventory list, reassign the correct dept/category, and then run this report again (When option "Use Departments" is on.)
Sales Report By Vendor: Link
Accounting: Reports: Sales Reports: Vendor: : Options
Using a specified date range and selection of vendors, the report groups sold inventory items under the vendor name. The summary report includes vendor name, SKU, description, quantity sold, average cost, average price, profit, and margin. All items for a vendor are subtotaled. At the end of the report totals are listed by vendor name, total cost, total price, profit, margin and percentage of sales and a grand total for cost, price and profit. The detailed report also includes invoice number, invoice date, customer name and account number and code number with subtotals per inventory item.
Store Credits List: Link
Accounting: Accounts: Store Credits Report:
List all store credits still active. The report includes customer name, account number and lookup code and credit amount with a grand total credits outstanding.
Uncollectable Debts Report: Link
Accounting: Accounts: Uncollectable Debts: : : Date
Accounts receivable for a specified time period which have been flagged as uncollectable are listed with the customer account number, customer name, lookup code, date of purchase and amount of purchase. A total of charges is listed.
Unpaid Commissions Report Link
Management: Commission Processing: Sales Commission Posting: Print [F7]
Commissions earned by employees but which have not yet been processed to pay are listed. Included in this report is the employee sales ID, invoice number, customer name, date of sale, SKU, description, quantity sold, amount of sale, commission percentage, commission earned, fixed commission amount and extended total to be paid. Return invoices will deduct commissions. Not all commissions earned will necessarily be paid at this time, so a Total to Pay can be different than the Total Commissions.
Unpaid Consignments Report Link
Management: Process Consignment Sales: Print List [F7]
Lists the sale of all consignment items, the consignor's name and amount to be paid to the consignor, with a grand total at the end of the report. Included is the date of sale, invoice number, SKU and description and quantity of the item sold. The paid value will always be zero unless the item is tagged to be paid.