Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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:
You can also run a report directly from the account itself:
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
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!
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:
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:
-Kass
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here