110
 
New Member

How do I enter daily sales for my cafe?

11/2/09 7:28 AM
Total Views: 83

How do I enter daily sales for my cafe? I want to track both the am and pm sales. Thank you

 
 
Subscribe RSS
 
 
All Replies:  Answers (2)   Comments (2)
Advanced Certified ProAdvisor
 
Rating 0

Answer

11/2/09 5:16 PM

Create 2 customer names - Daily Sales AM and Daily Sales PM

Your setup and procedures will depend on how much detail you want to track, and your reporting needs.

Here is my streamlined approach to using QuickBooks for restaurant/food establishments:

I start with a simple chart of accounts and edit/add detail when needed.

_Post your Daily Sales using the figures from your register reports and cc settlement reports. (see below)

_Post your purchases to Cost of Goods Sold.

_Periodically (annually, quarterly, or monthly), do an inventory adjustment to reflect current value on hand.

For a restaurant/food service business, I do not suggest that you track individual items or costs in QuickBooks. It would be extremely cumbersome.

This method is streamlined and will give you good tracking for your business - with numbers that your accountant will be able to use for taxes. . . and a good overview of your business activity for evaluating and setting future goals.

Periodically, you will need to do some calculations to help you with pricing, but, for the most part, your bookkeeping should be simple enough that you can move on to the business at hand, which is serving your customers!!


___________Daily Sales Procedure: _______________

 

If you can get good end-of-day reports from your register/POS system, I would suggest creating a Daily Sales Summary to post the totals from your z-out tape.


Use one item for total sales (or multiple, if you want the detail in QuickBooks) - use Sales Income as the account.

Create Other charge type items for the various sales tax collected (pointing all to a liability account called Sales tax payable). Make sure that your file preferences say that you 'don't collect sales tax' because you won't use the internal sales tax platform that QuickBooks provides.

Also, create payment type items for the totals on your settlement summary report from your credit card machine, pointing them to where they go in 'real life'.

This is just a general overview. You will need to develop a system that works best for you.  You might need to create a clearing account for the credit card payments, if you only settle once per day.

 

I hope this helps,

Laura D

When in doubt, make a backup first!!

*****

Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com


http://proadvisor.intuit.com/r...
 
 
 
Contributor

Comment 

11/8/09 2:42 PM

Laura D - what's the advantage to turning off sales tax tracking and entering the taxes as line items?

 

 
 
Advanced Certified ProAdvisor
 
Rating 0

Answer

11/8/09 3:07 PM

You can setup the sales tax using the QuickBooks platform, or using the calculations from the register.

Since most registers are calculating the sales tax based on pre-set taxable/non-taxable sales keys (items), I don't see a need to repeat the process (only to have to make adjustments) in QuickBooks.

If you use the QuickBooks platform, you can get sales tax liability reports, but will, most likely, need to adjust the sales tax that QuickBooks figures against the end of day z-report.

That said, it isn't 'wrong' or 'bad' to choose either method.  Think through the advantages and disadvantages of each and setup your procedures accordingly.

Laura D

When in doubt, make a backup first!!

*****

Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com


http://proadvisor.intuit.com/r...
 
 
 
Contributor

Comment 

11/9/09 1:50 AM

LauraD, I see, thanks, that's clear.

 
 
 
 
Subscribe RSS
© 2009 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.