MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE bill_charges (
    `bill_nbr`   varchar(30)   NOT NULL,
    `bill_id`    int(11)       NOT NULL,
    `version`    enum('1','2') NOT NULL DEFAULT '1'
);

INSERT INTO bill_charges (bill_nbr, bill_id, version)
VALUES ('50', 500, '1'),
       ('50', 501, '2'),
       ('60', 600, '1');
       
CREATE TABLE charges (
    `charge_id`      int(11) NOT NULL,
    `charge_type_id` int(11) NOT NULL,
    `bill_id`        int(11) NOT NULL,
    `charge_amt`     decimal(13,2) NOT NULL DEFAULT '0.00'
);

INSERT INTO charges (charge_id, charge_type_id, bill_id, charge_amt)
VALUES (10, 100, 501,  15.00),
       (11, 100, 501,  -5.00),
       (12, 200, 501,  50.00),
       (13, 300, 501,  -5.00),
       (14, 300, 501,  -5.00),
       (15, 300, 501, -25.00);

CREATE TABLE payments (
    `payment_id`     int(11) NOT NULL,
    `pays_charge_id` int(11) NOT NULL,
    `charge_id`      int(11) NOT NULL,
    `payment_amt`    decimal(13,2) NOT NULL DEFAULT '0.00'
);

INSERT INTO payments (payment_id, pays_charge_id, charge_id, payment_amt)
VALUES (20, 13, 10,  -5.00),
       (21, 14, 10,  -5.00),
       (20, 15, 12, -25.00);

bill_nbr	bill_id	version	remaining_balance
50	500	1	null
50	501	2	0.00
60	600	1	null