Join with sub query in eloquent

Here is a checkbook ledger with a running balance (not laravel, another framework) But sql is sql.

A running sum is a query in a query:

        $checksearch = $checksearch . "%";
        $pagingQuery = " LIMIT $offset, $rowsperpage";

        $sql = "SELECT OD.checkid, OD.transdate, OD.transdescribe, OD.widthdraw, OD.deposit, OD.isclr,";
        $sql = $sql . " (SELECT (Sum(IFNULL(deposit, 0)) - Sum(IFNULL(widthdraw, 0))) FROM checks";
        $sql = $sql . " WHERE checkid<=OD.checkid) AS RunningSum";
        $sql = $sql . " FROM checks AS OD" . $pagingQuery;
        $sth = $this->db->pdoPrepare($sql);
        //$sth = $conn->prepare($sql);
        $sth->execute();
        $results = $sth->fetchAll(\PDO::FETCH_ASSOC);
        return $results;

Notice the AS RunningSum

I would highly recomment you go here https://www.mysqltutorial.org/ And take some tutorials on queries, as a running sum is just a basic query.

Use a length aware paginator: https://laracasts.com/discuss/channels/guides/manual-pagination-episode-3

Thanks for the quick response. The sql I currently have works just fine. I'm looking to convert it to a laravel eloquent request so I can use some of the laravel built in methods like pagination. Thanks

Just write an eloquent query, I gave an example here https://laracasts.com/discuss/channels/eloquent/get-the-sum-of-all-payments-earnings-that-belongs-to-authors-books

But length aware paginator is laravel.