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 |