Inventory, Sales (POS), Settlements, Disbursements

Buy Outright (Resale, 'BOR')

In Program Setup > Inventory check 'Print BO [buy outright] Agreement and Item List on a single page' to activate that option.

'Buy Outright' is purchasing merchandise from individuals (not companies). A client record is required to record information about the seller, the items purchased and prices paid. (In some jurisdictions police are now requiring second-hand dealers (resellers) to record the same information that has been required of pawn shops.)

Don't use House Accounts for buy outright.

For shop-owned items create one or more accounts and set the Client % to 0 (zero). All sales proceeds will accumulate in the shop account.

For more than one person buying and reselling in the same shop, create an account for each and set the Client % to the appropriate value. (Entering '1' equals 100%.) Do NOT check this box:

If that box IS checked, attempting to use Batch Buy Outright will display a message: "House Accounts cannot be used for buy outright".

Settlement

Consigned items belong to consignors who are paid after items sell. In BCSS the process of paying consignors for sold items is referred to as 'Settlement'.

With buy outright 'settlement' takes place when the items are taken into inventory and sellers are paid.

Once the Buy-Outright screen has been opened, please do not minimize it or switch to another screen (to process a sale, for example). Instead, finish making entries (and printing price labels if desired), and close the Buy-Outright screen.


Buy Outright and Client %

As a 'consignment software program' BCSS processes buy-outright transactions as consignments (with settlement at the time of purchases). When buy and sell prices are entered for a buy-outright item, BCSS computes what the Client % would have been if the transaction had been a consignment. This is necessary to make computations correct within the program.

For example, if the buy price is $10 and the sell price is $100, BCSS would calculate the Client % to be 10%.

For information purposes, this 'Computed Client %' is displayed in Item Details. (Go to Inventory, select the Item and view the % at the bottom of the screen.) This entry cannot be edited. For all intents and purposes it can be ignored.


Program Setup for Resale (Buy Outright)

If BCSS is to be used exclusively for resale, make these settings:

  1. Click on File then Program Setup then Inventory.
  2. Check these options (and remember to uncheck the first option if consignments are added in the future):

  3. Click on the Clients tab and enter your clients' most common city and state (so it doesn't have to be typed in each time on a new-client record). City and state can be changed for any new or existing client.
  4. If purchases are to be funded with the shop's Store-Credit Balance, check:

  5. The New-Client Screen has typical fields for basic seller information (name, address, etc). If you are required to record sellers' details (height, weight, eye/hair color, ID numbers), in Program Setup on the check this box to add ID fields (not shown here) to the New-Client Screen:

    This is a feature of BCSS Diamond and Virtual.

  6. Click on the Printers tab and set the Ink Printer to the correct selection, and make sure the printer can self test or print from another program. If a printer is not listed, it needs to be installed.

  7. Click on Utilities then Edit Buy Outright Agreement:

  8. Type text that is to be printed on agreements. Note that any line longer than (approximately) 120 characters will exceed the right margin of the printed page. Use the Enter Key to start a new line at or near the 120th character on any line.

    Text entered here must be limited to 3 lines. Typically the text is a statement by the seller that he/she owns the item(s) and has the legal right to sell them. (Local law enforcement usually dictates the wording.)

  9. Click Save and Exit and restart the program.

Enter a New Seller and Purchase Merchandise

