To post a new support question, click the Post New Topic button below.
Current Version: 4.8.5 | Sytist Manual | Common Issues | Feature Requests
Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.
Report Math Help
Michael Leenheer
490 posts
Sun Jul 08, 18 10:30 AM CST
Hi Tim, can you please help me understand what's happening with the numbers displayed on the reports page? I am doing calculations and none of the numbers seem to add up.
For example, the GST (tax) is calculated on $5,706.81, but that total amount is not equal to the 'total sales' plus the 'shipping' and I don't know why the 'total sales' has smaller numbers under indicating it's a total of $5,060.80 - $34.08 ... what are those numbers? They don't match anything else I can find.
Please help - my immediate need is to calculate my gross sales for the month, and I'm not sure if that's the $6,780.91 or ...?? That largest number is NOT equal to the sales plus the shipping plus the tax, so I'm lost on the math here.
Thanks...
(PS: In a more general sense (and others please feel free to chime in here) I'd really really appreciate some extra development time on sales reporting so we can get more detailed breakdowns of what is being sold, how often early bird discounts are used, reports that show sales per gallery, that type of thing. )
For example, the GST (tax) is calculated on $5,706.81, but that total amount is not equal to the 'total sales' plus the 'shipping' and I don't know why the 'total sales' has smaller numbers under indicating it's a total of $5,060.80 - $34.08 ... what are those numbers? They don't match anything else I can find.
Please help - my immediate need is to calculate my gross sales for the month, and I'm not sure if that's the $6,780.91 or ...?? That largest number is NOT equal to the sales plus the shipping plus the tax, so I'm lost on the math here.
Thanks...
(PS: In a more general sense (and others please feel free to chime in here) I'd really really appreciate some extra development time on sales reporting so we can get more detailed breakdowns of what is being sold, how often early bird discounts are used, reports that show sales per gallery, that type of thing. )
Attached Photos
Michael Leenheer || My Sytist: https://subphoto.ca/client_galleries/demo01/
Tim - PicturesPro.com
16,148 posts
(admin)
Sun Jul 08, 18 12:25 PM CST
The $6,780.91 total is the total for the year ... 2018.
$5,060.80 is total sales for June ... "-$34.08" is from a trashed order (probably a canceled and refunded order).
The $5,.029.72 total is the total sales for June minus trashed orders including credits used shipping and taxes.
$5,060.80 is total sales for June ... "-$34.08" is from a trashed order (probably a canceled and refunded order).
The $5,.029.72 total is the total sales for June minus trashed orders including credits used shipping and taxes.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
Michael Leenheer
490 posts
Thu Jul 12, 18 4:00 PM CST
Thanks for the explanation, but I still can't make the math work out.
Sales - $5,026.72
Shipping - 524.68
GST - 285.37
SubTotal - $5,836.77
Less Credit Used (1165.34)
---
Total: $4,671.43
To wrinkle my brain further, tax was calculated on $5,706.81 -- which is higher than any amount I can add up from these numbers including shipping.
Will you please make a report we can view with the parts labelled clearly? Itemized in a list would be great but even a summary that shows the math would be wonderful. I'm genuinely confused.
(I do have 2 'trash' orders with June dates, these don't show up anywhere in these totals though do they? They are for $13.09 and $20.99 which aren't big enough to account for the discrepancies in the math anyway.)
Sales - $5,026.72
Shipping - 524.68
GST - 285.37
SubTotal - $5,836.77
Less Credit Used (1165.34)
---
Total: $4,671.43
To wrinkle my brain further, tax was calculated on $5,706.81 -- which is higher than any amount I can add up from these numbers including shipping.
Will you please make a report we can view with the parts labelled clearly? Itemized in a list would be great but even a summary that shows the math would be wonderful. I'm genuinely confused.
(I do have 2 'trash' orders with June dates, these don't show up anywhere in these totals though do they? They are for $13.09 and $20.99 which aren't big enough to account for the discrepancies in the math anyway.)
Michael Leenheer || My Sytist: https://subphoto.ca/client_galleries/demo01/
Tim - PicturesPro.com
16,148 posts
(admin)
Fri Jul 13, 18 12:17 PM CST
I miss-wrote about the total including credits. The $5,.026.72 is total payments and does not include account credits. The taxable total would be the taxable amount before account credits are taken off. So that would make the taxable amount closer to the $5706.81. And maybe you have some stuff that wasn't taxable.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
Michael Leenheer
490 posts
Fri Jul 13, 18 2:59 PM CST
I definitely should not have anything that's not taxed; if I do I really need to know since the government is collecting from me for it!
You didn't reply to the idea of improving the report with labels and more details; is that difficult / unlikely / not on your development list? I can't be the only one who'd really appreciate more info for the book keepers.
You didn't reply to the idea of improving the report with labels and more details; is that difficult / unlikely / not on your development list? I can't be the only one who'd really appreciate more info for the book keepers.
Michael Leenheer || My Sytist: https://subphoto.ca/client_galleries/demo01/
Tim - PicturesPro.com
16,148 posts
(admin)
Mon Jul 16, 18 3:43 AM CST
I made note of your request for more reporting. I didn't think I really needed to reply to that.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
Please log in or Create an account to post or reply to topics.
Loading more pages