Curriculum – Factor/SQL® Online Training Program

Getting Started in Factor/SQL®

  • Setting up Corporate Defaults
 
  • User Security
  • Establishing User and Group permissions/restrictions
  • Modifying User and Group security
  • Analyzing fee structures and rate table setup
  • Creating an incremental rate table (IR) with generated and custom tiers
  • Creating a daily rate table (DR) with an set APR or multiple percentages
  • Creating a net funds employed rate table (NFE) with an APR or prime rate; adding prime bank
  • Creating a link rate table (IR +DR)
  • Storing information in Factor/SQL®:
  • Banks
  • Brokers
  • Collectors
  • Standard Charges
  • Verification Codes
  • Tickler Codes
  • Rating Codes
  • Investors
  • Clients
  • Basic setup with single and multiple relations
  • Adding a single or multiple Brokers
  • Setting up tickler reminders
  • Setting up Wire/DDA information
  • Understanding Float/Clearing Days
  • Client Information
  • Debtors
  • Entering a new Debtor manually with single and multiple accounts
  • Importing Debtors through excel
  • Debtor Information
 

Daily Tasks

  • Purchases and Verifications
  • Entering schedules manually and through importing
  • Using Verification Tools:
  • Creating and using Verification Codes
 
  • Invoice approval or rejection
  • Using Factor/SQL® to create invoices (Transportation)
  • Attaching Investors to an invoice
  • Review of Transaction types
 
  • Payments and Reserve Transactions
  • View of daily transaction types
  • Posting full, partial, and over payments
  • Posting discounts, credit memos, and charge backs
  • Posting unapplied cash and non-factored payments
  • Posting to multiple Clients/Debtors from one transaction
  • Reversing a transaction
  • Balancing
  • Review reserve transactions types
  • Posting Adjustments and Reserve Disbursements
  • Searching for payments, transactions, checks
  • Collector Module
  • Using Collector Notes during collection calls
  • Creating and using tickler reminders for debtors
  • Adding Additional Note Categories
  • Reviewing Collection Status report
  • Creating notification, past due, and audit letters
  • How to customize letters in Factor/SQL®
  • Interfacing Factor/SQL® with your G/L system
  • Basic Setup- G/L interfacing
 

Reports

  • Overview of reports available in Factor/SQL®
  • Daily Reports
  • Periodic Reports
  • Portfolio Reports
  • Audit and Security Reports
  • Miscellaneous Reports
  • Statements
  • In depth: How to read a Client Summary
  • Emailing/Faxing Reports
  • Using Microsoft outlook to email reports
  • Using Factor/SQL® to fax reports
  • Saving reports as a pdf, excel, and word document
  • Scheduling reports to run
  • Customer Support
  • Customer Maintenance: Email and Call in support
  • Website: Customer Login