Excel for Beginners A basic, useable knowledge of Excel, including designing, creating and editing a spreadsheet to analyze and display data used to make business and/or personal decisions. Methods will include creating formulas, functions and charts to analyze and present information. Use relative and absolute cell references to speed up your work. Must have some experience with Windows and keyboard. Flash drive required: Students must activate their My Northshore account prior to first class.

QuickBooks Cloud Level 1 An introduction to the current version of QuickBooks. Topics include chart of accounts, list of vendors, items, customers, cash sales, invoicing, payments, deposits, bank reconciliation, bill payments, and creating reports and graphs. Knowledge of computers and Windows required. Flash drive required. Textbook required. Available at Danvers Campus Bookstore.Prerequisite: Bookkeeping and Accounting: Part 1 or equivalent experience. Students must activate their My Northshore account prior to first class.

Bookkeeping and Accounting: Part 1 An introduction to bookkeeping and accounting covering the accounting cycle. Analyze and record transactions using debits, credits, and T accounts, along with posting in the journal and the ledger. Prepare trial balance, create adjustments, and produce financial statements. Calculator and ruler are required. Textbook required: Please visit www.SHOPNSCC.com to order book. Students must activate their My Northshore account prior to first class. There is an instructor led virtual or in person option for this course. Please see schedule.

Taxes for Bookkeepers & Tax Preparers: An Introduction Looking to promote yourself within the CPA firm you work for or to sharpen your tax knowledge? CPA Kevin McAlarney will guide you through the most common individual tax forms along with reporting of taxable and tax free income, self-employed income, rental income, social security income, interest and dividend income, how to report capital gains and losses, itemized deductions, employee business expenses, deducting your vehicle for work, charitable donations, deducting IRA's, Roth IRA basic rules, filing status, claiming children, college tax credits, and how to compute depreciation deductions. Prerequisite: Bookkeeping and Accounting Part 1 or equivalent experience.

Bookkeeping and Accounting: Part 2 Continue the accounting cycle in more depth, covering banking procedures, cash and understanding payroll and payroll taxes. Work with sales and cash receipts including credits and accounts receivables. Purchases and accounts payable posting procedures will be prepared. Calculator and ruler are required. Textbook required (same as Bookkeeping and Accounting: Part 1). Please visit www.SHOPNSCC.com to order book. Prerequisite: Bookkeeping and Accounting Part 1 or equivalent experience. Students must activate their My Northshore account prior to first class.

Excel Intermediate Learn the techniques for handling large spreadsheets. Use the Solver Add-In analysis tool, the conditional IF function, cell references linking formulas between worksheets, cell and range naming and using named ranges in functions, formatting and customizing charts, the VLOOKUP function and creating a basic macro to automate a regularly used process. Flash drive required: Students must activate their My Northshore account prior to first class.

QuickBooks Cloud Payroll Add to your QuickBooks skills by learning how to set up payroll and employee accounts, distinguish between employees and 1099 subcontractors, prepare W2s and year-end reports, and the best way to pay taxes. Prerequisite: QuickBooks Level 1 or equivalent experience. Students must activate their My Northshore account and download QuickBooks Software prior to first class.

Audit Paper Trail: What to do with all that paperwork? Bookkeeping and accounting transactions originate from a document source. What happens to all those documents when you are done with them? What happens when you need to produce these documents upon audit? How long do you need to save these documents? These are some of the questions surrounding all those papers you need to put somewhere. Learn how to set procedures creating a proper audit trail. Covered topics include: accounts receivable, accounts payable, fixed assets, manual files, electronic files, scanning, shredding, sales tax returns, income tax returns, payroll and payroll tax returns and much more. Students must activate their My Northshore account prior to first class.