MICROSOFT ADVANCE EXCEL
TRAINING COURSE CONTENTS
( Can be customized )
Creating a Company in Sage 50
Getting Acquainted with Sage 50 ,The steps to create a Sage 50 Company
Default Setting master records in Sage 50
Customer , Vendor , Inventory , Payroll Setup , Employees, General Ledger
Maintain General Ledger Account in Sage 50
creation, Display- Alter & entering opening balance
Entering general Journal Entries in Sage 50
posting journal entries , modifying journal entries , & Delete journal entries & Effects of Adjustment Entries In- Final accounts
Reporting in Sage 50
Basic General Ledger Reports, Balance Sheet & P/L- statements, The Cash Flow Manager ,The Collection Manager ,Report Groups
Basic Inventory in Sage 50
Stock item creation, Unit of Measure, Stock Group , Location
Entering Beginning Balances in Sage 50
Customer, Vendor ,& Inventory Beginning Balances
Invoicing in Sage 50
Accounts Receivable, Quotes, Sales Orders, Proposals and Invoicing ,Entering & Converting Quotes , Sales Orders & Proposals Window ,Sales/Invoicing Window , Printing and Emailing Invoices , Entering and Applying Credit Memos ,Receive Money Window , Create sales invoice window, Selecting Deposits , Accounts Payable ,Purchase Orders Window ,Select for Purchase Orders , Purchases/Receive Inventory Window , Payments Window , Entering Vendor Credit Memos
Sales Tax in Sage 50
Using Sales Tax ,Paying Sales Taxes Sales tax adjustment entry
Advanced Inventory in Sage 50
multiple unit of stock items & additional expense of purchase & sales & discount entries
Sales Rep in Sage 50
Company operations set up for- Sales Rep , Payment of commission for sales Rep
Orders in Sage 50
Purchase order & sales order, Outstanding Reports of Purchase- orders & Sales Orders
Manufacturing in Sage 50
Setting BOM, Entry of manufacturing journal, Production details in- manufacturing journal, Cost calculation for final product
Managing Inventoryin Sage 50
Making Inventory Adjustments, Actual & Billed- Quantity, Changing Item Prices,
Entering BUDGET in Sage 50
Entering Account Budgets, & Budget reports
Job Assembling in Sage 50
Job Creation, Consumption & Sales of job, and Creating Custom Fields for Jobs, Reporting
Payroll Setup Wizard in Sage 50
Creating Payroll, Adding Employees, Adding Employee Beginning Balances, Paying a Group of Employees, Paying an Employee
Account Management in Sage 50
Writing Checks, Voiding Checks Reconciling Bank Accounts
Exporting Reports in Sage 50
Exporting Reports to PDF & Ms excel
Options menu in Sage 50
Changing Global Options, Changing the System Date
Other functions in Sage 50
Restoring from a Local Backup File, Setting Up Security and Creating Users