cancel
Showing results for 
Search instead for 
Did you mean: 
HCoKP
Level 3

Importing Credit Card Charges to an Accountant's Copy

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"

6 Comments 6
AbegailS_
QuickBooks Team

Importing Credit Card Charges to an Accountant's Copy

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:

  1. Go to the Banking menu and go to the Bank Feeds. Then, select Bank Feeds Center.
  2. From the Bank Accounts list, choose the account you want to connect. 
  3. Choose you're ready to get your transactions, choose Download Transactions.
  4. Select Synchronize. If you only want to download transactions for a specific account, select Sync this account. Or if you want to download transactions for all your accounts at the same bank, select Sync all for this Bank.
  5. From the Access to window, enter your PIN or password to connect to your bank.
  6. Select OK.

 

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 DesktopCustomer 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!

HCoKP
Level 3

Importing Credit Card Charges to an Accountant's Copy

@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.

ChristieAnn
QuickBooks Team

Importing Credit Card Charges to an Accountant's Copy

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:

 

  1. Go to the Banking menu and go to the Bank Feeds. Then, select Bank Feeds Center.
  2. From the Bank Accounts list, choose the account you want to connect. 
  3. When you're ready to get your transactions, choose Download Transactions.
  4. Select Synchronize. If you only want to download transactions for a specific account, select Sync this account. Or if you want to download transactions for all your accounts at the same bank, select Sync all for this Bank.
  5. From the Access to window, enter your PIN or password to connect to your bank.
  6. Click OK.

 

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.

Fiat Lux - ASIA
Level 15

Importing Credit Card Charges to an Accountant's Copy

@HCoKP 

Explore this importer tool.

https://www.moneythumb.com/?ref=110

 

BigRedConsulting
Community Champion

Importing Credit Card Charges to an Accountant's Copy

@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.

Maverick2
Level 6

Importing Credit Card Charges to an Accountant's Copy


@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)

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us