Custom Design Data's Wholesale Flower Market System is a versatile accounting system that can track accounts, billing, and inventory for wholesalers.
Accounts Receivable
This allows you to enter in postdated invoices and post the cash received from your customers directly on line, or indirectly through a batch system. Payments can be booked as checks, cash, wire transfers, credit card payments or charges against pre-existing credits. You can write off bad debts, note bounced checks (which result in a $20.00 charge to the customer), and allow discounts to be taken. You may also transfer monies from one division to another within your company. You can maintain a customer master file that can be shared by multiple companies. The customer file will reflect the assigned salesman, trucking route, credit limit, street address, sales tax ID, telephone numbers, bank account and/or credit card number. You can print Accounts Receivable aging reports by date, delinquency, credit limit and open accounts. These lists can be printed alphabetically or by customer number. You may print monthly statements of account for your customers to pay from. These can be based on only open invoices or on all invoices booked within a period. The system also allows you to display a customeršs account. It will list each invoice and show the payments made to that item. On the bottom is an aged summary breakdown of the open amounts. A full credit history screen is also available.
Accounts Payable
This will allow you to post consignments and payable invoices. You can maintain a vendor master file that contains name, street address, type of vendor, 1099 designation, commission rate for consignments, phone number, fax number and tax ID. You may reverse open invoices and post inter-company charges. You can print an aged open payables list by delinquency, by date, for specific vendors or by outstanding amounts. You can print consignment statements that include freight charges and commissions. You can display a vendoršs account showing all the invoices both closed and open by line. Any payments against an item are noted. On the bottom is an aged summary breakdown of the open invoices. An invoice can be changed at a later date after posting and the appropriate charges will be made to the purchase journal. The payables can also be tied to an inventory system for costing purposes.
Billing Control
This allows you to produce point of sale invoices. These can referenced to existing open orders or entered on the spot. It will print the invoices, calculate sales tax based on point of delivery, charge freight, credit the proper salesman and run a credit check on the client based on the credit limit setting. Customers who are COD will be forced to pay cash. Cash can also be accepted during billing. A full customer search is allowed based on name and the same is also allowed for the items sold. The system will distinguish between non-durable and hard goods. Both can be intermingled on the same invoice. Sales tax tables are maintained externally so that you can change the rates or add counties or states as required. Sales history is kept on all sales and can be retrieved by salesman, customer, date, area, flower or hard good number and volume. You can display a customeršs account, reprint invoices and or statements, display purchase or sales history on an item and print a sales tax report as needed.
Cash Disbursements
This allows for the selection of bills to be paid by vendor, date, discount and total balance. Consignment payments are also allowed for. A full statement is produced to accompany the payment. The discount can change from grower to grower, and all freight charges are deducted from the payment. The checks can be printed on the system. You may also enter in hand checks, print a check register, void checks, reverse void checks and display payments by vendor, date or check number. If a check is reversed, the accompanying payable invoices are re-opened. Full bank reconciliation is available on the system. Wire transfers can also be entered and are reflected on the bank reconciliation.
General Ledger
This allows for the maintenance of a chart of accounts with sub ledger numbers. Most of the journals that make up the ledger file are created within the other modules. The billing module updates the sales journal, while the accounts receivable module posts the cash receipts journal. The following reports can be printed: Purchase Journal by date, vendor number, or account number; Cash Disbursements by vendor number, account number, check number or date; Sales Journals by customer, account number, salesman, item number or date; Cash Receipts by salesman, account number, batch number, customer or date. You may post additional journal entries using a journal-posting program. You can print a full general ledger, a trial balance, a profit and loss or a cash activity list.
Inventory
A fully detailed inventory is now available on the system. It is kept by item number, receipt number and date. It is based on FIFO. It shows the receipt number, vendor received from, quantity on hand, amount allocated and to where, unit cost, type of booking, location and purchase order number. This is tied directly into the invoicing programs and the order entry programs. A summary inventory is also kept. A full detailed history of inventory is available for display.
Order Entry
This allows for the entry of orders as they are called in or hand delivered. It allows you to take in requests prior to delivery by weeks, days months or years. You may also enter in blanket orders for a customer and note the amount of times it is to be filled. You can print a pick list for a given day to accommodate the filling of these orders. This system also allows you to assign orders to different routes and print sheets for each route. You may also transfer orders from one route to another. An automatic back order system exists based on the print of the invoices. If a line partially filled and the order is not a blanket the system will index the sub order number by 1 noting it as a back order. All orders start with a sub order number of 0. The orders can be displayed by promise date, salesman, customer, order number or route number.
Sales Analysis
This will allow for the print of sales reports by salesman, customer, date, item number and invoice number. These records may also be displayed on the system. A full 24-month sales summary history is kept by customer and item. The individual sales records are also kept on the system. You can print a profit and loss by flower number or customer. This compares the cost of a particular flower, including freight and overhead, to the average sale price of a particular flower for a given period. This way you can monitor the value of particular flowers over a given period.
Backup and Reorganization
The backup of the system is automatically done nightly. The reorganization of files is done by date, across the entire platform. All open invoices regardless of age are never removed. All ledger entries are summarized into open balances. Prior to reorganization, a full backup is taken for archival purposes. |
|
Custom Design Data, Inc. :: P.O. Box 7136 :: Hicksville, NY 11802
516.236.5441 (p) :: 516.822.1645 (f) :: custom@customdesigndata.com (e) |