cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
cathydore-icloud
Level 1

I’ve been using my personal account for business banking so the only transactions I want to import are sales/fee income. Can I simply ‘exclude’ everything else?

I have a new business account but this is so I can give my new accountant details of my business income since last April.
1 REPLY 1
JuliaMikkaelaQ
QuickBooks Team

I’ve been using my personal account for business banking so the only transactions I want to import are sales/fee income. Can I simply ‘exclude’ everything else?

Hi there, cathydore. Let me share some additional information about excluding transactions.

 

In QuickBooks Online, you can exclude transactions you don't wish to include in your bank feeds. Before doing so, please know that the excluded transactions will not appear in your account registers or financial reports, which could make it easier or harder to reconcile your accounts depending on the type of transaction. If these transactions are automatically downloaded from your personal account, follow these steps to exclude them:

 

  1. Go to Transactions and select Bank Transactions.
  2. Click the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Click Exclude.

 

You may also refer to this article for more details about excluding transactions and Undo a mistakenly excluded transaction: Exclude a bank transaction you downloaded into QuickBooks Online.

 

If you need to transfer the sale/fee income transactions from your personal account to a new business account, you can exclude all the irrelevant transactions to avoid duplications. Then, you can download a CSV file of all your transactions and import only the required ones into the new business account. Here's how you can do it:

 

  1. Go to Transactions, then select Bank Transactions.
  2. Select Upload transactions.
  3. Select Drag and Drop or Select Files, then select the file you downloaded from your bank and click Continue.
  4. In the QuickBooks account dropdown, select the account you want to upload the transactions into and click Continue.
  5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then click Continue.
  6. Select the transactions you would like to import, then click Continue.
  7. Click Yes, then hit Done.

 

Furthermore, you may consider checking the CSV formats applicable to QuickBooks. 

 

You can also set up bank rules to categorise your bank transactions in the program.

 

If you have any further questions or concerns about managing your transactions or any other QuickBooks-related queries, please don't hesitate to contact us. We are always available to help you navigate any next steps that may be needed, and we are just a click away. Have a good day!

Need to get in touch?

Contact us