| klste@hotmail.de |
Family Budget Management in Excel VBA
Bank opening balance. Family Budget Management in Excel VBA.
The bank's opening balance of 5000 euros is entered.
Two accounts are affected: the “Bank” inventory account and the “Opening balance” inventory account. This entry represents an increase in inventory.
The amount in the “Bank” inventory account increases and the amount in the “Opening balance” inventory account increases.
The total amount in the final balance increases by 5000 euros. The final balance shows the current money supply. That's 5000 euros.
Opening balance of call money. Family Budget Management in Excel VBA.
The opening balance of call money of 20000 euros is entered.
Two accounts are affected: the “Call money” inventory account and the “Opening balance” inventory account. This entry represents an increase in inventory.
The amount in the “Call money” inventory account increases and the amount in the “Opening balance” inventory account increases.
The total amount in the final balance increases by 20000 euros. The final balance shows the current money supply. That's 25000 euros.
The wage. Family Budget Management in Excel VBA.
Wage amounting to 3000 euros were transferred to the account.
Two accounts are affected: the “Bank” inventory account and the “Wage” income account. This entry represents an increase in inventory.
The amount in the “Bank” inventory account increases and the amount in the “Wage” income account increases.
The total amount in the final balance increases by 3000 euros. The final balance shows the current money supply. That's 28000 euros.
The amount shown in the entry is added to the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a profit of 3000 euros.
Buy a car. Family Budget Management in Excel VBA.
Buy a car worth 50000 euros on credit.
Two accounts are affected: the “Car” inventory account and the “Credit” inventory account. This entry represents an increase in inventory.
The amount in the “Car” inventory account increases and the amount in the “Credit” inventory account increases.
The total amount in the final balance increases by 50000 euros. The final balance shows the current money supply. That's 78000 euros.
Payment by credit card. Family Budget Management in Excel VBA.
Purchases of household goods are paid for by credit card, the payment amount is 103.87 euros.
Two accounts are affected: the “Credit card” inventory account and the “Supermarket1” expense account. This entry represents a reduction in inventory.
The amount on the inventory account “Credit card” decreases and the amount on the expense account “Supermarket1” increases.
The total amount in the final balance decreases by 103.87 euros. The final balance shows the current money supply. That's 77896.13 euros.
The amount shown in the booking is deducted from the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a profit of 2896.13 euros.
Cashback on credit card. Family Budget Management in Excel VBA.
Financial institution pays 1 euro cashback on credit card.
Two accounts are affected: the “Credit card” inventory account and the “Cashback” income account. This entry represents an increase in inventory.
The amount in the “Credit card” inventory account increases and the amount in the “Cashback” income account increases.
The total amount in the final balance increases by 1 euro. The final balance shows the current money supply. That's 77897.13 euros.
The amount shown in the entry is added to the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a profit of 2897.13 euros.
Deposit on the credit card. Family Budget Management in Excel VBA.
1000 euros is deposited into the credit card.
Two accounts are affected: the “Credit card” inventory account and the “Bank” inventory account. This entry represents an inventory swap.
The amount in the “Credit card” inventory account increases and the amount on the existing “Bank” account decreases.
The total amount in the final balance remains unchanged. The final balance shows the current money supply. That's 77897.13 euros.
Interest on the car loan. Family Budget Management in Excel VBA.
500 euros interest on the car loan is paid.
Two accounts are affected: the “Bank” inventory account and the “Interest” expense account. This entry represents a reduction in inventory.
The amount on the inventory account “Bank” decreases and the amount on the expense account “Interest” increases.
The total amount in the final balance decreases by 500 euros. The final balance shows the current money supply. That's 77397.13 euros.
The amount shown in the bo1oking is deducted from the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a profit of 2397.13 euros.
Car loan repayment. Family Budget Management in Excel VBA.
Part of the car loan of 2000 euros will be repaid.
Two accounts are affected: the “Credit” inventory account and the “Bank” inventory account. This entry represents an inventory reduction.
The amount in the “Credit” inventory account decreases and the amount in the “Bank” inventory account decreases.
The total amount in the final balance is reduced by 2000 euros. The final balance shows the current money supply. That's 75397.13 euros.
Compensation from car insurance. Family Budget Management in Excel VBA.
After an accident, the car is totaled. The insurance company pays 46,000 euros in compensation.
Two accounts are affected: the “Bank” inventory account and the “Compensation” income account. This entry represents an increase in inventory.
The amount in the “Bank” inventory account increases and the amount in the “Compensation” income account increases.
The total amount in the final balance increases by 46000 euro. The final balance shows the current money supply. That's 121397.13 euros.
The amount shown in the entry is added to the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a profit of 48397.13 euros.
Write-off of the car. Family Budget Management in Excel VBA.
The value of the car, 50000 euros, will be removed from the program.
Two accounts are affected: the “Car” inventory account and the “Write-off” expense account. This entry represents a reduction in inventory.
The amount on the inventory account “Car” decreases and the amount on the expense account “Write-off” increases.
The total amount in the final balance decreases by 50000 euros. The final balance shows the current money supply. That's 71397.13 euros.
The amount shown in the bo1oking is deducted from the P&L (profit and loss).
P&L shows the current success (profit or loss). That's a loss of 1602.87 euros.
Car loan is halved. Family Budget Management in Excel VBA.
The remaining amount of the car loan of 24000 euros will be repaid.
Two accounts are affected: the “Credit” inventory account and the “Bank” inventory account. This entry represents an inventory reduction.
The amount in the “Credit” inventory account decreases and the amount in the “Bank” inventory account decreases.
The total amount in the final balance is reduced by 24000 euros. The final balance shows the current money supply. That's 47397.13 euros.
Change year. Family Budget Management in Excel VBA.
This program only processes data for one year.
At the beginning of a new year, the opening balance of all used inventory accounts is entered.
Before the initial inventory is entered, the current evaluation “Inventory Accounts_List” should be called up. The sheet with the evaluation should be saved as a PDF file.
The year is changed. When changing the year, a new calendar is created and all booking records are deleted, the password is the number 3.
Bank opening balance. Family Budget Management in Excel VBA.
The opening balance of each inventory account is the annual balance of the account from the previous year.
“Bank” and “Opening balance”. This booking is an increase in inventory. The amount in the “Bank” account increases and the amount in the “Opening balance” account increases. The total amount in the final balance increases by 26500 euros. The final balance shows the current money supply. That's 26500 euros.
Opening balance of call money. Family Budget Management in Excel VBA.
The opening balance of each inventory account is the annual balance of the account from the previous year.
“Call money” and “Opening balance”. This booking is an increase in inventory. The amount in the “Call money” account increases and the amount in the “Opening balance” account increases. The total amount in the final balance increases by 20000 euros. The final balance shows the current money supply. That's 46500 euros.
Opening balance of the credit. Family Budget Management in Excel VBA.
The opening balance of each inventory account is the annual balance of the account from the previous year.
“Credit” and “Opening balance”. The “Credit” account contains debts that have been credited to the “Bank” account. This booking is an inventory exchange. The amount in the “Credit” account increases and the amount in the “Opening balance” account decreases. Nothing changes in the final balance. The final balance shows the current money supply. That's 46500 euros.
Opening balance of the credit card. Family Budget Management in Excel VBA.
The opening balance of each inventory account is the annual balance of the account from the previous year.
If the amount on the “Credit card” was greater than zero.
“Credit card” and “Opening balance”. This booking is an increase in inventory. The amount in the “Credit card” account increases and the amount in the “Opening balance” account increases. The total amount in the final balance increases by 897.13 euros. The final balance shows the current money supply. That's 47397.13 euros.
If the amount on the “Credit card” was less than zero.
“Opening balance” and “Credit card”. The “Credit card” account contains debts that have not yet been debited from the “Bank” account. This posting is an inventory reduction. The amount in the “Credit card” account decreases and the amount in the “Opening balance” account decreases. The total amount in the final balance also decreases.
Check entry. Family Budget Management in Excel VBA.
If the opening balance of the inventory accounts is entered, the total amount in the final balance of the previous year should correspond to the total amount in the final balance since the beginning of the current year. This amounts to 47397.13 euros.