Cash and AutoCash Transactions
Cash accounts can be used as normal accounts or as autoCash
Definitions
We start with the following accounts and transaction categories
Deposit Accounts
| Name |
Parent |
Category |
Currency |
Starting Balance |
| BarclaysCurrent |
Barclays |
Checking |
GBP |
£10,000.00 |
| StarlingEuro |
Starling |
Checking |
EUR |
€5,000.00 |
Cash Accounts
| Name |
Category |
Currency |
Starting Balance |
AutoPayee |
AutoExpense |
| CashWallet |
Cash |
GBP |
£10.00 |
|
|
| EurosWallet |
Cash |
EUR |
|
|
|
Payee Accounts
| Name |
Type |
| ASDA |
Payee |
| CashExpense |
Payee |
| Market |
Market |
| Barclays |
Institution |
| Starling |
Institution |
TransactionCategories
| Name |
Type |
| Expenses:Cash |
Expense |
| Shopping:Food |
Expense |
| Market:CurrencyAdjust |
CurrencyFluctuation |
Transactions
We have the following events
Transactions
| Date |
Account |
Category |
Amount |
Direction |
Partner |
| 01-Jun-1987 |
BarclaysCurrent |
Transfer |
£50.00 |
To |
Cash |
| 02-Jun-1987 |
Cash |
Transfer |
£20.00 |
To |
BarclaysCurrent |
| 03-Jun-1987 |
Cash |
Shopping:Food |
£12.00 |
To |
ASDA |
| 04-Jun-1987 |
Cash |
Shopping:Food |
£6.00 |
From |
ASDA |
| 05-Jun-1987 |
BarclaysCurrent |
Transfer |
£22.00 |
To |
CashWallet |
| 06-Jun-1987 |
CashWallet |
Transfer |
£7.00 |
To |
BarclaysCurrent |
| 07-Jun-1987 |
StarlingEuro |
Transfer |
€65.00 |
To |
EurosCash |
| 08-Jun-1987 |
EurosCash |
Transfer |
€14.00 |
To |
StarlingEuro |
| 09-Jun-1987 |
EurosCash |
Shopping:Food |
€17.00 |
To |
ASDA |
| 10-Jun-1987 |
EurosCash |
Shopping:Food |
€8.00 |
From |
ASDA |
| 11-Jun-1987 |
StarlingEuro |
Transfer |
€13.00 |
To |
EurosWallet |
| 12-Jun-1987 |
EurosWallet |
Transfer |
€8.50 |
To |
StarlingEuro |
ExchangeRates
| Date |
USD |
EUR |
| 06-Apr-1980 |
0.800000 |
0.900000 |
| 01-Jan-2025 |
0.850000 |
0.950000 |
Analysis
The analysis of these transactions is as follows
AssetAnalysis
| Date |
BarclaysCurrent |
StarlingEuro |
CashWallet |
EurosWallet |
| EUR |
GBP |
EUR |
GBP |
| 06-Apr-1980 |
£10,000.00 |
€5,000.00 |
£4,500.00 |
£10.00 |
|
|
| 01-Jun-1987 |
£9,950.00 |
€5,000.00 |
£4,500.00 |
£10.00 |
|
|
| 02-Jun-1987 |
£9,970.00 |
€5,000.00 |
£4,500.00 |
£10.00 |
|
|
| 03-Jun-1987 |
£9,970.00 |
€5,000.00 |
£4,500.00 |
£10.00 |
|
|
| 04-Jun-1987 |
£9,970.00 |
€5,000.00 |
£4,500.00 |
£10.00 |
|
|
| 05-Jun-1987 |
£9,948.00 |
€5,000.00 |
£4,500.00 |
£32.00 |
|
|
| 06-Jun-1987 |
£9,955.00 |
€5,000.00 |
£4,500.00 |
£25.00 |
|
|
| 07-Jun-1987 |
£9,955.00 |
€4,935.00 |
£4,441.50 |
£25.00 |
|
|
| 08-Jun-1987 |
£9,955.00 |
€4,949.00 |
£4,454.10 |
£25.00 |
|
|
| 09-Jun-1987 |
£9,955.00 |
€4,949.00 |
£4,454.10 |
£25.00 |
|
|
| 10-Jun-1987 |
£9,955.00 |
€4,949.00 |
£4,454.10 |
£25.00 |
|
|
| 11-Jun-1987 |
£9,955.00 |
€4,936.00 |
£4,442.40 |
£25.00 |
€13.00 |
£11.70 |
| 12-Jun-1987 |
£9,955.00 |
€4,944.50 |
£4,450.05 |
£25.00 |
€4.50 |
£4.05 |
| 01-Jan-2025 |
£9,955.00 |
€4,944.50 |
£4,697.28 |
£25.00 |
€4.50 |
£4.28 |
| Profit |
£171.56 |
PayeeAnalysis
| Date |
ASDA |
CashExpense |
Market |
| 01-Jun-1987 |
|
-£50.00 |
|
| 02-Jun-1987 |
|
-£30.00 |
|
| 03-Jun-1987 |
-£12.00 |
-£18.00 |
|
| 04-Jun-1987 |
-£6.00 |
-£24.00 |
|
| 05-Jun-1987 |
-£6.00 |
-£24.00 |
|
| 06-Jun-1987 |
-£6.00 |
-£24.00 |
|
| 07-Jun-1987 |
-£6.00 |
-£82.50 |
|
| 08-Jun-1987 |
-£6.00 |
-£69.90 |
|
| 09-Jun-1987 |
-£21.30 |
-£54.60 |
|
| 10-Jun-1987 |
-£14.10 |
-£61.80 |
|
| 11-Jun-1987 |
-£14.10 |
-£61.80 |
|
| 12-Jun-1987 |
-£14.10 |
-£61.80 |
|
| 01-Jan-2025 |
-£14.10 |
-£61.80 |
£247.46 |
| Profit |
£171.56 |
TransactionCategoryAnalysis
| Date |
Expenses:
Cash
|
Shopping:
Food
|
Market:
CurrencyAdjust
|
| 01-Jun-1987 |
-£50.00 |
|
|
| 02-Jun-1987 |
-£30.00 |
|
|
| 03-Jun-1987 |
-£18.00 |
-£12.00 |
|
| 04-Jun-1987 |
-£24.00 |
-£6.00 |
|
| 05-Jun-1987 |
-£24.00 |
-£6.00 |
|
| 06-Jun-1987 |
-£24.00 |
-£6.00 |
|
| 07-Jun-1987 |
-£82.50 |
-£6.00 |
|
| 08-Jun-1987 |
-£69.90 |
-£6.00 |
|
| 09-Jun-1987 |
-£54.60 |
-£21.30 |
|
| 10-Jun-1987 |
-£61.80 |
-£14.10 |
|
| 11-Jun-1987 |
-£61.80 |
-£14.10 |
|
| 12-Jun-1987 |
-£61.80 |
-£14.10 |
|
| 01-Jan-2025 |
-£61.80 |
-£14.10 |
£247.46 |
| Profit |
£171.56 |
TaxAnalysis
| Date |
Market |
Expense |
| 01-Jun-1987 |
|
-£50.00 |
| 02-Jun-1987 |
|
-£30.00 |
| 03-Jun-1987 |
|
-£30.00 |
| 04-Jun-1987 |
|
-£30.00 |
| 05-Jun-1987 |
|
-£30.00 |
| 06-Jun-1987 |
|
-£30.00 |
| 07-Jun-1987 |
|
-£88.50 |
| 08-Jun-1987 |
|
-£75.90 |
| 09-Jun-1987 |
|
-£75.90 |
| 10-Jun-1987 |
|
-£75.90 |
| 11-Jun-1987 |
|
-£75.90 |
| 12-Jun-1987 |
|
-£75.90 |
| 01-Jan-2025 |
£247.46 |
-£75.90 |
| Profit |
£171.56 |