Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I purchased 3 items of office equipment from Amazon with my business credit card. Amazon charged my credit card twice where the two charges match the total of the 3 items but each charge doesn't match any one item purchased. I created one expense entry. How do I match this expense entry to the two credit card transactions? Using QBO
You can only match one downloaded transaction to one or multiple existing entries in QuickBooks Online, Darryl. Let me share an alternative way to handle the two charges with a single expense entry.
Since you're unable to match two credit card transactions to a single expense entry, exclude them from the Bank Feed. I'll show you how.
Additionally, please ensure that the expense you manually created represents the total amount of the three items purchased from Amazon. You may not link it to the bank transactions.
Moreover, refer to this article to edit or delete an entry: Enter and manage expenses in QuickBooks Online.
Furthermore, check out this guide to confirm that your records match your bank or credit card statement and avoid discrepancies: Reconcile an account in QuickBooks Online.
Your questions about expenses are always welcome. If you need more help reconciling your records, I'll be around to help you organize your accounts more.
This part is confusing.
"Additionally, please ensure that the expense you manually created represents the total amount of the three items purchased from Amazon. You may not link it to the bank transactions."
Is this a typo?
Was it supposed to say "You may NOW link it to the bank transactions"? If so, can you explain this more? How do I link them? Sorry, I'm new to QBO. Thanks
Thank you for pointing this out, Darryl. I appreciate your attention to detail and willingness to clarify this matter. Let me explain the intent behind the statement to address your confusion.
The statement "You may not link it to the bank transactions" means that the manual expense you created should remain separate from the excluded bank feed transactions. Linking them could result in duplicate entries and inflate your total expenses. Instead, treat the manual expense as the final record, as it accurately reflects the amounts.
QuickBooks matches transactions based on identical details such as amount, date, and account. Since QuickBooks does not allow matching multiple credit card transactions to a single expense entry, you'll need to exclude those transactions from the Bank Feed. This ensures your records remain accurate and prevents duplication.
When creating the manual expense, ensure it represents the total cost of the three Amazon purchases and includes all relevant details (like vendor, date, and expense category). This manual entry will act as the definitive record of the purchase.
I'll add this article as your guide to record, edit, and delete expenses in QuickBooks Online. Enter and manage expenses in QuickBooks Online.
After managing your expenses, I recommend reconciling your account to maintain clean and organized records that save you time and effort in the long run.
If you have additional questions or need further clarification about excluding transactions or creating manual entries, feel free to drop your Reply in this thread. The Community team is always here and ready to assist you!
Thank you for the clarification. I understand the expense part. Please excuse my ignorance of bookkeeping. I have always created an expense entry for things I purchase for my business. They are purchased with my business credit card every time. My bank accounts and credit card account are linked and when the new transactions of my credit card come in, they automatically match to the entered expenses. I click on the "match" button, the transaction gets filed away. By excluding these 2 credit card transactions, I'm thinking they are just sitting there as charges to the card and not related to anything. Don't I need to tell QBO what specifically those 2 charges belong to? An Amazon purchase, or a monthly software subscription, etc? Something? Or am I missing how this works? Thanks!
Everyone starts somewhere, and it’s completely okay to be unfamiliar with some aspects of bookkeeping, Darryl. You're doing a great job seeking to understand and manage your business finances better. I'm here to clarify things for you.
I agree with what my colleague explained about how QuickBooks matches transactions. When QuickBooks downloads new transactions, it attempts to match them with existing entries in your books based on factors like amount, date, and other details. If it finds a match, you can confirm it by clicking the Match button. However, if the suggested match is incorrect, you can use the Find other matches button to select the correct transaction.
You can follow the steps below on how to find other matches:
Please double-check all details when matching transactions to prevent any inaccuracies. It's important to be careful to maintain reliable financial records.
On the other hand, if you exclude credit card transactions, they will move to the Excluded tab and will not affect your financial reporting or account balance. Excluding transactions helps prevent duplicate and personal charges from disrupting your books. If you accidentally exclude a transaction, you can always go back to the excluded tab and Undo it.
You can visit this helpful resource for more details about excluding bank transactions in QBO: Exclude a transaction.
Additionally, you can use this article as a guide to help you reconcile and keep your financial records accurate and up-to-date. It offers a clear, step-by-step guide on how to reconcile your accounts, ensuring your financial statements match your bank transactions correctly: Reconcile an account.
Do you need more help on matching or excluding transactions in QuickBooks Online, Darryl? If so, please reply with your questions below. The Community and I are here to assist you further.
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