Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Good Morning;
My bank, Chase, only maintains access to my data in QBO format for two years but I need to enter older data that is only available in .PDF format.
The best I can figure out is to cut and paste from the .PDF into excel, go though and clean up the data by separating a single column into multiple columns then recombining it on a row by row basis. Once that is done I would the purchase third party software to convert the .XLS file to a .QBO file and finally import it into Quickbooks for categorization and reconciliation.
I have two questions:
1. Is there a better workflow for this?
2. Is there anyone that does this for clients?
Thanks,
Matt
Solved! Go to Solution.
Thank you so much!!!
Hello there, @Matt_Moore. I appreciate you reaching out, and thank you for providing detailed information about your concern.
You're on the right track in purchasing third-party software to convert your file so you can import it into your QuickBooks Desktop (QBDT) account. QuickBooks integrates with hundreds of third-party software developers. You can visit our QuickBooks Desktop Marketplace to view a wide range of options.
Once done converting the file, you're ready to import it into your QBDT account. Let me show you how:
For more details about importing your bank transactions in QBDT, you can visit this article: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop.
In case you need help matching your transactions, consider checking this resource for a guide: Add and match Bank Feed transactions in QuickBooks Desktop.
For additional reference, here's a link that you may find helpful for your future task: Reconcile an account in QuickBooks Desktop.
Please let me know if you have any other issues or concerns by leaving a comment in this thread. I want to make sure everything is taken care of for you. Have a great rest of the day!
Hello again, Fiat Lux - ASIA
I appreciate you for always sharing your knowledge about QuickBooks. This will definitely help other users as well in the future. Please keep on posting here in the Community.
Keep safe and have a great rest of the day.
MoneyThumb seels its program for a $ 549. annual fee. Is there a program that is for just a week or two or a few dozen pdfs?
Use the trial license.
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