The best way to avoid duplicate transactions is to maintain a routine of reconciling your manual transaction entries with your company's bank statement. In doing so, you're ensuring that your books are lining up with reality: the true activity in the business account.