Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How should QB users reconcile the funds they receive in their bank accounts from ecommerce transactions with the transaction metadata they receive from payment gateways (i.e. make sure that transactions reported by the gateway provider match actual funds received, etc.)?
Would we expect to be able to sync transaction metadata passed to bank account memos into QB? Or must we do it manually by comparing each transaction reported by a gateway to an individual bank transaction (which is quite tedious if you've got '000s of transactions per month)?
Solved! Go to Solution.
Hello there, @phaedrus.
I can clear things up for you. Transactions from e-commerce that sync in QuickBooks Online (QBO) can be matched in Banking. That's possible if their bank account is already connected to QBO. Metadata entries from the payments gateway post to QBO depending on the set up.
For transactions that didn't directly match in banking, we'll have to use the Find Match tool to manually locate them.
Here's how:
Once done, we can proceed to reconcile the account. Let's just make sure all the information matches the bank statement. You may visit this article for detailed steps: Reconcile an account in QuickBooks Online.
I'm adding this article to know how to use bank rules to automatically categorize transactions from your bank: Set up bank rules to categorize online banking transactions in QuickBooks Online.
Feel free to drop by the Community whenever you have further concerns regarding your transactions. Have a great day ahead!
Hello there, @phaedrus.
I can clear things up for you. Transactions from e-commerce that sync in QuickBooks Online (QBO) can be matched in Banking. That's possible if their bank account is already connected to QBO. Metadata entries from the payments gateway post to QBO depending on the set up.
For transactions that didn't directly match in banking, we'll have to use the Find Match tool to manually locate them.
Here's how:
Once done, we can proceed to reconcile the account. Let's just make sure all the information matches the bank statement. You may visit this article for detailed steps: Reconcile an account in QuickBooks Online.
I'm adding this article to know how to use bank rules to automatically categorize transactions from your bank: Set up bank rules to categorize online banking transactions in QuickBooks Online.
Feel free to drop by the Community whenever you have further concerns regarding your transactions. Have a great day ahead!
Which eCommerce platform do you have? e.g WooCommerce, BigCommerce, Shopify
Which payment gateway do you have? e.g Paypal, Stripe
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