How frequently you update your records depends on the number of transactions in your business. If transactions occur every day, then you should update your records daily.