*Cash Book The cash book is also a day book. It lists the money paid into and out of the business bank account (as opposed to petty cash). These transactions would include bank transfers, standing orders, direct debits, bank interest and charges. The cash book is normally split into two halves, one for payments and [read more]
Purchase Day Book and Purchases Returns Day Book*Purchase Day Book The Purchase Day Book records all the invoices it receives under the following headings: date supplier purchase ledger folio (reference to the page number of the purchase ledger, in a manual system) total amount invoiced purchases analysis of purchases (eg. telephone, electricity, etc….) The invoice number is not recorded because this is [read more] |
|
Sales Day Book and Sales Returns Day Book*Sales Day Book The sales day book is used to list all the invoices sent out to customers each day. It’s headings might be: data invoice number customer sales ledger folio (cross reference to the sales ledger page number, which a computerised system will reference automatically) total amount of invoice) analysis of tye of sale [read more] |
Informal Networking*Last night I braved the torrential rain (and almost didn’t make it through the flooded back roads) to go to an informal networking event, held at the lovely Strixton Manor. There was also a wine tasting laid on. Unfortunately, because I was driving, I wasn’t able to try any. Because it was informal, it was also [read more] |
Simple Formulae*All formulae in Excel begin with an = sign. Suppose you wish to add the contents of cell A1 and A2 and display the answer in cell A3, put the formua into cell A3: =A1+A2 To add a column of numbers from A1 down to A10, and put the total in cell B1, you could put [read more] |
Cell References*Excel references each cell, co-ordinate style: With absolute references, letters denote columns and numbers are used for rows. Hence B4, is the second column along (from the left) and the fourth row down. (There is another style of cell referencing, called relative referencing) To reference a range of cells (for example, the column of cells [read more] |
Menus, Toolbars, Mouse and Keyboard Shortcuts*As with many other Microsoft applications, there are several ways of doing things. Excel’s commands can be accessed through the menubar at the top. Clicking the righthand mouse button, while the cursor is in a cell, brings up a mini menu of mainly formatting options. There are keyboard short cuts (such as [CTRL] and [SHIFT] and $ [read more] |
