Skip to main content
October 30, 2024
Question

What is the costumer service phone number

  • October 30, 2024
  • 1 reply
  • 0 views
does anyone have the template to upload bank statement activities since i did not link the bank on time and now it needs to be done either manually or hopefully uploaded

1 reply

MariaSoledadG
October 30, 2024

You're right. You'll have to manually upload your bank transactions if you haven't connected your bank in QuickBooks Online yet. But don't worry, I'm here to guide you on how you can do this easily, useralperez.

 

You can upload CSV files in either 3-column or 4-column format. For the 3-column version, just include the Date, Description, and Amount columns. If you opt for the 4-column format, you'll need the Date, Description, Credit, and Debit columns. Check out this article for more details: Format CSV Files in Excel to get Bank Transactions into QuickBooks.

 

If your bank doesn't support CSV files but provides options like Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX), you can still import your data and then upload more than 90 days of bank transactions. Just make sure you know the date of the oldest transactions. Once you have that, you can download the files from your bank. Here's how to get started:

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions on 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.

Next, review the file format and size before manually uploading them in QuickBooks. Here's how:

  1. Go to Transactions, then select Bank transactions.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Select the Link account dropdown, then select Upload from file.
  4. Select Drag and drop or select files and select the file you downloaded from your bank. Then, select Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then, select Continue.
  6. If you're new to QuickBooks, you may not have an account to upload the transactions into. If you don't see one, select Add New from the dropdown to create a new bank account.
  7. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  8. Select the transactions you like to import. Then select Continue.
  9. Click Yes and Done.

To give you a step-by-step process and guide you on what you can do in case you get errors when uploading transactions, refer to this article for your reference: Manually Upload Transactions into QuickBooks Online.

 

On the other hand, if you still prefer to speak directly with our support team, you can find their phone number at the bottom of this article: QuickBooks Online Support.

 

Additionally, it's a good idea to compare each uploaded transaction with those already entered in QuickBooks to ensure everything is accurate. For guidance on how to do this, take a look a this helpful article: Reconcile An Account in QuickBooks Online.

 

If you have any other questions or concerns, feel free to reach out for assistance. We're here to make sure that everything about your bank transactions is covered. Have a nice day!