Reports - Differences in totals
Table of Contents
Note: This document has been imported from the former KB and has not yet been verified.
You may notice when you use the different reports like daily sales, tax reports, sales summary, you get different totals. Here is a little background on what makes those reports.
Tax Report
For when it's time to pay your tax agency, we think most people want the "Tax Report"
That report gets all the paid invoices where the money was received in that month.
Formula:
Invoices where Date Paid is inside X month, showing subtotals and tax
This means, if you take partial payments - they won't show in this figure. You can't really pay your tax agency for partial sales tax, because an invoice could be partially taxable, and you lose pennies when you split tax amounts into parts - to pay tax, you probably want "Cash Basis" - "Paid Invoices".
Daily Payments
Maybe you want to know exactly how much money you received for a day, to help you tie to deposits in the bank. This report is great for that - it's driven from the Payment based on the Payment Date. This report doesn't care about the Invoice at all, in fact, you can go to a customer and just start taking payments and they will show here - without ever having a single Invoice created. These figures look like this;
Formula:
Successful Payments grouped by Day, showing payment amount
Printing: The Print All function in the Daily Payments Report is printed as a Receipt. Please make sure Receipt printing is enabled in either Google Cloud Print or Autoprintr.
Daily Invoices
Similar to Daily Payments, but driven from the Invoice date field. This report will show invoiced money, regardless of if it's paid or not.
Formula:
Invoices grouped by Invoice Date
Daily Sales (Old)
This report shows invoices in that date range.
Formula:
Invoices (paid or unpaid) by Invoice Date, in that date range
Product Sales Report
This lets you see the sales of your inventory items. It does not include parts. Invoices can be paid or unpaid.
Formula:
Inventory line items in the date range, with math and grouping on the associated products.
Sales Detail (Line Items)
This is all the line items for the invoices you created in a date range, this lets you see what products and services you are selling in a table format.
Formula:
Line Items for paid invoices using the date the invoice was marked as paid
Sales Summary (Profit and Loss)
Since we aren't an accounting system, we are calling the Profit and Loss "Sales Summary" going forward. It uses a date range and shows paid Invoices again, but gives you the total, cost, tax, and net (subtotal-cost). Since the Tax Report uses subtotal instead of total, so you don't pay tax on the tax, these figures will be off by that much.
Formula:
Invoices where Date Paid is inside X month, showing total, cost, tax, and net (subtotal-cost)
Employee Sales and Commission
This is based on the tech assignment on line items on invoices. It is not based on which tech the associated ticket is assigned to.
Formula:
Line items for invoices in the date range where there is a tech attached. (Ignores line items with no tech assignment)
Advanced
If you want to see how these figures are built, just go to the Reports and get your Invoice Dump to CSV, and sort by Date Received (paid date) - then you can grab a chunk for a date range and do your own sum on the columns as you like.