Fixing end of day reports

Hopefully someone familiar with Sage can help me understand or fix a problem. 

I do daily sales reports and the way i am supposed to do my end of day report is under reports, transaction details and then sales. when i open the end of day sales, any products i sold the cost of it shows up as a positive instead of a negative. but if i go under reports, inventory and sales and then sales, it shows everything properly and shows what i collected in taxes as well which i need. is there a way i can edit it though so at the bottom of the page it gives me a total of all sales collected but not show the cost of goods as a positive? 

Hopefully someone understands what i am talking about and can help me as i should not have to add everything together or have to subtract amounts to figure out my total sales and how much money i collected when i pay alot of money for a program to tell me those amounts. i attached pictures of an end of day so people understand the layout of what i am seeing. i tried different layouts in the first picture and nonce of them give me an all together end of day total.

  • 0

    I'm not 100% sure I understand what you are looking for and what your issues are with the reports you are showing.  However, if your goal is to find out what your total sales are for the day, then the Income Statement run for just one day is the report you would want.

    I agree the Customer Sales report is lacking a grand total but it's purpose is to show customer sales not daily or total sales based on the way it was designed.

    The numbers you circled in the Sales Journal Entries report do not show the sales figures, only the costs and amount received/to be received.

    To determine how much money you collected (assuming you are balancing a cash drawer) you would run the General Ledger Report (Transactions by Account I think using non-accounting terms) for the accounts you receive money into during a day.  This would include your Petty Cash account, bank accounts, credit card receivable accounts, etc.

  • 0 in reply to Richard S. Ridings

    the problem once again with doing income statement is it does not show my hst/gst collected on sales. i need it to show this amount as well. what i need is an end of day that just shows the money collected along with the hst/gst collected on sales. sorry this is more of what i was trying to get too. unfortunately it is hard to use a POS system as i would still have to use a program like sage for keeping track of expenses and where i run an automotive shop i needed a program where i can give a receipt with full detail of the product i sell because of manufacturer rebates people can send away for on products i sell.

  • 0 in reply to alex ernst

    I am afraid I still don't understand if you are using Sage 50 as a POS or you have another POS system but it sounds like you are recording sales directly in Sage 50.

    Can't you just extend the idea I gave you about running the General Ledger report for the money collected accounts and add in the HST Collected account?

    but if i go under reports, inventory and sales and then sales, it shows everything properly and shows what i collected in taxes as well which i need

    I don't see taxes on this report.

    is there a way i can edit it though so at the bottom of the page it gives me a total of all sales collected but not show the cost of goods as a positive? 

    Yes, dump the Customer Sales report to Excel and do some quick math.  If you use the Subtotal formula in Excel, it's just one formula needed and just reference the top of the column and bottom in the formula.

    BTW

    the problem once again with doing income statement

    I don't see where you mention the income statement is a problem, sorry.

    my end of day report is under reports, transaction details and then sales. when i open the end of day sales, any products i sold the cost of it shows up as a positive instead of a negative.

    This report by definition never shows negatives.  It only shows debits and credits which do increase and decrease the balance of accounts but you have to know the bookkeeping concepts to know which one is which.  The Customer sales report and the Inventory Sales reports show the profit of the sales based on the specific perspective.

  • 0 in reply to Richard S. Ridings

    yes i use sage as a POS as there are no POS systems that offer what i need unless i have one made for me. If i pay all this money for an Accounting Program i should not have to run around looking for all of my amounts. I would like something simple that gives me all of my totals for my daily sales in one form and has my total taxes collected on it as well.