cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
BigWaveIndustries
Level 1

Comingled Bank account - Attempting to upload CSV

We started our business last year and we are very aware we should have got a separate business banking account. Alas, we didn't for a few months. So now I have a few months of bank statements with comingled transactions of business and personal. 

 

Do I simply upload the entire CSV and go from there, distinguishing the transactions, or only upload the business transactions. Searching for this answer has resulted in no results...

 

Any help would be greatly appreciated!

Thanks

2 Comments 2
Adrian_A
Moderator

Comingled Bank account - Attempting to upload CSV

I'm here to help manage your bank transactions, BigWave.

 

You'll have to upload the business transactions only since they include any costs incurred in your bank account that relate to the running of your business. I'll guide you through the steps.

 

If you connected your bank account, the system will download the latest 90 days transactions. Then, you'll have to upload the others manually. Here's how to import the transactions:

 

  1. From the Banking tab, select Banking.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. In the Link account drop-down, select Upload from file.
  4. Click Drag and drop or select files and then select the file you downloaded from your bank. Then select Continue.
  5. Select the account you want to upload the transactions into.
  6. Hit Continue.
  7. Continue with the on-screen instructions to successfully upload the transactions.

 

From there, you can categorise them. I've added these links for the steps to manage your transactions:

 

 

I'm always around if you have concerns with managing your bank transactions.

Fiat Lux - ASIA
Level 15

Comingled Bank account - Attempting to upload CSV

@BigWaveIndustries 

Another option, use csv2qbo converter tool

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