cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
jpc4
Level 1

bank transaction

i have bank of scotland set up

quickbooks online.

i cannot access any transaction older than january 1st 2023?

is it possible to access last year's transactions?

Solved
Best answer March 19, 2023

Accepted Solutions
LieraMarie_A
QuickBooks Team

bank transaction

Hi there, @jpc4.

 

It's nice to have you with us in the Community today. I'd be delighted to assist you to import your transactions into QuickBooks Online (QBO).

 

May I know the error message you're getting? First, you'll have to ensure the data is in the correct format before you upload it. You can upload CSVs using either the 3-column or 4-column format. The 3-column format has DateDescription, and Amount columns.

 

 

The 4-column format has DateDescriptionCredit, and Debit columns.

 

 

Please take note that CSV files for credit card accounts may display transactions in reverse. For example, deposits may appear as negative amounts because paying your credit card reduces your balance. 

 

Moreover, if you see an error message when you upload, do the following:

 

  • Remove any zeros (0) from the file. Leave those cells blank.
  • Correct any transactions that display numbers in the Description column.
  • Remove the word "amount" if it appears in the Credit or Debit column header. They should only read "Credit" and "Debit" without the word "amount."
  • Make sure the dates are in one format. We recommend you use: dd/mm/yyyy.
  • Mac users must save the file as a Windows CSV file.
  • Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:
    1. Open the CSV in Microsoft Excel.
    2. Highlight the column that contains the date.
    3. Go to Data then select Text to Columns.
    4. Follow the onscreen steps and select the following:
      • Original data type: Delimited
      • Delimiters: Space
      • Column data format: General

 

When your file is formatted correctlyupload them into QBO and ensure to match the columns on the file with the correct fields in QuickBooks. Finally, review and categorize your transactions to put them in your accounts.

 

If you have more questions about working with bank feeds, let me know in the comment section. I'll be right here to lend you a hand. Have a good one!

View solution in original post

6 REPLIES 6
MichelleBh
Moderator

bank transaction

 Happy to help, @jpc4. I hope all is well with you.

 

I can provide details about getting your missing bank transactions from last year to your QuickBooks Online (QBO).

 

When you connect an account, QuickBooks will normally only download bank transactions from the previous 90 days. Anything older than that can be downloaded via the web from your bank's website and imported into QuickBooks via CSV.

 

Here's how: 

 

  1. Sign in to your QBO account and select Transactions on the left panel.
  2. Click the Link account drop-down arrow and select Upload from file. 
  3. Click Browse and pick the file you've saved on your computer.
  4. Follow the on-screen instructions. 

 

Check out this article for a video tutorial: Manually upload transactions into QuickBooks Online.

 

In case you'll encounter error messages during the process, refer to this article for the detailed steps to fix them: Fix bank upload errors in QuickBooks Online.

 

Additionally, I've got you this article to help you categorize, match and reconcile your bank transactions in QBO:

 

 

Please let me know if you have additional questions about this or anything else. I'll be happy to answer them. Stay safe.

Fiat Lux - ASIA
Level 15

bank transaction

@jpc4 

Another option, use a converter tool as workaround (e.g csv2qbo)

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

 

jpc4
Level 1

bank transaction

when importing the spreadsheet file

i am getting lots of errors cannot import all data ?

LieraMarie_A
QuickBooks Team

bank transaction

Hi there, @jpc4.

 

It's nice to have you with us in the Community today. I'd be delighted to assist you to import your transactions into QuickBooks Online (QBO).

 

May I know the error message you're getting? First, you'll have to ensure the data is in the correct format before you upload it. You can upload CSVs using either the 3-column or 4-column format. The 3-column format has DateDescription, and Amount columns.

 

 

The 4-column format has DateDescriptionCredit, and Debit columns.

 

 

Please take note that CSV files for credit card accounts may display transactions in reverse. For example, deposits may appear as negative amounts because paying your credit card reduces your balance. 

 

Moreover, if you see an error message when you upload, do the following:

 

  • Remove any zeros (0) from the file. Leave those cells blank.
  • Correct any transactions that display numbers in the Description column.
  • Remove the word "amount" if it appears in the Credit or Debit column header. They should only read "Credit" and "Debit" without the word "amount."
  • Make sure the dates are in one format. We recommend you use: dd/mm/yyyy.
  • Mac users must save the file as a Windows CSV file.
  • Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:
    1. Open the CSV in Microsoft Excel.
    2. Highlight the column that contains the date.
    3. Go to Data then select Text to Columns.
    4. Follow the onscreen steps and select the following:
      • Original data type: Delimited
      • Delimiters: Space
      • Column data format: General

 

When your file is formatted correctlyupload them into QBO and ensure to match the columns on the file with the correct fields in QuickBooks. Finally, review and categorize your transactions to put them in your accounts.

 

If you have more questions about working with bank feeds, let me know in the comment section. I'll be right here to lend you a hand. Have a good one!

jpc4
Level 1

bank transaction

thanks

sorted , the date was the problem:thumbs_up:

MariaSoledadG
QuickBooks Team

bank transaction

Hello there, jpc4.

 

I'm glad everything has already been sorted out. Anyway, if you have any other concerns about your bank transactions, let us know so we can get back to you as soon as possible. We're always here to help you.

 

Need to get in touch?

Contact us