Template of a Sales Receipt or General Journal for entering daily sales at a restaurant.

Thanks for dropping by the QuickBooks Community, Angel11-72.

I'm happy to help point you in the right direction about creating a sales receipt template for your daily sales.

QuickBooks Desktop allows you to manage, download, and customize templates for your sales forms. However, we are not able to modify the template according to the order of items you mentioned above.

For this reason, I suggest using a third-party application. You can explore more options from our Intuit Marketplace. This is a one-stop shop where you'll find apps that integrate with QuickBooks Desktop.

To narrow down your search, browse the application per category or just enter a keyword in the search field.

If you have additional questions about handling transactions in QuickBooks, post a comment below. I’ll get back to assist you further. Wishing you continued success.

Ok, I'm not sure if I explained it right.  So I'm going to attach a report from the pos system that I have to work from.  If someone could show me how to set this up so I can include all of the discounts that would be great.  If not could you just show me how to enter this all.  Basically I need help building a template.  

Do a Web search for:

     QuickBooks enter "daily sales summary"

Here's one example of the search hits you'll get:

https://longforsuccess.com/daily-sales-summary-for-retailers-restaurants-ecommerce-and-more/

Hi there, Angel11-72.

I'd be happy to help you set this up and enter all of these details on the sales receipt.

I appreciate the screenshot. Based on this, we could set up everything you mentioned on your original post, including the discount, items. Doing that will allow you to add all of them on the sales receipt.

However, for the sales tax, we'll need to activate this in the Preferences window first before setting it up. The following steps below will guide you through the entire process from setting these items to creating the sales receipt:

receipt:

To activate the sales tax item

1. From the Edit menu, choose Preferences.
2. In the Preferences window, select Sales Tax in the left navigation menu.
3. Go to the Company Preferences tab.
4. Select Yes.
5. Click Add sales tax item.
6. In the New Item window, enter the following information:
   - Sales Tax Name: Enter the appropriate name for this sales tax.
   - Tax Rate (%): Enter the correct tax rate.
   - Tax Agency: Choose the appropriate option from the drop-down menu.
7. Click OK twice.

To set up sales items

1. From the Lists menu, choose Item List.
2. Click the Item drop-down button at the bottom left corner of the screen, then select New. You can also press Ctrl + N.
3. From the Type drop-down menu, choose the appropriate option.
4. Name the account accordingly.
5. From the Account drop-down menu, select the appropriate account.
6. Click OK and repeat these steps for the other items, such as the Sales, Liquor, Wine, Cooler Sales, Other Sales, and the Discount.

To create the sales receipt

1. From the Customers menu, choose Enter Sales Receipts.
2. Select the correct customer from the Customer:Job drop-down menu.
3. Enter all the items that needs to be in these transaction,
4. From the Tax drop-down menu, choose the correct Sales Tax item.
5. Click Save & Close.

I'm also including these helpful articles for your reference and for additional insight:

• Set up sales tax in QuickBooks Desktop
• Add, edit, and delete items
• Create sales receipts

I know you've got this, but please keep in touch if you need more help with this. I want to make sure you're taken care of. Have a great day!

@AldrinS

Please Learn from this input. You do Not want to enable Sales Taxes per your guidance here: "However, for the sales tax, we'll need to activate this in the Preferences window first before setting it up."

The QB user already has a system that is handling Sales Taxes. Two Systems never compute the same.

@Angel11-72

The Article provided by @FTech Explains how to handle everything from your Z-out tape, including Sales Taxes. You want to enter the amounts that you already have been given from the Source report. You don't want two computer systems debating which Sales tax is the right amount. For a Separate POS, sales tax in QB is treated as a manual Liability account activity. Not as Sales Tax Funcitonality.

@AldrinS  

Here is the daily sales report which is exactly like the z report but in different orders.  When I enter the discount that are in the lower middle section it makes the Daily Sales reports off.

Hello there, @Angel11-72.

Allow me to chime in and share some more insights about customizing your transaction templates.

You can customize your printed documents, labels, packing slips, and tags using the Print Designer:

1. Click the File menu.
2. Select Tools.
3. Choose Print Designer.
4. Choose a document type, then look for an available template that best fit your document preference.
5. Select Modify and click the section you’re working on to activate.
6. Choose Properties to apply Template Properties changes.
7. Click Add to include additional Data Field, Text label, Store Logo or Graphic Line.
8. Select Preview to see how your changes appear.
9. Once you're done, select Save.

That should help you change the format of your transaction, Angel11-72. For additional help, you may also reach out to our phone support. Our contact details can be found here along with our opening hours:

1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
2. Choose your QuickBooks Product.
3. Select your QuickBooks version.
4. On the Contact Us page, click a topic.
5. Click on the Get Phone Number button to see the support number.

Let me know if you have follow up concerns. I'd be happy to provide answers and help. Have a wonderful day!

I give up.  I know how to design the sales receipt, I'm ok with the taxes, I know how to make a template.  I just need to know how to include all the discounts so it does not throw off my sales report.  Or do I do a journal entry with all of the Discounts, Food Comp, wine/beer comp, etc)

I want it to match the sales report that come out of the POS system. 

Hello Angel,

Before you can add the discount on the sales receipt, you'll need to create first a discount item:

1. Select Lists at the top menu and click Item List.
2. Click the Item button and select New.
3. Choose the item type and enter the item details. I'd recommend reaching out to your accountant on how to set up the item.
4. Click OK.

Then, go back to the sales receipt and add the item.

As always, I'd recommend asking your accountant whether you'll need to create the discount item or journal entry. They know what's best for your books.

Let me know if you have other concerns.

Ok, last try. Where do I enter these?  In the sales receipt or just an entry ? I added just the part I need help with.

