Training on Accounting for Non-Profit Making Organizations using QuickBooks

Introduction

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses who use it to manage sales and expenses, keep track of daily transactions, generate reports for planning, and more. QuickBooks Desktop Enterprise Nonprofit Accounting Software includes the features and functionality of QuickBooks and has features designed for nonprofit organizations.

This course will introduce you to using Quickbooks. It will present the day to day functions for an administrator to work with customer, vendor, employee and banking transactions for a business using the Intuit Quickbooks application. This course will have you create a new company, add customers and vendors, work with your bills and invoicing your customers, entering transactions and working with your bank accounts and transactions.

This course is aimed at equipping the participants with skills to use QuickBooks Desktop Enterprise nonprofit software tools to meet the accounting needs of their non-profit/NGO organization.

Target Participants
This course is aimed at finance professionals and accountants working with NGO's

What you will learn

By the end of this training the participants will be able to:

• Set-up budgets, track actual with the budgets and report on variances
• Generate various financial reports and statements for Management, Donors & Auditors.
• Manage donors, grants, and pledges
• Manage vendors & suppliers
• Allocate expenses across multiple programs
• Post income and expenses by fund
• Manage cash advances given out
• Track details of Cash/Bank Account transactions

Prerequisites
Basic Windows, keyboarding and mouse skills.

Course Outline

The Basics

• Using the nonprofit menu
• Understanding the financial statements of a nonprofit
• The Unified Chart of Accounts (UCOA)
• Nonprofit forms and letters
• Setting up accounts for different types of nonprofits
• Setting up Classes and Programs
• Entering grants

Tracking Income

• Setting up members and donors
• Recording donations
• Tracking and receiving grants
• Receiving general contributions
• Making deposits

Tracking Expenses

• Setting up vendors and employees
• Entering and paying bills
• Writing checks
• Payroll management
• Tracking volunteer time
• Classifying expenses and payroll by program
• Allocating expenses by percentage to programs

Standard Reports for Nonprofits

• Basic Profit & Loss Statement
• Profit & Loss Statement by month and by program
• Budget vs. actual reports
• Year-end financial statements for auditors, directors and accountant

Customizing QuickBooks

• Adding, deleting, resizing, and reordering columns on reports
• Filtering and formatting reports
• Saving reports and creating memorized report groups
• Customizing forms
• Creating and using custom fields
• Exporting reports to Excel

Advanced Budgeting

• Entering and reviewing budgets
• Copying prior years' budgets
• Modifying budgets using Excel
• Importing an Excel budget
• Tracking budgets by program
• Entering budgets by grant
• Preparing budget reports for a Board of Directors
• Generating budget vs. actual reports

Pledges

• Entering pledges
• Reports of outstanding pledges
• Sending reminder letters for overdue pledges

Membership Organizations

• Invoicing for membership organizations
• Setting up members
• Reports of dues past-due
• Sending renewals

In-Kind Contributions

• Understanding In-kind Contributions
• Accounting for In-kind Contributions

Matching Grants

• Setting up Matching Grants
• Recording donations and pledges for Matching Grants
• Reports for Matching Grants

Capital Campaigns

• Creating a capital campaign
• Setting up accounts, classes, and budgets for a capital campaign
• Entering pledges, individual contributions, and lump-sum contributions
• Recording year-end adjustments
• Reports for capital campaigns

Special Events

• Creating a special event
• Setting up accounts, items, and budgets for a special event
• Accounting for sponsorship activities
• Entering ticket sales
• Tracking in-kind contributions, lump-sum deposits, and expenses
• Reports for special events

Direct Mail Pieces (Fundraising Letters)

• Creating fundraising letters
• Creating accounts and items for letters
• Two methods for entering income from letters
• Accounting for expenses
• Reports for fundraising letters

Fiscal Sponsorships

• Creating accounts, items, and customers
• Two methods for entering income
• Accounting for payments
• Reports for fiscal sponsorships

Tracking Donors/Volunteers

• Entering information for donors and volunteers
• Sending letters to donors
• Year-end reports for donors
• Tracking time for volunteers

Tracking Funds

• Creating classes and accounts for funds
• Entering transactions
• Recording beginning fund balances
• Reviewing fund balances

Advanced Features

• Using QuickBooks on a network (multi-user)
• Password protecting QuickBooks
• Updating QuickBooks
• Protecting your QuickBooks data

Payroll

• Setting up payroll
• Entering employees
• Setting up payroll items
• Tracking and invoicing time
• Processing paychecks
• Modifying paychecks
• Making tax deposits
• Preparing tax forms

Tricky Transactions

• Using online banking
• Handling bounced checks...easily
• Entering customer down payments/deposits
• Setting up automatic transactions (memorizing transactions)
• Using credit cards

Inventory

• Entering purchase orders
• Receiving inventory
• Adjusting inventory quantities

Methodology

This instructor led training course is delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

Accreditation

Upon successful completion of this training, participants will be issued with a certificate of participation.

Training Venue

The training is residential and will be held at the Livecode Training Centre in Westlands, Nairobi, Kenya. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

Accommodation

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Mobile Number: +254 725 771 853

Training Fees

The course fees is KES 70,000.00 or USD 1000.00 exclusive of VAT. The course fees covers the course tuition, training materials, two (2) break refreshments, lunch and study visits. Participants will cater for their travel and accommodation costs.

Payment

Payment should be transferred to Livecode Technologies account through bank on or before the course starting date. 

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

Cancellation Policy

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

Tailor- Made

This scheduled course can also be tailored for your organization. To find out how our tailor-made training can help your organization, call our team on

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.