You can fix this by recording the transactions on the day that you clear the bank rather than dated 7 days later.