How to automatically extract the ending balance in the schedule from the total table with EXCEL function

In the G3 cell of the "1 1 building catalogue" worksheet, the formula is as follows:

=SUM (indirect (B3&; "! : d ")-sum (indirect (B3&; "! E:E ")), and then drag this formula to the last line where there is data.

But there is something wrong with the ledger data of each room number. Need to adjust! ! ! See below for adjustment:

Take the account book of 20 1 room as an example; Where is the problem;

Community 1)B4 should collect the property fee, but it can't be blank here, and it should also indicate in which charging period the fee was collected, for example, 2018.3.1-2019.2.28, etc. Therefore, this B4 cell must be marked as B3 cell, and it should be consistent with the B3 cell you "keep accounts", so that it can be convenient to count whether there is any debt;

2) 2) Unit F3 did not deduct the property fees charged by the four banks after collecting the property fees. Therefore,

The following formula should be written in F3 cell: = if(D3 >；; 0, D3-SUMIF(B:B, B3, E:E), SUMIF(B:B, B3, D:D)-SUMIF(B:B, B3, $E$ 1:E3). Then drag the formula of F3 down. ...

Note: "Bookkeeping" and received property fees should be strictly recorded in Excel general ledger by branch, and should be correctly recorded in column D (uncollected receivables) and column E (received) respectively, and both columns cannot be filled in manually.