Can't import transactions older than 90 days from American Express (Mac QuickBooks2020)

Hi there, robgnyc.

I appreciate you for performing detailed information on your concern about missing transactions.

Since the system says it's imported the transactions and it doesn't show them so you match them up with the proper accounts, it could be the entries already added or categorized. To confirm this, you can go to the Bank Register and you'll see all cleared transactions from there.

Here's how:

1. Click the Banking menu at the top.
2. Choose Use Register.
3. Select the specific account from the drop-down arrow.
4. Click OK.
5. Review and find the transactions.

If the issue continues to occur, you can manually refresh the connection of the bank with QuickBooks Desktop to see the latest imported entries. Please follow the steps below.

1. Click the Banking menu at the top.
2. Choose Bank Feeds.
3. Select Bank Feeds Center.
4. Choose the specific bank account.
5. Click the Refresh accounts button.

If the problem persists, I recommend running the QuickBooks built-in diagnostic and repair tools called to rebuild and verify data utilities. These tools will repair and notify you of any possible data damage within the file. You can click this article to see the process:  Verify and Rebuild Data in QuickBooks Desktop.

Please refer to this article to see steps on how you can reconcile your accounts so they match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Desktop.

Reach out to me in the comment section if you have any other issues or concerns. I want to make sure everything is taken care of for you. Have a wonderful day!

When I look at the transaction register, I just see a bit gap between 5/27/20 and 11/26/20.

In my banking menu there is no option for Chose Banking Feeds.

I have used the utilizes to verify and rebuild the data. This didn't help.

Is there any way to force it to ingest the missing data from the .qbo file? Would it work if the data was in another format? I've looked in the raw XML data to see that the account number in the <ACCTID> node matches my account id so I know it's not that (I saw this as a suggested solution in other threads).

Are there any other workarounds?

@robgnyc 

Explore this converter app as a workaround.

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

You'll want to manually import your missing transactions, robgnyc.

In addition to what our AllStar provided, you can use a CSV file format in uploading missing transactions in QuickBooks aside from.QBO format. You can use these links that will give you more information on what can be imported and how they'll appear in the system. 

• Import and export data in QuickBooks Desktop
• Set up bank accounts for Bank Feeds in QuickBooks Desktop

If you need anything else, please don't hesitate to post them here. Take care!

I can download a file from Amex in a CSV format but It appears that if I wanted to import from a CSV I'd need something called the "QuickBooks_Import_Excel_and_CSV.exe" which is only for windows. So I'm out of luck on a Mac.

When I just go to File -> Import ->Transactions -> Credit Card Charges I just end at a sort of blank template screen but I'm not clear on what I need to do to access the downloaded .csv.

I'm not sure why Quickbooks makes this so difficult or why the .qbo file doesn't work but I'm about to abandon Quickbooks for another program because problems like these really kill me at tax time. Importing transactions should be a very basic function of an accounting program.

Thanks for following up with the Community, robgnyc.
 

It's easiest to import transactions when the fields on your spreadsheet match with QuickBooks. I'd be more than happy to guide you through generating a template for them.
 

Here's how:

1. In the top menu bar, go to File, then Import.
2. Choose Transactions.
3. Pick a type.
4. Use your Gear (⚙️) icon and click Export Table Template.
5. Enter a name.
6. Save the template.
7. Open it on your spreadsheet application.
8. Add the transactions to your template, then save it.

Now you'll be prepared to import your transactions.
 

I'll be here to help if there's any additional questions. Have a great day!