David Cameron has admitted he botched the handling of the row over his financial affairs, telling Tory activists it had "not been a great week".