3. Inputting a payment onto the spreadsheet | Coursetakers

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Bank Reconciliation & VAT on Excel

1. Introduction to the course

1. Introduction (2:20)
2. Intro to the fictitious company example - Flower Power (1:42)
3. Background to VAT in the UK (7:53)
4. Skeleton template explained (7:51)

2. Bank Reconciliation

1. Flower Power - income entered (11:37)
2. Input opening and closing balances (1:16)
3. Inputting a payment onto the spreadsheet (4:22)
4. Flower Power expenses entered (12:51)
5. Bank Reconciliation (2:31)
6. VAT return on excel (2:18)
7. Bank Reconciliation & VAT on Excel (1:12)
8. Zoho -Reconcile the bank (7:26)
9. Zoho - unrec transactions report (4:26)

3. Month 2 (July)

1. Enter income - month 2 (6:29)
2. Enter opening and closing bank balances for July (1:29)
3. Enter expenses - month 2 (July) (4:18)
4. Continuing to enter expenses (6:10)
5. How to deal with Credit Cards (13:03)
6. Month 2 - Bank reconciliation (1:17)
7. Month 2 - VAT Return (2:44)

4. Concluding lecture

1. How to organise your paperwork (8:41)
2. Next steps (1:40)

Teach online with

3. Inputting a payment onto the spreadsheet

Complete and Continue