QuickBooks support the ability to connect my checking account and credit card feed to my file. My goal for using QBO and bank feeds is to reduce data entry. Each morning when I log into QBO, I can see what expenses and payments have cleared the bank, and add them into my register. Credit card expenses? I do not even bother entering them into QBO; I let the feed do it for me. I can create rules to auto-categorize the transactions, too, so that I don’t make mistakes. There is even a setting to auto accept into the register after a rule is applied, which basically is auto data entry. I cannot do that with Excel – and the errors trying to do this in Excel … oh, the errors!
I challenge you to move away from Excel and use all the features you can in QBO. If you don’t know how to get more out of QBO, ask your accountant, find a new one here or simply contact the QuickBooks support line. It’s time move away from Excel!