The Happy Accountant

The point of carrying out a bank reconciliation is to check that nothing has been missed from the business’s records and also to ensure that there have been no bank errors.
A business’s cash book will rarely agree to the bank statement and it can be easy to miss transactions, such as direct debit payments if a [...]

A journal is usually used to correct errors that have been made.  The errors must be able to be corrected by means of a double entry, to be able to put it right by journalling.
So, if £500 of sales of square widgets had been incorrectly posted to sales of round widgets, the correcting journal would [...]

 T accounts are what ledger accounts might look like if they were kept on paper (as opposed to using computer software). 
They are nothing mysterious, drawn on paper, a T account is quite literally a large T!  The title of the ledger (for example, “motor expenses” is written across the top), debit entries against that account are [...]

To use the sales ledger spreadsheet is easy.  Just record all your sales invoices as you raise them.  Allow one row per invoice.
Enter the total amounts in columns D and E (if VAT registered) and check that the figure in column F is as you have put in your actual sales invoice.
If you give different periods [...]

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 in [...]

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 check [...]

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 period given (if applicable)
date invoice is due
date [...]

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 in [...]

To format the numbers (in columns D,E,F,H onwards) 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 check the [...]

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)
prof fees (analysis column)
[add more analysis columns, as relevant to your business]
description
notes

If [...]