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 formatted 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. [Use existing BANK vendor]
M: BANK SERVICE CHARGE - Check Box if YOUR Bank charges YOU for a Tenant bounced check 0 - No, 1- Yes
N: BANK SERVICE AMOUNT - Amount your bank charges YOU for a bounce check, if any
O: INC VENDOR ACCT NUM - Check Box to Include Vendor Account Number 0 - No, 1- Yes [Should be 1]
P: INC FIRST BREAK - Check Box to Include the first line of the Check Break out O - No, 1- Yes [Should be 0]
Q: INC CHECK BREAK - Check Box to Include Check Break out Invoice Numbers O - No, 1- Yes [Should be 0]
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 >$
​
YOU WILL ALSO NEED:
-Bank Routing Number
-Bank Fractal Code
-Bank Name for Check and Deposit printing
-Bank Address for Check printing
​
NOTE TO RIS SUPERVISOR:
-Backup Network Folder for safety reasons.
-Also test that the new general ledger account number exists for all companies. Use export codes from Company.