Consignors & Sellers - "Clients"

BCSS can be used to sell consignments and to buy merchandise from individuals for resale. Consignors and sellers are referred to collectively as 'clients' in the program.

Missing Records

If your data files are sent to tech support for an update or repair, don't add or change data in the program.

Inactive Records won't be included in lists and reports if individual records as tagged as 'inactive' and 'Include Inactives in Lists' in Program Setup (Clients tab) is not checked.

If a Record is 'missing':

  • Check the spelling of the name.
  • Edit the record and check as active:
  • Click 'View All' to make sure all records are present:
  • Sort the name column by clicking on the column header:

    In older versions of the software the database sorted all lower-case names first then first-letter-cap names next. Scroll through the entire list to see all possible variations of the name.

  • If on a network, make sure the remote computer is seeing the database on the host computer.

Things to Know

  • The Client List is sorted by the name appearing first. When adding new Clients consider entering last-name-first, a space, then the first name.
  • The Client ID can start with part of or all of a client's last name (and not numbers) to make sorting logical and item ownership apparent (when viewing price labels, lists and reports). Of course numbers can be used if preferred but don't use punctuation, (especially hyphens) or line breaks.
  • Set the default Client % (in decimal format; .4 = 40%) in File, Program Setup, Clients. The Client % is the share of the sale for the Client, not the shop. Each client and each inventory item record can have its own %.
  • Set the Client % for one Client by editing his/her record or by editing the inventory item record.
  • Create Client records for shop-owned items and set the Client % to 0 (to prevent creating settlement records). Multiple accounts can be used for shop-owned items. Don't use Transfer Accounts for shop-owned items.
  • Mailbox Feature - Notes for Clients: Select a Client and click Edit (or start a New-record). Click on Mailbox. Type a message to be given to the Client and/or as a reminder to you. Adding text here will highlight the Client record (in the main table) in pink as a reminder. Print Notes by selecting the Print Button while viewing the Mailbox screen or right-click on a Client and select Mailbox - Print.
  • Double click a record to edit it or RIGHT-click on a record for several options.

Things to Know about ID's

