How to Record Total Daily Sales in Quickbooks Online from POS System
Vložit
- čas přidán 8. 10. 2020
- This video explains how you can enter your total daily sales from your POS system into Quickbooks Online using a recurring sales receipt transaction. Contact Casey Moss Tax and Accounting, LLC for all of your tax and accounting needs!
www.caseymosstax.com - Jak na to + styl
HI Casey
Thank for the great video. How now we record CC sales. Also, I got confused with Tax as here QBO will recognise the full amount in tax while we only recieved Tax for the Cash sales
Thanks
Thank you so much. Very useful
Hi Casey, We just upgraded to QB Online. I cannot find pending sales in this updated version. I was hoping your video was going to show me how we can view daily sales after they have been entered as a sales receipt. Hopefully you have a solution to where we can find this feature or a new one that replaced it. Thanks in advance, Poppy
How do you add a tip to an already created invoice? So I invoice $300 for service then the customer adds a $30 tip.
WOW! This is really great information and very helpful! Is there a way to automate this information to come into 'Quickbooks Online' daily, from a data feed from a non-integrated POS system? Thanks!
Hi Kevin,
Glad you liked the video! There are a couple of POS systems that integrate with Quickbooks Online, so you can try to set up their integration. Otherwise, you would need to use Zapier or another product to automate if possible.
Thanks!
Casey
Hi Casey, now that we're offline (not taking time out of the video) can you explain a little more about why the Cash Payments Received are entered as negative. i understand the debit & credit journal entries but confused why negative. Thanks.
Hi Gi. A positive number on a sales receipt represents a credit entry to the corresponding account associated with the product/service listed. When we record daily sales, part of our sales are received in cash. To record this, we need a debit to our cash on hand account because our cash balance is increasing. Therefore, to get a debit entry on a sales receipt, a negative entry is required. Hope this helps!
@@caseymosstaxandaccountingl1685 Hmmm...I've used other accounting packages before like MSFT Dynamics GP and in the Distributions window there is 2 columns, one for Dr. and one for Cr. So for a sale you Debit AR or Cash and Cr. Sales. Both values are positive amounts and the totals at the bottom of each column have to match. There is no negative values. This must be a QB thing and it's confusing.
A negative value being applied to my Cash balance would reduce it, not increase it. I'm confused as to how this negative value doesn't reduce my cash balance?
Hi Casey, I own a beauty salon, where we take deposits to secure the appointments, I also sell gift cards, and I also have a membership program where I presale services at a discounted price if they enroll in a monthly CC auto draft. I have a POS where I have all the details by customer transaction. Now, my question is what kind of sales receipt should I create on QBO to correctly record all the payments ( I am clear with Cash and Credit Cards), But I am not sure how to register the liabilities of selling gift cards or prepaid services; and at the end of the day when the customer has used their credits to pay, what do I need to do?
Hi Andres,
I'd be happy to help you with this, but it'll require a consultation and some more work as it's a more complicated entry. Feel free to reach out to me via email (cmoss@caseymosstax.com) and I can give you some more information about this.
Thanks!
Can you show how/where you reflected cash deposits? Also how would you deal with Online orders that are paid 3-7 days later and minus fees for delivery?
Create a receivable account for delivery food. Then on the daily sales receipt debit the A/R delivery amount for the day. 3-7 days later debit your deposit amount and fees and credit your a/r delivery account to clear it out.
Hi freind
Thanks for this video
But in the resturant how i deal with delivery app that we deal with by credit and pay us after 2 weeks
Hi Mohaned,
For these types of payments, you'll want to set up a separate product called "Grubhub" or something similar. The corresponding general ledger account associated with this product should be "undeposited funds." Then, when the payment comes in, you'll choose New+Bank Deposit to enter the deposit into the bank.
Hope this helps!
What do you do with the sales tax number is your POS system calculates the taxes collected slightly differently than QBO? Do I need to have an additional account to capture that discrepancy?
Hi Townley. When this happens, there is a button next to the sales tax that says "see the math." You can click this and override the calculated amount. I'll only do this when the sales tax collected is off by a few pennies from rounding. That way your sales tax reports from QBO will match your POS sales tax reports. Let me know if you have any other questions about this.
@@caseymosstaxandaccountingl1685 Thank you. I am not sure if I am doing this correctly or not, but I don't see anything on the PNL side after I do this. Do I have to separate doing something to have these appear as entries on the PNL side? Basically I want to record all our sales daily and then match them to the account activity from the bank account so that everything is completely reconciled. Hope that makes sense. Thanks in advance for your help!
@@townleychattman5915 If you are not seeing any of this activity coming through on your profit and loss statement, you may need to make sure you have the correct categories selected for each product and service. Generally, if you have them set up correctly, it will post to the correct accounts and be visible on your profit and loss statement. In order to match to your bank feed, you need to make sure that the total deposit amount matches your total credit card deposits from your POS system. This can be complex to set up, so feel free to contact me for a consultation if you need assistance: caseymosstax.com/contact-me/
Can this method be used as a "monthly" or "weekly" sales receipt?
Hi Jacki,
Yes, this could be used as a monthly or weekly process as well. However, instead of the deposit going into the bank account, you'll want it to go into an "undeposited funds" account or a clearing account of some kind. Since the credit card deposits will still be coming in on a daily basis, you'll want some way to verify that the amount deposited matches your sales receipt entry.
@@caseymosstaxandaccountingl1685 would I then JE to clear the deposit from clearing account. I can’t see how this flows in QBO? Would each daily sales deposit/payment be listed in the “monthly” sales receipt separately to be able to match it from the bank feed for clearing account to balance to zero each month?
@@jackikiss1362 You would then code each deposit hitting the bank account to the clearing account to offset the amount from your sales entry. And no, if you are entering it monthly or weekly, it will not match your bank feed. That's why I generally recommend entering this daily so you have clear matches of deposits to sales receipt entries.
how to record sales from Clover POS sales report?
Just print a daily sales report from clover and manually enter it.