User Tools

Site Tools


faq:reconciliation_of_total_sales_on_the_h.s.t._report

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
faq:reconciliation_of_total_sales_on_the_h.s.t._report [2012/12/03 11:56 (12 years ago)] clifffaq:reconciliation_of_total_sales_on_the_h.s.t._report [2016/01/12 13:27 (8 years ago)] rmarsel
Line 5: Line 5:
 ====== Reconciling the Total Sales Figure on the H.S.T. Report ====== ====== Reconciling the Total Sales Figure on the H.S.T. Report ======
  
-The main idea behind this article is to help spead up the searching process. Instead of breaking down the problem piece by piece until we understand where the discrepencies come from, maybe we can get right to the heart of the matter with some simple checks.+The main idea behind this article is to help speed up the searching process. Instead of breaking down the problem piece by piece until we understand where the discrepencies come from, maybe we can get right to the heart of the matter with some simple checks.
  
 Since the Total Sales figure doesn't mean total taxable sales, the G.S.T. Collected number will not necessarily be 5% of the Total Sales figure. The trouble then is how do we tell what the differences are? I suggest starting with the tax summary report as it can report on some of our non-taxable numbers, and provide some key indicators to help us reconcile the difference. Since the Total Sales figure doesn't mean total taxable sales, the G.S.T. Collected number will not necessarily be 5% of the Total Sales figure. The trouble then is how do we tell what the differences are? I suggest starting with the tax summary report as it can report on some of our non-taxable numbers, and provide some key indicators to help us reconcile the difference.
Line 32: Line 32:
  
  
-==== The Total HST Collected number will be wong ====+==== The Total HST Collected number will be wrong ====
   * If any bills post to the HST Payable account (normally 2080) the HST report will now be wrong.   * If any bills post to the HST Payable account (normally 2080) the HST report will now be wrong.
     * You will notice that the HST collected on this report does not match the HST collected on the Tax Area report.     * You will notice that the HST collected on this report does not match the HST collected on the Tax Area report.
Line 70: Line 70:
     * **For more detail:** The invoice report can be used to get exempt invoices only. That is if you are looking for invoices that are tax 1 exempt.     * **For more detail:** The invoice report can be used to get exempt invoices only. That is if you are looking for invoices that are tax 1 exempt.
       * Just make sure the "(Tax 1) Exempts Invoices Only" check box is checked.       * Just make sure the "(Tax 1) Exempts Invoices Only" check box is checked.
 +
  
  
Line 79: Line 80:
     * Submitted as incident#36685(Dec2012-cm): When checking T Type invoices check to make sure all lines are at cost. Make a note on the warning that this could cause issues with artificially inflated/deflated incomes and can mess up your tax reconciliation reporting as it should not effect the income.     * Submitted as incident#36685(Dec2012-cm): When checking T Type invoices check to make sure all lines are at cost. Make a note on the warning that this could cause issues with artificially inflated/deflated incomes and can mess up your tax reconciliation reporting as it should not effect the income.
  
 +Note: There may be some categories like gift cards that are not posting to 4000 level accounts that we consider on invoice reports to better report revenue. Are gift cards really revenue if they post to a liability?
faq/reconciliation_of_total_sales_on_the_h.s.t._report.txt · Last modified: 2023/10/08 10:57 (7 months ago) by anemenzo