Sage 50 Accounts Professional / Financial Controller
Introduction
1 or 2 Day Course depending on experience
Overview
The Accounts Professional package was formally known as ''Financial Controller' until it was re-named by Sage in 2008.The skills and knowledge covered in this course are sufficient to enable you to use Sage Accounts at an introductory level.
Target Audience
This course is designed for anyone new to Sage 50 as well as people who are using a small area of the software and need to expand their understanding. During the course the learner will practice their skills with skill reviews and exercises. A certificate of completion is issued at the end of the course.
Course Outline
|
Working with Sage 50 Accounts Windows versions Different Sage 50 Accounts versions Avoiding the loss of data from a ‘live’ version of Sage 50 Accounts Working with Sage 50 Accounts as a single user Working with Sage 50 Accounts in a shared environment with multiple users Working through the chapters Course aims Program Basics Starting Sage 50 Accounts Opening the company file The ActiveSetup Wizard Entering a password The Tip of the Day dialog box The main program window Modules, windows and views Getting help Exiting Sage 50 Accounts Getting Started Restoring data for the first time Setting the financial year Backing up for the first time Account Names & Numbers Debit and credit Double entry book-keeping Viewing the accounts list Printing the current list Viewing and printing Nominal List report Account ranges Transactions and double entry Changing account names Control accounts Bank Receipts Entering a bank receipt Saving a transaction Bank Payments Bank payments Entering bank payments Financials The financial state of the company The Trial Balance report The Profit and Loss report The Balance Sheet Customers The Customers module Entering a new customer The Customer Record Wizard Adding more customers About selecting customers Editing customer details Changing the address details Agreeing terms Customer delivery addresses Customer address lists Suppliers Supplier details Editing the supplier record Service Invoices The Invoice window Service invoices Create a service invoice Entering order information Footer and payment details Printing invoices Updating ledgers Viewing customer and invoice information The Customers list The Customer Dashboard The Invoicing window Re-printing the invoice Products Products Adding new products The Product Record window Non-Stock and Service items Stock Control Stock adjustments in Stock adjustments out Stock returns Product activity Stocktaking Re-order levels The Products Dashboard |
Product Invoices Product invoices Sales details Giving discounts Order details Footer and payment details Adding an invoice with a customer delivery address Adding a further invoice Mix and match invoicing Printing the invoices Changing an invoice Adding carriage charges Updating the ledgers Adjustments in Checking the value of invoices Product Credit Notes Product credit notes Reviewing your Accounts The financial state of your company Sending Statements Account balances Aged debtors analysis Statements Customer communication history Customer Receipts Customer receipts Automatic allocation of receipts Manual allocation of receipts Partial allocation of receipts Giving a discount Payments on account Customer Activity Customer activity Purchase Invoices Supplier details Batch invoices Supplier account balances Supplier Payments Payments to suppliers Making a payment Printing remittance advice notes Printing cheques Supplier activity More about the Nominal Ledger Journal entries Nominal code activity Nominal Ledger Graph Nominal records Chapter 23 ~ More about Bank Accounts Bank transfers Combined payments Printing cheques via the Bank Payments window Petty cash transactions Bank Reconciliation Bank reconciliation Grouping bank transactions Reconciling your bank account Add an adjustment Recurring Entries What are recurring entries? Adding new recurring entries Adding a receipt Adding journal credits and debits recurring entries Setting up a bank transfer recurring entry Editing an entry A recurring entry processed weekly Processing recurring entries Suspending postings Deleting recurring entries VAT Returns Notes on VAT returns Producing a VAT return VAT adjustments Printing the VAT return Reconciling the VAT transactions Updating the VAT account references Using the VAT Liability Transfer Wizard Reports & Information Information |
Sage 50 Accounts Professional / Financial Controller
Intermediate
1 or 2 Day Course depending on experience
Overview
The skills and knowledge covered in this course are sufficient to enable you to use more advanced elements of the Sage Accounts software.
Target Audience
For both operators and managers of companies using Sage 50 who want expand their use of the software.
Course Outline
|
Working with Sage 50 Accounts
Windows versions
Different Sage 50 Accounts versions
Avoiding the loss of data from a ‘live’ version of Sage 50 Accounts
Working with Sage 50 Accounts as a single user
Working with Sage 50 Accounts in a shared environment with multiple users
Getting Started
Starting Sage 50 Accounts
Opening the company file
The ActiveSetup Wizard
Entering a password
The Tip of the Day dialog box
Restoring data for the first time
Setting the financial year
Backing up for the first time
Prepayments & Accruals
What are prepayments and accruals?
Prepayments, Accruals
Setting up prepayments, Entering the original invoices, Entering prepayments
Setting up accruals, Entering accruals
Processing prepayments and accruals
Which transactions were posted?
Check the nominal ledger balances
Deleting prepayments and accruals
Fixed Assets & Depreciation
What are fixed assets?
Depreciation methods
Straight line depreciation
Reducing balance depreciation
Entering a new fixed asset
Entering the original purchase invoice
Entering the asset details
Entering an existing asset
Depreciating assets
Asset valuation, Asset reports
Writing off an asset
Using the Fixed Asset Disposal Wizard
Delivery Addresses
Delivery and registered addresses
Adding delivery addresses
Adding multiple company delivery addresses
Setting the invoice and order defaults for delivery addresses
Editing a customer delivery address
Deleting a customer delivery address
Entering Purchase Orders
Purchase order processing
The Purchase Order Processing window
Entering a purchase order for product items; Save, discard, print & complete
Entering a non-product purchase order
Entering long descriptions
Changing the company delivery address
|
Purchase Order Skeletons
What is a purchase order skeleton?
Creating a purchase order skeleton
Using a non-recurring purchase order skeleton
Processing Purchase Orders
Printing purchase orders
Putting purchase orders ‘on order’
Deliveries,
Deliver - complete deliveries
GRN - Goods Received Notes
Amending deliveries
Recording a part-delivery
Completing a partly delivered order
Cancelling orders
Changes made to the accounts data
Creating purchase invoices from purchase orders
Purchase order reports
Deleting orders
Product Records & Purchase Orders
Product records
Cost price and re-order quantities
Entering a purchase order
BOMs & Product Transfers
What are BOMs?, Links & levels
Setting up and processing BOMs
Case 1 - CDKIT
Duplicating product records
Case 2 - WINVISINSTTR
Case 3 - WINVISSPECIAL
Checking availability of components
Stock transfers
Not enough components in stock
Transfers with sub-assemblies
Cancelling stock transfers
Product reports
Product Pricing Options
Pricing options
Setting a special customer price
Setting special customer prices for MSNATKEY
Removing a special customer price
Creating customer price lists
Changing a cost price
Moving a customer from one price list to another
Deleting price lists, Price list reports
Entering Sales Orders
Sales order processing
The Sales Order Processing window
Sales order - product items
Adding carriage and settlement terms
Save, discard, print & complete
Multiple line sales orders, discounts, goods not in stock
Applying a net value discount
Non-product sales orders
Recurring Sales Order Skeletons
Sales order skeletons
Creating a sales order skeleton
Editing a sales order skeleton
Processing a recurring sales order skeleton
Editing the frequency of a recurring sales order
Deleting a sales order skeleton
|
Processing Sales Orders
About sales order processing
Printing sales orders
Allocating stock
Using the ShortFall Generator
Sales order reports
Recording despatches
Changing a sales order
Manual processing
Partly allocated orders
Cancel, hold and unallocate
Deleting orders
More about Sales Invoices
Checking sales invoices
Payment details
Printing invoices, Updating ledgers
Credit Control
Credit control basics
Chasing Debts
The Chase Debt window
Listing customers with account balances, Using the Search function to restrict a list
Sending statements, Accounts letters
Disputed invoices
Recording a dispute on the customer communication record
Setting up dispute reasons in the Configuration Editor
Applying the dispute details to the sales invoice
Customer Refunds
Entering the overpayment
Checking the customer activity
Processing the customer refund
Printing the cheque
Checking the customer balance
Late Payment Legislation
What is the late payment legislation?
Setting up your system for late payment charges
Setting up the Credit Charges control account, Setting up the interest rate
Setting the customer record for credit charges
Adding an invoice
Charging customers for late payment
Using the Credit Charges Wizard
Writing Off Bad Debts
Writing off bad debts
Cash Flow Forecasting
Showing the Cash Flow window
Change the forecast period
Include and exclude sales and purchases
Add additional information
Include and exclude bank accounts
Print the cash flow forecast
View the cash flow graph
|
Sage 50 Accounts Professional / Financial Controller
Advanced
1 or 2 Day Course depending on experience
Overview
The skills and knowledge covered in this course are sufficient to enable you to use Sage Accounts to an advanced level. During this course the learner will practice their skills with reviews and exercises. A certificate of completion is issued at the end of the course.
Target Audience
This
Course Outline
|
Working with Sage 50 Accounts Windows versions, Different Sage 50 Accounts versions, Avoiding the loss of data from a ‘live’ version of Sage 50 Accounts, Course aims Getting Started Starting Sage 50 Accounts Restoring and backing up Setting the financial year Importing Data Preparing data for importing Importing customer records Performing the import Checking the customer records Setting up Departments Why use departments? Setting up departments Setting Budgets Entering nominal code budget details Advanced budgeting method Choosing the budgeting method Setting your budget by department Checking the departmental budgets Running a Variance Report Using one year’s actuals for the next year’s budget Setting up Discounts Customer discounts Discount by invoice value Discount by product quantity Copying an entire discount matrix Copying part of a discount matrix Applying a customer discount Settlement discounts Discounts by invoice item line Net value discounts Product discount scheme descriptions Quotations About quotations and converting quotations Creating a product quotation Checking the discounts that have been applied, Adding the customer quotation reference, Adding carriage and settlement terms, Entering an expiry date for the quotation Saving and closing the quotation Creating a service quote printing quotations Converting Quotations Winning and losing quotations Convert/Set as Won Lost/Set as Lost, Set as Open Winning a quotation Losing a quote, Retrieving a lost quotation and winning it Pro-forma Invoices Creating a pro-forma invoice Add the new customer Adding the service details Printing the pro-forma Processing the payment on account Creating the invoice Recording the deposit paid Allocating the payment on account |
The Euro & Other Foreign Currencies Sage 50 Accounts, the euro and foreign currencies VAT and VAT codes for EU transactions Setting up the Foreign Trader option Setting up the currency table Foreign currency bank accounts Invoicing in Euros Creating a sales invoice with a euro total Adding a new EU customer Adding a euro sales invoice Printing the service invoice with a Euro Receiving Payments in Euros Updating the currency table Receiving euro payments How Sage 50 Accounts Professional has dealt with the exchange rate variance Paying Foreign Currency Invoices Entering supplier invoices Setting up the supplier default currencies Entering euro currency supplier invoices Entering supplier invoices in currencies other than euros Paying foreign currency invoices Checking the supplier activity for exchange rate variance Contra Entries What is a contra entry? Entering the purchase invoices for the customer/supplier Entering contra entries Checking the supplier and customer balances Batch Payments Entering the supplier invoices Entering batch purchase payments Printing cheques Changing Posted Records Adding incorrect payments Checking the audit trail Using journal reversals File maintenance Corrections Editing the record Deleting posted transactions Checking the petty cash account Account activity Batch Changes & Global Changes What are batch changes? Making a batch change to customer settlement terms What are global changes? Making global changes to sales prices Using the Global Update Wizard Checking the product sales prices Changing specific records The Opening and Closing Stock Wizard Calculating the cost of sales Using the Opening and Closing Stock Wizard Checking the Profit and Loss report |
Analysing Budgets & Departments Analysing the budget Analysing department sales and expenditure Departmental profit and loss report The Audit Trail What is the audit trail? Printing the audit trail report Clearing the audit trail Report Designer Basic Skills About reports and layouts Using the Report Designer Objects that can be found on reports Basic skills, Tooltips, Selecting objects Customising a customer letter Starting the Report Designer Open an existing layout Preview and Designer view Saving a layout with a different filename Tooltips and selecting objects Displaying tooltips, Selecting objects Deleting objects, Moving objects Adding text and variable objects Editing a text object, Simple formatting, Changing a layout name Closing Report Designer Using your new letter Report Designer More Skills Opening an invoice form for editing Customising the invoice Adding variable objects and their titles Adding an image Using the customised invoice Deleting a layout The Sage Report Wizard Creating a new report Changing the page setup, Moving fields Accessing the new report Deleting a report Project Costing What is project costing? Setting up project costing Activating project costing Setting up project statuses and cost codes, Setting up resources Using project costing Setting up the project record Entering purchase invoices Posting stock to a project Posting non-stock items to a project - project only costs Assigning resources Analysing the project Adding budgets, Analysis Project enquiry, Project credits Raising the sales invoice Completing the project, Project reports Setting Passwords & Access Rights Setting password access to Sage Setting a company password Testing the company password Removing company password protection Setting up individual password protection, Setting up users and limiting what they use in Sage Deleting logon names |
« Back