In BCSS clients are identified by a (short) string of letters and/or numbers (Client ID). Some stores use numbers (for anonymity) while others prefer to use part of the last name and first initial (for identification).

  • IDs should be short so they fit properly on labels and in reports.
  • BCSS recognizes a 'two-part' Item ID with the first part being the Client ID, so a Client ID like Smith-B might cause confusion if the Item ID for B. Smith is Smith-B-1. (Don't use hyphens in Client IDs).

Using part of the last name (and initials if necessary) makes finding a client in a list or report easier, and it makes ownership of inventory items easier to determine when viewing price labels and reports.

  • If part of the last name is used, the Client ID on the new-client screen will be blank.
  • If numbers are used, the Client ID on the new-client screen will be the next number in sequence.
  • Either way, the Client ID on the new-client screen can be entered or edited.

Import Client Data - Client information may be entered in spreadsheets (in .csv format) and imported into BCSS. Existing client records can be exported, edited then imported back into BCSS - a quicker way to modify multiple records.

Change Client % Globally using the Percentage Tool. Options include changing the % for all clients, changing only unsold items or changing sold/unsettled items.


Hide Old Client Records

  • In Program Setup (Clients tab) uncheck 'Include Inactives in Lists'.
  • To mark one client account as Inactive, edit the client record and remove the check from 'This Client Is Active' and save the change. To show the record in lists again, check 'This Client Is Active' and save the change.
  • To mark multiple accounts as inactive, in the Client Work Area, select Batch Deactivate. Set a date and click OK. All records with no activity prior to the given date will be deactivated.

Inactive accounts will not appear in drop-down menus and lists.

Inactive accounts may be excluded from Reports by checking 'Active Only' on the Client Report Screen.

Inactive accounts are not removed from the database so deactivating accounts will not reduce the size of the database.


Warning Do not use single or double quotations marks in any data-entry fields in the program. If changes are made on the new-sale screen, click the Refresh Button to recalculate values.

Warning Do not use any characters (other than a dash) in Client IDs.


The Client ID

Before creating the first client record, for Client IDs, decide whether to use numbers, letters or a combination of letters and numbers for IDs.

  • The Client ID appears on price labels and in reports. Numbers don't indicate identity where using part of the last name and first initial (or initials) for Client ID suggests client identity.

The Client ID CAN be changed later on and here's why:

The program creates its own 'Internal ID' for each record, so it knows each client, not by the Client ID (assigned by the store) but by the Internal ID (assigned by the program).

Allowing the Client ID to be changed provides the flexibility sometimes needed to resolve issues:

  • The store owner decides that using part of the last name and first initial is a better system for Client IDs and wants to change them.
  • The store is sold and the new owner prefers a different ID format.

If numbers only are to be used, open the new-client screen and observe the Internal ID:

Use the number that appears on your screen (not in the image above, which may be different) for the Client ID:

Each time the new-client screen is opened, the next number in sequence will appear for the Client ID. (If a 'duplicate-ID message' appears, sort IDs in the Clients Work Area, determine the last-used number and use the next number for the new client.)

If you're thinking that changing the Client ID would really mess things up, you're right. If we had originally created a record for Mary Smith with Client ID 22, her first items would have Item IDs of 22-1, 22-2, etc.

Then when we changed her Client ID to SmithM, her recent items would have Item IDs of SmithM-33, SmithM-34, etc.

Any ordinary consignment software program would throw a 'don't know' when calling for item 22-1.

To avoid the potential confusion and colossal mess, when Mary's record was first created with ID 22, BCSS assigned an 'Internal ID' (hypothetically '34') to Mary, so no matter what you decide to call Mary, BCSS would always know her as '34'.

At POS you could call items 22-1 and SmithM-33. The program would enter both items on the new-sale invoice, credit Mary's account with the sale of both items and include the items correctly in reports (under the respective Client IDs).

  • If there is a duplicate Item ID (Client ID + Item Number), delete the inventory record and reenter the item under the correct Client ID.
  • Attempting to change the Client ID in batch edit will display: 'Changing the Item ID does not change the associated client'.

Add a New Client

To enlarge the video screen, start the video...

...and click on the icon:

To add a new client, select 'New Client' from the Client's Menu (or press F2).

Hate typing? Not so good at it? With BCSS Virtual scan your new clients' drivers licenses to auto fill the fields on the new-client screen with name, address, license #, height and weight, etc.

Part or all of the Client's last name (and initials if necessary) can be used for the Client ID (to make sorting of Client Records logical and to make ownership of inventory items easy to determine when viewing price labels and reports). Any combination of letters/numbers can be used for the Client ID. (Hyphens in the Client ID can be used but should be avoided.)

Complete as much information as desired. To save a record, it is only necessary to add the name of the client. Other details may be entered later by editing the record.

  • For uniformity names might be entered (last first or first last - with no punctuation) to make lists neat, readable, alphabetized and sorted in correct order. If checks will be printed with the program, payee names will appear as they are entered here (last first or first last).
  • Birthday can be entered by selecting a date using the drop-down calender (down arrow in that field) but typing may be quicker, especially for the year.
  • Requested Space relates to Mall Floor Space Rental. (If police reporting is activated, look for that option on the Details tab.)
  • User Date is seldom used. Set a date to contact this person.
  • User Text can be any 'string of characters' that uniquely identifies the person (like 'best' for your best clients). (Only one 'string of characters' may be used per Client Record. Spaces are ok but commas and apostrophes will be removed by BCSS.) Later on a report can be generated using the 'user text' as a search criteria. (Show me a list of all clients flagged with the user text 'best'.)
  • Set a different Client % if applicable (in decimal form, .4 = 40%) and use the drop-down box to choose how to dispose of unsold items (donate, destroy, return, transfer to Transfer Account (shop) ownership. (If police reporting is activated, look for that option on the Details tab.)
  • With BCSS Virtual check 'Allow Online Access' to grant online access to the client. See Virtual Edition.
  • Remove the check from 'This Client Is Active' to not display the client record in lists and reports. This option makes it possible to 'hide' inactive records to shorten lists of clients.
  • Check whether to Send Mailings and/or Send Sales Reports. These settings and many others may be used later to generate specific lists of clients for address labels, reports, etc.
  • Check This Is a House Account if all sales for the client are to be credited to the shop account.
  • Check No Credit-Card Fee if the client does not wish to pay for credit-card charges from settlements. (An add-on module is available for setting a % in the program to be deducted from settlements of credit-card sales. See credit-card processing.

The colored buttons at the top are rarely used:

  • 'General' is the main page which opens when the new-client option is selected. (Throughout BCSS a yellow background on a button indicates the selected button or window or screen).
  • Notes may be added for shop eyes only.
  • Mail Box is for notes that are to be given to the client.

A Consignment Agreement may be printed.

Click Save/Exit to save the new record and close the screen.

If entering more than one client, press F2 or press 'Save and Continue' to save the current entry and open a new record:


Edit a Client Record

Double-click on a Client to open the Client Edit Screen. Make changes and Click OK to save changes and exit, or click Save and Continue to save changes and continue editing the same record.


Edit a Client Account Balance

Click on the Account Status tab to view and/or edit Store Credit, Balance Credit, and last dates for Update, New Item, Sale and/or Settlement.

The first entry, Account Balance, cannot be edited (which is why it is 'grayed out').

Warning An account can only have a beginning balance once. After a beginning balance has been set, use the following procedure to change account balance:

Edit a Client Account Balance

Double-click on a Client to open the Client Edit Screen.

Click on the Account Status tab to view and/or edit Store Credit, Balance Credit, and last dates for Update, New Item, Sale and/or Settlement.

The first entry, Account Balance, cannot be edited (which is why it is 'grayed out').

Not allowing changes to Account Balance allows the program to keep track of adjustments made and show a total adjustment in Account History. Otherwise there would be no way to know what has been done.

Making Adjustments

Change account balance by adjusting Store Credit and Balance Credit:

  • A plus to Store Credit increases Account Balance.
  • A plus to Balance Credit decreases Account Balance.

To correct Store, make plus or minus changes to Store Credit.


Correct Incorrect Client Split


Keeping Client Accounts in Balance - how to use BCSS and accounting principles to keep client account balances in order.

Basic Accounting Principles

An understanding of basic accounting principles is necessary to make sure that all BCSS computations and client accounts are correct. A glossary or terms appears below.

Consignment Accounting

Accounting for consignment sales includes the added complexities of split sales proceeds and the settlement of sales. Otherwise, the process of recording sales and computing profits is essentially the same as for any store.

When a sale is finalized (saved in BCSS) accounts for the store, the client (and the employee in BCSS Diamond and Virtual) are credited and the settlement account is debited.

Accounting Terms

Allowance in Accounting Principles generally refers to an amount deducted from Accounts Receivable for bad debts. In Sales, Allowances are reductions in sale price based upon qualifying circumstances (like merchandise defect).

Accounts Payable are amounts owed by not yet paid (a form or debt); therefore, A/P is a form of credit which allows purchasers to pay for a product or service after delivery of the product or service.

Accounts Receivable (Trade Receivables) is the amount customers owe. On the Balance Sheet A/R's are a Current Asset if payment is due within 1 year.

Balance Credit is a manual adjustment. Positive/negative Balance Credit will subtract/add from/to Client balance.

Credit Balance is an account balance in the customer's favor.

Debit Balance is an amount owed to the seller.

  • A debit transaction decreases a credit balance or increases a debit balance.
  • A credit transaction decreases a debit balance or increases a credit balance.

Debits and Credits are a system of notation used in accounting to both keep track of the flow of money (transactions) into and out of an account, and to indicate the type of account. Traditionally, an account's transactions are recorded in two columns of numbers: debits in the left hand column, credits in the right. Keeping the debits and credits in separate columns allows each to be recorded and summed independently. The smaller of the two sums is then subtracted from the larger to give the account value. An account may thus have either a credit value or a debit value. more: http://en.wikipedia.org/wiki/Debits_and_credits

Gross Income is all income (from any source). For a business Gross Income is Pre-Tax Net Sales less Cost of Sales. (For individuals Gross Income is income before taking deductions or taxes into account.)

Income For households 'income' is the sum of all the wages, salaries, profits, interests payments, rents and other forms of earnings received. For businesses, 'income' generally refers to the amount of revenue remaining after expenses.

Profit or Net Income (the 'bottom line') is Total Revenue minus total expenses (in a given time period) and is equal to Total Revenue - Cost of goods sold - Sales discounts - Sales returns and allowances - Expenses - (Minority interest (shareholders) and Preferred stock dividends).

Inventory for consignment stores is generally a list of all items in the store for sale. Because ownership of consignments remains with sellers, consignments are not an asset of the store. Items that have been purchased by store principals which are for sale in the store are part of store inventory.

Net Sales (Revenue) is Gross Sales received for goods and services sold minus Sales Discounts, Sales Returns and Sales Allowances. Net Sales appear on the Income Statement as Sales or Net Sales.

  • Sales Returns: Refunds for returned merchandise
  • Sales Allowances: Reductions is sales price
  • Sales Discounts: Reduced payments based on invoice terms such as 2/10, n/30 (2% discount if paid within 10 days; net invoice total due in 30 days)

Gross Sales is the total invoice value of sales (during a time period) prior to deducting discounts, returns and allowances. Net Sales appear on income statements - not Gross Sales.

A Sale is the seller's passing of ownership of an item to a buyer for money or other compensation. A sale of merchandise is recorded in a General Journal as a debit to cash (or accounts receivable) and a credit to the sales account.

Stock Keeping Unit (SKU) is a unique identifier (attached to each billable item, variant, product line, bundle, service, fee or attachment) used to systematically track inventory.

Store Credit is an amount the store (debtor) owes to the customer (creditor) which the customer may use to make purchases. Store Credit = Total Settlement Amounts - In-House Purchases. As In-House Purchases uses Store Credit, Balance Due plus Store Credit decreases. Shop Credit increases when settlements are made for credit. The Total Account Balance will remain the same while removing the sold inventory from the unsettled list. The outstanding account balance can then be used to purchase goods from the store. Most commonly stores issue store credit when merchandise is returned without the original receipt.

The BCSS Consignment Agreement

Disposal Code appears on the Consignment Agreement.

Print Agreement and Inventory List Press 'Print Agreement and Item List' on the Batch-Enter window (after entering items) to print the Consignment Agreement and a list of the items added. Choosing to print the Agreement at any other time will print the entire inventory for all consignors.

Two generic Consignment Agreements are included in BCSS. The 1st is for 1st-time consignors and prints on a full sheet of paper. The 2nd is a shorter version for repeat consignors. Two copies are printed on 1 sheet of paper.

When either is printed, BCSS auto-enters the shop's information (that was entered in Program Setup) and the Client's information (from the Client's record).

The 'body' of the 1st Agreement contains sample shop terms and agreements which may be changed.

The 2nd Agreement is a short form for recording any changed information (like new address, new phone number) and the number of new items consigned. It too may be edited.


Editing the 1st Consignment Agreement

On the Main Menu, click on Utilities and select Edit Client Agreement:

Make deletions, additions, changes and click Save and Exit when finished. Restart BCSS. The changes will appear when the next agreement is printed.

Copy/Paste text into the Agreement Editor.

Note that any line in the Agreement should not be longer than (approximately) 120 characters. Lines longer than that will exceed the right margin of the printed page.

Note: The Agreement should be edited within BCSS. Writing the Agreement in Notepad, WordPad or any text editor and pasting into the BCSS Editor will lose the hard line breaks at the end of each line (created by pressing Enter at the end of each line).

The maximum number of lines that can be entered is 35.

The Agreement may be changed at any time. Past versions of the Agreement are not saved (but the content may be pasted into another document and saved).


Editing the 2nd Consignment Agreement

The procedure for editing the 2nd Agreement is different but fairly easy.

  1. On the Desktop, click on My Computer then C: then Program Files then BCSS.
  2. Click on addendum.txt. (This is the text file for the 2nd agreement.) Your computer should open addendum.txt in a text editor like WordPad or Notepad.
  3. Make changes. Hold down the control key and press the 'S' key to save changes.
  4. Close the file. Changes will appear when the 2nd Agreement is printed.

Printing the Consignment Agreement

In the Clients Work Area, RIGHT-click on a Client Record and select 'Agreement 1st' or 'Agreement 2nd' or, for the first Agreement only, select the Client and Press 'Print Agreement' on the right.

A Print-Preview Screen will display the agreement with shop and Client information pre-filled.

Preview the Agreement and press the printer icon to print.


Windows Print Setup

The next screen to appear is the Windows Print Setup screen. (It should not be necessary to change settings under 'Setup' on this screen, except to assure that Orientation is 'Portrait'.)

The settings should be:

  • Name: The correct printer name should appear here.
  • Size: Letter (A4 in New Zealand)
  • Page range: Current page (or All)
  • Orientation: Portrait (Never 'As Preview')
  • Number of copies: Change '1' to '2' to print 2 copies.

When settings are correct, press OK to start printing.

Balance Credit reduces the Client Account Balance without affecting Store Credit.

To edit Balance Credit:

  1. Double click on a Client Record to open the edit screen.

  2. Click on the Account Status tab.

  3. Click in the Balance-Credit Field and enter the amount of the adjustment.

  4. Click OK to save the change and exit, or click Save and Continue to save the change and continue editing the Record.
  5. To view the Store Credit, with the same Client still selected in the Client Work-Area Table, click on Account History (on the right)

    or look below in the Details Area:


Client Percentage is the share of the sale proceeds to be paid to the client. The percentage set for the client will appear in the Consignment Agreement.

Client % by Category - Assign different Client %'s to different categories. Go to Main Menu then Inventory then Categories. Select a Category and enter the appropriate percentage. Click Save/Exit.

Client Bonus for Store-Credit Settlement - Give an automatic bonus to Clients who settle for store credit. In Program Setup on the Clients Screen, set the bonus amount in 'Bonus for Store Credit Settlement'. When 'Credit' is selected as the settlement payment method, the bonus is auto-applied. (not available with batch settlements)


Set Client Percentage

There are 5 ways to set the Client Percentage:

  1. The default percentage for all new clients is set in Program Setup. Click on File:

    Click on Program Setup then click on the Clients Tab:

    Change the default % (0.40000) to the desired value (in decimal form, like .50 for 50%):

    The default percentage set for the client will appear in the Consignment Agreement.

  2. Change the Client Percentage when adding a new client on the New-Client Screen:

  3. After a new client has been entered, edit the Client Record and change the default percentage for that client. That % will apply to all new inventory from that client. It will not apply to existing inventory. Use the Percentage Tool to change the % for existing inventory and sold/unsettled items.

  4. After an inventory item has been entered, edit the inventory item record to change the percentage for that one item. (Double click on any Inventory Record to edit it.)

Change Client % (Unsold or Sold/Unsettled)

After an inventory item has been entered, edit the inventory item record to change the percentage for that one item. (Double click on any Inventory Record to edit it.)

To change the Client % on multiple records of inventory (unsold or sold/unsettled), use the Percentage Tool:

The Percentage Tool: Change Client % Globally

Make at least one backup of your data before using this feature.

The Client % can be changed for 1) unsold items and 2) sold-but-unsettled items. The options are to update:

  1. All unsold items.
  2. All sold unsettled items.
  3. Unsold items for one client.
  4. Sold unsettled items for one client.
  5. Change the current percentage for existing client records.

Change Client % for One Client

Make a backup of the database before using this feature so the current data can be restored if needed.

  1. In the Clients Work Area, select a Client
  2. In the lower-left menu select Percentage Tool
  3. Remove any values in the 'New Client Percentage on Sales'.
  4. Enter the desired percentage in decimal form. (.60 = 60%; 1 = 100%; Do not enter 100 for 100%.)
  5. The first two options must NOT be used when changing the % of one client:

  6. To the right of 'Update unsold items from the indicated client only' click on the button with the client's name to update unsold items.
  7. Likewise click on the button with the client's name to Update sold but unsettled items (if appropriate).
  8. When finished, close the screen (named 'Modify Global Client Percentage').
  9. Spot check records to assure correctness.

Change Client % for All Clients

  1. In the Clients Work Area, in the lower-left menu select Percentage Tool.
  2. Remove any values in the 'New Client Percentage on Sales'.
  3. Enter the desired percentage in decimal form. (.60 = 60%; 1 = 100%; Do not enter 100 for 100%.)
  4. Select ‘Unsold’ to update all unsold items REGARDLESS OF CLIENT.
  5. Select ‘Unsettled’ to update all sold but unsettled items REGARDLESS OF CLIENT.
  6. When finished, close the screen (named 'Modify Global Client Percentage').
  7. Spot check records to assure correctness.

As of 8/17/13 with v. 6.0.412, the Percentage Tool can be disabled by checking 'Hide Percentage Tool' on the clients tab in program setup.


Current Charges

Amounts can be charged to a client's account and paid by settlement, store credit or any method of payment.

Enter the Amount in the Client Record

  1. Edit an existing Client Record.
  2. Click on the 'Current Charges' tab at the top.

    There are 7 predefined types of charges (Advertising, Consultation, Credit-Card Fees, Delivery/Pickup, Preparation, Rent and Taxes). These will always appear, plus a set of blank lines below. (For mall space (booth) rental, rents are added to this list automatically, including past due if appropriate.)

  3. To add charges, edit one of the predefined lines, or use one of the blank lines below the predefined lines to add a fee type.
  4. Either way enter a description and an amount.
    • Click OK to save the entry and process the payment later (via a settlement or store credit).
    • Click Exit to close the window and not save the entry.
    • Click Save and Continue to save the entry and continue editing.
    • Check the 'Pay This?' box and select Pay Selected to start processing the payment from Store Credit.

When this window is next opened, entries appear at the top, plus the 7 predefined types and blank lines below ready to be used again.


Collect Payment from Store Credit

  1. On the Current-Charges Screen, check the box(es) of the charges to be paid.
  2. Select Pay Selected. A Credit-Sale Screen will open with the amount of store credit available.
  3. If the amount of store credit exceeds the payment, click Save to save the transaction, or click 'Save, Preview, Print' to save and print the transaction.
  4. If the amount of store credit is less than the payment, additional payment may be collected by completing the payment information in Pay Method 1. Click Save to save the transaction, or click 'Save, Preview, Print' to save and print the transaction.

BCSS will debit the client's account for the amount of store credit used. If the payment exceeded store credit, store credit will be negative.


Collect Payment Via Settlement

  1. In Program Setup on the Mall tab check 'Deduct other charges from settlements.'
  2. Select the Client.
  3. Press F7 or select New Settlement.
  4. The amount of the charge will be displayed as a deduction and can be edited.

Inventory List for One Client

There are 4 ways to view a list of inventory items for one client:

  1. 1 and 2: Account History and Current Items - Account Balance, Account Balance Purchases, Adjustments to Store Credit, Balance Credit, Beginning Account Balance, Cash Payments, Client %, and ID, Date of Last Action (sale or settlement), In Date, Invoice #, Item Description, Price, Quantity, Settlement Amount, Total Purchases, Total Settlements for Credit, Total Tax. In addition, Account History displays Settlement ID and Current Items displays Item Notes.
  2. 3. Detailed List - Barcode, Category, Client ID, Date In, Details, Discount, Discount Date, Item Description, Last Sale, Prices (Original and Current), Quantity, Total Price of All Items
  3. 4. Brief List - Category, Client's Name, Client ID, Date In, Description, Price, Quantity

Account History and Current Items

Account History shows all items consigned by a client, their disposition and how transactions produce the Current Account Balance. Current Items does the same but shows only items that have not been settled.

As of version 6.0.900 unsold inventory items appear in both reports (even though, of course, unsold items don't enter into the computation of the current account balance.


Create the Report

Select a Client from the Main Table in the Clients Work Area.

Select Account History or Current Items from Quick Links:

A comprehensive report will be presented and can be printed.


Print or view the Detailed List and Brief List this way:

  • On the Main Menu select Reports.
  • Select Inventory.
  • Click the blue drop-down arrow and select the Client.

  • For a Detailed List, press the Print Detailed List Button:

  • For a Brief List, press the Print Brief List Button:

  • If you wish to view a range of the Client's items, check the Items # Range and enter the first Item # only in the From Field and enter the last Item # only in the To Field. For example, if the Client ID is Steph and items are numbered Steph-1, Steph-2 and so on, and you want to see items 7 through 11, just enter 7 and 11, not Steph-7 and Steph-11:

    (The range will be ignored if the box isn't checked.)

  • To print the report, click on Print Detailed List or Print Brief List.
  • To view the Report in the Main Table, press View the Report.

Causes and Cures for Negative Balances


Symptom: Account Balance and Store Credit are both negative.

Cause: Buying more in credit sales than has been earned in sales revenue

Cures:
  • Leave the negative balance to be satisfied from future sales, or
  • Collect the difference from the client, or
  • Manually adjust the account balance to zero and absorb the loss

Symptom: Account Balance is positive and Store Credit is negative.

Cause: Ringing up a store-credit sale before processing outstanding settlements

Cure: Manually settle with the client. The store-credit payment will appear in the first payment option and remaining funds will be displayed in the second payment method with check as the payment type.

The program will display the difference between Account Balance and Store Credit. The difference will be the amount available for purchases or settlement.


Manually adjusting the store-credit balance should ONLY be done in extreme cases as doing so causes the audit trail to be lost.

Settlement Payment for One Client

There are 2 places to prepare a payment for one Client -

  1. On the New-Settlement Screen
  2. In the Disbursements Work Area

1. New-Settlement Screen

When the New-Settlement Screen is opened, BCSS auto-enters the next available check #s. Ignore check #s if payment is other than by check.

To prepare a New Settlement, complete the first payment fields (Check #, Payment Method, Amount):


Split Payments

Payments to Clients may be split between 2 of these methods - Cash, PayPal, Check, Credit or Gift Certificate. For Payment 1 select a method from the drop-down menu under Select Payment Method and select another for Payment 2, entering the amounts for each under Amount.

The Client's Shop Credit increases when Settlements are made for credit. The Total Account Balance will remain the same while removing the sold inventory from the Unsettled Sales List. The Outstanding Account Balance (Store Credit) can then be used for purchases.


2. Make Payment from the Disbursements Work Area

When a Sale is settled, BCSS creates a Disbursement Record in preparation for payment to the Client. Click on Disbursements in the Work Areas Menu to view all Disbursements in the Table.

RIGHT-click on a Disbursement Record to view the Context Menu:


Menu Options:


Edit - Open the Disbursement in an Edit Screen, Make changes, if any, and Save.


Print Check - Begin the Print Checks Process


Toggle Approved Status - Approve or Disapprove a prepared check.

(the other options are for viewing Disbursements on a daily, weekly, monthly or yearly basis, or 'View All'.)


Edit the Check

Clicking on Edit opens the Check-Edit Screen:

There's provision for setting check margins in addition to changing the name of the Payee, the Date, the Amount, Approved Status and Address.


Print the Check

Selecting Print Check from the Context Menu begins the Check-Printing Process by opening the Check-Position screen.

Select which check position to print - 1, 2 or 3 and click to close the window.

A Print-Preview Screen will appear displaying how the check will be printed. If adjustments or corrections are needed, close the Print-Preview Screen and edit the Check Record.

If no changes are needed, select the Printer Icon at the top of the Print-Preview Screen.

When printing for the first time, print a check on a white sheet of paper and hold the printed sheet and a sheet of checks together, one over the other, up to light to verify that the print aligns with the check spaces.

Client Reports

Total Paid to Clients - Run a disbursement report to see the amount paid to each client as a subtotal and the total amount paid for all consignors for a given period of time:

  1. Click on Reports on the Main Menu.
  2. Select Disbursements.
  3. Set the Payment-Date range and be sure to check the box:
  4. The Payment-Amount range can be set to only include payments above and below specified amounts.
  5. Click on Print the Report.
  6. On the print-preview screen, use the arrows to navigate between pages:
  7. Click on the last arrow to view the last page and the total for all payments.

Quick Report: How Much Are Clients Owed?

  1. Click on Reports in BCSS and select Clients.
  2. Check Account Balance and enter 0 and 10000 (to assure including all client balances):
  3. Click on 'Print the Report' to view the amount owed, or
  4. Click on 'View the Report' to view (in the Main Table) only Clients with a balance owed. (Click View All to view all client records again.)

A 'Client Report' is basically the result of a 'search' of the BCSS database for specific Clients - like a Google search with an important difference: Based upon your 'search criteria' a BCSS Report will include only the desired information and not 'close matches'.


Create a Client Report

Select Reports from the Main Menu:

Select Clients:

Settings on this screen tell BCSS which Clients are to be included in the Report.

For example, to create a list of Clients who are Active, who are on the Mailing List and who have account balances between $0 and $500, make these settings:

1. Check 'Active Only'.

2. Check 'On Mailing List'.

3. Check 'Account Balance' and enter 0 and 500 in the From and To fields. (If the box is not checked the settings will not be applied.)


Parameters

Clients may be included in the Report based upon Birthday, Birth Month, Date of Last New Item, Date of Sale or Date of Settlement, User Date or User Text, Active/Inactive status, Unsold Items Disposition, Transfer Accounts Only, On Mailing List, To Receive Sales Reports and/or With Inventory Only.


Sort Output

The content of the report may be sorted by ID, Name, New-Item Date, Settlement Date. Check one:


Print Reports

Selecting Print the Report -

will present the Report is a Print-Preview Screen:

The Report may be printed by pressing the printer icon (yellow arrow).


View the Report in the Main Table

Selecting View the Report

will present the information in the BCSS Main Table.


Time Filters

Click on these buttons:

to view records in the Main Table that have been added or edited today, last 7 days, last 30 days, etc. Click View All to see all records again.


Quick Links

BCSS is divided into Work Areas. They are:

Each Work Area has its own set of Quick Links. These are the Quick Links for Clients:

With Quick Links, select a Client and easily:

  • View account history
  • View current items
  • Transfer items to the shop's Transfer Account
  • Print one or more copies of the pre-filled Client Agreement
  • Return items
  • View the current settlement due
  • Undelete items (return them to inventory)

Individual Client Information

Select a Client in the Main Table then view information about the Client in the Details Area at the bottom.

Click on the colored tabs at the bottom to view different screens of information (Details, General, Items, Notes, Settlements).

Search and Sort Records

Note: Columns containing both letters and numbers is sorted (in databases) as text so numbers will appear in order of 1,10,2, not 1,2,10. Due to a limitation of the component used in the program, numbers also sort as text in reports and in lists of labels.


When looking for records currently added or edited, click on the time-period buttons to display records for the time period selected:

Click on View All to restore all records.

If a record doesn't appear after it's been added, click on View All.


Sort Columns in the Main Table (version 6.0.516 and later)

In any Work Area, click on the table header to sort the column alphabetically or numerically:

Click on the header again to reverse the sort order.

The triangle on the right of the column header indicates the sort order:

It may be necessary to move the vertical scroll bar (on the right of the main table) up or down to find a record.

Please note:

  • If every record (ID, Name, etc.) has letters only or numbers only, the sort will be A-Z or 1-10.
  • If records have a mix of letters and numbers (like Client IDs SmithJ and 125), the sort will be alphabetical so the sort of numbers in such a list will be 1,10,2, not 1,2,10.

Finding a Record

In November, 2013 (version 6.0.850) the search box was moved under the center table:

Search Options

Click on File then User Interface to select search options.

In Buyers, Clients, Employees and Settlements, searches can be by either ID or Name but not both.

In Disbursement searches can be by 'Paid By' or 'Paid To'.

In Inventory searches can be by ID1, ID2 or Description.

Sales searches can be by Invoice # or Name.

On the same screen, check 'Search by first letter/number only' to exclude any records that might include the search anywhere in the record. If this option is NOT checked, entering a search like 'ike' will find Ike Eisenhower and Mike Martin.

To search type the first number or letter of the ID, name, description or invoice #. If that doesn't find the correct listing or reduce the number of listings to a few, type the next number or letter of the name or ID.

Records can also be found by using Reports.

Watch a video.

How Search Worked Prior to Version 6.0.516

  • Search by ID - Replace 'Enter Search' with part or all of an ID ('Paid By' in Disbursements) and click the first button (with the 'white I' in the blue circle).
  • Search by Name - Enter part of all of a name ('Description' in Inventory) and click the 2nd button (with the 'white N' in the blue circle).
  • Click the 3rd button (with the white arrow) to find the next record (if any) that matches the ID or name entered.

What is Store Credit?

'Store Credit' is an amount of money the store owes the customer.

There are several reasons why a store might owe money to customers (like refunds, account adjustments) but in consignment, customers may be issued store credit in lieu of payment by cash or check.

Settlement for Store Credit

At settlement, BCSS provides options for how consignors are to be paid for sold items: cash, check, gift certificate, PayPal or store credit. ('Gift Certificate' and Store Credit are similar in concept.)

Manual Issuance of Store Credit

A Client Record may be manually adjusted to award store credit:

  1. Double click on a Client Record to open the edit screen.

  2. Click on the Account Status tab.

  3. Click in the Store-Credit Field and enter the amount of the credit.

  4. Click OK to save the change and exit, or click Save and Continue to save the change and continue editing the Record.
  5. To view the Store Credit, with the same Client still selected in the Client Work-Area Table, click on Account History (on the right)

    or look below in the Details Area:


  • Store Credit is applied against Settlement Due.
  • Store Credit will appear on the Sales Invoice for Client Credit Purchases.
  • Store Credit is adjusted automatically when a client buys from the shop and receives the client share from sales of items consigned.

Total Owed to Clients

One of the most-frequently asked questions is, "How much do we owe our consignors?" The answer is easy to find in BCSS.

Warning Sales on hold will cause account totals to disagree. Either finalize the open invoice or void it to resolve the issue.


Display/Print Amounts Owed to Some or All Clients

  1. In BCSS, click on Reports on the Main Menu:

  2. Select Clients.

  3. Check 'Account Balance' and enter a range:

    (The box must be checked for ranges to apply.)

    • Enter a large range (0 to 10000) to include all consignors.
    • Enter a range (like 10 to 100) to see only amounts due for the range entered.

  4. The Report Output can be sorted by ID, Name, New-Item Date or Settlement Date:

  5. Press Print the Report:

  6. View the list on the Print-Preview Screen.
  7. Scroll down to see the total (or use the arrows at the top of the screen to navigate).

  8. Print the report by clicking on the printer icon:

  9. ...and complete the Windows printing process.


Year End Totals Owed to Clients

Each year at year end a reminder is sent to stores to keep a copy of the BCSS data as it exists at the end of the year. The copy is needed to create a report for amounts owed at year end.

Report output can be refined by changing settings of the Report Screen and pressing the Print-Report Button again.