cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Moore
Level 2

Entering data from old PDF statements

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

  1.  

 

Solved
Best answer September 29, 2022

Best Answers
Fiat Lux - ASIA
Level 15

Entering data from old PDF statements

6 Comments 6
Fiat Lux - ASIA
Level 15

Entering data from old PDF statements

Utilize the pdf2qbo converter tool

https://www.moneythumb.com/?ref=110

 

Matt_Moore
Level 2

Entering data from old PDF statements

Thank you so much!!!

MirriamM
Moderator

Entering data from old PDF statements

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:

 

  1. Go to the Banking menu at the top. 
  2. Select Bank Feeds, then Import Web Connect Files.
  3. Select the .QBO file you saved or converted, then choose Open.
  4. When asked to select your bank account, use a QuickBooks account that exists if the account you're importing transactions into is already set up in QuickBooks, or select Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
  5. Click Continue.
  6. Choose OK when you see a dialog box telling you that the data has been successfully read into QuickBooks.
  7. Review your transactions in the Bank Feeds Center.

 

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!

FritzF
Moderator

Entering data from old PDF statements

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.

Jaybird123
Level 1

Entering data from old PDF statements

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?

Fiat Lux - ASIA
Level 15

Entering data from old PDF statements

@Jaybird123 

Use the trial license.

Need to get in touch?

Contact us