Hi guys . how can i upload bank statement Knowing that the bank account has a credit and a debit, while QuickBooks asks me to add the value in only one field ؟؟؟

Hello there, finance.

Let me shed some light on uploading your bank statement into QuickBooks Online (QBO). 

When importing your bank data, the online program (QBO) can handle 3-column or 4-column formats.

The following details can be added to the file: Date, Description, Amount, Credit, and Debit.

After getting the list of your entries from your bank, make sure to fine-tune the file format to prevent any errors. You can perform the following:

• Remove any zeroes (0) from the CSV file and leave those cells blank.
• Take out any numbers that are displayed in the Description column.
• Delete the word "amount" if it appears in the Credit or Debit column header. They should only read "Credit" and "Debit" without the word "amount."
• Make sure the dates are in one format and recommend using: dd/mm/yyyy.
• Mac users must save the file as a Windows CSV file.
• Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:

1. Open the CSV in Microsoft Excel.
2. Highlight the column that contains the date.
3. Go to Data then select Text to Columns.
4. Follow the onscreen steps and select the following:

• Original data type: Delimited
• Delimiters: Space
• Column data format: General

When you're ready, let's go ahead and upload your bank data. If your account isn't connected to online banking, follow these steps:

1. Go to the Banking menu on the left panel and choose Banking. 
2. From the link account drop-down select Upload from file.
3. Tap the Drag and drop iconor select files and select the file you downloaded from your bank. Then select Continue.
4. Select the account you want to upload the transactions in the QuickBooks account dropdown and press the Continue button to proceed.
5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
6. Tap the How many columns show amounts drop-down to choose Two columns and Continue.
7. Select the entries you'd to bring into QBO and click the Continue button.
8. Press the Yes button to confirm.
9. When you accept your transactions, choose Done.

If your account is linked to the bank fees, see this article for detailed instructions: Manually upload transactions into QuickBooks Online. Proceed directly to Step 4. 

If you come across any issues bringing in your transactions into QBO, this article contains solutions on how to resolve them: Fix bank upload errors.

Once your bank data are added to the program, I recommend classifying them to the correct category type. This way, you can balance the account seamlessly. 

For topics and resources to help handle any bank-related tasks, you can browse this link to view the list of articles: Self-help guide. 

If you need further information uploading your bank statement or have other product concerns, drop a comment below and tag my name. I'm more than happy to lend a helping hand. 

Hi, I have a similar question. 

I uploaded my bank statement and it recorded all debts and credits just fine. However, it added them only in Quickbooks balance for the bank.

Now it is showing actual bank balance as 0, since my bank doesn't offer direct connection to quickbooks online. How can I update the actual bank balance?

Thank you

@waqarakram 

You can use csv2qbo converter tool. It's $60 one time license.

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

but it will still not solve the problem, as Bank account balance stays zero even then, if I have read posts on forum correctly 

MY CSV file has a column available balance.  Can quick books pick my ending bank balance from there? as the actual bank balance?

Thanks for making your first post here in the QuickBooks Community forum. I'll share insight that could help you get through this, @waqarakram. I understand each bank formats CSV files differently, so it is vital to check the format of the CSV file received from the bank to ensure it can be uploaded into QuickBooks Online.

When importing a CSV file, the available balance column can be used to update the ending bank balance. However, you may need to map the column to the appropriate field during the import process and ensure that it accurately reflects the actual bank balance. After importing, review and reconcile your account to ensure accuracy.

QuickBooks can handle CSV files with either a 3-column or 4-column format, which includes the Date, Description, and Amount columns or the Date, Description, Credit, and Debit columns, respectively. Check out this article for more information: Format CSV files in Excel to get bank transactions into QuickBooks.

I'm always around and ready to help if you have more questions about organizing your banking transactions. Just click the Reply button to add your comment so I can further assist you. Keep safe, @waqarakram.

Thank you Christine for help, shouldn't there be a 5th Column for Balance? There is one if you convert to Ofx file.

Hello there, @waqarakram.

You can upload supported files with either the 3-column or 4-column format as mentioned by my colleague above. The 3-column format includes Date, Description, and Amount columns, while the 4-column format includes Date, Description, Credit, and Debit columns. These are the only columns QuickBooks can handle, and they must be in the specified order. You'll need to follow the correct format to import your transactions to QuickBooks without any issues, regardless of the file type.

You can check these articles out for more information on formatting and uploading your files to QuickBooks:

• Format CSV files in Excel to get bank transactions into QuickBooks
• Manually upload transactions into QuickBooks Online
   

For future reference, here's how to review downloaded bank transactions to ensure they're under the right categories: Categorize online bank transactions in QuickBooks Online.

Please don't hesitate to use the reply button if you have any other concerns about importing your files into QuickBooks. I'm always here if you need further clarification and assistance, @waqarakram.