Create a tutorial file with examples

In this article

When you create a new template file for beginners it is also suitable to create a tutorial file with example of opening balances, accounting and budget transactions.

The examples will depend on the specific purpose of the template, but it may be helpful to follow a similar approach and give an overview of the most used Transactions and Budget cases.

Opening Balances

Fill the column opening balances with amounts for the Assets, Liabilities and Equity.

Use simple rounded amounts.

Examples Of Accounting Transactions

Give examples of different Transactions type, without repeating too much the same case.
When it make sense, use the following sequence:

  • Simple Transactions (direct Debit and Credit):
    • Revenue Income going to the bank or the Cash.
    • Equity capital going to the Bank.
    • Loan going to the Bank.
    • Expense payed with the Cash or Bank.
    • Purchase of Material payed with Bank.
    • Transfer from Bank to Cash.
    • Transfer from Cash To Bank.
    • Partial Repayment of a Loan.
  • Transactions with multiple accounts:
    • Bank income split on multiple Sales or Service account.
    • Bank payment with multiple Costs.
  • Transactions with VAT (When applicable):
    • Sales.
    • Purchase.
  • Customers
    • Issue of an invoice.
    • Receive payment of an open invoice.
    • Issue of Credit note.
  • Suppliers
    • Bill received.
    • Bill payment.
    • Receive a Credit note.
  • End of year Transactions
    • Depreciation of Material.
    • Interest income.
    • Interest on Loan.
    • Active accruals.
    • Passive accruals.
  • Cost Centers
  • Segments

Budget Transactions

  • Not recurring revenues and expenses (no repetition code)
    • Income as Equity advance.
    • One time Sale.
    • One time expense.
    • One time payment with Bank with multiple costs.
    • Buying of Assets (Material).
  • Monthly recurring revenues and expenses (Repetition M)
    The most part of Income and Expenses are made on a monthly base.
    • Revenues from sales
    • All other Expenses.
  • Quarter recurring revenues and expenses (Repetition 3M)
    • Interest income.
    • Interest on Loan.
  • Semester recurring revenues and expenses (Repetition 6M)
  • End of Year (Repetition Y)
    • Depreciation.
    • Loan repayment.
    • Eventually an example of a Loan payment split on Interest and Repayment.

 

Share this article: Twitter | Facebook | LinkedIn | Email