Course Offerings

Individuals with functional bookkeeping skills or those who have finished a basic accounting or bookkeeping course will be prepared to become nationally Certified Bookkeepers, as recognized by the American Institute of Professional Bookkeepers (AIPB). Participants will apply a hands-on approach using the Intuit QuickBooks Online accounting application to evidence understanding. Course instruction will focus on preparing learners to master adjusting entries, accounting errors, payroll, depreciation, inventory, internal controls, and fraud prevention. Students who complete this course should be able to demonstrate bookkeeping expertise and be prepared to pass the AIPB Certified Bookkeepers certification exam.

Course Objectives

Introduction: Discuss how to become a Certified Bookkeeper, identify bookkeeping employment opportunities and practice using Intuit QuickBooks Online

Mastering Adjusting Entries: Define accruals and deferrals, calculate and record adjusting entries for accrued revenue and expenses, calculate and record adjusting entries for deferred revenue and expenses and construct an adjusted trial balance, add the adjustments and complete the adjusted trial balance

Mastering Correction of Accounting Errors: Perform the monthly bank reconciliation and find and correct errors revealed by it, find and correct errors in the trial balance, find and correct accrual errors discovered before the books are closed and find incorrect deferral errors discovered before the books are closed

Mastering Payroll: Carry out the basic payroll function, including paying wages, withholding, depositing and reporting taxes, and preparing federal forms; explain basic reporting of wages and taxes for Forms 940, 941, 944, 945, W-2, W-3 and 1099; and make journal entries for the payroll distribution, payroll-related expenses, payroll liabilities and remittance of employer taxes

Mastering Inventory: Record inventory purchases and sales and determine the cost of goods sold and end inventory under the perpetual method; record inventory purchases and sales and determine the cost of goods sold and ending inventory under the periodic method; compute and record cost of goods sold and ending inventory using weighted-average and moving-average costing; compute and record cost of goods sold and ending inventory using first-in, first-out (FIFO) costing; compute and record cost of goods sold and ending inventory using last-in, first-out (LIFO) costing; and compute and record changes in inventory under the lower of cost or net realization value (LCNRV) rule

Mastering Depreciation: Describe how qualifying assets are depreciated on the financial statements and tax return; depreciate for book purposes assets purchased at any time during the year under the straight-line, units of production, declining balance and the sum of the years' digits methods; depreciate both listed assets and real estate for tax purposes; and depreciate vehicles, including passenger automobiles, for tax purposes

Mastering Internal Controls and Fraud Prevention: Install basic internal controls, including segregation of duties, for preventing employee theft of inventory and other non-cash assets, signs of such theft and the schemes that are used to steal; understand the basics of background checks on applicants to reduce the likelihood of hiring employees who steal, insure or bond employees who have access to company cash and segregate duties to minimize the chance of employee fraud or theft of cash; install internal controls that prevent check fraud by employees or customers, spot counterfeit or altered checks and check-fraud schemes; implement internal controls that prevent credit card fraud by customers and know how to spot counterfeit credit cards; and establish controls that prevent vendors from cheating you

Outline of Instruction

Introduction: Becoming a Certified Bookkeeper by AIPB, bookkeeping employment opportunities and getting started using Intuit QuickBooks Online

Mastering Adjusting Entries: Introduction; why we use accruals, deferrals and other adjustments; accrued revenue; accrued expenses (accrued liabilities); revenue collected in advance (unearned revenue); prepaid (deferred) expenses; other end-of-period entries; from unadjusted trial balance to financial statements; applying your knowledge to the trial balance; and exam preparation

Mastering Correction of Accounting Errors: Introduction, where errors occur and how they are found, the bank reconciliation, finding and correcting errors using the unadjusted trial balance, correcting current period accrual errors, correcting current period deferral errors and exam preparation

Mastering Payroll: Introduction, employees vs. non-employees, federal and state wage-hour law, paying employees under federal law, employment records and payroll recordkeeping, employee data (Form W-4 and state withholding allowance certificates), how employers withhold and deposit federal taxes, federal employment reporting forms and due dates, when wages become taxable, other reporting rules, payroll entries and exam preparation

Mastering Inventory: Introduction to accounting for inventory, inventory recordkeeping using the perpetual method, inventory recordkeeping using the periodic method, inventory costing (weighted-average and moving-average), inventory costing using the FIFO method, inventory costing using the LIFO method, inventory costing using the lower of cost or net realizable value rule and exam preparation

Mastering Depreciation: Introduction, depreciation on the financial statement vs. tax return, depreciation under GAAP, straight-line method of depreciation, units of production method of depreciation, declining balance method of depreciation, sum of the years' digits method of depreciation, depreciation under federal income tax depreciation rules, tax depreciation of vehicles and exam preparation

Mastering Internal Controls and Fraud Prevention: Introduction; how dishonest employees steal inventory; how to prevent or spot employee theft; check fraud; credit card fraud; how vendors cheat you; computer and Internet fraud; forms, patterns and red flags of bribery; operations that support frauds and scams; and exam preparation

Contact Hours

96

CEUs

1

Industry Standard, State or National Certification

Certification

The American Institute of Professional Bookkeepers (AIPB)

Website

https://aipb.org

Certification Learning Outcomes/Requirements

Pass Part 1 of the national certification exam: Adjustments and Error Correction (Accruals, Deferrals and the Adjusted Trial Balance, followed by Correction of Accounting Errors and the Bank Reconciliation) (taken at Prometric)

Pass Part 2 of the national certification exam: Payroll and Depreciation (taken at Prometric)

Pass Part 3 of the national certification exam: Back-of-the-workbook exam on Inventory (included in the workbook "Mastering Inventory")

Part Part 4 of the national certification exam: Back-of-the-workbook exam on Internal Controls (included in the workbook "Mastering Internal Controls and Fraud Prevention")

Submit evidence of at least two years of full-time bookkeeping experience (or 3,000 hours of part-time or freelance experience) before or after passing the national exam. This can include internships and tax- or accounting-related volunteerism, such as Volunteer Income Tax Assistance (VITA), but not simply office work.

Sign a Code of Ethics

CE or CU Articulation

No

Prerequisites

Prior to course enrollment, students should have foundational bookkeeping or accounting skills or knowledge in alignment with the Bookkeeping: Intuit QuickBooks Certified User Online course.

Learning Supplies Needed

None

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance
Demonstrate an understanding of at least 70% of the course material taught.

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals who want to expand their knowledge and skills in bookkeeping or accounting and those who want to successfully prepare for the relevant industry certification exam(s).

Specific Industry or Business Support Needs

Bookkeeper, Accounting, Office Assistant, Administrative Assistant, Freelancing

Wake County Need for Industry Positions

According to Burning Glass Technologies, Wake County has a high demand for bookkeeping skills.

Industry or Job Titles Related to Training Outcomes for Employment

Bookkeeper

Accounting

Office Assistant

Administrative Assistant

Freelancing

Related Courses

HRD-3004BI2

ACC-3150BE

ACC-3150F2

SEF-3001BMG

SEF-3001GH1

SEF-77282

SEF-7994CL

SEF-8479CL

Course Contact Information

Joy Curry
919-866-5370
[email protected]