cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
uk-wonsulting-co
Level 1

QB fails to import my AMEX expenses from all of 2022, only shows 2023, although I've selected the correct time frame. Can you help?

 
2 Comments 2
MichelleBh
Moderator

QB fails to import my AMEX expenses from all of 2022, only shows 2023, although I've selected the correct time frame. Can you help?

I can help you show your 2022 AMEX data in your account, uk. This way, you can categorize them in QuickBooks as soon as possible. 

 

I'll share some details and a workaround for your 2022 AMEX data that doesn't download the issue in QuickBooks Online.

 

Some banks allow downloads of 90 months, 24 months, or up to 2 years of transactions. In your case, it downloads 90 days of data. With this, I'd recommend manually importing your transactions from your bank's website through a CSV file

 

Here's how: 

 

  1. Go to the Transactions menu and choose the Banking tab.
  2. Select Upload from file from the Link account drop-down menu.
  3. Click Drag or drop or select files, locate the file you downloaded from your bank, and hit Continue.
  4. From the QuickBooks account ▼ drop-down, select the account you want to upload the transactions into, then click Continue.
  5. Map the transactions accordingly and follow the onscreen instructions. 

For more details, see this link: Manually upload transactions into QuickBooks Online. If you encounter error messages during the process, refer to this article for the detailed steps to fix them: Fix bank upload errors in QuickBooks Online.

 

Remember to categorise and reconcile the bank to ensure they match your bank statements. 

 

In addition, here's an article to help you fix if the beginning balance doesn't match when you reconcile the accounts and some banking errors in QBO:

 

 

Please return to the Community if you have further questions about bank transactions or other related issues. Keep in mind that I'm always willing to help. Keep yourself safe always, uk. 

Fiat Lux - ASIA
Level 15

QB fails to import my AMEX expenses from all of 2022, only shows 2023, although I've selected the correct time frame. Can you help?

@uk-wonsulting-co 

Use csv2qbo converter tool as a workaround.

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