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

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. )
Attached Photos

Michael Leenheer   || My Sytist: https://subphoto.ca/client_galleries/demo01/
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.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
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.)
Michael Leenheer   || My Sytist: https://subphoto.ca/client_galleries/demo01/
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
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.
Michael Leenheer   || My Sytist: https://subphoto.ca/client_galleries/demo01/
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
6 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 830 times
Category: Reports
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close