To keep accurate records, account and till balances, an account must be created for each individual seller:

  1. Press F2 to open the New-Client Screen.
  2. Complete as much information as you wish. The program only requires an ID and name. IDs can be letters, numbers or a combination. For organization and sorting of lists, the format should be consistent. Stores often use part of the last name and first initial, like KennA and enter the name in last-first format like Kennedy Ann (space, no comma).
  3. Press 'Save / Enter Buys':
  4. Adjust the screen size if necessary.
  5. The table will be populated with the Seller ID and sequential item numbers, the Default Category (if set in Program Setup), Quantity (of 1), Barcodes and the current date (Date In). (If the first item number is incorrect, close the screen and click on Items at the bottom. Observe the last number used. Press F3 to open the single-item add screen and enter one item using the next number in sequence. Save the entry then reopen the batch-enter screen.)

  6. Enter a description. The field is limited to 20 characters (to fit on the smallest labels).
  7. Select a category if appropriate. (Press the first letter of the name of the category. Use the down arrow to select the category. Press Enter to record the category and move to the next field.)
  8. Details are not required. Details only appear in Detailed Reports and on larger price labels.
  9. Enter Sell Prices if labels will be printed from this screen. Otherwise they can be entered later. (Sell Prices will be on price labels but not on buy-outright agreements.)
  10. Enter Buy Prices. (They will be printed on the buy-outright agreements but not on price labels. They will be displayed on sales invoices as 'Last Item Cost' when the item is added to the invoice):

  11. Change the quantity if necessary.
  12. 'Location' refers to the physical location where the item can be found (bin #, shelf ID, department, etc.).
  13. The program will have assigned a barcode and must not be changed. (There is an option in Program Setup on the Printers page for not printing barcodes on price labels.)
  14. If necessary, use the scroll bar to scroll right:

  15. The date the item was purchased (Date In) can be changed. (If several items are being entered for a date other than the current date, close the program, change the date setting in Windows and reopen the batch-enter screen and enter the items.)
  16. Ignore the rental reference.
  17. Pictures of items can be taken, stored on a drive (or website) and paths to the pictures can be entered then recalled at POS to verify the item's identity.
  18. Notes about items can be entered (for shop eyes only).
  19. When finished entering items, click on Process BO Settlement Now:

  20. On the New-Settlement screen, items purchased will be checked and can be unchecked.
  21. Select the Payment Method:

    Payment can be split between two methods.

  22. Click Save and Exit:

  23. The settlement screen will close. If an agreement and item list are needed, click on 'Print Agreement and Item List':

  24. Click on the printer icon to print the page:

  25. On the Batch-Enter screen, if sheet labels or tags are to be printed, select one of these options:

    Those options do not apply to thermal labels.

  26. Or select this option to print thermal labels:

    The settings on the Labels screen will dictate which labels will be printed.

  27. To print a number of labels equal to the number of items in inventory, check this:

    If that box is not checked, one label will be printed for the item even if the quantity is greater than 1.

  28. To limit labels to a number of rows to be printed, enter the number of the last line to be printed:

    (If 10 rows are used and a row greater than 10 had been clicked on, inventory records will be created and blank labels will be printed for the 'blank rows'. Avoid clicking on unused rows. If uncertain, enter the number of the last row to be printed.)

    Optional Actions

    • Click Save/Exit to save the entries and print labels later
    • Click 'Print Agreement and Item List' to save entries and print the agreement and list of items purchased. The agreement and item list will print on one page, if that option is checked in Program Setup on the Inventory page:

    • Click 'Settle Only' to open and process the sale, then pay the seller. (This needs to be done for every purchase.)
      • The total sale will appear in the Notes section.
      • Uncheck any item that is not to be purchased.
      • Enter Additions or Deductions, if any.
      • To the right of Payment 1, ignore the check number and select payment method. (If payment is by check, the check number offered will be used. Otherwise it will be ignored.)
      • Choose 'Save, Print, Exit' to save the transaction and print a buy outright agreement.
      • Choose 'Save and Exit' to save the transaction and not print an agreement.
    • Select one of the options for sheet labels, or
    • Click Thermal (lower right) to print thermal labels.

Buy Outright General Reports

The most important reports can be called by pressing Function Keys on the top of the keyboard:

  • F8: Items Entered Today
  • F9: Today's Sales Recap
  • F10: Today's Sales
  • F11: Today's Settlements

The buttons across the middle of the screen are handy for viewing data for the time periods shown on the buttons:

The 'Quick Links' (on the right) have useful one-click reports related to buy outright in the Clients, Disbursements, Inventory, Sales and Settlements work areas. For example these are the Quick Links for the Clients Work Area:

Some of the functions shown do pertain to consignment and not buy outright.


Buy Outright Inventory Reports

Specific inventory reports based upon Clients, Dates In, Last Sale, Price Range, Quantity and Categories can be defined and generated under Reports > Inventory on the Main Menu:

Select Inventory. To generate a report including buy-outright items only, check the box:

Settings on this screen tell BCSS which inventory items to include in the Report:

For example, to include only items 22 through 40 for Meryl Streep:

1. Check 'Quantity greater than 0'. (Only items in inventory will be included in the report. Sold items will not be included.)

2. Select 'Meryl Streep' from the Client drop-down menu.

3. Check 'Items # Range' and enter 22 in the From Field and 44 in the To Field. (These settings will not apply if the box is not checked.)

Sort Output

The content of the report may be sorted by any of these:

Print the Report

Selecting Print Detailed List...

...will display a print preview of items matching the search criteria with ID, Category, Original Price, Quantity, Discount Date, Date In, Description, Client, Current Price, Discount, Last-Sale Date and Barcode.

Selecting Print Brief List...

...will present ID, Description, Category, Client, Price, Quantity and Date In.

Selecting Bar Code Report...

...will present a list with scanable barcodes.

The report may be printed by pressing the printer icon (yellow arrow):


View the Report in the Main Table

Selecting View the Report

 displays items matching the search criteria in the Main Table.


Buy Outright Sales Reports

Specific sales reports (based upon layaways, sales on hold, bad checks, voids, credit memos, client, buyer, salesperson, payment method, category, location, invoice date, invoice total and inventory number) can be defined and generated under Reports > Sales on the Main Menu:

Select Sales.

Settings on this screen determine the information in the Report:

Shop Sold List

Pressing Shop Sold List (at the bottom of the Sales Report Screen) will present a report showing Item ID, Description, Category, Price, Quantity, Date Sold, Invoice # (and 'Sold By' in BCSS Diamond and Virtual) for each item sold for the current day (if no date filter is set). Click the printer icon at the top of the report window to print the report.

Consignments-Sold List

This report includes Item ID, Description, Category, Price, Quantity, Date Sold, Invoice # and Payment Method for consignments sold.

Buy-Sold List

This report includes Item ID, Description, Category, Original Price, Quantity, Sale Price, Buy Price and Profit for shop-owned items.

Sales Recap

Pressing the Sales Recap Button will present a list of sections (not shown) for Invoice List, Salesperson Recap (in BCSS Diamond and Virtual), Payment Recap and Shop Totals. Uncheck sections to be excluded from the Sales Recap Report. Press the Preview/Print Button to preview the report. Click the printer icon at the top of the report window to print the report.

These is the information displayed in each Recap. (Buyer and employee information appear in Diamond and Virtual only.)

  • Invoice List: Date, Invoice #, Buyer, Sale Amount, Tax, Sale Total, Pay Method
  • Salesperson Recap: Salesperson, # of Sales, Amount
  • Payment Recap: Type of Payment, # of Payments, Total
  • Shop Totals: Sales (before tax), Clients' %, Buy-Outright Cost, Employee's %, Other Payments, Promo Discounts, Profit/Loss, Buyer Fees, Tax(es) (split if 2), Non-Taxable Sales

Profit/Loss Breakdown

Profit/Loss Breakdown on the Sales Report Screen generates a list of sold items showing costs related to each item including client share, employee share, promotional discount, buy-outright share and retail cost with totals by client and grant totals. A net profit/loss appears last and takes bills paid (Disbursements WA) into account. On the sales report screen, check the Invoice-Date Box and enter a date range, then press Profit/Loss Breakdown.


Sales Recap 'Errors'

Account History is an explanation of a client's account balance. The person in charge of 'the books' at the store must have a thorough understanding of the concepts of accounting as they apply to the consignment/resale business.

Payment Recap is a total of recorded amounts received. The other sections of the Sales Recap are based on prices of items sold. Go through invoices for the period in question and look for differences between payments and prices.

Common Mistakes

  • Changing an employee ID
  • Assigning buy outrights to the House Account

Troubleshooting

Incorrect Starting Number

  1. Find the last item number for the client.
    1. Select the client in the main table.
    2. Click on Items at the bottom of the screen.

    3. Sort the ID column and locate the last item number.
  2. Open the New-Item Screen (F3).
  3. Enter an item, changing the Item Number to the next-available number for the client.
  4. Complete information about the item.
  5. Click Save and Exit, or click 'Save, Print a Thermal Label'.

    Either way, the item will be saved.

  6. Reopen the Batch-Enter screen for the client and confirm that first item # is correct.

Reversing Entries

To delete a buy-outright transaction, do a settlement for the items for zero payment and delete the items from inventory.

If consignments have been incorrectly entered as resale items, do a settlement for the items for zero payment, delete the items from inventory and reenter them as consignments.

Credit-Card Processing

Advantages of Accepting Credit-Card Payments

  • Accepting credit cards satisfies your customers' expectations. It's convenient, they don't have to carry cash and they can 'pay later'.
  • Credit-card processing adds professionalism to your store's image and increases sales.
  • Buyers have more purchasing power, effectively making more money available for shopping.
  • Accepting cards can reduce the amount of cash needed at the store.
  • Card purchases eliminate math errors in calculating change due.
  • Card processing can help to eliminate employee theft.
  • Credit cards speed the checkout process.
  • Your customers appreciate speedy service and share their experiences with others.

BCSS and Credit-Card Processing

Use any merchant account and credit-card processor you wish. BCSS does not limit your choices. If you need to change processors or banks later, we won't be standing in your way.

Just swipe the card and select the card type from a drop-down menu on the sales invoice. The amount of the sale is auto-entered.

The cash drawer will not pop open when credit card is selected as the payment method.


Share Credit-Card Costs with Clients

It's becoming a common practice to pass some or all of the cost of providing credit-card processing on to those who benefit from it - your patrons.

A percentage can be deducted from every settlement of credit-card purchases:

  • Any client can be permanently excluded.
  • The percentage only applies to credit-card sales.

Where allowed, a percentage can also be added to credit-card purchases.

Use these options to take in more than actual credit-card costs.

There is a 3rd option of a % to be deducted from every sale (credit card or not) before applying the consignor split. For example, if the % is 2% and the sale is $100, the store would take $2 then split the remaining $98.

These 3 options are available in a separate module for $19.95/mo and that too can be passed on to clients.

Call 888-427-5779 for more information, or send an email.

Disbursements

Things to Know about Checks

  • BCSS auto-prepares Check Disbursements if the Payment Method for Settlement is 'Check'.
  • Attempting to print a check for a cash disbursement or for a disbursement marked as Not Approved will generate an error message.
  • If a check is created but won't be printed, change the check's status to Not Approved so it cannot be printed and will not affect reports. (Select the check in the Disbursements Work Area and click 'Approved/Canceled'.)
  • For some printers, it may be a bit difficult to determine the correct row spacing settings to print 3 checks per page. A work-around is to turn off '3 Checks Per Page' in Program Setup and print 1 check (the first print position) at a time, printing one check, tearing it off and refeeding the remainder of the sheet of checks.

Cancel a Check

  1. Select the check from the List in the Disbursements Work Area.
  2. Select Edit Disbursement and select Not Approved, then OK.
  3. Canceled checks do consume a check number but do not affect store income.

Checks and Accounting

A cash disbursement is processed the same as a check but no check number is used and no check is printed.

Cash and check both decrease store income.


Buying Checks

Three checks per page is the most common choice because there's less paper waste. Have them prepared by your bank to include special security measures against fraud.

If not already done, go to File, Program Setup, General and select either one check per page or three.

Settlement Checks

Adjust Print Position on Checks before attempting to print checks.


Pay One Consignor by Check

When 'Check' is the payment method selected for a settlement, BCSS prepares a check for printing and lists it in the Disbursement Work Area.

To pay a consignor by check, after the settlement has been processed -

  1. Go to the Disbursement Work Area.
  2. Select the check to be printed from the table by clicking on it.
  3. Select Print Check from the Disbursements Work Area Menu (lower left).

  4. On the next screen (not shown), select a print position for the check (top, middle or bottom).
  5. Click the X in the upper-right corner of Check-Position Window to close the window.
  6. The print that will appear on the check is presented in a Print-Preview Window.
  7. If the information is correct, click the Printer Icon on the top menu:

  8. The next screen to appear is the Windows Print Setup screen.

    The settings should be:

    • Name: The correct printer name should appear here.
    • Size: Letter
    • Page range: Current page
    • Orientation: Portrait (Never 'As Preview')
    • Number of copies: 1
  9. When settings are correct, load a blank sheet of paper in the printer and press OK to start printing.
  10. Place the printed page over a check page, square them and hold them up to the light to verify that the print will appear in the correct positions on the check.
  11. If the print position is incorrect, follow the procedures for Adjusting Print Position on Checks.
  12. If the print positions are correct repeat the printing of the check but load the check into the printer.

Pay Multiple Clients by Check

NOTE: To print multiple checks at the same time, first go to File, Program Setup, General tab and turn Print Preview off.

When 'Check' is the payment method selected for settlements, BCSS prepares a check for each settlement for printing and lists the checks in the Disbursement Work Area.

How to Print Several Checks at Once

  1. Select Batch Settle from the Settlements Work-Area Menu:

    Sales eligible for settlement will be listed. Uncheck those that are not to be processed and make sure 'Check' is the Payment Method selected.

    (Please remember that settlements for less than the amount stipulated in Program Setup will not appear in the list.)

  2. Place enough checks in the printer's tray.
  3. Click on Print Checks:

Checks should start to print. All checks marked for printing will be printed so make sure there are enough checks in the printer tray.


Manage Bad Checks

  • Editing an Invoice Record to note a bad check flags the Inventory Record and the Buyer's Record.
  • Reports can include bad checks only.

Record a Bad Check

Select Sales in the Work-Areas Menu.

Select a Sale in the List of Sales then select View Sale from the Sales Menu (lower left).

The View-Sale Screen has a button labeled 'Bad Check'.

If payment was made by check, pressing this button will draw a line through all amounts paid by check on the invoice.

If payment was not made by check, this button has no effect.

Bad-check sales are not included in sales reports unless the 'Report should only include bad checks' filter is checked. They do appear if 'View All' or one of the time periods (Today, Week, Month, etc.) in the Time Bar is selected.

If a Buyer's check is bad, the invoice number will appear on the General Tab in the Consignor's Details Area. Select the Consignor from the list and look to the lower right -

In the Disbursement Work Area

Click on a Disbursement to select it.

Click Approved/Canceled...

...to toggle the status of a check between Approved and Canceled.

The status of the check is shown in the Details Area next to Status:

Canceled checks do consume a check number but do not affect store income.

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 Consignor 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.

Check Setup

Go to File, Program Setup, General Tab and select either one check per page or three.

Print a check on a blank sheet of paper and hold it up to the light with a check behind to make sure the print lines up with the check's fields.

The Top and Left Margins and Row Space may need to be changed (on the New-Disbursement Screen) to print correctly. The default settings of (Left) 350, (Top) 850, and (Row) 13 are correct for most ink printers.


Prepare a New Check for Printing

  1. Select New Disbursement from the Disbursements Work-Area Menu.
  2. Complete the fields on the New-Disbursement Window:

    The next available check number and current date are auto-entered and may be changed. The starting check # is 1000.

  3. Enter the payee's name and the amount of the payment. Other information is optional.
  4. Select Bill, Cash Disbursement or 'Other' for the type of payment. ('Other' includes settlements and commission payments.)
  5. When entries are complete, press OK.

    The new check will now be listed in the Disbursements Work Area.

  6. Select the check.
  7. Select the print position for the check (Top, Middle or Bottom).
  8. Click OK to print.

When printing a check for the first time (or when printing for the first time after the program has been uninstalled and reinstalled), print on a plain piece of paper to see where the print would have been placed on the actual check, then adjust the margin settings to place the print in the correct position on the check.



Print the Check

  1. Select a check from the List in the Disbursements Work Area.
  2. Select Print Checks in the Disbursements Work Area Menu (lower left).
  3. A Check Layout window will appear. Select which check position to print, Top, Middle or Bottom.
  4. View the check on the Print-Preview Screen. If it appears to be correct, click the print button.


    Adjust Print Position on Checks

    It may be necessary to adjust top and left margins and row spacing to place print on checks in the proper positions. Align print for the first check. Alignment for checks 2 and 3 (on 3-check-per-page) should be ok.

    The settings for margins and row spacing are located on the Edit-Disbursement and New-Disbursement screens.

    Follow these procedures for determining correct Print-Position Settings:

    1. If there are no checks to print, use New Disbursement in the Disbursements Menu to create 3 fictitious checks. (They can be marked as 'Not Approved' later or BCSS may be reinstalled later to erase test data.)
    2. Choose the checks in the Disbursements Work Area. (Check the status of the check at the bottom of the screen. Status must be 'Approved'. If the check is shown as 'Canceled', it will not print. Either choose an Approved Check or click the Approved/Canceled option in the Disbursements Menu to change the status to Approved.)
    3. Select 'Print Check' from the Disbursements Menu.
    4. On the Check Position Screen, 'Top' should be selected by default. Select 'Top' if it is not selected.
    5. Click on the 'Close-Window X' in the upper right corner of the Check Position Screen.
    6. View the check on the Print-Preview Screen. If it appears to be correct, place one blank sheet of paper in the printer. (Feed one sheet at a time to avoid misfeeds.)
    7. Click the print button.

    8. Place the printed sheet over a check and square the 2 sheets.
    9. Hold them up to the light and observe where print would have been placed on the sheet of checks.
    10. To adjust print position, double click on the check record to open its Edit Screen. Settings for Margin and Row Space appear on the right:

      Large changes in the values for top and left margin are necessary to see significant changes in print position.

      It may be necessary to use negative values to achieve correct position. Top or Left Values could be from -500 to 2500. Row space could be from 5 to 20.

      • If the print position is too high, increase the Top-Margin Setting, or vice versa.
      • If the print position is too far to the right, increase the Left-Margin Setting, or vice versa.
      • Use the Row-Space Setting to increase or decrease the distance between lines.

    When the correct settings have been determined, record the settings (off of the computer) for future reference.


Disbursement Reports

Can't Print a Disbursement Report- error: bcoptions.dbf is not a table

  1. Close the program.
  2. Go to C:\BCSS\blank db.
  3. Copy these files to the clipboard: bcoptions.cdx and bcoptions.dbf.
  4. Paste those files in C:\BCSS, replacing the existing files.
  5. Reopen the program and try again.

There are 3 ways to generate Disbursement Reports:

  • Quick Links
  • Details Area - Select a Disbursement in the Disbursement Work Area
  • Filtered (Defined) Reports

Quick Links Reports

BCSS is divided into Work Areas. They are:

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

Cash Day/Week - View cash disbursements for today or the past 7 days

Cash (table) - View cash disbursements in the Main Table.

Checks Day/Week - View checks for today or the past 7 days.

Checks - View checks in the Main Table.

Disbursements Day/Week - View disbursements for today or the past 7 days.


Time Filters

Click on these buttons:

time filters

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.


One Disbursement Information

Select a disbursement from the Main Table and view information about the disbursement in the Details Area at the bottom of the screen:


Filtered Reports

A report 'filter' filters out unwanted information in the report.

For example, by setting the filter 'date range' to a specific time period, all data not falling within the specified range will be omitted from the report.

Disbursement Reports Using Filters

  1. In BCSS on the Main Menu click on Reports then click on Disbursements.
  2. Reports can include all disbursements or only those Approved or Not Approved.
  3. Select options and make settings on screen to define which disbursements are to appear in the report. (Note that the boxes for Payment Date and Payment must be checked for ranges to apply.)
  4. The report can be for all consignors or a selected consignor.
  5. The report can be sorted by Date or Payee.
  6. Select Print the Report to view a print preview with the option to print.
  7. Select View the Report to view the report in the BCSS Main Table.

Settlement Checks

Test Print allows for settlements to be printed without finalizing them, leaving the option to finalize them later and print checks. (Once settlements have been finalized, checks must be printed one at a time from the Disbursements Work Area.)

Checks Not Delivered

Occasionally a settlement check is not delivered. The settlement can be voided and the disbursement canceled - but the items that were settled won't show up in the consignor's account. Here's what to do:

In BCSS the items were probably moved to Deleted Items. To add them back to the 'to-be-settled list', from the Client Work Area, select a consignor and click on Undelete Items on the right. A list of items for the selected consignor will be presented. Check the items to be restored then select Record/Exit. The items will now appear on the New-Settlement Screen.

Pay by Check

When a settlement is finalized with 'Check' as the payment method, BCSS saves the settlement, prepares a check for printing and lists it in the Disbursement Work Area.

To pay a consignor by check, after the settlement has been processed -

  1. Go to the Disbursement Work Area.
  2. Select the check to be printed from the table by clicking on it.
  3. Select Print Check from the Disbursements Work Area Menu (lower left).

  4. On the next screen (not shown), select a print position for the check (top, middle or bottom).
  5. Click the X in the upper-right corner of Check-Position Window to close the window.
  6. The print that will appear on the check is presented in a Print-Preview Window.
  7. If the information is correct, click the Printer Icon on the top menu:

  8. The next screen to appear is the Windows Print Setup screen.

    The settings should be:

    • Name: The correct printer name should appear here.
    • Size: Letter
    • Page range: Current page
    • Orientation: Portrait (Never 'As Preview')
    • Number of copies: 1
  9. When settings are correct, load a blank sheet of paper in the printer and press OK to start printing.
  10. Place the printed page over a check page, square them and hold them up to the light to verify that the print will appear in the correct positions on the check.
  11. If the print position is incorrect, follow the procedures for Adjusting Print Position on Checks.
  12. If the print positions are correct repeat the printing of the check but load the sheet of checks into the printer.

To pay a consignor by check for a settlement not yet finalized -

  1. In the Settlements Work Area, select Batch or Aged-Batch Settlements.
  2. Click on 'Check None' to uncheck all accounts.
  3. Check the account to be settled.
  4. Make any other necessary adjustments (total amount, date, deductions, check #).
  5. Verify that Payment Method is 'Check'.
  6. Click Print Settlements - Settlements are created and will automatically be sent to the printer. DO NOT CLOSE THE WINDOW.
  7. Verify correctness. If any changes need to be made, delete the settlement, void the disbursement and manually re-create the settlement using 'Settle New' (F7).
  8. Click 'Print Checks'.

All checks will be sent to the printer. It might be advisable to only feed one sheet of checks at a time to assure proper printing and avoid issues with paper jams, out-of-ink runs, etc.

Here's another way to finalize the settlement and print the check:

  1. In the Clients Work Area, select the consignor to be settled.
  2. Press F7 or click 'Settle New F7' (top right).
  3. Make any other necessary adjustments (total amount, date, additions, deductions, check #) and/or notes.
  4. Verify that Payment Method is 'Check'.
  5. Change the check # if necessary.
  6. Click 'Save, Print, Exit' to save the settlement, or
  7. Click 'Save and Exit' to just save the settlement.
  8. Go to the Disbursements Work Area.
  9. Click on 'Today':

  10. Select the check.
  11. At the lower left, click on Print Check.
  12. Press View All to display all records again.


Pay Multiple Clients by Check

  1. Select Aged-Batch Settle or Batch Settle from the Settlements Work-Area Menu:

    Sales eligible for settlement will be listed. Uncheck those that are not to be processed and make sure 'Check' is the Payment Method selected.

    (Settlements for less than the amount stipulated in Program Setup will not appear in the list.)

  2. Place enough checks in the printer tray.
  3. Click on Print Checks:

    Checks should start to print. (It might be advisable to load one sheet at a time to control printing and monitor for print errors.)

Item and Space Rental

Item Rental

Any item added to or in inventory can be designated as a 'rental':

  • When entering an item check 'Rental'.
  • When using consignment batch enter, check 'Rental'.
  • To change an item to a rental, delete the record and reenter the item as a rental.

Client items could be 'rented out' (with permission) but mostly rentals will be shop-owned items with 100% of the proceeds credited to the shop account.

Process a Rental-Item Purchase

Press F5 to start the procedure for renting an item.

Select a Buyer from the List or press 'Close Without Choosing' to enter a Rental Sale without selecting a Buyer.

Click on Select from Item List

Rental Items are listed with a pink background for easier locating.

Select the Rental Item and press OK.

On the Invoice, if another item is added, the background color of Rental Item's line will be pink - a reminder to enter the Out/Return Dates. The Out Date is usually the current date and is auto-filled. The Return Date is the date the Item is to be returned. Both dates may be changed by typing new values or by using the drop-down calendars.

Complete the Invoice as for a New Sale.


Process Rental Returns

Select Rentals on the Main Menu.

Select Process Returns to view a list of Rentals that are currently out.

Check the items being returned and click OK to clear the Rental Record.

Inventory quantities will increase for the items returned.

Other selections in the Rental Menu allow reports that show Inventory or Sales Records for Rental items returned, not returned or past due.


Space Rental in Malls and Markets

To enlarge the video screen, start this video on 'Space Rental'...

...and click on the icon:

In the software vendors are the same as 'clients' (or consignors), each with a record and a Client % (the amount of each sale to be paid to the vendor). If a vendor is to receive 100% of sales proceeds, enter 1 for Client %. Enter .8 for 80%, etc. Enter 0 for sales proceeds that are to be credited to the shop account.

Settle for $0 - Process settlements for $0 to process mall charges that are equal to or more than the balance due.

With the Diamond and Virtual editions:

  • Track spaces for rent, renters, rent amounts, due dates and reservations.
  • Print price labels for vendors and mall-owned merchandise.
  • Process vendor sales.
  • Deduct rent from sales proceeds.
  • Share in vendor sales at variable percentages.
  • Add customized fees.
  • Pass credit-card charges on to vendors and purchasers. (paid option)
  • Download inventory that vendors entered online.
  • Produce several reports including rent shortages.

With the Virtual edition, vendors can view their account information online and add inventory online (to be downloaded to the shop computer). Mall operators routinely charge a small monthly fee for the feature, generating additional income beyond the $25/month server rental.

Vendor records are created the same way client or consignor records are created. (video)

Setup

Create a record for every rental unit.

  1. In BCSS click on File (upper left) then Program Setup then click on the Mall tab.
  2. Check the options at the top of the page that apply.
    • Deduct rent from settlements: Rent due will be auto-deducted when a settlement is processed. The amount set will be retained and can be edited.
    • Deduct other charges from settlements: Edit a vendor record and click on the Current-Charges tab to record other charges. Some types of charges are suggested on that screen. They can be changed and other types of charges can be entered. These are one-time fees and must be reset every month. For recurring charges, increase the rent.
    • Deduct Rent from batch settlements: Same as above but in 'batch'.
    • Rent is due monthly or weekly: Enter the appropriate amount in the table under 'Rent'. The program will add the amounts due to the Current-Charges Screen on the Edit-Client-Record Screen.
  3. On the first row under Name, enter a name for a space (like Booth 11).
  4. The Description is optional and can be any combination of letters and numbers.
  5. Under Occupant use the drop-down menu to select a client. (If no names appear, create a Client Record for every floor-space rentor and return here.)
  6. Enter the rental amount (under Rent) and due date (under Last Rent Paid - the date when rent was paid last, or the date to start paying from if the client has not paid previously).
  7. For 'Waiting' don't make an entry here, but edit the client's record and select the space the client wants (using the drop-down menu for 'Requested Space'). The client's name will appear in the Waiting column. If more than one client is waiting for the same space, the oldest request will be displayed first.
  8. Click Save/Exit to save entries and exit Program Setup.
  9. Edit a Client Record and click on the Current-Charges tab.
  10. If rent is due, the amount will appear here. If no rent is due, 'No Rent Due' will appear.
  11. Check the 'Pay This' box and press Pay Selected. (Close the Buyer List if it appears.)
  12. A Client-Credit-Sale Invoice will be presented.
  13. Collect payment from the client and select the pay method on the right.
    • If a credit card is being used, the amount due will be auto-entered as the amount paid.
    • For other forms of payment, the amount tendered will not be auto-entered.
  14. Click Save to record the sale, or click 'Save, Preview, Print' to view/print a receipt and save the sale.

Customized Charges

When adding or editing a client record, click on 'Current Charges' to view 7 predefined types of charges (Advertising, Consultation, Credit-Card Fees, Delivery/Pickup, Preparation, Rent and Taxes).

To add another charge, click in the Name field on the next-available line and type the name of the charge. Add a description if needed

These will always appear, plus a set of blank lines below. Rents are added to this list automatically, including past due if appropriate.

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. Either way, enter an amount. Click OK. 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.

To collect payment, check appropriate boxes. Click on 'Pay Selected'.

A fixed percentage can be set in Program Setup > Sales to be deducted from credit-card sales. Vendors would pay the (small) percentage on purchases made using credit cards but not on other payment methods (like cash, check, PayPal...). A separate percentage can be set to be added to credit-card sales so the person using the credit card pays the added fee. A third option allows for a set percentage or dollar amount to be deducted from every sale before applying the sales-split %. All 3 options are bundled in an optional module that requires activation ($19.95/mo). If your monthly sales are $10,000 and the percentage is 3%, that's an additional $300 - $19.95 in revenue.

Vendor online access to account information requires a username and password assigned by the mall manager. The information can be viewed on any device including cell phones. Malls are charging $2-$5 per month. Online access is also an optional module ($25/mo). One mall has 500 vendors with most of them paying $5 per month so this too can be a great source of additional income. No additional software functionality is needed. Just add the monthly fee to the rent total.

Pay Rent from Sales

Note: Rents are not collected in advance. They are deducted from sales for the prior month's rent.

If rent is to be collected in advance for a new renter, set the last rent date at today on the Mall tab of program setup. Collect rent. The program will collect rent again in 1 month.

Collect Rent When There Are No Sales

  1. Open the New-Sale Screen.
  2. Click on Unlisted Item.
  3. Enter a Description of 'rent collection'.
  4. Leave price set at zero.
  5. Select the Vendor under Client ID.
  6. Select Cash as the Payment Method.
  7. Click Save.
  8. Close the New-Sale Screen.
  9. Go to the Client Work Area.
  10. Select the client's record.
  11. Click on New Settlement in the lower-left menu.
  12. Enter the amount of the rent as a positive number in the Deduction field.
  13. Select Store Credit as the Payment Method. (Otherwise the rent due is cleared with no outstanding record of the amount due.)

The Settlement will process as entered, recording a negative settlement and a negative payment against the zero-price item.

Waiting List

On the General tab of the Consignor Edit window, specify which floor space a Consignor would like to have.

In Program Setup on the Mall tab, the name of the person waiting for the space will be displayed in the Waiting column. If more than one consignor is waiting for the same space, the oldest request will be displayed first.

Quickbooks

(This feature is available in BCSS Deluxe, Diamond and Virtual.)

  QuickBooks Integration with BCSS (Virtual edition) allows for the direct transfer of data from BCSS to QuickBooks.

  New QuickBooks Format If you have been using the QuickBooks Export Feature in BCSS and now see discrepancies, in BCSS, click on File then Program Setup then General tab and change the QuickBooks setting to '2000+'.


Important: QuickBooks doesn't know about consignment settlements for credit or cash. If you use QuickBooks with BCSS, always issue settlement checks, not cash or credit, so QuickBooks and BCSS will always agree. This is a limitation of QuickBooks that we can't remedy. A work around would be to generate a check then pay cash using the check as tender.

  • BCSS exports vendor names from check records.
  • BCSS will only export records for checks, employees and sales once. If one of these records has been deleted from QuickBooks, it cannot be exported again from BCSS. Save all exported files.
  • First and last name must be used in the name fields for Sales and Checks, otherwise QuickBooks will only give an unhelpful error message and not import the record. 'Cash Sale' (or any entry like 'Co.' or 'Inc.') may be used.
  • If apostrophes (') and quotes (") and tabs are used in BCSS (in inventory descriptions, for example), they will not be displayed in BCSS or QuickBooks.

Exporting Data in QuickBooks Format (.iif)

BCSS records are exported to a data file then imported into QuickBooks. The columns of records in BCSS for Clients, Vendors, Employees, Sales, Inventory and Checks are separated in the output data file by commas, so this type of file is commonly called a 'comma-separated' or 'comma-delimited' file with file names ending in .csv. QuickBooks data-file names end in .iif (Intuit Interface Format).

First, set up a 'company file' in QuickBooks before importing data. This creates a 'Chart of Accounts' and only needs to be done once. (See QuickBooks Help for details and for setting preferences.)

When BCSS output is imported into QuickBooks, no changes are made to existing accounts, and new accounts, if any, are added.

Use the 'Make QuickBooks Accounts' function (BCSS Main Menu, Utilities) to make the accounts in QuickBooks that BCSS will add data to. This function creates a file to be used to import data into QuickBooks as described below.

  • Accounts Receivable
  • Bills
  • Checking
  • Commissions
  • Consignor Payable
  • Inventory Asset
  • Sales: Consignment Sales
  • Sales: Discounts Given
  • Sales: Retail Sales
  • Sales: Tax Payable
  • Supplies
  • Undeposited Funds
  • Other Expenses

Exporting All Data to QuickBooks

To transfer all records for Clients, Vendors, Employees, Sales, Inventory and Checks to QuickBooks (for the first time, or to replace a corrupted QuickBooks file) -

  • In BCSS, on the General tab of Program Setup, check 'All Data' to export all records to QuickBooks once, then uncheck this option to avoid duplicate records.
  • Choose 'Export All' under the Main Menu/Utilities/QuickBooks.
  • Give the file a descriptive useful name like 'BCSS-data-12-31-16.iif' and note the location of the file on your PC.

Open QuickBooks and import the file (File/Import/iif file).


Exporting Select Data for QuickBooks

The program exports records since the last export each time.

If records that have been exported need to be exported again:

  • In Program Setup > General, check All Data.
  • Save/Exit
  • Perform the export (under Utilities).
  • If only some of the records are to be imported into QuickBooks, open the .iif file in a word processor (Notepad, Wordpad), remove the unwanted data, save the file and import.
  • In Program Setup > General, remove the check in 'All Data'.
  • Save/Exit

The next data exported from BCSS will be from the last record exported.


Updating All QuickBooks Records

Make sure the option mentioned above is NOT checked (to avoid duplicate records in QuickBooks).

Be sure to export vendors first if there are new ones.

  • Choose Export All under the Main Menu/Utilities/QuickBooks.
  • Give the file a descriptive useful name like 'BCSS-data-12-31-16.iif' and note the location of the file on your PC.

Open QuickBooks and import the file (File/Import/iif file).

BCSS will export all vendor and inventory records. QuickBooks will update changed records and add new ones.

The simple way to avoid having to remember exporting vendors first is to export all data daily (or however often needed).


Updating Select QuickBooks Records

Records for vendors, Employees, sales, inventory or checks may be updated separately.

  • Choose the information to be exported (Main Menu/Utilities/QuickBooks).
  • Give the file a descriptive useful name like 'BCSS-data-7-31-16.iif' and note the location of the file on your PC.
  • Open QuickBooks and import the file (File/Import/iif file).

Be sure to export the vendor list first if there are new entries.


General Considerations

QuickBooks will not accept a check unless the vendor payee is already on file, so to write a check for a new vendor, export the vendor list first. Otherwise, QuickBooks will give an error message and not import the record. This is most important because checks and sales can only be exported once from BCSS.

Be sure to record both names before exporting. It is possible to edit the iif file and insert a last name if it has been left out. This requires just a little in the way of computer skill. QuickBooks will accept 'Cash Sale' as first and last name. For vendor company names, add Co. or Inc. if necessary.

When exporting to QuickBooks, to assure there will never be a sale of non-existent inventory, a check for a payee not in the QuickBooks vendor list, or a transaction for which QuickBooks does not have an account, export files in this order: Accounts - Inventory - Sales - Vendors - Disbursements - Employees

QuickBooks does not recognize cash withdrawals from store funds. QuickBooks requires that checks be written for all disbursements so BCSS only exports check disbursements to QuickBooks. This will cause a discrepancy between what BCSS says about current funds and what QuickBooks says. We strongly recommend following the QuickBooks discipline of using checks for everything. This means no Settlements for credit.

The one exception to the checks-only rule is that QuickBooks will accept a credit memo where the Buyer is given cash refund. BCSS does report these to QuickBooks, however, BCSS recognizes the difference between a partial refund where the Buyer keeps the item and a full refund where the Buyer returns the item. As far as QuickBooks is concerned, all credit memos are for returned items.

BCSS allows a number of disbursement methods but QuickBooks does not know about Settlements for credit or cash.

Sales documents must have a buyer. The buyer can be 'Cash Sale', but it cannot be Sale or Cash. In QuickBooks, log in as administrator. Open the Customers area, click on Transactions and choose various ways to look at sales.


BCSS will not export voided invoices.

QuickBooks will accept inventory items from BCSS but it will not accept a quantity on hand. That must be input manually. BCSS does pass the quantity for each item as a custom field. To view custom fields for a QuickBooks item, first right-select the item and choose edit from the list. Then select custom fields. On the pop-up screen, select define fields. This generates another popup with a column of five fields. Put a check in the top check box. In the top label window, enter quantity and click OK. The quantity for this item is viewable but the same number for quantity needs to be put in the place where QuickBooks actually expects to find quantities in the item record.

QuickBooks does not know about Consignor or Buyer ID's so BCSS provides a custom field option for that as well.

Right click on the Consignor or Buyer Record. Choose edit. The rest is much the same.


Accounts Payable, Accounts Receivable, Cost of Goods Sold

BCSS does export Cost of Goods and Accounts Receivable information. It exports Undeposited Funds and Bank information (which would be Revenue accounts). It does not export Accounts Payable. There is a point where BCSS doesn't translate well to QB because QB doesn't understand consignment. It is a retail tool. Clients, for instance are exported as Vendors.

But BCSS does export a balanced set of accounts. It probably takes some data massage in QB to get the data to look right in a balance sheet.

The items.iif file has a column for cost. QuickBooks uses that for Cost of Goods Sold.

Integration with Consignment Software

BCSS Virtual is integrated with QuickBooks. (The program accesses QuickBooks DLL's (Dynamic Link Libraries) and submits date to the QuickBooks database via the links.)

According to Intuit upgrading to version 2014 isn't necessary and because new versions are 'backwards compatible', all versions are compatible with this integration.

Unlike other programs, there is no additional charge for this feature.


Windows may keep QuickBooks running in the background even though QuickBooks may have been closed.

  1. After a BCSS export without QuickBooks open, it will be necessary to terminate QuickbooksW32.exe in Task Manager > Processes. Otherwise QuickBooks will warn that external software is interacting with the company file when that is clearly not so. Here's how:
    • Right click on the taskbar.
    • Select Start Task Manager.
    • Click on the Processes tab.
    • Sort the list if necessary (by clicking on 'Image Name').
    • Right click on Quickbooks@32.exe.
    • Click on End Process.
    • Close the Task-Manager window.

Exporting from Consignment Software to QuickBooks for the First Time

Before starting an export session for the first time:

  1. With QuickBooks closed, download and install the QuickBooks Runtime Module: QBFC13_0Installer.exe.
  2. Read Only: Change the company file from 'read only' to 'read write' (to allow changes to be made by the consignment software).
    1. Find the Company Files Folder (Windows 10/8/7/Vista: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files or XP: C:\Documents and Settings\All Users\(Shared) Documents\Intuit\QuickBooks\Company Files)
    2. Right click on the folder.
    3. Select Properties.
    4. Go to the General tab if not already on it.
    5. Click on the Read-Only box until it is empty.
    6. Click OK.
  3. Create a New User in QuickBooks:
    1. In QuickBooks go to Company > Setup Users and Passwords > Setup User.
    2. The username is bcss (lower case).
    3. Answer 'No' to create a password. (There is no password.)
    4. Click next to access User Access Control.
      • BCSS doesn't require access to all areas of QuickBooks, but if the BCSS login is to be used for QuickBooks access, select 'All Areas of QuickBooks'. Otherwise choose Selected Areas of QuickBooks.
    5. Click next.
      • The consignment software should have Full access to all areas except Time Tracking (no access), Payroll and Employees (create transactions only), Sensitive Accounting Activities (no access), Sensitive Financial Reporting (no access).
    6. Click Finish.
    7. Leave QuickBooks open.

BCSS Setup

  1. In BCSS > Program Setup > General tab enter the company filename.
  2. Save and Exit.
  3. In BCSS under Utilities (upper right in the program) click on Connect to QuickBooks. This window should appear:

    • BCSS is signed, but QuickBooks doesn't find a certificate. Allow access even if QuickBooks is closed.
  4. Click Continue.

Connecting BCSS to QuickBooks

In BCSS under Utilities (upper right in the program) click on 'Connect to QuickBooks'.

Four progress prompts will appear:

  • QuickbooksFC Object Created
  • Connection Open
  • Open Company File Attempt 1 (BCSS will try 3 times if necessary.)
  • All Processes Successful

In BCSS under Utilities click on 'Export All'.

The last step (opening the company file) can take 2 or 3 minutes as QuickBooks and BCSS 'handshake'. (Tech support has no control over the time it takes Windows to complete this step.)

If this message appears, go back over the instructions above to make sure QuickBooks is installed and correctly configured:

If the handshake is successful, a message will appear confirming 'All Processes Successful'.

It will also be necessary to close BCSS and reopen it.


Troubleshooting

Read-Only File: By default Quickbooks creates the company file as 'read only'. Follow these instructions.

Incorrect Data: The 'quick fix' for incorrect data is to create a new company file in QuickBooks, check 'All Data' in BCSS Program Setup (General tab) and import the data again. (Uncheck 'All Data' in BCSS to transfer only new data in future transfers.)

Retail

To enlarge the video screen, start this video on 'Sheet-Label Setup'...

...and click on the icon:

Retail Accounts In BCSS

'Retail' in BCSS is the buying and reselling of merchandise acquired from businesses. (Buying and reselling merchandise acquired from individuals is 'resale' or 'buy outright.)

All activity related to retail takes place is the 'Shop Account' or 'House Account'. (Multiple house accounts can be used - one for each source of merchandise.)

Another type of 'house account' is the 'Transfer Account' which receives ownership of unsold consignments (if the Transfer Account and automatic transfers are activated and the disposal option in the client record is 'Transfer to House'). The Transfer Account should not be used for retail.

Other types of inventory with no cost basis (like donations to the shop) can be entered in the Transfer Account. All sales proceeds are generally subject to income tax.

For retail items, BCSS records buy and sell prices, computes the difference for sold items and reports the differences as profit or loss.

Retail House Account

For our purposes 'retail inventory' is merchandise purchased from businesses.

To enter retail inventory, a House Account must exist. To create one:

  1. Press F2 or click on New Client.
  2. If numbers are used for Client ID, enter the number that appears (on the right) for 'Internal ID'.
  3. If letters are used for Client ID, keep it short (for report columns and price labels). One letter would suffice.
  4. Check 'This Is a House Account' and note that the Client % changed to 0%. (All sales proceeds will go the House Account.)
  5. Click on Save/Exit. (Do not attempt to enter 'Buys' or 'Consignments' from this screen.)

Retail Inventory

It wouldn't be necessary to create client records for suppliers. It may be sufficient to place supplier information in the Details field of the item record then find the item record by scanning a barcode in the Inventory Work Area or by using the key-press search function below the list of items in the Inventory Work Area.

To add retail inventory:

  1. Select the House Account from the Clients Work Area table.
  2. In the lower-left menu chose Batch Retail. (Resize the screen if needed. Tech support can remove columns from this screen. A service fee would apply.)
  3. Enter up to 20 characters for a Description and press Enter.
  4. Press the first letter of the category name and use the mouse or down arrow to select the category then press Enter.
  5. Enter up to 100 characters for Details and press Enter, or just press Enter to skip the field.
  6. Enter the Selling Price and Retail Cost (no dollar signs).
  7. Change the Quantity, if appropriate.
  8. A 'Path to Picture' and 'Notes' can be typed in (or added later).
  9. With 'Label Quantity = Item Quantity' checked, multiple labels for any item will be printed.
  10. If sheet labels are to be printed, select on of these five options:

  11. If thermal labels are to be printed, select Thermal.
  12. If no labels are to be printed, click Save to save entries and close the screen. (Labels can be printed later.)

BCSS supports the use of two thermal label printers (or the Dymo Twin Turbo) - to avoid tag having to change labels/tags in the printer for different types of merchandise.

To view items entered:

  1. Go to the Inventory Work Area and click on Today:

  2. ...or click on Today Entered or press F8.
  3. ...or create an inventory report using today's date for the 'Date-In Range'.
  4. ...or select the House Account in the Clients Work Area and click on 'Items' at the bottom.

Retail Sales

If a retail item has been assigned to a category, that category can be included in promotional sales. (For some period of time, all items in category xxx will be discounted by xx%.)

Retail sales are generally taxable but local jurisdictions allow some merchandise (like clothing) to be sold tax-free or tax-free below a stipulated amount. Create categories, configure taxes and assign the categories to items.

With Diamond and Virtual editions, employees can be paid commissions and they can be denied or allowed access to any data and program functions (like voiding sales and discounting at POS). Each employee can have a 'till' that can be audited at any time.

To sell a retail item:

  1. Select the item in the Inventory Work Area and press 'Item to Invoice', or
  2. Press F6 to open the new-sale screen. (Adjust if necessary.) 'Cash Sale' will be listed as the name purchasers who don't wish to provide their personal information. With Diamond and Virtual, information entered here will be recorded in the Buyers Work Area.
    • The cursor will be in the bar-code field ready for a scan. Scan a barcode that was created by the program. (Barcodes not created by the program won't work.)
    • ...or enter the Item ID,
    • ...or enter an Unlisted Item (and choose the House Account for the Client ID),
    • ...or select an item from the dropdown menu.
  3. If a picture of the item was saved and assigned to the item, click on 'View Item Picture' to view it.
  4. The cost of the item will appear in 'Last Item Cost'.
  5. Under 'Enter Payments Below' if the payment is made in cash, leave 'Cash' as the payment method and enter the amount tendered in the field named 'Enter amount 1 here'. Change Due will appear at the bottom of the page.
  6. For payments other than cash, click the down arrow to the right of 'Cash' and select the method of payment. If a credit-card option is chosen, the amount of the sale will be entered as the amount paid and can be changed if necessary.
  7. If the sale is a Layaway, check the option at the bottom of the page and complete the payment schedule in the fields below 'Enter Payments Below'.
  8. For each item, Tax % may be changed and a '% Off' can be entered in decimal format.
  9. The entire invoice can be made tax free by checking 'Non-Taxable' (and optionally entering the buyer's 'Reseller Tax ID').
  10. For the entire invoice, discounts can be entered as dollar or percentage amounts.
  11. If credit-card charges are being passed to purchasers, the amount of the credit-card charge will appear at the bottom of the page.
  12. After all entries have been made, click Save to save the sale and prepare a new sale screen or choose 'Save, Preview, Print' to save the sale and print a receipt.

A sale can be put on hold indefinitely by clicking on 'Put Sale on Hold' and will appear in the Sales Work Area with a pink background.

A sale can be put on hold temporarily by clicking on Invoice 2 (top of the page) then returning to Invoice 1 when that purchaser returns to checkout.

Because invoices can be placed on hold temporarily, the 'red X' in the upper-right corner has been disabled to avoid losing sales on hold. Use 'Terminate Session' to close the invoice screen.


Retail Reports

Any list of information is a 'report'. There are several ways to create, view and print lists (reports) in the program:

  1. Select the House Account in the Clients Work Area and click on Items at the bottom. An item record can be selected then edited by clicking on Edit Item in the lower-left menu. The selected item can be deleted. If attempted a warning message will appear. Click OK to delete or cancel to not delete.
  2. Click on the blue Reports button at the top then select Inventory. Select House Account for the Client and set any parameters on the page to define which data should appear in the report.
  3. Reports can be generated for one or more House Accounts by clicking on Clients on the Reports screen and setting parameters there. Check 'House Accounts Only'. Reports will include House Account Names, # of Items, Balance, Dates Entered, Sales and Settlements.
  4. Sales Reports can be created using the Sales-Report page on the Reports screen.Select the House Account and set search parameters.

Troubleshooting

Barcodes Missing in current versions of the software are generally no longer an issue. The program assigns a barcode as each item is entered into inventory. Duplicate and missing barcodes might only occur now when barcodes are manually entered or edited, which should never be done.

Wrong Account can be corrected by:

  1. For a few items, delete the items from inventory and reenter them.
  2. For several items, export inventory records to a spreadsheet, correct the Client ID for the incorrect items, enter the correct Internal ID then import all inventory records. The items will be removed from the incorrect account and added to the correct account.

Duplicate ID or Incorrect Starting #

The 'next Client ID #' is stored in the Windows Registry. Windows can sometimes lose track of the number. Also, if letters and numbers are used in Client IDs (not advisable) the program will lose track of the next available number. Sort the ID column in the Clients Work Area and observe the last-used number. Open the new-client screen and enter the next number in sequence for the ID.

Missing Records

The most common reasons for missing client records are:

  • The client record has been flagged as 'inactive' and in Program Setup > General, the option to not include inactives in lists is not checked.
  • Record is not in sorted list: The record name is not as expected.