Hi. I am getting credit card payments on my website. The invoice is being sent to the customer from the website itself. not from QB.
After a few days, money comes in to my bank account and is shown on QBO as a transaction line of the bank account.
Obviously I cannot match this deposit/payment to an invoice in QBO, since the invoice was not generated in QB, rather in my website.
How can I process this transaction in the most efficient way?
* I've tried creating a Sales Receipt for each sale but it is automatically marked as PAID so I cannot match the line transaction to that sales receipt. I would like to be able to match the payment to an Invoice or any other Sale transaction so the inventory change on QB will be recorded as well.
Any ideas of how to process that, knowing that the sales are growing and I will not be able to create an Invoice and/or Sales Receipt each time I sale online?
I am working with two merchant providers:
- Authorize.net, but they have stopped their sync option to QB.
- Brainrtree, which requires a monthly fee for syncing.
Any help will be greatly appreciated.
We want your reports to be accurate, adi.
The best way to handle this situation is to create an invoice and match it to the bank transaction.
Here are the steps:
Then, match the invoice to the transaction in the banking section by following these steps:
The process will automatically create a payment transaction to the invoice when you view the customer transaction list.
You can also check this article for your reference: Add and match downloaded banking transactions.
If you have any additional questions or concerns, please don't hesitate to leave a comment on this thread.
Thank you for this answer.
Yes, I am aware of the invoice option but....
My online customers are individuals. When a sale on my eCommerce website is completed, the website (Magento based) creates an invoice for the customer. I do not want to create another invoice under that customer's name in QB, as this will be a double invoice in my books.
That's why I thought a Sales Receipt will do fine here.
Is there a way to sync Magento with QB?
And what would be the difference between an Invoice and a Sales receipt for that matter?
Anyway, adding manually invoices, or sales receipts for that matter, sounds like heavy duty work.
Prior to this situation I am in, Authorize.net had a sync with QB so for any transaction on Authorize.net, the sync created an invoice in QB and all I had to do with the line transaction in the bank account was to match it to that already automatically generated invoice.
I was looking for some kind of option like that without having to manually create an invoice/Sales receipt for each customer.
Thank you so much for your help on that.
Hi there, adi.
You can save your time and eliminate the manual data entry in QuickBooks by syncing your data from ecommerce to QuickBooks Online. There are applications available online or in the QuickBooks App website that’ll help you fulfill the process.
Please visit us again if you have other questions or you need assistance while working with QuickBooks.