Hi there, @Angel11-72.

I'm here to help share additional information about discounts in QuickBooks Desktop (QBDT).

Have you tried following the steps provided by my colleague JamesDuanT? As mentioned, you can create a discount item and add the discount item created on the sales receipt.

However, you can always consult a professional accountant for the best way to record the transactions.

You can also get in touch with our QuickBooks Support Team if you need further assistance. For the support contact information:

1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
2. Choose your QuickBooks Product.
3. Select your QuickBooks version.
4. On the Contact Us page, click a topic.
5. Click on the Get Phone Number button to see the support number.

Stay in touch if you have any other QuickBooks concerns, I'm always here to help. Have a wonderful day!

@HoneyLynn_G

Please Learn from this input; desktop doesn't have Print Designer and this is not an issue of Design.

There is Nothing about a Template in this discussion. It is the Use of the sales receipt to enter all data per where it needs to flow.

@JamesDuanT

@Angelyn_T

It really would help if the Intuit people would also Learn from that article that was linked by FTech; that is the Best Article for doing this with QB Desktop.

There is No Use for a Discount Item Type; that item Type needs to compute on items above it, in QB. This person has the Source Info already. They simply enter Positives and Negatives. Example:

Sales of Food positive

Sales of Food Negative <== for Comps or No Pay customer amounts

Both Service Items link to the same Income account

@Angel11-72

You can set up as many similar items as you want, so that the entry of the Z Out turns into a routine clerical task. Example
Sales of Food positive

Comped food "enter as negative" <== Name it and Prompt your clerk

And now you link Sales to one Sales account and "Comps" to a different Income account used only for negative (contra-accounting).

Just take it Line by Line. Basic Example:

Service Item for Sales <== links to Income, enter Positive, as Gross sales)

Or, break it out by Food and Bev Non-alcoholic and Alcohol. You set up what meets your needs, to match the Z out and for any required reporting.

Service item(s) or Other Charge Type Items for Sales reduction, such as Comp, and emp meals, as various negatives posting to income account(s).

Other activities, such as Tips Liability

Sales tax Other Charge Item as Liability

Right here, you typically includes the Over/Short item for adjusting if Funds doesn't match Sales + tips, which is linked to Income or Expense. You are not adjusting the Funds. You are adjusting Sales.

Then, you will have Payment Methods which will be Payment Items as Negatives: cash, Checks, Credit Card Charges. These are needed to be able to match Settlement of the funds, flowing to Bank in QB, to Undeposited Funds, etc.

It ends at 0, because everything is supposed to have been accounted for.

And make one with .01 in every field, positive and negative and Memorize it. Now, for each date you get the Z out, you open the Memorized Transactions list, you Double-Click that Daily Sales Summary, fill it in for that date and Save it; It's a Worksheet.

@Angelyn_T      I LOVE YOU!  Thank you so much.  So just because it says total discounts it really isn't, it's a contra account.  I already did January.  Actually I'm almost done with it.  So could I go back and do journal entries for the month.  (after I set the accounts as income)

juVielL    I'm so proud of myself.  I got it to work.  Yeah!!!  With the help you guys and gals.  I already entered last months the way I ususally do, without the discounts.  But I'll do a journal entry for just January.  Then I'll use my new sales receipt template.  Thanks everyone.

-Angela

@Angel11-72

If you want to use JE, instead, then you Won't Use the Daily Sales Summary. You just stated this: "So could I go back and do journal entries for the month.  (after I set the accounts as income)"

Don't do Both.

That Blog explains why to avoid JE for all of this, and why Sales Receipt as a worksheet, is a better method.

Delighted to hear everything works on your end, @Angel11-72.

Managing a business is busy enough. Our goal is to make it faster and easier for small business owners to track their transactions, so we’re happy that our software is doing that for you.

By the way, if there are any accounting and bookkeeping features you haven’t tried yet, these articles will come in handy: QuickBooks Community Help Articles.

This will get you on the right track managing your transactions. Have a great day ahead!

No, I'm not doing both.  I'm just saying next month I will start using my new template.  But last month I have already entered them in using my older template.  I'm not going back and redoing 31 days worth again.  That's why I wanted to enter a GJ entry for January.

Here is one example on how to set up template for "Daily Sales Summary" in QuickBooks Online (QBO):

Recording Daily Sales – Restaurants, Retail Stores, POS Cash Register, Sales Template

Hope this helps!

can someone help me setting up a template of a daily sales of sales receipt of general journal for the restaurant daily journals?

I can help you set up a template so you can start recording your total daily sales, @Escalongoria.

Thanks for reaching out to the Community for assistance. I’m here to provide you a step-by-step guide to help you get started.

If you've already created or set up a customer, accounts, and items for daily sales, then you can follow these instructions to create a template in QuickBooks Online.

1. Select the Gear icon, then choose Recurring transactions.
   
2. Hit New at the top right.
3. From the Transaction Type drop-down, choose Sales Receipt.
   
4. Press OK.
5. Name your template "Daily Sales" and make sure the Type is Unscheduled.
6. Select the Customer name.
7. Select these items:
   • Daily Sales: Daily Sales Income
   • Daily Sales: Cash
   • Daily Sales: Check
   • Daily Sales: Visa/Mastercard
   • Daily Sales: American Express
   • Daily Sales: Overage/Underage
   • Daily Sales: Discover
8. Click Save template.

Once done, you’re now ready to record your end of day sales in QuickBooks. However, if you’re currently using QuickBooks Desktop, you can follow the recommended instructions above.

You can use this article for a detailed guide and additional information about recording total daily sales in QuickBooks. I also have a video tutorial in case you need a visual reference.

If you have other QuickBooks concerns, please let us know. We’ll always here to lend a hand. Keep safe.