REPORTS & ANALYSES

Together with Collection Manager, Lookup Lists and Retail modules DJ Wizard allows you to produce over 150 report types, report layouts, and many veriations of them by sorting and selecting from many items in each report. Most reports are colorful and very representative. You can have your logo and text added to cutomize a report to your company needs and have publish them by printer press, laser printer, color printer or optionally export them to Excel. All reports are organized under several main sections, such as Clients, Stock, Transactions, etc. Confidential reports show only on machines where an authorized user logs on to. The Sort option allows you to manipulate the order in which, say, your clients in California will appear, i.e. by zip code or alphabetical order of the Company Name or City. You can further manipulate reports to show only the information related to a range or specific location(s), date(s), or company(ies), etc. You can even have confidential customized reports that only you can produce, if needed. Such customized reports can be added to your system very quickly and can be used immediately thereafter without the need to make any changes to your software. Here is a partial list of standard reports you can choose from, organized by their section:

Clients

You can print all or any part of your Client information and business transactions. Make mailing lists to your clients as easy as printing addresses labels in different standard Avery label formats.
  1. Client List - List includes clients name, contact, address, phone number, resale #, credit limit, etc...
  2. Chain Stores List - List clients alternative shipping addresses/other store locations, if they have been entered in.
  3. Clients Form - Show a summary of the client information.
  4. Business Volume - This report will print Year-to-date sale volumes by Client starting with your best client. Or you can choose any of the periods listed at the bottom.
  5. Client Payment Credits - List the any Client that has paid extra and what due invoices (if any) that this amount can be applied to.
  6. Address (1x7) - Prints labels 1 across and 7 down.
  7. Address (2x7) - Prints labels 2 across and 7 down.
  8. Address (3x10) - Prints labels 3 across and 10 down.
  9. Envelope (#10) - Print client address and your company info label to printed a standard envelope.

Stock

Stock - Print Price Lists for your Clients (single stones only) or all your Inventory for your Salesmen. Print Jewelry or Diamonds lists with or without prices. Print Stock Tags with Bar-codes to attach to your lots, stones, or jewelry.
  1. Price List for SM - This report will print regular price per carat of ALL your stock.
  2. Price List for Clients - This report will print regular price per carat of Single Stones only.
  3. Diamond List - This report will print only single stones and omit prices.
  4. Diamond Breakdown - This report will print available stones, broken down by shape, size , color and clarity.
  5. Diamond Tags - This report will print tags with regular prices for all diamonds in stock. Single stones without certificates suppress color and clarity.
  6. Diamond Barcodes - This report will print tags with barcodes for all diamonds in stock. Single stones without certificates suppress color and clarity.
  7. Certificate List - This report will print a list of all certificates defined in lot card.
  8. Jewelry Price List - This report will print jewelry price list.
  9. Jewelry Tags - This report will print tags for all jewelry currently in stock.
  10. Jewelry Barcodes - This report will print tags with barcodes for all jewelry in Stock.

Transactions

Transactions - Print a detailed list of all the merchandise now on memo or which has been returned. List the same to see what merchandise you've sold or had returned and to which Clients. Also print all transactions from between any given date.
  1. Memos - This report will print all of today's memos.
  2. Memo Trans - This Report will print current memorandums only.
  3. Returned Memoed Items - This Report will print all items returned from memo.
  4. Sale Trans - This report will print last month Sales Transactions. For past Sales, choose " ALL History" and select the dates you want.
  5. All Trans - Displays all transactions for each memo, group together by client.

Sales

Sales - Print sales, commissions and profit reports, as well as returns for any given date and for any period of time. Print statements for all your Clients. Print actual income for any given period of time. An Aging report tells you how much your Clients owe you past due dates within 30, 60, 90 and more days.
  1. Invoices - This report will Print All of Todays invoices.
  2. Due Amounts - This report will print all Open recievables, including past due amounts.
  3. Aging Report - This report will print a summary of all open recievables, aged as 30,60,.... days past due.
  4. Statements - This report will print all open recievables With past due amounts.
  5. Commissions - This report will print last months commissions. For past commisions, choose "All History" and select the dates you want.
  6. Comm. Returns - This report will print last months commission returns. For past commisions, choose "All History" and select the dates you want.
  7. Collected Amounts - This report will print all the payments received from your clients. It also show statistical data on whether the client pay on time and average time she/he is late. For payments from one client only, select by that client (Company Name or ID).

Suppliers

Suppliers - Print a detailed list of current debts for each Supplier and totals to all of them. Find out how much you owe your suppliers and see the Past Due Amounts, expected to be paid until the end of this month, next month, and later months. Print a list of your payments to supplier. Compare purchase prices from different suppliers.
  1. Suppliers List - Gives you a list of your suppliers with address's and phone numbers.
  2. Due Amounts Detail - Prints a list of invoices (to you) organized by suppliers showing the invoice date, total amount of the invoice and a list of the terms of payment along with the current balance you owe on each installment. If a supplier has an interest rate specified on its Supplier Form , and you are tracking interest, the interest figures will be listed as well.
  3. AP Aging - This report will print a summary of all open payables, aged as 30, 60, ...days past due.
  4. Due Amounts Forecast - Coming Soon.
  5. Payments to Suppliers - Any paymets you've made to your suppliers are listed on this report and organized by Supplier ID. There are amount summaries per invoice, per supplier and grand total of all payments to supplier. You can select to produce this report by a given supplier, type of supplier (diamonds, jewelry, etc.) or by purchase date.
  6. Compare Prices - This report will print prices for purchased items sorted by quality.

Lists

Lists - Show different lists of DJ Wizard data. Included are the following lists for your convenience.
  1. Rapaport Tables - This report will print the rappaport prices on this system.
  2. Salesperson Diamonds List - This report will print a diamonds stock list currently held by the salesperson you specify.
  3. Salesperson Jewelry List - This report will print a jewelry stock list currently held by the salesperson you specify.

Taxes

Tax Reports - Print your year-end income by category, itemized expenses, and monthly journals (cash receipts, invoices, checks) for quarterly filing.
  1. Sales Journal - This report will print a journal of sales from the beginning of this year, otherwise specify the period.
  2. Returns Journal - This report will print a journal of sales returns from the beginning of this year, otherwise specify the period.
  3. Receipts Journal - This report will print a journal of cash receipts from the beginning of this year, otherwise specify the period.
  4. Income by Category - This report will print detailed income from the beginning of this year, otherwise specify the period.
  5. Purchases Journal - This report will print a journal of purchases from the beginning of this year, otherwise specify the period.
  6. Payments Journal - This report will print a journal of payments to suppliers from the beginning of this year, otherwise specify the period.
  7. Expense by Category - This report will print detailed expenses from the beginning of this year, otherwise specify the period.

Analyze

Analyze Reports - Review your inventory value based on Nominal costs and Sale prices. Analyze sales of merchandise between any two dates (e.g., the best selling shape/size/color/clarity combinations of diamonds). Find out who your best clients are and their business volume of Diamonds and Jewelry within any period of time. Print Salesmen Performance to evaluate your sales people individually, breaking down their sales into direct and office sales.
  1. Diamond Value - This report lists your diamonds by their cost value organized by Shape and showing if they are On-Hand (carats) or In-Stock (outside w/ a salesperson or on-Memo). The cost values are in Nominal (original) cost and in "ALL Cost Values" (i.e., original plus overhead costs, such as shipping, insurance, certicficate cost, labor of cutting, polishing, repair etc.). If a stone is on Memo to you, its Nominal Value Amount is zero. If it is in Partnership, it considers only your part of the Nominal Cost depending on your partnership type (JV, PO, PP, see Partnership)
  2. Diamond Series -This unique series report is a diamonds stock complete history, designed for partners needs in mind. It begins from the date you purchased the stone(s) (or the parcel) until it has been completely sold (or returned from sale). It shows the original diamond figures such as date purchased, Shape, average Size, Color/Clarity and Total Weight as purchased, and Nominal Cost and Cost per Carat. It details all the transactions related to this stone or parcel. Including, who are the clients, how many carats and at what Price per carat and Amount the items were memoed or sold to them. The real power of this report, comes from the extensive summary at the end of the report. It show Original and Sales Performance figures at cost values as well as extrapolation of what you can expect from it if you make the same profits in the future. It also shows Inventory Aging and Markup Recomendation Adjustments if you wish to get rid of items purchase in the same batch and the leftover have minimal cost residue.
  3. Diamonds Sales/Profit - This report will print diamond profits crosstab of colors between 'D' and 'K' or else choose selected by.
  4. Gem Value - This report lists your Gem stones by their cost value organized by Shape and showing if they are On-Hand (carats) or In-Stock (outside w/ a salesperson or on-Memo). The cost values are in Nominal (original) cost and in "ALL Cost Values" (i.e., original plus overhead costs, such as shipping, insurance, certicficate cost, labor of cutting, polishing, repair etc.). If a stone is on Memo to you, its Nominal Value Amount is zero. If it is in Partnership, it considers only your part of the Nominal Cost depending on your partnership type (JV, PO, PP, see Partnership).
  5. Jewelry Value - This report lists your jewelry pieces by their cost value organized by Type (e.g., Band, Earring, Bracelettes, etc.) and inside the Type they are organized by Style It lists the Stock IDs, the Gold Type, details of the stones set on each and number of identical items you currently have in you stock from eacg. This report shows all stock items and their Nominal as well as Cost Values regardless if they are outside with a salesperson or on-Memo.
  6. Jewelry Unit Sale - Shows jewelry unit sales and list the results by catagory/style/quantity.
  7. Jewelry Sales/Profit - Shows jewelry sales or profit and list the results by category/style/quantity
  8. Sales and Profit - This report will print last months sales. For past sales choose 'All History' and select dates you want.
  9. Returns - This report will print last month returns. For past returns choose 'All History' and select dates you want.
  10. Salesman Performance - Show sales by salesmen before discounts and takes into effect returns (no matter when it was returned). Example: In april a salesman sells $1000 worth of diamonds, if in June it gets returned, the total sales for april will show $0. It will not show $1000 in april and -$1000 in June).
  11. Stock Value by Type - Shows value of stock and shows you what part of it is on memo, bought, owned, or part of a partnership - There is a selection where you can see either your share or total stock value no matter who owns it.

Utilities

  1. Report Control - This is your control for producing report. Do not try to close it.
  2. Selection Criteria - Opens selection criteria box.
  3. Preferences - Opens printer driver/monitor preferences.
  4. Administrator - Opens company info (address, phone, city etc.).
  5. Calculator - Open up the calculator.
  6. Reminder - Creates a reminder.txt file that you can use to enter in notes that yo can come back to.






Pricing Information

© 2006 DJW, Inc. All rights reserved.