Excel Accounts Training Public Class

About the Class

We provide introductory information, then proceed to Opening Balances.

Next we look at the Income and Receipts. We explore the information to identify, and where to record the single entry. On select the posting column, the rest is done by the spreadsheet.

Next we look at Purchases and Payments. We explore the information to identify, and where to record the single entry. On select the posting column, the rest is done by the spreadsheet.

We look at periodical reports; the Income and Receipts Summary, Purchases and Payments Summary, Vat Return, Assets Summary, Liabilities Summary, Trial Balance, Profit and Loss Account, and Balance Sheet.

We look at the two verification methods. The Income and Expenditure Changes, plus Bank Reconciliation. The Trial Balance is not effective since its automated.

We carryout Yearend Procedures, and look at the Yearend Reports.

We cover this in 3, one our sessions online.

Language of instruction: English

Keywords: bookkeeping, accounting, free excel accounts training