I have Quickbooks 2020 Desktop Mac version hooked up to my American Express account. I forgot to download transactions for several months. When I went to sync it up again it synced everything for 90 days.
However I have a hole between May and November of 2020. I figured out the exact dates, went on Amex online and searched for transactions for this time period and downloaded as a .qbo file. When I go to import it it says it's imported the number of transactions but it doesn't show them where I can match them up with the proper accounts. They just go in and disappear and I can't figure out how to import these missing transactions.
It's driving me insane.
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.
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.
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?
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.
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.
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!