Old bank statements

Paul 43 · ‎October 02, 2020

Hi

I’m new to quick books and not very good with computers, so go easy.

i have had trouble loading old bank statements manually. I managed to get my Natwest ones,

the Hsbc ones I’m finding a lot harder.

i can only upload in pdf file. I have downloaded adobe acrobat , I can get to excel , then change to csv file

when I go to upload to quick books it looks like the date and payment discription is in the same box , and will not let me enter box 1 for date and box 1 for discription.

can anyone help

ChristieAnn · ‎October 03, 2020

Hi there, Paul 43.

Thank you for coming back and for providing additional clarification on the issue. I'm here to help and provide some additional information about importing bank transactions in QuickBooks Online (QBO).

As mentioned by my colleague above, you'll need to make sure that you match the columns on the file with the banking fields in QuickBooks correctly. That said, uploading bank transactions in the QuickBooks that combine the date/description in the same column is unavailable. I'd suggest separating them in different columns.

QuickBooks Online can import CSV files that use either a 3-column or 4-column format. The 3-column template has columns for the Date, a Description of the transaction, and the amount of the transaction. Then, The 4-column template has a Date column, a Description column, and both a Credit and a Debit column. For additional information, you can click this article: Import bank transactions using Excel CSV files.

After that, you can now follow the steps shared above on how to import transactions from a CSV file.

Once your entries imported, I recommend categorizing and matching the transactions to the existing entries in QBO. Doing so will help ensure your financial records are accurate. Just go to the For Review tab to complete this task.

Please refer to this article to see steps on how to fix different banking errors: What to do if you see a bank error or bank transactions won’t download.

As always, you can reach back out if you have further questions about importing transactions in QuickBooks Online. I’d be happy to answer it for you.

View solution in original post

LieraMarie_A · ‎October 02, 2020

With the help of this information, you'll be a QuickBooks master in no time, @Paul 43!

Great job in converting your file to a CSV format! Can you clarify which part of the importing process you're getting the problem? I'd really appreciate if you send us a screenshot. This way, we can pinpoint the correct resolutions to resolve the problem. If it occurred in the Select transactions for import page (see screenshot below), you'll have to make sure that you match the columns on the file with the banking fields in QuickBooks in the Map columns page correctly.

Here's how to fix it:

Select the left Banking menu and select Banking.
Select File upload. If you’ve never connected an account, you can select Upload transactions.
Select Browse and choose the CSV file.
Select Open, then select Next.
From the QuickBooks Account drop-down list, select the bank or credit card account, then click Next.
Match the columns on the file with the banking fields in QuickBooks. Make sure the Date, Description, and Amount columns on the CSV match the columns and order in QuickBooks. You can choose 1 column or 2 columns depending on your CSV template format.
Select Next.
Select the checkboxes of the transactions to import and select Next.
Select Yes.
Select Let's go! when the import completed notification appears.

Refer to these links for more info and learn how your CSV file should look like:

After you download your transactions in QuickBooks, you can review them in the For Review tab to make sure all of your data is downloaded.

I'm always here if you need further assistance, @Paul 43. Have a great day!

Paul 43 · ‎October 02, 2020

Hi

I think the problem is I convert the pdf to excel

the bank has the date / description in the same column.

is there a way I can get this into quick books

thank you

Paul 43 · ‎October 03, 2020

Hi

i think the problem is, when I convert the pdf to excel, the document combines the date / description to the same column

when I go to upload to quick books after converting to csv, it does not except date / description in same part

can this get sorted?

ChristieAnn · ‎October 03, 2020

Hi there, Paul 43.

Thank you for coming back and for providing additional clarification on the issue. I'm here to help and provide some additional information about importing bank transactions in QuickBooks Online (QBO).

As mentioned by my colleague above, you'll need to make sure that you match the columns on the file with the banking fields in QuickBooks correctly. That said, uploading bank transactions in the QuickBooks that combine the date/description in the same column is unavailable. I'd suggest separating them in different columns.

QuickBooks Online can import CSV files that use either a 3-column or 4-column format. The 3-column template has columns for the Date, a Description of the transaction, and the amount of the transaction. Then, The 4-column template has a Date column, a Description column, and both a Credit and a Debit column. For additional information, you can click this article: Import bank transactions using Excel CSV files.

After that, you can now follow the steps shared above on how to import transactions from a CSV file.

Once your entries imported, I recommend categorizing and matching the transactions to the existing entries in QBO. Doing so will help ensure your financial records are accurate. Just go to the For Review tab to complete this task.

Please refer to this article to see steps on how to fix different banking errors: What to do if you see a bank error or bank transactions won’t download.

As always, you can reach back out if you have further questions about importing transactions in QuickBooks Online. I’d be happy to answer it for you.

Topics

Training

Community

Resources

Old bank statements