Computerized Accounting

About The Course

Computerized Accounting

Computerized accounting is software which used in offices to manage the complete office data at one place and allow a business owner, or finance person, to track sales, expenses, payroll, taxes, and even inventory.

MS Access

Building the structure of a database. Create a new database. Create a table using the design view. Manage tables. Set table field properties. Creating relationships between tables. Modify, add, and delete table fields. Sort and filter records in table. Create a Query, Add Criteria to a Query, Compile field to multiple table, and Add a Calculated Field to a Query, Perform Calculations on a Record Grouping. Create form by using wizard, Create form by design view, Changing the Look of Forms Changing the Arrangement of Forms. Create sub forms. Creating Reports by Using a Wizard, Modifying Report Design, Previewing and Printing Reports. Create and use a switchboard, Exporting Data to an Excel Workbook, Creating Word Mail Merge Documents, Importing Data, Linking Data to an Access Table and Protect Database.

MS Excel

Set up print options for single and multiple worksheets, Work with multiple worksheets, Format worksheets to suit needs, Add graphic elements to a chart, Create and work with charts, Enter formulas and work with formulas and functions, Use advanced features such as Goal Seek and the Analysis Identify, Identify the ways to use a scenario, Use macros to automate complex and repetitive tasks, Create custom functions, Send workbooks through e-mail, Use auditing features and incorporate comments in Excel, Create and work with Pivot Charts, Create and work with PivotTables, Use data outlining and consolidating features, Use sorting and filtering features, Identify elements of a list, Identify database functions, Use the nested IF function, Use advanced functions and Assignments.

Course Outline

Peachtree Introduction

  • Installation Peachtree
  • Starting Peachtree
  • Opening a sample company
  • Peachtree Menus

New Company Set-up

  • New Company Set-up Wizard
  • Real-Time vs. Batch Posting
  • Accounting Periods Chart of Accounts
  • General Journal Entries


  • Inventory Defaults
  • Adding Items
  • Maintain Sale Price
  • Set Trade Discount in Items
  • Set Unit Measure
  • Inventory Reports
  • Entering Inventory Beginning Balances

Accounts Payable

  • Vendor Defaults
  • Adding Vendors
  • Purchase Orders
  • Purchase Invoices
  • Entering Payments
  • Purchase Return
  • Accounts Payable Reports
  • Purchase Discount

Accounts Receivable

  • Customer Defaults
  • Sales Taxes
  • Adding Customers
  • Quotes
  • Sales Orders
  • Sales Invoices
  • Applying Customer Receipts
  • Accounts Receivable Reports
  • Sale Return
  • Cash Discount


  • Payroll Setup Wizard
  • Adding Employee
  • Entering Employee


  • Financial Statements
  • Balance Sheet


  • Admin
  • Users
  • Backup & Restore
  • Import & Export
  • Create PDF