City & Guilds Computerised Accounts Levels 1 & 2 Using Sage Line 50 v13Learnexpressdotnet have created following Step-by-Step training guides:
- Computerised Payroll Using Sage 50 Payroll Version 13 (based on the March 2007 Budget)
- City & Guilds Computerised Accounts Level 1 Using Sage Line 50 Version 13
- City & Guilds Computerised Accounts Levels 1& 2 and beyond using Sage Line 50 Version 13
- City & Guilds Computerised Accounts Level 1 -- 3 Practice Papers (1, 2, 3) Solutions and Exam Hints
- City & Guilds Computerised Accounts Level 1 -- 3 Practice Papers (4, 5, 6) Solutions and Exam Hints
- City & Guilds Computerised Accounts Level 1 -- 6 Practice Papers, Solutions and Exam Hints
- City & Guilds Computerised Accounts Level 2 -- 3 Practice Papers (1, 2, 3) Solutions and Exam Hints
Computerised Accounts Level 1 and Computerised Accounts Level 2 are City and Guilds qualification titles listed under Computerised Accounts 8989 syllabus and can be found on their website. All of the above-mentioned guides, mock exam papers and solutions are paper based.
All of the Step-by-Step training guides listed above have been written by a professional tutor/trainer with over 23 years of teaching experience at various Colleges, private organisations and Adult Educational Institutions.
This training guide covers City & Guilds Computerised Accounts Levels 1 & 2 and beyond. This guide has been created using Sage Line 50 Version 13 Financial Controller and contains field explanations as well as screen shots and is written in simple and easy to follow step-by-step commands and allows you to learn at your own pace.
Once ordered, the guide containing more than 100 A4 size pages will be printed, comb bound and sent to you along with the Sage Line 50 Interactive Training CD (See below). Please note that every page has a copyright watermark on it. This is not a CD based package and does not include the Sage Line 50 software program. If you are in any doubt please email us.
Although it is mentioned on Ebay that purchased goods will be dispatched within 2 working days of receiving cleared funds, we aim to post them within 1 working day. Please see our feedback. We post all items by 1st class recorded delivery and always get a proof of postage. Postal delivery is beyond our control and we cannot be liable for any losses in the post. Please allow a few days for delivery before enquiring about delivery of your item.
Cutomer Feedback:

"I have looked in waterstones and a number of other book shops, and none of them compare to your book, it really is first class and I sincerely mean that ! I'm one of these people who can work quite happily from a book if the examples are clear & precise, which yours are perfected to the tee !....infact the moment I got your book, and just looked at the first couple pages I knew I had found a star rated piece of teaching, I was soooo impressed I ordered the level 2 paper from e-bay as well (-: if only everyone used simple but effective examples in almost everything we want to learn educational wise life would be so much easier."
Paul, City & Guilds Exam Guide and City & Guilds Computerised Accounts Levels 1 & 2
"ps. your books are great. I already have a diploma in Sage but was a bit rusty and couln't get any books with exercises & examples anywhere till I saw yours. I would be willing to reccomend you anytime regards."
Liz, Computerised Payroll and City & Guilds Exam Guide
SAGE LINE 50 INTERACTIVE TRAINING CD (We are authorised seller of this software)
This is an interactive SAGE LINE 50 Training CD where you see and hear the trainer showing you step-by-step actions and then allows you to follow them. The program runs directly from the CD. This is not a SAGE LINE 50 program CD and you will not be able to practice on a step-by-step basis on this CD as you can in our guides. This CD contains two levels – Basic and Advanced. Basic and Advanced levels covers 17 topics each. A list of topics and their headings can be seen on the picture. If you have any queries please email us, we aim to respond within 48hours.

