Loading... Please wait...
  • Image 1

Hover over main image to zoom

Custom Workshop Day: General Ledger, Accounts Payable, & Bank Reconciliation 201


Product Description

Hands-on exercises to learn day to day operation in using these three modules. (The material offered for this day represents approximately 8 hours worth of interactive training. Also, included are up to five attendees from your organization. Supplies and workbooks are offered for the five attendees.If you have more than five attendees you will need to pay for the additional attendees here.) 

Some of what will be covered

 General Ledger 201 

 Accounts Payable 201

 Bank Reconciliation 201

Design a Chart of Accounts That Meets Your Needs.

  • Be Aware of GAAP & FASB Issues.
  • Understand the Classification of Balance Sheet Accounts
    • Classification of Net Assets (FASB 117)
    • Classification of Expense Accounts
  • Use the Minimum Number of Companies.
  • Use Funds Instead of Adding Companies.
  • Balance Sheet Issues
  • Interfund Issues
  • Use Departments to Add Reporting Flexibility
  • Account Numbering across Departments
  • Create Accounts Required by Sub-Ledgers
  • Add the Same Account to Multiple Departments at One Time
  • Use Total Levels to Add Subtotals and Grand Totals
  • Use Only Capital Accounts as Closing Accounts
  • Remove a Fund, Department, or Account by Hiding It
  • Restructure Your Chart of Accounts

Use Available Tools to Use the General Ledger Efficiently.

  • Use Projects to Track Related Activity Within and Across Accounts
  • Use the Project Register to Report Across Fiscal Years.
  • Correct Project Assignments to Posted Journal Entries
  • Do NOT Enable Sub-Ledger Journal Changes
  • Enable Bank Reconciliation Entries for Manual Journals
  • Assign Account Rights to Limit Access to the Chart of Accounts and to Empower Users to Run Their Own Reports.
  • Post Specific Journal Entries
  • Retrieve Sub-Ledger Register Reports (Source Documents)
  • Automate Recurring Journal Entries
      • Create Recurring Journals
      • Transfer Recurring Journal Entries
  • Reverse/Copy Journal Entry
  • Close the Period and Set a New Default Period
  • Close the Fiscal Year Efficiently
  • Closing Procedures General Ledger Fiscal Year Closing
  • Run the Check General Ledger Setup Utility Periodically

Create a Budget

  • Project Budgeting
  • Budget Revisions
  • Run a Preliminary Budget Report to Facilitate Budgeting
  • Export/Import Budgets
  • Budgeting for Purchases of Fixed Assets and Loan Principal Payments
  • Personalize Your Budgeted Financial Statement
    • Choosing Account Information Options
    • Choosing Columnar Information
    • Defining a Formula Column
    • Renaming Columns
    • Hiding Columns
    • Using Formulas

Understand the Relationship of Sub-Ledger Dates to the General Ledger

  • Contributions and Donors and Gifts
  • Accounts Payable
  • Accounts Receivable

Run All Financial Statements Required by GAAP

  • Balance Sheet (Statement of Financial Position)
      • Balance the Balance Sheet
  • Income & Expense Statement (Statement of Activities)
    • Columnar Income and Expense Statement
  • Cash Flow/Balance List (Statement of Cash Flow)
    • Creating the Cash Flow Special Report Design
    • Run the Cash Flow/Balance List Report
  • Understand the Difference between the Detail Ledger Report and the Journal History Report
    • The Detail Ledger Report
    • The Journal History Report
  • Use Special Report Designs to Create “Views” of the Chart of Accounts.
    • Example Cash Flow/Balance List Report
    • Example Columnar Income & Expense Report
    • Renumber Special Report Design Lines after a Change

Set Up Company Information to Suit Your Accounting Practices.

  • Cash vs. Accrual
  • Track Discounts
  • Display Remaining Budget Amounts on Entry
  • Use an Automated Clearing House (ACH) to Pay Vendors
  • Enable the Ability to Send ACH Payment Vouchers by E-mail
  • Manage Vendor ACH Information
  • Secure Vendor ACH Account Changes

Manage Vendor Information Effectively

  • Understand Financial Module Address Types
  • Create Custom Address Types
  • Save Previous Addresses
  • Track “Doing Business As” Information
  • Organize Vendor Names that Start with “The”
  • Include an Attn: Line for Business Labels
  • Add Default Vendor Information
  • Record Memos Regarding Issues with Vendors
  • Delete a Vendor

Correct Mistakes in Accounts Payable

  • Check A/P Setup
  • Modify 1099 Status after Posting an Invoice
  • Undo an Invoice
  • Void a Check

Work with Invoices Effectively

  • Create Custom Invoice Distributions
    • o   Setting up a distribution
    • o   Using a Distribution
    • Recurring Payments
      • o   Set up Recurring Payments
      • o   Transfer Recurring Payments
    • Understand Shelby Systems v5 Accounts Payable Dates
    • Use Acquire/View to Capture Invoice Images
    • Create Invoices to Pay a Group the Same Amount
    • Post Select AP Invoices by Changing “User” Ownership
    • Purge A/P History

Process Invoice Payments Effectively

  • Understand the Process Checks Bank Balance from GL
  • Select Invoices to pay
  • Change Due Date/Split Payment
  • Print Separate Checks to the Same Vendor

Accounts Payable Credit Card Processing

  • Benefits of Credit Card Processing
  • Setting up a Credit Card
  • Processing a Credit Card Transaction
    • Entering a Transaction
    • Scanning Documents (Acquire/View)
    • Completing and Updating Entered Transactions
  • Reconcile a Credit Card Statement
    • Create a Payment

Balancing Accounts Payable to General Ledger

Invoice Listing Report

Possible out of balance issues


Preliminary Topics

Bank Account Information

  • One physical Bank Account used over multiple Funds
  • Opening Balance
  • Outstanding Items
  • Reconciling Cleared Items Options
    • Reconcile Process Using the Detail List

Balance Bank Reconciliation with the General Ledger

  • Run a report to View All Items
  • Mark Canceled items
  • View Outstanding items

Starting Over with Bank Reconciliation

Things to Check If You Cannot Balance

























































*Hosting organization is also responsible for trainer's travel-related expenses, i.e. airfare and rental car or mileage at the current IRS rate, lodging, and meals (not to exceed an average of $40/day).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product!

Write Review
* Contact Person:

(Maximum Size: . Type: )
* Contact e-mail:

(Maximum Size: . Type: )
Names of the up to five attendees:
* Proposed Training Date (at least 3 week in future) / include 2nd/3rd choices: