Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Does anyone have a work-around or hack for importing a year's worth of credit card transactions for a client that sent us a .QBO file? Problem is we are using QB Desktop Accountant and running an Accountant's copy file that cannot be broken. We are looking at 100-150 transactions a month for a year, so hand entering each one is not ideal.
I am hoping an actual user will see this and have a solution and not get some generic copy and paste answer from QB "support team"
Hi there, @HCoKP.
Allow me to share some information about your concern in importing your credit card transactions.
Due to some feature limitation, you can only modify transactions that are in your clients accountant copy.
To isolate the issue you can set up an account using a Direct Connect in the client's regular account. This way QuickBooks will download the maximum number of transactions from your bank in this way. Depending on the bank, you may be able to download up to a year of historical transactions.
Here's how:
For more about the secure and easy way to share Accountant’s Copies between accountants and clients in QuickBooks Desktop, check out this article: Accountant's File Transfer Service
I'll be adding this article that can guide you to manually enter transactions in QuickBooks Desktop: Customer transaction workflows in QuickBooks Desktop
You can always get back to me whenever you have other concerns. I'm always here to help you anytime. Keep safe!
@AbegailS_ Thank you for your attempted reply but you clearly did not read my post and did not read my actual question. I am well aware of how to import QBO, however importing WebConnect files is for some dumb reason not allowed in an accountant's copy so I am looking for a work around since the existing programming is not useful. I clearly stated in my post that I am using an Accountant's Copy so your answer is irrelevant and does not apply.
Please actually read the user's posts and not just pick a keyword and reply with some generic, useless answer that is not even related to their question. Which is exactly what you did to my question. You wasted my time and anyone else reading this.
Hi there, HCoKP.
I appreciate you for coming back to the thread to add some clarification about your concern. With this, I'll be sharing information on the limitations of using the Accountant's copy and alternative options to achieve your goal.
While working on an Accountant's Copy, there are workflows and limitations in using this feature in QuickBooks Desktop. That said, you're unable to make changes by importing data from Excel, Web Connect, and QuickBooks timer files in an Accountant's Copy.
As a workaround, I suggest setting up an account using a Direct Connect in the client's regular account not in the accountant's copy. This way, QuickBooks automatically downloads the maximum number of transactions available from your bank. Depending on the bank, this can give you up to a year of the historical transaction and most banks may only download the previous 90 days.
Here's how:
Additionally, you also have the option to manually enter transactions in QuickBooks Desktop. You can click each article below to see the detailed steps on how you can track customer and vendor entries in the system.
Lastly, you may refer to this article to view details on how Accountant’s File Transfer Service lets accountants and their clients share an Accountant’s Copy through Intuit’s secure servers: Learn about the Accountant's File Transfer Service.
You can get directly in touch with me if you have additional questions about how an Accountant's Copy works in QuickBooks. I'd be glad to help. Take good care.
@HCoKP RE: Please actually read the user's posts and not just pick a keyword and reply with some generic, useless answer that is not even related to their question. Which is exactly what you did to my question. You wasted my time and anyone else reading this.
Don't you think you're asking an awful lot? You're asking reps here to completely change the way they answer questions.
Why, to do what you're asking, they'd have to:
1) Actually read the question.
2) Understand the question and the context.
3) Know how QuickBooks works.
4) Actually try to follow their answer to see if it works.
---------------------------
Unfortunately QBO files can't be imported using an accountant's copy file and there is no workaround - at least not within QuickBooks. It seems all forms of import are disabled.
This is probably due to laziness on Intuit's part, as they didn't want to be bothered to spend the time to write code to check the begin and end dates on the QBO file before importing the transactions to make sure they all fall before the cutoff date.
It'd be very simple to do. The dates look like this in the file:
<DTSTART>20211211120000[0:GMT]
<DTEND>20211211120000[0:GMT]
The logic would be as simple as:
If DTEND < Cutoff date, then it's OK to import.
@HCoKP wrote:@AbegailS_ Thank you for your attempted reply but you clearly did not read my post and did not read my actual question. I am well aware of how to import QBO, however importing WebConnect files is for some dumb reason not allowed in an accountant's copy so I am looking for a work around since the existing programming is not useful. I clearly stated in my post that I am using an Accountant's Copy so your answer is irrelevant and does not apply.
Please actually read the user's posts and not just pick a keyword and reply with some generic, useless answer that is not even related to their question. Which is exactly what you did to my question. You wasted my time and anyone else reading this.
Welcome to my nightmare. Just about every time I ask a question the question is not read, or it’s not read completely. I sometimes even say “I tried x or y.” Then I get a response to try x and y. Great! Thanks?
Just remember this: every problem you have can be solved by verifying and rebuilding company file. (Apparently)
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