How to match Square transactions in QuickBooks Online
ฝัง
- เผยแพร่เมื่อ 17 ก.ย. 2024
- How to match transactions coming from Square integration into your bank account. Detail information on how to locate each transactions and match it in banking avoiding duplication.
If you need a one-on one training please contact us at:
phone 407 504 9828
email: qboxperts@gmail.com
How to integrate Square into QuickBooks online tutorial:
/ @claudiaxperts
That video in the right hand corner is getting on my nerves. Its blocking key items!
Thanks for the feedback. I may redo this video.
Thank you! Very helping information.
You are welcome Jay!
Hey Ms. Claudia,
Great video on matching Square transactions. Could you make a video on how to create a “clearance account” for square transactions as well as how to create the corresponding journal entries that you mentioned. Thank you for sharing your xpertise with us.
Hi Debra, absolutely!!
Just got it published check it out
Hey Claudia, I've been reading the reviews on "Connect to Square" on the QBO website. Overwhelmingly, the new app is poorly rated and people hate the change. You seem to have found the Niche on TH-cam posting videos specifically about Square. For someone like myself getting up to speed on Square, have you thought about a video that compares Sync to Square app vs Connect to Square app and the major changes comparing the two. It seems from the reviews that people are frustrated on how the app operates but some just love it. Just a thought. Thank you for your videos on Square.
Hi Glen, yes there are issues with the integration. But when it does work it is a life saver.
Thanks for your video it was helpful.
Glad it was helpful!
Glad it was helpful!
Help full great...👍
Glad it was helpful!
look at where you video window is sitting- blocking the screen view of the information in quickbooks you are talking about
I will record another video on the subject. Stay tuned!
Hey Claudia, with the recent updates from Square, does the integration automatically create the accounts like Square Bank or Square Fees in COA, or do you have to set them up manually? I missed that in your videos if you covered it. Thank you!!!!!
Hi Glen, no more Square bank on the new update. Cash transaction go into Undeposited Funds and credit card transaction will go into the bank. There are accounts that will go into Square Banking if they were connected with Square before the update.
Thank you! Not sure what your next video topic will be but a overview of what COA accounts are needed with Square would be helpful. Such as fees move to Square Fee, income will flow to Square Income, Square bank will operate like a clearing account, and so on. And where in QBO or Square are the accounts assigned to correctly receive such transactional flow. Here are your 5-6 accounts you must have in COA to properly process Square transactions. Your videos are greatly appreciated and helpful. Thank you for taking the time to reply to your viewers!!
@@glenw.3813 Awesome Glen, I will cover that!
Hey Ms. Claudia, have you created this video that Glen W. suggested? What is the video title? I need to review this video to understand more fully how to handle specifically, Square transfer transactions so I can progress to reconcile. Thank you
Hey Ms. Claudia, why are some Square transactions Matched and others Added as a Deposit to the check register? I like the fact the deposit is split showing the difference between the Square amount and fees.
All should be matched, there could be discrepancies with the process or integration.
Ms. Claudia, if the Square integration is performed later in the year rather than the beginning, could this affect locating and matching transactions? I have Square transactions for January 2022 but cannot find a match for them. Thank you
@@debrajasey3212 Hi Debra, it looks like those transactions may be sitting in Undeposited Funds or maybe the deposit was recorded to the account but not matched. There is no way to tell what is going on unless I look at your books. I do offer one on one zoom sections and I charge $100.00 per hour if you would like to set up a time to meet please contact me at 407 504 9828 or email qboxperts@gmail.com
How do you get QB to quit thinking every transaction from Square is a new vendor, because of the date they add in the vendor name line? I'm not doing something right.
Hello, you are not able to change that. It is AI and you will always need to update because it is 99% wrong.
Thanks…. Also we couldn’t see much of it becaus the video was blocking whatever it was you were clicking . Is there another one. ?
I have a few videos in Square Integration. I will redo this one.
@@ClaudiaXperts if you could please show us how the square transactions will show on QBO and and if we need to either match or add the transaction BUT we out duplicating the fee . For instance. Square app shows $50.00 on the square tab . The bank feed shows $50.00. Do we go to the square app and. 1) add it to the bank feeds or do we 2) match it.
Note: do we need to work on the square app first by addin/matching or do we work in the bank feeds first and then go to square’s tab and then match it from there. Whatever we need to do as lokg as we don’t duplicate in omen
@@israelalvarado9720 Israel you need to add from Square app first then match it the bank account.
@@ClaudiaXperts thanks. The only thing that I don’t see that anywhere as an option on the bank feeds. I do see the options to either add or match but I see that from the “application transaction.” . I looked everywhere on TH-cam and I can’t find a video that can help us understand how to properly transfer payments from square to bank feeds without duplicating income.
I believe that if I categorize the amount first from the bank feeds before adding/matching the same transaction from the application transaction I’d might be duplicating it.
Am I right when I say . March it from
The app feeds and then categorize it at the bank feeds?
@@israelalvarado9720 Israel you add in the app transaction and go into banking and match it. If you do not see on banking as a matching option is because the transaction may have checks or cash mixed. I have another video on how to match transactions when there is a difference. I also offer one on one tutorials if you want I charge $100 per hour for a One on One Zoom meeting
Hi Ms. Claudia, I'm reaching out to you again. My Square-Mobile transactions in the Banking/App Transactions tab are being categorized to Miscellaneous (according to the Category or Match column heading). When I click on a transaction to view the details, it shows "Square Item" under Sales details. In the Accounting/Chart of Accounts for Square Item it shows it is an Income account, but does not show how it is categorized. Do you know why my transactions are being categorized to Miscellaneous and how do I correct it so it is going to the right account and what should it be? I'm assuming a mixture of Sales, square fees, taxes, etc. Thank you for your help!
Your products and services for Square item is probably routed to miscellaneous income. Go to products and services, click on Square item look at the income and verify if it is routed to miscellaneous account if so change it to the right income account t.
@@ClaudiaXperts Thanks for the quick response! I looked at an older transaction and clicked on "More" at the bottom of the screen and then "Transaction Journal" which shows that the transaction was going to Undeposited funds as a credit, and Bank Chgs: Sq Fees as a debit and the deposit into checking as a debit. This was before the Square update happened this past year. Does Square or QBO provide the mapping of the transactions? How do I get each transaction/deposit to split out into the correct accounts/categories? Does it just automatically come from Square with the correct info? I have tried searching for this info, but can't seem to find any answer.
@@joditrop Hi Jodi it splits according to what you have in the integrating mapping. You can click on the app tab, then click on the app settings and the mapping will be there. I do offer one on one tutorials and I charge $100.00 per hour if you are interested in a session let me know.
Where are the instructions/ where the link on how to do tracking? And how to add in lump sum?
To add lump some is how you link the app. If you selected to track individual transactions you will need to disconnect and reconnect. Please watch the video on how to link Square to QuickBooks.
Here is the link for the QuickBooks integration: th-cam.com/video/VCEocaNeEEw/w-d-xo.html
Hi Claudia,
What can I do if Square just sync my sales until the end of August month and I need to add the last for month. How can I do it in a bulk? Thanks
If your transaction are not flowing through then you integration may be broken and you may need to reconnect.
Hi Claudia,
Thank you so much for your prompt replay. I did but it doesn't work. I disconnect and connected again and I still have the issue. What else do you think I can do? Thanks
@@JhonnyGomez-m8kYou can contact QuickBooks and request them to verify why transactions are not coming through. You can hire me to look at what you have right now and see if the problem is with mapping. I charge $100 per hour for a Zoom meeting. If the problem is with QuickBooks integration you may still have to contact them.
@@ClaudiaXperts Hi Claudia, Thank you so much for let me know. I'll contact Quickbook if they don't provide me any information. I will contact you. Could you please send my an email with your services rate? Please
Hey Claudia! thank you so much for your video!
I have a problem with my Square and my Banking account, I can see the match with the Square and the deposit in my account but when I look for the transaccion in my account it isn´t there. I think the Quickbooks make change of what I can see or show me.
PLEASE HELPP!!!
Oriana it is hard to tell what is going on without looking in your books. Are the transactions coming through the app? Then are you adding the app transactions? Are the amounts in the app transaction the same as what hit your bank?
Remember that Square transactions will not match if you don’t add them first in the app tab. But prior to adding the transaction from the app make sure that when it hits the bank it is the exact amount. If you are adding the transactions there is also a possibility that when you add then it goes to undeposited funds.
@@ClaudiaXperts Yes, the transactions coming from the app.
No don't add any transaction at the moment , because they go to undeposited founds.
Yes they are the same amount.
@@ClaudiaXperts Hey Claudia! I found the problem, Quickbooks apply a rule, and match the deposit with the Square transaction! That´s the reason I wasn´t able to see it in my Checking account and only in Square Transactions.
Thank you so much for your time!
@@OriEnRemoto That makes sense, never set up rules for income transactions
When I manually entered the reports from square to quickbooks desktop I added service charges (3% of total taxed items) but with Quickbooks online, how can I add this service charge as it is not on the banking app transactions?
You will have to add from the chart of accounts as an expense account, this video is on QuickBooks Online not desktop.