Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHi Everyone
Some of my customers pay their invoices via the 'Square' system....however, when the payment arrives in my account from Square, it has taken out a percentage for it's fees, and so it no longer matches the original invoice price.
How do I record this accurately? For example, the original invoice was for $221, but Square took out a fee of $4.86, meaning that I only receive $216.14 in my account to match against the invoice, and so Quickbooks still thinks that my customer owes me money and their invoice is still outstanding!
Please advise how I resolve this issue, and how I can record it accurately each time this happens.
Thanks
Hi there, @Han2.
Let me help you record your invoice from your Square system. You can create a service item and name it into "Square Fee's" in your QuickBooks Online account and link that item to an expense account. So, once you enter an invoice transactions from the square, you can include the square fee's in the item line.
Let me walk you through the steps on how to create an item. Here's how:
For more detailed information, you can read this article: Add product and service items to QuickBooks Online.
Once done, you can use the Sales by Product/ Service report to track the service item. Just customize the report to pull up the specific statement you want to show.
Fill me in if you need more help by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!
Thank you for your assistance
I followed the steps that you outlined, but because it is an expense account that I set up, it won't allow me to choose it as a line item on the invoice because it requires an income account
@Rejeil_O wrote:Hi there, @Han2.
Let me help you record your invoice from your Square system. You can create a service item and name it into "Square Fee's" in your QuickBooks Online account and link that item to an expense account. So, once you enter an invoice transactions from the square, you can include the square fee's in the item line.
Let me walk you through the steps on how to create an item. Here's how:
- Go to the Sales tab, then select Products and Services.
- Click the New button, and choose the Service option.
- Name the item (Square Fee's), and enter the SKU's (Optional).
- From the Category field, select the category that best describes the service. Learn more about the item category.
- Click the I sell this product/service to my customer to remove the income account on the item.
- Put a checkmark in the box beside the I purchase this product/service from a vendor.
- Add the description.
- Enter the Cost of the service (Square fee's).
- Click the Expense account dropdown arrow, and select the account that fits your service item.
- On the Preferred Vendor field, enter the Square system as a vendor.
- Click Save and Close.
For more detailed information, you can read this article: Add product and service items to QuickBooks Online.
Once done, you can use the Sales by Product/ Service report to track the service item. Just customize the report to pull up the specific statement you want to show.
Fill me in if you need more help by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!
I do appreciate the steps you've performed to add the fees on your invoice, Han2.
We can receive a payment on the invoice without the square fees. Then, we'll deposit the payment to Undeposited Funds. When we create a bank deposit, we'll add the expense account used in tracking square fees. I'll show you how:
The amount total to deposit is now $216.14 which you can match to the customer's actual payment.
You can always leave a reply below if you need more help. Take care and have a nice day!
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.