Client Bookkeeping Solution Tutorial Book

Client Bookkeeping Solution Tutorial Book
  • Page 1

    CLIENT BOOKKEEPING SOLUTION Tutorial version 2007.x.x

  • Page 2

    TL 22537 (06/09/09) Copyright Information Text copyright 1997-2009 by Thomson Reuters/Tax & Accounting. All rights reserved. Video display images copyright 1997-2009 by Thomson Reuters/Tax & Accounting. All rights reserved. Thomson Reuters hereby...

  • Page 3

    Client Bookkeeping Solution Tutorial iii Contents 1 Introduction 11,.......................................................................................... 1 11, Before you begin 11,.............................................................................................. 1 Using this...

  • Page 4

    Contents iv Client Bookkeeping Solution Tutorial Financial institution setup (for online banking) 35,................................................ 25 Set up a CBS checkbook for online banking (optional) 35,.............................. 25 Other time-saving 38,items.........................

  • Page 5

    Contents Client Bookkeeping Solution Tutorial v 7 Deposits and Other Bank 85,Items........................................................ 75 85, Enter a deposit 85,............................................................................................... 75 Enter a payment 87,...........

  • Page 6

    Contents vi Client Bookkeeping Solution Tutorial 11 Export to Accountant 125,.................................................................... 115 125, Print the Transactions List report 125,.................................................................. 115 Specify locations for expor...

  • Page 7

    Contents Client Bookkeeping Solution Tutorial vii Transfer funds between accounts 174,................................................................ 164 Void or delete and duplicate a check 175,............................................................ 165 Data-entry filters 177,..........

  • Page 8

    Contents viii Client Bookkeeping Solution Tutorial Add a new vendor on the fly 230,......................................................................... 220 View 1099 totals 232,...................................................................................... 222 Attach a note to a ...

  • Page 9

    Contents Client Bookkeeping Solution Tutorial ix Issue a customer refund 275,............................................................................... 265 Enter a historical invoice to assess a finance charge 276,................................... 266 Print customer invoices 276,.......

  • Page 10

    Contents x Client Bookkeeping Solution Tutorial

  • Page 11

    Client Bookkeeping Solution Tutorial 1 1 Introduction Welcome to the Client Bookkeeping Solution® (CBS) Tutorial. This tutorial is designed to teach you how to use your CBS software by stepping you through the common tasks that you will most likely perform while using CBS for your company. The ...

  • Page 12

    Introduction 2 Client Bookkeeping Solution Tutorial Using this tutorial This tutorial is divided into two separate sections. CBS CheckWriter™ only. This section is intended for users who are licensed for CBS CheckWriter only. It includes information that is relevant to CBS CheckWriter users, ...

  • Page 13

    Introduction Client Bookkeeping Solution Tutorial 3 Choose an option means to click the option circle or option label once with the left mouse button so that a dot appears within the option circle. A window is a view that can be minimized or resized. When you are working in a window, you can a...

  • Page 14

    Introduction 4 Client Bookkeeping Solution Tutorial Additional resources It is not possible to cover all setup possibilities or to address all questions in this tutorial. As you work through the procedures in this guide, you may find the resources listed in this section helpful if you encounter ...

  • Page 15

    Introduction Client Bookkeeping Solution Tutorial 5 CBS help topics The primary documentation for your CBS software is provided in the comprehensive Client Bookkeeping Solution help system. You can use the CBS help system to quickly find information you need, when you need it. To access the CBS...

  • Page 16

    Introduction 6 Client Bookkeeping Solution Tutorial Your accountant Your accountant is a valuable resource when you have questions about your CBS software. Your accountant can explain basic procedures and answer questions about CBS, including specific questions about how to customize CBS for you...

  • Page 17

    Client Bookkeeping Solution Tutorial 7 2 Setting Up a New Company Database Before you begin using Client Bookkeeping Solution, your accountant will provide you with the initial setup files that include basic information to help you get started quickly. If you would like to familiarize yourself w...

  • Page 18

    Setting Up a New Company Database 8 Client Bookkeeping Solution Tutorial Client Bookkeeping Solution main window The CBS main window includes several distinct elements such as the title bar, menu bar, toolbar, shortcut bar, and status bar. When a CBS company database is open (as shown in the fol...

  • Page 19

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 9 Select global program options You can customize your CBS software by selecting or deselecting specific data-entry options. All program data-entry options are global — that is, the options you choose stay in effect until y...

  • Page 20

    Setting Up a New Company Database 10 Client Bookkeeping Solution Tutorial Utilities / Options / General tab

  • Page 21

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 11 Utilities / Options / CBS Data Folders tab

  • Page 22

    Setting Up a New Company Database 12 Client Bookkeeping Solution Tutorial Sample data Before you begin processing transactions for your company in CBS, your accountant will provide you with an accountant’s transfer file, which contains the initial setup data for your CBS company database. Yo...

  • Page 23

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 13 For this tutorial, the initial setup files have already been imported for you. For information on importing initial setup data, search on Importing:data from your accountant from the Index tab of the Help Topics dialog. Lo...

  • Page 24

    Setting Up a New Company Database 14 Client Bookkeeping Solution Tutorial 2. On the Client Bookkeeping Solution page, click the Download Now link in the “Client Bookkeeping Solution Tutorial” section. 3. If your browser displays a File Download - Security Warning prompt, click the Save butt...

  • Page 25

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 15 Select security options Depending on how your accountant has set up your CBS software, you may be able to use the multi-level security feature of CBS to control which users have access to specific windows or commands. A us...

  • Page 26

    Setting Up a New Company Database 16 Client Bookkeeping Solution Tutorial 6. After you have selected the applicable security features for the user or classification, click Save and close the Security window. Tips To view a description of any security option, click the desired option. The pro...

  • Page 27

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 17 Company Properties When setting up your CBS company database for you, your accountant specifies several general properties for the company database. 1. To view the company properties for your database, choose File / Compa...

  • Page 28

    Setting Up a New Company Database 18 Client Bookkeeping Solution Tutorial The date in the Next scheduled export field is based on the processing frequency selected by your accountant. If you have not yet completed an export in CBS, you may override this date with a prior period date. 2. Click t...

  • Page 29

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 19 2. In the Chart of Accounts window, enter 661 in the Number field. 3. Select E from the drop-down list in the Type field. 4. Enter Utilities in the Description field. 5. Click Save. 6. Your accountant may have set up ...

  • Page 30

    Setting Up a New Company Database 20 Client Bookkeeping Solution Tutorial Checkbook setup You can set up as many as 100 accounts or checkbooks for each CBS company database. In CBS, a checkbook can be something other than a traditional checking account. For example, you can set up checkbooks spe...

  • Page 31

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 21 7. CBS automatically opens the Savings checkbook record. Note: If you cleared the Move To Next Record After Save checkbox on the General tab of the Utilities / Options dialog, CBS does not move to the next record. 8. In t...

  • Page 32

    Setting Up a New Company Database 22 Client Bookkeeping Solution Tutorial 4. Click the Security tab. If your accountant set up your CBS software to allow you to set up checkbooks and security settings, you can specify which users can access the checkbook data on a checkbook-by-checkbook basis.

  • Page 33

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 23 5. Depending on how your accountant set up your CBS software, the Checkbook Setup window may include the Financial Institution Information tab. If your financial institution allows you to access your account information v...

  • Page 34

    Setting Up a New Company Database 24 Client Bookkeeping Solution Tutorial Rename a checkbook You may sometimes find it necessary to change the name of one or more of your CBS checkbooks. 1. Select City Bank from the drop-down list in the Checkbook description field. 2. Click the Rename button....

  • Page 35

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 25 2. Note that the default checkbook for CBS CheckWriter is the Operating checkbook. You could select a different default checkbook, but you do not need to do so for this tutorial. 3. Click Cancel to close the Default Check...

  • Page 36

    Setting Up a New Company Database 26 Client Bookkeeping Solution Tutorial checkbooks. The list will be empty the first time you enter data on this tab for this checkbook. If the drop-down list is empty or if you want to select a different financial institution, click the Update List button. In t...

  • Page 37

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 27 8. You can validate the checkbook during checkbook setup, or you can wait until you are ready to view the transaction information from your financial institution. When you validate a checkbook, CBS sends your user ID and ...

  • Page 38

    Setting Up a New Company Database 28 Client Bookkeeping Solution Tutorial Other time-saving items User-defined lists Client Bookkeeping Solution allows you to maintain lists of different items that can be recalled from several windows and dialogs throughout the program. You determine the entries...

  • Page 39

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 29 4. Click the arrow in the City drop-down list. Notice that Livonia is now included in the list of cities available for selection. 5. Close the Checkbook data-entry window. Notes You can add items to user-defined lists ...

  • Page 40

    Setting Up a New Company Database 30 Client Bookkeeping Solution Tutorial Keyboard shortcuts A keyboard shortcut is a combination of keys that you press simultaneously. These shortcuts give you the same result as using the left mouse button to click a menu option. You can see which CBS menu com...

  • Page 41

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 31 If you run CBS in multi-user mode and more than one person is working in the same company database at the same time. If any of the other users add transactions to the window or dialog you are working in, CBS will not aut...

  • Page 42

    Setting Up a New Company Database 32 Client Bookkeeping Solution Tutorial 1. Cho ose Setup / Groups / GL Account. 2. Enter Sales in the GL account group field. 3. Select accounts 401 and 405 from the Available GL accounts list. 4. Click Save, then close the GL Account Groups dialog.

  • Page 43

    Setting Up a New Company Database Client Bookkeeping Solution Tutorial 33 5. Cho ose File / Queue Reports and click the Options button associated with the Transactions List. 6. In the GL accounts to include group box, click the Group option, and then click the arrow in the drop-down list. Noti...

  • Page 44

    Setting Up a New Company Database 34 Client Bookkeeping Solution Tutorial

  • Page 45

    SECTION 1 Client Bookkeeping Solution CheckWriter Only This section is intended for clients who are licensed for CBS CheckWriter only (no add-on modules) Use sample company CheckWriter Tutorial.cbs

  • Page 46

  • Page 47

    Client Bookkeeping Solution Tutorial 37 3 Checkbook Data Entry If you are licensed for CBS CheckWriter but not for any of the optional CBS add-on modules, continue with this section. If you are licensed for one or more add-on modules — CBS PayCheck, CBS Accounts Payable, and/or CBS Accounts R...

  • Page 48

    Checkbook Data Entry 38 Client Bookkeeping Solution Tutorial 4. Enter Operating in the Checkbook group description field. 5. Click OK. Notice that the Bal and TBal amounts now appear on the CBS status bar.

  • Page 49

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 39 Enter checks Use the Checkbook data-entry window to enter transactions that affect your CBS checkbooks. The listview pane in the Checkbook data-entry window is similar to the register in your manual checkbook system. Handwritten chec...

  • Page 50

    Checkbook Data Entry 40 Client Bookkeeping Solution Tutorial Note: Because you selected the Operating checkbook as the default checkbook for CBS CheckWriter, you can press CTRL+K to open the Operating checkbook, or click the Checkbook icon on the CheckWriter shortcut bar. 2. Select GREEN from t...

  • Page 51

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 41 3. Select Handwritten from the drop-down list in the Pay preference field. CBS automatically enters the current date in the Date field and the next available check number in the Check # field. If the current date is not in the same per...

  • Page 52

    Checkbook Data Entry 42 Client Bookkeeping Solution Tutorial the transaction record. Notice that CBS does not export adjustments to your accountant. Tip If you prefer to enter whole dollar amounts without the decimal point, you can mark the Implied Decimal On Amounts checkbox on the General t...

  • Page 53

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 43 Unprinted checks CBS allows you to record checks that you can print at a later date. The program saves these transactions as unprinted checks. Each printed or handwritten check, by definition, has already been assigned both a check num...

  • Page 54

    Checkbook Data Entry 44 Client Bookkeeping Solution Tutorial 9. Click Save. Notice that the TBal amount on the status bar reflects the tentative checkbook balance as if all checks were printed. The Bal amount reflects the balance with printed checks only. 10. Click the Options button. 11. On t...

  • Page 55

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 45 Note: If you typically use a single GL account distribution for your vendors, or if you set up default distributions in the vendor record, you may want to clear the Default to Distributions tab checkbox to have the program display the...

  • Page 56

    Checkbook Data Entry 46 Client Bookkeeping Solution Tutorial message prompt asking if you would like to add this new description to the system. Click Yes. 17. In the List of Detail Descriptions dialog, press the TAB key to move to the next blank field and enter Tools. Click OK. 18. In the Chec...

  • Page 57

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 47 Print a check from the Checkbook data-entry window You can print a single check directly from the Checkbook data-entry window instead of using the File / Print Checks dialog. 1. In the Checkbook data-entry window, select Green Tree L...

  • Page 58

    Checkbook Data Entry 48 Client Bookkeeping Solution Tutorial 6. Select Lawn Care from the drop-down list in the Description column for the second row. 7. Click the Print button. 8. In the Check Printing dialog, enter 4/15/07 in the Check date field. Note that CBS automatically enters the next c...

  • Page 59

    Checkbook Data Entry Client Bookkeeping Solution Tutorial 49 11. In the Select Checks That Did Not Print dialog, mark the checkbox for Green Tree and click the Done button. Notice that CBS saved the check as an unprinted check, and the running balance is not affected.

  • Page 60

    Checkbook Data Entry 50 Client Bookkeeping Solution Tutorial

  • Page 61

    Client Bookkeeping Solution Tutorial 51 4 CheckWriter Vendors CBS makes it easy for you to keep track of information about each of your company’s regular vendors. The vendor record serves as a template for creating new transactions. When you record a check for a vendor in CBS, the program rec...

  • Page 62

    CheckWriter Vendors 52 Client Bookkeeping Solution Tutorial 7. Click Save. CBS displays a message prompt informing you that this vendor does not exist and asks if you would like to add this vendor. Click Yes. CBS opens the Confirm New Vendor Data dialog, where you can verify the vendor ID, paye...

  • Page 63

    CheckWriter Vendors Client Bookkeeping Solution Tutorial 53 Add a vendor record When you verified the vendor information in the previous section, CBS created a vendor record with that information. Now you can set up the rest of the vendor record in the Vendors window. 1. Cho ose Setup / Vendors....

  • Page 64

    CheckWriter Vendors 54 Client Bookkeeping Solution Tutorial 3. Click the Distributions tab. Notice that CBS automatically selected account 661 and entered the amount of 80.00. The program recalled this information from the vendor record that you set up in the previous section. 4. Click the CW ...

  • Page 65

    CheckWriter Vendors Client Bookkeeping Solution Tutorial 55 Add another vendor 1. On a new vendor record, enter MAX in the ID field. 2. Enter Office Max in the Name field. 3. Enter or select the following information on the General tab. Street 1 123 Main Street Street 2 Suite 102 City Plymouth S...

  • Page 66

    CheckWriter Vendors 56 Client Bookkeeping Solution Tutorial

  • Page 67

    Client Bookkeeping Solution Tutorial 57 5 Memorized Transactions In CBS, memorized transactions can speed data entry for all types of transactions. For example, if you pay the same amount of rent every month, you can set up a recurring memorized transaction for CBS to use to automatically creat...

  • Page 68

    Memorized Transactions 58 Client Bookkeeping Solution Tutorial 5. Click the Recurring transaction tab and select Monthly from the drop-down list in the Frequency field. 6. Select Operating in the Prompt to create when opening field. CBS will prompt you to create recurring transactions that may ...

  • Page 69

    Memorized Transactions Client Bookkeeping Solution Tutorial 59 11. Choose the Selected option and click OK. 12. In the Select Memorized Transactions to Use dialog, verify that the check to GREEN is in the Selected transactions pane.

  • Page 70

    Memorized Transactions 60 Client Bookkeeping Solution Tutorial 13. Click OK to create a transaction for GREEN based on the memorized transaction you set up. 14. If there are multiple transactions due to be created at this time (based on your current system date), the Update & Confirm Transac...

  • Page 71

    Memorized Transactions Client Bookkeeping Solution Tutorial 61 Memorize a transaction 1. In the Checkbook data-entry window, navigate to a new record and then select Office Max from the drop-down list in the ID field. 2. Enter 80. in the Amount field. When you move the cursor to the next field...

  • Page 72

    Memorized Transactions 62 Client Bookkeeping Solution Tutorial 5. Click Save.

  • Page 73

    Client Bookkeeping Solution Tutorial 63 6 Printing Reports and Checks Your CBS software includes a number of helpful reports that you can use to verify and analyze your company data. You can customize each report to your specific needs by selecting print options for each report. You can also u...

  • Page 74

    Printing Reports and Checks 64 Client Bookkeeping Solution Tutorial 4. Click the Consolidate button. When the program displays a prompt informing you that all checks were successfully consolidated, click OK. 5. Click the Close button to return to the Checkbook data-entry window. Notice that a s...

  • Page 75

    Printing Reports and Checks Client Bookkeeping Solution Tutorial 65 6. Close the Checkbook data-entry window. Print reports Before printing checks, you may want to print the Unprinted Regular Checks report to verify the information on the checks and avoid printing checks with errors and wastin...

  • Page 76

    Printing Reports and Checks 66 Client Bookkeeping Solution Tutorial 2. Mark the Unprinted Regular Checks checkbox and click the associated Options button. 3. In the Unprinted Regular Checks List dialog, choose the Selected option in the Unprinted Checks to Include group box. Click the Select Ch...

  • Page 77

    Printing Reports and Checks Client Bookkeeping Solution Tutorial 67 7. Close the Preview window by clicking the Close window button in the upper right corner, or by pressing ALT+F4. 8. Click the Options button associated with the Unprinted Regular Checks checkbox. 9. Cho ose the All option in ...

  • Page 78

    Printing Reports and Checks 68 Client Bookkeeping Solution Tutorial 12. Close the Preview window and then close the Queue Reports dialog.

  • Page 79

    Printing Reports and Checks Client Bookkeeping Solution Tutorial 69 Print checks After you have previewed the Unprinted Checks report to verify that all information is correct, you can print your checks. 1. Cho ose File / Print Checks, or click the Print Checks button on the toolbar. 2. Verify...

  • Page 80

    Printing Reports and Checks 70 Client Bookkeeping Solution Tutorial 6. When the program displays a message informing you that all checks were successfully consolidated, click OK. Close the Consolidate Checks dialog. 7. In the Select Regular Checks dialog, select the new combined check for Ace Ha...

  • Page 81

    Printing Reports and Checks Client Bookkeeping Solution Tutorial 71 Tips If you want CBS to display the check numbers in sequence, you can select Order Entered in the Sort by field in the Print Checks dialog when printing checks. To sort the checks by number while working in the Checkbook da...

  • Page 82

    Printing Reports and Checks 72 Client Bookkeeping Solution Tutorial Enter future-period checks CBS allows you to enter checks that are dated in a future period. You will now record a check for lawn care service to be generated and printed on May 15, 2007. 1. In the Checkbook data-entry window, s...

  • Page 83

    Printing Reports and Checks Client Bookkeeping Solution Tutorial 73 5. Click the Print button. CBS will print a check for nine dollars to the Girl Scouts on your default printer. 6. Click Continue in the Check Printing dialog. Click Yes when the program asks if all checks printed successfully. N...

  • Page 84

    Printing Reports and Checks 74 Client Bookkeeping Solution Tutorial

  • Page 85

    Client Bookkeeping Solution Tutorial 75 7 Deposits and Other Bank Items In addition to writing and recording checks, you can use CBS to enter deposits, fund transfers, and other financial transactions that affect your accounts. You can also easily export these transactions to your accountant. E...

  • Page 86

    Deposits and Other Bank Items 76 Client Bookkeeping Solution Tutorial 6. In the Checkbook data-entry window, click the Print button. 7. In the Print Deposit Slips dialog, click the Print button. CBS prints the deposit slip and saves the deposit transaction.

  • Page 87

    Deposits and Other Bank Items Client Bookkeeping Solution Tutorial 77 Tips If the deposit amounts will vary for each deposit transaction, you may want to memorize the transaction before you enter any amounts for the distributions. Or you can choose Setup / Memorized Transactions and set up a m...

  • Page 88

    Deposits and Other Bank Items 78 Client Bookkeeping Solution Tutorial Transfer funds You can use the Checkbook data-entry window to transfer funds between accounts in CBS. In this example, you will transfer money from your Operating checkbook to your Payroll Bank checkbook. 1. In the Checkbook ...

  • Page 89

    Deposits and Other Bank Items Client Bookkeeping Solution Tutorial 79 6. Click Save. The program transfers the $2,000 from the Operating checkbook to the Payroll checkbook. 7. Cho ose Checkbook / Open / Payroll Bank. 8. In the listview pane, highlight the payroll transfer transaction you just ...

  • Page 90

    Deposits and Other Bank Items 80 Client Bookkeeping Solution Tutorial 9. Click the Delete button. Because you created this transaction in the Operating checkbook, CBS does not allow you to delete it from this checkbook. The program displays a message explaining that this item was created in the...

  • Page 91

    Deposits and Other Bank Items Client Bookkeeping Solution Tutorial 81 3. In the Void or Delete Printed Check dialog, the Void the check option is selected by default. 4. Mark the Duplicate the check on void or delete checkbox, then click OK. CBS now displays the text **VOID** in the Payment co...

  • Page 92

    Deposits and Other Bank Items 82 Client Bookkeeping Solution Tutorial Print the Checkbook Register report The Checkbook Register report is very much like a check register in a manual checkbook system. It shows all activity for the selected checkbook, including handwritten or printed checks, depo...

  • Page 93

    Deposits and Other Bank Items Client Bookkeeping Solution Tutorial 83 CBS displays the Checkbook Register report, showing all transactions that will export to your accountant, including any voided checks. The future-period check will not be exported at this time. To see the future-period check,...

  • Page 94

    Deposits and Other Bank Items 84 Client Bookkeeping Solution Tutorial

  • Page 95

    Client Bookkeeping Solution Tutorial 85 8 Noncalculating Payroll Employee setup CBS makes it easy to keep track of information about each of your company’s employees. The employee record serves as a template. When you record a payroll check for an employee in CBS CheckWriter, the program reca...

  • Page 96

    Noncalculating Payroll 86 Client Bookkeeping Solution Tutorial 5. Select 1 from the drop-down list in the Dept. # field. The program displays a message prompt asking if you want to update the employee distributions based on the department. Click Yes. Note: CBS CheckWriter does not allow you to...

  • Page 97

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 87 10. Click Save to save the new account number and press CTRL+F4 to close the Chart of Accounts window. 11. In the NCP Employees window, click Save. Modify employee information Once you have added employee information, CBS allows yo...

  • Page 98

    Noncalculating Payroll 88 Client Bookkeeping Solution Tutorial 4. Enter 1 in the Units field. 5. Click Save. CBS automatically moves to the record for employee 102. 6. On the Check Distributions tab, note that CBS recalled the distribution amounts from Sue’s employee record. If an employee re...

  • Page 99

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 89 Select this item to create a withholding item for this employee’s payroll taxes. 8. Click Save to record your changes. Tip If your accountant has set up your CBS software to allow you to view, transfer, and/or delete payroll de...

  • Page 100

    Noncalculating Payroll 90 Client Bookkeeping Solution Tutorial If your CBS software is not set up to view, transfer, or delete payroll department information, you may want to use the same generic item for the same pay or withholding item for each employee. For example, if you deduct a fixed amou...

  • Page 101

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 91 4. Click Save. Because you are not using all the payroll items, you may choose to set up the data-entry options to hide these rows. 1. Click the Options button, then click the Payroll Checks tab. 2. Mark the Gross Pay #4, Gross Pay ...

  • Page 102

    Noncalculating Payroll 92 Client Bookkeeping Solution Tutorial 4. Click Save to save this check. 5. Select 103 from the ID field and enter the following values. Gross Pay #1 500.00 FICA-SS W/H 31.00 FICA-Med W/H 7.25 Federal W/H 44.00 State W/H 20.00 6. Click Save. Note the TBal (tentative ...

  • Page 103

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 93 View the Unprinted Payroll Checks report The Unprinted Payroll Checks List shows complete detail for unprinted checks entered for the selected checkbook . Detailed information for each unprinted check includes the employee number and...

  • Page 104

    Noncalculating Payroll 94 Client Bookkeeping Solution Tutorial 4. Click the Print button. Note: You cannot preview checks in CBS. 5. In the Check Printing dialog, enter 4/30/07 in the Date field and click Continue. The program displays a message prompt asking if all checks printed successfully...

  • Page 105

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 95 8. Mark the checkbox associated with check # 1000 for Tom Johnston. 9. Click the Done button, then click OK to close the Print Payroll Checks dialog. 10. In the Queue Reports dialog, clear the Print Payroll Checks checkbox. 11. Cli...

  • Page 106

    Noncalculating Payroll 96 Client Bookkeeping Solution Tutorial 6. Highlight the unprinted check to Sue Quincy and mark the Handwritten checkbox. 7. Enter 43007 in the Date field. 8. Click Save to record this action. Preview the Printed Payroll Checks report You can use the Printed Payroll Che...

  • Page 107

    Noncalculating Payroll Client Bookkeeping Solution Tutorial 97 3. Mark the Printed Payroll Checks checkbox and then click the associated Options button. 4. In the Checks to include group box, choose the Current export period option. 5. In the Format group box, choose the Detail (Sorted by type...

  • Page 108

    Noncalculating Payroll 98 Client Bookkeeping Solution Tutorial 10. When you have finished reviewing the report, close the preview window, and then click OK to close the Queue Reports dialog.

  • Page 109

    Client Bookkeeping Solution Tutorial 99 9 Journal Entries and Other Features CBS allows you to enter journal entry transactions, which do not affect the balance of any of your CBS checkbooks. Journal entries 1. Cho ose Setup / Memorized Transactions. 2. Select Journal Entry from the drop-down ...

  • Page 110

    Journal Entries and Other Features 100 Client Bookkeeping Solution Tutorial 12. Press the down-arrow key on your keyboard and enter 50.00 in the Credit column of the second distribution row. 13. Press the down-arrow key again and then click the Balance Entry button. The program enters 80.00 in ...

  • Page 111

    Journal Entries and Other Features Client Bookkeeping Solution Tutorial 101 3. In the Checkbook Filters dialog, enter New in the Filter Name field. 4. Enter 100 to 103 in the Number From and To fields in the Ranges to Include group box. Click OK. 5. CBS displays a message prompt asking if you ...

  • Page 112

    Journal Entries and Other Features 102 Client Bookkeeping Solution Tutorial 7. Click the Filters button. 8. In the Checkbook Filters dialog, select All from the Filter Name drop-down list and then click OK. CBS now displays all transactions in the listview pane. Sort transactions You can sort t...

  • Page 113

    Journal Entries and Other Features Client Bookkeeping Solution Tutorial 103 Notice that CBS no longer displays the balances in the Balance column. You must sort the transactions by date in order to display the running balance. Find transactions You can use the Find feature to search for a speci...

  • Page 114

    Journal Entries and Other Features 104 Client Bookkeeping Solution Tutorial 3. In the Field(s) to Search field, select Number from the drop-down list. 4. Click Find. CBS opens the transaction record for check #103. Click the Close button in the Find dialog to view the information for the check...

  • Page 115

    Client Bookkeeping Solution Tutorial 105 10 Checkbook Reconciliation If your accountant has enabled the checkbook reconciliation feature in your CBS software, you can make the job of reconciling your checkbook much faster and easier. If your financial institution offers any online banking servi...

  • Page 116

    Checkbook Reconciliation 106 Client Bookkeeping Solution Tutorial View transaction details CBS allows you to display transactions details (entered on the Details tab of the Checkbook data-entry window for deposits, other payments, and other deposits), with each component of the transaction displ...

  • Page 117

    Checkbook Reconciliation Client Bookkeeping Solution Tutorial 107 2. Because the cash deposit was posted immediately, you can mark this as cleared using any of the methods listed below. The program places an X in the Cleared column for all cleared items. Double-click the item you want to clear....

  • Page 118

    Checkbook Reconciliation 108 Client Bookkeeping Solution Tutorial 7. Leave EOM (End of Month) in the Recurring Frequency field. 8. Click the Create All button. 9. Click OK when prompted that the item was created, and then click the Done button. Note that the Interest Income item is already ma...

  • Page 119

    Checkbook Reconciliation Client Bookkeeping Solution Tutorial 109 10. Click Save. 11. Open the Checkbook data-entry window. Notice that the program added the Interest Income item to the checkbook.

  • Page 120

    Checkbook Reconciliation 110 Client Bookkeeping Solution Tutorial 12. The C next to the transaction description indicates that the item is selected to clear. The P next to the Deposit item indicates that this item is partially cleared. 13. Close the Checkbook window and return to the Checkbook...

  • Page 121

    Checkbook Reconciliation Client Bookkeeping Solution Tutorial 111 Edit menu options When the Checkbook Transactions tab of the Reconcile Transactions window is active, the Edit menu includes some commands that you may find helpful as you reconcile your checkbook in CBS. These commands include De...

  • Page 122

    Checkbook Reconciliation 112 Client Bookkeeping Solution Tutorial Finalize the reconciliation 1. On the Checkbook Transactions tab of the Reconcile Transactions window, clear the two Other Items (Bank service charge and Transfer to Payroll). Notice that the unreconciled difference is now zero. 2...

  • Page 123

    Checkbook Reconciliation Client Bookkeeping Solution Tutorial 113 6. Close the Reconcile Transactions window. 7. Cho ose Checkbook / Open / Operating. Note that an X appears in the Status column for the cleared transactions.

  • Page 124

    Checkbook Reconciliation 114 Client Bookkeeping Solution Tutorial 8. Close the Checkbook data-entry window. Note: If you set up CBS to retrieve your transaction data directly from your financial institution or from an electronic file, the program fills in the dates and amounts for you. As you c...

  • Page 125

    Client Bookkeeping Solution Tutorial 115 11 Export to Accountant Now that you have entered your checks, vendor information, employee records, and journal entries, you are ready to export this information to your accountant. Print the Transactions List report Before you export any data, you may ...

  • Page 126

    Export to Accountant 116 Client Bookkeeping Solution Tutorial Note that the Transactions List report shows transactions for all checkbooks. Because adjustments do not transfer to your accountant, they are not shown on the report. 6. Close the Preview window and the Queue Reports dialog.

  • Page 127

    Export to Accountant Client Bookkeeping Solution Tutorial 117 Specify locations for export and backup data Before exporting data, you will need to set up a file location for your export and backup files. Export and back up to a local folder 1. Cho ose Utilities / Options, and then click the CBS...

  • Page 128

    Export to Accountant 118 Client Bookkeeping Solution Tutorial Export data to your accountant 1. Cho ose File / Export To Accountant or click the Export to Accountant icon on the CBS shortcut bar. 2. The program displays a message prompt recommending that you back up your data before exporting ...

  • Page 129

    Export to Accountant Client Bookkeeping Solution Tutorial 119 8. The program prompts you when the export is complete. Click OK. Notice the CW Date in the lower, right corner of the status bar is now 5/31/07. Reverse an exported transaction Let’s assume that something was wrong with one of the ...

  • Page 130

    Export to Accountant 120 Client Bookkeeping Solution Tutorial Automatic back up of files and export data CBS creates a number of automatic data backups. During the export process, CBS automatically backs up the pre-export company data and export data, and stores this information in the CBS Arch...

  • Page 131

    Export to Accountant Client Bookkeeping Solution Tutorial 121 to view the list of these backup files, you can choose Utilities / Administrator Utilities and click the Archive Folder Maintenance. Conclusion Now that you have learned how to use CBS CheckWriter, you may want to start using CBS to ...

  • Page 132

    Export to Accountant 122 Client Bookkeeping Solution Tutorial

  • Page 133

    SECTION 2: Client Bookkeeping Solution Add-on Modules This section is intended for clients who are licensed for CBS CheckWriter and one or more of the following add-on modules. CBS PayCheck CBS Accounts Payable CBS Accounts Receivable Use sample company CBS Tutors, Inc..cbs

  • Page 134

  • Page 135

    Client Bookkeeping Solution Tutorial 125 12 Setting Up the Company Database If you did not complete Section 1 of this tutorial, you may want to review the “Start the program” and “Select global program options” sections beginning on page 17,7 of this Tutorial. Scenario Sample company C...

  • Page 136

    Setting Up the Company Database 126 Client Bookkeeping Solution Tutorial Note: If you recently updated your CBS software, the program may display a message prompt informing you that you must update your company data before the program can open it in the current version. Click Yes to continue. 4....

  • Page 137

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 127 6. After you have selected the applicable security features for the user or classification, click Save and close the Security window. Tips To view a description of any security option, click the desired option. The prog...

  • Page 138

    Setting Up the Company Database 128 Client Bookkeeping Solution Tutorial Company Properties 1. Cho ose File / Company Properties. Review the information that has already been set up for this sample company. Notice that there are several tabbed pages in this dialog. This sample company is license...

  • Page 139

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 129 The Allow 1099 item selection notation indicates that your accountant has set up your CBS software to allow you to select 1099 items for vendors when entering regular checks in CBS.

  • Page 140

    Setting Up the Company Database 130 Client Bookkeeping Solution Tutorial 2. Click the PayCheck tab. You can change the default Payroll frequency (frequency at which you pay your employees) on this tabbed page. Note that the changes you make in this dialog will affect all employees in the company...

  • Page 141

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 131 3. Click the Accounts Payable tab. This sample database uses the Net Purchase discount method. Ask your accountant which method would be best for you. Net purchase method. The program adjusts the discount amount to the act...

  • Page 142

    Setting Up the Company Database 132 Client Bookkeeping Solution Tutorial 5. Click the Accounts Receivable tab. You can specify default accounts for the program to use in cases where no account is specified during data entry. While most default accounts are optional, you must specify account nu...

  • Page 143

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 133 By default, CBS uses the company name and address specified on your CBS license for the remittance information. You can modify this information as necessary for printing forms.

  • Page 144

    Setting Up the Company Database 134 Client Bookkeeping Solution Tutorial 6. Click the Accounts Receivable – Data Entry tab to set up or modify options that apply to the accounts receivable data-entry windows and dialogs. 7. Click OK to close the Company Properties dialog.

  • Page 145

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 135 Chart of Accounts setup Your accountant may have set up your CBS software to allow you to add to or modify the Chart of Accounts. 1. Cho ose Setup / Chart of Accounts (or click the Chart of Accounts icon on the CheckWriter...

  • Page 146

    Setting Up the Company Database 136 Client Bookkeeping Solution Tutorial CBS displays a prompt stating that you cannot enter this account number because it falls within the restricted range established by your accountant. Click OK to continue. 7. Click the Close window button to close the Char...

  • Page 147

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 137 7. Click the Security tab. If your accountant set up your CBS software to allow you to set up checkbooks and the security for each checkbook, you can specify which users or user classifications can access the checkbook dat...

  • Page 148

    Setting Up the Company Database 138 Client Bookkeeping Solution Tutorial 8. Depending on how your accountant set up your CBS software, the Checkbook Setup window may include the Financial Institution Information tab. If your financial institution allows you to access your account information vi...

  • Page 149

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 139 10. Click Cancel. 11. Depending on how your accountant set up your CBS software, the Checkbook Setup window may include the MICR Information tab. You can print MICR-encoded checks on blank (rather than preprinted) check s...

  • Page 150

    Setting Up the Company Database 140 Client Bookkeeping Solution Tutorial 12. Click Save. The program automatically moves to the next checkbook record in the listview pane; in this example, that is the Savings account. Note: If you cleared the Move To Next Record After Save checkbox on the Gene...

  • Page 151

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 141 16. Click Save. 17. Because this checkbook was originally selected as the default checkbook for PayCheck checks, CBS displays a prompt informing you that your default checkbook will no longer be set for PayCheck check type...

  • Page 152

    Setting Up the Company Database 142 Client Bookkeeping Solution Tutorial 4. Click Save. Tip If you have a bitmap file of a company logo or a signature, you can have CBS print them on your checks or deposit slips. Simply click the Logo & Signature Paths button and specify the location for t...

  • Page 153

    Setting Up the Company Database Client Bookkeeping Solution Tutorial 143 Checking Account is the default checkbook for all CBS modules except for CBS PayCheck. This was the first checkbook you set up for this company database. You can select a different default checkbook for any licensed CBS mo...

  • Page 154

    Setting Up the Company Database 144 Client Bookkeeping Solution Tutorial

  • Page 155

    Client Bookkeeping Solution Tutorial 145 13 CBS CheckWriter CBS CheckWriter is the core module of the Client Bookkeeping Solution program. With CBS CheckWriter, you can record and print vendor and noncalculating payroll checks, and you can generate and print many helpful reports. All of your CB...

  • Page 156

    CBS CheckWriter 146 Client Bookkeeping Solution Tutorial Note: CBS records the adjustment as a deposit amount because you entered a positive number for the amount. CBS does not export adjustments to your accountant. Adjustments appear gray in the listview pane and are automatically marked as cl...

  • Page 157

    CBS CheckWriter Client Bookkeeping Solution Tutorial 147 4. Enter 5/15/07 in the Date field. If the program prompts you that the date is in a different period, click OK. 5. Select LAWN from the drop-down list in the ID field. Notice that the program automatically marks the Vendor check checkbox ...

  • Page 158

    CBS CheckWriter 148 Client Bookkeeping Solution Tutorial Example: If you enter 1000 in an amount field, CBS will enter the amount as $1,000.00. If the checkbox is not marked, CBS will enter the amount as $10.00. If you prefer to have CBS display the Address tab by default when you open the Chec...

  • Page 159

    CBS CheckWriter Client Bookkeeping Solution Tutorial 149 6. Click the Address tab. 7. Enter 234 Main Ave. in the Street field. 8. Enter Newtown in the City field. The program displays a message prompt asking if you want to add the city to the list of cities. Click Yes. 9. In the List of Citie...

  • Page 160

    CBS CheckWriter 150 Client Bookkeeping Solution Tutorial 10. Select MI from the drop-down list in the State field, and then select 48130 from the drop-down list in the Zip field. 11. Click the Details tab. Note: You can press CTRL+TAB and CTRL+SHIFT+TAB to move between the tabbed pages in any C...

  • Page 161

    CBS CheckWriter Client Bookkeeping Solution Tutorial 151 15. Now assume that you want to ask your accountant a question about this transaction. Choose Edit / Note to Accountant or (click the Note button). 16. In the Note to Accountant dialog, enter the following text. Should a new computer key...

  • Page 162

    CBS CheckWriter 152 Client Bookkeeping Solution Tutorial 3. In the Checkbook group description field, enter Checking Account and click OK. Notice that the Checking Account TBal and Bal amounts are now displayed on the CBS status bar, next to the CheckWriter and PayCheck export dates. Print a n...

  • Page 163

    CBS CheckWriter Client Bookkeeping Solution Tutorial 153 3. Enter 12. in the Amount field. 4. Enter Girl Scout cookies in the Memo field. 5. On the Distributions tab, select 620 from the drop-down list in the Account column of the first distribution row. 6. Click the Print button. 7. In the Chec...

  • Page 164

    CBS CheckWriter 154 Client Bookkeeping Solution Tutorial 9. In the Select Checks That Did Not Print dialog, mark the checkbox associated with the Girl Scouts check and click the Done button. Now, enter another check for Office Max. 1. Enter Office Max in the Payee field. 2. Enter 55.45 in the ...

  • Page 165

    CBS CheckWriter Client Bookkeeping Solution Tutorial 155 2. In the Consolidate Checks dialog, click the Select All button to mark all checks in the Checks to consolidate pane. 3. Click the Consolidate button. 4. CBS displays a message prompt when it finishes consolidating the checks. Click OK ...

  • Page 166

    CBS CheckWriter 156 Client Bookkeeping Solution Tutorial Preview the Unprinted Regular Checks report Before printing checks, you may want to print the Unprinted Regular Checks report to verify the information on the checks. This way you can avoid printing checks with errors and wasting check sto...

  • Page 167

    CBS CheckWriter Client Bookkeeping Solution Tutorial 157 7. Close the Preview window by clicking the Close window button in the upper right corner or by pressing ALT+F4. 8. In the Queue Reports dialog, mark the Unprinted Regular Checks checkbox and click the Options button. 9. In the Unprinted...

  • Page 168

    CBS CheckWriter 158 Client Bookkeeping Solution Tutorial 13. Note that there are no Vendor IDs listed for Office Max or Girl Scouts. That is because they are not vendor checks, and these payees will not appear in the Vendor List report. In addition, the program will not calculate year-to-date v...

  • Page 169

    CBS CheckWriter Client Bookkeeping Solution Tutorial 159 You can preview the reports on your computer monitor before printing them to paper, as you did in the previous exercise. This allows you to make any adjustments to the print settings before you print them. From the Preview window, you can...

  • Page 170

    CBS CheckWriter 160 Client Bookkeeping Solution Tutorial Enter a deposit 1. In the Checkbook data-entry window, select Deposit from the Type field. 2. Enter 5/30/07 in the Date field. 3. Enter Monthly Sales in the Description field. 4. Enter 1847.15 in the Amount field. 5. On the first line on...

  • Page 171

    CBS CheckWriter Client Bookkeeping Solution Tutorial 161 10. The program displays a message prompt asking if you want to add the description to the list of descriptions. Click Yes. 11. In the List of Detail Descriptions dialog, press the TAB key to move to the next row in the grid, and then ente...

  • Page 172

    CBS CheckWriter 162 Client Bookkeeping Solution Tutorial 17. In the Checkbook data-entry window, click Save. Tips If the deposit amounts will vary for each deposit transaction, you may want to memorize the transaction before you enter any amounts for the distributions. Or you can choose Setup...

  • Page 173

    CBS CheckWriter Client Bookkeeping Solution Tutorial 163 2. Notice that CBS saved the Monthly Sales deposit as a memorized transaction. 3. Select Other Payment from the Type drop-down list. 4. TAB to the ID field and enter ATM Withdrawal. 5. Enter Cash in the Desc field. 6. On the Distributio...

  • Page 174

    CBS CheckWriter 164 Client Bookkeeping Solution Tutorial Transfer funds between accounts You can use the Checkbook data-entry window to transfer funds between checkbook accounts in CBS. 1. In the Checkbook data-entry window, select Other Payment from the Type drop-down list. 2. Mark the EFT che...

  • Page 175

    CBS CheckWriter Client Bookkeeping Solution Tutorial 165 7. Click Save. 8. Close the Checkbook data-entry window. 9. Cho ose Checkbook / Open / Payroll Bank. 10. Highlight the transfer transaction you just created. The fields on the Distributions tab are grayed out and unavailable because you ...

  • Page 176

    CBS CheckWriter 166 Client Bookkeeping Solution Tutorial 5. Click OK. Notice that the program now displays the text **VOID** in the Payment column for check 101. The program also created a duplicate check for LAWN as an unprinted check. 6. Select the unprinted check for LAWN and then select Ha...

  • Page 177

    CBS CheckWriter Client Bookkeeping Solution Tutorial 167 Data-entry filters CBS allows you to limit the number of transactions displayed in the listview pane of the Checkbook data-entry window. 1. Cho ose Setup / Filters / Checkbook(s). Notice that there are three filters set up for you — All...

  • Page 178

    CBS CheckWriter 168 Client Bookkeeping Solution Tutorial 5. Click Save and then close the Checkbook Filters dialog. Return to the Checkbook data-entry window and click the Filters button. Select Current checks & deposits from the drop down list in the Filter Name field and click OK. 6. Noti...

  • Page 179

    CBS CheckWriter Client Bookkeeping Solution Tutorial 169 Preview the Checkbook Register report The Checkbook Register report is very much like a check register in a manual checkbook system. It shows all activity for the selected checkbook, including handwritten or printed checks, deposits, other...

  • Page 180

    CBS CheckWriter 170 Client Bookkeeping Solution Tutorial Journal entries Journal entries do not affect your checkbook, but CBS does export them to your accountant. You can set up a memorized journal entry for recurring entries. 1. Cho ose Setup / Memorized Transactions. 2. Select Journal Entry ...

  • Page 181

    CBS CheckWriter Client Bookkeeping Solution Tutorial 171 8. Cho ose Tasks / Journal Entries or click the Journal Entries icon on the CheckWriter shortcut bar. 9. Enter 5/31/07 in the Date field. 10. Press F4 in the Description field and select Depreciation Adjustment. 11. Enter $30.00 in the ...

  • Page 182

    CBS CheckWriter 172 Client Bookkeeping Solution Tutorial

  • Page 183

    Client Bookkeeping Solution Tutorial 173 14 CBS PayCheck CBS PayCheck adds full-featured calculating payroll to your CBS CheckWriter software. It can handle federal, state, and local tax withholdings, as well as special deduction calculations for both salaried and hourly employees, and it offer...

  • Page 184

    CBS PayCheck 174 Client Bookkeeping Solution Tutorial Note: To view the state or local tax tables, you would choose Setup / Tax Tables / State Tax Tables or Setup / Tax Tables / Local Tax Tables. 2. Click the Federal Tax Tables tab. Select the tax table you want to view from the drop-down list i...

  • Page 185

    CBS PayCheck Client Bookkeeping Solution Tutorial 175 you security rights to import these files, you can update the tax tables by choosing File / Import / CBS Payroll tax data updates. Set up benefit accruals CBS uses benefit accrual items to track the amount of an employee’s accrued time. Onc...

  • Page 186

    CBS PayCheck 176 Client Bookkeeping Solution Tutorial Employee setup CBS PayCheck allows you to maintain personnel information about each of your company’s employees, track payroll and benefit accrual information, and record and print paychecks. When you print paychecks from CBS PayCheck, the ...

  • Page 187

    CBS PayCheck Client Bookkeeping Solution Tutorial 177 10. Click the Benefits tab. 11. Select Vacation from the drop-down list in the Description field. 12. Select Monthly from the drop-down list in the Method field. 13. Enter 10 in the Allowance field. This tells the program that the employee...

  • Page 188

    CBS PayCheck 178 Client Bookkeeping Solution Tutorial 18. In the Employee-level Federal Tax W/H Item Information dialog, select Married from the Table drop-down list. You can use this dialog to set up allowances claimed on the employee’s W-4 form. 19. Click OK. 20. Click the Details button a...

  • Page 189

    CBS PayCheck Client Bookkeeping Solution Tutorial 179 24. Click the Tax Calculation Details button to view the tax treatment for the 401(k). The 401(k) wages in this example are not subject to federal, state, or local withholding. 25. Click OK to close the Edit Deduction – Tax Calculation Deta...

  • Page 190

    CBS PayCheck 180 Client Bookkeeping Solution Tutorial 3. Select Sales from the Sales dept field. 4. Click the Benefit Accruals tab. 5. Select Vacation from the Description column in the first row. 6. Click the Tax W/H and Deductions tab. 7. Enter Insurance in the Description column in the fir...

  • Page 191

    CBS PayCheck Client Bookkeeping Solution Tutorial 181 12. Click Save and close the PayCheck Items window. 13. In the Employee Templates window, click the Details button associated with the newly created Insurance item. 14. In the Additional Template-level Employee Deduction Item Information d...

  • Page 192

    CBS PayCheck 182 Client Bookkeeping Solution Tutorial PayCheck departments CBS uses PayCheck departments for reporting purposes and for distributing certain payroll setup information to individual employee records. You can set up departments to reflect actual departments in your company, or you ...

  • Page 193

    CBS PayCheck Client Bookkeeping Solution Tutorial 183 Edit PayCheck employee records 1. Cho ose Setup / PayCheck Employees. 2. Select 2 from the ID drop-down list. 3. Click the Personal tab and select Single from the Marital status drop-down list. 4. Click the Departments tab. Select Sales fro...

  • Page 194

    CBS PayCheck 184 Client Bookkeeping Solution Tutorial 10. Click the Benefits tab. Notice that the Tutoring department is now listed first. CBS lists the Home department first. 11. Click the Earnings tab and enter 10. in the Rate column for the Wages item for both departments. 12. Click the Tax...

  • Page 195

    CBS PayCheck Client Bookkeeping Solution Tutorial 185 17. In the Additional Employee-Level Deduction Item Information dialog, select 230 from the GL Account drop-down list. 18. Enter 5. in the Percent field. 19. Click OK to return to the PayCheck Employees window. 20. Click Save. Add a new empl...

  • Page 196

    CBS PayCheck 186 Client Bookkeeping Solution Tutorial 2. Click the Personal tab and select Single from the Marital status drop-down list. By default, CBS will use the single federal tax table for this withholding item. 3. Select Female from the Gender drop-down list. 4. Click the Departments ta...

  • Page 197

    CBS PayCheck Client Bookkeeping Solution Tutorial 187 7. Delete the data in the Sales Dpt field. You will select the sales department for Julie in the “CBS Accounts Receivable” chapter of this tutorial. 8. Click the Benefits tab. 9. The Vacation item is selected in the first blank row in t...

  • Page 198

    CBS PayCheck 188 Client Bookkeeping Solution Tutorial 16. Click OK to return to the PayCheck Employees window. 17. Select 510 for the GL Account associated with the Vacation item. 18. Click the Tax W/H and Deds tab. Notice that the Insurance item from the template is included. Also notice tha...

  • Page 199

    CBS PayCheck Client Bookkeeping Solution Tutorial 189 23. Click Save and then close the PayCheck Items window. 24. In the PayCheck Employees window, enter 100. in the Amount column. This tells the program that 100% of Julie’s net paycheck amount will be deposited. 25. Click the Direct Deposit...

  • Page 200

    CBS PayCheck 190 Client Bookkeeping Solution Tutorial 28. Click OK to return to the PayCheck Employees window. 29. Enter or select the following information in the Direct Deposit distribution grid. Account Number 7911291359 Account Type Checking Method Percent Amt / Percent 100 Status Approved

  • Page 201

    CBS PayCheck Client Bookkeeping Solution Tutorial 191 30. Click Save and close the PayCheck Employees window. Tips You can have CBS automatically delete inactive employee records at year-end. Simply enter a date in the Inactive date field on the Personal tab of an employee record to activate...

  • Page 202

    CBS PayCheck 192 Client Bookkeeping Solution Tutorial Transfer changes to multiple employee records You can quickly add, update, or delete data for multiple employees at the same time using the Transfer Changes to Employees dialog. 1. Cho ose Tasks / Transfer Changes To Employees. 2. Select the...

  • Page 203

    CBS PayCheck Client Bookkeeping Solution Tutorial 193 5. Click Continue. In the Select Employees to Transfer Changes To dialog, verify that all employees appear in the Selected Employees pane. 6. Click the Finish button. Click OK when the program prompts you that the employee records have been...

  • Page 204

    CBS PayCheck 194 Client Bookkeeping Solution Tutorial Enter PayCheck checks 1. Cho ose Checkbook / PayChecks / Payroll Bank. 2. In the PayChecks data-entry window, enter 5/31/07 in the Date and Period End Date fields. 3. Select 1 from the ID drop-down list. Notice that CBS automatically fills ...

  • Page 205

    CBS PayCheck Client Bookkeeping Solution Tutorial 195 6. Click the Close button. 7. Click Save to save the unprinted check. 8. Select 2 from the ID field. Since Marshall is an hourly employee you will need to enter the number of hours he worked before the program can calculate amounts for his ...

  • Page 206

    CBS PayCheck 196 Client Bookkeeping Solution Tutorial 14. Choose Setup / PayCheck Items. (Keep the Checkbook data-entry window open, but do not save the check.) 15. Press F4 in the Description field and select 401(k) % of Gross. 16. Mark the Department specific calculation checkbox. 17. Clic...

  • Page 207

    CBS PayCheck Client Bookkeeping Solution Tutorial 197 3. Notice that the program displays the check for Marshall Mortenson with the combined total amounts. Close the Preview window. 4. In the Queue Reports dialog, mark the Unprinted Checks report checkbox and click the associated Options butto...

  • Page 208

    CBS PayCheck 198 Client Bookkeeping Solution Tutorial 5. In the Unprinted Checks dialog, mark the Check list checkbox in the Format group box and select Department #/Employee ID from the drop-down list in the Print Order field. 6. Click OK to close the Options dialog. 7. In the Queue Reports d...

  • Page 209

    CBS PayCheck Client Bookkeeping Solution Tutorial 199 12. In the Select PayCheck Checks dialog, click the Select All button. 13. Click OK. 14. In the Print Checks dialog, click the Print button. 15. In the Check Printing dialog, notice that the Check Date and Period end date fields are grayed ...

  • Page 210

    CBS PayCheck 200 Client Bookkeeping Solution Tutorial 17. Click Continue. 18. The program displays a message prompt asking if all checks printed successfully. Click Yes. 19. CBS displays a message prompt informing you that one new payable was created. You will learn about PayCheck payables in ...

  • Page 211

    CBS PayCheck Client Bookkeeping Solution Tutorial 201 4. In the PayChecks data-entry window, highlight the unprinted check for Charles Ingram. 5. Click the Options button and click the PayCheck Calculation tab. 6. Clea r the Federal withholding checkbox in the Calculations and accruals group box...

  • Page 212

    CBS PayCheck 202 Client Bookkeeping Solution Tutorial 14. Click OK. Notice that the program now displays the account numbers for the pay items in the grid. 15. Place your cursor in the Date field and then press the TAB key until the cursor is in the Reg Hrs field. Note that the cursor did not s...

  • Page 213

    CBS PayCheck Client Bookkeeping Solution Tutorial 203 5. Close the Preview window and click the Payroll Journal Options button again. 6. In the Payroll Journal dialog, clear all checkboxes and then select Department from the Print Order drop-down list. 7. Click OK. 8. In the Queue Reports di...

  • Page 214

    CBS PayCheck 204 Client Bookkeeping Solution Tutorial 14. Close the Preview window and the Queue Reports dialog. View employee paycheck details 1. Cho ose Setup / PayCheck Employees. 2. Select 2 from the ID drop-down list.

  • Page 215

    CBS PayCheck Client Bookkeeping Solution Tutorial 205 3. Click the Details button. The program displays the earnings detail for the employee. The information on the Earnings report is the same as the information in this dialog. 4. Mark all three checkboxes in the Periods to show group box. 5. Ch...

  • Page 216

    CBS PayCheck 206 Client Bookkeeping Solution Tutorial

  • Page 217

    Client Bookkeeping Solution Tutorial 207 15 CBS Accounts Payable CBS Accounts Payable is an optional module that enables you to enter information about each of your payables, to schedule payments, and to track discount deadlines and total discount amounts taken or lost. With CBS Accounts Payabl...

  • Page 218

    CBS Accounts Payable 208 Client Bookkeeping Solution Tutorial 2. Click Save. 3. Close the Payment Terms window. Tip If you choose the End-of-month (EOM) option for the discount date or due date, you can have the program calculate the discount date or due date based on a specific number of day...

  • Page 219

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 209 If you want the date to be a specific end-of-month date, leave this field blank and specify the appropriate month in the Month to be based on field. For more information on setting up payment terms, search on Payment terms:Setting up ...

  • Page 220

    CBS Accounts Payable 210 Client Bookkeeping Solution Tutorial Set up a recurring payable A recurring payable is a fixed expense, such as rent or a loan payment, that you incur on a regular basis. You can set up CBS to automatically create invoices for these payables, saving you time and preventi...

  • Page 221

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 211 14. In the AP Vendors window, click Save and then return to the Memorized Transactions window. 15. Enter $600.00 in the Amount field. 16. Select 260 from the Account column in the first distribution row of the Distributions tab. 17. E...

  • Page 222

    CBS Accounts Payable 212 Client Bookkeeping Solution Tutorial 23. Click Save. Set up a PayCheck vendor As demonstrated earlier, CBS Accounts Payable tracks payables for your payroll tax liability for your PayCheck vendors when you print a paycheck, save a paycheck as handwritten, or void/delet...

  • Page 223

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 213 7. Enter Payroll in the Ven desc field. 8. Click the Payable Setup tab. 9. Mark the PayCheck vendor checkbox. 10. Click the Distributions tab. 11. Select 233 from the drop-down list in the Account column for the first distribution row...

  • Page 224

    CBS Accounts Payable 214 Client Bookkeeping Solution Tutorial Notes You can use each GL liability account for only one PayCheck vendor. If you delete or void a check in CBS PayCheck and there is an invoice for the tax liability, CBS will create a negative payable to offset that liability for A...

  • Page 225

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 215 4. CBS displays a message prompt asking if you would like to update the invoice date to match the AP date. Click No. 5. In the AP Transactions window, create a vendor check record using the following information. Type Payable Ven ID ...

  • Page 226

    CBS Accounts Payable 216 Client Bookkeeping Solution Tutorial Row 2: Gross $65.00 Row 3: Account 646 Row 3: Description Use default description. Row 3: Gross Use default amount. 7. Click Save. Create an on-demand AP transaction 1. Cho ose Tasks / Create On Demand Transactions / Payable transac...

  • Page 227

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 217 3. In the Update & Confirm Transactions to Create dialog, verify that the checkbox is marked for the GMAC transaction and click OK.

  • Page 228

    CBS Accounts Payable 218 Client Bookkeeping Solution Tutorial 4. CBS displays a message prompt informing you that it has finished creating transactions. Click OK. Enter invoices 1. In the AP Transactions window, use the following information to create an invoice. Type Payable Ven ID LAWN Date 5...

  • Page 229

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 219 3. Create another invoice for LAWN using the following information. Type Payable Ven ID LAWN Note: You can press ENTER with your cursor in the Ven ID field to use the same ID as the last transaction. Date 5/24/07 Note: You can press t...

  • Page 230

    CBS Accounts Payable 220 Client Bookkeeping Solution Tutorial 7. Click Save. Add a new vendor on the fly The program allows you to add new vendors on the fly during accounts payable data entry. 1. In the AP Transactions window, enter Smiths in the Ven ID field. 2. When you move the cursor to t...

  • Page 231

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 221 4. Be sure that the 1099 checkbox is marked, and select Nonemployee compensation from the Item default drop-down list. 5. Click the Save button. 6. Press CTRL + F6 to return the AP Transactions window. 7. Enter 1001 in the Ref # field...

  • Page 232

    CBS Accounts Payable 222 Client Bookkeeping Solution Tutorial View 1099 totals 1. Highlight one of the LAWN transactions in the listview pane and choose Edit / Vendor Detail / 1099 Totals. CBS tracks 1099 totals for each vendor. You can use this dialog to view the 1099 amounts for LAWN for the c...

  • Page 233

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 223 Attach a note to a transaction You can attach a note to any transaction for your accountant to review. The note will be exported along with the transaction. You can edit or delete the note any time before exporting data to your accoun...

  • Page 234

    CBS Accounts Payable 224 Client Bookkeeping Solution Tutorial Enter manual payments In CBS, you can record payments for an open payable in the AP Transactions window. Apply a payment to a specific open payable by selecting the open payable and entering the payment information on the Payments ...

  • Page 235

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 225 Use best match. CBS will look for a payable that exactly matches the payment amount. If no match is found, the program will apply the payment to the oldest outstanding balance. Handwritten checks You are going to record a handwritte...

  • Page 236

    CBS Accounts Payable 226 Client Bookkeeping Solution Tutorial 6. Click Save. Because you entered this check as a handwritten check, you will need to apply the payment to the appropriate open invoice(s). Cash payments 1. In the AP Transactions window, highlight the $35.00 open payable for Greensc...

  • Page 237

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 227 Credit memos 1. In the AP Transactions window, highlight the open payable for Smith’s Garage and click the Payments tab. 2. Select Credit Memo from the Type column. 3. Select 663 from the Credit GL Acct column. 4. Enter 2345 in the ...

  • Page 238

    CBS Accounts Payable 228 Client Bookkeeping Solution Tutorial Prepayments There may be times when you need to issue a prepayment check to a vendor even though you have not received an invoice. Note: A prepayment record will remain in the company database after you print the check. You can then m...

  • Page 239

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 229 7. Click OK. 8. Click the Print/Pay button. 9. In the Check Printing dialog, click the Edit Memo to Payee button. 10. In the Edit Memo to Payee dialog, enter Reference books in the Memo column for the Carlson Publishing invoice.

  • Page 240

    CBS Accounts Payable 230 Client Bookkeeping Solution Tutorial 11. Click OK. 12. In the Check Printing dialog, click Continue. 13. When the program displays a message prompt asking if all checks printed successfully, click Yes. AP journal entries If you record a payment in CBS that does not cre...

  • Page 241

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 231 3. Close the Journal entries window and any other open windows. Apply AP payments When you are ready to pay invoices, you can use the Apply AP Payments dialog to select open payables for full or partial payment. 1. Open the Apply Pa...

  • Page 242

    CBS Accounts Payable 232 Client Bookkeeping Solution Tutorial 2. Notice the checkboxes in the Pay column. Because the Automatically consolidate selected checks to the same vendor checkbox is marked on the Accounts Payable tab of the File / Company Properties dialog, you can simply mark the check...

  • Page 243

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 233 5. Click the Apply Pmt button to apply the payment to the invoices. 6. Click OK to close the Apply AP Payments dialog. Tips You can sort the transactions displayed in the Apply AP Payments dialog by choosing Sort Based on Vendor ID...

  • Page 244

    CBS Accounts Payable 234 Client Bookkeeping Solution Tutorial Print AP checks 1. Cho ose File / Print Checks and then click the Accounts Payable tab. 2. In the AP Check Options group box, clear the Automatically consolidate selected checks to the same vendor checkbox. 3. Click the Select/Apply...

  • Page 245

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 235 4. Select Check 1 Pay with first check from the drop-down list in the Pay column associated with the Office Depot invoice. 5. Click OK. Note: If there were two invoices for OFFICE, you could consolidate the two by selecting Check 1...

  • Page 246

    CBS Accounts Payable 236 Client Bookkeeping Solution Tutorial Remove a payment 1. Open the AP Transactions window. If CBS displays a message prompt informing you that the system date is different from the AP date and asking if you would like to change the AP date, click No. 2. Select the transac...

  • Page 247

    CBS Accounts Payable Client Bookkeeping Solution Tutorial 237 Accounts Payable reports 1. Cho ose File / Queue Reports and then click the Accounts Payable tab. 2. Mark the Aging Schedule checkbox and click the associated Options button. 3. In the AP Aging Schedule Options dialog, choose the All ...

  • Page 248

    CBS Accounts Payable 238 Client Bookkeeping Solution Tutorial

  • Page 249

    Client Bookkeeping Solution Tutorial 239 16 CBS Accounts Receivable CBS Accounts Receivable is an optional module that is designed to help you manage receivables by providing flexible, powerful, solutions for completing daily tasks, summarizing customer activity, and reporting critical sales in...

  • Page 250

    CBS Accounts Receivable 240 Client Bookkeeping Solution Tutorial Set up sales tax entities CBS allows you to set up an unlimited number of sales tax entities in order to calculate state and local sales taxes that apply to the products and/or services that your company provides. 1. Cho ose Setup ...

  • Page 251

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 241 For more information on sales tax entities, search on Sales tax:setting up sales tax from the Index tab of the Help Topics dialog. Set up finance charges CBS allows you to set up finance charges that you can use to assess a fee fo...

  • Page 252

    CBS Accounts Receivable 242 Client Bookkeeping Solution Tutorial 3. Click Save and then close the Finance Charges window. Tip Enter the minimum outstanding invoice amount allowed in order for your company to assess this finance charge. For example, if you do not want to calculate finance char...

  • Page 253

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 243 Set up a new sales department CBS uses Sales Departments for transaction reporting purposes. By default the program uses the Sales Department assigned to the customer (on the Invoice Information tab of the Setup / Customers window)...

  • Page 254

    CBS Accounts Receivable 244 Client Bookkeeping Solution Tutorial Set up invoice items In CBS, you can set up four different types of invoice items for the products and services you sell to your customers. An Item is a product or item you sell to your customers. A Service is a service you prov...

  • Page 255

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 245 3. Click Save. 4. Set up another invoice item using the following information. ID AR CREDIT Type Credit Description AR tutoring credit 5. Click the Format text button. 6. In the Description Editor, highlight the text and change t...

  • Page 256

    CBS Accounts Receivable 246 Client Bookkeeping Solution Tutorial 8. Click OK to close the Description Editor. 9. In the Invoice Items window, select 410 from the drop-down list in the Sales field in the GL Accounts group box. 10. Mark the Tax exempt checkbox, and then click Save. 11. Enter anot...

  • Page 257

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 247 2. Enter the following information in the Customers window. ID BOOK Name Bookkeeping Wonders Type Service (Click Yes when prompted to add the item.) 3. Enter the following information on the General tab. Address 100 Main Street D...

  • Page 258

    CBS Accounts Receivable 248 Client Bookkeeping Solution Tutorial 4. Click the Invoice Information tab and enter the following information. Sales Tax ID MI Payment Terms DuDate Finance Charge 15% Sales Dept Sales Sort Code Manual (Click Yes to add to the list.) 5. Click the Account Status tab an...

  • Page 259

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 249 6. Click the Shipping tab. 7. Enter OFFICE in the ID field. The program will prompt you to add it to the system. Click Yes. 8. Enter FedEx in the Method field and choose to save it to the system. 9. Click the Details button, and ...

  • Page 260

    CBS Accounts Receivable 250 Client Bookkeeping Solution Tutorial 10. Click OK to close the Shipping Address dialog. 11. In the Customers window, click Save. Note: If your accountant set up the Shipping GL account number in the File / Company Properties dialog, the program will automatically ent...

  • Page 261

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 251 9. Select MUSIC from the ID drop-down list. 10. Select DuDate from the drop-down list in the Payment Term field. 11. Select 15% from the drop-down list in the Finance Charge field. 12. Enter Sort-1 in the Sort code grid. CBS displa...

  • Page 262

    CBS Accounts Receivable 252 Client Bookkeeping Solution Tutorial 3. Place your cursor in the text editing section and enter the following message in the text entry section. Please remit payment. If you have already mailed the payment, thank you! 4. Highlight the text and change the font to 12 p...

  • Page 263

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 253 2. Cho ose Edit / Receivable Data Entry Options or click the Options button. 3. In the Receivable Data Entry Options dialog, choose the Memorized option in the Set data entry mode group box. 4. Click OK to close the Receivable Da...

  • Page 264

    CBS Accounts Receivable 254 Client Bookkeeping Solution Tutorial 7. Enter the following information on the Memorized Transaction tab. ID ACCT PLUS Frequency On Demand 8. Click the Items tab and enter the following information. Item Quantity AR TEXT Change quantity to 0 AR INSTRUCT Change quant...

  • Page 265

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 255 Enter receivable transactions You can use the Receivable Transaction window to enter invoices and payments. Enter the following information. 1. In the Receivable Transactions window, select I (Invoice) from the drop-down list in th...

  • Page 266

    CBS Accounts Receivable 256 Client Bookkeeping Solution Tutorial 8. Click the Items tab and enter the following information. Item Quantity TEXTBOOK AR TEXT 4. AR INSTRUCT 1. Blank Line TUTOR AR Tutor

  • Page 267

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 257 Notes CBS automatically enters the price and description using the information in the invoice item record. CBS prints the items on an invoice in the exact order you select them on the Items tab of the Receivable Transactions wind...

  • Page 268

    CBS Accounts Receivable 258 Client Bookkeeping Solution Tutorial 8. Mark the Final checkbox. Notice that the Applied Payments tab appears. Note: Before you can apply a payment to an invoice, you must finalize both the invoice and the payment. 9. Click Save. 10. The program displays a message pro...

  • Page 269

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 259 Notes The Credit type invoice items are included in the drop-down list on the Items tab only when you are entering a M (Credit Memo) type receivable transaction. Enter all amounts for Credit memos as positive amounts. Because th...

  • Page 270

    CBS Accounts Receivable 260 Client Bookkeeping Solution Tutorial 12. Click the Computations tab. 13. Enter 40. in the Amount field in the Discount group box. Notice that CBS changes the text color to red. This is because the program displays all override amounts in red. 14. Click Save. Note: If...

  • Page 271

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 261 Enter a customer payment Enter a check payment 1. In the Receivable Transactions window, enter the following transaction information. Type K (Check, PMT) ID BOOK Ref # 2345 Date 5/31/07 2. On the Payment Information tab, enter 309...

  • Page 272

    CBS Accounts Receivable 262 Client Bookkeeping Solution Tutorial Enter a cash payment 1. Enter the following transaction information. Type C (Cash, PMT) ID MUSIC Ref # Cash Date 5/20/07 2. On the Payment Information tab, enter $250.00 in the Payment total field. 3. Mark the Final checkbox, and ...

  • Page 273

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 263 Notes CBS displays this prompt when there are open, finalized invoices and open, finalized payments in the database. If you want to apply payments later, you can mark the Turn off this prompt for the current session checkbox. If...

  • Page 274

    CBS Accounts Receivable 264 Client Bookkeeping Solution Tutorial 4. Mark the Final checkbox. CBS displays the Apply Payments tab. 5. Click the Applied Payments tab and enter the information below. Row 1 Date 5/31/07 Reference # POS 1234 Type R Credit Card Vendor Visa (add to list) Amount Appli...

  • Page 275

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 265 6. Click Save. Issue a customer refund If you need to issue a refund to your customer for an overpayment or return of merchandise, or if your customer is dissatisfied with a purchase and requests a refund, you can use the Edit / I...

  • Page 276

    CBS Accounts Receivable 266 Client Bookkeeping Solution Tutorial Enter a historical invoice to assess a finance charge Now you are going to create an invoice dated in the past so that you can see how CBS assesses finance charges. 1. Select I (Invoice) from the drop-down list in the Type field. ...

  • Page 277

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 267 5. Click OK. 6. In the Finance Charge Confirmation dialog, the program will assess a finance charge of $2.94 on customer A1’s account because the customer has not yet paid their invoice.

  • Page 278

    CBS Accounts Receivable 268 Client Bookkeeping Solution Tutorial Notes Because this is the first time you are assessing finance charges for this customer, the Last Date customer was assessed as of field is blank. CBS divides the amounts subject to finance charge by 365 days and multiplies that...

  • Page 279

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 269 12. Select Inv from the drop-down list in the Form Type column. 13. Notice that the program automatically entered 3 in the # of forms to print column and Pending in the Selection Filter column. 14. Click the Edit Messages button...

  • Page 280

    CBS Accounts Receivable 270 Client Bookkeeping Solution Tutorial 16. Click OK to close the dialog. 17. In the Print Forms dialog, click the Print button. 18. After printing the invoices, the program displays the message prompt asking if all items printed successfully. Click Yes. Note: For more...

  • Page 281

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 271 View a customer’s open balances and YTD balances You can view customer account balance information for any customer at any time from either the Receivable Transactions window or the Customers window. 1. In the Receivable Trans...

  • Page 282

    CBS Accounts Receivable 272 Client Bookkeeping Solution Tutorial 3. In the Display totals for fields, enter 01/01/07 and 05/31/07 in the date range fields. 4. Click the Refresh Totals button. 5. Click the Done button. 6. Cho ose Edit / Customer Detail / Open Balances. 7. By default, the progr...

  • Page 283

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 273 9. Close the Receivable Transactions window. Note: To access these customer balances dialogs from the Customers window, highlight the customer whose balances you’d like to view, and then choose Edit / View Open Balances or Edit /...

  • Page 284

    CBS Accounts Receivable 274 Client Bookkeeping Solution Tutorial 5. Click the Apply Pmt button. 6. Click OK to close the Apply Customer Payment dialog. Note: The Apply Customer Payments dialog displays only those customers with both final unapplied payments and final open invoices. Record a dep...

  • Page 285

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 275 3. Enter $50.00 in the Amount field in the Deposit reduction group box. Notice that the program automatically entered 109 in the GL account field. This is the account specified in the Deposit reductions field in the File / Company ...

  • Page 286

    CBS Accounts Receivable 276 Client Bookkeeping Solution Tutorial 8. You do not need to print a deposit slip at this time, so click Cancel to return to the Deposits dialog. 9. Click the Make Deposit button and then close the Deposits window. 10. Choose Checkbook / Open / Checking Account. Notice...

  • Page 287

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 277 11. Close all open CBS windows. Print customer statements After printing the invoices, you can print the customer statements. A statement is a summary of what a customer owes your company. It usually includes the beginning open ba...

  • Page 288

    CBS Accounts Receivable 278 Client Bookkeeping Solution Tutorial 5. Select Open Balance from the drop-down list in the Selection filter column. 6. Click the Refresh button. Notice that there are three statements to print. 7. Click the Details button. 8. In the Select Statements to Print dialog,...

  • Page 289

    CBS Accounts Receivable Client Bookkeeping Solution Tutorial 279 Note: If you selected Customer or Contact in the Email to use for AR form delivery field on the General tab of a customer’s record, you can email the statement to that address by marking the Email checkbox. When you click the Pri...

  • Page 290

    CBS Accounts Receivable 280 Client Bookkeeping Solution Tutorial 5. Click Save and then click OK. Note: Most CBS Accounts Receivable reports include a Limit selection to group box, so you can specify filter criteria for individual reports. 6. In the Queue Reports dialog, mark the Invoice / Payme...

  • Page 291

    Client Bookkeeping Solution Tutorial 281 17 Export to Accountant Once you have finished entering transactions for the processing period, you must export these transactions to your accountant for processing. Your accountant will then retrieve your transactions into his/her accounting software an...

  • Page 292

    Export to Accountant 282 Client Bookkeeping Solution Tutorial 6. Note that the report shows transactions for all checkbooks. Because the checkbook adjustments do not transfer to your accountant, they do not show up on the report, and the Net Change for account 101 will not match the Checkbook b...

  • Page 293

    Export to Accountant Client Bookkeeping Solution Tutorial 283 3. In the Modify Location dialog, scroll to the top of the folders list, highlight Desktop, and click OK. 4. In the Options dialog, highlight the path in the Export to Accountant field, right-click in the field, and choose Copy from t...

  • Page 294

    Export to Accountant 284 Client Bookkeeping Solution Tutorial Important! If the Next Export Date is beyond the system date (today’s date), the program will display the following warning prompt when you click the Continue button. DO NOT ignore this message. Click No and contact your accountant....

  • Page 295

    Export to Accountant Client Bookkeeping Solution Tutorial 285

  • Page 296

    Export to Accountant 286 Client Bookkeeping Solution Tutorial

  • Page 297

    Client Bookkeeping Solution Tutorial 287 18 Proper Database Maintenance At the end of each CBS processing period, just before you create the export disk for your accountant, the program prompts you to make a backup copy of your data to save as an archive or send to your accountant with the expo...

  • Page 298

    Proper Database Maintenance 288 Client Bookkeeping Solution Tutorial 2. Click Save. If you discover that you need to make a correction to one or more transactions that have already been exported, be sure to consult with your accountant before proceeding. You may view exported transactions as h...

  • Page 299

    Proper Database Maintenance Client Bookkeeping Solution Tutorial 289 Delete old transactions At the end of the year you may want to remove prior-year transactions from the database. This is not necessary, but it may help to improve performance. Important! Be sure you back up your data before de...

  • Page 300

    Proper Database Maintenance 290 Client Bookkeeping Solution Tutorial Close and compact the database By default, when you close CBS, the program automatically compacts the company database to clean up temporary files and reduce the size of the data file. This will improve performance and decrease...

  • Page 301

    Client Bookkeeping Solution Tutorial 291 Appendix: Downloading and Applying CBS Software Updates Download CBS software updates From time to time your accountant may ask you to update your CBS program files. If you have access to the Internet and your accountant has set up your CBS software to a...

  • Page 302

    Appendix: Downloading and Applying CBS Software Updates 292 Client Bookkeeping Solution Tutorial 2. In the CBS Connect window, choose the Download now option, and then click the Download button. If there are any updates available, CBS will display the list of updates. After the updates have been...

  • Page 303

    Appendix:Downloading and Applying CBS Software Updates Client Bookkeeping Solution Tutorial 293 3. Use the Look in field to browse to the appropriate file. Highlight the appropriate ZIP file and click the Restore button. 4. The program will display a message prompt asking if you want to apply t...

  • Page 304

    Appendix: Downloading and Applying CBS Software Updates 294 Client Bookkeeping Solution Tutorial