Zap Worksheets

Product: WinTAM Series 6 and TAM - Series 7

There are a few different zaps that are available.  They are:

Below are the zap worksheets that Accounting Support strongly recommends that you fill out.  This information is mainly for your use in putting this information back into the system.  The same worksheets are used no matter which zap you are planning on doing.  If an Accounting Support Technician is assisting you with this process, they may require that the following worksheets are faxed into support.  Also if you are making any changes to your month end options, it is suggested that you complete these worksheets to note what changes were made and have all the information you need for this process in one place.

Worksheet - Agency Structure

If you have more than one agency that you are going to zap make additional copies of this worksheet.

Agency #  
Agency Name  
Attn  
City, State, Zip  
Phone Number  
Fiscal Accounting Year  
New Fiscal Accounting Year   

Note:  It is recommended to fill the above agency information out if you are changing the fiscal year.  

Worksheet – Month-End Options 

You should fill out this section of the worksheets only if you want to make changes to your Month-End options.

Month-End Journal Entries

  SYSTEM GENERATED Month-End Journal Entries
  MANUAL Month-End Journal Entries

Agency Bill Accounting

  ACCRUE Agency Bill Income
  CASH BASIS- Include Partially Paid Items
  CASH BASIS- Only Fully Paid Items

Direct Bill Accounting

  ACCRUE Direct Bill Income
  CASH BASIS Direct Bill Income

Producer Payment Method – (Agency Billed Business)

  Pay on INVOICED items
  Pay on PARTIALLY PAID items

if Yes, will you be deferring producer commissions?     Y / N

  Pay on FULLY PAID items

if Yes, will you be deferring producer commissions?    Y / N

  Allocate 100% of commissions to the producers?    Y / N
  Generate Month-End Journal Entries for Producers?     Y / N

Producer Payment Method – (Direct Billed Business)

  Pay on INVOICED items
  Pay on PAID items

If Yes, will you be deferring commissions?     Y / N

Company Payables Reconciliation

  Reconcile company payable items in detail
  Do not reconcile company payable items in detail

Direct Bill Reconciliation

  Transact and do not reconcile 
  Transact and reconcile commissions received
  Do not reconcile, but record commissions received

Income Posting Breakdown

  No breakdown; single account
  By policy status:  NEW, REN, etc.
  By user defined policy type class
  By producer code
  By company code

 Worksheet - Account Groups 

Groups are used to subtotal accounts on your Balance Sheet and Income Statement. For example, you may have many types of Asset Accounts but want to group them into Current Assets, Fixed Assets and Other Assets. Assigning a different group number to the different accounts in your General Ledger allows you to accomplish this.

Example:

Group # Description
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

Worksheet - Chart of Accounts 

You should fill out this section of the worksheets only if you plan to zap your chart of accounts. Make copies of this worksheet to complete entire chart of accounts

Acct # Title Level Type  Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Acct # Title Level Type Group Balance
           

Is account a cash journal? Y / N (If yes, complete cash journal worksheet.)

Worksheet - Cash Journals 

Make a copy for each cash journal you are setting up

Cash Journal #  
GL Account Number  
Bank Account Number  
Total Bank Account Balance  
Last Check Number  
Last Deposit Number  
Last Misc. Withdrawal  
Last Check Printed  

Agencies Sharing Cash Journal

# Agency's portion of balance # Agency's portion of balance # Agency's portion of balance
1 C N
2 D O
3 E P
4 F Q
5 G R
6 H S
7 I T
8 J U
9 K V
A L W
B M  

Worksheet - Required General Ledger Accounts Required 

Required Account Account Number Type Level
Account Receivable   Asset Account
Company Payables Major Account   Liability Title Account
Producer Payable Major Account   Liability Title Account
Agency Fee Income    Income Account/Title Account
Service Charge Income    Income Account/Title Account
Producer Expense   Expense Account
Broker Expense   Expense Account
Bad Debt Expense   Expanse Account
Waive Small Balance   Expense Account
Retained Earnings   Equity Account
Transfer Account   Asset Account
Binder Bill Payables   Liability Account
Pending Payables   Liability Account
Discounts Taken Expense   Expense Account
Payables Write Off   Income or Expense Account
P & C Income    Income Account/Title Account
Direct Bill Commission Receivables

Required only if Accruing Direct Bill

  Asset Account
Direct Bill Commission Income 

Required only if Accruing Direct Bill

  Income Account/Title Account
Unearned Commission Income

Required if on cash basis for Agency Bill

  Asset or Liability Account/Title Account
Earned Commission Income

Required if on cash basis for Agency Bill

  Income Account/Title Account

Notes:

Last Revised:  February 19, 2008 02:20 PM

SWE27150