Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I have 2 qbooks accounts for 2 businesses. I use my personal amex for both accounts plus personal. I have all the statements and the transactions in a excel file (csv). The statement starts in the second account and the moves to the first.
My question is - Do I need to exclude everything else and just balance one acct and then move to the other acct and do the same thing?
What is the best way to do this? I have read over the reconciling with a manual upload but, just need to make sure there are no duplicates I make a mistake that I cannot fix.
Thank you in advance. Sorry for the confusion. If I get this done, I will know what to do with my personal credit union debit card. Same issue.
Solved! Go to Solution.
Hello there, @ bassplayer.
It’s possible when you manually upload transactions, it causes duplicates. You have the option to exclude duplicate transactions and let me share with you the steps.
Before doing so, you'll need to compare two transactions to verify they’re duplicates. Once verified, you can follow the steps below to complete the process.
I've also attached some articles you can use about how to match your transactions as well as other ways to categorize them in QuickBooks:
If you need more help with excluding your duplicates transactions. Just hit the reply below. Have a good one.
Hello there, @ bassplayer.
It’s possible when you manually upload transactions, it causes duplicates. You have the option to exclude duplicate transactions and let me share with you the steps.
Before doing so, you'll need to compare two transactions to verify they’re duplicates. Once verified, you can follow the steps below to complete the process.
I've also attached some articles you can use about how to match your transactions as well as other ways to categorize them in QuickBooks:
If you need more help with excluding your duplicates transactions. Just hit the reply below. Have a good one.
I would highly recommend that you have two separate credit cards for each business and a third one for personal as that would make your accounting SO much easier and significantly reduce the risk of errors.
Hello Mary Ann,
Thank you for the advice.
Q- If I manually upload the same file into both business as some relate to business 2 and some relate to business 1?
ex. Amex in bus 2 is showing a balance of 3,100.00 and 717 in bus 1. I have google g suite for business 1 and 2. Also qbooks for both businesses.
Hello there, bassplayer.
In addition to what my colleagues suggested, yes, you can upload the same file to both business accounts. Let's just ensure that you don't add transactions to the incorrect bank to avoid duplicates and it will be easier for you to reconcile. You can always add, match or exclude transactions according to the bank statement.
If there are transactions that you've mistakenly added or excluded you can always Undo the action so it'll be removed in your bank's register. I'll show you how to undo for those accidentally added or matched transactions:
The transactions are now moved to the For review tab for you to manage again. Once done, you can now proceed in reconciling the accounts.
You always got our back if there's anything else you need help with. You take care always!
Hello Teri Level 8,
I have learned my lesson. Once I get this squared away and everything is 0, I will just transfer money to those accts and pay bills that way. it will automatically transact from separate accts. No more mess. I will be able to file taxes this year and have brand new bus accts.
Thank you
Good Morning Catherine,
I personally want to thank you. It is very detailed. Just like your colleagues, I have alot of great info. I will let you know how it turns out.
Once again, thanks
bassplayer
Most people learn this lesson the hard way, so you are definitely not alone on this one here.
Most accountants tell you this from the start, or they should, but we also know many clients don't listen, since it sounds like more work in the beginning, but we already know how much worse it will be later.
Cheers!
Always curious why anyone would have two small businesses vs. just having one for everything.
Are they different ownership? What is the advantage of having to manage two different QB's?
For our business we couldn't set up shop and have service trucks in another state. We were on thin ice with our insurance provider. So we had to set up a 2nd business to be able to get the insurance.
You are out of touch with the way entrepreneurs and small business people work to suggest this. This is a normal situation for the majority of businesses.
I agree with you.. if we own three companies just file them with different DBA’s . Then create template invoices for each DBA stating the TAX ID number on it then assign a separate SALES tax for each division . This shouldn’t be feasible
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