formated compleated in colsolidated liat bills