User Tools

Site Tools


integrity:report_discrepancies

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
integrity:report_discrepancies [2020/03/12 09:05]
kevin
integrity:report_discrepancies [2020/03/27 15:55] (current)
kevin
Line 3: Line 3:
  
 ==== Check Invoice Types in Report==== ==== Check Invoice Types in Report====
-Financial reports will include completed invoices types.  ​This would be "​C"​ash"​L"​ookup Cash and "​A"/​R Invoices ​as they post to the General Ledger. ​ Unless there is an option to otherwise include, they would not typically ​include incomplete types such as "​W"​ork Orders ​or La"​Y"​aways or "​E"​stimates. ​ If you are comparing a report that includes incompleted types against ​one that excludes, this can explain the discrepancy. +Financial reports will include completed invoices types.  ​You configure these Main types in the "​Invoice Setup"​. ​ These invoice types post to the general ledger: 
-  * Best Practice:   ​Review what types of invoices ​are being included ​in the report.+  * "​C"​ash 
 +  * "​L"​ookup Cash  
 +  * "​A"/​R Invoices 
 +  * "​B"​ - A/R with Back Orders  
 +  * "​T"​ransfer 
 +  * "​S"​ervice 
 +  * "​F"​inance 
 +  * "​O"​ut on RMA 
 +  * "​U"​ In on RMA 
 +  * "​P"​aid Out 
 +  * "​V"​isa ​ (Legacy) 
 +  * "​M"​astercard (Legacy) 
 +  * "​I"​nterest (Legacy) 
 +Many sales reports have an option to include incomplete types such as "​W"​ork OrdersLa"​Y"​aways or "​E"​stimates. ​ If you are comparing a report that includes incompleted types against ​financial reports ​that exclude, this can explain the discrepancy. ​ You can also forget to include completed invoice types which can explain a discrepancy. 
 +  * Best Practice: ​ Review what types of invoice types you are including ​in a report if you intend to compare against a financial report. 
 +  * Example: ​ Comparing ​the Financial Income and Expense ​report ​which only includes completed invoice types against the Main Category Sales Report that has options to include incompleted types.
  
 +==== Check Date Ranges ====
 +If you are running a financial report it will be run for an entire book month. ​ When running many non-financial reports these are run by date range instead of a book month. ​ Ensure you are not running for an incomplete date range and that all integrity has been checked before doing a comparison.
 +  * Best Practice: ​  ​Review dates and book months you are comparing against a report. ​ Use the date selection tool when selecting a date by double-clicking. ​ It will show you a calendar helping avoid missing the end of the month.
 +  * Example: ​ A leap year has a 29th day in February. ​ Comparing a financial book month for February against a report run on a leap year reporting on Feb 1 - Feb 28th will not include the 29th day.  Leap years only come around every 4 years so this can be easily missed.
  
 ==== Changing an Inventory Category ==== ==== Changing an Inventory Category ====
-With supervisor privileges, a user with rights can change the category that an inventory item resides in.   This will change where sales history will land in inventory reports but NOT change the income and cost of goods ledgers where past invoices have been posted to.  Looking back on reports that look at these areas will have different results after such a change. ​ Many times this change is made as it is the right thing for the sales team to keep inventory sales history with an item but forget to tell the financial stakeholders which run reports against these areas. +With supervisor privileges, a user with rights can change the category that an inventory item resides in.   This will change where sales history will land in inventory reports but NOT change the income and cost of goods ledgers where past invoices have been posted to.  Looking back on reports that look at these areas will have different results after such a change. ​ Many times this change is made as it is the right thing for the sales team to keep inventory sales history with an item but forget to tell the financial stakeholders which run reports against these areas. 
-  * Best Practice:   ​Restrict who has supervisor privileges.+  * Best Practice: ​  ​Restrict who has supervisor privileges.
  
  
 ==== GL coded entry on Invoice ==== ==== GL coded entry on Invoice ====
 Using the feature to place a general ledger code directly onto an invoice makes accounting easy but has a sales report consequence. ​ This value will be included in invoice sales reports but will not match the revenue for inventory sold detail reports as a GL code is not an inventory item. Using the feature to place a general ledger code directly onto an invoice makes accounting easy but has a sales report consequence. ​ This value will be included in invoice sales reports but will not match the revenue for inventory sold detail reports as a GL code is not an inventory item.
-  * Best Practice Solution:  Create a CATEGORY and INVENTORY item to sell and use that on an invoice instead. ​ You can then use a journal entry to direct the income sold from the inventory item, into the correct general ledger for accounting.+  * Best Practice Solution: ​ Create a CATEGORY and INVENTORY item to sell and use that on an invoice instead. ​ You can then use a journal entry to direct the income sold from the inventory item, into the correct general ledger for accounting.
  
 ==== Integrity ==== ==== Integrity ====
-If you are not running integrity report this can have a ledger, invoice reports and detail reports not matching as it depends on the view of the data that a report totals against.  If the integrity error is the invoice total does not match the detail.  This can be why a summary report does not match the detail reporting. +If you are not running integrity report this can have a ledger, invoice reports and detail reports not matching as it depends on the view of the data that a report totals against. ​ If the integrity error is the invoice total does not match the detail. ​ This can be why a summary report does not match the detail reporting. 
-  * Best Practice:  Make a habit to run integrity reports ​on a regular basis.+  * Best Practice: ​ Make a habit to run integrity reports ​regularly.
  
 ==== Changing Category Ledger Codes ==== ==== Changing Category Ledger Codes ====
 With category security, an administrator can make changes to the category income and cost of goods sold ledger codes for a category. ​ This would impact the "Main Category Income and Expense"​ and "Main Category Profitability"​ ledger reports. With category security, an administrator can make changes to the category income and cost of goods sold ledger codes for a category. ​ This would impact the "Main Category Income and Expense"​ and "Main Category Profitability"​ ledger reports.
-  * Best Practice:  Restrict who has privileges to make this type of financial change.+  * Best Practice: ​ Restrict who has privileges to make this type of financial change.
   
- 
integrity/report_discrepancies.1584029142.txt.gz · Last modified: 2020/03/12 09:05 by kevin