Built by Maven

Simple Expense Transactions

Simple expenses can be made from any valued account to/from any payee

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
Payee Accounts
Name Type
ASDA Payee
Market Market
Barclays Institution
Starling Institution
TransactionCategories
Name Type
Shopping:Food Expense
Market:CurrencyAdjust CurrencyFluctuation

Transactions

We have the following events

Transactions
Date Account Category Amount Direction Partner
01-Jun-1986 BarclaysCurrent Shopping:Food £21.95 To ASDA
02-Jun-1986 BarclaysCurrent Shopping:Food £9.99 From ASDA
03-Jun-1986 StarlingEuro Shopping:Food €31.20 To ASDA
04-Jun-1986 StarlingEuro Shopping:Food €5.12 From ASDA
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
EUR GBP
06-Apr-1980 £10,000.00 €5,000.00 £4,500.00
01-Jun-1986 £9,978.05 €5,000.00 £4,500.00
02-Jun-1986 £9,988.04 €5,000.00 £4,500.00
03-Jun-1986 £9,988.04 €4,968.80 £4,471.92
04-Jun-1986 £9,988.04 €4,973.92 £4,476.53
01-Jan-2025 £9,988.04 €4,973.92 £4,725.22
Profit £213.26
PayeeAnalysis
Date ASDA Market
01-Jun-1986 -£21.95
02-Jun-1986 -£11.96
03-Jun-1986 -£40.04
04-Jun-1986 -£35.43
01-Jan-2025 -£35.43 £248.69
Profit £213.26
TransactionCategoryAnalysis
Date Shopping:
Food 		Market:
CurrencyAdjust
01-Jun-1986 -£21.95
02-Jun-1986 -£11.96
03-Jun-1986 -£40.04
04-Jun-1986 -£35.43
01-Jan-2025 -£35.43 £248.69
Profit £213.26
TaxAnalysis
Date Market Expense
01-Jun-1986 -£21.95
02-Jun-1986 -£11.96
03-Jun-1986 -£40.04
04-Jun-1986 -£35.43
01-Jan-2025 £248.69 -£35.43
Profit £213.26