Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Let's add those bank transactions to your QuickBooks Online (QBO) account, @userpet.
You can manually add those transactions through the WebConnect process. However, you’ll need a soft copy of your bank transactions. It should be either a Comma-Separated Values (CSV) or a QuickBooks Online (QBO) file.
If your bank can't provide you a soft copy then I suggest scanning that printed bank transaction and saving it as a CSV file.
Before importing or uploading the file, make sure to check the format. You can have the 3-column or the 4-column format.
Check this article for more information: Manually upload transactions into QuickBooks Online. From here, you can categorise and then reconcile the transactions.
Let me know if you still have questions with adding your bank transactions in QBO. I'm always here to help. Have a wonderful day!
thanks for the answer,
however, it did not helped me..
as i said, my bank does not provide anything but printed statements...
and it does not make sense to me , to try to make exel file from it and then
upload it
and then match it...
its double work.....
make more sense to me to make the payments update directly from the printed statement into the system
but i dont know how...
an idea?
thanks again
Hi there, userpet.
I can share some tips on how you can upload those transactions.
Currently, QuickBooks Online only supports comma-separated values (CSV) and QBO files for WebConnect. Since you don't want to create an Excel file from scratch, you can try coordinating with your bank to check if they can provide a PDF copy of the printed statements.
Then, search for a third-party application online that allows Optical Character Recognition (OCR) preprocessing which basically converts a scanned image to text (Excel file). Once you're all set up and ready, you can follow these simple steps in uploading the file:
After uploading it, let's go back to the Banking menu to match and categorize your bank transactions. Then, you may now start reconciling them.
If there's anything else that I can help you with, please don't hesitate to add a comment below. I'll always have your back.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here