Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We input our sales from the POS by category from our third party software sales receipt daily. Our sales then show up in quickbooks as single sum with various categories (approx 4-6). We have synced our bank transactions, and the POS transfers the sales amount by card type, but its impossible to split and match each deposit by card type AND THEN match those sales with each category based on the sales receipt we create daily. If I could combine the bank transfers to match our daily sales receipt, I think this would resolve it, but I don't see where to combine bank transactions that are linked from our bank.
It's a great idea to combine bank transactions that are linked from your bank account, @The Paw. Allow me to provide further details about this below.
Currently, we're unable to combine bank transactions linked to your bank account, especially when your POS system sorts out sales deposits based on credit card types. Also, you're correct that you can only split the transactions. However, we're unable to categorize and match them with your sales receipts that you synced through your third-party POS.
In the meantime, I recommend sending feedback about it. We always consider customer feedback when improving or adding features. This will give us an idea of how we may improve the functionality of QBDT to meet users' needs and enhance the working experience. Here's how:
For more details about the feedback process, you can refer to this article: Submit feedback.
I'll also add this guide to help you reconcile your accounts so they always match your bank and credit card statements: Reconcile an account in QBDT.
Your thoughts and opinions matter to us. Please feel free to ask if you have any other concerns about combining bank transactions. I'm always here to help.
Thanks @Clark_B for the reply.
So it doesn’t sound like there is a solution to this. How would you suggest we match our deposits and transactions then, not using the sync feature with our bank might work but that unfortunately results in under-utilizing quickbooks features that are designed to make our bookkeeping easier…
@Clark_B we are also using the online version not the desktop.
Thank you for sharing this info and letting us know that you're using QuickBooks Online, @The Paw. I understand how convenient it would be if the system could combine deposits to create a single deposit and match it with a single sales receipt.
With QuickBooks Online, we can only match a deposit from your bank with multiple sales transactions but not vice versa. For example, if you have a bank deposit transaction, you can match it to a single sales receipt or invoice or a combination of invoices, sales receipts, and payments using the Find other matches feature. Please follow the Match with an existing transaction section from this article for more insights: Match online bank transactions in QuickBooks Online.
Here's a screenshot of what it looks like:
Also, you've mentioned that your sales receipt contains 4-6 categories. If that's the case, you can exclude the 3 deposit entries and create a CSV file to import a single deposit entry. This way, you can match it with the sales receipt, as QuickBooks does not allow combining multiple deposit transactions. This method ensures a one-to-one match between the bank deposit and the sales receipt/payment/invoice record.
On the other hand, you can submit your product suggestions directly to our engineers about combining deposits through QBO feedback. This allows us to benefit from your experience and potentially implement this feature if it becomes popular among users.
For more details about matching your bank feeds with QuickBooks records, you can bookmark the first article that I have presented."
Moreover, I'm adding these articles as your future references in case you want to undo bank feed categorizations before reconciling your bank at the end of the month:
Let me know if you need more assistance or alternatives with matching online banking transactions and exploring solutions with QBO. I'm always here to help. Take care.
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