Due to the nature of the products we sell there is no refund policy on all of our items. If you are in doubt please contact us first before bidding.
|
Please Note |
6 |
|
Getting Started |
7 |
|
General Guidelines |
8 |
|
Overview of Sage |
9 |
|
Function Keys |
10 |
|
Using the Menus and Toolbars |
11 |
|
Lesson 1 |
|
|
Introduction |
|
|
1.1 |
Double Entry Book-keeping |
12 |
|
1.2 |
Debit and Credit |
12 |
|
1.3 |
Tax Codes |
13 |
|
1.4 |
Nominal Codes Explained |
14 |
|
1.5 |
Printing Nominal Codes List |
15 |
|
1.6 |
Getting Help |
16 |
|
1.7 |
Control Accounts |
17 |
|
1.8 |
Exiting Sage Line 50 |
17 |
|
1.9 |
Restoring Your Data |
18 |
|
1.10 |
Setting Up Financial Year |
19 |
|
EXERCISE # 1 |
19 |
|
1.11 |
Backing Up Your Data |
20 |
|
Lesson 2 |
|
|
Case Study |
|
|
2.1 |
Details of Business |
21 |
|
2.2 |
Setting up the Nominal Ledger |
22 |
|
2.3 |
How to Change/Edit Nominal Code Entry |
23 |
|
EXERCISE # 2 |
23 |
|
2.4 |
Printing Nominal List |
24 |
|
Lesson 3 |
|
|
Nominal Ledger - Journal Entry |
|
|
3.1 |
Entering a Loan to the Company |
25 |
|
EXERCISE # 3 |
25 |
|
Lesson 4 |
|
|
Bank Payments |
|
|
4.1 |
Entering Bank Payments |
26 |
|
EXERCISE # 4a |
26 |
|
EXERCISE # 4b |
27 |
| 4.2 |
Report - Current (Cheque Book) Account Analysis |
28 |
|
4.3 |
Report - Cash Account Analysis |
28 |
|
Lesson 5 |
|
|
Purchase Ledger |
|
|
5.1 |
Account Reference Code |
29 |
|
5.2 |
Amending an Account Reference Code |
29 |
|
EXERCISE # 5 |
30 |
| 5.3 |
Entering Suppliers Details |
31 |
| 5.4 |
Editing Suppliers Details |
32 |
|
5.5 |
Report - Suppliers Address List |
33 |
|
Lesson 6 |
|
|
Batch Supplier (Purchase) Invoices |
|
|
6.1 |
Entering Batch Supplier Invoices |
34 |
|
EXERCISE # 6 |
35 |
|
6.2 |
Report - Supplier Activity Detailed |
36 |
|
Lesson 7 |
|
|
Supplier (Purchase) Credit Note |
|
|
7.1 |
Supplier (Purchase) Credit Note |
37 |
|
EXERCISE # 7 |
37 |
|
7.2 |
Report - Supplier Credit Note |
38 |
|
Lesson 8 |
|
|
Supplier Payments |
|
|
8.1 |
Supplier Payment |
39 |
|
EXERCISE # 8 |
39 |
| 8.2 |
Printing Advice Notes |
41 |
| 8.3 |
Report - List of Purchase Payment & Bank Payments By Bank |
42 |
|
8.4 |
Report - Aged Creditors Analysis (Summary) |
42 |
|
Lesson 9 |
|
|
Sales Ledger |
|
|
EXERCISE # 9 |
43 |
| 9.1 |
Entering Customers Details |
44 |
| 9.2 |
Editing Customers Details |
45 |
|
9.3 |
Report - Customers Address List |
46 |
|
Lesson 10 |
|
|
Batch Customer (Sales) Invoices |
|
|
10.1 |
Entering Batch Customer (Sales) Invoices |
47 |
|
EXERCISE # 10 |
48 |
|
10.2 |
Report - Customer Activity Detailed |
49 |
|
Lesson 11 |
|
|
Customer (Sales) Credit Note |
|
|
11.1 |
Customer (Sales) Credit Note |
50 |
|
EXERCISE # 11 |
50 |
|
11.2 |
Report - Customer Credit Note |
51 |
|
Lesson 12 |
|
|
Customer Receipts |
|
|
12.1 |
Entering Customer Receipts |
52 |
|
EXERCISE # 12 |
53 |
| 12.2 |
Report - Day Books: Customer Receipts (Detailed) |
54 |
|
12.3 |
Report - Aged Debtors Analysis (Detailed) |
55 |
|
Lesson 13 |
|
|
Bank Receipts (Cash Sales) |
|
|
13.1 |
Bank Receipts |
56 |
|
EXERCISE # 13 |
57 |
|
Lesson 14 |
|
|
Contra Entry |
|
|
EXERCISE # 14 |
58 |
|
14.1 |
Posting a Contra Entry |
58 |
|
Lesson 15 |
|
|
Bad Debts |
|
|
15.1 |
What is a Bad Debt and How to Write it Off |
60 |
|
EXERCISE # 15 |
60 |
|
Lesson 16 |
|
|
Financials |
|
|
16.1 |
The Audit Trail |
64 |
|
16.2 |
Audit Trail Entries Type |
65 |
| 16.3 |
The Trial Balance |
65 |
| 16.4 |
The Profit and Loss Report |
66 |
|
16.5 |
The Balance Sheet |
66 |
|
EXERCISE # 16 |
67 |
|
Lesson 17 |
68 |
|
Bank Reconciliation |
68 |
|
17.1 |
Bank Statement |
68 |
|
EXERCISE # 17 |
68 |
|
17.2 |
How to Reconcile |
69 |
|
17.3 |
Add an Adjustments |
71 |
|
17.4 |
Printing Bank Statement |
72 |
|
17.5 |
Report – Unreconciled Payments |
73 |
|
17.6 |
Report – Unreconciled Receipts |
73 |
|
Lesson 18 |
74 |
|
VAT Returns |
74 |
| 18.1 |
How Sage Handles VAT Returns |
74 |
|
18.2 |
Producing a VAT Return |
74 |
|
EXERCISE # 18 |
74 |
|
18.3 |
Printing the VAT Return |
76 |
|
18.4 |
Reconciling the VAT Transaction |
77 |
|
18.5 |
Updating the VAT Account References |
78 |
|
18.6 |
Paying VAT |
80 |
|
Lesson 19 |
81 |
|
Products |
81 |
|
19.1 |
List of Products |
81 |
| 19.2 |
Entering Products |
82 |
|
EXERCISE # 19 |
83 |
|
19.3 |
Report – Product List |
83 |
|
Lesson 20 |
84 |
|
Bank Transfer |
84 |
|
20.1 |
Transferring Money between Different Accounts |
84 |
|
EXERCISE # 20 |
84 |
|
20.2 |
Petty Cash Transactions |
86 |
|
|
20.2.1 |
Petty Cash Practice Exercise |
86 |
|
Lesson 21 |
|
|
Sales Order Processing |
88 |
|
21.1 |
How to Make up a Sales Order |
88 |
|
EXERCISE # 21 |
89 |
|
21.2 |
Report – Sales Order List |
90 |
|
21.3 |
Report – Outstanding Sales Order |
90 |
|
Lesson 22 |
|
|
Service and Product Invoices |
91 |
|
22.1 |
Creating a Product Invoice |
91 |
|
EXERCISE # 22 |
93 |
|
22.2 |
Printing the Invoice |
94 |
| 22.3 |
Updating Ledgers |
94 |
| 22.4 |
Creating a Service Invoice |
95 |
|
Lesson 23 |
|
|
More Journal Entries |
96 |
|
23.1 |
Entering Journal Entries |
96 |
|
EXERCISE # 23 |
96 |
|
Lesson 24 |
|
|
Purchase Order Processing |
98 |
|
24.1 |
How to make up a Purchase Order |
98 |
|
EXERCISE # 24 |
99 |
|
24.2 |
Report – Purchase Order List Fixed |
99 |
|
24.3 |
Report – Outstanding Purchase Orders Fixed |
100 |
|
Lesson 25 |
101 |
|
Fixed Assets |
101 |
|
EXERCISE # 25 |
101 |
|
25.1 |
How to Add a Fixed Asset |
101 |
|
25.2 |
Report – Fixed Assets List Register |
103 |
| Lesson 26 |
|
|
Recurring Entries |
104 |
|
26.1 |
Adding New Recurring Entries |
104 |
|
26.2 |
Adding a Second Payment |
107 |
|
EXERCISE # 26 |
107 |
|
26.3 |
Editing an Entry |
107 |
|
26.4 |
Adding a Receipt |
108 |
|
26.5 |
Deleting Recurring Entries |
109 |
|
26.6 |
Suspending Recurring Entries |
109 |
|
Lesson 27 |
110 |
|
File Maintenance |
110 |
|
27.1 |
Correcting a Transaction |
110 |
|
EXERCISE # 27 |
111 |
|
27.2 |
Editing Record |
111 |
|
27.3 |
Rebuilding Sage |
112 |
Due to the nature of the products we sell there is no refund policy on all of our items. If you are in doubt please contact us first before bidding.
|