Contents - Index


Tools: Location - Settings

This is used to maintain data specific to a location or multiple locations.

Location settings is an extension of location maintenance. It allows you to set up settings (such as ledger accounts) that affect only selected locations. For ALMSYs to properly function, you should have a setting for new deals, one for billing, and one for ledger accounts.

The screen is laid out with a list of the existing location settings definitions in the blue grid on the left. Once a setting is created (via the button), a panel will appear with that settings' fields, followed by a list of available locations which may be assigned to this setting. In order for a setting to take affect, it must have locations assigned to it.

When you add a new setting, you must first choose from the following categories:
  • Billing  These are default billing settings for new deals, as well as billing settings for statements.
  • CC/ACH These are control settings for credit card/automated clearing house (EFT) and are used when exporting batches to your bank.
  • Credit Bureau  These are control settings for reporting to the credit bureau(s).
  • New Deal  These are new deal defaults (for both leases and loans).
  • Ledger These are ledger account settings.

    For CC/ACH, choose from the list of available interfaces presented.

    Billing
    The Remit Payments To field is used to convey the name of the entity to which that the lessee is to make checks payable.

    The Return Mailing Address is used to override the location's main address for printing on statements and coupons.

    The Broadcast Message on Each Statement area represents five lines of sixty characters that will print at the bottom of each billing statement.

    Overriding Report Templates
    If you have the need to different statement/report templates for different locations, then you may specify the overriding template names in the spaces provided. (For example, you would want to override these templates if you had a different logo for different locations.)

    In order to override a report template:
  • ALMSys Support will create the template for you
  • ALMSys Support will create the "QueryMaster" entry so your template may be viewed

    CC/ACH: ATB1464
    This is used to maintain the ATB1464 (ATB Financial Canada) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with ATB. Please contact them directly and tell them that you are establishing an "CPA005 / CPA1464" interface.

    Customer Number: This is the 10-character number assigned to you by ATB Financial.
    Customer Name: A 30-character name for your business. It will be uppercased for you.
    Customer Name (Short): A 15-character name for your business. It will be uppercased for you.
    Scotiabank Data Center: This is the 5-digit code for the ATB data center that will be processing your file.
    Transit Routing Number: This is a 9-digit number that of the format 0YYYXXXXX, which is a zero, followed by the 3-digit institution number, followed by the 5-digit branch number. (ATB's institution number is 219, so your code will most likely start with "0219.")
    Account Number: The account number into which the funds will be deposited from your customers.
    Last File Number Used: The file number increments for each batch created. ATB wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.
    Are you creating a test file? Initially, ATB will want to see a test file to make sure all is well. Set this to Yes before exporting the batch in order to create a test file. Once approved, set it back to No. You must coordinate all test submissions with ATB.

    CC/ACH: CIBC80
    This is used to maintain the CIBC (Canadian Imperial Bank of Commerce) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with CIBC. Please contact them directly and tell them that you are establishing a CIBC80 interface.

    Destination Data Center: This is the first 5 digits of the originator number assigned to you by CIBC.
    Originator Number: This is assigned to you by CIBC.
    Transit Routing Number: This is a 9-digit number that of the format 0YYYXXXXX, which is a zero, followed by the 3-digit institution number, followed by the 5-digit branch number. (CIBC's institution number is 010, so your code will most likely start with "0010.")
    Account Number: The account number into which the funds will be deposited from your customers.
    Originator's Short Name: A 15-character name for your business.
    Currency Type: This should be set to CAD (Canadian Dollars).
    Last File Number Used: The file number increments for each batch created. CIBC wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.

    CC/ACH: HSBC1464
    This is used to maintain the HSBC1464 (HSBC Bank Canada) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with HSBC. Please contact them directly and tell them that you are establishing an "CPA005 / CPA1464" interface.

    Customer Number: This is the 10-character number assigned to you by HSBC.
    Customer Name: A 30-character name for your business. It will be uppercased for you.
    Customer Name (Short): A 15-character name for your business. It will be uppercased for you.
    Scotiabank Data Center: This is the 5-digit code for the HSBC data center that will be processing your file.
    Transit Routing Number: This is a 9-digit number that of the format 0YYYXXXXX, which is a zero, followed by the 3-digit institution number, followed by the 5-digit branch number. (HSBC's institution number is 016, so your code will most likely start with "0016.")
    Account Number: The account number into which the funds will be deposited from your customers.
    Last File Number Used: The file number increments for each batch created. HSBC wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.
    Are you creating a test file? Initially, HSBC will want to see a test file to make sure all is well. Set this to Yes before exporting the batch in order to create a test file. Once approved, set it back to No. You must coordinate all test submissions with HSBC.

    CC/ACH: NACHA
    This is used to maintain the NACHA (National Automated Clearing House Association) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in the US. You must coordinate setting up this interface with your bank. Not all banks use this type of interface, as it is too generic for some. Please contact them directly and ask them if they support an NACHA interface. They may or may not have a guide that assists you in filling out the fields on this screen.

    Immediate Destination: This is a 10 character field that is a space, followed by the 9-digit transit routing number for the account in which the deposits are to be made.
    Immediate Origin: Contact the bank for this information.
    Destination ACH (Name): A 23-character name for the bank receiving the deposits.
    Origin ACH (Name): A 23-character name for your business.
    Company (Name): A 23-character name for your business.
    Company I.D.: This is "1" followed by your tax i.d. number (no punctuation).
    Entry Description: A 10-character name describing the reason for the transaction. (i.e. "LEASE PMT")
    Discretionary Data: A optional 20-character field that further describes the transaction.
    Originating DFI: An 8-character field which is usually comprised of the first 8 digits of the bank's transit routing number.
    Reference Code: An optional 8-character field that is used in the header record. Consult your bank before using this field.
    Trace Prefix: An 8-digit field that is used in the generation of a unique record i.d. for each detail record. Typically, this is the first 8 digits of the bank's transit routing number. Contact the bank for assistance.
    Balanced Batch: A balanced batch is like an accounting journal, where the debits and credits add up to zero. In this case, the debits are all of your customers and the offsetting credit is YOUR account. Therefore, you must also supply your transit routing number and account number in order for a balanced batch to work correctly.
    Transit Routing Number: For balanced batches only, the transit routing number for your checking account.
    Account Number: For balanced batches only, the account number for your checking account.
    Settlement Date Default: By default, the settlement date is set to today. You can tell the program to default it to tomorrow. When you create the NACHA batch, it will ask you for the settlement date. You may change it at that time if needed.

    CC/ACH: RBC152
    This is used to maintain the RBC152 (Royal Bank of Canada) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with RBC. Please contact them directly and tell them that you are establishing an RBC152 interface.

    Client Number: This is the 6-digit number assigned to you by RBC. This number is to be followed by four zeroes.
    Client Name: A 30-character name for your business. It will be uppercased for you.
    Client Name (Short): A 15-character name for your business. It will be uppercased for you.
    Currency Type: This should be set to CAD (Canadian Dollars).
    Use control number instead of customer + deal?: On the export record for each customer, this is the reference that the customer will see. By default, it is the customer's account number followed by the deal number. If you have assigned unique control numbers to each deal, then you may choose to use the control number instead.
    Last File Number Used: The file number increments for each batch created. RBC wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.
    Are you creating a test file? Initially, RBC will want to see a test file to make sure all is well. Set this to Yes before exporting the batch in order to create a test file. Once approved, set it back to No.

    CC/ACH: Scot1464
    This is used to maintain the Scot1464 (Scotiabank of Canada) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with Scotiabank. Please contact them directly and tell them that you are establishing an "CPA005 / CPA1464" interface.

    Customer Number: This is the 10-character number assigned to you by Scotiabank.
    Customer Name: A 30-character name for your business. It will be uppercased for you.
    Customer Name (Short): A 15-character name for your business. It will be uppercased for you.
    Scotiabank Data Center: This is the 5-digit code for the Scotiabank data center that will be processing your file.
    Transit Routing Number: This is a 9-digit number that of the format 0YYYXXXXX, which is a zero, followed by the 3-digit institution number, followed by the 5-digit branch number. (Scotiabank's institution number is 002, so your code will most likely start with "0002.")
    Account Number: The account number into which the funds will be deposited from your customers.
    Last File Number Used: The file number increments for each batch created. Scotiabank wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.
    Are you creating a test file? Initially, Scotiabank will want to see a test file to make sure all is well. Set this to Yes before exporting the batch in order to create a test file. Once approved, set it back to No. You must coordinate all test submissions with Scotiabank.

    CC/ACH: TD80
    This is used to maintain the TD80 (TD Bank of Canada) ACH settings. (Please coordinate the setting up of your credit card/ACH processing with ALMSys Support. This setup tends to get very technical and there are protocols/channels that need to be adhered to.)

    This setting is only available in Canada. You must coordinate setting up this interface with TD Bank. Please contact them directly and tell them that you are establishing an "TD EFT 80" interface.

    Originator ID Number: This is the 10-character number assigned to you by TD Bank.
    Originator Short Name: A 15-character name for your business. It will be uppercased for you.
    Transit Routing Number: This is a 9-digit number that of the format 0YYYXXXXX, which is a zero, followed by the 3-digit institution number, followed by the 5-digit branch number. (TD Bank's institution number is 004, so your code will most likely start with "0004.")
    Account Number: The account number into which the funds will be deposited from your customers.
    Last File Number Used: The file number increments for each batch created. TD Bank wants these batches submitted in chronological order, typically starting at 1. To start at 1, this number must be set to zero. It will be incremented for each batch as they are exported.

    Credit Bureau
    This is used to maintain the credit bureau settings for the credit bureau interface file.

    Creditor Name The official name of the creditor reporting the credit bureau information.
    Creditor Class The classification code indicating the general type of business for the Creditor Name.
    Credit Grantor I.D. Used to uniquely identify a credit grantor. Use your internal code to identify each branch, office, and/or credit central where information is verified. This number must be unique and at least 5 digits long. Entire field should never be zero, blank or 9 filled.

    This field must be consistent on a month-to-month basis to avoid duplication of information. Notify credit reporting agencies before adding, deleting, or changing the identifiers in this field.

    Credit Bureau Program Identifiers
    Innovis The unique identification number assigned by this credit reporting agency.
    Equifax The unique identification number assigned by this credit reporting agency.
    Experian The unique identification number assigned by this credit reporting agency.
    Trans Union The unique identification number assigned by this credit reporting agency.

    Credit Bureau Run Options
    Report Bad Only? Turning this on will send only the deals that are currently "bad." "Bad" means that the current month is not a "B," "E," or "0." It does not matter what the prior months' history is; only the current month is used to determine if the deal will be reported or not.

    It is not recommended to use this option as it will not report your customers in good-standing.

    Ledger
    This is used to maintain most of the ledger accounts for the accounting interfaces.

    This screen is used to tell ALMSys what your ledger account numbers are. All of the accounts listed are required to be established on your ledger system.

    If you export billings to an external accounting system (such as XSellerator), then you probably already know that the accounting system typically ignores billings that are marked as being on month (term) #1. The Force Interface to Accept Term 1 Billings check box, when checked, will alter the term #1 billings to state that they are term #2, thus avoiding being excluded from the billings interface.

    Balancing using the Payment Distribution Report
    This section is written in the context of balancing by using the Payment Distribution Report (payments received disbursement). Only the fields in the orange box are required.

    Lease Loans (Principal Asset). This account is debited with the amount lent to the lessee for the lease. Debit this account immediately upon lease start. For loans, this is the principal account for payments.

    Lease Payments (Liability). This account is credited with lease payments made by lessees and is used to balance cash to cash between ALMSys and your ledger. The full payment is placed into this account.

    For an initial payment that includes the security deposit, you must post the security deposit to the Lease Security Deposits Account (described next). Only the payment portion is posted to the Lease Payments account.

    For a lease that rolls in the first payment, your institution is responsible for making this first payment for the deal. This payment is credited to this account and debited against the Lease Loans account.

    For a lease that rolls in the security deposit, your institution is responsible for making the security deposit for the deal. This amount is credited directly to the Lease Security Deposits account and debited against the Lease Loans account.

    This account is not used for loans.

    Lease Interest (Income). This account is credited once per lease term with the interest income for the month. For loans, this is the interest account for payments.
    Lease Late Charges (Income). This account is credited once per lease term with the late fees collected for the month. For loans, this is the late fee account for payments.
    Lease Security Deposits (Liability). This account is used to hold security deposits for leases. Generally, this account is credited with new leases, and debited when leases terminate. For new leases that roll in security deposits, these amounts are credited to this account when the lease is issued and debited against the Lease Loans account. (Not used for loans.)
    Lease Suspense (Suspense Account with Liability). ALMSys does not disburse any payment until a full payment has been made. Any amount that is not considered as a full payment is kept in this account until the full payment has been made. (Not used for loans.)

    Balancing via Receivables
    This section is written in the context of balancing by using the Detail Billed Reports. Each account type has a corresponding offset account. 

    If you export ledger information, then you may use the ledger account sign reverser buttons to reverse the sign on the amount begin exported. Typically, one sign would be positive and one would be negative.

    Lease Loans (Principal Asset). This is the principal income account.
    Lease Payments. Not used for receivables balancing.
    Lease Interest (Income). This is the interest income account.
    Lease Late Charges (Income). This is the late fee income account.
    Lease Security Deposits (Liability). This is the security deposits account.
    Lease Suspense. Not used for receivables balancing.
    Interest Additional Journal. This is used to make an additional interest entry (leases only) for billing journals.
    Lease Cap. Reduction. The capitalized cost reduction account.
    Lease Book Depreciation. The monthly book depreciation account.
    Lease Lev. Fin. Interest. The leveraged financing interest paid account.
    Lease Lev. Fin. Principal. The leveraged financing principal paid account.

    New Deal
    This is used to maintain the new deal default settings.

    The default Calculation Type is used to define the type of deal calculation used in all new deals. "Standard" is not recommended; please use "Standard with Interest" instead.

    The insurance defaults are split between personal and commercial (business) usage. The Minimum columns will be used in conjunction with the Insurance Fax.

    The Default Print Statement controls the setting of the Print Statement box on the billing - overall page when new deals are add

    For Monthly Deals Only ...
    This section allows you to set the default dates for monthly deals.

    When is the first payment due? 
  • Due on Delivery. For a lease, this will set the first payment due date to that of the contract date. For a loan, this will set the first payment due one month out.
  • Due on specific day in the following month, unless that day matches the contract day. Say you want all of your payments due on the 1st. You would mark this option and enter a "1" in the Specific Day field. In turn, if your contract date is May 15th, then the first payment due day would be June 1st. If your contract date if May 1st, then your first payment due date would also be May 1st.

    When is the second payment due? 
  • One month after the First Payment Due Day. Whatever was calculated for the first payment due date, plus one month (on the same day).
  • Due on specific day two months out, unless First Payment Due in on that day. Say you want all of your remaining payments due on the 15th. You would select this option and enter a "15" into the Specific Day field. If your first payment is due on April 28th, then the second payment would be due on June 15th. If your first payment is due on April 15th, then your second payment would be due on May 15th.

    When does the deal end?
  • Traditional. For a lease, this is the lease date plus the term, minus one day. For a loan, this is the due day of the last payment.
  • Last day of month for last payment due. If your last payment is due on August 3rd, the the deal would end on August 31st.