Hi
How to create report like this ?
How are you defining your Gross sales and Net Sales. IS your accounting already setup with all of these fields and is it accurately running with correct transactions and documents?
If you answered yes to most of that and you know how you want to figure gross and net sales then all of the syntax to produce the report is located in the Printer Templates look at Account Transaction Value Tags. Look up the tutorials on custom reports they all explain how to use the syntax.
… also. We are living in different countries, there might be country specific differences between how these terms are used and it will be awesome if you can describe us what these values are and how they are calculates.
1 Like
Gross Sales = total in sales ( Cash + Credit card + Gift Certificate sale + Gift certificate redeem, all payment type total) including sales tax
Void = Refund
Net sales = Gross sales - void
Opening cash = when we start work period and we keep in drawer to start the day (Previous day cash if keep same amount every day, Let say $200)
Gift cert.= gift certificate sales ( since this need to separate as this is just an exchange transaction)
Total Sales = Net sales + Gift certificate sales
Paid out = cash paid out from drawer
Credit card sales = Sales paid by credit card
Gift cert. redeem = sales paid by Gift Cert.
Cash= Total sales -Paid out - Credit Card Sales - Gift Cert. Redeem (This total need to be in drawer)
Actual Cash = employee/manager count cash in drawer and enter in before work period end or we can make it end of the shift forms where they enter this amount
Over/Short = Cash - Actual Cash
Closing Cash = enter at the end of work period ( this can go to next day opening cash )
Deposit in Bank = Actual Cash + Over/short - Closing Cash (Bank or Owner’s Pocket)
we also can include sale tax line just for owner information, if some one wants to know how much they owe to the authorities
one more question about all this…
Where do you store this info:
- Opening cash
- Actual Cash
- Closing Cash
thanks!
G.
all this info will enter by user so need to create action and rules for this. correct me if i am wrong
how it will save in database that i don’t know at this moment but we have to figure out.
ok, so… I would start trying to figure out how to save those values and after that figure out how to do a report…
trying to do a report without that info is not a very good idea…
G.
Can use accounting for that.
2 Likes
yes he sure can. Thats where I get drawn… LOL!!!
G.
I want to see weekly data in one report. accounting give me weekly ?
Accounting will store data… then you can filter that data in any way.
G.
1 Like
Yes it can. The point to consider though (as @Jesse and @gerlandog are eluding to) is that you need to spend some time setting up your Accounting to store as much of the data as possible (Cash, Credit, Float In/Out, etc) then you can design your Report around the Account Balances.
In many cases, if your Accounting system is robust enough, you won’t even need to do many on-the-fly calculations in your Report; your Accounting takes care of it for you, then you just filter it for the period(s) that you want to examine.
1 Like
@QMcKay is right. I apologize I have been visiting and trying to respond as much as possible but The past two weeks have been crazy for me and my family as we just sold our house and are planning our move so you have not and probably will not see as many super detailed responses as I usually give until this all settles down for me.
in Accounts i already set up filter type to week but when i see account screen i can’t see day by day activity so i thought report is only way to see weekly activity day by day on same screen
@allmixedup we are talking about custom reports… but if you setup the accounting correctly its much easier to setup the report…The custom report will pull data from your accounting… it stores the accounting in the database.
The custom report tags for accounting are as follows:
{ACCOUNT TOTAL:X} Account Total
{ACCOUNT DEBIT TOTAL:X} Account Debit Total
{ACCOUNT CREDIT TOTAL:X} Account Credit Total
{ACCOUNT TRANSACTION TOTAL:X} Account Transaction Total
{ACCOUNT TRANSACTION DEBIT TOTAL:X} Account Transaction Debit Total
{ACCOUNT TRANSACTION CREDIT TOTAL:X} Account Transaction Credit Total
{ACCOUNT TRANSACTION DETAILS:X} Account Transaction Details
PS Big Big Big Hint: You can find almost all Custom Report syntax in the Printer Templates on the right…Even stuff that @emre forgets to tell us in the forums sometimes shows up here. @emre has also been so kind that most of it functions the same across the various platforms like Tickets, Orders, etc.
There are more available like fields, expressions etc those can be found in tutorials specifically Custom Reports tutorials and documentation. Formatting can be found in the tutorials as well.
PS you can also use SQL scripting to pull and aggregate data any way you want.
ohh Ok
I just keep looking all over in my setup thinking that i am missing something 