public void EnsureASimpleIncomeTransactionWorks()
{
CSVLineItem t = new CSVLineItem()
{
Account = "Checking Account",
Category = "Income:Available this month",
SubCategory = "Available this month",
Date = new DateTime(2019, 1, 1),
Inflow = "$1,234.56",
Cleared = "C",
MasterCategory = "Income",
Memo = "January Bonus",
Outflow = "$0.00",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
var grouped = Program.GroupLineItems(
new List <CSVLineItem>()
{
t
},
this.accountTypes,
true,
this.unitedStatesCulture);
string expected =
@"2019-01-01 * Megacorp LLC
; January Bonus
Assets:Checking Account $1,234.56
Income:Megacorp LLC -$1,234.56
";
Assert.AreEqual(expected, Program.CreateLedger(grouped));
}
public void EnsureASimpleExpenseTransactionWorks()
{
CSVLineItem t = new CSVLineItem()
{
Account = "Checking Account",
Category = "Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Expenses",
Memo = "Food for party",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
var grouped = Program.GroupLineItems(
new List <CSVLineItem>()
{
t
},
this.accountTypes,
true,
this.unitedStatesCulture);
string expected =
@"2019-01-01 * Megacorp LLC
; Food for party
Assets:Checking Account -$42.42
Expenses:Expenses:Groceries $42.42
";
Assert.AreEqual(expected, Program.CreateLedger(grouped));
}
public void AccountTransferTest()
{
CSVLineItem t = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = string.Empty,
SubCategory = string.Empty,
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = string.Empty,
Memo = "Saving up for college",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Transfer : Savings Account",
};
var grouped = Program.GroupLineItems(
new List <CSVLineItem>()
{
t
},
this.accountTypes,
false,
this.unitedStatesCulture);
string expected =
@"2019-01-01 (123456)
; Saving up for college
Assets:Checking Account -$42.42
Assets:Savings Account $42.42
";
Assert.AreEqual(expected, Program.CreateLedger(grouped));
}
public void EnsureOutputEndsWithNewLine()
{
CSVLineItem t1 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "For the picnic",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
CSVLineItem t2 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123457",
Category = "Monthly Bills:Phone Bill",
SubCategory = "Phone Bill",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "Confirmation Number: 12345",
Outflow = "$42.43",
RunningBalance = "1,234.56",
Payee = "Megamobile LLC",
};
var transactions = Program.GroupLineItems(
new List <CSVLineItem>()
{
t1, t2
},
this.accountTypes,
true,
this.unitedStatesCulture);
string expected =
@"2019-01-01 (123456) * Megacorp LLC
; For the picnic
Assets:Checking Account -$42.42
Expenses:Every Expenses:Groceries $42.42
2019-01-01 (123457) * Megamobile LLC
; Confirmation Number: 12345
Assets:Checking Account -$42.43
Expenses:Every Expenses:Phone Bill $42.43
";
string result = Program.CreateLedger(transactions);
Assert.AreEqual(expected, result);
Assert.IsTrue(result.EndsWith(Environment.NewLine));
}
public void TransactionsWithFlagAreSupported()
{
CSVLineItem t1 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Flag = "Blue",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "(Split 2/2) Meat",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
CSVLineItem t2 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Flag = "Blue",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "(Split 1/2) Produce",
Outflow = "$12.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
var grouped = Program.GroupLineItems(
new List <CSVLineItem>()
{
t1, t2
},
this.accountTypes,
true,
this.unitedStatesCulture);
string expected =
@"2019-01-01 (123456) * Megacorp LLC
; :Blue:
Assets:Checking Account -$54.84
Expenses:Every Expenses:Groceries $12.42 ; Produce
Expenses:Every Expenses:Groceries $42.42 ; Meat
";
Assert.AreEqual(expected, Program.CreateLedger(grouped));
}
public void RarerCurrencySupported()
{
CSVLineItem t1 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Monthly Bills:Phone",
SubCategory = "Phone",
Date = new DateTime(2019, 1, 1),
Inflow = "0,00ден.", // YNAB for some reason puts a period after the currency
Cleared = "C",
MasterCategory = "Monthly Bills",
Memo = "Confirmation #: 1234",
Outflow = "12,48ден.",
RunningBalance = "-12,48ден.",
Payee = "Megacorp LLC",
};
var transactions = Program.GroupLineItems(
new List <CSVLineItem>()
{
t1
},
this.accountTypes,
true,
new CultureInfo("mk"));
// from what I can tell for Macedonian
// positive amoungs have the currency symbol at the end, but negative amounts are in the beginning
// see cultureInfo.NumberFormat.CurrencyPositivePattern/CurrencyNegativePattern
string expected =
@"2019-01-01 (123456) * Megacorp LLC
; Confirmation #: 1234
Assets:Checking Account -ден12,48
Expenses:Monthly Bills:Phone 12,48ден
";
string actual = Program.CreateLedger(transactions);
Assert.AreEqual(expected, actual);
}
public void NonEnUsCultureIsSupported()
{
CSVLineItem t1 = new CSVLineItem()
{
Account = "Compte Chèque",
CheckNumber = "123456",
Category = "Dépenses journalières:Supermarché",
SubCategory = "Supermarché",
Date = new DateTime(2019, 1, 1),
Inflow = "€0,00",
Cleared = "C",
MasterCategory = "Dépenses journalières",
Memo = "Faire des achats",
Outflow = "€1 304,16",
RunningBalance = "€1 234,56",
Payee = "Megacorp LLC",
};
var transactions = Program.GroupLineItems(
new List <CSVLineItem>()
{
t1
},
this.accountTypes,
true,
new CultureInfo("fr-FR"));
string expected =
@"2019-01-01 (123456) * Megacorp LLC
; Faire des achats
Assets:Compte Chèque -€1 304,16
Expenses:Dépenses journalières:Supermarché €1 304,16
";
string actual = Program.CreateLedger(transactions);
Assert.AreEqual(expected, actual);
}
public void SplitMemoBehavesAsExpected()
{
CSVLineItem t1 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "(Split 1/2) This is a test ",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
CSVLineItem t2 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "(Split 2/2)",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
CSVLineItem t3 = new CSVLineItem()
{
Account = "Checking Account",
CheckNumber = "123456",
Category = "Everyday Expenses:Groceries",
SubCategory = "Groceries",
Date = new DateTime(2019, 1, 1),
Inflow = "$0.00",
Cleared = "C",
MasterCategory = "Every Expenses",
Memo = "A regular old transaction",
Outflow = "$42.42",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
var transactions = Program.GroupLineItems(
new List <CSVLineItem>()
{
t1, t2, t3
},
this.accountTypes,
true,
this.unitedStatesCulture);
Assert.AreEqual("This is a test", transactions[0].LineItems[0].MemoWithoutSplit);
Assert.IsNull(transactions[0].LineItems[1].MemoWithoutSplit);
Assert.AreEqual("A regular old transaction", transactions[1].LineItems[0].MemoWithoutSplit);
}
public void DontUseClearAsterisk()
{
CSVLineItem clearedTransaction = new CSVLineItem()
{
Account = "Checking Account",
Category = "Income:Available this month",
SubCategory = "Available this month",
Date = new DateTime(2019, 1, 1),
Inflow = "$1,234.56",
Cleared = "C",
MasterCategory = "Income",
Memo = "January Bonus",
Outflow = "$0.00",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
CSVLineItem unclearedTransaction = new CSVLineItem()
{
Account = "Checking Account",
Category = "Income:Available this month",
SubCategory = "Available this month",
Date = new DateTime(2019, 1, 1),
Inflow = "$1,234.56",
Cleared = "U",
MasterCategory = "Income",
Memo = "January Bonus",
Outflow = "$0.00",
RunningBalance = "1,234.56",
Payee = "Megacorp LLC",
};
var transactionsNoClear = Program.GroupLineItems(
new List <CSVLineItem>()
{
clearedTransaction
},
this.accountTypes,
false,
this.unitedStatesCulture);
string noClearExpected =
@"2019-01-01 Megacorp LLC
; January Bonus
Assets:Checking Account $1,234.56
Income:Megacorp LLC -$1,234.56
";
var transactionsWithClear = Program.GroupLineItems(
new List <CSVLineItem>()
{
clearedTransaction
},
this.accountTypes,
true,
this.unitedStatesCulture);
string clearExpected =
@"2019-01-01 * Megacorp LLC
; January Bonus
Assets:Checking Account $1,234.56
Income:Megacorp LLC -$1,234.56
";
var unclearedTransactions = Program.GroupLineItems(
new List <CSVLineItem>()
{
unclearedTransaction
},
this.accountTypes,
true,
this.unitedStatesCulture);
string notClearExpected =
@"2019-01-01 ! Megacorp LLC
; January Bonus
Assets:Checking Account $1,234.56
Income:Megacorp LLC -$1,234.56
";
Assert.AreEqual(noClearExpected, Program.CreateLedger(transactionsNoClear));
Assert.AreEqual(clearExpected, Program.CreateLedger(transactionsWithClear));
Assert.AreEqual(notClearExpected, Program.CreateLedger(unclearedTransactions));
}
