INSERT INTO `expense_category` (`id`, `name`, `created_by`, `created_at`, `updated_by`, `updated_at`)
VALUES
  (1, 'Salary', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
  (2, 'Rent', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
  (3, 'Misc', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00');

INSERT INTO `expense_recurring` (`id`, `name`, `description`, `expense_category_id`, `created_by`, `created_at`, `updated_by`, `updated_at`)
VALUES
  (1, 'S1', '', 1, 0, '2018-08-24 17:40:48', 0, '2018-08-24 17:40:48'),
  (2, 'S2', '', 1, 0, '2018-08-24 17:41:43', 0, '2018-08-24 17:41:43'),
  (3, 'S3', '', 1, 0, '2018-08-24 17:43:23', 0, '2018-08-24 17:43:23'),
  (4, 'Rent', '', 2, 0, '2018-08-24 17:43:47', 0, '2018-08-24 17:43:47');


INSERT INTO `expense_recurring_amount` (`id`, `expense_recurring_id`, `amount`, `from_date`, `to_date`, `notes`, `created_by`, `created_at`, `updated_by`, `updated_at`)
VALUES
  (1, 1, 5000, '2018-08-01 00:00:00', '2018-09-30 00:00:00', '', 0, '2018-08-24 17:40:48', 0, '2018-08-24 17:40:48'),
  (2, 1, 10000, '2018-10-01 00:00:00', NULL, '', 0, '2018-08-24 17:40:48', 0, '2018-08-24 17:40:48'),
  (3, 2, 3000, '2018-09-01 00:00:00', NULL, NULL, 0, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00'),
  (4, 3, 2000, '2018-08-01 00:00:00', '2018-09-30 00:00:00', '', 0, '2018-08-24 17:43:23', 0, '2018-08-24 17:43:23'),
  (5, 4, 2500, '2018-08-01 00:00:00', NULL, '', 0, '2018-08-24 17:43:47', 0, '2018-08-24 17:43:47');


INSERT INTO `expenses` (`id`, `item`, `amount`, `expense_category_id`, `date`)
VALUES
  (1, 'M1', 100, 3, '2018-08-10 00:00:00'),
  (2, 'M2', 800, 3, '2018-08-10 00:00:00'),
  (3, 'M3', 50, 3, '2018-10-12 00:00:00'),
  (4, 'M4', 150, 3, '2018-10-12 00:00:00'),
  (5, 'M5', 200, 3, '2018-10-12 00:00:00'),
  (6, 'M6', 250, 3, '2018-10-12 00:00:00'),
  (7, 'R2', 500, 2, '2018-10-12 00:00:00');

INSERT INTO `clients` (`id`, `name`, `address`, `total_annual_income`, `service_start_date`, `billing_start_date`, `created_by`, `created_at`, `updated_by`, `updated_at`)
VALUES
  (1, 'C1', NULL, 100000, '2018-08-01', '2018-08-25', 0, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00'),
  (2, 'C2', NULL, 5000, '2018-08-25', NULL, 0, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00'),
  (3, 'C3', NULL, 10000, '2018-02-25', '2018-03-25', 0, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00');
