Happy Accountant: Accounting Blog & Online Accountant

* If you are serious about starting an eBay business, then it’s important to get the accounting and bookkeeping in place from the start. eBay traders generally do low value – high volume sales.  This means that if you neglect your bookkeeping, the backlog can buildup quite quickly.  Leaving it until “year end” will create [read more]

*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 [read more]

*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 [read more]

*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]

*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]

*Well, the VAT returns have been done and it’s back to the blog, which has been sorely neglected of late. I have also been reminded of how handy Excel is as a fallback, even though it isn’t necessarily the best tool for the job, it’s relatively painless, reasonably straightforward and fairly easy to follow the “audit trail”. [read more]

*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]