I am able to import a number of bank feeds that contain both daily cash and credit deposits. I would like to also upload the same daily cash and credit deposit information generated from my operational system to confirm what does not match between the bank feed and operational system data. How can I best perform this reconciliation?
Thank you for your question. The bank feeds tool in QuickBooks was designed to reconcile transactions that hit your bank and/or credit card accounts. In order to reconcile what hits your financial institution to your operational system, you will have to run reports in QuickBooks and compare them with reports from your operational system. You can also download reports from QuickBooks to Excel if that would help.
Crystalynn Shelton, CPA
Disclaimer: We spend hours researching and writing our articles and strive to provide accurate, up-to-date content. However, our research is meant to aid your own, and we are not acting as licensed professionals. We recommend that you consult with your own lawyer, accountant, or other licensed professional for relevant business decisions. Click here to see our full disclaimer.
Product or company names, logos, and trademarks referred to on this site belong to their respective owners.