Because Sales tax is short term liability account. You are collecting from your clients on behalf of your State, County, and City. When you pay the sales taxes you categorize as sales tax payable to remove the liability from the books. Sales tax should never touch the Profit & Loss. To increase your liability you credit to lower liability you debit.
I'm new to Toast and new to qbo. We pay out our tips daily out of the cash on hand, and the cash on hand stays in the restaurant. Is there a way to set up the template to reflect the credit card sales, tips received/tips payed, and cash on hand
The template will be the same. All the cash tips will need to be enter manually. You can do a Journal entry for that credit cash on hand debit tips payable.
I'm confused about the cash debit. I know where you are getting the number which is from the report. However, that means cash will be increasing month over month on the balance sheet. The business owner then deposits cash to their bank. So in the banking we will see deposits in the 'received' column. If you categorize it to the Toast Clearing, when will the cash balance ever go down?
Whenever you categorize your bank feed deposit as cash bank what you are doing is removing cash from cash bank and adding to your checking bank account. This will lower your cash bank balance and increase your checking bank account.
Is that a typo? Do you mean categorize bank 'feed'? Or bank fees? If I categorize cash deposits in the banking center to cash bank that still increases the cash bank account. Im sorry could you try to explain that again? I would really really appreciate it!!!
@@crystalramirez5631 Yes it is bank feed. Crystal when you categorize cash deposit in the bank feed as a cash bank what you are saying is that you took money from the cash bank account and deposited into the checking account. So money was taken from the cash bank therefore it lowered the balance and was deposited into the checking account which raises the balance in the checking account.
Great lesson as always. Thanks for sharing such high value info. I would request you cover Shopify and Amazon/QuickBooks topics. Also if you could explain how to understand their sales reports.
Working on QBO for a food truck. In the clearance account you mentioned recording income and expenses for Toast. For example, there are monthly fees associated with using the toast POS system automatically debited from the bank account. Should that be recorded under the clearance account? When recording September sales and adding the bank settlement deposits the clearance account has a balance. You mentioned it should zero out.
Hi Heather if the monthly fees are going through your checking account you just categorize from the bank feed no need to enter in the clearance account. At times clearance may hold funds, therefore, there will be a different till the funds are released.
Hello, I am confused here. Why do we enter the gross sales when that has the tips collected as well? the actual sales are the gross sales minus the tips which will then give us an actual picture of our daily/monthly revenues. To match it with Toast we should then take the gross sales minus the tips and that is what our revenues should be. can you please clarify?
Hi Dan this information is taken from the Toast reports. Please note that the tips is a liability in the balance sheet. So we credited the liability account to match what in the Toast report. We are not making up those numbers they are coming from Toast. The tips liability is removed when tips are paid to employees. They are never recorded in the Profit and Loss
But if you do it this way (which I love cause it’s old school and THAT never fails), then, the sales taxes are not automatic and the sales tax tab I’ll have it without a purpose. Right?
The sales tax will go straight to the balance sheet as a short term liability named sales tax payable. When you pay it you categorize as sales tax payable to offset the liability. With commerce sync they may send sales receipts for each batch containing the sales tax. You will need to set up sales tax prior to integrating with QuickBooks.
Working in Xtrachef & QBO- are there any experts out there with experience mapping COGS & Sales in Xtrachef to QBO? Please help if at all possible, I am willing to pay an expert to help with this. I am new to restaurant accounting and need to get my P&L correct. Please help! :)
How about for loyalty program offered by restaurant? where does that fall into?
That would be a separate entry.
Why wouldnt the sales tax be credited?
Because Sales tax is short term liability account. You are collecting from your clients on behalf of your State, County, and City. When you pay the sales taxes you categorize as sales tax payable to remove the liability from the books. Sales tax should never touch the Profit & Loss. To increase your liability you credit to lower liability you debit.
I'm new to Toast and new to qbo. We pay out our tips daily out of the cash on hand, and the cash on hand stays in the restaurant. Is there a way to set up the template to reflect the credit card sales, tips received/tips payed, and cash on hand
The template will be the same. All the cash tips will need to be enter manually. You can do a Journal entry for that credit cash on hand debit tips payable.
I'm confused about the cash debit. I know where you are getting the number which is from the report. However, that means cash will be increasing month over month on the balance sheet. The business owner then deposits cash to their bank. So in the banking we will see deposits in the 'received' column. If you categorize it to the Toast Clearing, when will the cash balance ever go down?
Whenever you categorize your bank feed deposit as cash bank what you are doing is removing cash from cash bank and adding to your checking bank account. This will lower your cash bank balance and increase your checking bank account.
Is that a typo? Do you mean categorize bank 'feed'? Or bank fees? If I categorize cash deposits in the banking center to cash bank that still increases the cash bank account. Im sorry could you try to explain that again? I would really really appreciate it!!!
@@crystalramirez5631 Yes it is bank feed. Crystal when you categorize cash deposit in the bank feed as a cash bank what you are saying is that you took money from the cash bank account and deposited into the checking account. So money was taken from the cash bank therefore it lowered the balance and was deposited into the checking account which raises the balance in the checking account.
Great lesson as always. Thanks for sharing such high value info. I would request you cover Shopify and Amazon/QuickBooks topics. Also if you could explain how to understand their sales reports.
Thank you, I will cover those Shopify is next!
@@ClaudiaXperts thanks, and using sales summary function in QB too
Working on QBO for a food truck. In the clearance account you mentioned recording income and expenses for Toast. For example, there are monthly fees associated with using the toast POS system automatically debited from the bank account. Should that be recorded under the clearance account? When recording September sales and adding the bank settlement deposits the clearance account has a balance. You mentioned it should zero out.
Hi Heather if the monthly fees are going through your checking account you just categorize from the bank feed no need to enter in the clearance account. At times clearance may hold funds, therefore, there will be a different till the funds are released.
As Usual, It's useful. Thank You !! 😊
You are very welcome!
what about payments on the sales reports that "other" ?
It could be anything, you will need to ask the business owner what was categorized as other.
Could you show how to record the Toast Fees?
Sure!
Hello, I am confused here. Why do we enter the gross sales when that has the tips collected as well? the actual sales are the gross sales minus the tips which will then give us an actual picture of our daily/monthly revenues. To match it with Toast we should then take the gross sales minus the tips and that is what our revenues should be. can you please clarify?
Hi Dan this information is taken from the Toast reports. Please note that the tips is a liability in the balance sheet. So we credited the liability account to match what in the Toast report. We are not making up those numbers they are coming from Toast. The tips liability is removed when tips are paid to employees. They are never recorded in the Profit and Loss
@@ClaudiaXpertsyes. Like sales taxes
May I know how are you tracking the toast fee in QuickBooks? or are you ignoring the fee and taking only the net revenue from Toast
Not ignoring the fees, recording according to the reports.
But if you do it this way (which I love cause it’s old school and THAT never fails), then, the sales taxes are not automatic and the sales tax tab I’ll have it without a purpose. Right?
If I let, say: commerce sync, do their little invoices AND charge me for the service, then the sales taxes are gonna show on the salex tax tab
The sales tax will go straight to the balance sheet as a short term liability named sales tax payable. When you pay it you categorize as sales tax payable to offset the liability. With commerce sync they may send sales receipts for each batch containing the sales tax. You will need to set up sales tax prior to integrating with QuickBooks.
@@ClaudiaXpertsso should I just ignore the sales tax TAB that qbo has for us there?
Working in Xtrachef & QBO- are there any experts out there with experience mapping COGS & Sales in Xtrachef to QBO? Please help if at all possible, I am willing to pay an expert to help with this. I am new to restaurant accounting and need to get my P&L correct. Please help! :)
We can help
I am specialized in QuickBooks integration we can look at it to see what is going on.