If you have a support question or comment, click the Post New Topic link below. Sytist Manual | Sytist Articles | Facebook Page.

Report Math Help

 
Please log in or Create an account to post or reply to topics.
 
Michael Leenheer
274 posts
Sun Jul 08, 18
10:30 AM
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 | New Light Photography - SUB Photo
Tim - PicturesPro.com
9886 posts
admin
Sun Jul 08, 18
12:25 PM
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
Michael Leenheer
274 posts
Thu Jul 12, 18
4:00 PM
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 | New Light Photography - SUB Photo
Tim - PicturesPro.com
9886 posts
admin
Fri Jul 13, 18
12:17 PM
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
Michael Leenheer
274 posts
Fri Jul 13, 18
2:59 PM
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 | New Light Photography - SUB Photo
Tim - PicturesPro.com
9886 posts
admin
Mon Jul 16, 18
3:43 AM
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
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 - 2017 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