The phrases 'This is it' and 'That is it/That's it' are used in their literal sense to identify a particular object. For example, if you have a box of keys and you are looking for the right key to open a particular door, when you finally find the right key, you would say 'That's it!' or 'This is it!'.
'This' indicates an object close to you, and 'that' indicates an object further away. So if you find the key yourself, you'd hold it up and say 'This is it!' , and if your friend finds the key, you'd point to it and sat 'That's it!'.
'That's it!' also has a idiomatic use meaning or 'It's finished'. When you have finally finished a long job, you might say 'That's it! It's over'. Or when you lose patience, you can say 'That's it! I've had enough.I'm leaving'.
Sometimes, 'That's it' in this figurative sense can have the same meaning as 'That's all'. Both can signify the end of something. Note that you can't use 'This is it' in this figurative sense.