Good day, efish123.
If you're attempting to upload bank data from Excel, please follow these steps:
Here's how: Step 1: Pick a start date:
- In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
- Look for the bank or credit card account you want to upload the transactions into.
- Click View register.
- Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.
Step 2: Get transactions from your bank:
- Sign in to your bank or credit card’s website.
- Follow your bank’s instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps. For Bank of America, Chase, and Wells Fargo.
- Check the date range for the download. It should be at least one day before the date of your oldest transaction.
- Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.
Other steps can be found in this article (step 3): Manually upload transactions into QuickBooks Online. On the same page, you'll find links to instructions on how to set up bank rules and reconcile your account.
Once imported, I recommend that you assign, and categorize your transactions. We can also match them to existing entries in the software. Simply select the For Review tab from the Banking menu. This will assist you in ensuring the accuracy of your financial records.
If you're uploading invoices, products and services, or customer lists, see this article: Frequently Asked Questions About Importing Data to QuickBooks Online.
Please let me know if you still need assistance uploading your data or if you have any additional QuickBooks questions. I'll be there to assist you. Have a good one, efish123.
