Accounting Practices and Procedures

This video tutorial guides viewers through creating an accounts receivable ledger in Excel. It explains the purpose of the ledger, how to enter data, calculate balances, and manage payments. The tutorial also covers finalizing the ledger and provides additional resources for further learning.

What is the primary purpose of an accounts receivable ledger?

• To show the total amount owed by customers

• To track expenses

• To calculate taxes

• To manage employee salaries

In the example provided, how much does the company 'Food and Food' owe?

• $25,000

• $5,000

• $50,000

• $1,500

What formula is used to display today's date in the ledger?

• NOW()

• CURRENT_DATE()

• TODAY()

• DATE()

How can you calculate the due date for an invoice?

• By adding 30 days to the invoice date

• By subtracting days from the invoice date

• By using a fixed date

• By adding a specified number of credit days to the invoice date

What happens if a customer makes a part payment?

• The full amount is marked as paid

• The part payment is ignored

• The invoice is canceled

• The balance due is adjusted accordingly

Which formula is used to calculate the balance due?

• A simple plus and minus formula

• MINUS()

• AVERAGE()

• SUM()

What should you do if a customer makes a full payment?

• Delete the invoice

• Enter the full payment amount

• Leave the payment section blank

• Enter zero in the payment section

How is the total balance from all customers calculated?

• By dividing all balances

• By multiplying all balances

• By subtracting all balances

• By adding all balances

What should you do if a customer makes another purchase?

• Add a new entry with a new invoice number

• Update the existing invoice

• Delete the old invoice

• Ignore the new purchase

Where can you find additional resources and videos related to accounting?

• In the video description

• In the comments section

• On the company's website

• On 'listen.org'