* To finish off this simple spreadsheet, it might be helpful to make it look slightly more presentable.Select Row 1 (by clicking on the 1) and then bring up the Format Cells dialog box (either by Menu|Format, keyboard shortcut or right mouse button menu) and then you can make the text bold (Font tab), colour [read more]
Simple Sales Ledger in Excel II*To format the numbers (in columns D,E, & F) so that they all have 2 decimal places, select these columns (by clicking at the top (where the column letter is) and then chosing Format|Cells and then (on the number tab) click number and make sure that there is a 2 in decimal places. I also [read more] |
|
Simple Sales Ledger in Excel I*First begin by heading up the columns, in cell A1: date of invoice invoice number (the number that you assign, since these are your sales invoices) customer net amount (if registered for VAT, if not registered for VAT, then head this column “gross amount”) VAT (omit this if not registered for VAT) gross amount credit [read more] |
Advantages of Double Entry Bookkeeping*Double Entry Bookkeeping dates back to Venice, 1494. As it’s name suggests, it means that every transaction is entered twice into the “books” of a business. Once as a debit and once as a credit. (How this works in detail will be the subject of a later post) It provides a specific means of dealing [read more] |
Simple Purchase Ledger in Excel IV*To use the purchase ledger spreadsheet is easy. Just record all purchase invoices, receipts and other payments on the spreadsheet. Allow one row per invoice/receipt. Enter the total amounts in columns D/E/F (allowing for the VAT split if VAT registered) and then allocate the relevent amounts in the appropriate analysis columns (column I to N [read more] |
 Simple Purchase Ledger in Excel I*First begin by heading up the columns, in cell A1: date supplier ref/invoice number net amount (if registered for VAT, if not registered for VAT, then head this column “gross amount”) VAT (omit this if not registered for VAT) date paid check zero stationery (analysis column) postage (analysis column) telephone (analysis column) electricity (analysis column) [read more] |
