| Introduction |
|
1 | (4) |
|
|
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
2 | (1) |
|
|
|
3 | (1) |
|
|
|
3 | (2) |
| Part 1: Getting Started With Sage 50 Accounts |
|
5 | (84) |
|
Chapter 1 Introducing Sage 50 Accounts |
|
|
7 | (20) |
|
Looking at the Varieties of Sage |
|
|
7 | (2) |
|
|
|
9 | (1) |
|
Getting what you need before you get started |
|
|
9 | (1) |
|
Moving to the installation |
|
|
10 | (1) |
|
Setting Up with the Active Set-Up Wizard |
|
|
10 | (7) |
|
Registering Your Software |
|
|
17 | (1) |
|
Finding Out How Easy Sage Is to Use |
|
|
18 | (1) |
|
Burying the accounting jargon |
|
|
18 | (1) |
|
|
|
19 | (6) |
|
|
|
20 | (5) |
|
|
|
25 | (2) |
|
Chapter 2 Creating Your Chart of Accounts and Assigning Nominal Codes |
|
|
27 | (20) |
|
Understanding as Much as You Need to about Accounting |
|
|
27 | (3) |
|
Dabbling in double-entry bookkeeping |
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
Looking at the Structure of Your COA |
|
|
30 | (8) |
|
Checking out the default COA |
|
|
30 | (3) |
|
Identifying balance sheet codes |
|
|
33 | (2) |
|
Looking at profit and loss codes |
|
|
35 | (2) |
|
Leaving gaps and mirroring codes |
|
|
37 | (1) |
|
Accommodating floating nominals |
|
|
37 | (1) |
|
|
|
38 | (5) |
|
|
|
38 | (2) |
|
|
|
40 | (3) |
|
|
|
43 | (4) |
|
|
|
43 | (1) |
|
Looking at some common errors |
|
|
44 | (3) |
|
Chapter 3 Setting Up Records |
|
|
47 | (24) |
|
Choosing How to Create Your Records |
|
|
47 | (2) |
|
Getting a quick start using the New icon |
|
|
48 | (1) |
|
|
|
48 | (1) |
|
Following the wizards brick by brick |
|
|
49 | (1) |
|
Creating Customer and Supplier Records |
|
|
49 | (4) |
|
Setting customer and supplier defaults |
|
|
51 | (2) |
|
Deleting customer and supplier records |
|
|
53 | (1) |
|
Creating Your Nominal Records |
|
|
53 | (6) |
|
Exploring your nominal records |
|
|
53 | (1) |
|
Renaming existing nominal records |
|
|
54 | (1) |
|
Adding a new nominal record |
|
|
55 | (1) |
|
Looking for a nominal record |
|
|
56 | (1) |
|
Looking around a nominal record |
|
|
57 | (2) |
|
|
|
59 | (1) |
|
Recording Your Bank Accounts |
|
|
59 | (4) |
|
Renaming an existing account |
|
|
60 | (1) |
|
|
|
61 | (1) |
|
|
|
62 | (1) |
|
Getting Your Product Records in Order |
|
|
63 | (4) |
|
Creating a product record |
|
|
63 | (2) |
|
|
|
65 | (1) |
|
Deleting a product record |
|
|
66 | (1) |
|
Entering a project record |
|
|
66 | (1) |
|
Setting Up Fixed Asset Records |
|
|
67 | (4) |
|
Chapter 4 Recording Your Opening Balances |
|
|
71 | (18) |
|
Timing Your Switch to Sage |
|
|
71 | (1) |
|
Obtaining Your Opening Balances |
|
|
72 | (2) |
|
Entering Opening Balances Using the Wizard |
|
|
74 | (12) |
|
Entering your default date |
|
|
74 | (1) |
|
Entering customer and supplier balances |
|
|
75 | (2) |
|
Checking the customer and supplier opening balances |
|
|
77 | (1) |
|
Reversing the nominal balances in preparation for entering the trial balance |
|
|
77 | (1) |
|
Entering the trial balance from your accountant |
|
|
78 | (1) |
|
Entering the uncleared transactions for your bank account |
|
|
79 | (1) |
|
Checking opening balances against the trial balance from your accountant |
|
|
80 | (1) |
|
|
|
80 | (1) |
|
|
|
81 | (1) |
|
Manually recording opening balances |
|
|
81 | (1) |
|
Manually recording opening bank balances |
|
|
82 | (1) |
|
Manually recording nominal opening balances |
|
|
83 | (1) |
|
Putting in opening balances for products |
|
|
84 | (2) |
|
Checking Your Opening Balances |
|
|
86 | (5) |
|
Printing an opening trial balance |
|
|
86 | (1) |
|
|
|
86 | (3) |
| Part II: Looking into Day-to-Day Functions |
|
89 | (68) |
|
Chapter 5 Processing Your Customer Paperwork |
|
|
91 | (12) |
|
Posting Batch Entry Invoices |
|
|
91 | (2) |
|
|
|
93 | (3) |
|
Registering Payments from Your Customers |
|
|
96 | (4) |
|
Giving credit where due - allocating credit notes |
|
|
98 | (2) |
|
Recording payments on account |
|
|
100 | (1) |
|
Deleting Invoices and Credit Notes |
|
|
100 | (3) |
|
Chapter 6 Invoicing Your Customers |
|
|
103 | (16) |
|
Deciding on an Invoice Type |
|
|
103 | (1) |
|
|
|
104 | (7) |
|
|
|
105 | (1) |
|
Getting to the main attraction |
|
|
106 | (3) |
|
Filling in the order details |
|
|
109 | (1) |
|
Getting down to the footer details |
|
|
109 | (1) |
|
Checking your profit on a product invoice |
|
|
110 | (1) |
|
Remembering that Communication is Key |
|
|
111 | (1) |
|
Managing Your Invoice List |
|
|
112 | (3) |
|
|
|
112 | (1) |
|
|
|
113 | (1) |
|
|
|
114 | (1) |
|
|
|
115 | (1) |
|
Saving Time while You Ask for Money |
|
|
115 | (4) |
|
Duplicating existing invoices |
|
|
115 | (1) |
|
Repeating recurring transactions |
|
|
115 | (2) |
|
|
|
117 | (2) |
|
Chapter 7 : Dealing with Paperwork from Your Suppliers |
|
|
119 | (10) |
|
Receiving and Posting Invoices |
|
|
119 | (4) |
|
Setting up your receiving system |
|
|
119 | (1) |
|
|
|
120 | (3) |
|
|
|
123 | (2) |
|
|
|
125 | (1) |
|
|
|
126 | (1) |
|
Printing a Remittance Advice Note |
|
|
127 | (2) |
|
Chapter 8 Recording Your Bank Entries |
|
|
129 | (16) |
|
Understanding the Different Types of Bank Account |
|
|
129 | (3) |
|
Keeping up with current (1200) and deposit (1210) accounts |
|
|
130 | (1) |
|
Counting the petty cash (1230) account |
|
|
131 | (1) |
|
Handling your cash register (1235) |
|
|
131 | (1) |
|
Managing the company credit card (1240) and credit card receipts (1250) |
|
|
131 | (1) |
|
Tracking Bank Deposits and Payments |
|
|
132 | (2) |
|
Transferring Funds between Accounts |
|
|
134 | (1) |
|
Repeating Recurring Entries |
|
|
135 | (5) |
|
Going for consistency with your bank entries |
|
|
135 | (3) |
|
Repeating customer and supplier payments |
|
|
138 | (1) |
|
Making regular journal entries - if you dare |
|
|
139 | (1) |
|
Processing and posting recurring entries |
|
|
139 | (1) |
|
|
|
140 | (2) |
|
|
|
141 | (1) |
|
Making payments from the tin |
|
|
141 | (1) |
|
Reconciling the petty cash tin |
|
|
141 | (1) |
|
Paying the Credit Card Bill |
|
|
142 | (3) |
|
|
|
142 | (1) |
|
Reconciling the credit card statement |
|
|
143 | (2) |
|
Chapter 9 Maintaining and Correcting Entries |
|
|
145 | (12) |
|
Finding Ways to Find Transactions |
|
|
145 | (2) |
|
|
|
147 | (2) |
|
|
|
149 | (1) |
|
Checking and Maintaining Your Files |
|
|
150 | (2) |
|
|
|
150 | (1) |
|
|
|
151 | (1) |
|
|
|
152 | (1) |
|
|
|
152 | (1) |
|
|
|
152 | (2) |
|
|
|
154 | (1) |
|
|
|
155 | (2) |
| Part III: Functions for Plus and Professional Users |
|
157 | (88) |
|
Chapter 10 Processing Sales Orders |
|
|
159 | (20) |
|
|
|
159 | (3) |
|
Amending your invoice and order defaults |
|
|
160 | (1) |
|
|
|
160 | (2) |
|
Allocating and amending stock for a quote |
|
|
162 | (1) |
|
Converting a quotation to an invoice or order |
|
|
162 | (1) |
|
|
|
162 | (8) |
|
Entering the sales order details |
|
|
164 | (3) |
|
|
|
167 | (1) |
|
|
|
168 | (1) |
|
Putting sales orders on hold |
|
|
168 | (1) |
|
Duplicating a sales order |
|
|
169 | (1) |
|
|
|
170 | (1) |
|
Allocating Stock to an Order |
|
|
170 | (3) |
|
|
|
170 | (1) |
|
|
|
171 | (1) |
|
Amending the allocation of stock |
|
|
171 | (1) |
|
Using the shortfall generator |
|
|
172 | (1) |
|
|
|
173 | (2) |
|
|
|
173 | (1) |
|
Using goods despatched notes |
|
|
173 | (1) |
|
Using the despatch facility |
|
|
174 | (1) |
|
Recording a despatch manually |
|
|
174 | (1) |
|
|
|
175 | (1) |
|
Deleting and Cancelling Sales Orders |
|
|
176 | (3) |
|
|
|
176 | (1) |
|
|
|
177 | (2) |
|
Chapter 11 Processing Purchase Orders |
|
|
179 | (16) |
|
Creating, Changing, and Copying a Purchase Order |
|
|
179 | (5) |
|
Creating a purchase order |
|
|
180 | (2) |
|
|
|
182 | (1) |
|
Duplicating a purchase order |
|
|
183 | (1) |
|
Placing the Goods on Order |
|
|
184 | (1) |
|
Ordering via the conventional method |
|
|
184 | (1) |
|
Manually placing goods on order |
|
|
184 | (1) |
|
Completing Your Purchase Order |
|
|
185 | (1) |
|
Printing Your Purchase Order |
|
|
186 | (1) |
|
|
|
187 | (4) |
|
Using goods received notes |
|
|
188 | (1) |
|
Accepting delivery of everything |
|
|
189 | (1) |
|
Taking in part of an order |
|
|
190 | (1) |
|
Creating an Invoice from an Order |
|
|
191 | (1) |
|
Deleting, Cancelling, and Reinstating Orders |
|
|
192 | (3) |
|
|
|
192 | (1) |
|
|
|
193 | (1) |
|
Putting a cancelled order back on order |
|
|
193 | (2) |
|
Chapter 12 Keeping Track of Your Products |
|
|
195 | (16) |
|
|
|
195 | (5) |
|
|
|
197 | (1) |
|
|
|
198 | (1) |
|
|
|
198 | (1) |
|
Using the stock shortfall facility |
|
|
199 | (1) |
|
Understanding a Bill of Materials |
|
|
200 | (5) |
|
Creating a bill of materials |
|
|
201 | (1) |
|
Checking stock availability for a BOM |
|
|
202 | (1) |
|
Transferring stock for a BOM |
|
|
203 | (2) |
|
|
|
205 | (2) |
|
|
|
207 | (4) |
|
Changing stock allocation |
|
|
208 | (1) |
|
|
|
209 | (2) |
|
Chapter 13 Managing Projects |
|
|
211 | (16) |
|
Appointing a Project's Status and Costs |
|
|
211 | (4) |
|
|
|
212 | (1) |
|
Looking at costs - types and codes |
|
|
213 | (1) |
|
Changing status and costs |
|
|
213 | (2) |
|
Managing Project Resources |
|
|
215 | (1) |
|
Creating or amending a resource |
|
|
215 | (1) |
|
|
|
216 | (1) |
|
|
|
216 | (5) |
|
Sharing out project charges |
|
|
216 | (2) |
|
Issuing stock to a project |
|
|
218 | (1) |
|
Counting costs from a supplier invoice |
|
|
219 | (1) |
|
Integrating POP with project costing |
|
|
220 | (1) |
|
|
|
221 | (3) |
|
Looking at the project's activity |
|
|
221 | (2) |
|
Comparing costs and budget |
|
|
223 | (1) |
|
Charging Your Customers for a Project |
|
|
224 | (1) |
|
|
|
225 | (2) |
|
Chapter 14 Using Foreign Currencies |
|
|
227 | (18) |
|
Setting Up Foreign Currencies |
|
|
227 | (3) |
|
Entering the exchange rate for a currency |
|
|
228 | (1) |
|
Amending the Countries table |
|
|
229 | (1) |
|
Tailoring the Foreign Trader Tool |
|
|
230 | (2) |
|
Keeping Trade Status in Mind when Setting Up Accounts |
|
|
232 | (1) |
|
|
|
233 | (4) |
|
Raising invoices, credit notes, and orders |
|
|
233 | (3) |
|
Entering batch invoices and credit notes |
|
|
236 | (1) |
|
Banking on Foreign Currencies |
|
|
237 | (4) |
|
Coping with customer receipts and supplier payments |
|
|
237 | (2) |
|
Carrying out a bank transfer |
|
|
239 | (1) |
|
Expecting changing exchange rates |
|
|
240 | (1) |
|
Doing Revaluations with the Wizard |
|
|
241 | (4) |
| Part Ilk Running Monthly, Quarterly and Annual Routines |
|
245 | (56) |
|
Chapter 15 Reconciling Your Bank Accounts |
|
|
247 | (10) |
|
Recognising Reasons to Reconcile |
|
|
247 | (1) |
|
Getting Ready to Reconcile |
|
|
248 | (1) |
|
|
|
249 | (5) |
|
Troubleshooting when Your Account Doesn't Reconcile |
|
|
254 | (1) |
|
|
|
254 | (3) |
|
Listing unpresented cheques and outstanding lodgements |
|
|
255 | (1) |
|
Remembering recurring entries |
|
|
255 | (2) |
|
Chapter 16 Running Your Monthly and Yearly Routines |
|
|
257 | (20) |
|
|
|
258 | (2) |
|
|
|
260 | (1) |
|
Depreciating Fixed Assets |
|
|
261 | (3) |
|
|
|
262 | (1) |
|
Posting assets and depreciation |
|
|
263 | (1) |
|
|
|
264 | (3) |
|
Rattling skeleton journals |
|
|
266 | (1) |
|
|
|
266 | (1) |
|
Carrying Out Your Month-End Routine |
|
|
267 | (6) |
|
Ticking off your checklist |
|
|
268 | (1) |
|
|
|
268 | (2) |
|
Clearing stock transactions |
|
|
270 | (1) |
|
|
|
271 | (1) |
|
|
|
272 | (1) |
|
|
|
273 | (2) |
|
|
|
275 | (2) |
|
Chapter 17 Running Your VAT Return |
|
|
277 | (24) |
|
Understanding some VAT Basics |
|
|
277 | (3) |
|
Knowing your outputs from your inputs |
|
|
278 | (1) |
|
|
|
278 | (1) |
|
Comparing Sage's VAT accounting methods |
|
|
279 | (1) |
|
|
|
280 | (5) |
|
Preparing your VAT return |
|
|
281 | (2) |
|
Reconciling your VAT return |
|
|
283 | (2) |
|
Checking Your VAT Return Using Reconciliation Reports |
|
|
285 | (4) |
|
Checking under the standard scheme |
|
|
285 | (1) |
|
Getting a hard copy of the nominal activity report |
|
|
285 | (2) |
|
Checking with cash accounting |
|
|
287 | (1) |
|
Completing your VAT return |
|
|
288 | (1) |
|
Submitting Your VAT Return |
|
|
289 | (2) |
|
Posting your return online via Sage |
|
|
290 | (1) |
|
Submitting your VAT return manually via HMRC |
|
|
291 | (1) |
|
Posting your refund or payment in Sage |
|
|
291 | (1) |
|
|
|
291 | (1) |
|
|
|
292 | (5) |
|
Going from standard to VAT cash accounting or the UK flat rate |
|
|
292 | (1) |
|
|
|
293 | (2) |
|
Making the switch from VAT cash to standard accounting |
|
|
295 | (1) |
|
Reconciling the sales tax and purchase tax control accounts |
|
|
296 | (1) |
|
|
|
297 | (1) |
|
|
|
298 | (3) |
| Part V: Using Reports |
|
301 | (56) |
|
Chapter 18 Running Monthly Reports |
|
|
303 | (14) |
|
Making the Most of Standard Reports |
|
|
303 | (1) |
|
Checking the Chart of Accounts |
|
|
304 | (1) |
|
Figuring Out the Financial Reports |
|
|
304 | (6) |
|
Trying for an initial trial balance |
|
|
304 | (2) |
|
Accounting for profit and loss |
|
|
306 | (1) |
|
Comparing profits and losses |
|
|
307 | (1) |
|
Weighing the balance sheet |
|
|
308 | (2) |
|
|
|
310 | (1) |
|
Forgetting the Periods and Going Transactional |
|
|
311 | (3) |
|
|
|
312 | (1) |
|
|
|
312 | (1) |
|
|
|
313 | (1) |
|
Designing Reports to Suit Yourself |
|
|
314 | (3) |
|
Chapter 19 Tackling the Complicated Stuff |
|
|
317 | (16) |
|
|
|
317 | (3) |
|
Sending spreadsheet stuff |
|
|
318 | (1) |
|
Transferring Outlook contacts |
|
|
318 | (1) |
|
|
|
319 | (1) |
|
|
|
320 | (2) |
|
Linking to Your Accountant |
|
|
322 | (2) |
|
Sending accounts to your accountant |
|
|
323 | (1) |
|
|
|
323 | (1) |
|
Getting back adjustments and narratives |
|
|
324 | (1) |
|
|
|
324 | (7) |
|
Configuring your e-banking |
|
|
325 | (2) |
|
|
|
327 | (1) |
|
Reconciling electronically |
|
|
328 | (3) |
|
Working with Document Manager |
|
|
331 | (2) |
|
Adding attachments and filing system references |
|
|
331 | (1) |
|
|
|
332 | (1) |
|
Chapter 20 Running Key Reports |
|
|
333 | (16) |
|
Checking Activity through the Nominal Codes |
|
|
333 | (2) |
|
Looking into Supplier Activity |
|
|
335 | (2) |
|
Tracking Customer Activity |
|
|
337 | (1) |
|
Checking Numbers with Supplier Daybook Reports |
|
|
338 | (1) |
|
Finding the Customers Who Owe You |
|
|
339 | (3) |
|
Paying Attention to Your Creditors |
|
|
342 | (1) |
|
Handling Unreconciled Bank Transactions |
|
|
343 | (3) |
|
Doing a Monthly Breakdown of Profit and Loss |
|
|
346 | (1) |
|
Ranking Your Top Customers |
|
|
347 | (2) |
|
|
|
349 | (8) |
|
|
|
349 | (1) |
|
|
|
350 | (4) |
|
Installing Sage 50 Tracker |
|
|
351 | (1) |
|
Looking at the Sage 50 Tracker dashboard |
|
|
352 | (2) |
|
Sussing Out Sage 50 Mobile Sales |
|
|
354 | (1) |
|
Keeping Connected with Connected Users |
|
|
355 | (2) |
| Part V1: The Part of Tens |
|
357 | (14) |
|
Chapter 22 Ten (Okay, Eleven) Funky Functions |
|
|
359 | (4) |
|
Browsing for Help with F1 |
|
|
359 | (1) |
|
Calculating Stuff with F2 |
|
|
359 | (1) |
|
Accessing an Edit Item Line for Invoicing with F3 |
|
|
360 | (1) |
|
Finding Multiple Functions with F4 |
|
|
360 | (1) |
|
Calculating Currency or Checking Spelling with F5 |
|
|
360 | (1) |
|
|
|
361 | (1) |
|
|
|
361 | (1) |
|
|
|
361 | (1) |
|
Calculating Net Amounts with F9 |
|
|
362 | (1) |
|
Launching Windows with F11 |
|
|
362 | (1) |
|
Opening Report Designer with F12 |
|
|
362 | (1) |
|
Chapter 23 Ten (Plus One) Wizards to Conjure Up in Sage |
|
|
363 | (8) |
|
Creating a New Customer Account |
|
|
363 | (1) |
|
Setting Up a New Supplier |
|
|
364 | (1) |
|
Initiating a New Nominal Account |
|
|
364 | (1) |
|
Creating a New Bank Account |
|
|
365 | (1) |
|
|
|
365 | (1) |
|
Starting Up a New Project |
|
|
365 | (1) |
|
Helping Out at Month-End: Opening/Closing Stock |
|
|
366 | (1) |
|
Fuelling Up: Scale Charges |
|
|
366 | (1) |
|
Saving Time: Global Changes |
|
|
367 | (1) |
|
Handling Currencies: Foreign Bank Revaluation |
|
|
368 | (1) |
|
Keeping Others in the Loop: Accountant Link |
|
|
368 | (3) |
| Index |
|
371 | |
