I want to ask if I could use a CSV file in reconciling instead of PDF Bank Statement. When I ask my client to send Bank Statement, he always sends me a CSV File.
Great to see you in the Community, @Lhorie27. Yes, you can reconcile the data from the bank via .csv file in QuickBooks Online (QBO).
You may want to upload the c.sv file first to the correct bank account that you want to reconcile. I'd be happy to guide you through the steps.
This is what it looks like:
Once done importing, you can now proceed to the reconciling process. I've got an article that contains the steps on how to reconcile: Reconcile an account in QuickBooks Online.
Please feel free to get back to me here for any additional questions about the reconciliation process. I've got your back. Take care!
Good day, Lhorie27!
Let me further assist you in handling your client's transactions.
When you upload a CSV file, you can match the uploaded entries to the existing transactions in QuickBooks Online and this won't cause any duplicate. This is another way of bringing in the bank transactions aside from linking the bank account.
For the detailed steps, you can follow the instructions shared by my colleague or check this article: Manually upload transactions into QuickBooks Online.
Also, I added this link to learn more about what to do with the imported bank transactions: Categorize and match online bank transactions in QuickBooks Online.
Keep on posting here if you need our help in handling bank transactions. Take care always!
Thanks for coming back, Lhorie27.
Yes, we need the beginning and ending balance when reconciling your bank accounts. If you're reconciling an account for the first time, we'll need to review the opening balance. Where it needs to match the balance of your real-life bank account for the day you decided to start tracking transactions in QuickBooks Online (QBO).
When connecting your bank and credit cards to online banking, QBO automatically downloads transactions and enters the opening balance for you. You don't need to worry about the opening balance. Here's an article you can refer to for more details about reconciling an account in QuickBooks Online.
Also, when you start a reconciliation, you enter the ending balance from your bank statement. QuickBooks uses this to check for accuracy. Make sure you entered the correct amount. Here's how:
Just in case QuickBooks Online doesn't match your bank statement at the end of reconciliation, follow the steps in this article to troubleshoot the issue: Fix issues at the end of reconciliation in QuickBooks Online.
Feel free to visit our Banking page for more insights about managing your company's income and sales transactions.
Do you need more help completing other tasks in QuickBooks? Please let me know and I'll assist you with some guides and other pointers. Have a great day.