Entering Restaurant Register Sales

SOLVED

Hi, I’ve recently started setting up Sage 50 for a small take out restaurant. I’m new to accounting with Sage and also for a restaurant. I’ve used quickbooks some for a different type of company where it was invoice only and we didn’t really deal with different accounts. 

I’m having a hard timing figuring out how to put the daily register sales in. I’ve read a little about using the ledger but I’m very unfamiliar with this. I’ve also read about using a sales invoice for each day (which is how it would be done in quickbooks I believe). I think I would prefer the sales invoice method but I’m unsure how to go about it. 

Also like to know if I have to show the different payment type totals or if it can just be all cash? We aren’t connecting the program to the bank or tracking deposits with it. It’s only being used for payroll and to keep track of expenses and sales. I’ve read about people using a cash clearing account and what not but I’m not sure why I would have to if we aren’t prossessing the deposit slips through sage. 

I’d really appreciate any advice you could give!

thank you 

  • 0
    SUGGESTED

    Hi Brandy, 

    If the cash register is not linked to Sage 50 I would use a memorized template for daily sales.  It does not sound like you have a strong accounting background so I would suggest contacting your accountant and have them create one for you.  

    You could use the invoice like you would in Quickbooks, but you would have to post the transactions to General Ledger accounts as well. 

    Accounting is accounting.  Quickbooks was posting to specific buckets also.  They may not have had numbers, but they could have had General Ledger Account numbers if they were turned on. To be honest, the only difference between Sage and QB is that Sage asks you where you want to post and with Quickbooks you just post and you pay you pay your accountant at the end of the year to clean up the mess. 

    If you don't have an accountant and need some help setting up a entry, I would be more than happy to help you but there would be a fee for my service.   I would need your daily sales activity to create your template. 

    Kind regards,

    Shirley Byard, Owner Best Business Strategies, [email protected]   304-233-2612

  • +1
    verified answer

    Brandy,

    Welcome to Sage!

    You don't specify if you have more than one sale account so I am going to assume you have more than one sale account. Since you will not be tracking deposits or bank activity for deposits, the easiest way to enter the data would be a general journal entry. For all sales you would debit the cash account and credit the various type of sales accounts for each day.  For example, to record $1200.00 of sales made today the reference may be Sales-62818 - Debit cash (or cash clearing) 1200.00 and credit 1000.00 food sales and 200.00 to beverage sales, the description would be "to record daily sales".  Once you save the general ledger transaction you can open it back up and copy it for future sales. This makes it really easy to enter the next days sales without having to retype each line, just choose "list", find the one you want, right click on the line and choose copy. Then all you have to do is change the reference for the correct date and the amounts. Once you get to the amounts you can use the arrow down key to get to them quickly.

    You can also create a memorized transaction. Once you save the memorized transaction, you can then open it and "use" it, which creates the general ledger journal entry for you.  Either way is ok.

    Note: If you decide to start tracking deposits to the bank you will need to add another general ledger journal entry for the daily deposits and debit cash and credit cash clearing account for the deposited amount.

    Hope that clears up some of the muddy waters. 

    Best Regards,

    Accounting Conversions

    800-303-7770

  • 0 in reply to KimClement

    Hi, Thank you so much that was very helpful!

    I had one more question. I have setup my recurring entry. Each time I enter a new one it prompts me that the tax codes/amounts have changed and I need to verify them. Then it opens a new window (SalesTax). The tax amount and code are right, but the "Amount Subject to Tax" always shows the original amount from the first one I setup to recur. Is that something I need to manually change or can it just be ignored?

  • 0 in reply to Brandy1984

    If you are keeping track of Sales Tax then you will need to make sure the sales tax is recorded properly.  Otherwise,set up an Exempt Sales Tax code under Maintain Sales Taxes.  Then open the recurring entry and change the sales tax code to "Exempt" and save it. If that doesn't resolve it, go to maintain customers, choose the correct customer ID, and under the general tab change the sales tax to "Exempt" and resave that customer ID.

  • 0 in reply to KimClement

    Thank you! I will try that and see how it works.