Accountant's Assistant Handbook

Note: The CBS Sample Company.cbs client (included with the 
Client Bookkeeping Solution software) was used for the illustrations 
in the Checkbook reconciliation section.  
2. Click 
the 
Summary tab to enter information from the client’s most 
recent bank statement.  
 

---

 
Client Setup in CBS 
Accountant’s Assistant Handbook 
103 
3. Click 
the 
Add button to enter the uncleared items that are already in 
CSA; select the type for each item (Historical In Transit, Check, 
Deposit, or Other Item).  
 
Importing spreadsheet data 
The CBS spreadsheet import utility allows your client to import the 
following types of data from a Microsoft Excel spreadsheet into CBS: 
ƒ 
Finance charges 
ƒ 
Payment terms 
ƒ 
Sales tax 
ƒ 
Time entry 
ƒ 
CheckWriter transactions 
ƒ 
Customers 
ƒ 
Invoice items 

---

Client Setup in CBS 
 
104 
Accountant’s Assistant Handbook 
 
Choose Utilities / Spreadsheet Import. In the Import Spreadsheet 
Data dialog, select the spreadsheet from which to import data and to 
define the spreadsheet setup. You must enter data in all fields before 
initiating the import process.  
 
For detailed information on importing spreadsheet data in CBS, search 
on Import spreadsheet data:importing spreadsheet data from the 
Index tab of the CBS Help Topics dialog.