ATO Income Tax Account and Integrated Client Account template for tracking payments related to franking account

Hello fellow redditors,

We have a few clients that are well behind in BAS and Income Tax payments and it's becoming a bit of a task to track which payments relate to income tax, interest, BAS's, IAS's etc so that the franking account remains accurate. I have created a spreadsheet to track this but we have a few people in the office that aren't the greatest at keeping the spreadsheets NEAT AND ACCURATE! Does anyone have an easy to follow (like think Chimpanzee easy) excel template that they use and are happy to share?

Thanks!