| Introduction |
|
1 | (6) |
|
|
|
1 | (1) |
|
Conventions Used in This Book |
|
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
2 | (1) |
|
How This Book Is Organised |
|
|
3 | (2) |
|
Part I Setting Up and Installing Sage 50 Accounts |
|
|
3 | (1) |
|
Part II Looking into Day-to-Day Functions |
|
|
3 | (1) |
|
Part III Functions for Plus and Professional Users |
|
|
3 | (1) |
|
Part IV Running Monthly, Quarterly and Annual Routines |
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
4 | (1) |
|
|
|
5 | (1) |
|
|
|
5 | (2) |
|
Part I Setting Up and Installing Sage 50 Accounts |
|
|
7 | (86) |
|
Chapter 1 Introducing Sage 50 Accounts |
|
|
9 | (24) |
|
Looking at the Varieties of Sage |
|
|
9 | (2) |
|
|
|
11 | (4) |
|
Getting what you need before you get started |
|
|
11 | (1) |
|
Moving to the installation itself |
|
|
11 | (4) |
|
Setting Up with the Active Set-Up Wizard |
|
|
15 | (4) |
|
Registering Your Software |
|
|
19 | (1) |
|
Finding Out How Easy Sage Is to Use |
|
|
20 | (4) |
|
Burying the accounting jargon |
|
|
20 | (1) |
|
Looking at the screen layout |
|
|
21 | (1) |
|
|
|
21 | (3) |
|
|
|
24 | (7) |
|
Exploring the browser toolbar |
|
|
24 | (6) |
|
Navigating the Task pane, Links list and Module buttons |
|
|
30 | (1) |
|
|
|
31 | (2) |
|
Chapter 2 Creating Your Chart of Accounts and Assigning Nominal Codes |
|
|
33 | (20) |
|
Understanding as Much as You Need to about Accounting |
|
|
33 | (3) |
|
Dabbling in double-entry bookkeeping |
|
|
34 | (1) |
|
|
|
34 | (1) |
|
|
|
35 | (1) |
|
Looking at the Structure of Your Chart of Accounts (COA) |
|
|
36 | (8) |
|
Checking out the default COA |
|
|
36 | (3) |
|
Identifying Balance Sheet codes |
|
|
39 | (2) |
|
Looking at Profit and Loss codes |
|
|
41 | (2) |
|
Leaving gaps and mirroring codes |
|
|
43 | (1) |
|
Accommodating floating nominate |
|
|
44 | (1) |
|
Editing Your Chart of Accounts |
|
|
44 | (5) |
|
Amending your Chart of Accounts |
|
|
45 | (1) |
|
Creating a new Chart of Accounts |
|
|
46 | (3) |
|
Checking Your Chart of Accounts |
|
|
49 | (4) |
|
|
|
49 | (1) |
|
Looking at some common errors |
|
|
50 | (3) |
|
Chapter 3 Setting Up Records |
|
|
53 | (24) |
|
Choosing How to Create Your Records |
|
|
53 | (3) |
|
Getting a quick start using the Record icon |
|
|
53 | (1) |
|
Switching off the process maps |
|
|
54 | (1) |
|
Following the wizards brick by brick |
|
|
55 | (1) |
|
Creating Customer and Supplier Records |
|
|
56 | (4) |
|
Setting customer and supplier defaults |
|
|
58 | (1) |
|
Deleting customer and supplier records |
|
|
59 | (1) |
|
Creating Your Nominal Records |
|
|
60 | (6) |
|
Exploring your nominal records |
|
|
60 | (1) |
|
Renaming existing nominal records |
|
|
61 | (1) |
|
Adding a new nominal record |
|
|
62 | (1) |
|
Looking for a nominal record |
|
|
63 | (1) |
|
Looking around a nominal record |
|
|
64 | (2) |
|
|
|
66 | (1) |
|
Recording Your Bank Accounts |
|
|
66 | (3) |
|
Renaming an existing account |
|
|
67 | (1) |
|
|
|
67 | (2) |
|
|
|
69 | (1) |
|
Getting Your Product Records in Order |
|
|
69 | (4) |
|
Creating a product record |
|
|
70 | (2) |
|
|
|
72 | (1) |
|
Deleting a product record |
|
|
72 | (1) |
|
Entering a project record |
|
|
72 | (1) |
|
Setting Up Fixed Asset Records |
|
|
73 | (4) |
|
Chapter 4 Recording Your Opening Balances |
|
|
77 | (16) |
|
Timing Your Switch to Sage |
|
|
77 | (1) |
|
Obtaining Your Opening Balances |
|
|
78 | (2) |
|
Entering Opening Balances Using the Wizard |
|
|
80 | (11) |
|
Entering your default date |
|
|
81 | (1) |
|
Entering customer and supplier balances |
|
|
81 | (1) |
|
Reversing the nominal balances in preparation for entering the Trial Balance |
|
|
82 | (2) |
|
Entering the Trial Balance from your accountant |
|
|
84 | (1) |
|
Entering the uncleared transactions for your bank account |
|
|
85 | (1) |
|
Checking opening balances against the Trial Balance from your accountant |
|
|
86 | (1) |
|
|
|
86 | (1) |
|
|
|
87 | (1) |
|
Manually recording opening balances |
|
|
87 | (1) |
|
Recording opening bank balances manually |
|
|
88 | (1) |
|
Recording nominal opening balances manually |
|
|
89 | (1) |
|
Putting in opening balances for products |
|
|
90 | (1) |
|
Checking Your Opening Balances |
|
|
91 | (2) |
|
Printing an opening Trial Balance |
|
|
92 | (1) |
|
|
|
92 | (1) |
|
Part II Looking into Day-to-Day Functions |
|
|
93 | (66) |
|
Chapter 5 Processing Your Customer Paperwork |
|
|
95 | (10) |
|
Posting Batch Entry Invoices |
|
|
95 | (2) |
|
|
|
97 | (2) |
|
Registering Payments from Your Customers |
|
|
99 | (5) |
|
Matching payments to invoices |
|
|
100 | (2) |
|
Giving credit where due - allocating credit notes |
|
|
102 | (2) |
|
Recording payments on account |
|
|
104 | (1) |
|
Deleting Invoices and Credit Notes |
|
|
104 | (1) |
|
Chapter 6 Invoicing Your Customers |
|
|
105 | (16) |
|
Deciding on an Invoice Type |
|
|
105 | (1) |
|
|
|
106 | (8) |
|
|
|
107 | (1) |
|
Getting to the main attraction |
|
|
108 | (3) |
|
Filling in the order details |
|
|
111 | (1) |
|
Getting down to the footer details |
|
|
112 | (1) |
|
Checking your profit on a product invoice |
|
|
113 | (1) |
|
|
|
114 | (1) |
|
Managing Your Invoice List |
|
|
115 | (3) |
|
|
|
115 | (1) |
|
|
|
116 | (1) |
|
|
|
117 | (1) |
|
|
|
117 | (1) |
|
Saving Time while You Ask for Money |
|
|
118 | (3) |
|
Duplicating existing invoices |
|
|
118 | (1) |
|
Repeating recurring transactions |
|
|
118 | (2) |
|
|
|
120 | (1) |
|
Chapter 7 Dealing with Paperwork from Your Suppliers |
|
|
121 | (10) |
|
Receiving and Posting Invoices |
|
|
121 | (4) |
|
Setting up your receiving system |
|
|
121 | (1) |
|
|
|
122 | (3) |
|
|
|
125 | (1) |
|
|
|
126 | (1) |
|
|
|
127 | (2) |
|
Printing a Remittance Advice Note |
|
|
129 | (2) |
|
Chapter 8 Recording Your Bank Entries |
|
|
131 | (16) |
|
Understanding the Different Types of Bank Accounts |
|
|
131 | (3) |
|
Keeping up with the Current and Deposit accounts (1200/1210) |
|
|
132 | (1) |
|
Counting the Petty Cash account (1230) |
|
|
132 | (1) |
|
Handling your Cash Register (1235) |
|
|
133 | (1) |
|
Managing the company credit card (1240) and credit card receipts (1250) |
|
|
133 | (1) |
|
Tracking Bank Deposits and Payments |
|
|
134 | (2) |
|
Transferring Funds between Accounts |
|
|
136 | (1) |
|
Repeating Recurring Entries |
|
|
137 | (6) |
|
Going for consistency with your hank entries |
|
|
137 | (3) |
|
Repeating customer and supplier payments |
|
|
140 | (1) |
|
Making regular journal entries - if you dare |
|
|
141 | (1) |
|
Processing and posting recurring entries |
|
|
142 | (1) |
|
|
|
143 | (1) |
|
|
|
143 | (1) |
|
Making payments from the tin |
|
|
143 | (1) |
|
Reconciling the petty cash tin |
|
|
144 | (1) |
|
Paying the Credit Card Bill |
|
|
144 | (3) |
|
|
|
144 | (1) |
|
Reconciling the credit card statement |
|
|
145 | (2) |
|
Chapter 9 Maintaining and Correcting Entries |
|
|
147 | (12) |
|
Checking and Maintaining Your Files |
|
|
147 | (5) |
|
|
|
148 | (1) |
|
|
|
149 | (2) |
|
|
|
151 | (1) |
|
|
|
151 | (1) |
|
|
|
151 | (1) |
|
Finding Ways to Find Transactions |
|
|
152 | (1) |
|
|
|
153 | (2) |
|
|
|
155 | (1) |
|
|
|
156 | (3) |
|
Part III Functions for Plus and Professional Users |
|
|
159 | (88) |
|
Chapter 10 Processing Sales Orders |
|
|
161 | (20) |
|
|
|
161 | (3) |
|
Amending your invoice and order defaults |
|
|
162 | (1) |
|
|
|
162 | (2) |
|
Allocating and amending stock for a quote |
|
|
164 | (1) |
|
Converting a quotation to an invoice or order |
|
|
164 | (1) |
|
|
|
164 | (8) |
|
Entering the sales order details |
|
|
166 | (3) |
|
|
|
169 | (1) |
|
|
|
170 | (1) |
|
Putting sales orders on hold |
|
|
170 | (1) |
|
Duplicating a sales order |
|
|
171 | (1) |
|
|
|
172 | (1) |
|
Allocating Stock to an Order |
|
|
172 | (2) |
|
|
|
172 | (1) |
|
|
|
173 | (1) |
|
Amending the allocation of stock |
|
|
174 | (1) |
|
Using the shortfall generator |
|
|
174 | (1) |
|
|
|
174 | (3) |
|
|
|
175 | (1) |
|
Using goods despatched notes |
|
|
175 | (1) |
|
Using the despatch facility |
|
|
176 | (1) |
|
Recording a despatch manually |
|
|
176 | (1) |
|
|
|
177 | (1) |
|
Deleting and Cancelling Sales Orders |
|
|
178 | (3) |
|
Chapter 11 Processing Purchase Orders |
|
|
181 | (16) |
|
Creating, Changing and Copying a Purchase Order |
|
|
181 | (4) |
|
Creating a purchase order |
|
|
182 | (2) |
|
|
|
184 | (1) |
|
Duplicating a purchase order |
|
|
184 | (1) |
|
Placing the Goods On Order |
|
|
185 | (1) |
|
Ordering via the conventional method |
|
|
185 | (1) |
|
Manually placing goods on order |
|
|
185 | (1) |
|
Completing Your Purchase Order |
|
|
186 | (1) |
|
Printing Your Purchase Order |
|
|
187 | (1) |
|
|
|
188 | (4) |
|
Using goods received notes |
|
|
189 | (2) |
|
Accepting delivery of everything |
|
|
191 | (1) |
|
Taking in part of an order |
|
|
191 | (1) |
|
Creating an Invoice from an Order |
|
|
192 | (1) |
|
Deleting, Cancelling and Un-Cancelling Orders |
|
|
193 | (4) |
|
|
|
193 | (1) |
|
|
|
194 | (1) |
|
Putting a cancelled order back on order |
|
|
195 | (2) |
|
Chapter 12 Keeping Track of Your Products |
|
|
197 | (16) |
|
|
|
197 | (4) |
|
|
|
199 | (1) |
|
|
|
199 | (1) |
|
Using the stock shortfall facility |
|
|
200 | (1) |
|
Understanding a Bill of Materials |
|
|
201 | (5) |
|
Creating a bill of materials |
|
|
202 | (2) |
|
Checking stock availability for a BOM |
|
|
204 | (1) |
|
Transferring stock for a BOM |
|
|
205 | (1) |
|
|
|
206 | (2) |
|
|
|
208 | (5) |
|
Changing stock allocation |
|
|
210 | (1) |
|
|
|
210 | (3) |
|
Chapter 13 Managing Projects |
|
|
213 | (16) |
|
Appointing a Project's Status and Costs |
|
|
213 | (4) |
|
|
|
214 | (1) |
|
Looking at costs - types and codes |
|
|
215 | (1) |
|
Changing status and costs |
|
|
216 | (1) |
|
Managing Project Resources |
|
|
217 | (1) |
|
Creating or amending a resource |
|
|
217 | (1) |
|
|
|
218 | (1) |
|
|
|
218 | (5) |
|
Sharing out project charges |
|
|
219 | (1) |
|
Issuing stock to a project |
|
|
220 | (2) |
|
Counting costs from a supplier invoice |
|
|
222 | (1) |
|
Integrating POP with project costing |
|
|
222 | (1) |
|
|
|
223 | (3) |
|
Looking at the project's activity |
|
|
224 | (2) |
|
Comparing costs to budget |
|
|
226 | (1) |
|
Charging Your Customers for a Project |
|
|
226 | (2) |
|
|
|
228 | (1) |
|
Chapter 14 Using Foreign Currencies |
|
|
229 | (18) |
|
Setting Up Foreign Currencies |
|
|
230 | (3) |
|
Entering the exchange rate for a currency |
|
|
231 | (1) |
|
Amending the Countries table |
|
|
231 | (2) |
|
Tailoring the Foreign Trader Tool |
|
|
233 | (1) |
|
Keeping Trade Status in Mind when Setting Up Accounts |
|
|
234 | (2) |
|
|
|
236 | (3) |
|
Raising invoices, credit notes and orders |
|
|
236 | (2) |
|
Entering batch invoices and credit notes |
|
|
238 | (1) |
|
Banking on Foreign Currencies |
|
|
239 | (5) |
|
Customer receipts and supplier payments |
|
|
239 | (2) |
|
Carrying out a bank transfer |
|
|
241 | (1) |
|
Expecting changing exchange rates |
|
|
242 | (2) |
|
Doing Revaluations with the Wizard |
|
|
244 | (3) |
|
Part IV Running Monthly Quarterly and Annual Routines |
|
|
247 | (54) |
|
Chapter 15 Reconciling Your Bank Accounts |
|
|
249 | (12) |
|
Recognising Reasons to Reconcile |
|
|
249 | (2) |
|
Getting Ready to Reconcile |
|
|
251 | (1) |
|
Doing the Actual Reconciliation |
|
|
251 | (5) |
|
Troubleshooting when Your Account Doesn't Reconcile |
|
|
256 | (1) |
|
|
|
257 | (4) |
|
Listing unpresented cheques and outstanding lodgements |
|
|
258 | (1) |
|
Remembering recurring entries |
|
|
258 | (3) |
|
Chapter 16 Running Your Monthly and Yearly Routines |
|
|
261 | (18) |
|
|
|
262 | (2) |
|
|
|
264 | (1) |
|
Depreciating Fixed Assets |
|
|
265 | (3) |
|
|
|
266 | (1) |
|
Posting assets and depreciation |
|
|
267 | (1) |
|
|
|
268 | (4) |
|
Rattling skeleton journals |
|
|
270 | (1) |
|
|
|
270 | (2) |
|
Carrying Out Your Month-End Routine |
|
|
272 | (3) |
|
Ticking off your checklist |
|
|
272 | (1) |
|
|
|
273 | (1) |
|
Clearing stock transactions |
|
|
274 | (1) |
|
|
|
274 | (1) |
|
|
|
275 | (2) |
|
|
|
277 | (2) |
|
Chapter 17 Running Your VAT Return |
|
|
279 | (22) |
|
Understanding Some VAT Basics |
|
|
279 | (3) |
|
Knowing your outputs from your inputs |
|
|
280 | (1) |
|
|
|
280 | (1) |
|
Comparing Sage's VAT accounting methods |
|
|
281 | (1) |
|
|
|
282 | (3) |
|
|
|
284 | (1) |
|
|
|
285 | (3) |
|
Checking under the standard scheme |
|
|
285 | (2) |
|
Checking with cash accounting |
|
|
287 | (1) |
|
Making Manual Adjustments to Your VAT Return |
|
|
288 | (1) |
|
Reconciling Your VAT Transactions |
|
|
289 | (1) |
|
Submitting Your VAT Return |
|
|
290 | (2) |
|
Posting your return online via Sage |
|
|
290 | (1) |
|
Submitting your VAT return manually via HMRC |
|
|
291 | (1) |
|
Posting your refund/payment in Sage |
|
|
291 | (1) |
|
|
|
292 | (1) |
|
|
|
292 | (6) |
|
Going from standard to VAT cash accounting or the UK flat rate |
|
|
293 | (1) |
|
|
|
294 | (1) |
|
Making the switch from VAT cash or flat rate cash to standard accounting |
|
|
295 | (1) |
|
Reconciling the sales tax and purchase tax control accounts |
|
|
296 | (2) |
|
|
|
298 | (1) |
|
|
|
298 | (3) |
|
|
|
301 | (66) |
|
Chapter 18 Running Monthly Reports |
|
|
303 | (18) |
|
Making the Most of Standard Reports |
|
|
303 | (1) |
|
Checking the Chart of Accounts First |
|
|
304 | (1) |
|
Figuring Out the Financial Reports |
|
|
305 | (5) |
|
Trying for an initial Trial Balance |
|
|
305 | (1) |
|
Accounting for profit and loss |
|
|
306 | (2) |
|
Weighing the Balance Sheet |
|
|
308 | (2) |
|
Keeping an Eye on Your Budget Report |
|
|
310 | (1) |
|
Looking Back with the Prior Year Report |
|
|
311 | (1) |
|
|
|
311 | (2) |
|
Forgetting the Periods and Going Transactional |
|
|
313 | (3) |
|
|
|
314 | (1) |
|
|
|
314 | (1) |
|
|
|
314 | (2) |
|
Designing Reports to Suit Yourself |
|
|
316 | (5) |
|
Chapter 19 Tackling the Complicated Stuff |
|
|
321 | (16) |
|
|
|
321 | (3) |
|
Sending spreadsheet stuff |
|
|
322 | (1) |
|
Transferring Outlook contacts |
|
|
322 | (1) |
|
|
|
323 | (1) |
|
Choosing an alternative export method |
|
|
324 | (1) |
|
|
|
324 | (3) |
|
Linking to Your Accountant |
|
|
327 | (1) |
|
Sending accounts to your accountant |
|
|
327 | (1) |
|
Getting back adjustments and narratives |
|
|
328 | (1) |
|
|
|
328 | (6) |
|
Configuring your e-Banking |
|
|
329 | (1) |
|
|
|
330 | (2) |
|
Reconciling electronically |
|
|
332 | (2) |
|
Working with Document Manager |
|
|
334 | (3) |
|
Adding attachments and filing system references |
|
|
335 | (1) |
|
|
|
336 | (1) |
|
Chapter 20 Running Key Reports |
|
|
337 | (18) |
|
Checking Activity through the Nominal Codes |
|
|
337 | (2) |
|
Looking into Supplier Activity |
|
|
339 | (2) |
|
Tracking Customer Activity |
|
|
341 | (1) |
|
Checking Numbers with Supplier Daybook Reports |
|
|
342 | (1) |
|
Finding the Customers Who Owe You |
|
|
343 | (2) |
|
Paying Attention to Your Creditors |
|
|
345 | (2) |
|
Handling Unreconciled Bank Transactions |
|
|
347 | (2) |
|
Surveying Your Profit and Loss-Actual, Budget and Prior Year |
|
|
349 | (2) |
|
Doing a Monthly Breakdown of Profit and Loss |
|
|
351 | (1) |
|
Ranking Your Top Customers |
|
|
352 | (3) |
|
|
|
355 | (12) |
|
Installing Sage 50 Mobile |
|
|
356 | (3) |
|
|
|
356 | (3) |
|
Navigating around Sage 50 Mobile |
|
|
359 | (8) |
|
|
|
359 | (2) |
|
|
|
361 | (1) |
|
|
|
362 | (1) |
|
|
|
363 | (4) |
|
|
|
367 | (14) |
|
Chapter 22 Ten (Okay, Eleven) Funky Functions |
|
|
369 | (4) |
|
Browsing for Help with F1 |
|
|
369 | (1) |
|
Calculating Stuff with F2 |
|
|
370 | (1) |
|
Accessing an Edit Item Line for Invoicing with F3 |
|
|
370 | (1) |
|
Finding Multiple Functions at F4 |
|
|
370 | (1) |
|
Calculating Currency or Checking Spelling with F5 |
|
|
370 | (1) |
|
|
|
371 | (1) |
|
|
|
371 | (1) |
|
|
|
371 | (1) |
|
Calculating Net Amounts with F9 |
|
|
372 | (1) |
|
Launching Windows with F11 |
|
|
372 | (1) |
|
Opening Report Designer with F12 |
|
|
372 | (1) |
|
Chapter 23 Ten (Or More) Wizards to Conjure |
|
|
373 | (8) |
|
Creating a New Customer Account |
|
|
373 | (1) |
|
Setting up a New Supplier |
|
|
374 | (1) |
|
Initiating a New Nominal Account |
|
|
374 | (1) |
|
Creating a New Bank Account |
|
|
375 | (1) |
|
|
|
375 | (1) |
|
Starting Up a New Project |
|
|
375 | (1) |
|
Helping Out at Month-End: Opening/Closing Stock |
|
|
376 | (1) |
|
Fuelling Up: Scale Charges |
|
|
376 | (1) |
|
Helping with Your Bookkeeping: VAT Transfer |
|
|
377 | (1) |
|
Saving Time: Global Changes |
|
|
377 | (1) |
|
Handling Currencies: Foreign Trader Setup |
|
|
378 | (1) |
|
Keeping Others in the Loop: Accountant Link |
|
|
379 | (2) |
| Appendix: Glossary |
|
381 | (4) |
| Index |
|
385 | |
