Import missing Amex credit card statements for reconcile in QBO - January through September 2020

Hi there, @nonyanon.

You can prepare an Excel CSV for the missing entries from January to September 2020. Then, upload the file to QuickBooks Online (QBO). I'm here to guide you with detailed instructions.

First, get the transactions from your bank.

1. Sign in to your bank or credit card's website.
2. Follow your bank's instructions for how to download CSV files of your transactions to your computer. 
3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
4. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

After that, review the file format and size before uploading the transactions. If the file is too big, shorten the date range and download transactions in smaller batches.

And, here's how you can upload the file to QuickBooks.

1. Click on Transactions or Banking at the left pane, then go to the Banking page.
2. Select the blue tile for the account you want to upload the transactions into.
3. Tap on the Link account dropdown, then Upload from file.
4. Hit Browse, then select the file you downloaded from your bank. Then select Next.
5. In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then select Next.
6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. 
7. Click Next, then select the transactions you'd like to import.
8. Hit Next, then Yes.
9. When you're ready, select Let's go.

Once the transactions are available in QuickBooks, it's time to review and categorize them so you can proceed with your reconciliation.

Please feel free to get back to me here for any additional questions about your banking transactions. I always have your back. Thanks for dropping in, and cheers for more success!

@nonyanon 

Another option, utilize SlickConnect. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed. 

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

Thx!! I will review and execute later tonight. 

im confused by the Balance Sheet showing negative numbers on two financial Accts - why?

Thanks for coming back to the Community, nonyanon.

Let me help and guide you on how to correct the information on your Balance Sheet report.

The total assets should match your total liabilities on your Balance Sheet. If the information is out of balance, let’s perform the following troubleshooting steps to rectify the issue:

1. Choose each account on the report to see the transactions related to the balance of each account.
2. Find the date when your balance sheet went out of balance. Open the report and go to the Report period drop-down to select This Year-to-date. Then narrow down each month up to the exact date range.
3. From there, look for the transactions that are making your balance sheet out of balance.

For additional resources, you can browse this article: Basic troubleshooting for balance sheets. The solution is scenario-based, and I recommend you choose the one that fits your situation.

To learn more about the Balance Sheet Report, click here to view the complete details. It provides detailed information on why the statement doesn’t match your other reports.

Stay in touch if you have clarifications about running the Balance Sheet report. I’ll be glad to answer them for you. Wishing you and your business continued success.