| 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 |
|
|
1 | (24) |
|
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 Setup Wizard |
|
|
10 | (6) |
|
Registering Your Software |
|
|
16 | (1) |
|
Finding Out How Easy Sage Is to Use |
|
|
17 | (7) |
|
|
|
17 | (1) |
|
|
|
18 | (6) |
|
|
|
24 | (1) |
|
Chapter 2 Creating Your Chart of Accounts and Assigning Nominal Codes |
|
|
25 | (20) |
|
Understanding as Much as You Need to about Accounting |
|
|
26 | (2) |
|
Dabbling in double-entry bookkeeping |
|
|
26 | (1) |
|
|
|
27 | (1) |
|
|
|
27 | (1) |
|
Looking at the Structure of Your COA |
|
|
28 | (1) |
|
Checking out the default COA |
|
|
29 | (2) |
|
Identifying balance sheet codes |
|
|
31 | (2) |
|
Looking at profit and loss codes |
|
|
33 | (3) |
|
Leaving gaps and mirroring codes |
|
|
36 | (1) |
|
Accommodating floating nominals |
|
|
36 | (1) |
|
|
|
37 | (5) |
|
|
|
37 | (2) |
|
|
|
39 | (3) |
|
|
|
42 | (3) |
|
|
|
42 | (1) |
|
Looking at some common errors |
|
|
43 | (2) |
|
Chapter 3 Setting Up Records |
|
|
45 | (26) |
|
Choosing How to Create Your Records |
|
|
45 | (1) |
|
Getting a quick start using the New icon |
|
|
46 | (1) |
|
Following the wizards brick by brick |
|
|
46 | (1) |
|
Creating Customer and Supplier Records |
|
|
46 | (6) |
|
Setting customer and supplier defaults |
|
|
49 | (2) |
|
Deleting customer and supplier records |
|
|
51 | (1) |
|
|
|
51 | (1) |
|
Creating Your Nominal Records |
|
|
52 | (7) |
|
Exploring your nominal records |
|
|
52 | (2) |
|
Renaming existing nominal records |
|
|
54 | (1) |
|
Adding a new nominal record |
|
|
54 | (1) |
|
Looking for a nominal record |
|
|
55 | (2) |
|
Looking around a nominal record |
|
|
57 | (1) |
|
|
|
58 | (1) |
|
Recording Your Bank Accounts |
|
|
59 | (3) |
|
Renaming an existing account |
|
|
60 | (1) |
|
|
|
60 | (2) |
|
|
|
62 | (1) |
|
Getting Your Product Records in Order |
|
|
62 | (6) |
|
Creating a product record |
|
|
63 | (2) |
|
|
|
65 | (1) |
|
Deleting a product record |
|
|
66 | (1) |
|
Entering a project record |
|
|
66 | (2) |
|
Setting Up Fixed Asset Records |
|
|
68 | (3) |
|
Chapter 4 Recording Your Opening Balances |
|
|
71 | (18) |
|
Timing Your Switch to Sage |
|
|
72 | (1) |
|
Obtaining Your Opening Balances |
|
|
72 | (2) |
|
Entering Opening Balances Using the Wizard |
|
|
74 | (8) |
|
Entering your default date |
|
|
75 | (1) |
|
Entering customer and supplier balances |
|
|
76 | (1) |
|
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 | (2) |
|
Entering the uncleared transactions for your bank account |
|
|
80 | (1) |
|
Checking opening balances against the trial balance from your accountant |
|
|
81 | (1) |
|
|
|
81 | (1) |
|
|
|
81 | (1) |
|
Manually Entering Information |
|
|
82 | (5) |
|
Manually recording opening balances |
|
|
82 | (1) |
|
Manually recording opening bank balances |
|
|
83 | (1) |
|
Manually recording nominal opening balances |
|
|
84 | (1) |
|
Putting in opening balances for products |
|
|
85 | (2) |
|
Checking Your Opening Balances |
|
|
87 | (2) |
|
Printing an opening trial balance |
|
|
87 | (1) |
|
|
|
87 | (2) |
|
PART 2 LOOKING INTO DAY-TO-DAY FUNCTIONS |
|
|
89 | (78) |
|
Chapter 5 Processing Your Customer Paperwork |
|
|
91 | (12) |
|
Posting Batch Entry Invoices |
|
|
91 | (3) |
|
|
|
94 | (2) |
|
Registering Payments from Your Customers |
|
|
96 | (6) |
|
Giving credit where due -- allocating credit notes |
|
|
99 | (2) |
|
Recording payments on account |
|
|
101 | (1) |
|
Deleting Invoices and Credit Notes |
|
|
102 | (1) |
|
Chapter 6 Invoicing Your Customers |
|
|
103 | (18) |
|
Deciding on an Invoice Type |
|
|
104 | (1) |
|
|
|
104 | (9) |
|
|
|
105 | (2) |
|
Getting to the main attraction |
|
|
107 | (2) |
|
Filling in the order details |
|
|
109 | (1) |
|
Getting down to the footer details |
|
|
110 | (1) |
|
Going over payment details |
|
|
111 | (1) |
|
Checking your profit on a product invoice |
|
|
112 | (1) |
|
Remembering that Communication Is Key |
|
|
113 | (1) |
|
Managing Your Invoice List |
|
|
114 | (4) |
|
|
|
114 | (2) |
|
|
|
116 | (1) |
|
|
|
116 | (2) |
|
|
|
118 | (1) |
|
Saving Time While You Ask for Money |
|
|
118 | (3) |
|
Duplicating existing invoices |
|
|
118 | (1) |
|
Repeating recurring transactions |
|
|
118 | (2) |
|
|
|
120 | (1) |
|
|
|
120 | (1) |
|
Chapter 7 Dealing with Paperwork from Your Suppliers |
|
|
121 | (12) |
|
Receiving and Posting Invoices |
|
|
121 | (4) |
|
Setting up your receiving system |
|
|
122 | (1) |
|
|
|
122 | (3) |
|
|
|
125 | (2) |
|
|
|
127 | (1) |
|
|
|
128 | (2) |
|
Printing a Remittance Advice Note |
|
|
130 | (3) |
|
Chapter 8 Recording Your Bank Entries |
|
|
133 | (18) |
|
Understanding the Different Types of Bank Account |
|
|
134 | (2) |
|
Keeping up with current (1200) and deposit (1210) accounts |
|
|
134 | (1) |
|
Counting the petty cash (1230) account |
|
|
135 | (1) |
|
Handling your cash register (1235) |
|
|
135 | (1) |
|
Managing the company credit card (1240) and credit card receipts (1250) |
|
|
136 | (1) |
|
Tracking Bank Deposits and Payments |
|
|
136 | (4) |
|
Transferring Funds between Accounts |
|
|
140 | (1) |
|
Repeating Recurring Entries |
|
|
141 | (6) |
|
Going for consistency with your bank entries |
|
|
141 | (3) |
|
Repeating customer and supplier payments |
|
|
144 | (1) |
|
Making regular journal entries - if you dare |
|
|
144 | (1) |
|
Processing and posting recurring entries |
|
|
145 | (2) |
|
|
|
147 | (1) |
|
|
|
147 | (1) |
|
Making payments from the tin |
|
|
147 | (1) |
|
Reconciling the petty cash tin |
|
|
148 | (1) |
|
Paying the Credit Card Bill |
|
|
148 | (3) |
|
Making credit card payments |
|
|
148 | (1) |
|
Reconciling the credit card statement |
|
|
149 | (2) |
|
Chapter 9 Maintaining and Correcting Entries |
|
|
151 | (16) |
|
Finding Ways to Find Transactions |
|
|
151 | (2) |
|
|
|
153 | (1) |
|
|
|
154 | (2) |
|
|
|
156 | (1) |
|
|
|
157 | (1) |
|
Checking and Maintaining Your Files |
|
|
158 | (3) |
|
|
|
158 | (1) |
|
|
|
159 | (2) |
|
|
|
161 | (1) |
|
|
|
161 | (1) |
|
|
|
161 | (1) |
|
Backing Up Data the Manual Way |
|
|
161 | (2) |
|
|
|
163 | (1) |
|
|
|
164 | (3) |
|
PART 3 FUNCTIONS FOR PLUS AND PROFESSIONAL USERS |
|
|
167 | (90) |
|
Chapter 10 Processing Sales Orders |
|
|
169 | (20) |
|
|
|
169 | (4) |
|
Amending your invoice and order defaults |
|
|
170 | (1) |
|
|
|
170 | (2) |
|
Allocating and amending stock for a quote |
|
|
172 | (1) |
|
Converting a quotation to an invoice or order |
|
|
172 | (1) |
|
|
|
173 | (7) |
|
Entering the sales order details |
|
|
174 | (3) |
|
|
|
177 | (1) |
|
|
|
178 | (1) |
|
Putting sales orders on hold |
|
|
179 | (1) |
|
Duplicating a sales order |
|
|
179 | (1) |
|
|
|
180 | (1) |
|
Allocating Stock to an Order |
|
|
180 | (5) |
|
|
|
180 | (1) |
|
|
|
181 | (1) |
|
Amending the allocation of stock |
|
|
181 | (1) |
|
Using the shortfall generator |
|
|
182 | (1) |
|
|
|
183 | (1) |
|
|
|
183 | (1) |
|
Using goods despatched notes |
|
|
183 | (1) |
|
Using the despatch facility |
|
|
184 | (1) |
|
Recording a despatch manually |
|
|
184 | (1) |
|
|
|
185 | (1) |
|
Deleting and Cancelling Sales Orders |
|
|
186 | (3) |
|
|
|
186 | (1) |
|
|
|
187 | (2) |
|
Chapter 11 Processing Purchase Orders |
|
|
189 | (16) |
|
Creating, Changing and Copying a Purchase Order |
|
|
190 | (4) |
|
Creating a purchase order |
|
|
190 | (2) |
|
|
|
192 | (1) |
|
Duplicating a purchase order |
|
|
193 | (1) |
|
Placing the Goods on Order |
|
|
194 | (2) |
|
Ordering via the conventional method |
|
|
194 | (1) |
|
Manually placing goods on order |
|
|
195 | (1) |
|
Completing Your Purchase Order |
|
|
196 | (1) |
|
Printing Your Purchase Order |
|
|
197 | (1) |
|
|
|
198 | (3) |
|
Using goods received notes |
|
|
198 | (2) |
|
Accepting delivery of everything |
|
|
200 | (1) |
|
Taking in part of an order |
|
|
200 | (1) |
|
Creating an Invoice from an Order |
|
|
201 | (2) |
|
Deleting, Cancelling and Reinstating Orders |
|
|
203 | (2) |
|
|
|
203 | (1) |
|
|
|
204 | (1) |
|
Putting a cancelled order back on order |
|
|
204 | (1) |
|
Chapter 12 Keeping Track of Your Products |
|
|
205 | (16) |
|
|
|
205 | (2) |
|
|
|
207 | (1) |
|
|
|
208 | (1) |
|
|
|
208 | (1) |
|
Using the stock shortfall facility |
|
|
209 | (1) |
|
Understanding a Bill of Materials |
|
|
210 | (5) |
|
|
|
211 | (2) |
|
Checking stock availability for a BOM |
|
|
213 | (1) |
|
Transferring stock for a BOM |
|
|
214 | (1) |
|
|
|
215 | (2) |
|
|
|
217 | (4) |
|
Changing stock allocation |
|
|
219 | (1) |
|
|
|
219 | (2) |
|
Chapter 13 Managing Projects |
|
|
221 | (18) |
|
Appointing a Project's Status and Costs |
|
|
222 | (3) |
|
|
|
222 | (1) |
|
Looking at costs -- types and codes |
|
|
223 | (1) |
|
Changing status and costs |
|
|
224 | (1) |
|
Managing Project Resources |
|
|
225 | (2) |
|
Creating or amending a resource |
|
|
226 | (1) |
|
|
|
226 | (1) |
|
|
|
227 | (5) |
|
Sharing out project charges |
|
|
227 | (1) |
|
Issuing stock to a project |
|
|
228 | (2) |
|
Counting costs from a supplier invoice |
|
|
230 | (1) |
|
Integrating POP with project costing |
|
|
230 | (2) |
|
|
|
232 | (3) |
|
Looking at the project's activity |
|
|
232 | (2) |
|
Comparing costs and budget |
|
|
234 | (1) |
|
Charging Your Customers for a Project |
|
|
235 | (1) |
|
|
|
236 | (3) |
|
Chapter 14 Using Foreign Currencies |
|
|
239 | (18) |
|
Setting Up Foreign Currencies |
|
|
240 | (3) |
|
Entering the exchange rate for a currency |
|
|
240 | (2) |
|
Amending the Countries table |
|
|
242 | (1) |
|
Tailoring the Foreign Trader Tool |
|
|
243 | (1) |
|
Keeping Trade Status in Mind When Setting Up Accounts |
|
|
244 | (1) |
|
|
|
245 | (4) |
|
Raising invoices, credit notes and orders |
|
|
246 | (2) |
|
Entering batch invoices and credit notes |
|
|
248 | (1) |
|
Banking on Foreign Currencies |
|
|
249 | (5) |
|
Coping with customer receipts and supplier payments |
|
|
249 | (2) |
|
Carrying out a bank transfer |
|
|
251 | (2) |
|
Expecting changing exchange rates |
|
|
253 | (1) |
|
Doing Revaluations with the Wizard |
|
|
254 | (3) |
|
PART 4 RUNNING MONTHLY, QUARTERLY AND ANNUAL ROUTINES |
|
|
257 | (62) |
|
Chapter 15 Reconciling Your Bank Accounts |
|
|
259 | (18) |
|
Recognising Reasons to Reconcile |
|
|
260 | (1) |
|
Using Bank Feeds to Post Data into Sage |
|
|
261 | (6) |
|
|
|
261 | (2) |
|
Downloading your bank transactions |
|
|
263 | (1) |
|
Reconciling your downloaded transactions |
|
|
264 | (3) |
|
Double-checking everything |
|
|
267 | (1) |
|
Manually Entering Your Bank Account Data |
|
|
267 | (1) |
|
Using e-Banking to Import Data |
|
|
268 | (1) |
|
|
|
269 | (5) |
|
Troubleshooting When Your Account Doesn't Reconcile |
|
|
274 | (1) |
|
|
|
275 | (2) |
|
Chapter 16 Running Your Monthly and Yearly Routines |
|
|
277 | (20) |
|
|
|
278 | (2) |
|
|
|
280 | (2) |
|
Depreciating Fixed Assets |
|
|
282 | (2) |
|
|
|
282 | (2) |
|
Posting assets and depreciation |
|
|
284 | (1) |
|
|
|
284 | (4) |
|
|
|
285 | (1) |
|
Rattling skeleton journals |
|
|
286 | (1) |
|
|
|
287 | (1) |
|
Carrying Out Your Month-End Routine |
|
|
288 | (6) |
|
Ticking off your checklist |
|
|
288 | (1) |
|
|
|
289 | (2) |
|
Clearing stock transactions |
|
|
291 | (1) |
|
|
|
292 | (1) |
|
|
|
293 | (1) |
|
|
|
294 | (1) |
|
|
|
295 | (2) |
|
Chapter 17 Running Your VAT Return |
|
|
297 | (22) |
|
Understanding Some VAT Basics |
|
|
298 | (3) |
|
Knowing your outputs from your inputs |
|
|
298 | (1) |
|
|
|
298 | (1) |
|
Comparing Sage's VAT accounting methods |
|
|
299 | (2) |
|
|
|
301 | (5) |
|
Preparing your VAT return |
|
|
301 | (3) |
|
Reconciling your VAT return |
|
|
304 | (2) |
|
Checking Your VAT Return Using Reconciliation Reports |
|
|
306 | (3) |
|
Checking under the standard scheme |
|
|
306 | (2) |
|
Checking with cash accounting |
|
|
308 | (1) |
|
Getting ready to reconcile after checking |
|
|
308 | (1) |
|
Completing Your VAT return |
|
|
309 | (4) |
|
|
|
311 | (1) |
|
Submitting your VAT return |
|
|
311 | (2) |
|
Posting your refund or payment in Sage |
|
|
313 | (1) |
|
Investigating Other Useful Icons in Your VAT Module |
|
|
313 | (6) |
|
|
|
313 | (1) |
|
|
|
314 | (1) |
|
Completing the EC Sales list |
|
|
315 | (1) |
|
Understanding the Reverse Charge Sales list |
|
|
315 | (1) |
|
|
|
316 | (1) |
|
Accessing verification reports |
|
|
317 | (2) |
|
|
|
319 | (62) |
|
Chapter 18 Running Monthly Reports |
|
|
321 | (16) |
|
Making the Most of Standard Reports |
|
|
321 | (1) |
|
Checking the Chart of Accounts |
|
|
322 | (1) |
|
Figuring Out the Financial Reports |
|
|
322 | (6) |
|
Trying for an initial trial balance |
|
|
323 | (1) |
|
Accounting for profit and loss |
|
|
324 | (1) |
|
Comparing profits and losses |
|
|
325 | (2) |
|
Weighing the balance sheet |
|
|
327 | (1) |
|
|
|
328 | (2) |
|
Forgetting the Periods and Going Transactional |
|
|
330 | (2) |
|
|
|
330 | (1) |
|
|
|
331 | (1) |
|
|
|
331 | (1) |
|
Designing Reports to Suit Yourself |
|
|
332 | (5) |
|
Chapter 19 Tackling the Complicated Stuff |
|
|
337 | (18) |
|
|
|
337 | (4) |
|
Sending spreadsheet stuff |
|
|
338 | (1) |
|
Transferring Outlook contacts |
|
|
338 | (1) |
|
|
|
339 | (2) |
|
|
|
341 | (3) |
|
Linking to Your Accountant |
|
|
344 | (2) |
|
Sending accounts to your accountant |
|
|
345 | (1) |
|
|
|
345 | (1) |
|
Getting back adjustments and narratives |
|
|
346 | (1) |
|
|
|
346 | (7) |
|
Configuring your e-Banking |
|
|
347 | (1) |
|
|
|
348 | (3) |
|
Reconciling electronically |
|
|
351 | (2) |
|
Working with Document Manager |
|
|
353 | (2) |
|
Adding attachments and filing system references |
|
|
353 | (1) |
|
|
|
354 | (1) |
|
Chapter 20 Running Key Reports |
|
|
355 | (18) |
|
Checking Activity through the Nominal Codes |
|
|
355 | (3) |
|
Looking into Supplier Activity |
|
|
358 | (2) |
|
Tracking Customer Activity |
|
|
360 | (1) |
|
Checking Numbers with Supplier Daybook Reports |
|
|
361 | (1) |
|
Finding the Customers Who Owe You |
|
|
362 | (2) |
|
Paying Attention to Your Creditors |
|
|
364 | (2) |
|
Handling Unreconciled Bank Transactions |
|
|
366 | (3) |
|
Doing a Monthly Breakdown of Profit and Loss |
|
|
369 | (1) |
|
Ranking Your Top Customers |
|
|
370 | (3) |
|
|
|
373 | (8) |
|
|
|
373 | (2) |
|
|
|
375 | (4) |
|
Installing Sage 50 Tracker |
|
|
375 | (2) |
|
Looking at the Sage 50 Tracker dashboard |
|
|
377 | (2) |
|
Sussing Out Sage 50 Mobile Sales |
|
|
379 | (1) |
|
Keeping Connected with Connected Users |
|
|
380 | (1) |
|
|
|
381 | (16) |
|
Chapter 22 Ten (Okay, Eleven) Funky Functions in Sage |
|
|
383 | (6) |
|
Browsing for Help with F1 |
|
|
384 | (1) |
|
Calculating Stuff with F2 |
|
|
384 | (1) |
|
Accessing an Edit Item Line for Invoicing with F3 |
|
|
384 | (1) |
|
Finding Multiple Functions with F4 |
|
|
384 | (1) |
|
Calculating Currency or Checking Spelling with F5 |
|
|
385 | (1) |
|
|
|
385 | (1) |
|
|
|
386 | (1) |
|
|
|
386 | (1) |
|
Calculating Net Amounts with F9 |
|
|
386 | (1) |
|
Launching Windows with F11 |
|
|
387 | (1) |
|
Opening Report Designer with F12 |
|
|
387 | (2) |
|
Chapter 23 Ten (Plus One) Wizards to Conjure Up in Sage |
|
|
389 | (8) |
|
Creating a New Customer Account |
|
|
389 | (1) |
|
Setting Up a New Supplier |
|
|
390 | (1) |
|
Initiating a New Nominal Account |
|
|
390 | (1) |
|
Creating a New Bank Account |
|
|
391 | (1) |
|
|
|
391 | (1) |
|
Starting Up a New Project |
|
|
392 | (1) |
|
Helping Out at Month End: Opening/Closing Stock |
|
|
392 | (1) |
|
Fuelling Up: Scale Charges |
|
|
392 | (1) |
|
Saving Time: Global Changes |
|
|
393 | (1) |
|
Handling Currencies: Foreign Bank Revaluation |
|
|
394 | (1) |
|
Keeping Others in the Loop: Accountant Link |
|
|
394 | (3) |
| Index |
|
397 | |
