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':
Still no record? The next likely possibility is that the client record is flagged as 'inactive' and inactive records are not included in the client list.
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.
Things to Know
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).
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.
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
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.
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.
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 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:
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).
Add a New Client
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.
The colored buttons at the top are rarely used:
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').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.
Change account balance by adjusting Store Credit and Balance Credit:
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.
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.
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.
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.
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.
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:
When settings are correct, press OK to start printing.
Balance Credit reduces the Client Account Balance without affecting Store Credit.
To edit Balance Credit:
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:
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.
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:
Change Client % for One Client
Make a backup of the database before using this feature so the current data can be restored if needed.
Change Client % for All Clients
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.
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
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.)
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
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
Inventory List for One Client
There are 4 ways to view a list of inventory items for one client:
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:
(The range will be ignored if the box isn't checked.)
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 revenueCures:
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. 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):
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:
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.
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:
Quick Report: How Much Are Clients Owed?
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:
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.)
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.
The content of the report may be sorted by ID, Name, New-Item Date, Settlement Date. Check one:
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.
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.
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:
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.
Finding a Record
In November, 2013 (version 6.0.850) the search box was moved under the center table:
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
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:
or look below in the Details Area:
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.
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
(The box must be checked for ranges to apply.)
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.