Excel Importation Checkbook Setup
IMPORTANT NOTE: The General Ledger Account for the checkbook MUST exist (in all companies) before attempting to import the checkbooks for those companies.
All rows in the Excel Sheet are to be formated as Text. The importation program will convert to a number as needed.
Spreadsheet Column Explanations:
A: COMPANY – Existing Company Short Name where this new checkbook will be added C(6)
B: CHECKBOOK - The NEW Short Name of the checkbook to be added [maximum 6 characters] C(6)
C: CHKBK LONG NAME - Checkbook Long Name for the screen only C(40)
D: CHKBK COMPANY NAME - Checkbook Company Name for checks & deposit slips C(40)
E: CHKBKCOMPANY ADDRESS1 - Checkbook Address line 1 C(40)
F: CHKBKCOMPANY ADDRESS2 - Checkbook Address line 2 C(40)
G: CHKBK COMPANY ADDRESS3 - Checkbook Address line 3 C(40)
H: CHKBK ROUTING NUMBER - Bank account number for this checkbook C(40)
I: STARTING CHK # - Start Check Number C(20) - Will be converted to a number
J: GL CODE - General Ledger Account Number assigned to this checkbook that you set up.
This must be 6 characters long C(20)-Will be converted to a number
K: RETURN GLCODE - General Ledger Account Number for bank expense -Will be converted to a number
L: BANK VENDOR - Vendor Code assigned to this bank for service charges.
M: BANK SERVICE CHARGE - Check Box for Bank Service Charge for Tenant bounced check 0 - No, 1- Yes
N: BANK SERVICE AMOUNT - Amount your bank charges for a bounce check
O: INC VENDOR ACCT NUM - Check Box to Include Vendor Account Number 0 - No, 1- Yes
P: INC FIRST BREAK - Check Box to Include the first line of the Check Break out O - No, 1- Yes
Q: INC CHECK BREAK - Check Box to Include Check Break out Invoice Numbers O - No, 1- Yes
R: RENT RECEIPT - Buttton Selection for Rent Receipt - O Disabled,1- Enabled Checked,2 - Enabled Box Un-Checked
S: MICR BUS PERS - Buttton Selection for Business Checks or Personal Checks - o - Business.1- Personal
T: TWO SIGNATURE - Buttton Selection for Two Signature 0-1 Signature,1-2 Signatures,3 Transitional,4-3 Signatures
U: TWO SIG IF AMT - Amount for Two Signatures if >$