cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
straitshome-com-
Level 1

The bank feed with Singapore OCBC Bank has format issue. the data format is not aligned. There is no key transaction description. Instead there are type of transaction

 
1 Comment 1
ReymondO
QuickBooks Team

The bank feed with Singapore OCBC Bank has format issue. the data format is not aligned. There is no key transaction description. Instead there are type of transaction

Good day, @straitshome-com-.

 

I'd be glad to help import your bank transactions into QuickBooks Online (QBO). 

 

Each bank formats CSV files differently. Thus, you'll have to ensure you're following a 3-column or 4-column format to successfully upload CSVs into QuickBooks. 

 

Please see the screenshots below for additional reference:

 

The 3-column format has a Date, Description, and Amount column. 

 

 

On the other hand, the 4-column format has a Date, Description, Credit, and Debit column.

 

 

In case you encounter any error messages when uploading, make sure to fine-tune the formatting

 

If you're referring to something else, I'd also appreciate it if you can share a screenshot and additional info. That way, we can provide the right steps to address the issue. 

 

When your file is formatted correctly, follow these steps to upload your transactions into QuickBooks Online. Once they're in QuickBooks, it's time to match and categorise them. They'll go into your accounts after you review them.


@straitshome-com-, should you need further assistance with this? Or need help performing specific tasks in QuickBooks? Feel free to get back to me by clicking the REPLY  button below. It'll be my pleasure to assist you again. Take care, and have a nice day!