United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
learningthisstuff
Level 2
posted
‎June 24, 2020 08:56 AM
last updated ‎June 23, 2020 3:56 PM

Is there a way to view or search for Transactions from Each Bank Account?

Hi, 

I made an error. Transactions in personal and business accounts were mixed. So I imported all my accounts (business and personal) into QB Online. 

I then sorted the transactions allocating all the business ones (to their transaction type as setup in chart of accounts). 
I also setup in the chart, one called, Personal (and allocated all my personal expenses to that, or selected 'Exclude') 

So, now, after speaking with an accountant, he said it's probably best to Disconnect all the personal accounts, and then manually enter the business expenses that were made in them, into QB. 

I have a few years worth of stuff I need to organise. So, was wondering if it was possible to 
Sort via each bank account. (perhaps I could get the personal account and sort it so I can see just the business expenses for each period... which could then be manually entered into QB... I believe as an adjustment). 

Or could all the transactions be exported to excel. I could then sort to reveal just the business transactions. 

Or if there's a better way to do this. 

Any advice would be much appreciated. 

Thanks 
 

Reply
3 Comments 3
Kass_B - Product Champion
Content Creator
‎June 24, 2020 12:18 PM

Is there a way to view or search for Transactions from Each Bank Account?

Hi learningthisstuff,

 

There are a couple of different ways you can review transactions entered into your books. The Transaction Detail by Account Report will allow you to view and sort the transactions specific to account:

 

  1. Click on the Reports tab, and use the search bar to locate and select this report.
  2. Select Customise on the top right.
  3. Enter the date range you require.
  4. Select Filter, then select the Account option and choose the relevant account from the dropdown. Then select Run Report.
  5. You can export this to Excel as required and sort further if necessary - look at the top right corner of the report for the Export symbol.

 

You can also run a report directly from the account itself:

 

  1. Select the Settings icon (top right) and choose Chart of Accounts.
  2. Locate the account and select Account history.
  3. Enter in a date range as required. Then use the export icon at the top right above the Balance column. 

 

Both reports will display the full transaction history for the account. Sorting through your personal and business transactions will depend on how you have categorised them; the first report mentioned above has a column titled 'Split', this lists where you have categorised the transaction to which you may find helpful. The second report displays a similar list however is titled 'Account'.

 

-Kass

Reply
learningthisstuff
Level 2
‎June 24, 2020 04:00 PM

Is there a way to view or search for Transactions from Each Bank Account?

 

 

 

 

Awesome! 

 

Thanks, I'll give these a go. 

 

Do you know then, if I were to dissconnect the bank accounts, would that delete the transactions? 
If not, would deleting the bank accounts (from QB) delete the transactions? 

 

I'm trying to find the best way to remove everything that I imported from the personal accounts except the business expenses. I imagine I might have to delete all these transactions and then manually import them as a manual expense (or a loan to the company or something). 

Thanks! 

 

 

 

 

 

Reply
Kass_B - Product Champion
Content Creator
‎June 24, 2020 04:29 PM

Is there a way to view or search for Transactions from Each Bank Account?

Hi learningthisstuff,

 

Any transactions in the For Review or Excluded sections of your Banking page will be removed if you disconnect the bank feed altogether:

 

  1. Select the Banking tab, then click on the account 'card' at the top of the page.
  2. Select the pencil icon in the top right of the 'card' and select Edit Account Info.
  3. On the popup, scroll down. Select 'Disconnect this account on Save', then Save and Close.

 

However, any transactions that you have already allocated to your books and are showing in the Reviewed section are now a part of your books and disconnecting the account will not remove these. You can either manually remove these in the Chart of Accounts account history by selecting each transaction and clicking Delete, or make the entire account inactive. To make the account inactive:

 

  1. Select the Settings icon, then Chart of Accounts.
  2. Locate the account. On the dropdown menu to the right, select Make Inactive. Any balance on the account will be automatically removed using an adjustment (to the Opening balance equity account) when you click Yes to confirm. 

 

-Kass

Reply