How should I deal with transactions in an account that cannot connect to QB?

Hello, Themsbcollective. I understand that not all banks support direct feeds yet, but you can still handle this by recording your transactions in QuickBooks through manual upload or manual entry.

Before recording transactions, first create the savings account in your Chart of Accounts by going to Accounting> Chart of Accounts > New account> enter bank's name, choose Account type and Detailed type > then, click Save. Once created, you can then proceed with either option to record transactions within that account.

If you'd like to proceed with manually uploading your file, you need to Download a file from your bank (CSV, QFX, QBO, or OFX format) and upload it in QuickBooks. This lets you review and categorize just like connected accounts.

Here's how:

1. From Banking Transactions, click Link account dropdown.
2. Choose Upload from file, then browse your file and click Continue.

3. Select account you created for your bank and Continue.
4. Match the columns in the file with the correct fields in QuickBooks. Then select Continue.
5. Select all the transactions you'd like to import. Then, click Continue, Yes and Done. 

You can then view this article to check the correct format: Format CSV files in Excel to get bank transactions into QuickBooks.

Another way is to enter them manually by using checks, deposits, or journal entries directly to your bank's account history. Please check this article for the detailed steps: Add a transaction to an account history.

For reconciliation, it works exactly the same way, go to Bank Transaction> Reconcile, select your savings account, enter your statement ending date and balance, and check off the transactions. Check out this article for complete details: Reconcile an account in QuickBooks Online.

Please don't hesitate to leave us a response if you have other questions or concerns.