Custom Report End Sales Expenses, Bankings

V5 Question
1

Hi All,

I am trying to implement a custom report for end of month balances of sales , expenses and flag tickets called banked-in.

I’m trying to add two custom elements to the end of this this report.

First element I’m trying to add is the list of expenses incurred , and the second element I’m trying to implement is the total of Tickets that have a flagged called banked.

This is so I can balance the books can anyone assist.

[MONTLY BANKING REPORT :1, 1.2, 1, 1, 1, 1, 1, 1,1,1]

>Day|Ticket Sales|Discount|Round|Tax|Total|Cash|Credit|$Banked Tag|Expenses

{REPORT TICKET DETAILS:T.Date,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum,TT.Banked.sum:(TS.Status=Paid)}

>Total |{REPORT TICKET DETAILS:([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum,TT.Banked.sum:(TS.Status=Paid)}
2

First we can’t really assist you until you give us more information specifically how you are recording expenses. Expenses can be different for each and every person so without knowing how your tracking them we have no way to guide you in how to report them.

Secondly I see your using a ticket tag for Banked. You use expressions at end of the tag to filter by. For example

{REPORT TICKET TOTAL:TT.Banked.sum:(TS.Status=Paid)}

The TT.Banked.Sum will show the Sum of the Ticket Tag: Banked line. (TS.Status=Paid) filters the report to show ONLY tickets with a Ticket State status of Paid.

So if your using Ticket Tag to flag your tickets as banked then you need to use that for the filter. According to documentation for report tags here: https://www.sambapos.com/wiki/doku.php?id=custom_reporting_tags you should use something like TT.<tag name> so your report would look similar to this:

{REPORT TICKET DETAILS:T.Date,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum:(TS.Status=Paid) AND (TT.Banked=Yes)}

That would filter only tickets with a Ticket Tag called Bank with a value of Yes. So obviously you would need a tag called Bank that sets a value of Yes or No with the example I showed. You may set it up differently but hopefully I demonstrated the idea.

1 Like
3

Firstly Thank you for your assistance.

I have implemented the following as per your suggestion, Im really not a coder , however if I use and it does not show in either Paid, or Banked. but if I put OR in it shows in Banked but doesn’t show in Paid as well.

I’m trying to show all paid tickets in Cash , or Credit and Banked in Banked Columns

[Sales:1, 1.2, 1, 1, 1, 1, 1, 1, 1]

Day|Ticket Sales|Discount|Round|Tax|Total|Cash|Credit|Banked

{REPORT TICKET DETAILS:T.Date,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]-[T.TotalAmount]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum:(TS.Status=Paid) OR (TT.Banked=Yes)}

Total |{REPORT TICKET DETAILS:([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]-T.TotalAount).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum:(TS.Status=Paid) OR (TT.Banked=Yes)}

4

The sample I showed assumes you have a Ticket Tag called Banked and it assumes you set that tag to Yes

You probably do not set it to Yes so it will not work unless you do. You have not explained how your using that Ticket Tag so I just made a guess.

5

In Relation to Expenses

I have implemented at Entity for Expenses where I can , Search , Edit , or Enter new Expenses Payment
As per below. If you have a suggested better way would be interested in looking at it. With Expenses I trying to implement a way to record and report on costs or the period and then have a PL statement that shows the total sales, tickets, banked tickets and expenses.

thank you . Again I’m very new at this .the product is brilliant but just trying to find my way.

Pasted image1324×296 5.69 KB

Pasted image1351×142 5.39 KB

6

That is correct

7

So your tag is Bank not Banked so it should be TT.Bank=Yes

8

Not really its all what works best for you. I personally prefer to do a combo of accounting and entities.

9

I would like to do the accounting however I found that I could not expanded the details I required on input
As I couldn’t find away to add Cheque number , Category, Payee

10

I have changed the report and tested it however I flagged the transaction as No and it is now showing in the banked and Cash, when it should be only showing in Cash.

[Sales:1, 1.2, 1, 1, 1, 1, 1, 1, 1]

>Day|Ticket Sales|Discount|Round|Tax|Total|Cash|Credit|Banked

{REPORT TICKET DETAILS:T.Date,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]-[T.TotalAmount]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum:(TS.Status=Paid) OR (TT.Bank=Yes)}

>Total |{REPORT TICKET DETAILS:([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]-T.TotalAount).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum,T.TotalAmount.sum:(TS.Status=Paid) OR (TT.Bank=Yes)}
11

A tip for you when posting Printer Templates or report templates highlight the entire template and press the </> button it formats it so its readable. I went ahead and did it for you.

1 Like
12

Is Cash also a Ticket Tag? PS you should change OR to AND

When you use OR it allows either but what you need is to force it to check BOTH.

Basically putting OR means it will show report for tickets with or without that tag.

13

Thanks
However I don’t understand what to put to-get both, also thanks for the tip re posting report template I will remember that …

14

Cash is not a tag it is a payment type

15

Ok so thats your conflict there. Your using Two different systems and trying to filter by it. You need to decide on a single method to flag the tickets and filter by that one method it will simplify it. But Let me show you something to try in meantime.

16

Lets clarify something though, you have three columns one for Cash, Credit Card, and Banked. Can you clarify exactly what your expecting to see with reports? I may be confused on what your asking.

17

What I’m trying to see is

Total Sales for Period
Total Cash for Period
Total Creidt for Period
Total that Have been flagged to be banked. eg.

1 ticket was paid by Cash for 100
1 ticket was paid by Credit for 100
1 ticket was paid by Cash for 100 and Banked

18

Ok that is actually much easier. I thought you wanted it filtered by Banked. Give me moment.

19

Hi ,

have you been able to have a look at the following as yet.