Current Account Exercises With Solutions - CORRECT
Uploaded by
ScribdTranslationsCurrent Account Exercises With Solutions - CORRECT
Uploaded by
ScribdTranslationsActivities UD 04 - 9
9. Create a template in a spreadsheet that will help you make the following settlements.
c) Settle the following account using the Hamburg method, in which the account holder has done this
MOTION DATE
FECHA CONCEPT
Must News VALUE
02-May Opening entry 30,000.00 May 3
Check to be deposited on May 14 20,000.00 14-may
23-May check to be paid 5,000.00 23-may
June 11 effective income 3,000.00 June 11
15-Jun direct debit receipt 15,000.00 June 15
June 28 dividend payment 527.00 28-jun
June 30 CLOSURE 30 Jun
Int a n/f 0.00
Int a s/f 31,82
IRCM 6.05
Commission for entry 1.80
Balance as of June 30
account actions by the Hamburg method.
the movements:
BALANCE DAYS OF COMMERCIAL NUMBERS
Deudor Acreedor BALANCE Debtors Creditors
30.000,00 11 330,000.00
50,000.00 9 450,000.00
45,000.00 19 855,000.00
48,000.00 4 192,000.00
33,000.00 13 429.000,00
33.527,00 2 67,054.00
2,323,054.00
33,527.00
TOTAL NC 0.00
33,527.00
33.558,82
33.552,78
33.550,98
33,550.98
33.550,98
Check your learning - Activity 1
Use the spreadsheet template and settle using the hamburger method the following
The company TULSA from Castellón maintains a current account with the financial entity.
MOVEMENT DATE
DATE CONCEPT
There must be VALUE
01-Jun Previous balance 3,500.00 01-Jun
June 2nd Cash entry 10 AM. 1,000.00 02-Jun
June 4 Receipt of check from another entity 1.500,00 June 6
June 6 Buy values 25,000.00 06-jun
June 10 Reimbursement 5,000.00 June 10
June 10 Loan payment 40,000.00 June 10
June 18 Check paid 2,000.00 18-jun
June 20 Cash income 12 h. 50.000,00 June 21
June 25 Sale of securities 30,000.00 26-jun
June 30 CLOSURE June 30
I debtor 118.63
I am a creditor 3.18
IRCM 0.61
Overdraft commission 3.00
Maintenance commission 1,00
Balance as of June 30
current accounts:
BCA account. During the month of June, the following transactions have taken place in the account:
BALANCE DAYS OF COMMERCIAL NUMBERS
Debtor Creditor BALANCE Debtors Creditors
3,500.00 1 3.500,00
4,500.00 4 18,000.00
6,000.00 0 0.00
19,000.00 4 76,000.00
24,000.00 0 0.00
64,000.00 8 512.000,00
66,000.00 3 198,000.00
16,000.00 5 80,000.00
14,000.00 4 56,000.00
14,000.00
TOTAL NC 866,000.00 77,500.00
13,881.37
13,884.55
13.883,95
13.880,95
13.879,95
13,879.95
