--These are all random BS numbers, just for testing. create table TestAccount (id integer primary key, Date DATETIME, Desc text, Type text, Amount REAL, Notes text); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/01/2018', "Balance", "Balance", 100.76,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/02/2018', "Debit", "Store_1", -155.95,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/03/2018', "Deposit", "Deposit", 232.00, "Pay Check"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/03/2018', "Debit", "Withdrawal", -20.00,"Cash"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/09/2018', "Debit", "Store_1", -85.36,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/10/2018', "Deposit", "Deposit", 232.00, "Pay Check"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/10/2018', "Debit", "Withdrawal", -5.00,"Cash"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/13/2018', "Debit", "Locally Sourced Water", -28.37,"Water Bill"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/13/2018', "Debit", "Power2U", -143.11,"Electric Bill"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/13/2018', "Debit", "Data Deficit", -58.62,"Internet Bill"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/13/2018', "Debit", "LotsaTalk", -102.39,"Cellphone Bill"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/16/2018', "Debit", "Store_1", -99.54,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/17/2018', "Deposit", "Deposit", 232.00, "Pay Check"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/17/2018', "Debit", "MoneyStorage Bank", -256.72,"House Payment"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/17/2018', "Debit", "Withdrawal", -26.00,"Cash"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/23/2018', "Debit", "Store_1", -45.99,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/24/2018', "Deposit", "Deposit", 232.00, "Pay Check"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/30/2018', "Debit", "Store_1", -101.24,""); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/31/2018', "Deposit", "Deposit", 232.00, "Pay Check"); insert into TestAccount values ((SELECT MAX(id) FROM TestAccount)+1, '08/31/2018', "Debit", "Withdrawal", -50.00,"Cash");