Every ledger entry should be posted close to when it happens. Rent charges, manual charges, late fees, credits, and payments all need to land in the same record if the balance is going to mean anything.
That is why a dedicated rent system is usually better than keeping payment screenshots in one place and a spreadsheet somewhere else. The ledger should not require detective work.
