I am using QuickBooks Premier 2019 Desktop. I have one user but multiple salespeople each with their own business credit card. I currently have them hand me their physical receipts and then manually enter them into QuickBooks. Is there a better way for me to track their expenses?
I currently have each card set up with their own username and password. The card/bank, American Express, is not allowing multiple user names or the same username with different passwords to download through QuickBooks.
I understand you probably have separate logins to the card accounts so that the employees can access the data as well as you. An alternative would be downloading transactions in csv/excel format and then uploading into QBDT. Even if the only export from AmEx you can get is pdf there are pdf edit programs that can convert a pdf to excel.
Correct, also having them all separate allows me to track each of their individual expenses. It's strange that the Quicken product allowed this type of downloading but QuickBooks does not so I am not convinced that this a bank issue but possibly a QuickBooks issue that needs to be addressed.
Currently, you can only connect one American Express account to your QuickBooks. Let's connect the parent account and add the sub-accounts.
To create a subaccount:
You can download your sub-accounts transactions to keep track their expenses, but you'll only need to reconcile the parent account. This is because the bank provides us with a static balance of the entire account, not the subaccount.
I'm sure many QuickBooks users would find this feature helpful. I can send feedback directly to our engineers. They can consider this feature added in the future update.
I've added these articles for your reference:
Please know that you can always swing by anytime if you have other questions.
Thank you Sheila but in the Bank Feeds window would I only be using the master account? How would the transactions get into the individual sub-account?
Thanks for responding Dbraun4,
You'll be using your master or parent account for reconciliation purposes. Then, import your individual transactions via WebConnect into your subaccounts to keep track of their expenses. Let me help you with the steps.
To download web (.qbo) connect files:
Once done, go to the Bank Feeds Center to review your transactions.
To reconcile your parent account, please refer to this article for the detailed steps: Reconcile in QuickBooks Desktop.
The Community is always here to help if you have other questions, please don't hesitate to reach out.
Again, thank you for your responses and work-around. Although your method works it takes so many steps for each individual card. As I said, Quicken offers one simple login that will download transactions for all accounts including individual cards that are set up as online accounts and it amazes me that an application as supposedly as advanced as QuickBooks is cannot accomplish the same thing.
Thanks for getting back to us, @Dbraun4.
The WebConnect feature is the available workaround for QBDT to track each individual card. At this time, setting them all up to download their respective transactions using bank feeds is unavailable.
You can follow the steps provided by my colleague in the meantime. Rest assured, I’m passing it along here on my end for consideration in the near future.
A suggestion like this is very important for us to know how we can be even better. In the meantime, get details regarding QuickBooks Desktop’s newest features by following the steps below:
Thank you for understanding. I’ll personally update the thread for any information or changes.
Also, for some tips and resources about QuickBooks, you can visit our Community website: QBDT Self-help.
Let’s me know if you need anything else. I’m more than happy to help. Wishing you and your business continued success!